0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0076 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event/1b/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.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.0006 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0026 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0006 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0070 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.0008 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.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '91'
0.0339 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '241'
AND `published` = 1
0.0287 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0117 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '245'
AND `published` = 1
0.0281 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '250'
AND `published` = 1
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '251'
AND `published` = 1
0.0292 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '256'
AND `published` = 1
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '263'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '91'
AND `name` = '1b'
0.0064 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.0070 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.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10912'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10877'
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` = '10873'
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` = '10872'
ORDER BY `chip_change` DESC, `busted` ASC
0.0126 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10864'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10863'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10857'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10858'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10851'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10850'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10847'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10844'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10838'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10837'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10833'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10830'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10828'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10821'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10816'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10815'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10810'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10806'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10803'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10801'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10798'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10795'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10790'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10788'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10786'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10781'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10780'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10778'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10772'
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` = '10770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10764'
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` = '10761'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10756'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10753'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10750'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10748'
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` = '10747'
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` = '10745'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '241'
ORDER BY `busted` ASC, `current_chips` DESC
0.0060 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.0057 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.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10912'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10877'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10873'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10872'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10871'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10864'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10857'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10858'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10851'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10850'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10847'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10844'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10837'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10833'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10828'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10827'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10825'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10821'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10819'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10816'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10815'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10810'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10806'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10803'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10801'
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` = '10798'
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` = '10795'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10788'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10786'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10781'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10780'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10778'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10772'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10765'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10764'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10761'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10756'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10753'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10750'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10748'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10747'
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` = '10745'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 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.0066 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.0059 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.0059 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
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
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.
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 .
Go to checkoutMore 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.