INSERT INTO `sessions` (`source`, `campaign`, `ad_group`, `keyword`, `landing_page`, `device`, `match_type`, `position`, `referer`, `reseller_id`, `user_agent`, `ip_address`, `updated_at`, `created_at`) VALUES ('direct', '', '', '', 'tour/show/Maalaea_Sunset_Whale_Watch', '', '', '', '', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '3.235.107.209', '2020-08-08 13:31:43', '2020-08-08 13:31:43')

UPDATE `sessions` SET `campaign` = '', `ad_group` = '', `device` = '', `match_type` = '', `referer` = '', `reseller_id` = '', `updated_at` = '2020-08-08 13:31:43', `visits` = '1' WHERE `id` = '1301776'

SELECT * FROM `category_tours` WHERE `url_name` = 'Maalaea_Sunset_Whale_Watch' LIMIT 1

SELECT `images`.*, `category_tour_images`.`id` AS `pivot_id`, `category_tour_images`.`created_at` AS `pivot_created_at`, `category_tour_images`.`updated_at` AS `pivot_updated_at`, `category_tour_images`.`category_tour_id` AS `pivot_category_tour_id`, `category_tour_images`.`image_id` AS `pivot_image_id` FROM `images` INNER JOIN `category_tour_images` ON `images`.`id` = `category_tour_images`.`image_id` WHERE `category_tour_images`.`category_tour_id` = '258'

SELECT * FROM `categories` WHERE `staging` = '1'

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '258' LIMIT 1

SELECT COUNT(*) AS `aggregate` FROM `reviews` WHERE `category_tour_id` = '258'

SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1

SELECT COUNT(*) AS `aggregate` FROM `reviews` WHERE `vendor_id` = '8'

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '258' LIMIT 1

SELECT `category_tours`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_id` AS `pivot_category_id`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id` FROM `category_tours` INNER JOIN `tour_categories_new` ON `category_tours`.`id` = `tour_categories_new`.`category_tour_id` WHERE `tour_categories_new`.`category_id` = '11' AND `active` = '1'

SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '122' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '135' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '149' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '149' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '149' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '148' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '141' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '171' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '171' LIMIT 1

SELECT * FROM `vendors` WHERE `id` = '171' LIMIT 1

SELECT * FROM `images` WHERE `id` = '2815' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '38' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '38' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '38' LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '38' LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '38' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '38' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '38' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '38' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '38' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT * FROM `images` WHERE `id` = '3111' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '134' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '134' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '134' LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '134' LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '134' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '134' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '134' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '134' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '134' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT * FROM `images` WHERE `id` = '3112' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '144' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '144' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '144' LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '144' LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '144' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '144' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '144' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '144' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '144' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT * FROM `images` WHERE `id` = '4793' LIMIT 1

SELECT * FROM `vendor_info` WHERE `vendor_id` = '8' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '258' LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '258' LIMIT 1

SELECT `tags`.*, `category_tour_tags`.`id` AS `pivot_id`, `category_tour_tags`.`created_at` AS `pivot_created_at`, `category_tour_tags`.`updated_at` AS `pivot_updated_at`, `category_tour_tags`.`category_tour_id` AS `pivot_category_tour_id`, `category_tour_tags`.`tag_id` AS `pivot_tag_id`, `category_tour_tags`.`reason` AS `pivot_reason`, `category_tour_tags`.`category_tour_id` AS `pivot_category_tour_id`, `category_tour_tags`.`tag_id` AS `pivot_tag_id` FROM `tags` INNER JOIN `category_tour_tags` ON `tags`.`id` = `category_tour_tags`.`tag_id` WHERE `category_tour_tags`.`category_tour_id` = '258' AND `category_tour_tags`.`active` = '1'

SELECT * FROM `category_tour_tags` WHERE `tag_id` = '13' AND `category_tour_id` = '258' LIMIT 1

SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '258' AND `active` = '1' LIMIT 1

SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '258' AND `active` = '1' LIMIT 1

SELECT `options`.*, `tour_options`.`id` AS `pivot_id`, `tour_options`.`created_at` AS `pivot_created_at`, `tour_options`.`updated_at` AS `pivot_updated_at`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id`, `tour_options`.`price` AS `pivot_price`, `tour_options`.`active` AS `pivot_active`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id` FROM `options` INNER JOIN `tour_options` ON `options`.`id` = `tour_options`.`option_id` WHERE `tour_options`.`category_tour_id` = '258' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'tour' ORDER BY `layout` ASC

SELECT `options`.*, `tour_options`.`id` AS `pivot_id`, `tour_options`.`created_at` AS `pivot_created_at`, `tour_options`.`updated_at` AS `pivot_updated_at`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id`, `tour_options`.`price` AS `pivot_price`, `tour_options`.`active` AS `pivot_active`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id` FROM `options` INNER JOIN `tour_options` ON `options`.`id` = `tour_options`.`option_id` WHERE `tour_options`.`category_tour_id` = '258' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'tour' ORDER BY `layout` ASC

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '1' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '2' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '3' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '4' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '5' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '6' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '8' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '11' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '12' AND `active` = '1'

SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '13' AND `active` = '1'

SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '258' LIMIT 1

SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '258' LIMIT 1

SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '258' LIMIT 1

SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '258' LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '258' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '258' LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '258' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1

SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '258' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'luau_and_shows' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'snorkel_and_diving' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'helicopter' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'zipline' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'sunset_cruise' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'scenic_tour' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'downhill_biking' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'hiking' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'whale_watching' LIMIT 1

SELECT * FROM `categories` WHERE `url_name` = 'adventure' LIMIT 1