Self Catering in Skipton

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`;
```
- Bedale
- Malton
- Scarborough
- Filey
- Masham
- Sedbergh
- Goathland
- Middleham
- Selby
- Grassington
- Northallerton
- Settle
- Harrogate
- Pateley Bridge
- Skipton
- Hawes
- Pickering
- Staithes
- Helmsley
- Piercebridge
- Thirsk
- Ingleton
- Richmond
- Thornton le Dale
- Kirkbymoorside
- Ripon
- Whitby
- Leyburn
- Robin Hood's Bay
- York
- Malham
- Runswick Bay

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`;