- Home
- View Directory
- Advertising
- Pick of the Week
- Competitions
- December 2014/January 2015
- May/June 2014
- April/May 2014
- February/March 2014
- December 13/January 14
- October/November 2013
- August/September 2013
- June/July 2013
- March 2013
- February 2013
- January 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- Health & More
- Useful Info
- Sign up
- Contact Us
Expression #1 of ORDER BY clause is not in SELECT list, references column 'kosherp_main.Advert.Type of Advert' which is not in SELECT list; this is incompatible with DISTINCT(3065) executing query: SELECT DISTINCT `Category`.`ID`,`Category`.`Name` FROM `Category` JOIN `Advert Category` ON `Advert Category`.`Category`=`Category`.`ID` JOIN `Advert` ON `Advert`.`ID`=`Advert Category`.`Advert` JOIN `Advert Modification` ON `Advert Modification`.`Advert`=`Advert`.`ID` JOIN `Advert City` ON `Advert`.`ID`=`Advert City`.`AdvertID` WHERE `Category`.`Parent` IN (87) AND `Advert Modification`.`Authoriser`<>0 AND `Advert Modification`.`Rejected`='0' AND `Advert`.`Cancellor`=0 AND `Advert Modification`.`NoShow`='0' ORDER BY `Advert`.`Type of Advert` DESC, `Advert Modification`.`Name` ASC
Tel: 020 7416 5000
Recreation & Travel > Tourist Attractions
There are 22 listings in Recreation & Travel > Tourist Attractions
Alton Towers
Blackpool Sea Life Centre
Blackpool Zoo
Blue Planet Aquarium
Chester Zoo
East Lancashire Railway
Eureka! The Museum for Children
HMS Belfast
Imperial War Museum
Tel: 020 7416 5000