Sorry, there are no results at this time. select distinct left(title,1) as initial, title, description, location, access_restrictions, title.title_id as this_record, display_note, pre, citation_guide, ctags, format FROM title, restrictions, location, location_title, source, rank WHERE title.title_id = '20' AND title.title_id = location_title.title_id AND location.location_id = location_title.location_id AND restrictions_id = access_restrictions AND rank.title_id = title.title_id AND source.source_id = rank.source_id ORDER BY title