- 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 (150) 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 8440 5111
Tel: 020 7915 1048 / 020 8915 1000
Tel: 020 7405 9200
Tel: 020 7955 5000
Tel: 01895 823 737
Tel: 020 8510 5555
Tel: 020 7780 2400
Tel: 276 1234
Tel: 020 7253 3411
Tel: 795 4567
Tel: 020 8887 2000
Tel: 787 7700
Tel: 020 7794 0500
Tel: 020 7377 7000
Tel: 794 4696
Tel: 789 7373
Tel: 226 0112
Tel: 020 7725 6666
Tel: 276 1234
Tel: 020 7725 1465
Tel: 020 8442 6000
Tel: 020 7601 8888
Tel: 020 7806 4000
Tel: 020 8457 4560
Tel: 020 7935 4444
Tel: 020 7837 3611
Tel: 020 7580 4400
Tel: 020 7837 8855
Tel: 020 7387 9300
Tel: 020 7387 9300
Tel: 020 7586 5959
Tel: 020 7272 3070
Health & Beauty > Hospitals
There are 35 listings in Health & Beauty > Hospitals
Alexandra Hospital
Barnet General
Tel: 020 8440 5111
Eastman's Dental
Tel: 020 7915 1048 / 020 8915 1000
Great Ormond Street Children's Hospital
Tel: 020 7405 9200
Guy's
Tel: 020 7955 5000
Harefield Hostpital
Tel: 01895 823 737
Homerton
Tel: 020 8510 5555
London Independent
Tel: 020 7780 2400
Machester Royal Infirmary
Tel: 276 1234
Moorfield's eye
Tel: 020 7253 3411
North Manchester General Hospital (crumpsall)
Tel: 795 4567
North Middlesex
Tel: 020 8887 2000
Oaklands Hospital
Tel: 787 7700
Royal Free
Tel: 020 7794 0500
Royal London
Tel: 020 7377 7000
Royal M/cr Chidren's Hospital
Tel: 794 4696
Salford Royal Hospital (hope)
Tel: 789 7373
Spire (private)
Tel: 226 0112
Spire Private Hospital (formerly Bupa)
St Mary's
Tel: 020 7725 6666
St Mary's Hospital
Tel: 276 1234
St Mary's Lindo wing
Tel: 020 7725 1465
St. Ann's
Tel: 020 8442 6000
St. Bartholomew's
Tel: 020 7601 8888
St. John & St Elizabeth
Tel: 020 7806 4000
The Garden
Tel: 020 8457 4560
The London Clinic
Tel: 020 7935 4444
The National Neurology
Tel: 020 7837 3611
The Portland
Tel: 020 7580 4400
The Royal National E.X.T.
Tel: 020 7837 8855
University College
Tel: 020 7387 9300
University College A & E
Tel: 020 7387 9300
Wellington
Tel: 020 7586 5959
Whittington
Tel: 020 7272 3070