0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0076 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-27'
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.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.0061 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.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` = 'page'

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

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

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

0.0011 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.0067 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.0005 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
  1. Home
  2. Events
  3. UKIPT

UKIPT


Exciting live tournaments held in the UK&Ireland.

Upcoming Tour Stops

Monday 10th - Sunday 16th June, 2024

UKIPT Malaga

Casino Torrequebrada, Av. del Sol, s/n, 29639 Benalmádena, Málaga, Spain

One of Spain’s most stunning coastal cities. Perfect for sun, sea, sand, nightlife…and the thrill of live poker.

That’s right. The UK and Ireland Poker Tour (UKIPT) hits Málaga for the first time this summer for seven days of non-stop action under the Mediterranean sun.  And this time the stakes are even higher as the UKIPT and ESPT tours are combining forces to host a joined Málaga stop in the south of Spain

Now that’s epic, action-packed activities on and off the felt. So, join us there for some of the hottest poker and nightlife Europe has to offer.

UKIPT Cup: Dates TBC - €330

UKIPT Main Event:  Dates TBC - €1,100

UKIPT High Roller: Dates TBC - €2,200

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs
    Find Hotels, Flights & More       Full Schedule Coming Soon  
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: Dates TBC - £330

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

UKIPT High Roller: Dates TBC - £2,200

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details
    Find Hotels, Flights & More       Full Schedule Coming Soon  
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  
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.