0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0139 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event/1A/updates'
ORDER BY `views` DESC
0.0112 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event/1A/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.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.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.0003 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.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.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.0037 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` = 'kings-of-tallinn-2023-main-event'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '13'
0.0416 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0084 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '50'
AND `published` = 1
0.0289 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '52'
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` = '54'
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` = '57'
AND `published` = 1
0.0289 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` = '59'
AND `published` = 1
0.0286 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` = '61'
AND `published` = 1
0.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '13'
AND `name` = '1A'
0.0063 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '50'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '50'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.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` = '2221'
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` = '2219'
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` = '2216'
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` = '2214'
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` = '2212'
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` = '2210'
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` = '2209'
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` = '2208'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2205'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2204'
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` = '2203'
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` = '2202'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2201'
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` = '2198'
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` = '2197'
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` = '2193'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2192'
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` = '2190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2188'
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` = '2187'
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` = '2185'
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` = '2184'
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` = '2183'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2182'
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` = '2181'
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` = '2176'
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` = '2175'
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` = '2174'
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` = '2172'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2171'
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` = '2165'
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` = '2164'
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` = '2162'
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` = '2161'
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` = '2160'
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` = '2158'
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` = '2156'
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` = '2154'
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` = '2152'
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` = '2149'
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` = '2147'
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` = '2145'
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` = '2148'
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` = '2140'
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` = '2139'
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` = '2138'
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` = '50'
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` = '50'
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` = '2221'
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` = '2219'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2216'
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` = '2214'
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` = '2212'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2210'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2209'
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` = '2208'
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` = '2205'
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` = '2204'
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` = '2203'
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` = '2202'
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` = '2201'
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` = '2198'
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` = '2197'
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` = '2193'
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` = '2192'
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` = '2190'
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` = '2188'
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` = '2187'
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` = '2185'
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` = '2184'
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` = '2183'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2182'
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` = '2181'
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` = '2176'
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` = '2175'
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` = '2174'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2172'
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` = '2171'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2165'
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` = '2164'
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` = '2162'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2161'
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` = '2160'
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` = '2158'
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` = '2156'
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` = '2154'
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` = '2152'
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` = '2149'
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` = '2147'
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` = '2145'
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` = '2148'
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` = '2140'
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` = '2139'
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` = '2138'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '61'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1912
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.
End-of-Day 1a Chip Counts Posted Wednesday 1st March, 2023 at 22:01(UTC+2) by Jason Glatzer
Player
Chips
Big Blinds
Julius Tiihonen
244,000
244
Tommi Lankinen
174,800
175
Roberts Rumba
168,700
169
Francisco Racionero
144,300
144
Anthony Kauzloric
137,100
137
Janne Nevalainen
125,400
125
Michailas Miserkejevas
116,400
116
Albert Jonsson
116,200
116
Lari Pukkila
113,600
114
Kasso Laasik
110,000
110
Eirimas Tomkevicius
108,600
109
Miko Ylikoski
105,300
105
Sebastian Wahl
101,100
101
Rokas Barzdzius
101,000
101
Touko Berndtson
96,800
97
Aleksei Smirnov
95,800
96
Toivo Rinne
93,900
94
Adria Comas I Roura
93,500
94
Ignas Vaitulionis
92,700
93
Mathias Siljander
87,200
87
Leonardo Romeo
86,000
86
Joni Rantamäki
85,000
85
Stanislav Smeljov
84,900
85
Ville Jantunen
84,800
85
Benjamin Gros
83,900
84
Elias Vaaraniemi
80,700
81
Jaana Kindsigo
79,600
80
Gediminas Dirmantas
73,300
73
Federico Cirillo
71,600
72
Lasse Enojarvi
71,500
72
Mauri Dorbek
69,200
69
Andzej Bilat
69,000
69
Luigi Shehadeh
68,900
69
Igor Pihela Jr.
68,800
69
Luca Beretta
68,700
69
Julien Fuchs
68,500
69
Martynas Racinskas
67,200
67
Julius Dagys
65,000
65
Dmitrijs Arsuns
64,900
65
Jari Lahtinen
63,400
63
Jevgeni Voitovits
62,800
63
Viktors Caikins
62,400
62
Theophile TGeorge
62,300
62
Giovanni Nava
61,800
62
Javier Guinot Moya
61,000
61
Matias Knaapinen
60,900
61
Aleksandr Kuperman
60,900
61
Nikita Staroverov
60,600
61
Justas Semaška
57,800
58
Marco Regonaschi
56,900
57
Niall Farrell
56,200
56
Juri Vassin
55,900
56
Mantas Bagocius
55,500
56
Visa Kiviharju
55,300
55
Annika Anni
54,400
54
Adomas Juozapavicius
54,400
54
Andrei Mjagkov
54,400
54
Luca Sebastiani
54,300
54
Krzysztof Romanow
54,200
54
Juho Suutari
54,200
54
Kaupo Tenno
53,100
53
Magnus Pukk
52,800
53
Marita Mägi
51,500
52
Algirdas Saveikis
50,200
50
Iiro Kettunen
49,500
50
Pavels Spirins
48,400
48
Daragh Davey
47,400
47
Hannes Keskküla
46,200
46
Richard Koppel
45,800
46
Timo Laiho
44,800
45
Andrius Bielskis
43,900
44
Bartosz Mielczarek
43,800
44
Andrey Koks
43,400
43
Donatas Pilinkus
42,700
43
Paulius Vaitiekunas
42,500
43
Miika Toyras
42,000
42
Giada Fang
41,500
42
Totti Arosuo
41,100
41
Elias Suhonen
40,000
40
Raini Lelle
39,100
39
Kasperi Ilkka
37,000
37
Ilari Sahamies
35,400
35
Kristaps Renga
35,200
35
Matti Lasanen
31,800
32
Kasparas Klezys
30,600
31
Martin Häidberg
30,100
30
Ranno Sootla
30,000
30
Ivar Simmer
29,700
30
Allesandro Giordano
28,500
29
Jari Karkkainen
27,900
28
Audrius Laimelis
27,700
28
Leevi Laiho
26,400
26
Markus Ylanne
26,300
26
Kyle Maguire
24,800
25
Vllaznin Dida
24,200
24
Johan Martinsen
23,700
24
James Noonan
23,100
23
Victor Prior Fernandez Amat
23,000
23
Vadim Guk
21,700
22
Laurynas Cerniauskas
21,000
21
Yaniv Peretz
20,900
21
Deniss Davõdov
20,600
21
Victor Fernandez Garcia
20,300
20
Roope Tarmi
20,100
20
Jaakko Tirkkonen
19,800
20
Davide Muccini
18,500
19
Mati Pirn
18,000
18
Martynas Vitkauskas
18,000
18
Dmitri Dudakov
17,700
18
Henri Piironen
17,000
17
Taavi Tamm
16,000
16
Priit Vallap
15,300
15
Ignacio Garrido
15,000
15
Tarmo Tammel
15,000
15
Kaius Kiidli
14,000
14
Siim Pindis
12,600
13
Andrei Silencov
11,500
12
Final Three Hands Posted Wednesday 1st March, 2023 at 20:50(UTC+2) by Jason Glatzer
Players will soon be bagging chips as the final three hands were announced. We will post final chip counts of Day 1b within the hour.
Pukk Doubles Through Vaaraniemi Posted Wednesday 1st March, 2023 at 20:31(UTC+2) by Jason Glatzer
Main Event Day 1a Level 8: 400/800 (600) Entries: 128/227
Magnus Puuk jammed for 12,400 from middle position and was called by Elias Vaaraniemi from the cutoff.
Magnus Puuk: Elias Vaaraniemi:
Puuk won the flip after the runout improved his hand to a pair of tens.
Player
Chips
Progress
Elias Vaaraniemi
60,000
30,000
Magnus Pukk
27,000
3,000
Too Many Outs for Vetelainen to Avoid with Big Slick Posted Wednesday 1st March, 2023 at 20:11(UTC+2) by Jason Glatzer
Main Event Day 1a Level 8: 400/800 (600) Entries: 133/227
Martin Haidberg opened for 1,600 from middle position before Antti Vetelainen three-bet jammed for 10,400 from one seat over. Haidberg went into the tank for about a minute before he called.
Antti Vetelainen: Martin Haidberg:
Vetelainen was ahead when the chips were committed but the odds evened up after Haidberg hit a flush draw on the flop. Most of the table let out a small chuckle after the turn as this also gave Haidberg more outs with an open-ended straight draw.
It was neither the flush draw nor the straight draw that ultimately led to a bad beat for Vetelainen for his short stack. Instead, it was the river pairing up Haidberg to send Vetelainen to the rail.
Player
Chips
Progress
Martin Haidberg
50,000
20,000
Antti Vetelainen
0
0
Peretz Doubles His Short Stack Posted Wednesday 1st March, 2023 at 20:02(UTC+2) by Jason Glatzer
Main Event Day 1a Level 8: 400/800 (600) Entries: 138/227
Yaniv Peretz three-bet jammed from the small blind for 11,600 and was called by Pavels Spirins, who opened from the button.
Yaniv Peretz: Pavels Spirins:
Peretz was ahead when the chips went in and doubled his stack after Spirins found no love on the runout.
Player
Chips
Progress
Pavels Spirins
55,000
25,000
Yaniv Peretz
25,000
5,000
Final Blind Level of Day 1a Posted Wednesday 1st March, 2023 at 19:58(UTC+2) by Jason Glatzer
Main Event Day 1a Level 8: 400/800 (600) Entries: 138/227
The final blind level of Day 1a has kicked off with blinds at 400/800 along with an 800 big blind ante. After this level, players will bag their stacks into Friday's Day 2.
19:55 (UTC+2)
Start of Level 8 Blinds: 400/800 Ante: 800
Full House for Wahl Posted Wednesday 1st March, 2023 at 19:53(UTC+2) by Jason Glatzer
Main Event Day 1a Level 7: 300/600 (600) Entries: 141/225
Roope Tarmi checked with the on the board after the turn. Sebastian Wahl fired out for 18,200 into a pot north of 30,000. Tarmi went into the tank for more than a minute before he called.
Tarmi checked again after the river completed the board. Wahl stared down his opponent for about 15 seconds. Then the sunglasses came off with Wahl deciding what to do with Tarmi holding only 17,000 behind. Wahl eventually decided to check back.
Tarmi turned over the but his two pair was not good enough to win the hand as Wahl held for a full house to win the pot.
Player
Chips
Progress
Sebastian Wahl
121,000
91,000
Roope Tarmi
17,000
13,000
Posted Wednesday 1st March, 2023 at 19:29(UTC+2) by Jason Glatzer
Main Event Day 1a Level 7: 300/600 (600) Entries: 150/223
There was about 10,000 in the pot when both Albert Jonsson and Vadim Guk checked the flop before the action picked up on the turn.
Jonsson fired out for 10,000. Guk jammed for 35,000 and Jonsson called.
Vadim Guk: Albert Jonsson:
Guk was miles ahead with his set of nines and only needed to fade a ten on the river which would have given Jonsson a Broadway straight. The paired the board on the river instead and Guk earned a double-up through Jonsson.
Player
Chips
Progress
Vadim Guk
100,000
70,000
Albert Jonsson
40,000
10,000
Posted Wednesday 1st March, 2023 at 19:20(UTC+2) by Jason Glatzer
Main Event Day 1a Level 7: 300/600 (600) Entries: 150/222
Ivar Simmer three-bet jammed for 32,400 from the big blind and was called by Casper von Schantz, who opened from middle position.
Ivar Simmer: Casper von Schantz:
Simmer was in jeopardy of losing his stack but that all changed after he improved to a set on the flop.
"Keep it, keep it!" screamed Simmer.
His set held the rest of the way with the turn and river completing the board.
"Thank you," Simmer said either to the dealer or the poker gods.
Player
Chips
Progress
Ivar Simmer
66,000
36,000
Casper von Schantz
12,000
58,000
Firaldo Flips Like a Champ Posted Wednesday 1st March, 2023 at 19:15(UTC+2) by Jason Glatzer
One player that has yet to make it back to his seat in the Main Event is GGPoker Ambassador Niall "Firaldo" Farrell.
Instead, he decided to play the one-table, one-hand €150 GGPoker Mystery Bounty Flip&Go. Probably from miles around, people heard Firaldo celebrating.
Laura Cornelius gave him her microphone and after he won his flip he was screaming wrestling quotes before beginning to sing. It is likely we will see this in a video in the near future.
Firaldo will be playing on Day 2 thanks to winning the flip for a chance at the €5,000 guaranteed top mystery bounty along with a tasty prize pool. There is still plenty of time for other players to join Firaldo in on the fun. Best of luck to everyone flipping today!
Meanwhile, we went to count Firaldo's chip count in the Main Event as he was heading back to the table. He confirmed it was around 40,000 before saying: "Wow, 40,000! I am good at every form of poker!"
Player
Chips
Progress
Niall Farrell
40,000
18,000
18:57 (UTC+2)
Start of Level 7 Blinds: 300/600 Ante: 600
Big Stacks Around the Room Posted Wednesday 1st March, 2023 at 18:57(UTC+2) by Jason Glatzer
Player
Chips
Progress
Kasso Laasik
161,000
131,000
Michailas Miserkejevas
95,000
65,000
Juho Suutari
90,000
60,000
Dmitrijs Arsuns
87,000
7,000
Vasilij Barna
85,000
55,000
Aleksandr Kuperman
80,000
10,000
Anthony Kauzloric
80,000
5,000
Lari Pukkila
75,000
45,000
Julius Dagys
75,000
45,000
Niko Palonen
70,000
40,000
Roberts Rumba
70,000
40,000
Eirimas Tomkevicius
70,000
40,000
Igor Pihela Jr.
70,000
5,000
Final Day 1a Break Posted Wednesday 1st March, 2023 at 18:36(UTC+2) by Jason Glatzer
Players are on their final Day 1a break. Two more blind levels will be played on Day 1a including 300/600 (600) and 400/800 (800) before players bag their stacks into Friday's Day 2.
We will update some of the bigger stacks from around the room during or shortly after the break.
Dorbek Cracks Indrikovs' Rockets Posted Wednesday 1st March, 2023 at 18:25(UTC+2) by Jason Glatzer
Main Event Day 1a Level 6: 200/500 (500) Entries: 161/217
Davis Indrikovs limped from the button. Mauri Dorbek, who is on his second bullet of the day, raised to 2,000 from the small blind. Luigi Shehadeh called from the big blind before Indrikovs jacked it up to 6,500. Dorbek jammed, Shehadeh folded, and Indrikovs called off his stack of less than 20,000.
Davis Indrikovs: Mauri Dorbek:
"Aces?" asked Dorbek before the cards were turned over.
They were indeed pocket rockets but this didn't matter at the end as the runout improved Dorbek to a flush.
"Get this player out of here," Dorbek said as a joke to the floor to her fellow countrymate. "He always gets so lucky."
Player
Chips
Progress
Mauri Dorbek
65,000
54,000
David Indrikovs
0
0
Don't Miss Tonight's Mega Satellite to the Record-Breaking Main Event Posted Wednesday 1st March, 2023 at 18:12(UTC+2) by Jason Glatzer
Koks Wins the Hand Without a Deuce Posted Wednesday 1st March, 2023 at 18:11(UTC+2) by Jason Glatzer
Main Event Day 1a Level 6: 200/500 (500) Entries: 162/214
Jaanus Kippel bet 2,500 into a pot of a bit more after the flop and was called by Andrey Koks. Koks then called a bet by Kippel for 4,000 on the turn. The river completed the board.
Kippel went into the tank before he checked.
"Do you have a two?" Kippel asked.
"No," Koks laughed.
Koks opted to check the action back a few moments later. Kippel turned over the . This didn't win the hand as Koks subsequently showed the for a full house.
Player
Chips
Progress
Andrey Koks
45,000
15,000
Jaanus Kippel
25,000
5,000
Straight for Borozna to Double Through Laimelis Posted Wednesday 1st March, 2023 at 17:52(UTC+2) by Jason Glatzer
Main Event Day 1a Level 6: 200/500 (500) Entries: 163/208
Juri Borozna jammed for 19,300 over the bet of 6,000 by Audrius Laimelis. Laimelis went into the tank for about two minutes before he called.
Borozna turned over for trips. Laimelis attempted to muck his hand but the dealer turned it over as it was an all-in and a call to show he had for an overpair to the board.
Player
Chips
Progress
Juri Borozna
60,000
30,000
Audrius Laimelis
30,000
0
17:39 (UTC+2)
Start of Level 6 Blinds: 200/500 Ante: 500
200 Entries! Posted Wednesday 1st March, 2023 at 17:25(UTC+2) by Jason Glatzer
Main Event Day 1a Level 5: 200/400 (400) Entries: 162/200
Day 1a of the Main Event has reached 200 entries. With tomorrow's Day 1b field expected to be even bigger, it seems like the €500,000 guarantee is simply a placeholder and has a strong chance to be the biggest Kings of Tallinn Main Event in history when taking into account also the turbo Day 1c and late entries and re-entries permitted during the first three blind levels of Friday's Day 2.
Straight for Smirnov Posted Wednesday 1st March, 2023 at 16:58(UTC+2) by Jason Glatzer
Main Event Day 1a Level 5: 200/400 (400) Entries: 160/191
Aleksei Smirnov bet 6,000 into a pot of a bit more with the on the board. Stanislovas Vinicenka tanked for a few moments before he called.
Smirnov turned over for a turned straight and won the hand after Vinicenka mucked his cards.
Player
Chips
Progress
Aleksei Smirnov
65,000
35,000
Stanislovas Vinicenka
7,200
22,800
Von Schantz Off to Broadway Posted Wednesday 1st March, 2023 at 16:52(UTC+2) by Jason Glatzer
Main Event Day 1a Level 5: 200/400 (400) Entries: 160/188
Casper von Schantz bet 8,000 into a pot of around the same with the on the board after the turn. Victor Fernandez Garcia jammed for about 28,000 and von Schantz snap-called.
Victor Fernandez Garcia: Casper von Schantz:
Garcia was down to four-outs on the river with his two pair outmatched by his opponent's Broadway straight. Von Schantz scooped up the pot and sent Garcia to the rail after the blank river completed the board.
Player
Chips
Progress
Casper von Schantz
70,000
40,000
Victor Fernandez Garcia
0
0
Posted Wednesday 1st March, 2023 at 16:40(UTC+2) by Jason Glatzer
Main Event Day 1a Level 5: 200/400 (400) Entries: 158/180
Viktors Caikins and Algirdas Saveikis both had their stacks in the middle with the on the board just before the break.
The table exploded in shock. Saveikis turned over for a full house. The second nuts wasn't enough as Caikins woke up with for quads.
Saveikis went on break with 5,000 in chips and dusted these off the very first hand after the break.
Player
Chips
Progress
Viktors Caikins
70,000
0
Algirdas Saveikis
0
0
16:36 (UTC+2)
Start of Level 5 Blinds: 200/400 Ante: 400
Various Big Stacks at Break Posted Wednesday 1st March, 2023 at 16:36(UTC+2) by Jason Glatzer
Player
Chips
Progress
Federico Cirillo
85,000
55,000
Dmitrijs Arsuns
80,000
30,000
Raini Lelle
75,000
15,000
Viktors Caikins
70,000
40,000
Miko Ylikoski
70,000
40,000
Aleksandr Kuperman
70,000
40,000
Joni Rantamaki
70,000
40,000
Annika Anni
70,000
0
Igor Pihela Jr.
65,000
20,000
Iiro Kettunen
60,000
30,000
Toivo Rinne
60,000
30,000
Second Break Posted Wednesday 1st March, 2023 at 16:13(UTC+2) by Jason Glatzer
Players are on their second break. Blinds will increase to 200/400 with a 400 big blind ante when the action resumes.
"I Should Have Jammed" Posted Wednesday 1st March, 2023 at 16:11(UTC+2) by Jason Glatzer
Main Event Day 1a Level 4: 100/300 (300) Entries: 152/171
Anthony Kauzloric fired out for 12,000 into a pot of nearly double that with the on the board on the turn. Mauri Dorbek tanked for several minutes.
"You have ace-jack," said Kauzloric before the clock was called.
The floor came over and shared to Dorbek he had 30 seconds. About halfway through his time he announced his call.
Kauzloric turned over for Broadway and won the hand after Dorbek mucked his cards.
"I should have jammed," stated Dorbek.
"The turn or river?" asked Kauzloric.
"The river," replied Dorbek.
"I would have called anyway," shared Kauzloric. "I was already committed."
Player
Chips
Progress
Anthony Kauzloric
75,000
30,000
Mauri Dorbek
11,000
19,000
Posted Wednesday 1st March, 2023 at 15:49(UTC+2) by Jason Glatzer
Main Event Day 1a Level 4: 100/300 (300) Entries: 151/164
Krzysztof Romanow bet 5,200 into a pot of slightly more with the on the board. Dmitrijs Arsuns tanked for a moment before he called.
Romanow turned over and tapped the table after Arsuns called with to win the hand.
Player
Chips
Progress
Dmitrijs Arsuns
50,000
20,000
Krzysztof Romanow
17,000
13,000
Props to the Dedication of Benjamin Gros Posted Wednesday 1st March, 2023 at 15:37(UTC+2) by Jason Glatzer
Main Event Day 1a Level 4: 100/300 (300) Entries: 152/161
It took over 17 hours of play last night for Benjamin Gros to win the Kings of Tallinn €555 Championship for €55,500. The action ended at around 5:30 a.m. with some photos and discussions to follow.
The player from France is quite dedicated to the grind. Many would take a day off after such a long grind and a big win. But not Gros, as he just entered the Main Event looking for an even bigger payout. We enjoyed watching Gros leverage his big stack to his advantage at the final table yesterday and wish him the best of luck in the Main Event.
Meanwhile, Kyle Maguire, who traveled out to Tallinn from Scotland with Niall Farrell is also in the hunt for another big payout for his resume.
Player
Chips
Progress
Kyle Maguire
30,000
0
Benjamin Gros
30,000
0
Flush Good on a Scary Board for Kauzloric Posted Wednesday 1st March, 2023 at 15:30(UTC+2) by Jason Glatzer
Main Event Day 1a Level 4: 100/300 (300) Entries: 150/159
Marita Magi checked with the on the board after the turn. Anthony Kauzloric fired out for 2,500 into a pot of over 6,000. Magi tanked for close to a minute before she called.
The river double-paired the board. Both players checked. Kauzloric turned over for a flush and won the hand after Magi mucked.
"What the f&#k," said Jaana Kindsigo, who was also at the same table and shocked that the flush was able to hold on a scary board.
Player
Chips
Progress
Anthony Kauzloric
45,000
15,000
Jaana Kindsigo
35,000
5,000
Marita Magi
32,000
2,000
15:21 (UTC+2)
Start of Level 4 Blinds: 100/300 Ante: 300
Sviten Special Begins Posted Wednesday 1st March, 2023 at 15:20(UTC+2) by Jason Glatzer
The €250 Sviten Special tournament has just kicked off with a field of 26 entries. Sviten Special author Martin Smith, Aki Pyysing, Dainius Antanaitis, Peder Behr, and Matteo Crapanzano were among the players in action at the start of play.
Sviten Special is one of the more unique games combining both five-card draw and pot-limit Omaha in the same game. Here is how the game works:
Players start with five cards followed by a round of betting.
A flop is dealt followed by another round of betting.
Players can then discard up to all five cards or stand pat. If discarding just a single card, it will be dealt face up for all players to see. The player can then decide if they want to keep that card or get a new one face down.
A turn is dealt followed by a round of betting.
The final round of betting takes place after the river.
The best five-card draw hand wins half the pot with the best five-card Omaha hand winning the other half.
Best of luck to all of the Sviten Special players. Anyone that has any questions about the game can drop by the media desk and Jason would be happy to explain the rules in more detail along with some basic strategy.
Rockets for Messina Posted Wednesday 1st March, 2023 at 14:58(UTC+2) by Jason Glatzer
Main Event Day 1a Level 3: 100/200 (200) Entries: 141/147
Bengt-Anders Johnsson fired out for 3,600 into an already bloated four-bet pot with the on the board after the flop. Renato Messina called and Johnsson jammed on the turn for more than the 14,500 Messina had behind. Messina quickly called this as well and had Johnsson drawing dead.
Renato Messina: Bengt-Anders Johnsson:
The inconsequential paired the board on the river to make Messina's double-up official.
Player
Chips
Progress
Renato Messina
50,000
26,000
Bengt-Anders Johnsson
19,000
11,000
Full House for Pihela Jr. Posted Wednesday 1st March, 2023 at 14:49(UTC+2) by Jason Glatzer
Main Event Day 1a Level 3: 100/200 (200) Entries: 139/143
Andzej Bilat checked the river with the on the board before Igor Pihela Jr. fired out a pot-sized bet of 7,000.
Bilat tanked for close to a minute before he called. Pihela Jr. instantly turned over for a full house. Bilat actually had the case jack as he flashed the before tossing his hand into the muck.
Player
Chips
Progress
Igor Pihela Jr.
45,000
15,000
Andzej Bilat
14,000
16,000
Posted Wednesday 1st March, 2023 at 14:41(UTC+2) by Jason Glatzer
Main Event Day 1a Level 3: 100/200 (200) Entries: 135/139
Raini Lelle has one of the bigger early stacks in the room sitting on around 60,000 in chips. He just won a three-bet pot against Kasperi IIkka. There was a continuation bet and a call to bring the pot north of 10,000 after the came on the flop.
The turn and river brought no action. Lelle turned over and won the pot with his top pair and king kicker after Ilkaa folded his hand.
Meanwhile, GGPoker Ambassador Niall "Firaldo" Farrell is in the house and already has nearly a double starting stack as well. Farrell is a well-established online and live poker pro with more than $6.5 million in live tournament cashes as tracked by The Hendon Mob. He has found some success here in Tallinn as back in 2021 he shipped the Tallinn Summer Showdown €1,000 Main Event for €32,125.
Player
Chips
Progress
Raini Lelle
60,000
30,000
Niall Farrell
58,000
28,000
Kasperi Ilkka
24,000
6,000
Posted Wednesday 1st March, 2023 at 14:26(UTC+2) by Jason Glatzer
Main Event Day 1a Level 3: 100/200 (200) Entries: 130/134
Antti Vetelainen checked with the on the board after the flop before Renato Messina fired out for 800 into a pot of 2,900. Vetelainen called and both players checked the turn.
The river completed the board. Vetelainen fired out for 4,200. Messina tanked for close to two minutes before he found a call. Vetelainen turned over for a turned flush. This got the job done as Messina opted to muck his cards.
Player
Chips
Progress
Antti Vetelainen
45,000
15,000
Renato Messina
24,000
6,000
14:17 (UTC+2)
Start of Level 3 Blinds: 100/200 Ante: 200
First Break Posted Wednesday 1st March, 2023 at 14:13(UTC+2) by Jason Glatzer
Main Event Day 1a Level 2: 100/100 (100) Entries: 127/131
Players are on their first break. After the break, we will be on the floor reporting hands until the conclusion of Day 1a at around 8:30 p.m.
Kristaps Kalva, Jari-Pekka Rattya, and Juho Santala all hit the rail during Level 2 and haven't re-entered at least as of yet.
Player
Chips
Progress
Juho Santala
0
0
Jari-Pekka Rattya
0
0
Kristaps Kalva
0
0
Anni Ousts Al-Kharzaji Posted Wednesday 1st March, 2023 at 13:32(UTC+2) by Jason Glatzer
Main Event Day 1a Level 2: 100/100 (100) Entries: 120/121
While Level 1 was rather quiet, the action picked up at Table 7 during the second blind level. Mohammed Al-Khazraji was down to 10,000 in chips. He jammed these in over a bet and a call with the on the board with the .
Annika Anni woke up with for trips. No hearts came on the turn or river and Al-Khazraji was the first casualty of the day while Anni had the early chip lead.
Player
Chips
Progress
Annika Anni
70,000
40,000
Mohammed Al-Khazraji
0
0
13:10 (UTC+2)
Start of Level 2 Blinds: 100/100 Ante: 100
More Than 100 Entries Posted Wednesday 1st March, 2023 at 13:02(UTC+2) by Jason Glatzer
Main Event Day 1a Level 1: 100/100 Entries: 101/101
Day 1a of the Main Event has already grown to more than 100 entries as players continue to file into the tournament arena.
Posted Wednesday 1st March, 2023 at 13:01(UTC+2) by Jason Glatzer
Main Event Day 1a Level 1: 100/100 Entries: 85/85
The Day 1a field of the Main Event has already grown to 85 entries and counting. Here is a look at some of the early players in the field.
Player
Chips
Progress
Juuso Kauppi
30,000
0
Bartosz Mielczarek
30,000
0
Lukas Soucek
30,000
0
Leonardo Romeo
30,000
0
Vytautas Kacerauskas
30,000
0
Jaana Kindsigo
30,000
0
Julien Fuchs
30,000
0
Andrius Bielskis
30,000
0
12:59 (UTC+2)
Start of Level 1 Blinds: 100/100 Ante: 0
Cards in the Air Posted Wednesday 1st March, 2023 at 12:03(UTC+2) by Jason Glatzer
Main Event Day 1a Level 1: 100/100 Entries: 61/61
The Main Event has kicked off the first of its three opening flights. There were 61 entries to start the day. This figure will grow with many players planning to late-register after a late night last evening.
Best of luck to all the players.
Welcome to the €500K GTD Kings of Tallinn Main Event Posted Wednesday 1st March, 2023 at 10:55(UTC+2) by Jason Glatzer
Welcome to the coverage of the 2023 Kings of Tallinn €1,100 Main Event at Olympic Park Casino and the Hilton Tallinn Park.
Today will feature the first of the three starting flights starting at noon EEST. Players will play eight levels of one-hour each.
Players start off with 30,000 in chips and will have plenty of opportunities to accumulate a huge stack with unlimited re-entries permitted throughout the day along with the first two levels on Day 2.
Due to the late end of the €555 Championship last night, the blog will kick off sometime after the first break.
Thank you for tuning in and best of luck if you are playing in the Main Event today.
10:53 (UTC+2)
Day 1A of King of Tallinn 2023 Started Level:Blinds: 0/0 Ante: 0
Your search results are valid for .
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.
runout improved his hand to a pair of tens.
flop. Most of the table let out a small chuckle after the 
river pairing up Haidberg to send Vetelainen to the rail.
runout.
on the board after the turn. Sebastian Wahl fired out for 18,200 into a pot north of 30,000. Tarmi went into the tank for more than a minute before he called.
flop before the action picked up on the 
flop.
river completing the board.
river completed the board.
for a full house.
for a turned straight and won the hand after Vinicenka mucked his cards.
for a full house. The second nuts wasn't enough as Caikins woke up with 
on the board after the flop. Renato Messina called and Johnsson jammed on the 
turn for more than the 14,500 Messina had behind. Messina quickly called this as well and had Johnsson drawing dead.
£ GBP
$ USD
€ EUR
