| 1 | SHOW FULL COLUMNS FROM `rentals` | | 91 | 91 | 3 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 |
| 3 | SHOW FULL COLUMNS FROM `regions` | | 13 | 13 | 1 |
| 4 | SHOW FULL COLUMNS FROM `communities` | | 25 | 25 | 1 |
| 5 | SHOW FULL COLUMNS FROM `images` | | 8 | 8 | 1 |
| 6 | SHOW FULL COLUMNS FROM `users` | | 14 | 14 | 1 |
| 7 | SHOW FULL COLUMNS FROM `alerts` | | 15 | 15 | 1 |
| 8 | SHOW FULL COLUMNS FROM `results` | | 8 | 8 | 1 |
| 9 | 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`, `Region`.`id`, `Region`.`mls_name`, `Region`.`mls_value`, `Region`.`slug`, `Region`.`title`, `Region`.`button_text`, `Region`.`keywords`, `Region`.`description`, `Region`.`name`, `Region`.`content`, `Region`.`community_count`, `Region`.`created`, `Region`.`modified`, `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 `rentals` AS `Rental` LEFT JOIN `regions` AS `Region` ON (`Rental`.`region_id` = `Region`.`id`) LEFT JOIN `communities` AS `Community` ON (`Rental`.`community_id` = `Community`.`id`) WHERE `Rental`.`id` = 4209 LIMIT 1 | | 0 | 0 | 1 |
| 10 | SELECT `Community`.`slug`, `Community`.`name` FROM `communities` AS `Community` WHERE 1 = 1 ORDER BY `Community`.`name` ASC | | 126 | 126 | 0 |
| 11 | 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`, `Region`.`id`, `Region`.`mls_name`, `Region`.`mls_value`, `Region`.`slug`, `Region`.`title`, `Region`.`button_text`, `Region`.`keywords`, `Region`.`description`, `Region`.`name`, `Region`.`content`, `Region`.`community_count`, `Region`.`created`, `Region`.`modified`, `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 `rentals` AS `Rental` LEFT JOIN `regions` AS `Region` ON (`Rental`.`region_id` = `Region`.`id`) LEFT JOIN `communities` AS `Community` ON (`Rental`.`community_id` = `Community`.`id`) WHERE ((`Rental`.`price` <= 200) AND (`Rental`.`zip_code` IS NULL) AND (`Rental`.`beds` >= NULL) AND (`Rental`.`id` IS NOT NULL) AND (`Rental`.`approved` = 1)) ORDER BY `Rental`.`featured` DESC, `Rental`.`price` DESC LIMIT 3 | | 0 | 0 | 0 |
