0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0060 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event/1b/updates' ORDER BY `views` DESC

0.0082 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_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.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.0001 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.0064 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.0004 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` = '2024_KOT_1100_Main_Event'

0.0002 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '91'

0.0207 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0041 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '241' AND `published` = 1

0.0206 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` = '245' AND `published` = 1

0.0211 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` = '250' AND `published` = 1

0.0210 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` = '251' AND `published` = 1

0.0208 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0041 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '256' AND `published` = 1

0.0205 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0057 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '263' AND `published` = 1

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '91' AND `name` = '1b'

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

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

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

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10887' 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` = '10882' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10873' 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` = '10872' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10864' 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` = '10863' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10858' 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` = '10851' 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` = '10850' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10838' 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` = '10837' 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` = '10833' 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` = '10830' 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` = '10828' 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` = '10827' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10821' 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` = '10819' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10816' 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` = '10815' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10795' 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` = '10790' 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` = '10788' ORDER BY `chip_change` DESC, `busted` ASC

0.0144 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10786' 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` = '10781' 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` = '10780' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10761' 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` = '10756' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10753' 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` = '10750' 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` = '10748' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

0.0148 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10887' 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` = '10882' 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` = '10879' 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` = '10877' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10871' 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` = '10869' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10864' 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` = '10863' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10857' 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` = '10858' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10844' 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` = '10838' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10827' 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` = '10825' 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` = '10821' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10819' 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` = '10816' 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` = '10815' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10806' 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` = '10803' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10795' 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` = '10790' 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` = '10788' 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` = '10786' 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` = '10781' 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` = '10780' 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` = '10778' 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` = '10772' 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` = '10770' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0147 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10761' 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` = '10756' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '10747' 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` = '10745' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0004 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2351

English
Kings of Tallinn 2024 Event #29: €1,100 Main Event (English) Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 1b
20:55 (UTC+0)
Day 1b of Kings of Tallinn 2024 Ended
Level: 8     Blinds: 500/1,000     Ante: 1,000
2024 Kings of Tallinn €350 Cup Champion Sven Omland Bags Day 1b Chip Lead Posted Thursday 29th February, 2024 at 20:54(UTC+0) by Jason Glatzer

The 2024 Kings of Tallinn €1,100 Main Event has already more than lived up to its billing and will be easily the largest in the festival's 10-year history. The €500,000 guarantee was smashed less than midway through the day with nearly €600,000 in the prize pool with still tonight's Day 1c and four levels of late registration on tomorrow's Day 2 not yet factored in.

Day 1b attracted 385 entries to bring the total number of entries up to 623 entries when taking into account the 238 entries on Wednesday's Day 1a. Remarkably, already 254 players have punched their tickets including 167 players on Day 1b into Day 2.

Earlier this week, Sven Omland shipped the two-day Kings of Tallinn €350 Cup for €19,200. Today he shined the brightest again amongst the massive field and bagged the Day 1b chip lead with 233,800.

This still places him far behind the more than 300,000 bagged on Day 1a by Christian "Sleeping Beauty" Rysgaard. You can read more about that by clicking on "Day 1a" in our coverage.

Omland wasn't the only one who advanced with a big stack on Day 1b as Latvia's Adrian Imsa (205,600), Spain's Josep Pastor (196,400), Finland's Henri Wagner (193,500), and local hero Ramel Kasi (180,500) all were picking up pots from the opening bell and dominating throughout the day to end in the top five on the leaderboard.

You can check out the full chip counts by clicking on the "Chip Counts" tab in our coverage. We will be back to report the final chip counts of Day 1c and link you to the seat draw for Day 2 before the night is over.

Players Bagging Chips Posted Thursday 29th February, 2024 at 18:45(UTC+0) by Jason Glatzer

Players are bagging their chips into tomorrow's Day 2. We will update the final chip counts of the day in about an hour.

Meanwhile, Day 1c kicks off at 9 p.m. We will not be covering that flight but will provide the final chip counts and the seat draw for tomorrow's Day 2 upon its conclusion. If you believe the 2023 Kings of Tallinn Summer Showdown Main Event runner-up Phil Gross (pictured below), it is going to be huge as he shared that he believes there will be more than 225 entries in the final opening flight alone and was willing to put a drink bet behind that statement.

Players can get into the action even after Day 1c as late registration will remain open during the first four blind levels of tomorrow's Day 2.

Pastor Flushes Daunaravicius to the Rail Posted Thursday 29th February, 2024 at 18:28(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 186/385

The action paused on Josep Pastor for a few minutes with about 45,000 in the pot and the on the board before he effectively jammed betting 50,000.

Vaidas Daunaravicius paused for a few moments before he called off his stack of around 20,000. Pastor had the nuts with with a timely river to send Daunaravicius to the rail near the end of Day 1b after he turned over the for an overpair to the board.

Player Chips Progress
Josep Pastor 170,000 50,000
Vaidas Daunaravicius 0 0
Friends Collide Posted Thursday 29th February, 2024 at 18:18(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 186/385

As we mentioned earlier today, Kaisa Soursa traveled with her friend and Kings of Tallinn veteran Anne Bezdek (pictured below) from Finland to enjoy an extended week of poker action and good company at Olympic Park Casino.

They were sitting side-by-side on Table 21 and just noticed that Bezdek was not in her seat. Antti Perttula, who was also at the table, confirmed that Bezdek lost her stack and didn't simply move tables.

We learned a little later, that it was Soursa who was responsible for bringing a little friend vs. friend crime into the mix.

Perttula shared that Bezdek jammed for 14 big blinds from under the gun with king-nine. Soursa, who was one seat over, isolated with aces. The board ran dry for Bezdek and she will likely take comfort that it is travel buddy who has her chips instead of someone that she doesn't know.

Player Chips Progress
Antti Perttula 96,000 51,000
Kaisa Soursa 95,000 10,000
Anne Bezdek 0 0
Cipollini Folds Trip Ducks Facing Leinonen's Jam Posted Thursday 29th February, 2024 at 18:10(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 193/384

Federico Cipollini bet 11,500 from the big blind into a pot north of 25,000 with the on the board. Santtu Leinonen (pictured below) jammed for 38,800 and Cipollini tanked for about five minutes.

Cipollini separated out the chips he would have needed to call and was trying to ask Leinonen questions. Leinonen stayed stoically quiet and stared down at the table the entire time.

Eventually, Rolf Jauring called for time. The floor came over and consulted with the dealer who confirmed that Cipollini had plenty of time before the clock was called.

Cipollini opted to fold as the clock hit 1 second. He flashed first to his neighbor and then to the entire table that he made a big fold with thinking his trip ducks weren't good enough.

Leinonen opted not to show his hand, so we will never know if it was a good results-oriented fold or not.

Player Chips Progress
Santtu Leinonen 80,000 50,000
Federico Cipollini 57,000 18,000
Final Blind Level of Day 1b Posted Thursday 29th February, 2024 at 17:47(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 200/383

The final blind level of Day 1b has kicked off. The clock will stop near the end of the blind level when the tournament staff will randomly select the number of hands each table will need to play before the surviving players can bag their chips into tomorrow's Day 2.

Meanwhile, Day 1c will kick off in about an hour at 9 p.m. with a faster 30-minute blind structure. While we will not provide full reporting for this opening flight, we do promise to update the final statistics, chip counts, and also share a seat draw for tomorrow's Day 2.

17:44 (UTC+0)
Start of Level 8
Blinds: 500/1,000     Ante: 1,000
Ojaveer Having Fun Posted Thursday 29th February, 2024 at 17:41(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 202/382

Poker streamer Oskar Ojaveer, also known as Deckflow, was recently moved to Table 1 not too far away from Paul Koppe.

"I am having fun," Ojaveer said when we asked him about his day. 

There weren't any huge hands but Ojaveer mentioned that he may have gotten under the skin of Estonian poker legend Mauri Dorbek when he called him down on the river in a three-bet pot with just ace-high. 

Ojaveer is near an average stack with 46,500 and we wish him the best of luck on his journey in the 2024 Kings of Tallinn Main Event.

Player Chips Progress
Oskar Ojaveer 46,500 16,500
"Show One, Show All" Posted Thursday 29th February, 2024 at 17:34(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 204/382

Dawid Zielinski bet 10,000 or less with two 5,000-denominated chips in front of him into a pot of around 12,000 with the already dealt on the flop.

Justas Semaska (pictured below) tanked for more than a minute before he jammed for 19,200. Zielinski was busy getting a massage and asked for a count. His massage continued but his decision was still forthcoming. About a minute later he asked how much the bet was again.

"Too much," Zielinski said before folding his hand.

Semaska breathed a huge sigh of relief and showed a player on the rail his cards.

"Show one, show all," said the dealer.

Semaska then turned over his cards to show he made a move with the bottom pair along with a gutshot Broadway and backdoor flush draw with .

Player Chips Progress
Dawid Zielinski 85,000 15,900
Justas Semaska 40,000 10,000
Talviste Drawing Dead to Zahl Posted Thursday 29th February, 2024 at 17:11(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 212/380

Peer Zahl bet 6,500 into a pot of a bit more with the on the board after the turn. Peeter Talviste jammed for around 25,000. Zahl snap-called and had Talviste drawing dead to his straight.

Peeter Talviste:
Peer Zahl:

Talviste's chips officially went into Zahl's stack after the river completed the board.

Player Chips Progress
Peer Zahl 60,000 30,000
Peeter Talviste 0 0
Ponnio Runs Into Tori's Broadway Posted Thursday 29th February, 2024 at 17:03(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 219/379

Risto Ponnio had his stack of 18,000 committed from the button and was up against WSOPC Tallinn €1,500 Main Event fifth-place finisher Mairo Tori, who already piled up some chips before the last break.

Risto Ponnio:
Mairo Tori:

Ponnio was ahead after the flop but was already out of the chair. The turn wasn't even fully on the board as Ponnio turned over his hand understanding he was drawing dead.

"I knew it was coming," Ponnio said with a small smile.

The river made the hand official and Ponnio, who is well known for his OFC and mixed game prowess, will need to re-enter if he wants a shot at snagging a piece of what will be a record-breaking Kings of Tallinn prize pool.

Player Chips Progress
Mairo Tori 155,000 50,000
Risto Ponnio 0 0
Kasi Over 200K at Break Posted Thursday 29th February, 2024 at 16:44(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 218/376

Estonia's Ranel Kasi held the chip lead at the break and already surpassed 200,000 in chips from his 30,000 opening stack.

Check out some of the bigger stacks from around the room below:

Player Chips Progress
Ranel Kasi 225,600 120,600
Sven Omland 164,000 72,000
Henri Wagner 140,000 42,000
Jani Tuovinen 135,000 70,000
Ignacio Garrido 120,800 29,800
Margus Tuvikene 120,000 90,000
Josep Pastor 120,000 90,000
Sauli Haapaniemi 117,000 87,000
Jari-Pekka Juhola 117,000 87,000
Tomi Arponen 111,300 81,300
Mairo Tori 105,000 75,000
16:43 (UTC+0)
Start of Level 7
Blinds: 400/800     Ante: 800
Final Break Posted Thursday 29th February, 2024 at 16:24(UTC+0) by Jason Glatzer

Players are about to head on their final break of Day 1b. Blinds will increase to 400/800 (800) and 500/1,000 (1,000) before surviving players bag and tag their chips into tomorrow's Day 2.

We will update the bigger stacks from around the room shortly after the break.

Friends Bezdek and Soursa Sitting Side-By-Side Posted Thursday 29th February, 2024 at 16:21(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 229/371

Anne Bezdek has been part of the Kings of Tallinn fabric since the beginning of the event in 2015. She traveled to Estonia with her close friend Kaisa Soursa, and as fate would have it the two players are sitting side by side at Table 21.

Both players are above a starting stack but Soursa's stack is nearly a triple starting stack. It could have been more as she doubled up Antti Perttula when her king-queen didn't get there against ace-king.

"I remember there were two fives on the board," Bezdek said with a friendly smile. "And I had ten-five."

Meanwhile, Perttula took a bad beat shortly after we witnessed the fun table dynamic between two friends. Romet Martjan got his last 10,200 in the middle with king-ten and nailed a king on the flop to double up with Perttula's pocket queens missing the cut.

Anne Bezdek appeared as a guest in the inaugural episode of the OlyBet Poker Podcast chatting with Jason Glatzer, Teresa Nousiainen, and Kelly Limonova about the Kings of Tallinn and more. Check out the episode below:

Player Chips Progress
Kasia Soursa 85,000 55,000
Antti Perttula 45,000 15,000
Anne Bezdek 35,000 5,000
Romet Martjan 22,000 8,000
Ziigmund in the House Posted Thursday 29th February, 2024 at 16:06(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 234/369

Finnish online poker legend Ilari "Ziigmund" Sahamies (pictured below) is a staple here in Tallinn having attended many of the bigger festivals over the years. He is busy getting a massage and trying to build a stack.

To Ziigmund's left is the charismatic Estonian Andrey Koks and to his right is last night's eighth-place finisher in the €555 Championship Matte Karjalainen creating an interesting trio sitting side by side.

Karjalainen recently won a small pot to get back above a starting stack, while Koks is still above a starting stack as well.

Best of luck to all three players.

Player Chips Progress
Andrey Koks 50,000 20,000
Matte Karjalainen 35,000 5,000
Ilari Sahamies 33,000 3,000
PLO Mystery Bounty Champ Koppe With the Magical Seat (and a Full House) Posted Thursday 29th February, 2024 at 15:47(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 239/353

Magic flew through the air earlier this week when Paul Koppe (pictured below) defeated Janne Nevalainen heads-up in the €555 PLO Mystery Bounty after flopping a rare Royal Flush. Koppe then proceeded to take down the largest mystery bounty from the event and more.

Now, Koppe has the magical chair as he is seated in Seat 1 at Table 1 and has used that magic his poker acumen to chip up nicely on Day 1b. We learned that he picked up a big stack in a spot that would have awarded a bad beat jackpot downstairs in the casino in the cash games when his ace-king beat pocket kings with two aces and a king on the board.

In a more recent hand, Koppe fired out for 15,000 with the  on the board. Jesper Hansen went into the tank for about two minutes before he called.

Hansen mucked his hand after Koppe turned over the for a full house, however, he told the table later when they asked that he had ace-king.

Player Chips Progress
Paul Koppe 120,000 90,000
Jesper Hansen 15,000 15,000
15:33 (UTC+0)
Start of Level 6
Blinds: 300/600     Ante: 600
Baixas Unable to Get Past King-Deuce Three-Bet Special by Kauppi Posted Thursday 29th February, 2024 at 15:33(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 239/353

Jordi Baixas (pictured below) took fifth place last night in the €555 Championship out of a record-breaking 700 entries to bank €15,200. He now hopes for even better success in the €1,100 Main Event. He may not have won the following pot, but is in general heading in the right direction.

Baixas opened for 1,200 from the button and was called by Mykolas Guiga. Juuso Kauppi three-bet to 5,500 from the big blind. Baixas called and Guiga got out of the way.

The board was checked the entire way. Kauppi turned over the and his connecting king on the river was good enough as Baixas opted to muck his hand.

Player Chips Progress
Mykolas Guiga 65,000 6,000
Jordi Baixas 50,000 20,000
Juuso Kauppi 45,000 15,000
Byrne Picks Up a Small Pot Off Piik Posted Thursday 29th February, 2024 at 15:24(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 239/349

It wasn't a big hand that was important to report but it involved two notable people in FLIP founder and Queens of Tallinn host Daiva Byrne and former OlyBet Poker Manager Martin Piik with Byrne.

Don't think just because they helped grow poker that they don't know how to play as both are known as strong poker players.

Byrne, who hasn't been witnessed above a starting stack the entire day, changed that by winning a small pot off Piik. 

Piik picked up some chips before this and is well north of a starting stack.

Best of luck to both players in finding a big bag into Friday's Day 2.

Player Chips Progress
Martin Piik 50,000 20,000
Daiva Byrne 32,000 2,000
Maisins Doubles With Top Pair Posted Thursday 29th February, 2024 at 15:05(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 246/342

There was already more than 20,000 in the pot with the on the flop when Gatis Maisins (pictured below) had his 26,600 stack committed against Jani Tuovinen.

Gatis Maisins:
Jani Tuovinen:

"There we go," Tuovinen said about the turn as it opened up a few more outs with a gutshot straight draw. 

However, Tuovinen paid off Maisins after the blank river completed the board.

Player Chips Progress
Gatis Maisins 75,000 45,000
Jani Tuovinen 65,000 37,000
Day 6 Video Highlights Posted Thursday 29th February, 2024 at 14:59(UTC+0) by Jason Glatzer

Check out the video highlights from Day 6 of the 2024 Kings of Tallinn:

Event #36: €250 NLH Kicking Off Posted Thursday 29th February, 2024 at 14:57(UTC+0) by Jason Glatzer

The one-day Event #36: €250 NLH is about to begin. The tournament offers plenty of action with a starting stack of 20,000 and 20-minute blind levels.

Late registration will be open until approximately 8:15 p.m. when Level 10 begins.

Vygerdas Jonikas, WSOP Circuit Tallinn Opening Event champion Viacheslav Sultanov, and Georgios Tsouloftas (pictured below) are among the players already registered for the action.

Kasi Barrels River Posted Thursday 29th February, 2024 at 14:50(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 250/322

Estonia's Ranel Kasi had 78,000 on the break and has chipped up beyond 100,000 in the following hand.

Albert Martinez Domenech opened for 1,000 from the cutoff. Kasi three-bet to 3,000 from the big blind and Domenech called.

Kasi continued for 2,800 on the flop and for 8,000 on the turn. Domenech called both times to see the river. Kasi bet 40,000 for more than his opponent had in his stack. Domenech tanked for more than a minute before he folded.

Player Chips Progress
Ranel Kasi 105,000 75,000
Albert Martinez Domenech 20,000 10,000
Beretta Leads at Break Posted Thursday 29th February, 2024 at 14:35(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 250/322

2020 Kings of Tallinn Summer Showdown Main Event runner-up from Italy Luca Beretta led the way at the break. Check out some of the top stacks from around the room.

Player Chips Progress
Luca Beretta 108,000 78,000
Maher Mahmoud 105,000 75,000
Jani Tuovinen 102,000 72,000
Sascha Manns 99,500 34,500
Henri Wagner 98,000 8,000
Svein Mathiassen 92,000 62,000
Sven Omland 92,000 62,000
Ignacio Garrido 91,000 27,000
Tomas Pinkevicius 85,000 55,000
Oleksii Lubnin 83,200 53,200
Robertas Smolskis 83,000 53,000
14:31 (UTC+0)
Start of Level 5
Blinds: 200/500     Ante: 500
Break Time! Posted Thursday 29th February, 2024 at 14:11(UTC+0) by Jason Glatzer

Players are about to embark on their second break of Day 1b. Blinds will increase to 200/500 (500) and 300/600 (600) before the final break of the day in a little more than two hours.

We will update some of the biggest stacks from around the room shortly after the break.

Modens Doubles Through Garcia Posted Thursday 29th February, 2024 at 14:06(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 232/317

Mindaugas Bertulis opened for 1,000 from middle position and was called by Davis Modens from the hijack and Kristian Kostiander from the cutoff.  Miki Garcia three-bet to 4,200 from the small blind and only got one call by Modens.

Garcia fired out for 2,000 on the flop. Modens jammed for 11,600 and Garcia snap-called.

Davis Modens:
Miki Garcia:

Modens had a draw and eventually won the hand with two pair after the turn and river completed the board to double his stack.

Player Chips Progress
Miki Garcia 40,000 10,000
Davis Modens 35,000 5,000
"Let's See" (Or Not) Posted Thursday 29th February, 2024 at 13:43(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 253/309

Sergejs Kacapovs checked the river with the on the board before Juri Vassin fired out for 7,500 into a pot of around 24,000.

Kacapovs tanked silently for about a minute before he spoke up.

"Let's see," Kacapovs said to Vassin before tossing in a chip to call.

Although Kacapovs paid the price, he wasn't able to see as Vassin snap-mucked his cards. Kacapovs is likely not complaining about the outcome as he won the pot regardless of seeing Vassin's cards or not.

Player Chips Progress
Sergejs Kacapovs 50,000 20,000
Juri Vassin 24,000 6,000
€500K Guarantee Dusted Off! Posted Thursday 29th February, 2024 at 13:25(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 250/295

A couple of more players got into the mix to increase the Day 1b field size to 295 entries. This combined with the 238 entries from Day 1a brings 535 entries already to already dust off the €500,000 guarantee.

Now it is just a matter of how big the 2024 Kings of Tallinn €1,100 Main Event will grow to. The sky appears to be the limit based on what we have witnessed thus far.

€500K Guarantee Nearly Met Posted Thursday 29th February, 2024 at 13:22(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 248/293

The Main Event is only two players away from surpassing the lofty €500,000 guarantee during the opening moments of Level 4 on Day 1b.

13:18 (UTC+0)
Start of Level 4
Blinds: 200/400     Ante: 400
Fors Runs Into Karim's Straight Posted Thursday 29th February, 2024 at 13:03(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 243/280

Jonatan Fors (pictured below) paused for several moments before jamming for more than the 19,400 Michel Karim had in his stack before he opted to jam into a pot of around the same with the on the board.

Karim snap-called. Fors turned over the for top pair and top kicker. However, this wasn't enough as Karim had the nuts with for a straight.

Player Chips Progress
Michel Karim 60,000 30,000
Jonatan Fors 28,000 2,000
"Always Trouble With Queens" Posted Thursday 29th February, 2024 at 12:47(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 242/269

Henri Wagner (pictured below) already chipped up after ousting Hanna Heinlo after his set of fours cracked aces. He just added some more chips as follows:

Wagner from the big blind bet 5,000 into a pot of around double that with the  on the board. Pekka Virtanen quickly called from the button and the river completed the board.

Wagner fired out for 11,500. Virtanen tanked for more than a minute before he opted to call. Wagner tabled the and won the hand with and overpair to the board after Virtanen mucked. At this point, Wagner let out a huge sigh of relief.

"Always trouble with queens," Adomas Juozapavicius, who was also at the table, said to Wagner.

Wagner nodded in agreement as he began to stack up his chips.

Player Chips Progress
Henri Wagner 90,000 60,000
Pekka Virtanen 14,000 16,000
Various Big Stacks at Break Posted Thursday 29th February, 2024 at 12:30(UTC+0) by Jason Glatzer

The 2023 World Series of Poker Circuit Main Event Champion Ignacio Garrido (pictured below celebrating with friends) is looking to win another Main Event.

The Spanish player living in Estonia was in the top five of the leaderboard at the break. Check out some of the bigger stacks from around the room.

Player Chips Progress
Adrians Imsa 80,000 15,000
Mykolas Guiga 71,000 41,000
Dawid Zielinski 69,100 39,100
Frederik Brink 67,300 37,300
Ignacio Garrido 64,000 34,000
Daniyel Destici 63,800 33,800
Laur Sibold 63,000 33,000
Arto Lehtonen 62,400 22,400
Day 1b Bigger Than Day 1a Posted Thursday 29th February, 2024 at 12:25(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 228/245

Several players hopped in on the break to grow Day 1b to 245 entries. This means Day 1b is officially bigger than the 238 entries attracted during Day 1a.

Unfortunately, Finnish poker legend Aki Pyysing (pictured below at the 2023 Kings of Tallinn Summer Showdown) is one of the players on the rail. He already quickly re-entered and we wish him the best of luck on his second Day 1b bullet.

Player Chips Progress
Aki Pyysing 30,000 0
12:18 (UTC+0)
Start of Level 3
Blinds: 100/300     Ante: 300
First Break Posted Thursday 29th February, 2024 at 12:00(UTC+0) by Jason Glatzer

Players are on their first 15-minute break. Blinds will increase to 100/300 with a 300 big blind ante before moving ahead to 200/400 with a 400 big blind ante before the second break takes place.

Queens of Tallinn Host Daiva Byrne in Action Posted Thursday 29th February, 2024 at 11:51(UTC+0) by Jason Glatzer

Queens of Tallinn host and FLIP founder Daiva Byrne (pictured below) is in action and ready to rumble. Finnish poker journalist Aki Pyysing was also witnessed just entering.

Others noticed around the room include Paulius Jucys, Markku Koplimaa, Aleksandrs Krumins, and Mark Metsla.

Player Chips Progress
Mark Metsla 30,000 0
Aleksandrs Krumins 30,000 0
Markku Koplimaa 30,000 0
Paulius Jucys 30,000 0
Aki Pyysing 30,000 0
Daiva Byrne 30,000 0
Manns "Repaired Damage" While Napel "Punted Stack" Posted Thursday 29th February, 2024 at 11:47(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 205/221

"I have repaired the damage," Sascha Manns said as we walked by and noticed him on about double a starting stack after being the first player eliminated and first to re-enter.

"How did you double?" we asked.

Both Manns and 2024 Kings of Tallinn Cup champion Tobias Napel (pictured below) had a quick laugh.

"I punted my stack," Napel said with a smile.

"We were laughing because the floor was called at the end of the hand," Manns added. "Napel didn't want to show his cards at showdown when there was an all-in and a call."

Manns and Napel shared a little bit about the hand after the laughter died down.

Manns opened with cowboys and was called by Napel to see the flop. Both players checked the turn before Napel four-bet shoved the river.

Manns called and turned over the . This is when the floor was called before Napel turned over his .

"I wanted to show the table what kind of fish he is," Manns said with a laugh about Napel.

Napel laughed as well and we wish both of these friendly and fun players the best of luck.

Player Chips Progress
Sascha Manns 65,000 35,000
Tobias Napel 8,000 22,000
200 Entries Before First Break Posted Thursday 29th February, 2024 at 11:25(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 194/200

Day 1b has already attracted 200 entries before the first break with 194 players remaining. Kelly Limonova, who appeared as a guest in the debut of the OlyBet Poker Podcast, Luis Rodriguez Cruz, and Trond Aanestad were the latest three players on the rail. Cruz re-entered while the other two players have not at least as of yet returned to the Main Event action.

Player Chips Progress
Luis Rodriguez Cruz 30,000 0
Trond Aanestad 0 0
Kelly Limonova 0 0
Whose Jack Was Better? Posted Thursday 29th February, 2024 at 11:17(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 182/185

Hendry Kullamae and Maciej Komorowski (pictured below at the 2023 WSOPC Tallinn) both checked the turn with the on the board. Javier Moya bet 5,500 into a pot of 8,000. Kullamae called and about a minute later Komorowski jammed for 16,700. Moya snap-folded and Kullamae went into the tank for about two minutes.

He looked down at his cards at least twice before he opted to fold. He flashed the representing at least top pair. Komorowski opted to also show one card and turned over the . Whether his other card was better than Kullamae's card will never be officially known.

Roman Jezov and Hans Erlandsson both hit the rail during the opening minutes of Day 2. Erlandsson re-entered, while Jezov is still on the rail.

Player Chips Progress
Maciej Komorowski 36,000 6,000
Hans Erlandsson 30,000 0
Javier Moya 30,000 0
Hendry Kullamae 25,000 5,000
Roman Jezov 0 0
11:01 (UTC+0)
Start of Level 2
Blinds: 100/200     Ante: 200
Manns Runs Into Imsa's Flush Posted Thursday 29th February, 2024 at 10:58(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 159/160

It is always a pleasure to see Germany's Sascha Manns in Tallinn. Manns shared last night that other operators should pay attention to what happens in Estonia as it is the perfect combination of poker and fun.

Manns had a little less fun thus far in the Main Event and was the first player on the rail. He was also the first player to re-enter. We caught up to the table after we saw him standing up and he recapped the action as he was heading to re-enter.

It was a three-bet pot when Manns check-called a bet by Adrians Imsa (pictured below) on the flop. Manns check-raised the turn leaving just 9,000 back. That went in on the river and Imsa quickly called.

Manns had the nut flush draw on the turn and two pair on the river as he tabled the . However, this was no match to the turned flush by Imsa who had a big smile on his face after effectively doubling through Manns with .

Player Chips Progress
Adrians Imsa 65,000 35,000
Sascha Manns 30,000 0
Cowboys Good for Lehtonen Posted Thursday 29th February, 2024 at 10:39(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 138/138

Andre Al-Khabbaz check-called a bet of 3,000 by Arto Lehtonen into a pot of around 8,000 with the on the board after the turn before the river completed the board.

Al-Khabbaz checked again. Lehtonen tanked for about 20 seconds before he bet 6,000. Al-Khabbaz paused for about a minute before he called.

Lehtonen turned over the and his cowboys got the job done as Al-Khabbaz opted to muck his cards.

Meanwhile, Pasi Trollhjarta, had already chipped up at the same table with 45,000 in chips in his stack.

Player Chips Progress
Pasi Trollhjarta 45,000 15,000
Arto Lehtonen 40,000 10,000
Andre Al-Khabbaz 13,000 17,000
Century Mark Achieved Posted Thursday 29th February, 2024 at 10:21(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 109/109

There are already more than 100 players in the Day 1b field early on Level 1. This will almost certainly more than double by the end of the day.

Leibgoren Chips Up With Better Full House Than Svendsen Posted Thursday 29th February, 2024 at 10:19(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 99/99

Michel Leibgorin checked the board from the small blind before Kenneth Svendsen bet 800 from the button into a small pot. Leibgorin check-raised to 5,000. Svendsen paused for about 20 seconds before he called.

Leibgorin immediately tabled the for a full house. Svendsen flashed the representing a weaker full house before mucking the rest of his hand.

Player Chips Progress
Michel Leibgorin 37,000 7,000
Kenneth Svendsen 24,000 6,000
Early Players in Action Posted Thursday 29th February, 2024 at 10:06(UTC+0) by Jason Glatzer

Kings of Tallinn €555 Championship runner-up Andrius Bielskis (pictured below), Tomi Arponen, Hanna Heinlo, Monika Leek, Richard Melby, Davis Modens, and Tomas Pinkevicius are among the early players in action.

Player Chips Progress
Tomas Pinkevicius 30,000 0
Davis Modens 30,000 0
Richard Melby 30,000 0
Monika Leek 30,000 0
Hanna Heinlo 30,000 0
Tomi Arponen 30,000 0
Andrius Bielskis 30,000 0
Cards in the Air Posted Thursday 29th February, 2024 at 10:01(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 80/80

Day 1b kicked off with 80 players registered. This will grow significantly as yesterday began with 50 players but eventually grew to 238 entries after the eight blind levels of one hour each were in the books.

10:00 (UTC+0)
Day 1b of Kings of Tallinn 2024 Started
Level: 1     Blinds: 100/100     Ante: 100
Welcome to Day 1b of the Main Event Posted Thursday 29th February, 2024 at 08:52(UTC+0) by Jason Glatzer

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

The €500,000 guarantee will likely be smashed today with yesterday witnessing a banner crowd of 238 entries. Today boasts the final two opening flights in Day 1b at 12 p.m. and Day 1c at 9 p.m. The field will grow even bigger after that with late registration open for the first four blind levels of Friday's Day 2.

Players start with a deep stack of 30,000 in chips good for 300 big blinds if playing from Level 1. Blinds increase slowly at one-hour each throughout the tournaments providing an amazing structure. The only exception to this is during tonight's Day 1c, which will boast 30-minute levels.

Opening flight players will battle for eight blind levels. Currently, Christian "Sleeping Beauty" Rysgaard remarkably catapulted his 30,000 opening stack into 304,300 during yesterday's Day 1a to sit on top of the leaderboard heading into Thursday.

Our coverage begins when cards are in the air for Day 1b at 12 p.m. While we won't be covering the turbo Day 1c, we do promise at the end of the day to provide chip counts and a Day 2 seat draw for tomorrow.


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.