0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0079 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-09' AND `url` = 'https://www.maineventtravel.com/tour/redtooth-poker-tour' ORDER BY `views` DESC

0.0113 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-09' AND `url` = 'https://www.maineventtravel.com/tour/redtooth-poker-tour'

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.0067 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.0004 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.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'redtooth-poker-tour'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'redtooth-poker-tour'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '93'

0.0016 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '93' ORDER BY `tour_stops`.`start_date` ASC

0.0071 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC

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

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

Redtooth Poker Tour


Tickets for the 2022/23 season are on sale at Main Event Tickets

 

2022/2023 Redtooth Poker Tour will see 9 VEGAS100 seats and 1 seat into the Malta52, as well as over £133,000 in CASH PRIZES!!! *

The tour will consist of 8 dealer dealt legs taking place around the UK & Europe with the winner of each leg winning a seat into VEGAS100 2023.

All tour legs will be dealer dealt from start to finish and up to £43* from every buy-in will go towards the prize pool which will be paid out in a standard casino structure. Please remember all our tournaments are now dealer dealt by Redtooth Poker dealers increasing our costs, a percentage of the buy-in is required to cover the costs of this.

The final table from EVERY leg will also win a UK National Final seat, a total of 100 seats awarded throughout the year. Players will also accumulate points on the RPT leader board to have a chance at winning a FREE VEGAS100 guest ticket to join us in Las Vegas for the VEGAS100 2021!! Changes to this are currently being made and we will keep you updated with the amendments.

Big things are coming for 2022 including a return to the biggest live poker festival in Europe at Grosvenor Goliath X! Here we will be offering a ONE-OFF LIVE MALTA52 event, The 4 Player Team will be back and our favourite tag team special.

Please remember to take part in the closed Redtooth Poker RPT you must have played 8 pub games in the last 12 months prior to the event.

We look forward to seeing you back at the RPT 2022!!!

To find your nearest Redtooth Poker venue please visit www.redtoothpoker.com/venues/find

NB:
  1. 8 games in the past 12 months must be played prior to the event – attendees will be checked against our records
    If you have not played the required games and purchased a ticket a refund will not be given
  2. All ticket prices will include a booking fee that is non-refundable
  3. Where multiple tickets have been made on a single purchase, any refund of an event will require the entire purchase to be cancelled.
 
A full copy of the Official Redtooth Poker Terms & Conditions can be located at   www.redtoothpoker.com/terms 

 

Upcoming Tour Stops


Sorry, we have no tour stops currently scheduled for Redtooth Poker Tour.
Please check back soon, or subscribe to our newsletter.
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.