0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0011 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/pokernews-travel-credit-offer', 1, '2024-04-24')

0.0005 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.0006 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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` = 'tour'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' 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 `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0143 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.0011 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.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` = 'pokernews-travel-credit-offer'

0.0002 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/pokernews-travel-credit-offer%'

English

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.

 

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.