| 1 | SELECT WpPost.post_content,WpPost.guid,WpPost.post_date,WpPost.post_title,WpPostmeta2.meta_value FROM `u407119412_tripoffbeat2`.`wp_posts` AS `WpPost` left JOIN `u407119412_tripoffbeat2`.`wp_postmeta` AS `WpPostmeta1` ON (`WpPostmeta1`.`post_id` = `WpPost`.`ID` AND `WpPostmeta1`.`meta_key` = "_thumbnail_id") left JOIN `u407119412_tripoffbeat2`.`wp_postmeta` AS `WpPostmeta2` ON (`WpPostmeta2`.`post_id` = `WpPostmeta1`.`meta_value` AND `WpPostmeta2`.`meta_key` = "_wp_attachment_metadata") WHERE `WpPost`.`post_type` = 'post' AND `WpPost`.`post_status` = 'publish' ORDER BY `WpPost`.`post_date` desc | | 63 | 63 | 7 |
| 2 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 0 |
| 3 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 0 |
| 4 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_weekends` = 1 | | 9 | 9 | 0 |
| 5 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_vacations` = 1 | | 9 | 9 | 0 |
| 6 | SELECT `Category`.`id`, `Category`.`name` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_destinations` = 1 | | 9 | 9 | 0 |
| 7 | SELECT `State`.`id`, `State`.`name`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_destinations` = 1 ORDER BY `State`.`name` asc | | 14 | 14 | 0 |
| 8 | SELECT `State`.`id`, `State`.`name`, `State`.`thumb`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_weekends` = 1 ORDER BY `State`.`name` asc | | 6 | 6 | 0 |
| 9 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | | 6 | 6 | 0 |
| 10 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`activity_id` IN (40, 43, 44, 45, 46, 50) | | 624 | 624 | 1 |
| 11 | SELECT Activity.id,Activity.activity_name,Activity.activity_thumb, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`parent_id` = 0 LIMIT 10 | | 10 | 10 | 0 |
| 12 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`activity_id` IN (40, 41, 42, 43, 44, 45, 46, 48, 50, 51) | | 1097 | 1097 | 1 |
| 13 | SELECT State.id,State.name,count(`Resort`.`id`) as place_count FROM `u407119412_tripoffbeat2`.`states` AS `State` inner JOIN `u407119412_tripoffbeat2`.`resorts` AS `Resort` ON (`Resort`.`state_id` = `State`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE 1 = 1 GROUP BY `Resort`.`state_id` | | 22 | 22 | 1 |
| 14 | SELECT `ListingBanner`.`id`, `ListingBanner`.`slug`, `ListingBanner`.`title`, `ListingBanner`.`meta_title`, `ListingBanner`.`meta_keywords`, `ListingBanner`.`meta_desc`, `ListingBanner`.`description`, `ListingBanner`.`banner`, `ListingBanner`.`from_console`, `ListingBanner`.`update_on`, `ListingBanner`.`create_on`, `ListingBanner`.`status`, `ListingBanner`.`is_delete` FROM `u407119412_tripoffbeat2`.`listing_banners` AS `ListingBanner` WHERE `ListingBanner`.`id` = 6 LIMIT 1 | | 1 | 1 | 0 |
| 15 | SELECT `ListingBannerResort`.`id`, `ListingBannerResort`.`listing_banner_id`, `ListingBannerResort`.`resort_id` FROM `u407119412_tripoffbeat2`.`listing_banner_resorts` AS `ListingBannerResort` WHERE `ListingBannerResort`.`listing_banner_id` = (6) | | 0 | 0 | 0 |
