0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-04' AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event/2/updates' ORDER BY `views` DESC

0.0013 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event/2/updates', 1, '2024-05-04')

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

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

0.0014 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.0014 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.0242 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.0030 SECONDS:
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, 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_stop_blogs` LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id` LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `friendly_url` = 'kings-of-tallinn-2023-main-event'

0.0008 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '13'

0.0368 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0050 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '50' AND `published` = 1

0.0198 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0044 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '52' AND `published` = 1

0.0204 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0045 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '54' AND `published` = 1

0.0198 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0044 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '57' AND `published` = 1

0.0192 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0039 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '59' AND `published` = 1

0.0190 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0043 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '61' AND `published` = 1

0.0113 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '13' AND `name` = '2'

0.0066 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '57' ORDER BY `busted` ASC, `current_chips` DESC

0.0049 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '57' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0048 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2447' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2444' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2443' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2440' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2439' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2438' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2436' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2432' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2430' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2429' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2428' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2424' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2423' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2422' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2419' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2416' ORDER BY `chip_change` DESC, `busted` ASC

0.0048 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2417' ORDER BY `chip_change` DESC, `busted` ASC

0.0154 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2414' ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2413' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2412' ORDER BY `chip_change` DESC, `busted` ASC

0.0053 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2410' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2409' ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2408' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2405' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2404' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2401' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2400' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2399' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2395' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2393' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2392' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2391' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2390' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2386' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2383' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2378' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2377' ORDER BY `chip_change` DESC, `busted` ASC

0.0101 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2376' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2373' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2371' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2367' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2365' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2363' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2362' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2361' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2360' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2358' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2354' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2351' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2350' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2349' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2347' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2344' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2338' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2337' ORDER BY `chip_change` DESC, `busted` ASC

0.0048 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '57' ORDER BY `busted` ASC, `current_chips` DESC

0.0148 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '57' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2448' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2447' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2444' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2443' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2440' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2439' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2438' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2436' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2432' ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2430' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2429' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2428' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2424' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2423' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2422' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2419' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2416' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2417' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2414' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2413' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2412' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2410' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2409' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2408' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2405' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2404' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2401' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2400' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2399' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2395' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2393' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2392' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2391' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2390' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2386' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2383' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2378' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2377' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2376' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2373' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2371' ORDER BY `chip_change` DESC, `busted` ASC

0.0237 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2367' ORDER BY `chip_change` DESC, `busted` ASC

0.0052 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2365' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2363' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2362' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2361' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2360' ORDER BY `chip_change` DESC, `busted` ASC

0.0106 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2358' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2354' ORDER BY `chip_change` DESC, `busted` ASC

0.0102 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2351' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2350' ORDER BY `chip_change` DESC, `busted` ASC

0.0344 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2349' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2347' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2344' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2338' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '2337' ORDER BY `chip_change` DESC, `busted` ASC

0.0048 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '61' ORDER BY `busted` ASC, `current_chips` DESC

0.0003 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 1912

English
King of Tallinn 2023 2023 Kings Of Tallinn €1,100 Main Event (English) Live Reporting - Day 4

Current Level 35 Current Day 4
Blinds 175,000/350,000 Ante 350000
Entries 716 Remaining 1
Prize Pool (EUR) €673,040 First Prize (EUR) €140,100
1 New Update - Click to refresh
Live Updates - Day 2
End-of-Day 2 Chip Counts Posted Friday 3rd March, 2023 at 22:17(UTC+2) by Jason Glatzer
Player Chips Big Blinds
Pavels Spirins 868,000 145
Paul Koppe 845,000 141
Ranno Sootla 614,000 102
Mika Antero Levaniemi 591,000 99
Priit Parmasto 547,000 91
Kasparas Klezys 534,000 89
Federico Luciano Cirillo 512,000 85
Sergejs Korobovs 505,000 84
Oskars Gailums 502,000 84
Yanis Mehdi Sahli 452,000 75
Niki Juhani Nurmisto 433,000 72
Javier Guinot Moya 427,000 71
Mikael A.I Niemelä 379,000 63
Lari Anttoni Pukkila 372,000 62
Aleksi Mikael Naski 366,000 61
Mohammed T. M. Al-Khazraji 362,000 60
Roope N.A Holma 358,000 60
Adria Comas I Roura 331,000 55
Leonardo Romeo 320,000 53
Antti E. E. Veteläinen 320,000 53
Davide Muccini 313,000 52
Taago Tamm 291,000 49
Magnus Pukk 290,000 48
Vu Hoang Vuong 286,000 48
Anthony Jay Kauzloric 281,000 47
Janne M. T. Nevalainen 270,000 45
Paulius Vaitiekunas 269,000 45
Jani Alexanteri Tuovinen 262,000 44
Miko Hermanni Miettinen 261,000 44
Theophile Tristan George 260,000 43
Ignas Vaitulionis 256,000 43
Michailas Miserkejevas 242,000 40
Julius Jesperi Tiihonen 241,000 40
Anatoly Filatov 228,000 38
Victor Fernandez Garcia 223,000 37
Nemo Rafael Vilpponen 221,000 37
Toni Valtteri Ylitervo 219,000 37
Arminas Nemeika 215,000 36
Ignacio Gonzalez Garrido 208,000 35
Dainius Antanaitis 206,000 34
Verneri Janne Aaron Häkkinen 197,000 33
Eirik Kristiansen 192,000 32
Albert Ostrovskij 192,000 32
Juri Vassin 185,000 31
Linus Hans Ludwig Lauermann 184,000 31
Timo Petteri Laiho 182,000 30
Sebastian Wahl 181,000 30
Tomas Kirchovas 180,000 30
Lukas Bytautas 178,000 30
Martin Piik 175,000 29
Adomas Juozapavicius 174,000 29
Francisco Jose Blanco Racionero 172,000 29
Hanno Kerem 156,000 26
Giada Fang 153,000 26
Irmantas Bzeskis 149,000 25
Grigorijus Vasilavicius 149,000 25
Rokas Barzdzius 148,000 25
Dmitrijs Arsuns 146,000 24
Gytis Bernatavicius 142,000 24
Luca Sebastiani 142,000 24
Arto E. S. Mansner 136,000 23
Roberts Rumba 136,000 23
Gintaras Naglius 135,000 23
Algirdas Saveikis 132,000 22
Gints Ozols 130,000 22
Anna-Mari Hursti 129,000 22
Albert L. E. Jonsson 122,000 20
Walter Treccarichi 122,000 20
Luigi Andrea Shehadeh 118,000 20
Kai E. J. Lehto 116,000 19
Artiom Goncarenko 115,000 19
Keito Kaljulaid 114,000 19
Mairo Tori 103,000 17
Jari M.J. Mähönen 98,000 16
Ville Heikki Juhana Konttinen 96,000 16
Marco Regonaschi 96,000 16
Steven Tool 93,000 16
Jon Ander Martinez 92,000 15
Joni S.J Rantamäki 91,000 15
Aleksandr Kuperman 89,000 15
Mart Kalju 88,000 15
Deniss Davõdov 81,000 14
Richard Koppel 76,000 13
Saulius Tumosa 73,000 12
Seppo Paavo Parkkinen 72,000 12
Airin Pindis 71,000 12
Carl Henrik Gustafsson 70,000 12
Martynas Racinskas 69,000 12
Daragh Davey 60,000 10
Vladimir Iljunin 52,000 9
Jari-Pekka Juhola 47,900 8
Justas Vaiciulionis 46,000 8
Tomas Pinkevicius 25,000 4
Day 3 Players Come Back Early! Posted Friday 3rd March, 2023 at 21:12(UTC+2) by Jason Glatzer

Kings of Tallinn Tournament Director Teresa Nousiainen announced that players should return at 11:45 a.m. tomorrow instead of 12 p.m. Please take note if you advanced with a stack.

The money bubble will approach quickly tomorrow, so it's not likely something players want to miss.

Meanwhile, it was also announced that the action is on its final three hands before Day 2 concludes. Stay tuned for the final chip counts of Day 2 of the Main Event.

Posted Friday 3rd March, 2023 at 21:05(UTC+2) by Jason Glatzer

Main Event Day 2
Level 16: 2,000/5,000 (5,000)
Entries: 96/716

Tomas Pinkevicius opened from early position and was called by Yanis Mehdi Sahli from the big blind. Sahli called bets on all three streets including a jam on the river for a 400,000 pot with the on the board. 

Pinkevicius turned over and lost the hand to Sahli who held for the top pair.

Player Chips Progress
Yanis Mehdi Sahli 400,000 293,200
Tomas Pinkevicius 100,000 70,000
Thore-Fabian Kunze 0 0
Viktor Eriksson 0 0
Roope Tarmi 0 0
Sondre Stormyr 0 0
Sixes Run Into Nines for Reigass Posted Friday 3rd March, 2023 at 20:42(UTC+2) by Jason Glatzer

Main Event Day 2
Level 16: 2,000/5,000 (5,000)
Entries: 100/716

Gatis Reigass just hit the rail. He first got his sixes in against Saulius Tumosa's nines. He had crumbs left in his stack and those were lost when his ace-trey were no good against the ace-ten held by Niki Nurmisto.

Player Chips Progress
Niki Nurmisto 450,000 374,600
Saulius Tumosa 130,000 100,000
Gatis Reigass 0 0
Posted Friday 3rd March, 2023 at 20:36(UTC+2) by Jason Glatzer

Main Event Day 2
Level 15: 2,000/4,000 (4,000)
Entries: 101/716

The final blind level of Day 2 has kicked off. There is an outside chance that the tournament will progress beyond the money bubble today with 87 players collecting at least a min-cash of €2,100 but the more likely scenario is that players will come back tomorrow and break the bubble early on Day 3.

Player Chips Progress
Osku Karttunen 0 0
Pasi Sormunen 0 0
Eirimas Tomkevicius 0 0
20:33 (UTC+2)
Start of Level 16
Blinds: 2,000/5,000     Ante: 5,000
"This is Actually a Sick Spot" Posted Friday 3rd March, 2023 at 20:21(UTC+2) by Jason Glatzer

Main Event Day 2
Level 15: 2,000/4,000 (4,000)
Entries: 106/716

Lari Pukkila checked the flop before Viktors Caikins bet 18,000 into a pot of a bit more. Linus Lauermann raised to 44,000 before Pukkila jammed for about 150,000 after tanking for a minute. Caikins tanked as well for a minute before he called off for about 65,000.

"This is actually a sick spot," said Lauermann. "I know you have aces or queens."

Lauermann shared he had ace-queen but didn't show his hand before he folded.

Viktors Caikins:
Lari Pukkila:

It was good that he listened to his read as if he had ace-queen he would be behind both players. Caikins, despite having the best hand preflop was drawing to just two outs for a better set. Neither the turn nor the river got the job done and Calkins was on the rail.

Player Chips Progress
Lari Pukkila 250,000 136,400
Linus Lauermann 150,000 0
Pekka Ikonen 0 0
Gert Laanemets 0 0
Greger Aktell 0 0
Robertas Smolskis 0 0
Viktors Caikins 0 0
Starting Time Pushed Back 30 Minutes for the 9 PM Events Posted Friday 3rd March, 2023 at 20:00(UTC+2) by Jason Glatzer

Main Event Day 2
Level 15: 2,000/4,000 (4,000)
Entries: 111/716

Both Day 2 of the €150 GGPoker Mystery Bounty Flip & Go and the €250 2-7 Pot-Limit Deuce-to-Seven Triple Draw events were scheduled for 9 p.m.

Both events have been pushed back 30 minutes and will start at 9:30 p.m. to give the staff enough time to clear out the players and bags from the Main Event.

Player Chips Progress
Henri Kasper 0 0
Timo Lamsa 0 0
Kaupo Tenno 0 0
Matias Knaapinen 0 0
Kaspars Renga 0 0
James Noonan 0 0
Mikko Ylamaki 0 0
Tommi Lankinen 0 0
Dennis Berglin 0 0
Allan Arjut 0 0
Yesterday's Recap With Laura Cornelius Posted Friday 3rd March, 2023 at 19:44(UTC+2) by Jason Glatzer

Rockets Good for Gailums Posted Friday 3rd March, 2023 at 19:40(UTC+2) by Jason Glatzer

Main Event Day 2
Level 15: 2,000/4,000 (4,000)
Entries: 122/716

Oskars Gailums opened for 12,000. Grantas Naujokas jacked it up to 40,000. Gailums three-bet to 90,000 before Naujokas four-bet shoved for 250,000. Gailums had him covered and was ahead in a massive pot with to his opponent's .

The ladies proved to be no good for Naujokas on a blank board and Gailums was among the chip leaders. 

Meanwhile, it appears that Paul Koppe has the chip lead with around 800,000 in chips.

Player Chips Progress
Paul Koppe 800,000 400,000
Oskars Gailums 660,000 410,000
Anatoly Filatov 461,000 285,400
Mika Levaniemi 419,000 277,500
Toni Ylitervo 233,000 164,800
Dainius Antanaitis 200,000 36,500
Daragh Davey 105,000 35,000
Ville Jantunen 0 0
Max Rotko 0 0
Donatas Pilinkus 0 0
Van Phung 0 0
Justas Brazlauskis 0 0
Edgars Beizaks 0 0
Kasper Mellanen 0 0
19:22 (UTC+2)
Start of Level 15
Blinds: 2,000/4,000     Ante: 4,000
Finnish Legend Aki Pyysing on the Rail Posted Friday 3rd March, 2023 at 19:02(UTC+2) by Jason Glatzer

Main Event Day 2
Level 14: 1,500/3,000 (3,000)
Entries: 131/716

Aki Pyysing just hit the rail on a big cooler. He shared with the media that he bet on every street with and ran into the held by Marco Regonaschi on a board.

We wish Pyysing the best of luck in the other event, especially if he hops into the €3,000 High Roller.

Players just went on a 20-minute break. After the break, players will play two more blind levels before bagging their stacks into Day 3.

Player Chips Progress
Marco Regonaschi 235,000 178,100
Joni Lankinen 0 0
Pekka Virtanen 0 0
Niall Farrell 0 0
Armend Sahiti 0 0
Peep Kivistik 0 0
Marita Magi 0 0
Aki Pyysing 0 0
Queens Good for Miettinen Posted Friday 3rd March, 2023 at 18:50(UTC+2) by Jason Glatzer

Main Event Day 2
Level 14: 1,500/3,000 (3,000)
Entries: 138/716

Miko Miettinen got his stack of 68,500 in against Ville Jantunen after the came on the flop.

Miko Miettinen:
Ville Jantunen:

Miettinen was ahead but he wasn't quite safe yet. Jantunen blanked both the turn and river.

Player Chips Progress
Miko Miettinen 190,000 90,800
Ville Jantunen 80,000 4,800
Joni Lankinen 0 0
Marek Selgeveer 0 0
Andrey Koks 0 0
Mathias Siljander 0 0
Vllaznin Dida 0 0
Daniel Feirer 0 0
Andzej Bilat 0 0
Andrius Bielskis 0 0
Tuomo Niemela 0 0
€140K Top Prize! Posted Friday 3rd March, 2023 at 18:32(UTC+2) by Jason Glatzer

The payouts have been announced for the 2023 Kings of Tallinn Main Event with the top 87 players guaranteed at least a €2,100 min-cash. Sunday's winner will go home much richer than that with a whopping €140,100 top prize.

Here is a look at all of the payouts:

Place Prize
1 €140,100
2 €89,800
3 €60,000
4 €40,040
5 €29,800
6 €22,500
7 €17,600
8 €14,200
9 €11,900
10 €9,800
11-12 €7,850
13-14 €6,350
15-16 €5,100
17-24 €4,200
25-32 €3,600
33-40 €3,200
41-48 €2,800
49-56 €2,500
57-72 €2,300
73-87 €2,100
GG EstonianWeirdo Posted Friday 3rd March, 2023 at 18:23(UTC+2) by Jason Glatzer

Main Event Day 2
Level 14: 1,500/3,000 (3,000)
Entries: 148/716

Eirik Kristiansen eliminated Mairo "EstonianWeirdo" Toom after the duo got it in on a flop for about 15 big blinds.

Toom held and was unable to get any help to survive against Kristiansen's .

Player Chips Progress
Eirik Kristiansen 225,000 165,700
Lasse Enojarvi 0 0
Kasso Laasik 0 0
Toivo Rinne 0 0
Elias Vaaraniemi 0 0
Donatas Kiauleikis 0 0
Niklas Vakkuri 0 0
Ivar Simmer 0 0
Marko Keskel 0 0
Lasse Enojarvi 0 0
Mairo Toom 0 0
Miko Ylikoski 0 0
Moya Wins a Three-Way Pot Posted Friday 3rd March, 2023 at 18:06(UTC+2) by Jason Glatzer

Main Event Day 2
Level 14: 1,500/3,000 (3,000)
Entries: 159/716

Eero Lehtinen jammed for about 10 big blinds from early position. Javier Moya three-bet shoved for 75,000 from one seat over and both players were up against the start-of-the-day chip leader Julius Tiihonen.

Eero Lehtinen:
Javier Moya:
Julius Tiihonen:

Moya's ace-queen improved to a straight to double through Tiihonen and eliminate Lehtinen with a lower straight after the

Player Chips Progress
Julius Tiihonen 265,000 85,000
Javier Guinot Moya 175,000 114,000
Matiss Celmins 0 0
Justas Semaska 0 0
Rain Molderkivi 0 0
Henri Schalin 0 0
Raimo Kaljulaid 0 0
Yuzhou Yin 0 0
Petri Paakkonen 0 0
Andrei Mjagkov 0 0
Alf Hjartberg 0 0
Mikael Wulff 0 0
Madis Ormisson 0 0
Mauri Dorbek 0 0
Ilari Sahamies 0 0
Eero Lehtinen 0 0
18:05 (UTC+2)
Start of Level 14
Blinds: 1,500/3,000     Ante: 3,000
Various Chip Counts Posted Friday 3rd March, 2023 at 17:40(UTC+2) by Jason Glatzer
Player Chips Progress
Paul Koppe 400,000 243,000
Julius Tiihonen 350,000 106,000
Ignas Vaitulionis 330,000 237,300
Pavels Spirins 300,000 251,600
Jari-Pekka Juhola 300,000 230,400
Anatoly Filatov 300,000 124,400
Yanis Mehdi Sahli 285,000 178,200
Grantas Naujokas 280,000 156,600
Arto Mansner 270,000 240,000
Francisco Racionero 260,000 115,700
Grigorijus Vasilavicius 250,000 228,600
Donatas Pilinkus 250,000 207,300
Kasparas Klezys 245,000 45,000
Irmantas Bzeskis 230,000 169,400
Eirimas Tomkevicius 230,000 121,400
Jani Tuovinen 230,000 10,000
Gytis Bernatavicius 230,000 10,000
Anthony Kauzloric 210,000 72,900
Priit Parmasto 210,000 62,000
Davide Muccini 200,000 90,000
Sondre Stormyr 190,000 121,000
Daragh Davey 140,000 92,600
Ranno Sootla 120,000 90,000
Niall Farrell 90,000 10,000
Toom Runs Into Rockets Posted Friday 3rd March, 2023 at 17:31(UTC+2) by Jason Glatzer

Main Event Day 2
Level 13: 1,000/2,500 (2,500)
Entries: 172/716

Mairo Toom four-bet jammed from under the gun and was called by Kaspars Renga from middle position for his stack of 63,000.

Kaspars Renga:
Mairo Toom:

"Oh no!" said Toom, who streams online under the "EstonianWeirdo" Twitch name.

Renga's rockets were more than OK after the ran out on board.

Player Chips Progress
Kaspars Renga 135,000 22,400
Mairo Toom 95,000 22,100
Justas Semaska 0 0
Matiss Celmins 0 0
Dan Larsson 0 0
Teemu Kailasvuo 0 0
Markus Ylanne 0 0
Julius Dagys 0 0
Julien Fuchs 0 0
Mario Jurgens 0 0
Ryhor Karapanau 0 0
Table 13 Moved to the TV Table Posted Friday 3rd March, 2023 at 17:16(UTC+2) by Jason Glatzer

Main Event Day 2
Level 13: 1,000/2,500 (2,500)
Entries: 181/716

Table 13 has moved to the TV table featuring EPT Paris final tablist Henri Kasper, online poker legend Ilari "Ziigmund" Sahamies, Dainius Antanaitis, and more. You can check out the live stream at the Kings of Tallinn website by clicking on the live stream in the menu or at Main Event Travel.

Here is a look at the chip counts of those playing:

Player Chips Progress
Dainius Antanaitis 163,500 14,400
Toivo Rinne 156,500 62,600
Mika Levaniemi 141,500 81,500
Anna-Mari Hursti 92,500 47,700
Mart Kalju 83,000 75,000
Ilari Sahamies 69,500 34,100
Henri Kasper 64,500 24,900
Marek Selgeveer 46,000 17,200
Tuomo Niemela 30,500 44,500
Jacks Good for Schalin Posted Friday 3rd March, 2023 at 17:08(UTC+2) by Jason Glatzer

Main Event Day 2
Level 13: 1,000/2,500 (2,500)
Entries: 185/716

Henri Schalin three-bet jammed for 29,000 from the small blind and was called by Roope Holma, who opened from middle position.

Henri Schalin:
Roope Holma:

The fish hooks held for Schalin after Holma's fives got nowhere on the board to earn a much-needed double.

Player Chips Progress
Henri Schalin 70,000 20,900
Roope Holma 0 195,900
Touko Berndtson 0 0
Eliminations Before the Break Posted Friday 3rd March, 2023 at 17:05(UTC+2) by Jason Glatzer
Player Chips Progress
Stanislav Smeljov 0 0
Vytautas Kacerauskas 0 0
Laurynas Cerniauskas 0 0
Teemu Toikkanen 0 0
Kristian Kostiander 0 0
Nikita Staroverov 0 0
Hannes Keskkula 0 0
Zydrunas Karcemarskas 0 0
Jyrki Lampinen 0 0
Ricardas Zygis 0 0
Vadim Kiseliov 0 0
Mark Berman 0 0
Evert Andersson 0 0
Victor Prior Fernandez Amat 0 0
Mark Metsla 0 0
Elias Suhonen 0 0
Miika Toyras 0 0
Tapio Aaltonen 0 0
17:01 (UTC+2)
Start of Level 13
Blinds: 1,000/2,500     Ante: 2,500
Second Break Posted Friday 3rd March, 2023 at 16:43(UTC+2) by Jason Glatzer

Players are on their second short break. The blinds will increase to 1,000/2,500 with a 2,500 big blind ante.

Posted Friday 3rd March, 2023 at 16:41(UTC+2) by Jason Glatzer

Main Event Day 2
Level 12: 1,000/2,000 (2,000)
Entries: 195/716

Vadim Kiseliov bet 6,500 on the flop. Jani Tuovinen min-clicked it back to 13,000. Laanemets jammed for 60,000 and Touvinen called.

Vadim Kiseliov:
Jani Tuovinen:

Touvinen was ahead with his set but Kiseliov had plenty of outs with an open-ended straight draw and a draw to a better set. Neither draw completed with the turn and river completing the board.

Player Chips Progress
Andrey Koks 280,000 236,600
Jani Tuovinen 240,000 168,000
Kasparas Klezys 200,000 169,400
Gert Laanemets 135,000 10,700
Win a Battle of Malta Package Posted Friday 3rd March, 2023 at 16:29(UTC+2) by Jason Glatzer

The Battle of Malta is in the house and you might want to visit them as they are giving away two packages to the 2023 Battle of Malta Spring Edition at Casino Malta on May 31 to June 6.

The package includes both hotel accommodation and the €600 buy-in to the €500,000 Main Event! 

We will be there and hope to see you there as well!

Posted Friday 3rd March, 2023 at 16:21(UTC+2) by Jason Glatzer

Main Event Day 2
Level 12: 1,000/2,000 (2,000)
Entries: 204/716

Player Chips Progress
Annika Anni 0 0
Martin Haidberg 0 0
Yaniv Peretz 0 0
Josep Pastor De Ramon 0 0
Aleksei Smirnov 0 0
Kyle Maguire 0 0
Beratavicius Takes Out Two with Rockets Posted Friday 3rd March, 2023 at 16:06(UTC+2) by Jason Glatzer

Main Event Day 2
Level 12: 1,000/2,000 (2,000)
Entries: 216/716

Herli Olop jammed for less than 10 big blinds from early position before Virgo Laansoo came in over the top for 45,000 from one seat over. Gytis Bernatavicius called both players from the hijack and it was a three-way showdown.

Herli Olop:
Virgo Laansoo:
Gytis Bernatavicius:

"Oh my god," said Olop as he got out of his chair seeing how thin he was drawing.

Bernatavicius's hand was able to hold with the running out on the board to oust both Olop and Laansoo.

Player Chips Progress
Gytis Bernatavicius 240,000 169,100
Uri Gilboa 0 0
Jimmy Dewerdt 0 0
Antti Tuomi 0 0
Johan Creutz 0 0
Juuso Lepisto 0 0
Anne Bezdek 0 0
Annie Chen 0 0
Virgo Laansoo 0 0
Herli Olop 0 0
Tarmo Tammel 0 0
"I Have a Straight" Posted Friday 3rd March, 2023 at 15:52(UTC+2) by Jason Glatzer

Main Event Day 2
Level 11: 800/1,600 (1,600)
Entries: 227/716

Jaana Kindsigo had a handful of big blinds while in the big blind when she got them in against Justas Vaiciulionis, who opened from middle position.

Jaana Kindsigo:
Justas Vaiciulionis:

The ran out on the board.

"Seat open!" the dealer shouted.

"I have a straight," said Kindsigo who was already out of her chair. "Ah, he has a flush."

Player Chips Progress
Justas Vaiciulionis 70,000 40,000
Jaana Kindsigo 0 0
Krzysztof Romanow 0 0
Visa Kiviharju 0 0
Carl Lockmer 0 0
Recent Eliminations Posted Friday 3rd March, 2023 at 15:46(UTC+2) by Jason Glatzer
Player Chips Progress
Arkadiusz Liszewski 0 0
Jan Granlund 0 0
Johan Martinsen 0 0
Mantas Bagocius 0 0
Kasperi Ilkka 0 0
Martynas Vitkauskas 0 0
Miska Vihervuori 0 0
Igor Pihela Jr. 0 0
Davis Modans 0 0
15:44 (UTC+2)
Start of Level 12
Blinds: 1,000/2,000     Ante: 2,000
Posted Friday 3rd March, 2023 at 15:44(UTC+2) by Jason Glatzer

Main Event Day 2
Level 11: 800/1,600 (1,600)
Entries: 233/716

Erkki Kaira jammed less than 10 big blinds from the cutoff before Andrei Mjagkov three-bet shoved for 27,000 from the button. The rest of the table folded and the flip was on.

Erkki Kaira:
Andrei Mjagkov:

Kaira was unable to win the flip after Mjagkov improved to trip queens on the board.

Player Chips Progress
Albert Ostrovskij 100,000 70,500
Petri Paakkonen 95,000 21,400
Martin Piik 90,000 53,100
Andrei Mjagkov 55,000 600
Erkki Kaira 0 0
Recent Eliminations Posted Friday 3rd March, 2023 at 15:40(UTC+2) by Jason Glatzer

Main Event Day 2
Level 11: 800/1,600 (1,600)
Entries: 240/716

Player Chips Progress
Andrejs Stenickins 0 0
Ermo Kosk 0 0
Hamizs Jaralijevs 0 0
Bartosz Mielczarek 0 0
Nico Sauerland 0 0
Gediminas Dirmantas 0 0
Heikki Piira 0 0
Michael Ibba 0 0
Leevi Laiho 0 0
Johan Karlsson 0 0
Tomi Arponen 0 0
Juho Suutari 0 0
Julius Kettunen 0 0
Stanislovas Vinicenka 0 0
Kaspar Valk 0 0
Renato Messina 0 0
Totti Arosuo 0 0
Samuel Richards 0 0
Ilja-Ulo Nukka 0 0
Markku Koplimaa 0 0
Arturs Barkevics 0 0
Mohamed Barre Mohamud 0 0
Santtu Leinonen 0 0
Top Pair Good for Brazlauskis Posted Friday 3rd March, 2023 at 15:25(UTC+2) by Jason Glatzer

Main Event Day 2
Level 11: 800/1,600 (1,600)
Entries: 244/716

Justas Brazlauskis opened from middle position for 6,000 and was called by Taago Tamm from the small blind and Gatis Reigass from the big blind.

Tamm and Reigass checked the flop. Brazlauskis over-bet the pot for 27,000. Tamm jammed over the top for about 250,000. Reigass folded and Brazlauskis went into the tank for more than a minute before he called off for 116,000.

Justas Brazlauskis:
Taago Tamm:

The race was on with Brazlauskis holding top pair and Tamm with middle pair and a flush draw. Tamm bricked both the turn and river to double up Brazlauskis in a huge pot.

Player Chips Progress
Justas Brazlauskis 255,000 225,000
Taago Tamm 140,000 110,000
Gatis Reigass 70,000 40,000
Edgars Beizaks the G.O.A.T. Posted Friday 3rd March, 2023 at 15:00(UTC+2) by Jason Glatzer

Main Event Day 2
Level 11: 800/1,600 (1,600)
Entries: 265/716

Edgars Beizaks caught up with us on the break and said you must share how I am the G.O.A.T. (Greatest of All Time). 

We walked by his table and he was at around 40,000.

"Just wait, I will be on more than 100,000 soon," Beizaks shared.

Madis Ormisson then joined the table with about 60,000. Beizaks seemed pleased.

"Ah, a fish I can get chips from," Beizaks joked about his poker friend. 

"The Latvians are always dreaming," Ormisson said as the table was getting ready for the next hand.

Meanwhile, here is a look at some of the eliminations on Day 2.

Player Chips Progress
Madis Ormisson 60,000 18,100
Edgars Beizaks 40,000 10,000
Allesandro Giordano 0 0
Mikk Sibrits 0 0
Lassi Kolari 0 0
Anttu Hurnanen 0 0
Maksim Petrov 0 0
Benas Jakusevas 0 0
Henri Piironen 0 0
Rauno Arras 0 0
Arturs Martinsons 0 0
Vasilij Barna 0 0
Donatas Simas 0 0
Mati Pirn 0 0
Jaakko Tirkkonen 0 0
Tomi Lehtinen 0 0
Marius Verikas 0 0
Max Avela 0 0
Jussi Mattila 0 0
Giovanni Nava 0 0
Inigo Martin 0 0
Jari Lahtinen 0 0
Erki Andressoo 0 0
Raini Lelle 0 0
Kristo Kadastik 0 0
Jevgeni Voitovits 0 0
Andrei Silencov 0 0
Sven Reimaa 0 0
Egle Geniene 0 0
Kristaps Renga 0 0
Jari Porkka 0 0
Sandris Mukans 0 0
Magnus Pukk 0 0
Marius Morel 0 0
Kaius Kiidli 0 0
Augustas Masaitis 0 0
Romans Krasins 0 0
Iiro Kettunen 0 0
Joonas Lyttinen 0 0
Jari-Pekka Rattya 0 0
Tuomas Roppanen 0 0
Priit Vallap 0 0
Dainius Balynas 0 0
Dmitri Dudakov 0 0
Tomi Hietala 0 0
Margus Tuvikene 0 0
Vadim Guk 0 0
Luca Beretta 0 0
Keimo Suominen 0 0
Taniel Soorumaa 0 0
Mykola Shapovalov 0 0
Artjoms Skvarkovskis 0 0
Herli Olop 0 0
Matti Lasanen 0 0
Audrius Laimelis 0 0
Jukka Perala 0 0
Jose Antoni Gonzalez Zaragoza 0 0
Siim Pindis 0 0
Oskaras Valteris 0 0
Vitalii Shcherba 0 0
Leevi Lindstedt 0 0
Stefan Bergstrom 0 0
Hanli Xiong 0 0
Hannes Praks 0 0
Posted Friday 3rd March, 2023 at 14:45(UTC+2) by Jason Glatzer

Main Event Day 2
Level 11: 800/1,600 (1,600)
Entries: 270/716

Late registration is now closed for the Main Event. The field unofficially attracted 716 entries to generate a €673,040 prize pool.

The staff is double-checking all the figures before this will be official. If it is off, it won't be by much. We will update again if the figures change and again once the payouts are announced.

14:41 (UTC+2)
Start of Level 11
Blinds: 800/1,600     Ante: 1,600
TV Table Line-Up Posted Friday 3rd March, 2023 at 14:41(UTC+2) by Jason Glatzer

Henri Kasper busted before the break, so he won't be at the TV table. Many other interesting players including Giada Fang will be. Here is a look at the line-up and their chip counts.

Player Chips Progress
Albert Jonsson 144,500 28,300
Sergejs Korobovs 139,900 30,000
Carl Gustafsson 125,900 45,200
Giada Fang 104,600 63,100
Peter Hanko 49,900 2,400
Evert Andersson 47,800 15,600
Mario Jurgens 39,300 13,000
Airin Pindis 34,600 8,000
700 Entries and Final Three Hands of Late Registration Posted Friday 3rd March, 2023 at 14:13(UTC+2) by Jason Glatzer

Main Event Day 2
Level 10: 600/1,200 (1,200)
Entries: 267/701

The Main Event has reached 700 entries! Amazing job to all the players and staff!

The field will grow slightly as the final three hands were announced. After this, players can still enter or re-enter on the 20-minute break.

Also of note is that the live stream with both recent EPT Paris final tablist Henri Kasper, Giada Fang, Albert Jonsson, and others will begin.

Kadanik Delivers a Bad Beat to Kacerauskas Posted Friday 3rd March, 2023 at 14:09(UTC+2) by Jason Glatzer

Main Event Day 2
Level 10: 600/1,200 (1,200)
Entries: 268/699

Alari Kadanik limped from under the gun before Antti Tuomi raised to 4,000. Vytautas Kacerauskas three-bet to 8,500. Kadanik four-bet jammed for slightly more than a starting stack. Toumi folded and Kacerauskas called.

Alari Kadanik:
Vytautas Kacerauskas:

Kacerauskas was ahead but poker can be cruel at times. This was one of those times with Kadanik finding a partner for his queen on the board.

Saveikis Wins a Flip Against Wall Posted Friday 3rd March, 2023 at 13:54(UTC+2) by Jason Glatzer

Main Event Day 2
Level 10: 600/1,200 (1,200)
Entries: 280/689

Algirdas Saveikis limped from early position. Another player called before Sebastian Wahl raised to 2,400. Saveikis jacked it up to 8,500. The other player in the hand folded before Wahl jammed his big stack. Saveikis called off for 22,500 in total and the cards were turned over.

Algirdas Saveikis:
Sebastian Wahl:

Wahl was ahead on the flip after both the flop and the turn. That all changed with the spiking the river to improve Saveikis to a better pair and win the pot.

Player Chips Progress
Sebastian Wahl 160,000 58,900
Algirdas Saveikis 50,000 200
Mattila Misses His Double Gutter Against Lauermann Posted Friday 3rd March, 2023 at 13:40(UTC+2) by Jason Glatzer

Main Event Day 2
Level 10: 600/1,200 (1,200)
Entries: 294/684

Jussi Mattila jammed for slightly less than a starting stack with the on the board after the floor. Linus Lauermann called and another player at the table folded.

Jussi Mattila:
Linus Lauermann:

"Well, at least I am ahead this time," Lauermann said in a friendly manner to Mattila. "At least you can re-enter if you don't get there."

Mattila was behind but had some hope with a double-gutshot straight draw. The turn and river weren't the cards Mattila needed to get ahead and he lost his stack to Lauermann.

"I plan to re-enter, but first I will grab something to eat," Mattila shared with us from the rail after the hand.

Player Chips Progress
Linus Lauermann 150,000 7,800
Jussi Mattila 0 0
Posted Friday 3rd March, 2023 at 13:28(UTC+2) by Jason Glatzer

Main Event Day 2
Level 10: 600/1,200 (1,200)
Entries: 296/678

Arturs Martinsons limped from early position. Jimmy Dewerdt raised to 4,000 from the button. Martinsons jammed for about 25,000 and Dewerdt snap-called.

Arturs Martinsons:
Jimmy Dewerdt:

Martinsons seemed to know that his ace-nine suited wasn't going to get there against nines as he stood up and took a few steps away from the table. His intuition was correct as he bricked the board to lose his stack to Dewerdt.

Player Chips Progress
Jimmy Dewerdt 80,000 42,700
Arturs Martinsons 0 0
New Kings of Tallinn Record Posted Friday 3rd March, 2023 at 13:22(UTC+2) by Jason Glatzer

Main Event Day 2
Level 10: 600/1,200 (1,200)
Entries: 300/675

The 2023 Kings of Tallinn is officially the biggest in the festival's history with 675 entries and counting. This beats the previous record of 674 entries just before the pandemic in 2020.

Special thanks to all of the players and staff for making this a historic event!

Late Registration Closes After This Blind Level Posted Friday 3rd March, 2023 at 13:20(UTC+2) by Jason Glatzer

As a reminder to all of the players, late registration will close after this level. Players can still re-enter on the 20-minute break that will follow but after this time the field will be locked.

We will then know and share the official prize pool and payouts before the second level once everything is double-checked and confirmed.

Set of Sixes for Farrell Posted Friday 3rd March, 2023 at 13:19(UTC+2) by Jason Glatzer

Main Event Day 2
Level 10: 600/1,200 (1,200)
Entries: 302/673

Pasi Sormunen jammed for 22,000 into a pot of a bit less with the on the board after the turn. GGPoker Ambassador Niall Farrell asked for a count before he called, while Uri Gilboa folded.

Pasi Sormunen:
Niall Farrell:

"Set?" Sormunen rhetorically asked.

Sormunen was drawing dead and got up from the table before the river completed the action.

Player Chips Progress
Niall Farrell 80,000 23,800
Pasi Sormunen 0 0
13:16 (UTC+2)
Start of Level 10
Blinds: 600/1,200     Ante: 1,200
Berndtson's Bluff Picked Off by Muccine Posted Friday 3rd March, 2023 at 12:56(UTC+2) by Jason Glatzer

Main Event Day 2
Level 9: 500/1,000 (1,000)
Entries: 319/652

Davide Muccine began today with less than a starting stack and has had a heck of a run and is about double the average stack mostly thanks to the following hand.

Touko Berndtson jammed tons more than the pot on the double-paired board. Muccine went into the tank for several minutes before a player called time. With about 15 seconds left, Muccine found a hero call.

Berndtson turned over . As his pair was lower than the pairs on the board, he basically had a nine kicker to the board. Meanwhile, Muccine made a gutsy call with to win the hand with his ace kicker.

"It is good the clock was called," commented Eirimas Tomkevicius, who was also at the table. "You may have talked yourself into a fold if you had more time."

Muccine neither confirmed nor denied that statement and after building his stack he left the room for an unscheduled break.

Player Chips Progress
Davide Muccini 110,000 91,500
Touko Berndtson 40,000 56,800
Lucky Treys for Brazlauskis Posted Friday 3rd March, 2023 at 12:42(UTC+2) by Jason Glatzer

Main Event Day 2
Level 9: 500/1,000 (1,000)
Entries: 324/646

The prize pool has just surpassed €600,000 and is growing fast early on Day 2. Roman Krasins will be one of the players that will need to re-enter if he wants to grab a slice of the pie after the following hand.

Augustas Masaitis opened for 2,200 from under the gun before Roman Krasins jammed for 15,000 from middle position. Justas Brazlauskis called from the small blind before Masaitis jammed for more than 100,000. Brazlauskis called off his stack of 42,200 and the cards and the players were off to the races.

Roman Krasins:
Justas Brazlauskis:
Augustas Masaitis:

Brazlauskis was in a bit of trouble when the chips got in but that all changed after he hit a set of treys on the flop. His set held after the turn and river completed the board to double through Masaitis and send Krasins to the rail.

Player Chips Progress
Justas Semaska 100,000 42,200
Augustas Masaitis 85,000 21,000
Romans Krasins 0 0
Gailums Wins Massive Pot With a Flush Posted Friday 3rd March, 2023 at 12:27(UTC+2) by Jason Glatzer

Main Event Day 2
Level 9: 500/1,000 (1,000)
Entries: 331/638

Pasi Sormunen three-bet jammed after the turn with the 9h] on the board. Oskars Gailums called to create a 250,000 pot and his opponent drawing dead.

Oskar Gailums:
Pasi Sormunen:

Sormunen had a straight but this wasn't good against Gailums' flush. The inconsequently completed the board on the river for Gailums to win a massive pot and leave Sormunen short on chips.

Player Chips Progress
Oskars Gailums 250,000 108,300
Pasi Sormunen 20,000 103,800
Nines No Good for Holma Posted Friday 3rd March, 2023 at 12:18(UTC+2) by Jason Glatzer

Main Event Day 2
Level 9: 500/1,000 (1,000)
Entries: 330/635

Audrius Laimelis opened for 2,200 from early position. Roope Holma jammed for 17,600 from the hijack. Federico Cirillo called from the cutoff and Laimelis folded.

Roope Holma:
Federico Cirillo:

Things went from bad to worse for Holma after his opponent improved to a set on the flop. The turn and river completed the board and Holme was one of the early players on the rail after running into Cirillo's full house.

Player Chips Progress
Federico Cirillo 100,000 28,400
Roope Holma 0 0
Shuffle Up and Deal Posted Friday 3rd March, 2023 at 12:08(UTC+2) by Jason Glatzer

Main Event Day 2
Level 9: 500/1,000 (1,000)
Entries: 331/630

The Main Event has just kicked off after some preliminary announcements by the tournament staff. There were already 26 new entries to bring the field up to 624 and counting.

Best of luck to all the players batting it out today for Kings of Tallinn glory!

Julius Tiihonen Leads Entering Day 2 Posted Friday 3rd March, 2023 at 10:41(UTC+2) by Jason Glatzer

The 2023 Kings of Tallinn €1,100 Main Event attracted 604 entries during the three opening flights with 305 players advancing to Friday's Day 2. The prize pool blossomed to €567,760 to smash the €500,000 guarantee.

This is not all as thanks to late registration remaining open with unlimited re-entries during the first two blind levels of Day 2, the field and prize pool will continue to grow. Now all eyes are on whether a new record will be set for this event.

The previous record took place just before the pandemic in 2020 when 674 entries came out in full force to generate a €640,300 prize pool. Johan Karlsson, who is in this year's Main Event field, won that event for €126,300 after agreeing to a heads-up deal with Ermo Kosk before defeating him in heads-up play. Will a new record be set? Time will tell.

The plan for today is to play eight blind levels of 60 minutes each starting with 500/1,000 and a 1,000 big ante. This equates to 30 big blinds for those entering or re-entering at the start of Day 2.

Julius Tiihonen will enter today as the chip leader after parlaying his 30,000 opening stack into 244,000 in chips on Day 1a. No other player bagged more than 200,000 in chips but several came close including Day 1b chip leader Dennis Berglin (192,000), GGPoker Ambassador Anatoly Filatov (175,600), Tommi Lankinen (174,800), and Armend Sahiti (173,700).

The action will kick off at noon. Stay tuned to watch the 2023 Kings of Tallinn unfold.

Day 2 Seat Draw Posted Friday 3rd March, 2023 at 02:16(UTC+2) by Jason Glatzer
Table Seat Player Chips Big Blinds
                 1 1 Sven Reimaa 93,900 94
                 1 2 Herli Olop 43,300 43
                 1 3 Kyle Hugh Maguire 24,800 25
                 1 5 Magnus Pukk 52,800 53
                 1 6 Kaspars Renga 112,600 113
                 1 7 Jari-Pekka Juhola 69,600 70
                 1 8 Adomas Juozapavicius 54,400 54
                 1 9 Johan Mikael Martinsen 23,700 24
 
                 2 1 Nemo Rafael Vilpponen 62,600 63
                 2 2 Miko Hermanni Miettinen 99,200 99
                 2 3 Margus Tuvikene 11,600 12
                 2 4 Joni S.J Rantamäki 85,000 85
                 2 6 Mairo Tori 118,400 118
                 2 7 Artiom Goncarenko 80,800 81
                 2 8 Siim Pindis 12,600 13
                 2 9 Lukas Bytautas 19,000 19
 
                 3 1 Jevgeni Voitovits 62,800 63
                 3 2 Grantas Naujokas 123,400 123
                 3 4 Mathias H. M. Siljander 87,200 87
                 3 5 Hans Stefan Bergström 36,900 37
                 3 6 Javier Guinot Moya 61,000 61
                 3 7 Julius Jesperi Tiihonen 244,000 244
                 3 8 Nico Sauerland 43,800 44
                 3 9 Kaspar Valk 47,200 47
 
                 4 1 Ignas Vaitulionis 92,700 93
                 4 2 Lari Anttoni Pukkila 113,600 114
                 4 3 Giovanni Nava 61,800 62
                 4 4 Martin Häidberg 30,100 30
                 4 5 Zydrunas Karcemarskas 83,700 84
                 4 6 Michailas Miserkejevas 116,400 116
                 4 7 Andrei Silencov 11,500 12
                 4 8 Santtu Kalevi Leinonen 135,600 136
 
                 5 1 Henri Sebastian Piironen 17,000 17
                 5 2 Carl Henrik Gustafsson 80,700 81
                 5 3 Evert J. A. Andersson 32,200 32
                 5 4 Albert L. E. Jonsson 116,200 116
                 5 5 Airin Pindis 42,600 43
                 5 6 Donatas Simas 92,300 92
                 5 8 Sergejs Korobovs 109,900 110
                 5 9 Giada Fang 41,500 42
 
                 6 1 Ville Heikki Juhana Konttinen 115,800 116
                 6 2 Roope N.A Holma 20,500 21
                 6 3 Kristian E. V. Kostiander 36,900 37
                 6 4 Samuli Tero Hietala 65,800 66
                 6 5 Ivar Simmer 29,700 30
                 6 6 Kasper J. O. Mellanen 101,400 101
                 6 7 Max August Avela 96,000 96
                 6 9 Hannes Praks 10,000 10
 
                 7 1 Seppo Paavo Parkkinen 51,300 51
                 7 2 Dominik Ostrowski 34,000 34
                 7 3 Jyrki Olavi Lampinen 32,900 33
                 7 4 Jaana Kindsigo 79,600 80
                 7 5 Bartosz Mielczarek 43,800 44
                 7 6 Aleksi Mikael Naski 50,400 50
                 7 7 Pekka Samuli Ikonen 75,000 75
                 7 8 Markus Tapio Ylänne 26,300 26
 
                 8 1 Touko Teivonpoika Berndtson 96,800 97
                 8 2 Mykola Shapovalov 52,400 52
                 8 3 Eirimas Tomkevicius 108,600 109
                 8 4 Davide Muccini 18,500 19
                 8 5 Martynas Vitkauskas 18,000 18
                 8 6 Iiro Mikael Kettunen 49,500 50
                 8 7 Andzej Bilat 69,000 69
                 8 9 Grigorijus Vasilavicius 21,400 21
 
                 9 1 Kasparas Klezys 30,600 31
                 9 2 Peeter Talviste 54,800 55
                 9 3 Kaupo Tenno 53,100 53
                 9 4 Sondre Stormyr 69,000 69
                 9 5 Annika Anni 54,400 54
                 9 7 Jari M.J. Mähönen 136,300 136
                 9 8 Raimo Kaljulaid 40,700 41
                 9 9 Richard Koppel 45,800 46
 
               10 2 Theophile Tristan George 62,300 62
               10 3 Vadim Guk 21,700 22
               10 4 Leonardo Romeo 86,000 86
               10 5 Tomi Tapani Arponen 26,400 26
               10 6 Deniss Davõdov 20,600 21
               10 7 Rauno Arras 14,600 15
               10 8 Stanislav Smeljov 84,900 85
               10 9 Aleksandr Kuperman 60,900 61
 
               11 1 Alari Kadanik 66,000 66
               11 2 Aleksei Smirnov 95,800 96
               11 3 Adria Comas I Roura 93,500 94
               11 4 Antti Tapani Tuomi 79,200 79
               11 5 Vytautas Kacerauskas 88,500 89
               11 6 Mikael A.I Niemelä 38,600 39
               11 7 Mantas Bagocius 55,500 56
               11 8 Marco Regonaschi 56,900 57
 
               12 1 Rain Mölderkivi 29,000 29
               12 2 Jimmy Philippe Dewerdt 37,300 37
               12 3 Audrius Laimelis 27,700 28
               12 4 Miko Sakari Ylikoski 105,300 105
               12 5 Keito Kaljulaid 17,600 18
               12 7 Federico Luciano Cirillo 71,600 72
               12 8 Raini Lelle 39,100 39
               12 9 Marita Mägi 51,500 52
 
               13 1 Tarmo Tammel 15,000 15
               13 3 Mika Antero Levaniemi 60,000 60
               13 4 Tuomo Kalervo Niemelä 75,000 75
               13 5 Marek Selgeveer 63,200 63
               13 6 Toivo O. T. Rinne 93,900 94
               13 7 Mart Kalju 158,000 158
               13 8 Ilari Aaretti Sahamies 35,400 35
               13 9 James Noonan 23,100 23
 
               14 1 Juho Joonas V Suutari 54,200 54
               14 2 Juuso Samuel Tiitus Lepistö 58,700 59
               14 3 Mikko Tapani Ylämäki 56,400 56
               14 5 Samuel Thomas Richards 50,100 50
               14 6 Pavels Spirins 48,400 48
               14 7 Viktor E. P. Eriksson 21,500 22
               14 8 Vitalii Shcherba 11,000 11
               14 9 Jose Antoni Gonzalez Zaragoza 15,200 15
 
               15 2 Joni H.C Lankinen 67,400 67
               15 3 Gert Laanemets 124,300 124
               15 4 Laurynas Cerniauskas 21,000 21
               15 5 Pekka Aulis Kristian Virtanen 49,000 49
               15 6 Benjamin Arthur Victor Gros 83,900 84
               15 7 Miika Samuli Töyräs 42,000 42
               15 8 Taavi Tamm 16,000 16
               15 9 Ermo Kosk 37,500 38
 
               16 1 Jukka T. J. Perälä 49,700 50
               16 2 Hannes Keskküla 46,200 46
               16 3 Dan Erik Sebastian Larsson 58,100 58
               16 4 Mauri Kristjan Dorbek 69,200 69
               16 5 Maksim Petrov 6,000 6
               16 7 Julien Lauren Fuchs 68,500 69
               16 8 Elias L. B. Suhonen 40,000 40
               16 9 Hanno Kerem 77,500 78
 
               17 1 Andrejs Stenickins 21,000 21
               17 2 Henri Mikael Schalin 49,100 49
               17 3 Hanli Xiong 26,700 27
               17 4 Kasso Laasik 110,000 110
               17 5 Michael Ibba 41,200 41
               17 6 Josep Pastor De Ramon 97,800 98
               17 8 Victor Fernandez Garcia 20,300 20
               17 9 Mati Pirn 18,000 18
 
               18 1 Luca Sebastiani 54,300 54
               18 2 Timo Petteri Laiho 44,800 45
               18 3 Algirdas Saveikis 50,200 50
               18 4 Markku Koplimaa 80,700 81
               18 5 Renato Messina 47,900 48
               18 6 Andrius Bielskis 43,900 44
               18 7 Roberts Rumba 168,700 169
               18 9 Annie Chen 25,800 26
 
               19 1 Arminas Nemeika 87,000 87
               19 2 Miska Kasperi Vihervuori 72,300 72
               19 3 Jari Juhani Lahtinen 63,400 63
               19 5 Hamizs Jaralijevs 66,600 67
               19 6 Henri Käsper 39,600 40
               19 7 Mohamed Barre Mohamud 17,400 17
               19 8 Jani Alexanteri Tuovinen 72,000 72
               19 9 Donatas Kiauleikis 20,600 21
 
               20 1 Leevi Petteri Laiho 26,400 26
               20 2 Anthony Jay Kauzloric 137,100 137
               20 3 Marius Morel 24,500 25
               20 4 Sandris Mukans 27,400 27
               20 5 Erki Andressoo 30,700 31
               20 6 Robertas Smolskis 16,500 17
               20 7 Benas Jakusevas 36,900 37
               20 8 Heikki Juhani Piira 45,000 45
 
               21 1 Visa V. V. Kiviharju 55,300 55
               21 2 Oskars Gailums 141,700 142
               21 3 Niall Farrell 56,200 56
               21 4 Uri Gilboa 112,100 112
               21 5 Dagys Julius 65,000 65
               21 6 Niki Juhani Nurmisto 75,400 75
               21 7 Tapio Ilmari Aaltonen 71,200 71
               21 8 Pasi Tapani Sormunen 123,800 124
 
               22 1 Jari Tapio Kärkkäinen 27,900 28
               22 2 Lassi Kolari 36,700 37
               22 3 Irmantas Bzeskis 60,600 61
               22 4 Vladimir Iljunin 22,900 23
               22 5 Teemu Tuomas Kailasvuo 19,400 19
               22 6 Mohammed T. M. Al-Khazraji 106,300 106
               22 8 Tommi Petteri Lankinen 174,800 175
               22 9 Madis Ormisson 41,900 42
 
               23 1 Virgo Laansoo 63,000 63
               23 2 Inigo Naveiro Martin 20,800 21
               23 3 Gytis Bernatavicius 70,900 71
               23 5 Mark Metsla 43,400 43
               23 6 Taniel Sõõrumaa 28,000 28
               23 7 Ilja-Ülo Nukka 23,400 23
               23 8 Greger B. E. Aktell 143,000 143
               23 9 Tuomas Antero Röppänen 19,900 20
 
               24 1 Anna-Mari Hursti 44,800 45
               24 2 Johan Stig Arne Creutz 50,500 51
               24 3 Dmitrijs Arsuns 64,900 65
               24 5 Francisco Jose Blanco Racionero 144,300 144
               24 6 Kent Mikael Wulff 96,700 97
               24 7 Tomas Pinkevicius 30,000 30
               24 8 Arturs Martinsons 45,500 46
               24 9 Ricardas Zygis 57,300 57
 
               25 2 Leevi Olavi Lindstedt 26,800 27
               25 3 Jon Ander Martinez 91,500 92
               25 4 Verneri Janne Aaron Häkkinen 29,700 30
               25 5 Alf Sebastian Hjärtberg 43,600 44
               25 6 Joonas Juhani Lyttinen 26,500 27
               25 7 Priit Vallap 15,300 15
               25 8 Gediminas Dirmantas 73,300 73
               25 9 Matiss Celmins 35,500 36
 
               26 2 Krzysztof Grzegorz Romanow 54,200 54
               26 3 Max Rudolf Rotko 42,600 43
               26 4 Daniel Feirer 53,600 54
               26 5 Dennis Berglin 192,000 192
               26 6 Tomas Kirchovas 157,400 157
               26 7 Eirik Kristiansen 59,300 59
               26 8 Roope O. O. Tarmi 20,100 20
               26 9 Allan Arjut 87,200 87
 
               27 1 Marko Keskel 47,900 48
               27 2 Dmitri Dudakov 17,700 18
               27 4 Luca Beretta 68,700 69
               27 5 Toni Valtteri Ylitervo 68,200 68
               27 6 Yaniv Peretz 20,900 21
               27 7 Igor Pihela Jun. 68,800 69
               27 8 Ranno Sootla 30,000 30
               27 9 Rokas Barzdzius 101,000 101
 
               28 1 Jaakko Petteri Tirkkonen 19,800 20
               28 2 Totti Matias Arosuo 41,100 41
               28 3 Mark Paul Berman 21,700 22
               28 4 Matti Tapani Lasanen 31,800 32
               28 5 Mairo Toom 117,100 117
               28 6 Jari Pekka Rättyä 7,200 7
               28 8 Keimo I. T. Suominen 27,100 27
               28 9 Paul Koppe 157,000 157
 
               29 1 Antti E. E. Veteläinen 43,100 43
               29 2 Nikita Staroverov 60,600 61
               29 3 Paulius Vaitiekunas 42,500 43
               29 4 Peep Kivistik 27,900 28
               29 5 Andrey Koks 43,400 43
               29 6 Arto E. S. Mansner 30,000 30
               29 7 Janne M. T. Nevalainen 125,400 125
               29 9 Oskaras Valteris 13,600 14
 
               30 1 Allesandro Giordano 28,500 29
               30 2 Matias Manuel Knaapinen 60,900 61
               30 3 Arturs Barkevics 49,600 50
               30 4 Julius Kasperi Kettunen 23,500 24
               30 5 Viktors Caikins 62,400 62
               30 6 Daragh Davey 47,400 47
               30 8 Jari Juhani Porkka 43,300 43
               30 9 Kasperi Kasimir Ilkka 37,000 37
 
               31 1 Kai E. J. Lehto 95,200 95
               31 2 Ryhor Karapanau 51,200 51
               31 3 Aki Taisto Olavi Pyysing 37,300 37
               31 4 Carl H.R. Lockmer 63,200 63
               31 5 Yanis Mehdi Sahli 106,800 107
               31 7 Teemu Aukusti Toikkanen 95,200 95
               31 8 Egon Kaljulaid 105,000 105
               31 9 Ignacio Gonzalez Garrido 15,000 15
 
               32 1 Andrei Mjagkov 54,400 54
               32 3 Karl Johan Karlsson 44,000 44
               32 4 Vllaznin Dida 24,200 24
               32 5 Albert Ostrovskij 29,500 30
               32 6 Stanislovas Vinicenka 88,000 88
               32 7 Martin Piik 36,900 37
               32 8 Petri Eero Sakari Pääkkönen 73,600 74
               32 9 Erkki Kristian Kaira 19,200 19
 
               33 3 Vadim Kiseliov 69,600 70
               33 4 Gintaras Naglius 132,100 132
               33 5 Van Tuan Phung 50,300 50
               33 6 Anne Bezdek 80,300 80
               33 7 Priit Parmasto 148,000 148
               33 8 Lasse Olavi Enojärvi 71,500 72
               33 9 Victor Prior Fernandez Amat 23,000 23
 
               34 1 Ville Olavi Jantunen 84,800 85
               34 2 Juri Vassin 55,900 56
               34 3 Kaius Kiidli 14,000 14
               34 4 Martynas Racinskas 67,200 67
               34 5 Peter Hanko 52,300 52
               34 8 Linus Hans Ludwig Lauermann 142,200 142
               34 9 Raimo Tapio Ahola 57,700 58
 
               35 1 Tomi Seppo Arvid Hietala 14,000 14
               35 3 Kristaps Renga 35,200 35
               35 5 Sten Talviste 52,800 53
               35 6 Tomi Peter Lehtinen 42,200 42
               35 7 Egle Geniene 15,300 15
               35 8 Donatas Pilinkus 42,700 43
               35 9 Anatoly Filatov 175,600 176
 
               36 1 Artjoms Skvarkovskis 52,700 53
               36 4 Augustas Masaitis 106,000 106
               36 5 Dainius Balynas 69,200 69
               36 6 Justas Semaška 57,800 58
               36 7 Romans Krasins 134,000 134
               36 8 Jan Kristian Granlund 65,500 66
               36 9 Luigi Andrea Shehadeh 68,900 69
 
               37 1 Mikk Sibrits 42,300 42
               37 3 Elias Oskari Vääräniemi 80,700 81
               37 4 Thore-Fabian Kunze 19,800 20
               37 5 Yuzhou Yin 35,800 36
               37 7 Osku Kalle Karttunen 55,400 55
               37 8 Arkadiusz Liszewski 23,600 24
               37 9 Dainius Antanaitis 149,100 149
 
               38 1 Timo Tuomas Lämsä 128,300 128
               38 2 Anttu H.O Hurnanen 29,800 30
               38 3 Marius Verikas 30,800 31
               38 4 Davis Modans 76,600 77
               38 5 Niklas Mikael Vakkuri 63,100 63
               38 6 Gints Ozols 60,000 60
               38 7 Eero Ilari Lehtinen 63,500 64
 
               39 1 Mario Jürgens 52,300 52
               39 2 Sebastian Wahl 101,100 101
               39 3 Jussi P. K. Mattila 42,000 42
               39 4 Armend Sahiti 173,700 174
               39 5 Vasilij Barna 106,000 106
               39 7 Vu Hoang Vuong 46,700 47
               39 9 Kristo Kadastik 40,000 40
02:12 (UTC+2)
Day 2 of King of Tallinn 2023 Started
Level: 9     Blinds: 500/1,000     Ante: 1,000

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.