CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT `o`.*, MIN(`a`.`price`) AS 'pmin', MAX(`a`.`price`) AS 'pmax', MIN(`a`.`area`) AS 'amin', MAX(`a`.`area`) AS `amax`
- FROM `objects` o
- LEFT JOIN `apartments` a ON `a`.`object_id`=`o`.`id`
- WHERE `o`.`obj_type`=3 ORDER BY `o`.`object_id` LIMIT 2