Could not complete query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 10' at line 54
Query:
SELECT *, `rtr2_properties`.`id` AS `id` FROM `rtr2_properties`
LEFT JOIN `rtr2_photos` ON (`rtr2_properties`.`id` = `rtr2_photos`.`property_id` AND `rtr2_photos`.`id` = '2')
LEFT JOIN (
SELECT `rtr2_property_amenities`.`property_id`, `value` AS `pets` 
    FROM `rtr2_property_amenities`
    WHERE `rtr2_property_amenities`.`amenity_id` = 1460
    ) `pets`
ON `rtr2_properties`.`id` = `pets`.`property_id`
LEFT JOIN (
SELECT `id`, 1 AS `pool`
FROM `rtr2_properties`
LEFT JOIN (
    SELECT `rtr2_property_amenities`.`property_id`, `value` AS `private`
    FROM `rtr2_property_amenities`
    WHERE `rtr2_property_amenities`.`amenity_id` = 1010
    ) `pool1`
ON `id` = `pool1`.`property_id`
LEFT JOIN (
    SELECT `rtr2_property_amenities`.`property_id`, `value` AS `community`
    FROM `rtr2_property_amenities`
    WHERE `rtr2_property_amenities`.`amenity_id` = 1011
    ) `pool2`
ON `id` = `pool2`.`property_id`
LEFT JOIN (
    SELECT `rtr2_property_amenities`.`property_id`, `value` AS `outdoor`
    FROM `rtr2_property_amenities`
    WHERE `rtr2_property_amenities`.`amenity_id` = 1015
    ) `pool3`
ON `id` = `pool3`.`property_id`
WHERE `private` = 1
  OR `community` = 1 
  OR `outdoor` = 1
) `pool`
ON `rtr2_properties`.`id` = `pool`.`id`
LEFT JOIN (
 SELECT `property_id`, `min`, `max`
  FROM (
   SELECT `rtr2_rates`.`property_id`, MIN(`rtr2_rates`.`Rate`) AS `min` 
    FROM `rtr2_rates`
    
    GROUP BY `property_id`
  ) `min_rates`
  JOIN (
  SELECT `rtr2_rates`.`property_id`, MAX(`rtr2_rates`.`Rate`) AS `max` 
   FROM `rtr2_rates`
   
   GROUP BY `property_id`
  ) `max_rates`
  USING (`property_id`)
) `rates`
ON `rtr2_properties`.`id` = `rates`.`property_id`
WHERE  (`streetcode` = 'Rehoboth Beach')
ORDER BY `street` ASC
LIMIT -10, 10