SELECT cit.citation_id, citation_reference, title, subtitle, contributor, item_locator, content_link, src_identifier, src_notes, count(*) , max(content_link) content_link, max(fulltext_link) fulltext_link , max(file_link) file_link FROM gc_collections col ,gc_citations cit ,gc_holdings hld WHERE 1=1 AND hld.collection_id = col.collection_id AND hld.citation_id = cit.citation_id AND cit.content_type = 'Ginans' AND collection_status = 'active' AND citation_status = 'active' AND item_status = 'active' AND src_identifier = 10 AND gc_category = 'Archive' AND ginans_link <> '' GROUP BY cit.citation_id ORDER BY citation_reference
|
|