0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`
0.0074 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-10-15' AND `url` = 'https://www.maineventtravel.com/pages/page/goliathfinaltablefreeroll' ORDER BY `views` DESC
0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/goliathfinaltablefreeroll', 1, '2024-10-15')
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.0072 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.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.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`.`url_name` = 'goliathfinaltablefreeroll'
0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/goliathfinaltablefreeroll%'
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
Grosvenor Goliath 2024 £200 Main Event
Grosvenor Goliath Ladies £115 Event
Grosvenor Goliath £125 RedTooth Big One
Grosvenor Goliath £440 Mystery Bounty
Grosvenor Goliath £1500 High Roller
Grosvenor Goliath £550 Goliath Cup
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