Notice: Undefined offset: 0 in /var/www/vhosts/sandyblue.com/httpdocs/includes/_sys_search.php on line 911
Could not select GET_REC_NUM: 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 'GROUP BY acc.ID, ofrz.ID, lstmnz.ID ' at line 55 SQL USED: SELECT DISTINCT acc.ID AS rec_id##ALLFLDZ## FROM sbcomdb.Accommodation AS acc LEFT JOIN sbcomdb.Resorts AS rsrt ON (rsrt.ID = acc.ResortID) INNER JOIN sbcomdb.taxonomy AS prop_typ ON (prop_typ.tax_typ='prop_typ' AND prop_typ.id=acc.prop_typ) INNER JOIN sbcomdb.prop_lox AS loc_0 ON (loc_0.id = acc.prop_location) INNER JOIN sbcomdb.prop_lox AS loc_1 ON (loc_1.id = loc_0.parent_id) LEFT JOIN sbcomdb.prop_lox AS loc_2 ON (loc_2.id = loc_1.parent_id) LEFT JOIN ( SELECT ID, AssocID, Discount, #GROUP_CONCAT(DATE_FORMAT(av_deals.ArrDate,'%M'),'-', DATE_FORMAT(av_deals.DepDate,'%M'),'-',CAST(av_deals.Discount AS CHAR) ORDER BY av_deals.ID ASC SEPARATOR '#') AS offers, GROUP_CONCAT(DATE_FORMAT(av_deals.ArrDate,'%Y-%m-%d'),':', DATE_FORMAT(av_deals.DepDate,'%Y-%m-%d'),':',CAST(av_deals.Discount AS CHAR) ORDER BY av_deals.ID ASC SEPARATOR '#') AS offers, COUNT(DISTINCT av_deals.ID) AS offer_count FROM sbcomdb.av_deals AS av_deals GROUP BY av_deals.AssocID ) AS ofrz ON ofrz.AssocID = acc.ID LEFT JOIN #LSTMINZ 0 ( SELECT ID, AssocID, Discount, #GROUP_CONCAT(DATE_FORMAT(av_lastminute.ArrDate,'%M'),'-', DATE_FORMAT(av_lastminute.DepDate,'%M'),'-',CAST(av_lastminute.Discount AS CHAR) ORDER BY av_lastminute.ID ASC SEPARATOR '#') AS lastminute, GROUP_CONCAT(DATE_FORMAT(av_lastminute.ArrDate,'%Y-%m-%d'),':', DATE_FORMAT(av_lastminute.DepDate,'%Y-%m-%d'),':',CAST(av_lastminute.Discount AS CHAR) ORDER BY av_lastminute.ID ASC SEPARATOR '#') AS lastminute, COUNT(DISTINCT av_lastminute.ID) AS lastminute_count FROM sbcomdb.av_lastminute AS av_lastminute GROUP BY av_lastminute.AssocID ) AS lstmnz ON lstmnz.AssocID = acc.ID WHERE #0 acc.Deleted=0 AND acc.Archived=0 AND acc.ShowOnSite = 1 AND acc.IsPrivate = 0 AND acc.ResortID = GROUP BY acc.ID, ofrz.ID, lstmnz.ID ORDER BY #0 rec_id=0 DESC, acc.OrdNum_InParent ASC #0 \n\n