אלמאגו רוף תל אביב

class.udb.php:184 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 10' at line 14

SELECT sites.*,promotedDomains.active as promoted,sites_domains.hideContactMethods,settlements.lat_y,settlements.lon_x,sites_langs.siteName as siteLangName, sites_langs.reviewLocation, sites_langs.owners, IF(sites.exBits & 1 OR (sites.externalEngine > '' AND sites.externalID > ''), 0, 1) AS `noDates`,
sites_domains.avgScore, sites_domains.forCouples, sites_domains.ServiceLevelAgreement, sites_domains.checkedDate, sites_domains.checkedBy,
sites_domains.maskyooPhone, sites_domains.phone,
sites_domains.hostPhrase as hostPhraseDomain,
areas.TITLE as areaName,settlements.TITLE as cityName, main_areas.TITLE as mainAreaName,`promotedsearchDomains`.active as promotS
FROM `sites` INNER JOIN `sites_domains` ON (sites.siteID = sites_domains.siteID AND sites_domains.domainID = 109)
INNER JOIN `sites_langs` ON (sites.siteID = sites_langs.siteID AND sites_langs.domainID = 109 AND sites_langs.langID = 1)
LEFT JOIN `settlements` ON (sites.`settlementID` = settlements.settlementID)
LEFT JOIN `areas` ON (areas.areaID = settlements.areaID)
LEFT JOIN `main_areas` ON (areas.main_areaID = main_areas.main_areaID)
LEFT JOIN `promotedsearchDomains` ON (promotedsearchDomains.siteID = sites.siteID and promotedsearchDomains.domainID = 109 )
left join promotedDomains on (promotedDomains.siteID=sites_domains.siteID and promotedDomains.domainID=109 and promotedDomains.active=1)
WHERE sites.siteID!=1334 and sites_domains.active = 1 AND
sites.siteID IN (70,135,235,260,289,342,346,374,461,472,797,867,909,914,917,921,922,938,951,972,973,974,1000,1057,1070,1085,1102,1161,1171,1182,1196,1205,1213,1267,1331,1334,1415,1464,1530,1574,1579,1590,1619,1629,1676,1698,1700,1701,1801,1863,1886) ORDER BY LIMIT 10
1: class.udb.php:374 udb::query()
2: class.InSearch.php:556 udb::key_row()
3: footer.php:13 InSearch::fullSitesResults()
4: index.php:387 include()