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 ')
LEFT JOIN sitesCancel ON(sites.siteID = sitesCancel.siteID)
WHERE sites' at line 11


SELECT `tmp`.*, sites_text.owners as `LangOwners`, sites_text.TITLE as `LangTitle`, sites_text.arem as `LangDesc`
FROM
(
SELECT sites.siteID, sites.TITLE, sites.arem, sites.onlineOrders, sites.onlineOrdersLangs, sites.prPicture,sites.prPictureFirst, sites.lineDesc, sites.phone2, sites.owners, sites.couples, sites.freeInWeekend, sites.clubGift, sites.clubType
,sites.typeStructure,main_areas.TITLE as `mname`, settlements.TITLE as `sname`, areas.TITLE as `aname`, areas.areaID, SUM(sitesRooms.roomCount) as `roomCount`, sitesCancel.from_order, sitesCancel.to_order , IF(sitesJumps.active, sitesJumps.time, 0) as `jumper`, IF(sitesJumps.free, 1, 0) as `freeFriday`
FROM `sites` INNER JOIN `settlements` USING(`settlementID`) INNER JOIN `areas` USING(`areaID`) INNER JOIN `main_areas` ON(areas.`main_areaID` = main_areas.main_areaID)
INNER JOIN `sites_text` ON (sites_text.siteID = sites.siteID AND sites_text.LangID=1 AND sites_text.PortalID=5 AND sites_text.if_show=1)
INNER JOIN `sitesRooms` ON (sites.siteID = sitesRooms.siteID)
INNER JOIN `deals` ON (deals.`siteID` = sites.`siteID` AND deals.dealType = 0 )
INNER JOIN dealsPortals ON(dealsPortals.`dealID` = deals.`dealID` AND dealsPortals.portalID = 5 AND ('2021-04-22' BETWEEN dealsPortals.fromDate AND dealsPortals.toDate))
LEFT JOIN sitesJumps ON (sites.siteID = sitesJumps.siteID AND period=)
LEFT JOIN sitesCancel ON(sites.siteID = sitesCancel.siteID)
WHERE sitesRooms.ifShow=1 AND sites.siteID IN (581,32,211,214,302,313,331,352,411,480,528,544,547,564,80,210,212,415,266,359,410,484,559,561,23,168,213,358,413,493,499,595,479,300,541,460,467,604,508,461,245,321,452,498,532,455,347,560,562,632,123,270,483,630,76,84,380,575,617,164,327,121,334,489,118,477,550,552,462,124,610,409,311,582,449,457,472,491,488,261,305,360,456,571,74,574,16,114,120,172,324,330,337,526,543,546,606,87,125,326,325,365,464,545,548,623,14,323,423,458,572,107,20,363,614,119,333,414,542,250,316,465,176,218,308,506,79,391,516,593,628,53,587,117,194,202,203,231,314,451,469,468,470,513,565,644,113,322,431,523,556,56,78,88,92,293,370,406,602,21,39,90,453,450,535,551,158,518,33,60,68,109,160,162,375,426,540,42,110,166,471,318,563,645,17,63,434,539,607,636,646,37,58,77,98,112,216,338,343,622,190,89,444,591,638,7,25,111,115,374,85,598,605,611,196,15,459,577,522,629,264,579,256,520,639,652,94,135,169,336,348,396,510,555,578,585,54,171,263,243,405,531,613,131,199,609,625,454,64,301,361,507,227,18,173,354,481,104,137,161,197,443,620,239,307,317,368,310,651,234,241,340,538,497,612,624,643,36,45,49,83,193,427,501,521,530,634,647,649,22,139,217,490,69,96,208,342,482,527,641,52,312,355,373,495,238,309,144,50,91,95,19,503,618,262,437,428,416,524,67,102,30,295,536,534,26,71,267,590,66,442,12,148,240,570,635,97,209,627,51,207,62,29,140,61,100,103,147,353,517,31,362,13,127,138,402,35,48,156,616,155,486,432,205,57,615,566,596,420,235,553,206,149,320,640,494,554,418,626,648,183,181,179,284,180,584,304,390,515,594,185,204,178,306,273,191,195,146,192,492,332,184,188)
GROUP BY sites.siteID

ORDER BY `jumper` DESC, RAND()
) as `tmp` LEFT JOIN `sites_text` ON (sites_text.siteID = tmp.siteID AND sites_text.LangID=1 AND sites_text.PortalID=5)
WHERE 1
GROUP BY `tmp`.siteID
ORDER BY `jumper` DESC, RAND()
1: class.udb.php:183 udb::query()
2: inc_search.php:204 udb::full_list()
3: index.php:489 include()