North Walsham, Norfolk photos from the-nineteenth-century
SELECT archive.archive_id, MAX(archive.archive_filename2) AS archive_filename2, MAX(archive.archive_title) AS archive_title, MAX(archive.archive_label) AS archive_label, MAX(archive.archive_text) AS archive_text, MAX(archive.archive_url) AS archive_url, MAX(hotspots.hotspot_id) AS hotspot_id FROM archive LEFT JOIN hotspots ON hotspots.hotspot_parent = archive.archive_id WHERE archive_status = 2 AND archive_page = 173 AND (the-nineteenth-century >= YEAR(archive.archive_date_from) AND the-nineteenth-century <= YEAR(archive.archive_date_to)) GROUP BY archive.archive_id ORDER BY archive_index LIMIT 0, 40Unknown column 'the' in 'where clause'