0.0011 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0068 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-05-31' AND `url` = 'https://www.maineventtravel.com/live-reporting/upcoming-events' ORDER BY `views` DESC

0.0351 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-05-31' AND `url` = 'https://www.maineventtravel.com/live-reporting/upcoming-events'

0.0091 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0029 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0037 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0064 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0063 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0064 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

0.0065 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0049 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0081 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0064 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0068 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0045 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0018 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0069 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

0.0167 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0110 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

0.0014 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` ORDER BY `DATE` DESC, `id` DESC LIMIT 30

0.0006 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0128 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC

0.0007 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0024 SECONDS:
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stop_blogs` LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id` LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stop_blogs`.`active` = '1' ORDER BY `end_date` DESC LIMIT 30

0.0435 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 223 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0277 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 221 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0278 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 222 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0389 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 220 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0272 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 219 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0293 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 210 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0392 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 211 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0299 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 212 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0295 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 213 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0289 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 215 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0281 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 217 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0284 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 218 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0283 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 214 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0276 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 207 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0288 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 208 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0341 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 189 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0442 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 190 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0306 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 191 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0328 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 192 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0279 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 193 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0270 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 194 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0270 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 195 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0276 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 196 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0256 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 197 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0253 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 198 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0249 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 199 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0253 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 201 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0249 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 202 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0246 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 203 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0308 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 204 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%live-reporting-page%'

English

Live Reporting


No Upcoming Events to Show

Try viewing our latest or past events.
Latest News & Blogs

One Month To Go WSOP – Book Now to Secure the Action!

The countdown is well and truly on! In just one month, the 2025 World Series of Poker returns to Las Vegas for another unforgettable summer of high-stakes drama, life-changing prize pools, and the electric atmosphere that only the WSOP can deliver. Whether you’re chasing a coveted gold bracelet, grinding the daily events, or planning your very first trip to the poker capital of the world, now is the time to lock in your travel plans – and there’s no better way to do it than with Main Event Travel.

Rest in Peace Owain Robert Charles Reed

It is with deep sadness that the Main Event Travel team will be out of office today and tomorrow to attend the funeral of our friend and colleague, Owain Reed, who has been lost to us all far too soon.
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.