Could not complete query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-10, 10' at line 20
Query: 
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