0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0120 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-12' AND `url` = 'https://www.maineventtravel.com/live-reporting/latest-events' ORDER BY `views` DESC

0.0202 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-12' AND `url` = 'https://www.maineventtravel.com/live-reporting/latest-events'

0.0004 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.0005 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.0006 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.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.0006 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.0116 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.0018 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.0014 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.0124 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.0015 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.0095 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.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` = 103 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` = 104 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` = 105 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` = 106 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` = 107 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` = 108 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` = 109 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` = 110 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` = 92 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

0.0317 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` = 94 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` = 98 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` = 99 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` = 95 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` = 102 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` = 96 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` = 97 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` = 100 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` = 101 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` = 76 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` = 77 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` = 78 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0290 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` = 79 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` = 80 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` = 81 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0290 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` = 82 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` = 83 ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

English

Live Reporting


2024 PPT Series #2

Pure Casino Calgary
Live Coverage: Tuesday 9th - Monday 15th April, 2024
Event #1: $670 6-Max ($600 + $70) Latest Update Nicholas Peterson wins his First PPT Trophy and $10.020 View
Event #2: $230 Bounty ($150 + $50 + $30) Latest Update Hassan Issa Wins Event #2 for $3,070 View
Event #3: $340 Survivor ($300 + $40) Latest Update Who Will Survive? View
Event #4: $560 8-Max ($500 + $60) Latest Update Jesse Talbot Wins Event #4 for $8,970 View
Event #5: $340 Mixed NLH/PLO ($300 + $40) Latest Update Daniel O'Leary Wins Event #5 for $5,650 View
Event #6: $560 Bounty ($300 + $200 + $60) Latest Update Jay Draglands Wins First Trophy in PLO Bounty View
Event #7: $340 NLH ($300 + $40) Latest Update Daniel O'Leary Wins Event #7 for $6,455 View
Event #8: $1,100 Main Event ($990 + $110) Latest Update Main Event Time! View
Latest News & Blogs

It’s All About Cyprus as MET Gets Players to EAPT & MPP with Hotels, Packages, Flights, AND a Giveaway! 

MainEventTravel.com has a $2200 Value Luxon Pay Mystery Bounty Package Giveaway for you! 

The GPI Nominated Malta Poker Festival is 2 weeks away!!!

MainEventTravel.com offers exclusive VIP Packages and Room Rates, ATOL Protected Flights, Buy-ins, and Off-the-Felt Activity tickets.
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.