- Yorkshire Dales
SELECT DISTINCT t.`name` FROM `town` t, `district` d, `town_district` td, `website_town` wt WHERE t.`id`=td.`town` AND td.`district` = d.`id` AND d.`town` = '67' AND wt.`website`='1' AND wt.`town`=t.`id` AND wt.`visible`='1' ORDER BY t.`name`;
- North York Moors
SELECT DISTINCT t.`name` FROM `town` t, `district` d, `town_district` td, `website_town` wt WHERE t.`id`=td.`town` AND td.`district` = d.`id` AND d.`town` = '38' AND wt.`website`='1' AND wt.`town`=t.`id` AND wt.`visible`='1' ORDER BY t.`name`;
- The Wolds
SELECT DISTINCT t.`name` FROM `town` t, `district` d, `town_district` td, `website_town` wt WHERE t.`id`=td.`town` AND td.`district` = d.`id` AND d.`town` = '59' AND wt.`website`='1' AND wt.`town`=t.`id` AND wt.`visible`='1' ORDER BY t.`name`;
- Yorkshire Coast
- North Yorkshire
SELECT DISTINCT t.`name` FROM `town` t, `district` d, `town_district` td, `website_town` wt WHERE t.`id`=td.`town` AND td.`district` = d.`id` AND d.`town` = '39' AND wt.`website`='1' AND wt.`town`=t.`id` AND wt.`visible`='1' ORDER BY t.`name`;
- East Yorkshire
SELECT DISTINCT t.`name` FROM `town` t, `district` d, `town_district` td, `website_town` wt WHERE t.`id`=td.`town` AND td.`district` = d.`id` AND d.`town` = '12' AND wt.`website`='1' AND wt.`town`=t.`id` AND wt.`visible`='1' ORDER BY t.`name`;
- South Yorkshire
SELECT DISTINCT t.`name` FROM `town` t, `district` d, `town_district` td, `website_town` wt WHERE t.`id`=td.`town` AND td.`district` = d.`id` AND d.`town` = '57' AND wt.`website`='1' AND wt.`town`=t.`id` AND wt.`visible`='1' ORDER BY t.`name`;
- West Yorkshire
SELECT DISTINCT t.`name` FROM `town` t, `district` d, `town_district` td, `website_town` wt WHERE t.`id`=td.`town` AND td.`district` = d.`id` AND d.`town` = '62' AND wt.`website`='1' AND wt.`town`=t.`id` AND wt.`visible`='1' ORDER BY t.`name`;