Warning: implode(): Invalid arguments passed in /home/v4ucssd/public_html/js_ajax_res.php on line 84
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 'AND sites.siteID NOT IN(0)
GROUP BY sites.siteid
ORDER BY f' at line 10

SELECT `tmp`.* FROM (SELECT sites.siteType, sites.accessories, sites_text.title, sites_text.picture, sites_text.siteid,sites.rooms, sites_text.address, sites_text.phone, sites_text.siteAltPic, sites_text.siteTitlePic,sites.home_line, sites.home_line_show,
sites.title as `dk90_title`, sites.picture as `dk90_picture`, sites.phone as `dk90_phone`, sites.siteAltPic as `dk90_siteAltPic`, sites.siteTitlePic as `dk90_siteTitlePic`,
city, currency, sites.area,cities.title as `cityTitle`, datesCal.free, datesCal.date, posted
FROM sites
INNER JOIN sites_text ON(sites.siteid = sites_text.siteid AND sites_text.PortalID=2 AND sites_text.LangID=1 AND sites_text.ifShow=1)
INNER JOIN cities ON (sites.city = cities.id)

LEFT JOIN datesCal ON(sites_text.siteid = datesCal.siteID AND datesCal.date='')
LEFT JOIN turbo_new ON (sites.siteid = turbo_new.siteID AND turbo_new.posted=1)
WHERE AND sites.siteID NOT IN(0)
GROUP BY sites.siteid
ORDER BY free DESC , RAND()

) as `tmp`
LEFT JOIN packages ON(packages.siteID = tmp.siteid)
LEFT JOIN packages_periods as `p` ON(p.packageID = packages.packageID AND p.active=1 AND p.periodID='-1' )
GROUP BY tmp.siteid
ORDER BY posted DESC, free DESC
LIMIT 0,24
1: class.udb.php:183 udb::query()
2: js_ajax_res.php:94 udb::full_list()