select c.coll_id, c.title, count(t.title_id) as cnttitle from collections c, titles t where c.coll_id = t.coll_id group by c.coll_id, c.title order by title

Resources in ArchSearch

Below is a list of all the collections available within the ADS Catalogue: ArchSearch

The collections fall into roughly two different categories:


#title# [Description]
#cnttitle# records in ArchSearch select title_id from titles where coll_id = #coll_id# select unique type.type, source.title, source.url_text from type, source where source.title_id = #titles.title_id# and source.title_id = type.title_id and source.title like '%ads.ahds.ac.uk%'
#type# - #url_text#

Society of Antiquaries of London library
Go to library catalogue