the city guide to hotel, lodge and guest house / bed and breakfast accommodation in and around Londonderry

The City Guide to hotels, lodges and guesthouses in and around Londonderry

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PropertyType = 'l' ORDER BY (ISNULL(description) OR (description = '')), paf DES' at line 1

SELECT CompanyName,CompanyCode,Address1,Address2,Town,County,PostCode,Telephoneno,Faxno,PropertyType,Stars,Diamonds, Bedrooms,roomsinglerate,roomdoublerate,Golfcourse,Indoorpool,Outdoorpool,Tenniscourts,Gymnasium,Disabled, Amex,AccMaster,Barclvisa,Diners,JCB,switch,delta,Description, handbooktown, paf, SQRT(POW((0-coordx),2)+POW((0-coordy),2)) AS distance, FourposterBed FROM abcbusiness WHERE (webtown = 'Londonderry') AND PropertyType IN ('H','T','G','L' ,'R', 'Z') PropertyType = 'l' ORDER BY (ISNULL(description) OR (description = '')), paf DESC, distance