class.udb.php:201 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 Deals.Deal_type_ID = 5 AND Deals.Active = 1 AND CURDATE() BETWEEN Deals.star' at line 6
SELECT Deals.fileName, sites.TITLE AS TITLE, sites.siteID, settlements.TITLE as `settName`, sites.enableOutLinks, sites.link_type, IF(Deals.extLink, Deals.extLink, sites.link) as `link`
FROM `Deals` INNER JOIN `sites` USING(`siteID`) INNER JOIN `settlements` USING(`settlementID`) LEFT JOIN `sitesTypes` ON (`sites`.`siteID` = `sitesTypes`.`siteID`)
INNER JOIN `sitesOptions` ON (sites.siteID = sitesOptions.siteID)
WHERE sites.if_show = 1 AND sitesTypes.typeID = AND Deals.Deal_type_ID = 5 AND Deals.Active = 1 AND CURDATE() BETWEEN Deals.startDate AND Deals.endDate AND Deals.location = 0
AND sitesOptions.optionID IN (153)
ORDER BY Deals.upTime DESC, RAND()
LIMIT 0,8
1: gtest2.php:103 udb::query()