| Query / Запрос |
SELECT
SQL_CALC_FOUND_ROWS
tbl.*,
IF( tbl.vid = 1, 'продажа', 'покупка' ) rub_name,
geo.name geo_name,
im.name logo,
im.techinfo
FROM ent_sales tbl
LEFT JOIN geo geo
ON tbl.geo = geo.id
LEFT JOIN ent_images im
ON tbl.id = im.model_id
AND im.model = 'ent_sales'
WHERE
tbl.hide = 0
AND tbl.ent_id = 1699
AND tbl.datestop >= UNIX_TIMESTAMP()
GROUP BY tbl.id
ORDER BY
tbl.vid DESC,
tbl.id DESC limit 0,15 |