search

COLLECTION: 0 
SELECT  distinct  i.collection_label, i.label as title, i.year,i.place, i.archive_date, i.item_id, i.collection, i.dt_create, i.bibref, i.thumb, i.thumb1, i.thumb2, i.obj_type, i.issue_aggr, i.pages, i.issue_cnt, i.weight, i.folder, i.status, i.uuid, i.lang, i.user_create, i.user_update, i.dt_update, i.dt_create, i.folders FROM  dsd.item2 i  WHERE  status = 'finish' AND in_archive  AND (site = 1 OR site = 0)  ORDER by   i.dt_create desc, i.label  limit 20  offset ? 
===============================================
SELECT count(*)  FROM dsd.item2 i  WHERE  status = 'finish' AND in_archive  AND (site = 1 OR site = 0) 
Browse