0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0057 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/tour/ukipt' ORDER BY `views` DESC

0.0081 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/tour/ukipt'

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.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.0064 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.0005 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.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` = 'page'

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

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'ukipt'

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

0.0010 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` = '133' ORDER BY `tour_stops`.`start_date` ASC

0.0065 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.0007 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.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

UKIPT


Exciting live tournaments held in the UK&Ireland.

Upcoming Tour Stops

Saturday 3rd - Sunday 11th August, 2024

UKIPT London

Hippodrome Casino, Leicester Square, London

The crown jewel in the UK and Ireland Poker Tour is back with a bang. Expect fireworks in an iconic city that has hosted epic UKIPT stops in the past. With red-hot action expected, this is set to be no different, especially with the iconic Hippodrome Casino London hosting for another year.

And with the event taking part in the heart of the city, there’s so much more than poker available to our players. Whether it’s taking in the sights, enjoying the historic architecture or soaking up the atmosphere of London, you won’t fail to be impressed.

UKIPT Cup: August 10-11 - £330

UKIPT Main Event: August 4-11 - £1,100

UKIPT High Roller: August 7-8 - £2,200

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  

Friday 8th - Monday 18th November, 2024

UKIPT Nottingham

Dusk Till Dawn, Redfield Way, Boulevard Retail Park, Lenton, Nottingham, NG7 2UW

The final stop of the UK & Ireland Poker Tour will be returning this November, along with the massive £1,000,000 guaranteed Main Event. That means Nottingham is once again home to some of the biggest poker prize pools of the season.

And with Dusk Till Dawn Poker and Casino hosting for another year, players are sure to receive an unrivalled experience on the felt when the cards start flying. How can you be part of the last UKIPT stop of 2024 and get your hands on a share of that awesome guarantee?

UKIPT Cup: Dates TBC - £330

UKIPT Main Event: November 10-18 - £1,100 (£1,000,000 GTD)

UKIPT High Roller: Dates TBC - £2,200

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  
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.