0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0073 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event/1B/updates' ORDER BY `views` DESC

0.0103 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event/1B/updates'

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.0001 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.0003 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0003 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0036 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.0005 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.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '13'

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

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

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

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

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

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

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '13' AND `name` = '1B'

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

0.0062 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` = '52' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0064 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` = '2309' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 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` = '2308' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2306' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2304' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 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` = '2300' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 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` = '2299' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2298' 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` = '2297' 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` = '2296' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 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` = '2294' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2293' 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` = '2292' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2289' 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` = '2288' 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` = '2287' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2286' 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` = '2282' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2281' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2278' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2277' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2276' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2275' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2272' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2271' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2270' 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` = '2268' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 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` = '2267' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2263' 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` = '2262' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2260' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2261' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2257' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2256' 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` = '2255' 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` = '2254' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2252' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2251' ORDER BY `chip_change` DESC, `busted` ASC

0.0082 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` = '2250' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 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` = '2247' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2244' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2242' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2241' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2238' 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` = '2237' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 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` = '2233' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 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` = '2228' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 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` = '2227' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2226' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2225' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0058 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` = '52' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0061 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` = '2309' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2308' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 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` = '2306' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 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` = '2304' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2300' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2299' ORDER BY `chip_change` DESC, `busted` ASC

0.0271 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` = '2298' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2297' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2296' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2294' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2293' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2292' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 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` = '2289' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2288' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2287' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2286' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2282' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2281' 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` = '2278' ORDER BY `chip_change` DESC, `busted` ASC

0.0075 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` = '2277' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2276' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2275' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2272' 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` = '2271' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2270' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2268' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2267' 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` = '2263' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2262' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2260' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2261' ORDER BY `chip_change` DESC, `busted` ASC

0.0265 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` = '2259' ORDER BY `chip_change` DESC, `busted` ASC

0.0070 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` = '2257' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2256' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2255' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2254' ORDER BY `chip_change` DESC, `busted` ASC

0.0091 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` = '2252' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 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` = '2251' 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` = '2250' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 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` = '2247' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2244' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2242' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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` = '2241' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2238' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2237' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2233' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 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` = '2228' 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` = '2227' 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` = '2226' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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` = '2225' ORDER BY `chip_change` DESC, `busted` ASC

0.0058 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 1B
End-of-Day 1b Chip Counts Posted Thursday 2nd March, 2023 at 20:50(UTC+2) by Jason Glatzer
Player Chips Big Blinds
Dennis Berglin 192,000              192
Anatoly Filatov 175,600              176
Armend Sahiti 173,700              174
Mart Kalju 158,000              158
Tomas Kirchovas 157,400              157
Paul Koppe 157,000              157
Dainius Antanaitis 149,100              149
Priit Parmasto 148,000              148
Greger Aktell 143,000              143
Linus Lauermann 142,200              142
Oskars Gailums 141,700              142
Jari Mahonen 136,300              136
Santtu Leinonen 135,600              136
Romans Krasins 134,000              134
Gintaras Naglius 132,100              132
Gert Laanemets 124,300              124
Grantas Naujokas 123,400              123
Mairo Tori 118,400              118
Mairo Toom 117,100              117
Juhana Konttinen 115,800              116
Kaspars Renga 112,600              113
Uri Gilboa 112,100              112
Yanis Mehdi Sahli 106,800              107
Mohammed Al-Khazraji 106,300              106
Augustas Masaitis 106,000              106
Kasper Mellanen 101,400              101
Miko Miettinen 99,200                99
Josep Pastor De Ramon 97,800                98
Mikael Wulff 96,700                97
Max Avela 96,000                96
Teemu Toikkanen 95,200                95
Sven Reimaa 93,900                94
Donatas Simas 92,300                92
Jon Ander Martinez 91,500                92
Vytautas Kacerauskas 88,500                89
Stanislovas Vinicenka 88,000                88
Allan Arjut 87,200                87
Carl Gustafsson 80,700                81
Markku Koplimaa 80,700                81
Anne Bezdek 80,300                80
Antti Tuomi 79,200                79
Hanno Kerem 77,500                78
Davis Modans 76,600                77
Niki Nurmisto 75,400                75
Pekka Ikonen 75,000                75
Tuomo Niemela 75,000                75
Miska Vihervuori 72,300                72
Jani Tuovinen 72,000                72
Tapio Aaltonen 71,200                71
Gytis Bernatavicius 70,900                71
Jari-Pekka Juhola 69,600                70
Vadim Kiseliov 69,600                70
Sondre Stormyr 69,000                69
Samuli Hietala 65,800                66
Jan Granlund 65,500                66
Eero Lehtinen 63,500                64
Marek Selgeveer 63,200                63
Niklas Vakkuri 63,100                63
Virgo Laansoo 63,000                63
Nemo Vilpponen 62,600                63
Gints Ozols 60,000                60
Eirik Kristiansen 59,300                59
Mikko Ylamaki 56,400                56
Osku Karttunen 55,400                55
Peeter Talviste 54,800                55
Daniel Feirer 53,600                54
Sten Talviste 52,800                53
Artjoms Skvarkovskis 52,700                53
Mykola Shapovalov 52,400                52
Peter Hanko 52,300                52
Seppo Parkkinen 51,300                51
Aleksi Naski 50,400                50
Van Tuan Phung 50,300                50
Samuel Richards 50,100                50
Arturs Barkevics 49,600                50
Pekka Virtanen 49,000                49
Marko Keskel 47,900                48
Renato Messina 47,900                48
Vu Vuong 46,700                47
Arturs Martinsons 45,500                46
Anna-Mari Hursti 44,800                45
Alf Hjartberg 43,600                44
Mark Metsla 43,400                43
Herli Olop 43,300                43
Jari Porkka 43,300                43
Antti Vetelainen 43,100                43
Airin Pindis 42,600                43
Max Rotko 42,600                43
Mikk Sibrits 42,300                42
Tomi Lehtinen 42,200                42
Jussi Mattila 42,000                42
Michael Ibba 41,200                41
Raimo Kaljulaid 40,700                41
Kristo Kadastik 40,000                40
Jimmy Dewerdt 37,300                37
Aki Pyysing 37,300                37
Stefan Bergstrom 36,900                37
Benas Jakusevas 36,900                37
Kristian Kostiander 36,900                37
Martin Piik 36,900                37
Lassi Kolari 36,700                37
Yuzhou Yin 35,800                36
Matiss Celmins 35,500                36
Jyrki Lampinen 32,900                33
Evert Andersson 32,200                32
Marius Verikas 30,800                31
Tomas Pinkevicius 30,000                30
Anttu Hurnanen 29,800                30
Rain Molderkivi 29,000                29
Sandris Mukans 27,400                27
Keimo Suominen 27,100                27
Leevi Lindstedt 26,800                27
Joonas Lyttinen 26,500                27
Tomi Arponen 26,400                26
Annie Chen 25,800                26
Marius Morel 24,500                25
Arkadiusz Liszewski 23,600                24
Julius Kettunen 23,500                24
Vladimir Iljunin 22,900                23
Mark Berman 21,700                22
Viktor Eriksson 21,500                22
Andrejs Stenickins 21,000                21
Inigo Martin 20,800                21
Donatas Kiauleikis 20,600                21
Tuomas Roppanen 19,900                20
Teemu Kailasvuo 19,400                19
Lukas Bytautas 19,000                19
Keito Kaljulaid 17,600                18
Mohamed Barre Mohamud 17,400                17
Egle Geniene 15,300                15
Jose Antoni Gonzalez Zaragoza 15,200                15
Rauno Arras 14,600                15
Tomi Hietala 14,000                14
Oskaras Valteris 13,600                14
Hannes Praks 10,000                10
Maksim Petrov 6,000                  6
Filatov Among the Chip Leaders Posted Thursday 2nd March, 2023 at 20:47(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 8: 400/800 (800)
Entries: 143/286

GGPoker Ambassador Anatoly Filatov has been residing nearby the casino and opted to join us for the €500,000 guaranteed Main Event. So far, it looks like a good choice for Filatov as he is among the chip leaders with 175,000 in chips.

Filatov was kind enough to recall a hand that got him a good part of this stack. He opened with a suited big slick and got two players to call. Filatov fired out for 7,000 on the rainbow flop and got one player to call to see the on the turn.

Filatov bet 10,000 and got a call. A brick that Filatov couldn't recall came on the river. Filatov fired out for 30,000. His opponent jammed for a little more and Filatov called. His opponent had and lost his stack to Filatov.

In other news, Day 1b is near a close with the tournament staff announcing that four more hands will be dealt before players start to bag their stacks.

Stay tuned for the final chip counts of the day.

Day 1c will begin as soon as players clear out for Day 1b. We will provide light coverage of this final opening flight.

Player Chips Progress
Anatoly Filatov 175,000 145,000
Untimely Bluff for Berg Posted Thursday 2nd March, 2023 at 20:32(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 8: 400/800 (800)
Entries: 150/286

Mairo Tori bet 8,000 into a pot north of 20,000 after the came on the flop. Roni Berg jammed over the top for about 62,000.

Tori went into the tank for several minutes before ultimately deciding to call.

Mairo Tori:
Roni Berg:

Berg's play showed a lot of heart even if it didn't work this time around. Berg was drawing dead after the turn and Tori doubled up with a full house after the river completed the board.

Player Chips Progress
Mairo Tori 125,000 82,000
Roni Berg 15,000 45,000
Konttinen Delivers Lindberg a Cooler Posted Thursday 2nd March, 2023 at 20:22(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 8: 400/800 (800)
Entries: 158/286

Max Rotko opened from the middle position and was called by Bjorne Lindberg from the hijack and Juhana Konttinen from the button.

Rotko and Lindberg both checked the flop. Konttinen fired out for 2,000. Rotko called before Lindberg raised to 10,000. Konttinen called before Rotko got out of the way.

Lindberg jammed the turn for 45,000 and Konttinen, who had Lindberg covered, found a call.

Bjorne Lindberg:
Juhana Konttinen:

Both players had trips. However, Konttinen's queen kicker put him ahead. The river didn't change that fact and Konttinen ousted Lindberg on a cooler.

Player Chips Progress
Juhana Konttinen 120,000 90,000
Bjorne Lindberg 0 0
Final Day 1b Blind Level Begins Posted Thursday 2nd March, 2023 at 20:08(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 8: 400/800 (800)
Entries: 158/286

The Day 1b field is approaching a whopping 300 entries with the action moving to the final blind level of the day.

It likely won't get there as many players that have hit the rail recently have already said they will hop into Day 1c starting at 9 p.m. instead but we will likely see a few more before the end of the day.

20:06 (UTC+2)
Start of Level 8
Blinds: 400/800     Ante: 800
Berg Doubles Through Touvinen Posted Thursday 2nd March, 2023 at 19:58(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 7: 300/600 (600)
Entries: 160/285

Jani Tuovinen squeezed over a raiser and two callers for about 45,000 before Roni Berg called off his stack of around 25,000.

Roni Berg:
Jani Touvinen:

The runout let Berg win the flip with a pair of jacks.

Player Chips Progress
Roni Berg 60,000 30,000
Jani Touvinen 20,000 10,000
Pihela Doubles With Two Pair Posted Thursday 2nd March, 2023 at 19:32(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 7: 300/600 (600)
Entries: 173/282

Igor Pihela Sr. (pictured below) checked with the  on the board after the turn before Juris Hlibovs bet 6,000 into a pot of 10,000. Pihela min-clicked it back to 12,000 after pausing for a minute.

Hlibovs jammed for more than the 31,400 Pihela had behind and Pihela wasted no time in finding a call.

Igor Pihela Sr.:
Juris Hlibovs:

As most poker players might feel on the inside, Hlibovs seemed less than thrilled that he was behind. Hlibovs didn't improve on the river and Pihela doubled his stack with two pair.

Player Chips Progress
Igor Pihela Sr. 75,000 45,000
Juris Hlibovs 25,000 30,000
Posted Thursday 2nd March, 2023 at 19:21(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 7: 300/600 (600)
Entries: 172/277

The TV table has been changed for the final two hours of the Main Event to Table 11.

You can check out everyone at the table listed below and you can watch the stream by heading to Live Stream at the Kings of Tallinn website or also at Main Event Travel.

Player Chips Progress
Dainius Antanaitis 117,000 3,000
Tomi Hietala 42,000 12,000
Espen Sandvik 39,000 9,000
Leevi Lindstedt 37,000 7,000
Massimo Casabona 21,000 9,000
Airin Pindis 19,000 11,000
Mohamed Barre Mohamud 16,000 14,000
Oskaras Valteris 14,000 16,000
Posted Thursday 2nd March, 2023 at 19:14(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 7: 300/600 (600)
Entries: 173/277

Janis Vasiljevs got the last of his short stack in with and was up against Rauno Arras who was also short with .

Vasiljevs was on the rail after the ran out on the board. Arras is still below a starting stack, but earned some breathing room.

Player Chips Progress
Rauno Arras 20,000 10,000
Janis Vasiljevs 0 0
Late Registration Reminder Posted Thursday 2nd March, 2023 at 19:05(UTC+2) by Jason Glatzer

Late registration will be open through all of the opening flights. This is not all as it will also remain open for the first two blind levels of tomorrow's Day 2.

19:04 (UTC+2)
Start of Level 7
Blinds: 300/600     Ante: 600
500 Entries! Posted Thursday 2nd March, 2023 at 18:44(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 6: 200/500 (500)
Entries: 175/274

The Main Event has reached over 500 entries! 

Players went on a 20-minute break shortly after this milestone was reached.

Antanaitis Ousts Sandvik with a Full House Posted Thursday 2nd March, 2023 at 18:43(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 6: 200/500 (500)
Entries: 180/271

Gatis Reigass opened for 1,100 from early position and was called by Dainius Antanaitis from middle position. Reigass continued for 800 on the flop. Antanaitis jacked it up to 3,200 and Reigass called.

Reigass check-called a bet of 6,000 by Antanaitis on the turn before checking one last time after the river. Antanaitis effectively jammed more than the pot and Reigass called off his stack of 27,000. Antanaitis won the hand with a full house with , while Reigass showed the before hitting the showers.

Player Chips Progress
Dainius Antanaitis 120,000 90,000
Gatis Reigass 0 0
Posted Thursday 2nd March, 2023 at 18:28(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 6: 200/500 (500)
Entries: 185/269

Hendrik Uibo checked the flop before Juris Hlibovs bet 1,300 into about 4,000. Uibo raised to 3,800. Hlibovs clicked it back to 8,000 before Uibo jammed for about 24,000. Hlibovs called and the cards were turned over.

Henrik Uibo:
Juris Hlibovs:

Hlibovs was ahead with his two pair and won the hand after Uibo was unable to improve from his top pair with the turn and river completing the board on the river.

Player Chips Progress
Juris Hlibovs 55,000 25,000
Henrik Uibo 0 0
Posted Thursday 2nd March, 2023 at 18:11(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 6: 200/500 (500)
Entries: 189/265

Aigars Petrovs checked with not a ton in the pot and the on the board. Kim Holmberg bet 3,200. Petrovs raised to 11,000 and Holmberg went into the tank for at least a minute before he called.

For some reason, neither player was immediately turning over their cards to the dismay of some at the table.

Petrovs eventually turned over the for trip sixes and claimed the pot after Holmberg mucked.

Player Chips Progress
Kim Holmberg 105,000 75,000
Aigars Petrovs 70,000 40,000
17:55 (UTC+2)
Start of Level 6
Blinds: 200/500     Ante: 500
Not the Best Blind Level for Vist Posted Thursday 2nd March, 2023 at 17:55(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 5: 200/400 (400)
Entries: 197/245

Carmen-Elina Vist was likely the first player with a six-figure stack but now she is on the rail. It appears that some of her chips went to tablemates Mairo Toom and Miko Miettinen, who now each hold six-figure stacks, but Toom informed us that Vist spread them around just before Vist's final table took place.

Oleg Lakota opened for 1,600 from the button. Vist jammed for 5,900. Lakota asked for a count and Vist almost accidentally turned over her cards. She caught herself before it was too late.

 "I am calling anyway," Lakota said midway through the deal counting up Vist's stack and soon after tossed a chip in to call.

Carmen-Elina Vist:
Oleg Lakota:

The board improved both players to a flush. Lakota's flush was better and Vist went from hero to zero in about an hour.

Player Chips Progress
Miko Miettinen 120,000 90,000
Mairo Toom 115,000 35,000
Oleg Lakota 45,000 15,000
Carmen-Elina Vist 0 0
PLO PKO Begins Posted Thursday 2nd March, 2023 at 17:09(UTC+2) by Jason Glatzer

Another side event just kicked off in the €250 PLO Progressive Bounty. The tournament features a round of each between four-card PLO and five-card PLO.

Adam Tomasson, Dainius Balynas, Daragh Davey, and Sebastian Simovic were some of the early players in the field.

Flush for Aktell Posted Thursday 2nd March, 2023 at 17:03(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 5: 200/400 (400)
Entries: 199/243

Greger Aktell fired out for 12,500 into a pot of a bit more with the on the board. 

Rudolfs Vegners called a few moments later only to muck his hand after seeing Aktell turned a flush with .

Player Chips Progress
Greger Aktell 80,000 50,000
Rudolfs Vegners 6,000 24,000
Cows Delay Lindberg Posted Thursday 2nd March, 2023 at 16:58(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 5: 200/400 (400)
Entries: 197/240

One player that isn't yet back in his seat is Bjorne Lindberg. During the break, Lindberg went for a smoke and won 150 free spins at the same time at the Invaders from the Planet Moolah slot machine. We very often call this the "Moo Machine" as it features futuristic cows and other fun characters.

Very often, players will win more spins in the free spin mode, so we will likely not see Lindberg for the next 10 minutes.

 

Player Chips Progress
Bjorne Lindberg 45,000 15,000
Various Big Stacks at Break Posted Thursday 2nd March, 2023 at 16:46(UTC+2) by Jason Glatzer
Player Chips Progress
Antti Vetelainen 110,000 80,000
Tomi Lehtinen 95,000 65,000
Mart Kalju 95,000 5,000
Seppo Parkkinen 90,000 60,000
Mairo Toom 80,000 50,000
Carmen-Elina Vist 80,000 30,000
Hanno Kerem 76,000 0
Tomas Kirchovas 75,000 45,000
Nijat Rustamov 75,000 45,000
Tomas Pinkevicius 75,000 45,000
Juho Heiska 73,000 43,000
Tuomo Niemela 70,000 40,000
Sergejs Korobovs 65,000 35,000
16:38 (UTC+2)
Start of Level 5
Blinds: 200/400     Ante: 400
Second Break Posted Thursday 2nd March, 2023 at 16:22(UTC+2) by Jason Glatzer

Players are on their second break of Day 1b. We will update some of the bigger chip counts from around the room during the break.

Some of the players will take part in the €150 GGPoker Flip & Go Mystery Bounty. They just take a few minutes with a single hand being dealt. Best of luck to all of the flippers.

Value Town for Vist Posted Thursday 2nd March, 2023 at 16:18(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 4: 100/300 (300)
Entries: 196/229

Carmen-Elina Vist bet 12,600 into a pot of around 24,000 with the on the board.

"I never bluff," shared Vist to her opponent Myro Lyytinen.

Lyytinen tanked for a few minutes while Vist was chatting it up. Eventually, Lyytinen opted to call. Vist turned over and got paid with Lyytinen turning over a small pair with .

Player Chips Progress
Carmen-Elina Vist 110,000 30,000
Myro Lyytinen 5,000 25,000
Day 1b Bigger Than Day 1a Posted Thursday 2nd March, 2023 at 16:15(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 4: 100/300 (300)
Entries: 197/229

The Day 1b field is now officially already bigger than the Day 1a field with 229 entries with Day 1a attracting 227 entries. The €500,000 guarantee is also already met with 456 entries in total for a €430,520 prize pool and counting.

Kalju Wins the Battle of Estonian Big Stacks Posted Thursday 2nd March, 2023 at 15:52(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 4: 100/300 (300)
Entries: 201/222

Mart Kalju and Peeter Talviste both had more than double their stacks at Table 3 before getting tangled up in a hand.

Kalju fired out for 6,000 into a pot of around double that with the on the board. Talviste quickly called and mucked his hand after Kalju turned over for trip fours.

Player Chips Progress
Mart Kalju 90,000 60,000
Peeter Talviste 60,000 30,000
"OK, I Can Rebuy" Posted Thursday 2nd March, 2023 at 15:37(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 4: 100/300 (300)
Entries: 199/214

Ronny Albrigtsen, who chipped up since the break, and Jari-Pekka Juhola checked the flop before Jari Porkka fired out for 2,100 into a pot of around 10,000. Albrigtsen raised to 10,100. Juhola quickly folded and Porkka went into the tank for close to a minute before he jammed over the top for 22,900.

"What do you have?" Albrigtsen asked while Porkka remained stoically quiet. "Do you have jacks or tens?"

Albrigtsen tanked a bit longer before he talked himself into a call.

"If you have kings or aces, its a bit of a cooler," Albrigtsen said. "OK, I can rebuy."

Jari Porkka:
Ronny Albrigtsen:

Albrigtsen got out of his seat as the turn and river completed the board. However, he sat back down as the dealer and one of the other players at the table pointed out that he had Porkka covered.

Meanwhile, we noticed Ronny Albrigtsen lost his small stack and Stefan Bittger was also recently sent to the rail.

Player Chips Progress
Jari Porkka 55,000 25,000
Jari-Pekka Juhola 35,000 15,000
Ronny Albrigtsen 4,000 6,000
Ronny Albrigtsen 0 0
Stefan Bittger 0 0
15:22 (UTC+2)
Start of Level 4
Blinds: 100/300     Ante: 300
Anatoly Filatov in the House! Posted Thursday 2nd March, 2023 at 15:16(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 3: 100/200 (200)
Entries: 197/209

Niall Farrell isn't the only GGPoker Ambassador to come to the Kings of Tallinn this year as we just had a quick chat with Anatoly Filatov who is now seated at Table 1.

This was a pleasant surprise as we haven't seen Filatov in Tallinn, at least in recent years, for any of the big events.

While is he often smiling, don't let that deceive you about his poker prowess as he is one of the most successful poker players in the field with nearly $5.3 million in live tournament cashes as tracked by The Hendon Mob.

Player Chips Progress
Anatoly Filatov 30,000 0
Set of Tens for Simonovicius Posted Thursday 2nd March, 2023 at 15:09(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 3: 100/200 (200)
Entries: 195/206

Andrius Simonovicius opened for 500 from under the gun. Uri Gilboa called from the cutoff before Eldars Sadih-Zade three-bet to 2,500 from the button. Both Simonovicius and Gilboa called to see the  flop.

Simonovicius and Gilboa checked before Sadih-Zade went into the tank for about a minute. Sadih-Zade then opted to bet 3,000. Simonovicius tanked for a minute before he called and Gilboa quickly folded.

Simonovicius checked again on the  turn. Sadih-Zade jammed for 23,700 and Simonovicius quickly called off his stack of 22,300.

Andrius Simonovicius: 
Eldars Sadih-Zade: 

Simonovicius turned a set of tens but still had a sweat with Sadih-Zade having some outs to a flush. His flush draw didn't complete on the  river for Simonovicius to win the hand and leave his opponent with crumbs.

Player Chips Progress
Andrius Simonovicius 60,000 30,000
Uri Gilboa 30,000 0
Eldars Sadih-Zade 1,400 28,600
200 Day 1b Entries! Posted Thursday 2nd March, 2023 at 14:57(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 3: 100/200 (200)
Entries: 191/200

The Day 1b field has already reached 200 entries. It seems likely that it will pass the 227 entries that Day 1a attracted.

Stream Begins Posted Thursday 2nd March, 2023 at 14:55(UTC+2) by Jason Glatzer

The Kings of Tallinn will be hosting a live stream of the Main Event the rest of the way. Kristjan Laas will be the host.

We embedded the stream below but you can also check it out on a variety of sources by heading including heading to the Live Stream tabs on both the Kings of Tallinn and the Main Event Travel websites.

Joking Around With Anne Bezdek Posted Thursday 2nd March, 2023 at 14:52(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 3: 100/200 (200)
Entries: 190/198

The Kings of Tallinn has exceeded its already high expectations. Absolutely nothing to complain about so we had to find something.

We just caught up with Anne Bezdek who is about to take her seat in the Main Event.

"Your name is now too long," we said referring to the fact before she got married a few years ago her name was just eight letters long as Anne Meri.

The chatter continued with Finnish poker reporter Juhani Tyriseva also part of the conversation when we found out she will be seated at Table 39, Seat 6.

"Are you taking your seat now?" Tyriseva asked.

"Yeah, in the bathroom," Bezdek replied as a joke. "I will look for Seat 6 there."

Bezdek is in Tallinn for just about every major international event and has had some deep runs over the years. We wish her the best of luck in the Main Event.

Player Chips Progress
Anne Bezdek 30,000 0
Pyysing Runs Into the Nuts Posted Thursday 2nd March, 2023 at 14:39(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 3: 100/200 (200)
Entries: 188/195

Pavels Pecevics fired out for 5,000 into a pot of a bit more with the on the board. Aki Pyysing found the call only to muck his hand after Pecevics turned over the nuts with for the straight.

Player Chips Progress
Pavel Pecevics 40,000 10,000
Aki Pyysing 16,000 14,000
Slow Starts for Gronvik and Albrigtsen Posted Thursday 2nd March, 2023 at 14:32(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 3: 100/200 (200)
Entries: 183/189

We caught up with the Norwegian poker couple Ronny Albrigtsen and Evy Albrigtsen during the break. Evy is up to 40,000 but Ronny is down to about 10,000. Ronny shared that he ran into a few bad beats and hopes to double or triple up before the next break. Although that would be nice, that isn't really necessary with the amazing structure at the Kings of Tallinn Main Event.

Meanwhile, Mikael Gronvik is also off to a slow start. In a recent hand just after the break he bet 2,000 into a pot of a bit more with the on the board. Mairo Tori quickly called. Gronvik was trying to represent a better hand than he had and showed the

"Nice hand," Gronvik said as Tori turned over to win the pot.

Player Chips Progress
Mairo Tori 43,000 13,000
Evy Albrigtsen 40,000 10,000
Mikael Gronvik 19,000 11,000
Ronny Albrigtsen 10,000 20,000
14:25 (UTC+2)
Start of Level 3
Blinds: 100/200     Ante: 200
Vist Chips Up Before the Break Posted Thursday 2nd March, 2023 at 14:07(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 2: 100/100 (100)
Entries: 169/174

Carmen-Elina Vist chipped up just before the break. She already amassed a decent stack before this hand.

Vist, who opened preflop, continued with a bet of 2,700 on the flop and was called by Tomas Zarankus and Risto Parnat.

Parnat and Vist both checked the turn. Zarankus bet 5,100. Parnat folded and Vist called. Both players checked the river. Vist turned over the which won the hand as Zarankus mucked his hand. Before mucking, Zarankus showed the to the table.

Player Chips Progress
Carmen-Elina Vist 80,000 50,000
Risto Parnat 30,000 0
Tomas Zarankus 15,000 15,000
First Break Posted Thursday 2nd March, 2023 at 14:02(UTC+2) by Jason Glatzer

Players are now on a quick 20-minute break. The stream will start shortly after the break, which you will able to check out by clicking on the Live Stream tab at the Kings of Tallinn website, over at the Main Event Travel blog, or many other ways. We will also embed the stream here in a post once it begins.

Meanwhile, players will be flipping during the break with some tables opening for the €150 GGPoker Flip & Go Mystery Bounty.

Player Chips Progress
Carmen-Elina Vist 80,000 50,000
Risto Parnat 30,000 0
Tomas Zarankus 15,000 15,000
Sviten Special Champion Tony Westby About to Enter Posted Thursday 2nd March, 2023 at 13:54(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 2: 100/100 (100)
Entries: 163/166

Last night, Tony Westby won the €250 Sviten Special Event for €4,100 after navigating through a field of 55 entries.

Westby was hanging around with some other Norwegian players and shared with us that he plans to get into the Day 1b action of the Main Event after the break.

The Norwegian has had some success here at the Kings of Tallinn in the past as well with a much bigger score than he notched last night. Westby took fourth place in the Kings of Tallinn €3,000 High Roller back in 2020 for his biggest career live tournament cash for €30,800.

Best of luck to Westby and everyone that came in from Norway!

Player Chips Progress
Tony Westby 30,000 0
Ten-Trey Gets the Job Done for Juhola Posted Thursday 2nd March, 2023 at 13:28(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 2: 100/100 (100)
Entries: 151/153

Tomi Arponen fired out for 2,100 into a pot of around 4,000 with the on the board after the turn. Jari-Pekka Juhola quickly called before both players checked down the river.

Arponen turned over which wasn't enough as Juhola connected with the board with to take down the pot.

Meanwhile, Arnas Lydeka became the second player to hit the rail in the Day 1b field at around the same time at a different table.

Player Chips Progress
Jari-Pekka Juhola 50,000 20,000
Tomi Arponen 20,000 10,000
Arnas Lydeka 0 0
Nikitins Freerolling Posted Thursday 2nd March, 2023 at 13:19(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 2: 100/100 (100)
Entries: 141/142

Stefan Bittger opened for 300 from middle position. Jans Nikitins three-bet to 1,200 before Bittger jammed for 14,800. Nikitins tanked for a minute before he called.

Stefan Bittger:
Jans Nikitins:

The saying goes that everyone loves a chop and likely Bittger felt that way after the following runout.

The flop provided both players backdoors to a flush. Nikitins had a true flush draw on the turn. However, the pot ended in a chop after the river completed the board.

Player Chips Progress
Jans Nikitins 0 15,000
Stefan Bittger 0 5,000
13:04 (UTC+2)
Start of Level 2
Blinds: 100/100     Ante: 100
Ozuls Felts Gotovusa Posted Thursday 2nd March, 2023 at 13:04(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 1: 100/100
Entries: 129/130

Gints Ozols and Fuad Gotovusa got their stacks locked up on the river with the on the board. According to the table, Gotovusa had which proved to be no match to the held by Ozols to win the hand with a flush. 

Player Chips Progress
Gints Ozols 65,000 35,000
Fuad Gotovusa 0 0
Century Mark Achieved Posted Thursday 2nd March, 2023 at 12:26(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 1: 100/100
Entries: 103/103

Players continue to file into the Day 1b field with now over 100 entries in the mix.

Early Entries in the Field Posted Thursday 2nd March, 2023 at 12:07(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 1: 100/100
Entries: 67/67

Here is a look at some of the early entries in the Day 1b field.

Player Chips Progress
Tero Kilkanen 30,000 0
Vytautas Kacerauskas 30,000 0
Mikael Gronvik 30,000 0
Mairo Toom 30,000 0
Gytis Bernatavicius 30,000 0
Evy Albrigtsen 30,000 0
Day 1b Begins Posted Thursday 2nd March, 2023 at 12:01(UTC+2) by Jason Glatzer

Main Event Day 1b
Level 1: 100/100
Entries: 64/64

Day 1b has kicked off with 64 entries already in their seats. It is anticipated that the Day 1b flight will be the biggest of the three opening flights. Best of luck to all of the players!

Welcome to Day 1b of the €500,000 Guaranteed Main Event Posted Thursday 2nd March, 2023 at 11:27(UTC+2) by Jason Glatzer

Welcome back to the 2023 Kings of Tallinn at Olympic Park Casino and the Hilton Tallinn Park.

Today we will be focusing on reporting the final two opening flights of the €500,000 guaranteed Kings of Tallinn €1,100 Main Event starting with Day 1b at 12 p.m with Day 1c beginning after Day 1b players bag their stacks at 9 p.m.

The event boasts one-hour blind levels throughout the four-day affair with the only exception being Day 1c, which is not quite turbo but still will play out quicker with 30-minute blind levels.

Players start with a healthy stack of 30,000 in chips, which will be good for 300 big blinds for the first two blind levels. They will have a chance to build a healthy stack with not only unlimited re-entries permitted throughout all of the opening flights but also during the first two blind levels of Day 2.

Bags will be passed around to the surviving players after eight blind levels of play. 

As a side note, players that buy into the Main Event via Luxon Pay will be offered bubble insurance for free! A Luxon Pay representative is nearby if you have any questions.

Day 1a attracted a banner field of 227 entries with 117 players finding a bag. Day 1a chip leader Julius Tihonen was the only player to find a bag with more than 200,000 after advancing to tomorrow's Day 2 with 244,000 in chips.

After today's opening flights, the remainder of the Main Event will feature Day 2, Day 3, and the final day on March 3-5. We will be with you the entire way until a winner is crowned.

11:21 (UTC+2)
Day 1B of King of Tallinn 2023 Started
Level: 1     Blinds: 100/100     Ante: 0

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.