class.udb.php:127 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 ')
ORDER BY RAND()
LIMIT 0,24' at line 9
SELECT sitesPriceCache.*, deals.dealID, sites.TITLE, sites.arem, sites.clubGift, sites.clubType, sites.settlementID, sites.prPicture, sites.prPictureFirst, sites.lineDesc, sites.couples
, sitesSpecials.daysInWeek, sitesSpecials.dealTo, sitesSpecials.limitations, sites_text.TITLE as `LangTitle`, `sites_text`.arem as `LangDesc`, sites_text.LangID, sites_text.PortalID
FROM `sites` INNER JOIN `deals` USING(`siteID`) INNER JOIN dealsPortals USING(`dealID`)
INNER JOIN `sitesPriceCache` ON (sites.siteID = sitesPriceCache.siteID)
LEFT JOIN `sitesSpecials` ON (sitesSpecials.specID = sitesPriceCache.specID)
LEFT JOIN `sites_text` ON (sites_text.siteID = sites.siteID AND sites_text.LangID=1 AND sites_text.PortalID=4)
WHERE sites.if_show = 1 AND sitesPriceCache.cacheType = 2 AND deals.dealVisible = 1 AND deals.dealType = 1 AND dealsPortals.portalID = 1
AND ('2021-09-29' BETWEEN dealsPortals.fromDate AND dealsPortals.toDate) AND sites.siteID NOT IN ()
ORDER BY RAND()
LIMIT 0,24
1: class.udb.php:234 udb::query()
2: ajax_index.php:19 udb::key_row()