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 'AND bnbrates.active = 'TRUE' AND CASE WHEN options.special_offers = 'false' TH' at line 47
[SELECT bnbrates.id, bnbrates.ratetype, case when 0 != 0 and length(bnbrates.caption) > 43 then concat(substring(bnbrates.caption, 1, 40), '...') else bnbrates.caption end as caption, bnbrates.caption as fullcaption, bnbrates.description, CASE WHEN pax = 'per room' THEN 1 WHEN rooms.sleeps IS NOT NULL THEN rooms.sleeps ELSE 2 END AS paxmultiplier, replace(bnbrates.pax, ' ', '
') as pax, bnbrates.period, bnbrates.nights as numnights, case when bnbrates.nights <= 0 or bnbrates.nights = 1 then 'per night' else concat(bnbrates.nights, ' nights') end as nights, bnbrates.rooms, bnbrates.startdate, bnbrates.enddate, bnbrates.price, CASE WHEN bnbrates.ratetype != 'standard' THEN '•' ELSE '' END AS offer, CASE WHEN rooms.type IS NULL THEN bnbrates.roomtype ELSE rooms.type END AS roomtype, CASE WHEN rooms.totalrooms IS NULL THEN 3 ELSE rooms.totalrooms END AS totalrooms, CASE WHEN '' = '' THEN date_format(current_date, '%D %M, %Y') WHEN month(date('')) = month(date('')) THEN concat(date_format(date(''), '%D - '), date_format(date(''), '%D %M, %Y')) WHEN year(date('')) = year(date('')) THEN concat(date_format(date(''), '%D %M - '), date_format(date(''), '%D %M, %Y')) ELSE concat(date_format(date(''), '%D %M, %Y'), ' - ', date_format(date(''), '%D %M, %Y')) END AS dates, CASE WHEN month(startdate) = month(enddate) THEN concat(date_format(startdate, '%D - '), date_format(enddate, '%D %M, %Y')) WHEN year(startdate) = year(enddate) THEN concat(date_format(startdate, '%D %M - '), date_format(enddate, '%D %M, %Y')) ELSE concat(date_format(startdate, '%D %M, %Y'), ' - ', date_format(enddate, '%D %M, %Y')) END AS offerdates, CASE WHEN month(startdate) = month(enddate) THEN concat(date_format(startdate, '%e - '), date_format(enddate, '%e %b')) WHEN year(startdate) = year(enddate) THEN concat(date_format(startdate, '%e %b - '), date_format(enddate, '%e %b')) ELSE concat(date_format(startdate, '%e %b'), ' - ', date_format(enddate, '%e %b')) END AS shortdates, CASE WHEN month(startdate) = month(enddate) THEN concat(date_format(startdate, '%e-'), date_format(enddate, '%e %b')) WHEN year(startdate) = year(enddate) THEN concat(date_format(startdate, '%e %b-'), date_format(enddate, '%e %b')) ELSE concat(date_format(startdate, '%e %b'), '-', date_format(enddate, '%e %b')) END AS extrashortdates FROM bnbrates LEFT OUTER JOIN rooms ON (rooms.id = bnbrates.roomtype OR (rooms.type = bnbrates.roomtype AND rooms.bnb_ref = bnbrates.bnb_ref)) LEFT OUTER JOIN options ON options.bnb_ref = bnbrates.bnb_ref WHERE bnbrates.bnb_ref = AND bnbrates.active = 'TRUE' AND CASE WHEN options.special_offers = 'false' THEN ratetype != 'specialoffer' ELSE 1 END AND CASE WHEN options.last_minute = 'false' THEN ratetype != 'lastminute' ELSE 1 END AND CASE WHEN ratetype = 'lastminute' THEN enddate <= date_add(current_date, interval 15 day) ELSE enddate >= current_date END AND bnbrates.rooms != 0 AND (@nights := IF('' != '', '', 0)) IS NOT NULL AND (@arrival := IF('' = '', current_date, DATE(''))) IS NOT NULL AND (@departure := IF('' = '', 0, DATE(''))) IS NOT NULL AND @arrival < enddate AND CASE WHEN @departure != 0 THEN @departure > startdate ELSE 1 END AND CASE WHEN @nights > 0 THEN @nights >= bnbrates.nights AND @nights % bnbrates.nights = 0 ELSE bnbrates.nights > 0 END AND CASE WHEN @nights > 0 THEN CASE WHEN bnbrates.period = 'weekend' THEN @nights <= 2 AND dayofweek(@arrival) >= 6 AND dayofweek(@departure) <= 7 WHEN bnbrates.period = 'midweek' THEN @nights <= 4 AND dayofweek(@arrival) >= 1 AND dayofweek(@departure) <= 6 WHEN bnbrates.period = 'bankholiday' THEN @nights <= 3 AND dayofweek(@arrival) >= 6 AND (dayofweek(@departure) <= 7 OR dayofweek(@departure) = 1) WHEN bnbrates.period = 'sunday' THEN @nights = 1 AND dayofweek(@arrival) = 1 AND dayofweek(@departure) = 2 ELSE @arrival < @departure END ELSE 1 = 1 END ORDER BY bnbrates.enddate, bnbrates.roomtype, bnbrates.startdate, bnbrates.price]

There are currently no rates available for the dates selected. Please send us an Email Enquiry.				Rates			Total	Rooms
There are currently no offer listed. Please send us an Email Enquiry

€ 00.00 Total