0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0073 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-04-27'
AND `url` = 'https://www.maineventtravel.com/pages/page/pokernews-travel-credit-offer'
ORDER BY `views` DESC

0.0087 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-27'
AND `url` = 'https://www.maineventtravel.com/pages/page/pokernews-travel-credit-offer'

0.0006 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.0005 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
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 *
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.0117 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.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.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` = '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` = 'pokernews-travel-credit-offer'

0.0002 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%/page/pokernews-travel-credit-offer%'
English
  1. Home
  2. PokerNews Travel Credit Offer

PokerNews Travel Credit Offer


PokerNews $25 Travel Credit Redemption

Email lasvegas@maineventtravel.com with "PokerNews" in the subject before 15th April 2024 to claim.

A reply will be sent to you with the following instructions and Ts & Cs.

You will be required to have a MainEventTravel.com account to receive credit.

If you do not have MainEventTravel.com account you register for one using this link https://maineventtravel.com/user/login/register

You will be required to supply MainEventTravel.com with the email address of the account you wish the Travel Credit to be credited into.

Travel credit will be added to customer’s MainEventTravel.com account within 72 hours of email confirmation.  

Travel credit is non-transferable.

Travel credit has no cash value.

Travel credit has no expiration date.

Travel credit can be used toward Pre-Paid Hotels and Flights only. 

Search for eligible Hotels using the 'Pay Now' button. 

An attempt to purchase Buy-ins or Gift Vouchers using PokerNews Travel Credit will be canceled and refunded.

You can use a Travel Credit balance towards a full or partial payment in ANY currency.

'Pay Hotel' selections will not accept the use of Travel Credit as your credit card will be supplied directly to the Hotel. 

Only one $25 Travel Credit can be requested per customer.

Management reserves the right to cancel or amend this promotion due to abuse or to protect the integrity of the brand.

 

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.