SELECT sites.siteid,sites.rooms,sites.title, sites.picture, sites.siteid, sites.phone, sites.siteAltPic, sites.siteTitlePic, sites.accessories, sites.home_line, sites.home_line_show, sites.home_line2, sites.home_line2_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`,
cities.title as `cityTitle`, sites.area
FROM sites
INNER JOIN cities ON (sites.city = cities.id)
INNER JOIN areas ON(cities.areasMain = areas.id)
INNER JOIN superareas ON (superareas.id = areas.superareas)
LEFT JOIN areas ON (`areas`.id=`cities`.areasMain) LEFT JOIN superareas ON (`superareas`.id=`areas`.superareas)
INNER JOIN pirsumim ON(sites.siteid = pirsumim.siteID AND pirsumType=5 AND PortalID=1)
WHERE ( sites.picture!='') AND sites.siteType=1 AND sites.ifShow=1 AND 1=1 AND superareas.id=4 AND areas.id=20 AND 1=1
ORDER BY RAND()
LIMIT 16
1: class.udb.php:234 udb::query()
2: inc_search.php:247 udb::key_row()
3: index.php:405 include()