SELECT
p.*,
f.id as format_id,
c.id as collection_id
FROM
photographs p
LEFT JOIN
formats f
ON f.id = p.format_id
LEFT JOIN
sizes s
ON s.id = p.size_id
LEFT JOIN
collections c
ON c.id = p.collection_id
LEFT JOIN
users u
ON u.id = p.scanning_technician
WHERE
p.call_number IS NOT NULL
AND p.date_removed IS NULL
AND p.call_number like ('%E-0012-187%') AND (collection_id = 2)
ORDER BY
p.call_number asc
LIMIT
1000
Search |
Special Collections General Photograph Collection