CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT COUNT(*) AS total, o.id AS id FROM _objects AS o LEFT JOIN _images AS i ON i.object_id = o.id WHERE build_category = 'APARTMENT' AND square >= 10 AND square <= 1000 AND price >= 10000 AND price <= 20000000 GROUP BY o.id