0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`
0.0068 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-08-22' AND `url` = 'https://www.maineventtravel.com/pages/page/IPT-Killarney-Festival-FinalTableFreeroll' ORDER BY `views` DESC
0.0088 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-08-22' AND `url` = 'https://www.maineventtravel.com/pages/page/IPT-Killarney-Festival-FinalTableFreeroll'
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.0002 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.0069 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.0004 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.0002 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.0002 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`.`url_name` = 'IPT-Killarney-Festival-FinalTableFreeroll'
0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/IPT-Killarney-Festival-FinalTableFreeroll%'
Hi,
We'd like to send you push notifications so you never miss out on:
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
Win back up to 100% of Tournament Travel booked with MainEventTravel.com
IPT The Killarney Festival €700 Irish Poker Cup
IPT The Killarney Festival €2000 Highroller
IPT The Killarney Festival €1650 Killarney Omaha Championship 7-Max
IPT The Killarney Festival €150 NLH €10K
IPT The Killarney Festival €300 Omaha 7 Max
Step 1) T
Step 2) Make the Official Final Table!
Step 3) Tag MainEventTravel.com with a pic of yourself before the Official Final Table of an Eligible Event begins using #FinalTableFreeroll
When you are ready to redeem your Travel Credit Let us know your finishing place and we will transfer your travel credit!
Use @MainEventTravel.com on Facebook