0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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

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

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

0.0001 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.0001 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.0003 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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

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

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

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

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

0.0002 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.0063 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.0002 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '13'

0.0226 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` = '50' AND `published` = 1

0.0221 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.0215 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` = '54' AND `published` = 1

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

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

0.0216 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` = '61' AND `published` = 1

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

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

0.0046 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` = '50' 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` = '2221' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 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` = '2219' 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` = '2216' 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` = '2214' 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` = '2212' 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` = '2210' 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` = '2209' 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` = '2208' 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` = '2205' 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` = '2204' 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` = '2203' 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` = '2202' 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` = '2201' 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` = '2198' 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` = '2197' 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` = '2193' 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` = '2192' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0049 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` = '2188' 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` = '2187' 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` = '2185' 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` = '2184' 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` = '2183' 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` = '2182' 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` = '2181' 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` = '2176' 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` = '2175' 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` = '2174' 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` = '2172' 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` = '2171' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0056 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` = '2164' 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` = '2162' 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` = '2161' 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` = '2160' 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` = '2158' 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` = '2156' 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` = '2154' 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` = '2152' 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` = '2149' 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` = '2147' 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` = '2145' 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` = '2148' 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` = '2140' ORDER BY `chip_change` DESC, `busted` ASC

0.0049 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` = '2139' 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` = '2138' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0142 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` = '2216' 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` = '2214' 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` = '2212' 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` = '2210' 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` = '2209' ORDER BY `chip_change` DESC, `busted` ASC

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` = '2208' 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` = '2205' 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` = '2204' 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` = '2203' 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` = '2202' 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` = '2201' 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` = '2198' 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` = '2197' 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` = '2193' 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` = '2192' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

0.0069 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` = '2181' 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` = '2176' 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` = '2175' 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` = '2174' ORDER BY `chip_change` DESC, `busted` ASC

0.0461 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` = '2172' 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` = '2171' 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` = '2165' 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` = '2164' 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` = '2162' 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` = '2161' 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` = '2160' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 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` = '2158' 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` = '2156' 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` = '2154' ORDER BY `chip_change` DESC, `busted` ASC

0.0568 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` = '2152' 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` = '2149' 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` = '2147' 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` = '2145' 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` = '2148' 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` = '2140' 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` = '2139' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0590 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.0004 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 1A
End-of-Day 1a Chip Counts Posted Wednesday 1st March, 2023 at 22:01(UTC+2) by Jason Glatzer
Player Chips Big Blinds
Julius Tiihonen 244,000              244
Tommi Lankinen 174,800              175
Roberts Rumba 168,700              169
Francisco Racionero 144,300              144
Anthony Kauzloric 137,100              137
Janne Nevalainen 125,400              125
Michailas Miserkejevas 116,400              116
Albert Jonsson 116,200              116
Lari Pukkila 113,600              114
Kasso Laasik 110,000              110
Eirimas Tomkevicius 108,600              109
Miko Ylikoski 105,300              105
Sebastian Wahl 101,100              101
Rokas Barzdzius 101,000              101
Touko Berndtson 96,800                97
Aleksei Smirnov 95,800                96
Toivo Rinne 93,900                94
Adria Comas I Roura 93,500                94
Ignas Vaitulionis 92,700                93
Mathias Siljander 87,200                87
Leonardo Romeo 86,000                86
Joni Rantamäki 85,000                85
Stanislav Smeljov 84,900                85
Ville Jantunen 84,800                85
Benjamin Gros 83,900                84
Elias Vaaraniemi 80,700                81
Jaana Kindsigo 79,600                80
Gediminas Dirmantas 73,300                73
Federico Cirillo 71,600                72
Lasse Enojarvi 71,500                72
Mauri Dorbek 69,200                69
Andzej Bilat 69,000                69
Luigi Shehadeh 68,900                69
Igor Pihela Jr. 68,800                69
Luca Beretta 68,700                69
Julien Fuchs 68,500                69
Martynas Racinskas 67,200                67
Julius Dagys 65,000                65
Dmitrijs Arsuns 64,900                65
Jari Lahtinen 63,400                63
Jevgeni Voitovits 62,800                63
Viktors Caikins 62,400                62
Theophile TGeorge 62,300                62
Giovanni Nava 61,800                62
Javier Guinot Moya 61,000                61
Matias Knaapinen 60,900                61
Aleksandr Kuperman 60,900                61
Nikita Staroverov 60,600                61
Justas Semaška 57,800                58
Marco Regonaschi 56,900                57
Niall Farrell 56,200                56
Juri Vassin 55,900                56
Mantas Bagocius 55,500                56
Visa Kiviharju 55,300                55
Annika Anni 54,400                54
Adomas Juozapavicius 54,400                54
Andrei Mjagkov 54,400                54
Luca Sebastiani 54,300                54
Krzysztof Romanow 54,200                54
Juho Suutari 54,200                54
Kaupo Tenno 53,100                53
Magnus Pukk 52,800                53
Marita Mägi 51,500                52
Algirdas Saveikis 50,200                50
Iiro Kettunen 49,500                50
Pavels Spirins 48,400                48
Daragh Davey 47,400                47
Hannes Keskküla 46,200                46
Richard Koppel 45,800                46
Timo Laiho 44,800                45
Andrius Bielskis 43,900                44
Bartosz Mielczarek 43,800                44
Andrey Koks 43,400                43
Donatas Pilinkus 42,700                43
Paulius Vaitiekunas 42,500                43
Miika Toyras 42,000                42
Giada Fang 41,500                42
Totti Arosuo 41,100                41
Elias Suhonen 40,000                40
Raini Lelle 39,100                39
Kasperi Ilkka 37,000                37
Ilari Sahamies 35,400                35
Kristaps Renga 35,200                35
Matti Lasanen 31,800                32
Kasparas Klezys 30,600                31
Martin Häidberg 30,100                30
Ranno Sootla 30,000                30
Ivar Simmer 29,700                30
Allesandro Giordano 28,500                29
Jari Karkkainen 27,900                28
Audrius Laimelis 27,700                28
Leevi Laiho 26,400                26
Markus Ylanne 26,300                26
Kyle Maguire 24,800                25
Vllaznin Dida 24,200                24
Johan Martinsen 23,700                24
James Noonan 23,100                23
Victor Prior Fernandez Amat 23,000                23
Vadim Guk 21,700                22
Laurynas Cerniauskas 21,000                21
Yaniv Peretz 20,900                21
Deniss Davõdov 20,600                21
Victor Fernandez Garcia 20,300                20
Roope Tarmi 20,100                20
Jaakko Tirkkonen 19,800                20
Davide Muccini 18,500                19
Mati Pirn 18,000                18
Martynas Vitkauskas 18,000                18
Dmitri Dudakov 17,700                18
Henri Piironen 17,000                17
Taavi Tamm 16,000                16
Priit Vallap 15,300                15
Ignacio Garrido 15,000                15
Tarmo Tammel 15,000                15
Kaius Kiidli 14,000                14
Siim Pindis 12,600                13
Andrei Silencov 11,500                12
Final Three Hands Posted Wednesday 1st March, 2023 at 20:50(UTC+2) by Jason Glatzer

Players will soon be bagging chips as the final three hands were announced. We will post final chip counts of Day 1b within the hour.

Pukk Doubles Through Vaaraniemi Posted Wednesday 1st March, 2023 at 20:31(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 8: 400/800 (600)
Entries: 128/227

Magnus Puuk jammed for 12,400 from middle position and was called by Elias Vaaraniemi from the cutoff.

Magnus Puuk:
Elias Vaaraniemi:

Puuk won the flip after the runout improved his hand to a pair of tens.

Player Chips Progress
Elias Vaaraniemi 60,000 30,000
Magnus Pukk 27,000 3,000
Too Many Outs for Vetelainen to Avoid with Big Slick Posted Wednesday 1st March, 2023 at 20:11(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 8: 400/800 (600)
Entries: 133/227

Martin Haidberg opened for 1,600 from middle position before Antti Vetelainen three-bet jammed for 10,400 from one seat over. Haidberg went into the tank for about a minute before he called.

Antti Vetelainen:
Martin Haidberg:

Vetelainen was ahead when the chips were committed but the odds evened up after Haidberg hit a flush draw on the flop. Most of the table let out a small chuckle after the turn as this also gave Haidberg more outs with an open-ended straight draw.

It was neither the flush draw nor the straight draw that ultimately led to a bad beat for Vetelainen for his short stack. Instead, it was the river pairing up Haidberg to send Vetelainen to the rail.

Player Chips Progress
Martin Haidberg 50,000 20,000
Antti Vetelainen 0 0
Peretz Doubles His Short Stack Posted Wednesday 1st March, 2023 at 20:02(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 8: 400/800 (600)
Entries: 138/227

Yaniv Peretz three-bet jammed from the small blind for 11,600 and was called by Pavels Spirins, who opened from the button.

Yaniv Peretz:
Pavels Spirins:

Peretz was ahead when the chips went in and doubled his stack after Spirins found no love on the runout.

Player Chips Progress
Pavels Spirins 55,000 25,000
Yaniv Peretz 25,000 5,000
Final Blind Level of Day 1a Posted Wednesday 1st March, 2023 at 19:58(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 8: 400/800 (600)
Entries: 138/227

The final blind level of Day 1a has kicked off with blinds at 400/800 along with an 800 big blind ante. After this level, players will bag their stacks into Friday's Day 2.

19:55 (UTC+2)
Start of Level 8
Blinds: 400/800     Ante: 800
Full House for Wahl Posted Wednesday 1st March, 2023 at 19:53(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 7: 300/600 (600)
Entries: 141/225

Roope Tarmi checked with the on the board after the turn. Sebastian Wahl fired out for 18,200 into a pot north of 30,000. Tarmi went into the tank for more than a minute before he called.

Tarmi checked again after the river completed the board. Wahl stared down his opponent for about 15 seconds. Then the sunglasses came off with Wahl deciding what to do with Tarmi holding only 17,000 behind. Wahl eventually decided to check back.

Tarmi turned over the but his two pair was not good enough to win the hand as Wahl held for a full house to win the pot.

Player Chips Progress
Sebastian Wahl 121,000 91,000
Roope Tarmi 17,000 13,000
Posted Wednesday 1st March, 2023 at 19:29(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 7: 300/600 (600)
Entries: 150/223

There was about 10,000 in the pot when both Albert Jonsson and Vadim Guk checked the flop before the action picked up on the turn.

Jonsson fired out for 10,000. Guk jammed for 35,000 and Jonsson called.

Vadim Guk:
Albert Jonsson:

Guk was miles ahead with his set of nines and only needed to fade a ten on the river which would have given Jonsson a Broadway straight. The paired the board on the river instead and Guk earned a double-up through Jonsson.

Player Chips Progress
Vadim Guk 100,000 70,000
Albert Jonsson 40,000 10,000
Posted Wednesday 1st March, 2023 at 19:20(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 7: 300/600 (600)
Entries: 150/222

Ivar Simmer three-bet jammed for 32,400 from the big blind and was called by Casper von Schantz, who opened from middle position.

Ivar Simmer:
Casper von Schantz:

Simmer was in jeopardy of losing his stack but that all changed after he improved to a set on the flop.

"Keep it, keep it!" screamed Simmer.

His set held the rest of the way with the turn and river completing the board.

"Thank you," Simmer said either to the dealer or the poker gods.

Player Chips Progress
Ivar Simmer 66,000 36,000
Casper von Schantz 12,000 58,000
Firaldo Flips Like a Champ Posted Wednesday 1st March, 2023 at 19:15(UTC+2) by Jason Glatzer

One player that has yet to make it back to his seat in the Main Event is GGPoker Ambassador Niall "Firaldo" Farrell.

Instead, he decided to play the one-table, one-hand €150 GGPoker Mystery Bounty Flip&Go. Probably from miles around, people heard Firaldo celebrating.

Laura Cornelius gave him her microphone and after he won his flip he was screaming wrestling quotes before beginning to sing. It is likely we will see this in a video in the near future.

Firaldo will be playing on Day 2 thanks to winning the flip for a chance at the €5,000 guaranteed top mystery bounty along with a tasty prize pool. There is still plenty of time for other players to join Firaldo in on the fun. Best of luck to everyone flipping today!

Meanwhile, we went to count Firaldo's chip count in the Main Event as he was heading back to the table. He confirmed it was around 40,000 before saying: "Wow, 40,000! I am good at every form of poker!"

Player Chips Progress
Niall Farrell 40,000 18,000
18:57 (UTC+2)
Start of Level 7
Blinds: 300/600     Ante: 600
Big Stacks Around the Room Posted Wednesday 1st March, 2023 at 18:57(UTC+2) by Jason Glatzer
Player Chips Progress
Kasso Laasik 161,000 131,000
Michailas Miserkejevas 95,000 65,000
Juho Suutari 90,000 60,000
Dmitrijs Arsuns 87,000 7,000
Vasilij Barna 85,000 55,000
Aleksandr Kuperman 80,000 10,000
Anthony Kauzloric 80,000 5,000
Lari Pukkila 75,000 45,000
Julius Dagys 75,000 45,000
Niko Palonen 70,000 40,000
Roberts Rumba 70,000 40,000
Eirimas Tomkevicius 70,000 40,000
Igor Pihela Jr. 70,000 5,000
Final Day 1a Break Posted Wednesday 1st March, 2023 at 18:36(UTC+2) by Jason Glatzer

Players are on their final Day 1a break. Two more blind levels will be played on Day 1a including 300/600 (600) and 400/800 (800) before players bag their stacks into Friday's Day 2.

We will update some of the bigger stacks from around the room during or shortly after the break.

Dorbek Cracks Indrikovs' Rockets Posted Wednesday 1st March, 2023 at 18:25(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 6: 200/500 (500)
Entries: 161/217

Davis Indrikovs limped from the button. Mauri Dorbek, who is on his second bullet of the day, raised to 2,000 from the small blind. Luigi Shehadeh called from the big blind before Indrikovs jacked it up to 6,500. Dorbek jammed, Shehadeh folded, and Indrikovs called off his stack of less than 20,000.

Davis Indrikovs:
Mauri Dorbek:

"Aces?" asked Dorbek before the cards were turned over.

They were indeed pocket rockets but this didn't matter at the end as the  runout improved Dorbek to a flush.

"Get this player out of here," Dorbek said as a joke to the floor to her fellow countrymate. "He always gets so lucky."

Player Chips Progress
Mauri Dorbek 65,000 54,000
David Indrikovs 0 0
Don't Miss Tonight's Mega Satellite to the Record-Breaking Main Event Posted Wednesday 1st March, 2023 at 18:12(UTC+2) by Jason Glatzer

Koks Wins the Hand Without a Deuce Posted Wednesday 1st March, 2023 at 18:11(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 6: 200/500 (500)
Entries: 162/214

Jaanus Kippel bet 2,500 into a pot of a bit more after the flop and was called by Andrey Koks. Koks then called a bet by Kippel for 4,000 on the turn. The river completed the board.

Kippel went into the tank before he checked.

"Do you have a two?" Kippel asked.

"No," Koks laughed.

Koks opted to check the action back a few moments later. Kippel turned over the . This didn't win the hand as Koks subsequently showed the for a full house.

Player Chips Progress
Andrey Koks 45,000 15,000
Jaanus Kippel 25,000 5,000
Straight for Borozna to Double Through Laimelis Posted Wednesday 1st March, 2023 at 17:52(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 6: 200/500 (500)
Entries: 163/208

Juri Borozna jammed for 19,300 over the bet of 6,000 by Audrius Laimelis. Laimelis went into the tank for about two minutes before he called.

Borozna turned over for trips. Laimelis attempted to muck his hand but the dealer turned it over as it was an all-in and a call to show he had for an overpair to the board.

Player Chips Progress
Juri Borozna 60,000 30,000
Audrius Laimelis 30,000 0
17:39 (UTC+2)
Start of Level 6
Blinds: 200/500     Ante: 500
200 Entries! Posted Wednesday 1st March, 2023 at 17:25(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 5: 200/400 (400)
Entries: 162/200

Day 1a of the Main Event has reached 200 entries. With tomorrow's Day 1b field expected to be even bigger, it seems like the €500,000 guarantee is simply a placeholder and has a strong chance to be the biggest Kings of Tallinn Main Event in history when taking into account also the turbo Day 1c and late entries and re-entries permitted during the first three blind levels of Friday's Day 2.

Straight for Smirnov Posted Wednesday 1st March, 2023 at 16:58(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 5: 200/400 (400)
Entries: 160/191

Aleksei Smirnov bet 6,000 into a pot of a bit more with the on the board.  Stanislovas Vinicenka tanked for a few moments before he called.

Smirnov turned over for a turned straight and won the hand after Vinicenka mucked his cards.

Player Chips Progress
Aleksei Smirnov 65,000 35,000
Stanislovas Vinicenka 7,200 22,800
Von Schantz Off to Broadway Posted Wednesday 1st March, 2023 at 16:52(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 5: 200/400 (400)
Entries: 160/188

Casper von Schantz bet 8,000 into a pot of around the same with the on the board after the turn. Victor Fernandez Garcia jammed for about 28,000 and von Schantz snap-called.

Victor Fernandez Garcia:
Casper von Schantz:

Garcia was down to four-outs on the river with his two pair outmatched by his opponent's Broadway straight. Von Schantz scooped up the pot and sent Garcia to the rail after the blank river completed the board.

Player Chips Progress
Casper von Schantz 70,000 40,000
Victor Fernandez Garcia 0 0
Posted Wednesday 1st March, 2023 at 16:40(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 5: 200/400 (400)
Entries: 158/180

Viktors Caikins and Algirdas Saveikis both had their stacks in the middle with the on the board just before the break.

The table exploded in shock. Saveikis turned over for a full house. The second nuts wasn't enough as Caikins woke up with for quads.

Saveikis went on break with 5,000 in chips and dusted these off the very first hand after the break.

Player Chips Progress
Viktors Caikins 70,000 0
Algirdas Saveikis 0 0
16:36 (UTC+2)
Start of Level 5
Blinds: 200/400     Ante: 400
Various Big Stacks at Break Posted Wednesday 1st March, 2023 at 16:36(UTC+2) by Jason Glatzer
Player Chips Progress
Federico Cirillo 85,000 55,000
Dmitrijs Arsuns 80,000 30,000
Raini Lelle 75,000 15,000
Viktors Caikins 70,000 40,000
Miko Ylikoski 70,000 40,000
Aleksandr Kuperman 70,000 40,000
Joni Rantamaki 70,000 40,000
Annika Anni 70,000 0
Igor Pihela Jr. 65,000 20,000
Iiro Kettunen 60,000 30,000
Toivo Rinne 60,000 30,000
Second Break Posted Wednesday 1st March, 2023 at 16:13(UTC+2) by Jason Glatzer

Players are on their second break. Blinds will increase to 200/400 with a 400 big blind ante when the action resumes.

"I Should Have Jammed" Posted Wednesday 1st March, 2023 at 16:11(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 4: 100/300 (300)

Entries: 152/171

Anthony Kauzloric fired out for 12,000 into a pot of nearly double that with the on the board on the turn. Mauri Dorbek tanked for several minutes.

"You have ace-jack," said Kauzloric before the clock was called.

The floor came over and shared to Dorbek he had 30 seconds. About halfway through his time he announced his call.

Kauzloric turned over for Broadway and won the hand after Dorbek mucked his cards.

"I should have jammed," stated Dorbek.

"The turn or river?" asked Kauzloric.

"The river," replied Dorbek.

"I would have called anyway," shared Kauzloric. "I was already committed."

Player Chips Progress
Anthony Kauzloric 75,000 30,000
Mauri Dorbek 11,000 19,000
Posted Wednesday 1st March, 2023 at 15:49(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 4: 100/300 (300)

Entries: 151/164

Krzysztof Romanow bet 5,200 into a pot of slightly more with the on the board. Dmitrijs Arsuns tanked for a moment before he called.

Romanow turned over and tapped the table after Arsuns called with to win the hand.

Player Chips Progress
Dmitrijs Arsuns 50,000 20,000
Krzysztof Romanow 17,000 13,000
Props to the Dedication of Benjamin Gros Posted Wednesday 1st March, 2023 at 15:37(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 4: 100/300 (300)

Entries: 152/161

It took over 17 hours of play last night for Benjamin Gros to win the Kings of Tallinn €555 Championship for €55,500. The action ended at around 5:30 a.m. with some photos and discussions to follow.

The player from France is quite dedicated to the grind. Many would take a day off after such a long grind and a big win. But not Gros, as he just entered the Main Event looking for an even bigger payout. We enjoyed watching Gros leverage his big stack to his advantage at the final table yesterday and wish him the best of luck in the Main Event.

Meanwhile, Kyle Maguire, who traveled out to Tallinn from Scotland with Niall Farrell is also in the hunt for another big payout for his resume.

Player Chips Progress
Kyle Maguire 30,000 0
Benjamin Gros 30,000 0
Flush Good on a Scary Board for Kauzloric Posted Wednesday 1st March, 2023 at 15:30(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 4: 100/300 (300)

Entries: 150/159

Marita Magi checked with the on the board after the turn. Anthony Kauzloric fired out for 2,500 into a pot of over 6,000. Magi tanked for close to a minute before she called.

The river double-paired the board. Both players checked. Kauzloric turned over for a flush and won the hand after Magi mucked.

"What the f&#k," said Jaana Kindsigo, who was also at the same table and shocked that the flush was able to hold on a scary board.

Player Chips Progress
Anthony Kauzloric 45,000 15,000
Jaana Kindsigo 35,000 5,000
Marita Magi 32,000 2,000
15:21 (UTC+2)
Start of Level 4
Blinds: 100/300     Ante: 300
Sviten Special Begins Posted Wednesday 1st March, 2023 at 15:20(UTC+2) by Jason Glatzer

The €250 Sviten Special tournament has just kicked off with a field of 26 entries. Sviten Special author Martin Smith, Aki Pyysing, Dainius Antanaitis, Peder Behr, and Matteo Crapanzano were among the players in action at the start of play.

Sviten Special is one of the more unique games combining both five-card draw and pot-limit Omaha in the same game. Here is how the game works:

  • Players start with five cards followed by a round of betting.
  • A flop is dealt followed by another round of betting.
  • Players can then discard up to all five cards or stand pat. If discarding just a single card, it will be dealt face up for all players to see. The player can then decide if they want to keep that card or get a new one face down.
  • A turn is dealt followed by a round of betting.
  • The final round of betting takes place after the river.
  • The best five-card draw hand wins half the pot with the best five-card Omaha hand winning the other half. 

Best of luck to all of the Sviten Special players. Anyone that has any questions about the game can drop by the media desk and Jason would be happy to explain the rules in more detail along with some basic strategy.

Rockets for Messina Posted Wednesday 1st March, 2023 at 14:58(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 3: 100/200 (200)

Entries: 141/147

Bengt-Anders Johnsson fired out for 3,600 into an already bloated four-bet pot with the on the board after the flop. Renato Messina called and Johnsson jammed on the turn for more than the 14,500 Messina had behind. Messina quickly called this as well and had Johnsson drawing dead.

Renato Messina:
Bengt-Anders Johnsson:

The inconsequential paired the board on the river to make Messina's double-up official.

Player Chips Progress
Renato Messina 50,000 26,000
Bengt-Anders Johnsson 19,000 11,000
Full House for Pihela Jr. Posted Wednesday 1st March, 2023 at 14:49(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 3: 100/200 (200)

Entries: 139/143

Andzej Bilat checked the river with the on the board before Igor Pihela Jr. fired out a pot-sized bet of 7,000.

Bilat tanked for close to a minute before he called. Pihela Jr. instantly turned over for a full house. Bilat actually had the case jack as he flashed the before tossing his hand into the muck.

Player Chips Progress
Igor Pihela Jr. 45,000 15,000
Andzej Bilat 14,000 16,000
Posted Wednesday 1st March, 2023 at 14:41(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 3: 100/200 (200)

Entries: 135/139

Raini Lelle has one of the bigger early stacks in the room sitting on around 60,000 in chips. He just won a three-bet pot against Kasperi IIkka. There was a continuation bet and a call to bring the pot north of 10,000 after the came on the flop.

The turn and river brought no action. Lelle turned over and won the pot with his top pair and king kicker after Ilkaa folded his hand.

Meanwhile, GGPoker Ambassador Niall "Firaldo" Farrell is in the house and already has nearly a double starting stack as well. Farrell is a well-established online and live poker pro with more than $6.5 million in live tournament cashes as tracked by The Hendon Mob. He has found some success here in Tallinn as back in 2021 he shipped the Tallinn Summer Showdown €1,000 Main Event for €32,125.

Player Chips Progress
Raini Lelle 60,000 30,000
Niall Farrell 58,000 28,000
Kasperi Ilkka 24,000 6,000
Posted Wednesday 1st March, 2023 at 14:26(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 3: 100/200 (200)

Entries: 130/134

Antti Vetelainen checked with the on the board after the flop before Renato Messina fired out for 800 into a pot of 2,900. Vetelainen called and both players checked the turn.

The river completed the board. Vetelainen fired out for 4,200. Messina tanked for close to two minutes before he found a call. Vetelainen turned over for a turned flush. This got the job done as Messina opted to muck his cards.

Player Chips Progress
Antti Vetelainen 45,000 15,000
Renato Messina 24,000 6,000
14:17 (UTC+2)
Start of Level 3
Blinds: 100/200     Ante: 200
First Break Posted Wednesday 1st March, 2023 at 14:13(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 2: 100/100 (100)

Entries: 127/131

Players are on their first break. After the break, we will be on the floor reporting hands until the conclusion of Day 1a at around 8:30 p.m.

Kristaps Kalva, Jari-Pekka Rattya, and Juho Santala all hit the rail during Level 2 and haven't re-entered at least as of yet.

Player Chips Progress
Juho Santala 0 0
Jari-Pekka Rattya 0 0
Kristaps Kalva 0 0
Anni Ousts Al-Kharzaji Posted Wednesday 1st March, 2023 at 13:32(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 2: 100/100 (100)

Entries: 120/121

While Level 1 was rather quiet, the action picked up at Table 7 during the second blind level. Mohammed Al-Khazraji was down to 10,000 in chips. He jammed these in over a bet and a call with the on the board with the .

Annika Anni woke up with for trips. No hearts came on the turn or river and Al-Khazraji was the first casualty of the day while Anni had the early chip lead.

Player Chips Progress
Annika Anni 70,000 40,000
Mohammed Al-Khazraji 0 0
13:10 (UTC+2)
Start of Level 2
Blinds: 100/100     Ante: 100
More Than 100 Entries Posted Wednesday 1st March, 2023 at 13:02(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 1: 100/100

Entries: 101/101

Day 1a of the Main Event has already grown to more than 100 entries as players continue to file into the tournament arena.

Posted Wednesday 1st March, 2023 at 13:01(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 1: 100/100

Entries: 85/85

The Day 1a field of the Main Event has already grown to 85 entries and counting. Here is a look at some of the early players in the field.

Player Chips Progress
Juuso Kauppi 30,000 0
Bartosz Mielczarek 30,000 0
Lukas Soucek 30,000 0
Leonardo Romeo 30,000 0
Vytautas Kacerauskas 30,000 0
Jaana Kindsigo 30,000 0
Julien Fuchs 30,000 0
Andrius Bielskis 30,000 0
12:59 (UTC+2)
Start of Level 1
Blinds: 100/100     Ante: 0
Cards in the Air Posted Wednesday 1st March, 2023 at 12:03(UTC+2) by Jason Glatzer

Main Event Day 1a
Level 1: 100/100

Entries: 61/61

The Main Event has kicked off the first of its three opening flights. There were 61 entries to start the day. This figure will grow with many players planning to late-register after a late night last evening.

Best of luck to all the players.

Welcome to the €500K GTD Kings of Tallinn Main Event Posted Wednesday 1st March, 2023 at 10:55(UTC+2) by Jason Glatzer

Welcome to the coverage of the 2023 Kings of Tallinn €1,100 Main Event at Olympic Park Casino and the Hilton Tallinn Park.

Today will feature the first of the three starting flights starting at noon EEST. Players will play eight levels of one-hour each.

Players start off with 30,000 in chips and will have plenty of opportunities to accumulate a huge stack with unlimited re-entries permitted throughout the day along with the first two levels on Day 2.

Due to the late end of the €555 Championship last night, the blog will kick off sometime after the first break. 

Thank you for tuning in and best of luck if you are playing in the Main Event today.

10:53 (UTC+2)
Day 1A of King of Tallinn 2023 Started
Level:      Blinds: 0/0     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.