0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0070 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/tallinn_summer_showdown_555championship_2023'
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.0003 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0005 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.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0005 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.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` = 'page'
0.0038 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'tallinn_summer_showdown_555championship_2023'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'
0.0316 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` = '76'
AND `published` = 1
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '77'
AND `published` = 1
0.0287 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '78'
AND `published` = 1
0.0286 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` = '79'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '80'
AND `published` = 1
0.0284 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '81'
AND `published` = 1
0.0001 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '81'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'
AND `name` = '3'
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '81'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 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` = '81'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3786'
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` = '3776'
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` = '3775'
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` = '3771'
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` = '3769'
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` = '3766'
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` = '3763'
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` = '3760'
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` = '3761'
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` = '3758'
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` = '3756'
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` = '3751'
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` = '3750'
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` = '3749'
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` = '3747'
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` = '3745'
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` = '3741'
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` = '3739'
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` = '3736'
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` = '3734'
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` = '3731'
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` = '3727'
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` = '3725'
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` = '3729'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3721'
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` = '3720'
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` = '3716'
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` = '3711'
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` = '3710'
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` = '3707'
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` = '3717'
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` = '3705'
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` = '3702'
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` = '3700'
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` = '3697'
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` = '3694'
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` = '3692'
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` = '3691'
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` = '3690'
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` = '3689'
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` = '3685'
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` = '3682'
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` = '3688'
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` = '3681'
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` = '3680'
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` = '3679'
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` = '81'
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` = '81'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3786'
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` = '3776'
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` = '3775'
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` = '3771'
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` = '3769'
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` = '3766'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3763'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3760'
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` = '3761'
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` = '3758'
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` = '3756'
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` = '3751'
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` = '3750'
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` = '3749'
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` = '3747'
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` = '3745'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3741'
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` = '3739'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3736'
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` = '3734'
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` = '3731'
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` = '3727'
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` = '3725'
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` = '3729'
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` = '3721'
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` = '3720'
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` = '3716'
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` = '3711'
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` = '3710'
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` = '3707'
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` = '3717'
ORDER BY `chip_change` DESC, `busted` ASC
0.0093 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3705'
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` = '3702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0125 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3700'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3697'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3694'
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` = '3692'
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` = '3691'
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` = '3690'
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` = '3689'
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` = '3685'
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` = '3682'
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` = '3688'
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` = '3681'
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` = '3680'
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` = '3679'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '81'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
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.
Maikel Homin Wins Kings of Tallinn Summer Showdown €555 Championship (€56,900) Posted Wednesday 26th July, 2023 at 20:48(UTC+2) by Jason Glatzer
Records were broken and a new Kings of Tallinn legend was made in the 2023 Kings of Tallinn Summer Showdown €555 Championship Event. Estonia's Maikel Homin (pictured above) began the final day with the second shortest stack of the final 14 players and dazzled both spectators and his opponents with an amazing performance to win the event for €56,900 at Olympic Park Casino and the Hilton Tallinn Park.
The event not only was the largest of its kind at the Kings of Tallinn Summer Showdown but proved to be the biggest in Kings of Tallinn history with 573 entries creating a huge €269,310 prize pool. This was even more than the record established in February to create a new gold standard when France's Benjamin Gros defeated a field of 559 entries to win the €55,500 top prize.
"I'm very happy about the win," said Homin. "Although I would have to win two or three more similar events to consider moving up stakes."
From an observer's point of view, it appeared that Homin didn't make any mistakes, at least any major ones. This was a concern of his at the start of the day, especially with a short stack.
"In my head, I understood I can't be making the same mistakes I make sometimes while playing online poker," Homin shared. "I often make silly moves when running deep."
The heads-up affair against Finland's Henri Antikainen spanned a few hours with the lead change going back and forth. Homin noticed his opponent changing up his style, and it was one of the more entertaining heads-up matches to follow in recent history.
Event #9: €555 Championship Final Table Results
Place
Player
Country
Prize
1
Maikel Homin
Estonia
€56,900
2
Henri Antikainen
Finland
€38,450
3
Simon Forendal
Sweden
€22,760
4
Dmitri Dudakov
Estonia
€16,620
5
Michailas Miserkejevas
Lithuania
€13,010
6
Kim Lindstrom
Finland
€9,770
7
Janne Ojala
Finland
€6,700
8
Juho Heiska
Finland
€4,930
9
Jevgenijs Sapronenko
Latvia
€3,950
Event #9: €555 Championship Final Day Action
The final day began with Finnish poker streamer Juho Heiska in the lead with Henri Antikainen and Raivo Pinsel just a blind or two behind. On the flip, was the eventual winner Maikel Homin with a short stack.
In poker, no lead is safe and stacks can fall apart like they did for Pinsel who bubbled the final table when his king-eight was unable to hold against the jack-ten held by Michailas Miserkejevas. Antikainen managed to chip up and he began the final table with the chip. By this time, Homin was near the top of the pack.
A massive hand took place early at the final table where Heiska blew up his stack by three-bet jamming with king-ten suited. He ran into the queens of Ojala and Homin's cowboys to hit the rail, while Homin was inches away from the chip lead.
Dmitri Dudakov, who had the lead a few times on Day 2, took the lead after doubling through Miserkejevas in a blind vs. blind battle when his ace-nine held against ace-eight.
Dudakov's good fortunes came to an end shortly after Miserkevjevas dusted off his stack. First, Simon Forendal won a big flip against Dudakov when his fours were good against ace-jack before hitting the rail a short while later when his ace-deuce didn't match up well against Homin's ace-eight.
By this point, it was Antikainen with the big chip lead with just three players remaining. Homin doubled through Antikainen to take the chip lead but Antikainen fought back and regained control.
Homin then eliminated Forendal on a bad beat when his queen-seven got there against king-seven but was still facing a 2:1 chip disadvantage against Antikainen.
The lead went back and forth several times in the truly entertaining two-hour heads-up battle. Eventually, Antikainen, who was quite aggressive at the final table, got his hand caught in the proverbial cookie jar. He jammed with middle pair on the flop with eight-seven and got no help to get beyond the top pair held by Homin with king-nine suited to be left with crumbs.
Antikainen (pictured below) nearly evened things up by doubling through Homin twice. Both times Homin was ahead when the chips went in preflop and it appeared that Antikainen regained momentum. However, time shortly after ran out for Antikainen. This time Antikainen got it in good with ace-queen but it didn't hold after Homin called with king-ten to fall one player shy of the title.
Congrats to Maikel Homin for his epic victory and we wish him and all of the players the best of luck during this week's Kings of Tallinn Summer Showdown.
Henri Antikainen Eliminated in 2nd Place (€38,450) Posted Wednesday 26th July, 2023 at 19:24(UTC+2) by Jason Glatzer
After a couple of bad beats, Maikel Homin won the last pot while slightly behind. Henri Antikainen opened for 1.1 million. Homin jammed and Antikainen snap-called off his stack of a little more than 7 million.
Henri Antikainen: Maikel Homin:
Homin connected with his king on the board to win the tournament with two pair for a record top prize for this event of €56,900. Antikainen had tons of heart and took it well. Perhaps, the huge €38,450 runner-up prize helped soften the blow of falling one player short of the title.
Stay tuned for a recap of the final day of the 2023 Kings of Tallinn Summer Showdown €555 Championship and check out all of the final table payouts below:
Place
Player
Country
Prize
1
Maikel Homin
Estonia
€56,900
2
Henri Antikainen
Finland
€38,450
3
Simon Forendal
Sweden
€22,760
4
Dmitri Dudakov
Estonia
€16,620
5
Michailas Miserkejevas
Lithuania
€13,010
6
Kim Lindstrom
Finland
€9,770
7
Janne Ojala
Finland
€6,700
8
Juho Heiska
Finland
€4,930
9
Jevgenijs Sapronenko
Latvia
€3,950
Player
Chips
Progress
Maikel Homin
17,200,000
7,000,000
Henri Antikainen
0
0
Antikainen on Crumbs Before Coming Back With Back-to-Back Doubles Posted Wednesday 26th July, 2023 at 19:07(UTC+2) by Jason Glatzer
Maikel Homin defended his big blind after Henri Antikainen min-raised. Antikainen checked the flop.
Homin bet 600,000. Antikainen jammed and Homin called off for 6,900,000. A crowd surrounded the table as the players showed their cards.
Maikel Homin: Henri Antikainen:
"Seven please?" Antikainen pleaded.
Instead, he was drawing dead and on fumes after Homin improved to trips on the turn. The river ended the hand and Antikainen was on thin ice with crumbs in his stack.
He got a lucky double the next hand when his got there against after improving to trips on the board.
Shortly after, Antikainen jammed for 3,200,000 from the button and was called again.
Henri Antikainen: Maikel Homin:
Antikainen connected with his eight on the board to get back into the thick of things.
Player
Chips
Progress
Maikel Homin
10,200,000
600,000
Henri Antikainen
7,000,000
600,000
Antikainen Doubles With Tens Posted Wednesday 26th July, 2023 at 18:54(UTC+2) by Jason Glatzer
Henri Antikainen (pictured below) won a couple of small pots before he min-raised the button and Maikel Homin defended his big blind to see the flop. Both players checked and Homin checked again on the turn.
Antikainen fired out for 900,000 and Homin called. The river completed the board. Homin checked and Antikainen bet 1,200,000. Homin went into the tank for a few minutes before making the call.
Antikainen turned over the and lost the pot to Homin who paired his four with the .
Player
Chips
Progress
Maikel Homin
12,200,000
1,200,000
Henri Antikainen
5,000,000
1,200,000
Homin in the Lead Posted Wednesday 26th July, 2023 at 18:04(UTC+2) by Jason Glatzer
The action began small enough with a limped pot before Maikel Homin bet 275,000 on the flop. Henri Antikainen called before he called a bet of 600,000 on the turn. Homin open-jammed for 3,325,000 on the river. Antikainen tanked for several minutes before he called.
Homin turned over the for the third pair.
"You're good," said Antikainen.
"I'm good???!?" said a shocked Homin.
Antikainen had a bluff catcher with his but this wasn't good enough to beat what Homin was trying to get Antikainen off of. The stacks were fairly even for the first time during heads-up play after the hand.
Player
Chips
Progress
Henri Antikainen
8,800,000
4,000,000
Maikel Homin
8,400,000
4,000,000
King-High Gets the Job Done for Antikainen Posted Wednesday 26th July, 2023 at 17:43(UTC+2) by Jason Glatzer
It was a heck of a run for Sweden's Simon Forendal (pictured below) and he could have potentially gone further if not for the following bad beat against Maikel Homin.
Homin jammed from the small blind and Forendal called off his short stack of under 10 big blinds from the big blind.
Simon Forendal: Maikel Homin:
Homin nailed two pair on the flop and Forendal was out in third place for €22,760 after the turn and river didn't get him past Homin's two pair.
Meanwhile, Henri Antikainen will begin the heads-up battle against Homin with a nearly 2:1 chip advantage with both players already locking up €38,450 runner-up prize with a €56,900 top prize on the line for the winner.
Player
Chips
Progress
Henri Antikainen
10,375,000
125,000
Maikel Homin
6,800,000
300,000
Simon Forendal
0
0
Antikainen Back on Top Posted Wednesday 26th July, 2023 at 16:48(UTC+2) by Jason Glatzer
The chip lead was short-lived for Maikel Homin and is back with Henri Antikainen. There were 1 million chips in the pot with the on the board after the turn when Homin check-called a bet of 750,000 by Antikainen.
Homin checked again on the river. Antikainen fired out for 1,400,000 and Homin quickly called.
Homin shook his head in what appeared to be frustration with Antikainen turning over the . Homin's cards went into the muck and the exciting three-handed play continued.
Player
Chips
Progress
Henri Antikainen
10,500,000
3,500,000
Maikel Homin
6,500,000
3,000,000
Homin Snags Chip Lead Off Antikainen Posted Wednesday 26th July, 2023 at 16:42(UTC+2) by Jason Glatzer
There wasn't a ton in the pot when Henri Antikainen check-jammed the flop and was called by Maikel Homin for his stack of around 4 million.
Maikel Homin: Henri Antikainen:
Homin's overpair held after the turn and river completed the board to take his first chip lead.
Player
Chips
Progress
Maikel Homin
9,500,000
4,200,000
Henri Antikainen
7,000,000
2,900,000
16:30 (UTC+2)
Start of Level 34 Blinds: 100,000/200,000 Ante: 200,000
Break Time Posted Wednesday 26th July, 2023 at 16:13(UTC+2) by Jason Glatzer
The final three players are on break for 15 minutes. Blinds will increase to 100,000/200,000 with a 200,000 big blind ante when the action resumes.
Henri Antikainen jammed a river over a bet by Maikel Homin with the on the board. Homin tanked for a few minutes before he laid down his hand. Antikainen will have a massive chip lead once the action resumes.
Player
Chips
Progress
Henri Antikainen
10,425,000
6,325,000
Maikel Homin
4,800,000
500,000
Simon Forendal
1,950,000
1,150,000
Dmitri Dudakov Eliminated in 4th Place (€16,620) Posted Wednesday 26th July, 2023 at 15:56(UTC+2) by Jason Glatzer
Level 31: 75,000/150,000 (150,000) Entries: 3/573
Maikel Homin min-raised the button before Dmitri Dudakov jammed for about a dozen big blinds. Homin snapped it off with Dudakov at risk.
Dmitri Dudakov: Maikel Homin:
Dudakov wasn't happy about Homin's call but he pulled ahead with two pair on the flop. It was looking even better for Dudakov to double on the turn but the spiked the river to improve Homin to a better two pair to eliminate Dudakov.
Player
Chips
Progress
Maikel Homin
5,300,000
1,600,000
Dmitri Dudakov
0
0
Forendal Wins a Flip Against Dudakov Posted Wednesday 26th July, 2023 at 15:45(UTC+2) by Jason Glatzer
Level 31: 75,000/150,000 (150,000) Entries: 4/573
Simon Forendal jammed for 1,450,000 from the button. Dmitri Dudakov came in over the top for about 3,200,000 from the small blind and Henri Antikainen folded from the big blind.
Simon Forendal: Dmitri Dudakov:
Dudakov expressed his frustration on the turn after Forendal improved to a straight to win the flip after the ran out on the board.
Player
Chips
Progress
Simon Forendal
3,100,000
1,575,000
Dmitri Dudakov
1,700,000
2,400,000
15:37 (UTC+2)
Start of Level 33 Blinds: 75,000/150,000 Ante: 150,000
Michailas Miserkejevas Eliminated in 5th Place (€13,010) Posted Wednesday 26th July, 2023 at 15:17(UTC+2) by Jason Glatzer
Level 31: 50,000/125,000 (125,000) Entries: 4/573
Michailas Miserkejevas (pictured below) folded a few hands before he jammed his decimated 225,000 chip stack from under the gun. Maikel Homin called from the button and Dmitri Dudakov called from the big blind.
Dudakov and Homin checked down the board.
Homin turned over the for the bottom pair. This won the pot to oust Miserkejevas in fifth place with Dudakov showing and Miserkejevas bricking his live cards with .
Player
Chips
Progress
Dmitri Dudakov
4,100,000
1,000,000
Maikel Homin
3,700,000
100,000
Michailas Miserkejevas
0
0
Dudakov Wins Massive Pot Against Miserkejevas Posted Wednesday 26th July, 2023 at 15:02(UTC+2) by Jason Glatzer
Level 31: 50,000/125,000 (125,000) Entries: 5/573
Dmitri Dudakov jammed from the small blind with and was called by Michailas Miserkejevas with from the big blind.
Both players connected with their kickers to their ace on the runout. Dudakov had the better pair and doubled through Miserkejevas, who was left with crumbs after the hand.
Players went on a quick unscheduled toilet break after the hand.
Player
Chips
Progress
Dmitri Dudakov
5,100,000
2,400,000
Michailas Miserkejevas
250,000
2,550,000
Kim Lindstrom Eliminated in 6th Place (€9,770) Posted Wednesday 26th July, 2023 at 14:59(UTC+2) by Jason Glatzer
Level 31: 50,000/125,000 (125,000) Entries: 5/573
Kim Lindstrom jammed his short stack from the small blind of five big blinds and was looked up by Simon Forendal from blinds.
Kim Lindstrom: Simon Forendal:
Forendal's queen found some love on the board to eliminate Linstrom in sixth place for €9,770.
Player
Chips
Progress
Dmitri Dudakov
5,100,000
2,400,000
Michailas Miserkejevas
250,000
2,550,000
14:54 (UTC+2)
Start of Level 32 Blinds: 50,000/125,000 Ante: 125,000
Juho Heiska Eliminated in 7th Place (€6,700); Janne Ojala Eliminated in 8th Place (€4,930) Posted Wednesday 26th July, 2023 at 14:47(UTC+2) by Jason Glatzer
Level 31: 60,000/120,000 (100,000) Entries: 6/573
Maikel Homin came into the final day with one of the shortest stacks and now is near the chip lead after eliminating Day 2 chip leader Juho Heiska (pictured above) and Janne Ojala (pictured below) as follows.
Homin opened for 250,000 from the hijack. Heiska jammed for 1,500,000 from the small blind. Ojala called off for 625,000 from the big blind. Homin, who barely had Heiska covered, snap-called when the action came back to him.
Janne Ojala: Juho Heiska: Maikel Homin:
Homin got nervous after the flop gave Heiska a pair to improve from along with a flush draw. Heiska bricked the turn and river and Homin's rockets held to eliminate Heiska in seventh place for €6,700 and Ojala in eighth place for €4,930.
Player
Chips
Progress
Maikel Homin
3,800,000
1,775,000
Janne Ojala
0
0
Juho Heiska
0
0
Jevgenijs Sapronenko Eliminated in 9th Place (€3,950) Posted Wednesday 26th July, 2023 at 14:39(UTC+2) by Jason Glatzer
Level 30: 50,000/100,000 (100,000) Entries: 8/573
Dmitri Dudakov opened for 225,000 from early position. Maikel Homin called from the small blind before Jevgenijs Sapronenko (pictured below) jammed for 300,000 from the big blind. Both Dudakov and Homin called to see the flop.
Homin check-called a bet of 175,000 before giving up on the turn after Dudakov bet 275,000.
Jevgenijs Sapronenko: Dmitri Dudakov:
Dudakov flopped the nuts and by the time the cards were turned over Sapronenko was drawing dead. The river completed the board and Sapronenko was the first player to hit the rail at the final table.
Player
Chips
Progress
Dmitri Dudakov
2,700,000
500,000
Jevgenijs Sapronenko
0
0
Ojala Doubles Short Stack Posted Wednesday 26th July, 2023 at 14:24(UTC+2) by Jason Glatzer
Level 30: 50,000/100,000 (100,000) Entries: 9/573
Juho Heika jammed from the small blind before Janne Ojala called off his small stack of 300,000 from the big blind.
Janne Ojala: Juho Heiska:
The flop improved Ojala to a set but he had a sweat with Heiska holding an open-ended straight draw.
Heiska was calling for an ace but he bricked the turn and river to double Ojala.
Player
Chips
Progress
Juho Heiska
1,400,000
50,000
Janne Ojala
700,000
350,000
Pinsel Bubbles Final Table Posted Wednesday 26th July, 2023 at 14:12(UTC+2) by Jason Glatzer
Level 30: 50,000/100,000 (100,000) Entries: 9/573
Raivo Pinsel began the day near the chip lead but was unable to parlay that into a final table appearance. The Estonian jammed for 650,000 from the cutoff and was called by Michailas Miserkevicius from the big blind.
Raivo Pinsel: Michailas Miserkevicius:
Pinsel's king-high was unable to hold after Miserkevicius connected with his jack on the board.
Players were immediately in their seats with the action resuming after Elena Kask snapped a photo of the group of nine.
Player
Chips
Progress
Michailas Miserkejevas
2,800,000
425,000
Raivo Pinsel
0
0
"Way Too Many Outs" Posted Wednesday 26th July, 2023 at 14:03(UTC+2) by Jason Glatzer
Jonatan Fors (pictured below) jammed for 400,000 from under the gun and was cold-called by Michailas Miserkevicius from the button.
Jonatan Fors: Michailas Miserkevicius:
The table remained silent after the flop but Fors spoke up after the turn.
"Way too many outs," Fors said about his two over cards, gutshot Broadway draw, and flush draw.
Fors saw it coming as a blank river completed the board to hit the rail in 11th place for €2,780.
"Good game," Fors said to the table before collecting his payout slip.
Chip Counts at Break Posted Wednesday 26th July, 2023 at 13:50(UTC+2) by Jason Glatzer
Henri Antikainen held the lead at the break after winning a big hand against Juho Heiska without a showdown during Level 29. Check out all the chip counts below:
Player
Chips
Progress
Henri Antikainen
4,100,000
300,000
Michailas Miserkejevas
2,375,000
675,000
Dmitri Dudakov
2,200,000
900,000
Maikel Homin
2,025,000
925,000
Simon Forendal
1,525,000
125,000
Juho Heiska
1,450,000
50,000
Kim Lindstrom
1,150,000
130,000
Raivo Pinsel
850,000
1,480,000
Jevgenijs Sapronenko
750,000
555,000
Jonatan Fors
400,000
870,000
Janne Ojala
350,000
348,000
13:44 (UTC+2)
Start of Level 31 Blinds: 50,000/100,000 Ante: 100,000
Break Time Posted Wednesday 26th July, 2023 at 13:40(UTC+2) by Jason Glatzer
Players are on a 15-minute break. Blinds will increase to 50,000/100,000 with a 100,000 big blind ante when the action resumes.
Antikainen Takes the Chip Lead Posted Wednesday 26th July, 2023 at 13:24(UTC+2) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 11/573
Juho Heiska three-bet Henri Antikainen's open to 320,000. Antikainen called to see the flop. Both players checked the flop before things got more interesting on the turn.
Antikainen check-raised Heiska's 250,000 to 650,000 and Heiska called. The river completed the board and Antikainen jammed. Heiska mentioned he thought his opponent was bluffing but a few minutes later folded to give Antikainen the chip lead.
Player
Chips
Progress
Henri Antikainen
3,800,000
1,435,000
Juho Heiska
1,500,000
1,400,000
Two Out at Same Time Posted Wednesday 26th July, 2023 at 13:15(UTC+2) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 11/573
Two players hit the rail at the same time and it was a similar situation with the button jamming and the big blind calling.
The first to go was Steven Seller (pictured below). He open-jammed a short stack with and was actually ahead of Michailas Miserkejevas who called from the big blind with . The double-paired board improved Miserkejevas to a full house and Seller was out in 13th place for €2,320.
Moments later, it was Hendrik Diegenant, jammed his short stack with . Juho Heiska called from the big blind with and it looked like he would double up his opponent after Diegenant connected his ten on the flop. That all changed when Heiska improved to a better pair on the turn and Diegenant was eliminated in 12th place for €2,780.
Player
Chips
Progress
Juho Heiska
2,900,000
510,000
Michailas Miserkejevas
1,700,000
295,000
Steven Seller
0
0
Hendrik Diegenant
0
0
13:03 (UTC+2)
Start of Level 30 Blinds: 40,000/80,000 Ante: 80,000
Berggren First on the Rail Posted Wednesday 26th July, 2023 at 12:43(UTC+2) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 13/573
Moments after Homin doubled up, Phillip Berggren (pictured below) had different fortunes at the other table in play. Berggren jammed for less than 10 big blinds with before Simon Foredal three-bet shoved with .
The cowboys were more than good on the runout and Berggren was the first player on the rail on the final day in 14th place for €2,320.
Player
Chips
Progress
Simon Forendal
1,400,000
800,000
Phillip Berggren
0
0
Homin Doubles Through Dudakov Posted Wednesday 26th July, 2023 at 12:39(UTC+2) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 14/573
Maikel Homin jammed for 465,000 from the button over the min-raise open Dmitri Dudakov from the cutoff. Dudakov asked for a count before he called.
Maikel Homin: Dmitri Dudakov:
Homin flopped Yahtzee as he nailed a straight on the flop and doubled through Dudakov after the turn and river completed the board.
Player
Chips
Progress
Dmitri Dudakov
1,300,000
185,000
Maikel Homin
1,100,000
420,000
Lindstrom Doubles Through Forendal Posted Wednesday 26th July, 2023 at 12:33(UTC+2) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 14/573
Simon Forendal opened for 120,000 from the cutoff. Kim Lindstrom (pictured below) quickly jammed the button for 435,000. Forendal asked for a count before he called.
Kim Lindstrom: Simon Forendal:
Lindstrom was ahead the entire way and doubled with a flush after the ran out on the board.
Player
Chips
Progress
Kim Lindstrom
1,020,000
952,500
Simon Forendal
600,000
435,000
12:23 (UTC+2)
Start of Level 29 Blinds: 30,000/60,000 Ante: 60,000
Everyone Loves a Chop Posted Wednesday 26th July, 2023 at 12:23(UTC+2) by Jason Glatzer
Level 27: 20,000/50,000 (50,000) Entries: 14/573
The first all-in and call just took place on Table 11 but ended in no drama. Juho Heiska min-raised from early position before Maikel Homin jammed the button for 10 big blinds. Hendrik Diegenant four-bet jammed for a little more from the small blind and Heiska quickly got out of the way.
Maikel Homin: Hendrik Diegenant:
Both players took back their stacks after a chop was apparent on the flop and the chop was made official after the turn and river competed the board.
Player
Chips
Progress
Hendrik Diegenant
650,000
325,000
Maikel Homin
600,000
80,000
Small Ball Posted Wednesday 26th July, 2023 at 12:16(UTC+2) by Jason Glatzer
Level 27: 20,000/50,000 (50,000) Entries: 14/573
Despite the major fireworks last night, players are playing tight to the vest with the big money jumps and the final table looming. The short stacks are getting away with shoves at least for now.
Shuffle Up and Deal Posted Wednesday 26th July, 2023 at 12:00(UTC+2) by Jason Glatzer
Level 27: 20,000/50,000 (50,000) Entries: 14/573
The action kicked off for the final day of the €555 Championship. Best of luck to all of the players.
11:59 (UTC+2)
Start of Level 28 Blinds: 20,000/50,000 Ante: 50,000
Who Will Win the €555 Championship? Posted Wednesday 26th July, 2023 at 10:37(UTC+2) by Jason Glatzer
The time is near and the mission is clear. There are just 14 players remaining from the record-breaking €555 Championship at the 2023 Kings of Tallinn Summer Showdown at Olympic Park Casino and the Hilton Tallinn Park.
Finland's Juho Heiska (pictured above) will enter the final day in the pole position with 2,390,000 in chips good for 48 big blinds. However, Heiska's lead is far from secure there are two other players just a big blind or two behind with Henri Antikainen sitting on 2,365,000 and Raivo Pinsel with 2,330,000. While Heiska and Antikainen were near the top of the pack for a bit near the end of the day, Heiska catapulted his stack near the end of Day 2 after winning a miracle of a hand to end Day 2 with a two-outer on the river to end the dreams of €555 Championship glory for Roope Tarmi.
The final 14 players have each locked up €2,390 with much more on the line for every pay jump. Today's winner is slated to bank a tasty €56,900 top prize, which if no deal is made would surpass the previous record top prize of €55,500 won by Benjamin Gros at the 2023 Kings of Tallinn earlier this year.
The action will begin with the second half of Level 27 with blinds at 20,000/50,000 along with a 50,000 big blind ante. After this blind level, blind levels will increase every 40 minutes until a winner is crowned.
Stay tuned as we bring you the action of the 2023 Kings of Tallinn Summer Showdown €555 Championship starting at noon. Will one of the three chip leaders ship the event or will someone else rise to the occasion? Time will tell but in the meantime check out the opening chip counts for the day below:
Player
Country
Chips
Big Blinds
Juho Heiska
Finland
2,390,000
48
Henri Antikainen
Finland
2,365,000
47
Raivo Pinsel
Estonia
2,330,000
47
Dmitri Dudakov
Estonia
1,485,000
30
Michailas Miserkejevas
Lithuania
1,405,000
28
Jevgenijs Sapronenko
Latvia
1,305,000
26
Jonatan Fors
Finland
1,270,000
25
Simon Forendal
Sweden
1,035,000
21
Hendrik Diegenant
Belgium
975,000
20
Janne Ojala
Finland
698,000
14
Philip Berggren
Sweden
655,000
13
Steven Seller
Estonia
654,000
13
Kim Lindstrom
Finland
585,000
12
Maikel Homin
Estonia
535,000
11
Final Day Seat Draw Posted Wednesday 26th July, 2023 at 10:27(UTC+2) by Jason Glatzer
Table
Seat
Player
Country
Chips
Big Blinds
11
2
Hendrik Diegenant
Belgium
975,000
20
11
3
Henri Antikainen
Finland
2,365,000
47
11
4
Raivo Pinsel
Estonia
2,330,000
47
11
5
Juho Heiska
Finland
2,390,000
48
11
6
Jevgenijs Sapronenko
Latvia
1,305,000
26
11
7
Dmitri Dudakov
Estonia
1,485,000
30
11
8
Maikel Homin
Estonia
535,000
11
12
1
Steven Seller
Estonia
654,000
13
12
2
Jonatan Fors
Finland
1,270,000
25
12
3
Janne Ojala
Finland
698,000
14
12
4
Philip Berggren
Sweden
655,000
13
12
5
Michailas Miserkejevas
Lithuania
1,405,000
28
12
6
Simon Forendal
Sweden
1,035,000
21
12
7
Kim Lindstrom
Finland
585,000
12
10:27 (UTC+2)
Day 3 of Kings of Tallinn Summer Showdown 2023 Started Level: 27 Blinds: 20,000/40,000 Ante: 40,000
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.
board to win the tournament with two pair for a record top prize for this event of €56,900. Antikainen had tons of heart and took it well. Perhaps, the huge €38,450 runner-up prize helped soften the blow of falling one player short of the title.
flop.
turn. The 
river ended the hand and Antikainen was on thin ice with crumbs in his stack.
got there against 
after improving to trips on the 
board.
board to get back into the thick of things.
runout to double his short stack.
flop. Both players checked and Homin checked again on the 
river completed the board. Homin checked and Antikainen bet 1,200,000. Homin went into the tank for a few minutes before making the call.
flop. Henri Antikainen called before he called a bet of 600,000 on the 
river. Antikainen tanked for several minutes before he called.
but this wasn't good enough to beat what Homin was trying to get Antikainen off of. The stacks were fairly even for the first time during heads-up play after the hand.
river paired the board. Both players checked.
turn and 
river. Antikainen fired out for 1,400,000 and Homin quickly called.
on the board. Homin tanked for a few minutes before he laid down his hand. Antikainen will have a massive chip lead once the action resumes.
for the bottom pair. This won the pot to oust Miserkejevas in fifth place with Dudakov showing 
before Simon Foredal three-bet shoved with 
£ GBP
$ USD
€ EUR
