0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0099 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-01-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/latest-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.0002 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.0003 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.0003 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

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

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` = 'tour'

0.0003 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.0005 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.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` = 'page'

0.0045 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.0015 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.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.0008 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.0031 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.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` = 223
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0335 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.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` = 222
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` = 220
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` = 219
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

0.0303 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.0326 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.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` = 207
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` = 208
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

0.0320 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.0323 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.0395 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.0441 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.0368 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.0318 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.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` = 197
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` = 198
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0324 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.0325 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.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` = 202
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

No Latest Events to Show

Try viewing our upcoming or past events.

Latest News & Blogs

Kings of Tallinn Celebrates 10-Year Anniversary This February

The Kings of Tallinn, one of Europe's most exciting poker festivals, is set to mark its 10th anniversary with a spectacular event in February 2025. Hosted at the luxurious Hilton Tallinn Park Hotel and Olympic Park Casino, this milestone promises an unforgettable experience for poker enthusiasts from around the globe.

Irish Poker Open 2025: Europe’s Longest-Running Poker Festival Returns

The highly anticipated Irish Poker Open 2025 is set to take place from 10th to 21st April at the Royal Dublin Society (RDS), Dublin. Renowned for its vibrant atmosphere and prestigious history, the event is expected to draw poker enthusiasts from around the globe, all vying for their share of fame and fortune.

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