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 | 20 |
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 `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`.`slug` = 'testimonial' LIMIT 1 | | 1 | 1 | 1 |
12 | SELECT `ListingBannerResort`.`id`, `ListingBannerResort`.`listing_banner_id`, `ListingBannerResort`.`resort_id` FROM `u407119412_tripoffbeat2`.`listing_banner_resorts` AS `ListingBannerResort` WHERE `ListingBannerResort`.`listing_banner_id` = (9) | | 0 | 0 | 0 |
13 | SELECT `Testimonial`.`id`, `Testimonial`.`tl_author`, `Testimonial`.`tl_author_profile_thumb`, `Testimonial`.`tl_from`, `Testimonial`.`tl_desc`, `Testimonial`.`tl_type`, `Testimonial`.`created_on`, `Testimonial`.`updated_on`, `Testimonial`.`is_delete`, `Testimonial`.`status` FROM `u407119412_tripoffbeat2`.`testimonials` AS `Testimonial` WHERE 1 = 1 | | 28 | 28 | 0 |