0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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

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

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

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

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

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

0.0002 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.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

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

0.0003 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.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 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.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0003 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.0003 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.0041 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.0009 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.0005 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.0004 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.0070 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.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.0004 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.0033 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.0342 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.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` = 221
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0314 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.0271 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.0257 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.0248 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.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` = 211
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0259 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.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` = 213
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0275 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.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` = 217
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` = 218
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` = 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.0285 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.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` = 189
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0259 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.0266 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.0266 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.0258 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.0300 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.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` = 195
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` = 196
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0274 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.0261 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.0258 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.0264 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.0457 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.0373 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.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` = 204
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(2)
  • 888poker UK Poker League(5)
  • APAT(12)
  • APPT(3)
  • Aria Resort & Casino(3)
  • Asian Poker Tour(4)
  • Aspers Casino Westfield Stratford City(8)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(1)
  • British Poker Series(8)
  • BSOP(4)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(8)
  • EAPT(2)
  • EPT(4)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(50)
  • Grosvenor UK Poker Open(0)
  • GUKPT Grosvenor(7)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • King's Resort(0)
  • Kings of Tallinn(0)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(14)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • OlyBet Showdown Vilnius (1)
  • Orleans Summer Open(0)
  • PartyPoker Tour(3)
  • Poker GO Tour(3)
  • Poker Skills Events(1)
  • PokerStars Open(4)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(3)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(2)
  • Unibet DeepStack Open(8)
  • Venetian Deepstack Extravaganza(1)
  • Women's Winter Festival(0)
  • WPT(4)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(4)
  • WSOP International Circuit(3)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • #FinalTableFreeroll – Viva Las Vegas

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

1. Home
2. Live Reporting

Live Reporting

Latest Events Upcoming Events Past Events

BPS One-Day 20k Newcastle

Aspers Casino

Live Coverage: Saturday 07 December, 2024

December BPS One Day Newcastle Latest Update Darren Knaggs takes it down! View

Kings of Vilnius

Olympic Casino Lietuva

Live Coverage: Friday 15th - Sunday 24th November, 2024

Event #19: €2,000 NLH High Roller Latest Update End of Day 2 View

Event #23: €1,100 NLH Main Event Latest Update End of Day 3 View

BPS200 London

Aspers Casino Westfield Stratford City

Live Coverage: Thursday 14th - Sunday 17th November, 2024

BPS200 London November Latest Update 35 Players Return View

BPS One-Day 20k Newcastle

Aspers Casino

Live Coverage: Saturday 09 November, 2024

BPS ONE DAY 20K Latest Update End of Day 1 View

Kings of Tallinn Autumn Edition 2024

Olympic Park Casino

Live Coverage: Friday 18th - Sunday 27th October, 2024

Event #20 €555 NLH Kings of Tallinn Championship Latest Update End of Day 3 View

Event #27 €5,000 NLH Progressive Bounty Latest Update End of Day 1 View

Event #31: Kings of Tallinn €1,100 Main Event Latest Update End of Day 4 View

Event #52: €3,000 NLH Latest Update End of Day 2 View

Event #20 €555 NLH Kings of Tallinn Championship (Finnish) Latest Update 555€ Championship, tulokset View

Event #31: Kings of Tallinn €1,100 Main Event (Finnish) Latest Update Kiitokset seurasta - Helmikuussa jatkuu View

Event #52: €3,000 NLH (Finnish) Latest Update Highroller, tulokset View

BPS One-Day 20k Manchester

Manchester235

Live Coverage: Saturday 19 October, 2024

BPS ONE DAY 20K Latest Update End of Day 1 View

BPS Championships

Aspers Casino Westfield Stratford City

Live Coverage: Thursday 3rd - Monday 14th October, 2024

BPS 200 Championship Edition Latest Update End of Day 2 View

BPS Championship Main Event Latest Update Start of Level 32 View

Pure Poker Tour - 2024 PPT Series #4

Casino Yellowhead

Live Coverage: Sunday 15th - Monday 30th September, 2024

PPT Series #4 Latest Update PPT #4 is Dedicated to the Memory of Ryan Snyder View

PPT Series #4 Event #1: $340 Seniors ($300 + $40) Latest Update Let's Make a Deal View

PPT Series #4 Event #2: $230 Little Bounty ($150 + $50 + $30) Latest Update Mike Malm Wins Little Bounty for $4,880 View

PPT Series #4 Event #3: $450 Mystery Bounty ($300 + $300 + $50) Latest Update David Johnson Wins Mystery Bounty After Deal View

PPT Series #4 Event #4: $340 Survivor ($300 + $40) Latest Update Deal Cut with Final Five View

PPT Series #4 Event #5: $230 Tag Team with Switches ($200 + $30) Latest Update Final Results from Tag Team View

PPT Series #4 Event #6: $450 8-Max ($400 + $50) Latest Update Ajaypal Gill Wins 8-Max for $10,168 after Deal View

PPT Series #4 Event #7: $560 6-Max ($500 + $60) Latest Update Eric Wasylenko Adds to his PPT Trophy Collection with 6-Max Win View

PPT Series #4 Event #8: $230 Turbo ($200 + $30) Latest Update Kevin Schell Wins Turbo after Chop View

PPT Series #4 Event #9: $340 NLH/PLO Mixed ($300 + $40) Latest Update Marc Lavergne Wins NLH/PLO Mix for $7,560 in Deal View

PPT Series #4 Event #10: $340 Freezeout ($300 + $40) Latest Update Daniel O'Leary Wins Freezeout for $7,367 View

PPT Series #4 Event #12: $340 Bounty ($250 + $50 + $40) Latest Update Sharmark Mohamed Wins Event #12 for $7,983 View

PPT Series #4 Event #13: $560 PLO Big Bounty ($300 + $200 + $60) Latest Update Gary Rooprai Wins PLO Big Bounty for $7,746 plus 9 Bounties View

PPT Series #4 Event #14: $340 NLH ($300 + $40) Latest Update Dave S Wins Event #14 View

PPT Series #4 Event #15: $1,100 Main Event ($990 + $110) Latest Update MIchael "Berny" Bernstein Wins Main Event for $75,094 View

Latest News & Blogs

Top Hotels for the WSOP 2025: 2 Months to Go – Have You Booked Yet? Lock in the Best Rates Today!

The World Series of Poker (WSOP) is just two months away, and if you haven’t already secured your accommodation, now is the time to act! The WSOP is one of the most prestigious poker events in the world, drawing thousands of players and fans to Las Vegas for weeks of thrilling action.

The 2025 World Series of Poker

The World Series of Poker (WSOP) is back for its 56th edition, set to take place from May 27 to July 16, 2025, at Horseshoe Las Vegas and Paris Las Vegas. This summer’s series promises to be bigger than ever, with an unprecedented 100 bracelet events, including a mix of classic tournaments and exciting new additions.

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter