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%'

English

Goliath FinalTableFreeroll


ALL multi-day Goliath events are included in the #FinalTableFreeroll promotion

Win back up to 100% of Tournament Travel booked with MainEventTravel.com

Grosvenor Goliath 2024 £200 Main Event 

Grosvenor Goliath GUKPT £1250 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

Entering our exclusive added-value #FinalTableFreeroll promotion is as easy as 1, 2, 3! Just book your Tournament Travel with MET then...

Step 1) Tag MainEventTravel.com on Facebook or X in a post any time before the first Day 1 of the Eligible Event telling us which festival you booked to attend.

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

Official Final Table - 10% back in Travel Credit

Heads Up - 50% back in Travel Credit

Winner - 100% back in Travel Credit

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 Use @MainEventTravel on X

Terms & Conditions apply.

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.