0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0160 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-21' AND `url` = 'https://www.maineventtravel.com/news/article/Thats-a-Wrap-UKIPT-London-Start-Planning-Your-UKIPT-Edinburgh-Trip-With-Main-Event-Travel-com-Today' ORDER BY `views` DESC

0.0182 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-21' AND `url` = 'https://www.maineventtravel.com/news/article/Thats-a-Wrap-UKIPT-London-Start-Planning-Your-UKIPT-Edinburgh-Trip-With-Main-Event-Travel-com-Today'

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.0006 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.0003 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.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

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.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.0040 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.0049 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0132 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0009 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.0042 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `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.0032 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0008 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.0006 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.0036 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `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.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.0059 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `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.0006 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.0049 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `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.0006 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.0046 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `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.0049 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `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.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.0034 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0009 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.0092 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0011 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.0007 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.0052 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `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.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.0019 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 `url_name` = 'Thats-a-Wrap-UKIPT-London-Start-Planning-Your-UKIPT-Edinburgh-Trip-With-Main-Event-Travel-com-Today'

0.0009 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 `date` <= '2024-11-21' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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.0006 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.0002 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '897'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Monday 25th September, 2023

That’s a Wrap UKIPT London – Start Planning Your UKIPT Edinburgh Trip With MainEventTravel.com Today!

By Mad Harper

It’s a quick turnaround for UKIPT fans following a great event in London. There’s now just a month to go before the tour heads north for UKIPT Edinburgh. This will be the UKIPT’s first visit to the Scottish capital since 2015 when Spanish player David Gomez took down the Main Event for nearly £50k.

The 2023 edition of UKIPT Edinburgh, which is taking place October 24-29 at the Genting Casino Fountain Park, is the fourth UKIPT event of the year and we strongly recommend planning your trip now as affordable hotel space gets snapped up very quickly in this well-known tourist hotspot.

MainEventTravel.com can help you sort out all your travel and accommodation for Edinburgh! We have reduced prices for numerous UKIPT hotels providing you with lots of options at lower cost than most major online travel providers. Check our hotel low-down below!

Hotels super close to the venue

The Hampton by Hilton Edinburgh West End (pictured below) is just a hop, skip and a jump from the tournament venue and is also ideally placed for the top sightseeing attractions of the city such as Edinburgh Castle and the Royal Mile. The hotel has a bar, restaurant, small fitness centre, HDTV in every room, free WiFi – and complimentary hot breakfast is included for all stays. Parking is available (first come, first served) at £15.50/day. There is also a useful 24-hour “hub” with refreshments and convenience items available at any time.

Leonardo Royal Hotel Edinburgh Haymarket

With its stately grey stone exterior (pictured below), this elegant 282-room property – now part of the Leonardo chain – stands beneath Edinburgh Castle, right next to Haymarket train station in the centre of the Scottish capital. Boasting a great in-house restaurant, this contemporary four-star hotel offers stylish accommodation and is an easy ten-minute stroll from the tournament venue. The hotel also puts you within walking distance of Princes Street, the Grassmarket, and the Royal Mile. The modern, Scottish-influenced rooms are all equipped with flat-screen satellite TV, tea/coffee-making facilities, and free Wi-Fi. The front desk is open 24/7. Full English breakfast is available from the daily buffet, with cold dishes and continental options to choose from. The hotel’s Vitruv restaurant is open daily for evening meals, and the Leo90 bar is the perfect spot for a few drinks after dark. Private outdoor parking is available at a charge.

Voco Edinburgh

Well located in the centre of Edinburgh, the 4-star voco Edinburgh Haymarket (pictured below), part of the IHG hotel chain, has air-conditioned rooms, a fitness centre, free WiFi and a comfortable lounge. There is also room service and a 24-hour front desk. The restaurant serves both Scottish and European dishes and there is a bar for evening cocktails. All rooms are fitted with a flat-screen TV, private bathroom, safety deposit box and many rooms have lovely city views. Breakfast is available daily, and includes Full English/Irish, vegetarian and vegan options. There is also an on-site snack bar. The hotel is only 14 minutes’ walk from the tournament venue and also lies close to tourist sites like the National Museum of Scotland and Royal Mile. Blossom Restaurant & Bar provide a welcoming atmosphere where you can unwind your mind after a long day at the tables.

Mercure Edinburgh Haymarket

The Mercure Edinburgh Haymarket Hotel (pictured below) is ideally located in the heart of Edinburgh, making it the perfect base for sightseeing AND playing poker. Lying only ten minutes’ walk from the tournament venue, the Mercure is a stylish four-star hotel with spacious, modern, well-equipped rooms and plenty of on-site facilities including a restaurant, bar and lounge area, fitness centre, 24-hour front desk and room service. Parking is available nearby at £11/day. All rooms feature USB chargers, free high-speed Wi-Fi, a minibar, tea/coffee-making facilities and a seating area. 

Further afield

MainEventTravel is also recommending hotels that are a slightly longer walk from the tournament venue but are comfy, great value and an ideal option if you’re trying to keep costs down.

Murrayfield Hotel & House

This impressive Victorian property (pictured below) lies in a quiet setting in the beautiful and historic centre of Edinburgh close to Murrayfield Stadium. It’s a slightly longer walk – about half an hour – to the tournament venue but only seven minutes in a cab. The hotel prides itself on its warm Scottish hospitality with a restaurant serving home-cooked traditional Scottish and international dishes.  The comfortable and beautifully decorated rooms all have free WiFi, en-suite bathroom, flat-screen TV, and tea/coffee-making facilities. There is free parking too. The hotel bar offers stylish surroundings with daily entertainment and live sports – and there’s a beer garden!

Braid Apartments

Braid Apartments (pictured below) provides a great way to keep costs down during your trip to Edinburgh. The property incorporates 20 modern and stylish apartments with a range of studio, 1- and 2-bedroom options in a historical building in Edinburgh's New Town. Guests on the upper floors of the north-facing side of the building get amazing views over the Firth of Forth and beyond. You are also only a short walk from many of Edinburgh's most popular attractions, including Edinburgh Castle, The Old Town, Princes Street, Edinburgh New Town and Edinburgh Art Galleries. Free WiFi is provided throughout the property.

Travelodge Hotels – Edinburgh Central Queen Street & Edinburgh Haymarket

There are two good Travelodges that are within walking distance from the UKIPT venue at Genting Casino Fountain Park. Edinburgh Haymarket will take you around 22 minutes to get to the venue and Edinburgh Central Queen Street (pictured below) around 30 minutes. The Edinburgh Central Queen Street Hotel sits within easy reach of some of the best sights in the city – from the awe-inspiring castle to the Scottish National Gallery and Holyrood Palace. You’re also only a stone's throw from Harvey Nicks if you fancy some up-market shopping. Edinburgh Haymarket, which is set in a listed Georgian building, is located in Edinburgh's elegant West End near the train station and also has an on-site restaurant and bar serving breakfast and tasty evening meals. All Travelodge rooms feature Freeview TV, tea/coffee-making facilities, a comfy bed with plump pillows and a cosy duvet.

UKIPT Edinburgh schedule
With a £1,100 buy-in Main Event starting October 26 and numerous other great tournaments on the schedule, UKIPT Edinburgh promises a ton of exciting poker action. Flagship events include the £2,200 High Roller (October 25-26) and the £330 Cup (October 28-29). Other tournaments include a £220 PLO event, a £220 8-game tourney, several NLH freezeouts and a £220 Women’s Event on Sunday, October 29.

Dylan Bradley wins UKIPT London
UKIPT London, which finished on Sunday, was a massive success. Dylan Bradley (pictured) took down the £1,100 buy-in Main Event for £71,560 – his first recorded cash – after outlasting a 374-entry field. A total of 56 players made the money for a share of the £359,040 prize pool. 

Also among those who enjoyed success in London was Marle Spragg (pictured above), wife of PokerStars Team Pro and UKIPT Brighton champion Ben Spragg. Marle saw off 45 competitors in the Women’s Event to take the trophy and £2,942 first prize. Deborah Worley-Roberts, runner-up in the UKIPT Brighton Women’s Event, finished 7th in London. Another female trophy winner was DeAnna Debosz (pictured below) who put into practice everything she has learned as a Hippodrome Ladies Club regular to snag her first tournament victory in the £220 NLH Bounty. DeAnna takes £3,082 + £900 home to North London – her biggest live cash.

UKIPT Nottingham Grand Final 

The final event of this year’s tour is the UKIPT Nottingham Grand Final which is taking place at Dusk Till Dawn from November 4-13. MainEventTravel.com is the Official Travel Partner of Dusk Till Dawn. 

Photo Credit - Danny Maxwell

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.