0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0072 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-22' AND `url` = 'https://www.maineventtravel.com/pages/page/goliath-promotion' ORDER BY `views` DESC

0.0115 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-12-22' AND `url` = 'https://www.maineventtravel.com/pages/page/goliath-promotion'

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.0005 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.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0033 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.0006 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` = 'goliath-promotion'

0.0021 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/Goliath-promotion%'

English

Goliath Promotion




 

Grosvenor Casinos presents the Goliath


The Goliath 2019 is set to be the biggest yet with new side events and bigger live tournaments.  Interested? Register at your local Grosvenor Casino or online at www.grosvenorpoker.com

Feeling Lucky? Enter our competition in partnership with Grosvenor Casinos, to win a £200 credit towards your accommodation and buy-in.

All you have to do is fill in the below form between July 14th and July 21st for a chance to win!

If you win but you've already registered for the  Goliath before the competition end date, don't worry! Grosvenor Casinos will refund the buy-in fee (including reg).

Terms & Conditions
1. The Main Event Travel Competition will run from the 14th July at 8 pm – 21st July at 8pm.
2. This promotion will be hosted through the Main Event Travel website on the Goliath landing page and promoted through Grosvenor Poker and Main Event Travel Facebook pages.
3. To participate customers must register with Main Event Travel by entering their email address in the competition landing page.
4. The winner will be randomly selected and then contacted by Main Event Travel to inform them of their prize. The prize will be of a value up to £200 to spend on Goliath booking a hotel and a buy in £125 through Main Event Travel. All arrangement for hotels, buy-in and payment will be made between Main Event Travel and the winning customer. Please refer to Main Even Travel full T&Cs at https://www.maineventtravel.com/pages/page/terms
5. All winners must be a member of Grosvenor Casinos, if not winners will need to sign up at Reception when they arrive at the event. Valid photo ID will be required as proof of age when entering the competition.
6. Customers should be available to play in one of the two main event flights on 1st or 2nd  August at Grosvenor Casino Coventry next to the Ricoh Arena, Judds Lane, Longford, Coventry, CV6 6AQ.
7. By entering this competition hosted by Grosvenor Casinos, the winner is agreeing to receive communications from Grosvenor Casinos and Main Event Travel. You can opt out of these consents at any point by contacting a team member or the sender (Grosvenor Casinos and grosvenorpoker.com)
8. The winners will not be contacted through a third party unless it is to arrange accommodation and payments.
9. The Promotion is subject to availability, legal restrictions and at the discretion of management and are available to over 18s only.
10. There is no cash or other alternatives to the promotion in whole or in part. The offers are non-transferable.
11. The Promoter reserves the right to withdraw or change this offer at any time.
12. The Promoter is the sole arbiter of this promotion and its decision is final and binding. No correspondence will be entered into.
13. Grosvenor Casinos employees are not eligible to participate in this promotion.
14. This promotion is not to be used in conjunction with any other offer.

Promoter: Grosvenor Casinos Limited, Grosvenor Casinos (GC) Limited and The Gaming Group Limited, TOR, Saint-Cloud Way, Maidenhead, SL6 8BN

Promoter: Main Event Travel,  28 South Harbour  Street, Ayr, KA1JA

 

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.