| 7 | SELECT `Rental`.`id`, `Rental`.`system_id`, `Rental`.`status`, `Rental`.`terms`, `Rental`.`mls_number`, `Rental`.`listing_agent_name`, `Rental`.`listing_agent_phone`, `Rental`.`listing_office_name`, `Rental`.`listing_office_phone`, `Rental`.`address`, `Rental`.`street_name`, `Rental`.`street_number`, `Rental`.`city`, `Rental`.`region_id`, `Rental`.`community_id`, `Rental`.`neighborhood`, `Rental`.`complex_name`, `Rental`.`unit_number`, `Rental`.`zip_code`, `Rental`.`price`, `Rental`.`price_original`, `Rental`.`price_difference`, `Rental`.`security_deposit`, `Rental`.`beds`, `Rental`.`beds_total`, `Rental`.`baths`, `Rental`.`baths_half`, `Rental`.`baths_full`, `Rental`.`sqft`, `Rental`.`remarks`, `Rental`.`additional_remarks`, `Rental`.`occupied`, `Rental`.`security`, `Rental`.`view`, `Rental`.`bbq`, `Rental`.`beach_rights`, `Rental`.`hiking_trails`, `Rental`.`clubhouse`, `Rental`.`concierge`, `Rental`.`exercise_room`, `Rental`.`gated_community`, `Rental`.`golf`, `Rental`.`horse_facility`, `Rental`.`horse_trails`, `Rental`.`laundry_facilities`, `Rental`.`onsite_guard`, `Rental`.`playground`, `Rental`.`pool`, `Rental`.`recreation_area`, `Rental`.`rv_parking`, `Rental`.`sauna`, `Rental`.`spa`, `Rental`.`tennis_courts`, `Rental`.`dishwasher`, `Rental`.`disposal`, `Rental`.`dryer`, `Rental`.`microwave`, `Rental`.`range_oven`, `Rental`.`refrigerator`, `Rental`.`satellite_dish`, `Rental`.`washer`, `Rental`.`lessee_pays`, `Rental`.`movein_requirements`, `Rental`.`air_conditioner`, `Rental`.`furnished`, `Rental`.`date_available`, `Rental`.`pets`, `Rental`.`virtual_tour`, `Rental`.`elevator`, `Rental`.`exclusive_yard`, `Rental`.`parking_spaces`, `Rental`.`style`, `Rental`.`property_type`, `Rental`.`price_reference`, `Rental`.`rental_type`, `Rental`.`vacation_rental_min`, `Rental`.`residential_rental_min`, `Rental`.`approved`, `Rental`.`featured`, `Rental`.`photos_downloaded`, `Rental`.`expires`, `Rental`.`is_expired`, `Rental`.`user_id`, `Rental`.`image_count`, `Rental`.`lat`, `Rental`.`lon`, `Rental`.`source_id`, `Rental`.`source_name`, `Rental`.`source_created`, `Rental`.`created`, `Rental`.`modified` FROM `rentals` AS `Rental` WHERE `Rental`.`region_id` = (20) ORDER BY `Rental`.`featured` DESC, `Rental`.`price` DESC LIMIT 8 | | 8 | 8 | 11 |
| 8 | SELECT `Community`.`id`, `Community`.`mls_name`, `Community`.`mls_value`, `Community`.`rental_count`, `Community`.`slug`, `Community`.`title`, `Community`.`button_text`, `Community`.`keywords`, `Community`.`description`, `Community`.`name`, `Community`.`content`, `Community`.`population`, `Community`.`average_household_income`, `Community`.`average_temperature`, `Community`.`average_annual_rainfall`, `Community`.`renter_occupied`, `Community`.`region_id`, `Community`.`color`, `Community`.`top`, `Community`.`left`, `Community`.`abbrev`, `Community`.`lat`, `Community`.`lon`, `Community`.`created`, `Community`.`modified` FROM `communities` AS `Community` WHERE `Community`.`region_id` = (20) | | 0 | 0 | 1 |
