0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0135 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-21' AND `url` = 'https://www.maineventtravel.com/news/article/ukipt-birmingham' ORDER BY `views` DESC

0.0273 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-21' AND `url` = 'https://www.maineventtravel.com/news/article/ukipt-birmingham'

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

0.0060 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.0052 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.0098 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.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.0031 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.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.0026 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.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` = '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.0030 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.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` = '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.0060 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.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` = '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.0080 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.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.0236 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.0051 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.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.0336 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.0010 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.0093 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.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.0050 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.0023 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` = 'ukipt-birmingham'

0.0008 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.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.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` = '43'

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

English
Tuesday 11th October, 2016

Ted Jackson-Spivack wins UKIPT Birmingham

By

What a way to go out. Ted Jackson-Spivack got what everyone wants for their birthday, a UKIPT title of course! He turned 24 today and tonight has a birthday card with £35,000 inside it and a cake topped with a shiny trophy. 

Ukipt6_birmingham_main_event_day3_ted_jackson_spivack.jpg

It'll be the birthday boy buying the drinks tonight

 

We returned with 22 players today and for so long it looked as if Ludovic Geilich was going to become the fifth and final double Main Event winner on the UKIPT as he bossed proceedings. But once play got five-handed Jackson-Spivack took control, eliminating three players in a row and then taking care of Geilich in a short heads-up battle. 

Ukipt6_birmingham_main_event_day3_heads_up.jpg

Heads-up play begins

 

The Folkestone based player started heads-up with a two to one chip lead and it was one-way traffic to the title. On the final hand Geilich limped the button with queens and called all-in for just under 20 big blinds when Jackson-Spivack set him in with K♥4♣. A king on the turn sealed the deal for Jackson-Spivack and a gracious Geilich shook his hand as Jackson-Spivack was mobbed by his rail.

This victory is by far the largest live cash on Jackson-Spivack's poker résumé and completes a great few weeks for the mixed games specialist. Before the final table he told us he'd entered this tournament as he needed to take a break from online having grinded hard during WCOOP, where he finished third in Event #5 a $320 NL Omaha Hi/Lo, 6-Max tournament.

Ukipt6_birmingham_main_event_day3_ludovic_geilich.jpg

Another fine performance from Geilich

 

We were treated to another great episode of the 'Ludovic Geilich Show' here in Birmingham with the UKIPT4 Marbella champion putting on a relentless display of aggressive poker when he had chips, which was the vast majority of the time. He was in or around the chip lead in the run to the final table and but for a brief period where he found himself in 20-30 big blind territory he was very much the table captain. 

He played his usual expressive brand of poker, winning lots of small pots to chip up, when you mix that up with winning the majority of the big pots played that makes for a potent combination for a very dangerous player. He had running battles with Jackson-Spivack and third placed finisher Krishna Nagaraju throughout. This led Jackson-Spivack to remark at one point. "You're too good Ludo," when he'd put him in a particularly tricky ICM spot. Geilich showed off a full repertoire of skills today from correctly snap calling with ace high, to overbetting the pot for thin value. It was a fine performance from a man who so badly wanted that second UKIPT title and on another day he'd have been posing for the winner's photo.

Ukipt6_birmingham_main_event_day3_jake_cody.jpg

Cody - cold decked

 

Another man who was looking for the perfect ending was Mr. UKIPT himself aka Team PokerStars Pro Jake Cody. He'd tied Thomas Ward's record for Main Event cashes when he made the money yesterday and today he had one thing is mind, winning the final UKIPT Main Event. Sadly, it wasn't meant to be as he was coolered out of the tournament in 11th place in a hand against Ben Morrison. The chips went in on the turn of a A♥J♠8♣K♥ board. Cody had top two but Morrison had flopped a set of eights and that was that. Cody almost won a trophy in a side event that he hopped in but came up just short in fifth place. When Morrison himself busted in ninth place the final table was set. You can see a full list of in the money finishers here.

2016_UKIPT_Birm_LineUp_MickeyMay_106118.jpg

Eight guys all wanting to hitch a lift to UKIPT success

 

Along with Geilich, it was David Clarkson, Jeremy Wray and Graham Parkin who were leading the pack, while David Wilkes and Nathan Webb were in the danger zone. They did a good job of hanging on as it took 75 minutes for the first elimination of the final table. When it happened it was a cooler with Wilkes running jacks into the queens of Nagaraju. 

It was at this stage the Geilich went on his downswing so much so that when Webb shoved for around nine big blinds with K♥T♥, Geilich had a decision for around 40% of his stack with A♥8♥. He called, held and was back in business with six left. For Webb, who was Day 1B chip leader, it was the end of a remarkable run.

2016_UKIPT_Birm_David_Wilkes_MickeyMay_106060.jpg

Wilkes - eighth

 

Ukipt6_birmingham_main_event_day3_nathan_webb.jpg

Webb - seventh

 

The start of Geilich's sticky patch came when he lost a race to Wray. A few orbits later it was win some, lose some for the former Swindon Town chairman as he risked his final ten big blinds with pocket tens and lost out to Geilich's ace-king, the Scotsman flopped a king and rivered a flush just for good measure. 

2016_UKIPT_Birm_Jeremy_Wray_Ludovic_Geilich_MickeyMay_106312.jpg

A good day for Wray (left) ended in a sixth place finish

 

If Geilich had been the lead actor up until this point he was relegated to the shadows as Jackson-Spivack came to the fore. In eight minutes he eliminated Parkin (jacks versus tens), Clarkson (kings versus ace-jack) and Nagaraju with 9♣8♣ against pocket sevens when he flopped two pair.

2016_UKIPT_Birm_David_Clarkson_MickeyMay_106209.jpg

A fine fourth place finish for tour reg Clarkson

 

He took that momentum into heads-up play and soon had the scalp of Geilich to add to those that had gone before. Congratulations to Ted Jackson-Spivack on winning UKIPT Birmingham and becoming the final UKIPT Main Event champion, he's in good company. 

UKIPT6 Birmingham Main Event
Dates: October 6 - October 9
Buy-in: £700+£70
Entries: 244 (216 uniques, plus 28 re-entries)
Prize pool: £165,676

POS NAME COUNTRY STATUS PRIZE
1 Ted Jackson-Spivack United Kingdom   £35,000
2 Ludovic Geilich United Kingdom   £23,600
3 Krishna Nagaraju India   £16,646
4 David Clarkson United Kingdom PokerStars Qualifier £13,480
5 Graham Parkin United Kingdom   £10,670
6 Jeremy Wray United Kingdom PokerStars Qualifier £8,100
7 Nathan Webb United Kingdom   £5,920
8 David Wilkes United Kingdom   £4,330

 

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.