0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0060 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-06-16' AND `url` = 'https://www.maineventtravel.com/news/article/Northern-Europeslargest-festival-kicks-off-this-weekend-Kings-of-Tallinn-' ORDER BY `views` DESC

0.0083 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-06-16' AND `url` = 'https://www.maineventtravel.com/news/article/Northern-Europeslargest-festival-kicks-off-this-weekend-Kings-of-Tallinn-'

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.0003 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.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.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.0059 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.0035 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.0075 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.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.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.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` = '16' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0049 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.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.0039 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.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.0039 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.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` = '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.0041 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.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.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.0144 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.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.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` = '30' 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.0150 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.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.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.0015 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` = 'Northern-Europeslargest-festival-kicks-off-this-weekend-Kings-of-Tallinn-'

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-06-16' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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.0003 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` = '781'

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

English
Thursday 23rd February, 2023

Northern Europe's largest festival kicks off this weekend - Kings of Tallinn

By Jason Glatzer

The largest festival in Northern Europe kicks off this weekend with the Kings of Tallinn  making its triumphant return to the luxurious Olympic Park Casino and the adjoining world-class Hilton Tallinn Park from Feb. 23 to March 5.

 

The Kings of Tallinn has something for every type of poker player with a massive menu of 53 events. While there are tons of no-limit hold’em events each day, there are many other variants to keep your appetite satisfied as well with tournaments featured in pot-limit Omaha, 8-game, Open Face Chinese Poker, Sviten Special, and more.

 

The Kings of Tallinn isn’t afraid to try something new as not only do they have a “traditional” €660 Mystery Bounty event on the schedule but also a €440 Omaha Mystery Bounty along with a unique €150 GGPoker Flip&Go Mystery Bounty with many opening flights.

 

Experienced poker reporters Jason Glatzer (English) and Juhani Tyrisevä (Finnish) will be reporting live from the casino floor for the first time at Main Event Travel. The duo will be primarily focusing on the action of two of the bigger events in the €555 NLH Championship on Feb. 25-28 before hopping into bringing the action to your doorstep in the €500,000 guaranteed Kings of Tallinn €1,100 Main Event on March 1-5.

 

 

“The tournament schedule is a combination of already established traditional Kings of Tallinn events, like the €555 NLH Championship and €1,100 Main Event and players’ hopes and wishes that led to brand-new events, like the GGPoker Flip&Go Mystery Bounty where Day 1 is a one-hand flip, and Day 2 regular play,” Nousiainen said. “We guarantee at least one €5,000 Mystery Envelope for Day 2 of this event! Another new event is the €440 PLO Mystery Bounty, requested by our Omaha-loving players, and the €350 NLH/ PLO Mix is also a player’s wish.”

 

Of course, Main Event Travel can help you and all players with all of their travel needs for the 2023 Kings of Tallinn with many affordable travel options based on your needs.

 

Massive Main Event

 

The highlight of the 2023 Kings of Tallinn is easily the €1,100 Main Event on March 1-5. For the second time in event history, the festival’s organizers slapped a massive €500,000 guarantee on this event.

 

This could prove to be merely a placeholder as just before the COVID pandemic began in February 2020 the Main Event smashed its €500,000 guarantee with 674 entries getting into the action to generate a huge €640,300 prize pool. Sweden’s Johan Karlsson was the star of the show by winning the coveted trophy along with a massive €126,900 top prize after agreeing to a heads-up deal with Estonia’s Ermo Kosk.

 

The Main Event structure is among the best if you love deep-stacked play with a long clock. The tournament features three opening flights with players starting with 30,000 in chips on March 1-2 and boasts long one-hour blind levels throughout the event except for the third and final opening flight which still provides plenty of play with 30-minute blind levels.

 

Surviving players will join others that late-register or re-enter on Day 2 on March 3 with late registration not closing until the conclusion of the first blind level of the day. Players will continue to battle it out for two more days after this until a winner is crowned on March 5.

 

Exciting Team Competition

 

 

The Kings of Tallinn is already exciting thanks to the amazing schedule, cash games around the clock, the helpful and experienced staff, and the family feeling of the entire festival.

 

This is not all as the Team Competition is yet another big reason that the Kings of Tallinn is on many players’ calendars as there are rails for just about every event with teammates rooting each other to victory.

 

The Team competition is free to enter with players forming teams of four on the Kings of Tallinn website.  Don’t stress if you come alone and have yet to meet enough people to form a team as the Kings of Tallinn staff will help you get on a team. Many players have taken this path and the past and led to making some new poker friends for life.

 

The Team Competition is funded with 2% of the prize pools of qualifying events. The top two teams will be in the money, with 75% of the prize pool to be awarded to the winning team and the remaining 25% to the runner-up team. We aren’t talking about just honor here as the winning team is expected to be awarded a huge prize of approximately €20,000!

 

“The schedule is built so that one can play the Main Event daytime, and hop into evening events from 21:00 onwards,” shared Nousiainen. “This was a request by our players and it works great for the Team Challenge. Form a poker team of four players, come up with a fun name for the team, and start collecting points! Every time a player cashes from a Kings Of Tallinn tournament, he/ she collects points to the team! Satellites and the Ladies Event excluded. Players also get one team point for playing any of the events.” 

 

 

2023 Kings of Tallinn Key Dates

Here is a look at some of the highlights of the Kings of Tallinn. Check out the full schedule for Kings of Tallinn.


 

·        €120 Estonian Independence Day Special with added Kings Of Tallinn Tickets for Final Table: February 24

 

·        €555 NLH Championship: February 25 - 28

 

·        €150 GG Poker Flip&Go Mystery Bounty: February 27 - March 3

 

·        €350 NLH Deep Stack with €550 Ticket Added To Winner: February 27 

 

·        €350  8 Game: February 28 

 

·        €440 PLO 4 & 5 Mystery Bounty: February 28

 

·        €150 Celebrity Special: February 28 

 

·        €1,100 Kings Of Tallinn 2023 Main Event, €500,000 Guaranteed!!: March 1  - March 5

 

·        €250 Sviten Special: March 1

 

·        €550 NLH: March 1

 

·        €350 PLO 5 HI-LO: March 2

 

·        €1,100 PLO 4 & 5 Championship: March 3

 

·        €250 Deep Stack: March 3

 

·        €250 Deuce to Seven: March 3

 

·        €120 Queens Of Tallinn: March 4

 

·        €350 Open Face Chinese: March 4

 

·        €3,000 Kings Of Tallinn 2023 Highroller: March 4 - 5

 

·        €660 Mystery Bounty: March 4 – 5

 

 Photo Credit:  2022 Main Event Winner Adam Kharman, Kings of Tallinn

 

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.