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 | 17 |
2 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 1 |
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 | 1 |
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 `Package`.`id`, `Package`.`pkg_name`, `Package`.`pkg_slug`, `Package`.`meta_title`, `Package`.`meta_keywords`, `Package`.`meta_desc`, `Package`.`pkg_thumb`, `Package`.`pkg_thumb_large`, `Package`.`pkg_thumb_alt`, `Package`.`pkg_amount`, `Package`.`list_price`, `Package`.`bulk_discount`, `Package`.`pkg_duration`, `Package`.`pkg_location`, `Package`.`travel_dates`, `Package`.`available_packages`, `Package`.`tripoffbeat_offer`, `Package`.`inclusions`, `Package`.`how_to_redeem`, `Package`.`extra_adult_and_children`, `Package`.`how_to_cancel`, `Package`.`detailed_inclusions`, `Package`.`pkg_valadity`, `Package`.`resort_to_choose_from`, `Package`.`itinerary`, `Package`.`package_highlights`, `Package`.`pkg_locations`, `Package`.`start_on`, `Package`.`expire_on`, `Package`.`update_on`, `Package`.`status`, `Package`.`is_delete` FROM `u407119412_tripoffbeat2`.`packages` AS `Package` WHERE `Package`.`pkg_slug` = 'kerala-backwaters' LIMIT 1 | | 1 | 1 | 1 |
12 | SELECT `PackageOption`.`id`, `PackageOption`.`package_id`, `PackageOption`.`option_title`, `PackageOption`.`option_descn`, `PackageOption`.`created_on`, `PackageOption`.`updated_on`, `PackageOption`.`status` FROM `u407119412_tripoffbeat2`.`package_options` AS `PackageOption` WHERE `PackageOption`.`package_id` = (9) | | 0 | 0 | 0 |
13 | SELECT `PackageCity`.`id`, `PackageCity`.`package_id`, `PackageCity`.`city_id`, `PackageCity`.`Label` FROM `u407119412_tripoffbeat2`.`package_cities` AS `PackageCity` WHERE `PackageCity`.`package_id` = (9) | | 3 | 3 | 1 |
14 | SELECT `Package`.`id`, `Package`.`pkg_name`, `Package`.`pkg_slug`, `Package`.`meta_title`, `Package`.`meta_keywords`, `Package`.`meta_desc`, `Package`.`pkg_thumb`, `Package`.`pkg_thumb_large`, `Package`.`pkg_thumb_alt`, `Package`.`pkg_amount`, `Package`.`list_price`, `Package`.`bulk_discount`, `Package`.`pkg_duration`, `Package`.`pkg_location`, `Package`.`travel_dates`, `Package`.`available_packages`, `Package`.`tripoffbeat_offer`, `Package`.`inclusions`, `Package`.`how_to_redeem`, `Package`.`extra_adult_and_children`, `Package`.`how_to_cancel`, `Package`.`detailed_inclusions`, `Package`.`pkg_valadity`, `Package`.`resort_to_choose_from`, `Package`.`itinerary`, `Package`.`package_highlights`, `Package`.`pkg_locations`, `Package`.`start_on`, `Package`.`expire_on`, `Package`.`update_on`, `Package`.`status`, `Package`.`is_delete` FROM `u407119412_tripoffbeat2`.`packages` AS `Package` WHERE 1 = 1 | | 23 | 23 | 4 |
15 | SELECT `PackageOption`.`id`, `PackageOption`.`package_id`, `PackageOption`.`option_title`, `PackageOption`.`option_descn`, `PackageOption`.`created_on`, `PackageOption`.`updated_on`, `PackageOption`.`status` FROM `u407119412_tripoffbeat2`.`package_options` AS `PackageOption` WHERE `PackageOption`.`package_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24) | | 86 | 86 | 0 |
16 | SELECT `PackageCity`.`id`, `PackageCity`.`package_id`, `PackageCity`.`city_id`, `PackageCity`.`Label` FROM `u407119412_tripoffbeat2`.`package_cities` AS `PackageCity` WHERE `PackageCity`.`package_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24) | | 181 | 181 | 0 |
17 | 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 | 19 |
18 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 13 |
19 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 0 |
20 | 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 |
21 | 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 |
22 | 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 |
23 | 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 |
24 | 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 |
25 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | | 6 | 6 | 0 |
26 | 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 |
27 | SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`id` = 48389 LIMIT 1 | | 1 | 1 | 0 |
28 | 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 | 12 |
29 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 0 |
30 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 0 |
31 | 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 |
32 | 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 |
33 | 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 |
34 | 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 |
35 | 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 |
36 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | | 6 | 6 | 0 |
37 | 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 |
38 | SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`id` = 48357 LIMIT 1 | | 1 | 1 | 0 |
39 | 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 | 11 |
40 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 0 |
41 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | | 8 | 8 | 0 |
42 | 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 |
43 | 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 |
44 | 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 |
45 | 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 |
46 | 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 |
47 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | | 6 | 6 | 0 |
48 | 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 |
49 | SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`id` = 1950 LIMIT 1 | | 1 | 1 | 1 |