0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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.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.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.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.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.0034 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.0095 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.0011 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.0007 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.0037 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.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` = 223 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` = 221 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` = 222 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` = 220 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0339 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.0402 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.0340 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.0389 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 212 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` = 213 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` = 215 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0391 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.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` = 218 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` = 214 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` = 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.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` = 189 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` = 190 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` = 191 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` = 192 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

0.0369 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.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` = 195 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` = 196 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0333 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.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` = 198 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` = 199 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` = 201 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` = 202 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0327 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.0306 SECONDS:
SELECT `tour_stop_blog_day_posts`.* FROM `tour_stop_blog_day_posts` JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blog_day_posts`.`tour_stop_blog_day_id` JOIN `tour_stop_blogs` ON `tour_stop_blogs`.`id` = `tour_stop_blog_days`.`tour_stop_blog_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blogs`.`id` = 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

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.
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.