0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/past-events', 1, '2025-04-22')

0.0003 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.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'

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

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

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

0.0004 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.0005 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.0004 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 `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.0040 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.0010 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.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.0006 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.0079 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.0006 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.0040 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.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` = 223
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0297 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.0375 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.0337 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.0301 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.0332 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.0305 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.0371 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.0511 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.0384 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.0294 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.0287 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.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` = 214
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0296 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.0309 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.0351 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.0319 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.0343 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.0312 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.0316 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.0292 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.0298 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.0297 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.0309 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.0311 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.0304 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.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` = 201
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0298 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.0291 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.0350 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%'

    

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(4)
  • APAT(12)
  • APPT(3)
  • Aria Resort & Casino(1)
  • Asian Poker Tour(4)
  • Aspers Casino Westfield Stratford City(7)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(1)
  • British Poker Series(8)
  • BSOP(4)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(6)
  • EAPT(1)
  • EPT(4)
  • Golden Nugget Grand Poker Series(1)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(44)
  • Grosvenor UK Poker Open(0)
  • GUKPT Grosvenor(7)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(0)
  • Irish Poker Open(0)
  • Irish Poker Tour(10)
  • 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(15)
  • North American Poker Tour(0)
  • OlyBet Showdown Vilnius (1)
  • Orleans Summer Open(0)
  • PartyPoker Tour(3)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Open(5)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(4)
  • Triton Super High Roller Series(2)
  • UK Poker Championships(2)
  • Unibet DeepStack Open(6)
  • Venetian Deepstack Extravaganza(2)
  • Winamax SISMIX(1)
  • Women's Winter Festival(0)
  • WPT(3)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(4)
  • WSOP International Circuit(1)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(2)
• 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

May Getaways: Poker Takes Centre Stage in Monte Carlo and Barcelona

Spring sunshine, iconic cities, and world-class poker — it’s time to plan your next escape

2 Weeks to Go! Malta Poker Festival: Hotels, Sights to See & More

The Malta Poker Festival is just two weeks away, offering poker enthusiasts an exciting mix of tournaments and stunning Mediterranean scenery. Set in the heart of Malta, the festival promises thrilling action, luxurious accommodations, and plenty of sightseeing opportunities. Book your trip with Main Event Travel for easy access to hotels like the Hilton Malta, Hotel Valentina, and The George Hotel. Don't miss out on this unforgettable experience—secure your spot today!

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