0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0086 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-09-13' AND `url` = 'https://www.maineventtravel.com/live-reporting' ORDER BY `views` DESC

0.0122 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-09-13' AND `url` = 'https://www.maineventtravel.com/live-reporting'

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.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.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.0004 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.0037 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.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.0116 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.0028 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.0345 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.0273 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.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` = 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.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` = 219 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` = 210 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` = 211 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` = 212 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

0.0468 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.0362 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.0247 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.0252 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.0254 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.0267 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.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` = 195 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0252 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.0251 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.0255 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.0260 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.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` = 201 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0251 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.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` = 203 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` = 204 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

English

Live Reporting


No Latest Events to Show

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

Experience the Thrill: The Festival Series Malta 2025 Returns to Portomaso Casino

The Festival Series Malta 2025 takes place from September 15–21 at Portomaso Casino in St. Julian's, offering a week of high-stakes poker action for players of all levels. Highlights include the €550 Main Event, The Hendon Mob Championship, mixed-format tournaments, and the unique 10-Game Mix. Players can create flexible Main Event travel packages, choosing their preferred hotel and flights. With luxurious surroundings, vibrant nightlife, and Mediterranean charm, the festival promises an unforgettable poker experience.

Irish Poker Tour Killarney Festival 2025 Set for September

Get ready for six incredible days of poker as the Irish Poker Tour Killarney Festival 2025 takes over the Gleneagle Hotel & INEC from 23–28 September! With over €900,000 guaranteed, highlights include the €700 Irish Poker Cup Main Event, the €60,000 Mystery Bounty, and the €50,000 Killarney 300. Don’t miss Ireland’s most exciting poker festival — book your flights and hotel packages now with Main Event Travel and secure your spot in Killarney!
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.