תודה על פנייתך
בעל הצימר יחזור אליך בהקדם
רוצים לחסוך זמן בחיפוש צימר?
תנו לנו למצוא לכם את הצימר בקלות ובמהירות.
השאירו פרטים ואנו נחזור אליכם עם צימרים איכותיים לחופשה הבאה שלכם.
נופש לתאריך
הרכב הנופש
מבוגרים
ילדים
תינוקות
קוד אימות
secure
אנחנו נפנה אלייך צימרים במבצע לתאריכים שבחרתם
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 ('2019-03-19' 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 (566,571,168,266,331,359,411,484,493,499,528,544,547,564,559,204,213,415,561,211,214,302,313,410,480,23,80,210,212,413,479,467,455,300,461,545,546,468,541,243,367,271,14,39,120,472,508,532,460,202,76,321,360,477,371,422,459,37,380,124,565,16,36,114,162,270,305,439,463,470,498,514,557,56,525,548,92,123,347,452,489,550,552,560,562,287,330,63,443,158,403,110,453,261,203,311,42,117,351,24,518,567,64,73,78,111,116,118,121,160,163,172,245,334,457,488,507,509,523,526,540,323,358,449,513,74,84,88,365,462,510,58,70,164,372,391,423,458,506,511,543,530,89,165,431,15,53,108,176,54,194,81,125,322,325,520,119,77,327,17,435,483,535,75,227,338,456,128,396,409,491,568,217,234,109,60,86,98,293,333,337,370,450,464,82,318,375,497,166,471,90,324,438,542,32,218,310,363,426,516,7,85,354,519,20,104,503,101,112,134,231,308,316,326,414,79,87,233,250,301,551,97,95,340,344,374,369,434,539,196,25,52,94,141,193,241,348,373,466,537,113,129,135,169,440,454,69,115,314,563,555,106,522,30,44,190,22,569,171,21,10,556,529,451,481,531,96,465,18,33,161,216,312,343,368,437,495,521,131,361,429,538,262,307,50,91,264,405,209,68,309,239,490,428,19,482,442,55,137,317,67,199,273,501,28,127,267,527,13,229,205,206,173,29,61,138,48,268,12,31,72,524,62,256,486,47,49,238,336,139,263,328,427,536,207,416,353,402,35,144,142,235,148,342,208,45,197,240,66,355,420,432,534,51,295,100,362,155,103,424,102,191,147,174,26,57,553,156,320,494,570,46,149,554,183,179,178,180,181,418,185,515,304,517,306,195,146,492,192,188,332,549,184)
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:487 include()