SELECT *, `rtr_properties`.`id` AS `id` FROM `rtr_properties` LEFT JOIN `rtr_photos` ON (`rtr_properties`.`id` = `rtr_photos`.`property_id` AND `rtr_photos`.`id` = '2') LEFT JOIN ( SELECT `property_id`, `min`, `max` FROM ( SELECT `rtr_rates`.`property_id`, MIN(`rtr_rates`.`Rate`) AS `min` FROM `rtr_rates` GROUP BY `property_id` ) `min_rates` JOIN ( SELECT `rtr_rates`.`property_id`, MAX(`rtr_rates`.`Rate`) AS `max` FROM `rtr_rates` GROUP BY `property_id` ) `max_rates` USING (`property_id`) ) `rates` ON `rtr_properties`.`id` = `rates`.`property_id` WHERE (`streetcode` = 'Bethany') ORDER BY `street` ASC LIMIT -10, 10