0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0073 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event/1B/updates'
ORDER BY `views` DESC
0.0103 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/1B/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.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.0001 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.0002 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.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 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.0036 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'kings-of-tallinn-2023-main-event'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '13'
0.0274 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '50'
AND `published` = 1
0.0317 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0090 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '52'
AND `published` = 1
0.0272 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '54'
AND `published` = 1
0.0277 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` = '57'
AND `published` = 1
0.0274 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '59'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '61'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '13'
AND `name` = '1B'
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '52'
ORDER BY `busted` ASC, `current_chips` DESC
0.0062 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` = '52'
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` = '2309'
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` = '2308'
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` = '2306'
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` = '2304'
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` = '2300'
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` = '2299'
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` = '2298'
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` = '2297'
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` = '2296'
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` = '2294'
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` = '2293'
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` = '2292'
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` = '2289'
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` = '2288'
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` = '2287'
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` = '2286'
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` = '2282'
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` = '2281'
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` = '2278'
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` = '2277'
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` = '2276'
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` = '2275'
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` = '2272'
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` = '2271'
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` = '2270'
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` = '2268'
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` = '2267'
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` = '2263'
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` = '2262'
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` = '2260'
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` = '2261'
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` = '2257'
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` = '2256'
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` = '2255'
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` = '2254'
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` = '2252'
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` = '2251'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2250'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2247'
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` = '2244'
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` = '2242'
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` = '2241'
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` = '2238'
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` = '2237'
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` = '2233'
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` = '2228'
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` = '2227'
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` = '2226'
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` = '2225'
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` = '52'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 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` = '52'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '2309'
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` = '2308'
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` = '2306'
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` = '2304'
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` = '2300'
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` = '2299'
ORDER BY `chip_change` DESC, `busted` ASC
0.0271 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2298'
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` = '2297'
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` = '2296'
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` = '2294'
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` = '2293'
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` = '2292'
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` = '2289'
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` = '2288'
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` = '2287'
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` = '2286'
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` = '2282'
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` = '2281'
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` = '2278'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2277'
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` = '2276'
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` = '2275'
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` = '2272'
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` = '2271'
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` = '2270'
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` = '2268'
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` = '2267'
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` = '2263'
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` = '2262'
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` = '2260'
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` = '2261'
ORDER BY `chip_change` DESC, `busted` ASC
0.0265 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2259'
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` = '2257'
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` = '2256'
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` = '2255'
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` = '2254'
ORDER BY `chip_change` DESC, `busted` ASC
0.0091 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2252'
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` = '2251'
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` = '2250'
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` = '2247'
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` = '2244'
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` = '2242'
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` = '2241'
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` = '2238'
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` = '2237'
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` = '2233'
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` = '2228'
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` = '2227'
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` = '2226'
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` = '2225'
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` = '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 1b Chip Counts Posted Thursday 2nd March, 2023 at 20:50(UTC+2) by Jason Glatzer
Player
Chips
Big Blinds
Dennis Berglin
192,000
192
Anatoly Filatov
175,600
176
Armend Sahiti
173,700
174
Mart Kalju
158,000
158
Tomas Kirchovas
157,400
157
Paul Koppe
157,000
157
Dainius Antanaitis
149,100
149
Priit Parmasto
148,000
148
Greger Aktell
143,000
143
Linus Lauermann
142,200
142
Oskars Gailums
141,700
142
Jari Mahonen
136,300
136
Santtu Leinonen
135,600
136
Romans Krasins
134,000
134
Gintaras Naglius
132,100
132
Gert Laanemets
124,300
124
Grantas Naujokas
123,400
123
Mairo Tori
118,400
118
Mairo Toom
117,100
117
Juhana Konttinen
115,800
116
Kaspars Renga
112,600
113
Uri Gilboa
112,100
112
Yanis Mehdi Sahli
106,800
107
Mohammed Al-Khazraji
106,300
106
Augustas Masaitis
106,000
106
Kasper Mellanen
101,400
101
Miko Miettinen
99,200
99
Josep Pastor De Ramon
97,800
98
Mikael Wulff
96,700
97
Max Avela
96,000
96
Teemu Toikkanen
95,200
95
Sven Reimaa
93,900
94
Donatas Simas
92,300
92
Jon Ander Martinez
91,500
92
Vytautas Kacerauskas
88,500
89
Stanislovas Vinicenka
88,000
88
Allan Arjut
87,200
87
Carl Gustafsson
80,700
81
Markku Koplimaa
80,700
81
Anne Bezdek
80,300
80
Antti Tuomi
79,200
79
Hanno Kerem
77,500
78
Davis Modans
76,600
77
Niki Nurmisto
75,400
75
Pekka Ikonen
75,000
75
Tuomo Niemela
75,000
75
Miska Vihervuori
72,300
72
Jani Tuovinen
72,000
72
Tapio Aaltonen
71,200
71
Gytis Bernatavicius
70,900
71
Jari-Pekka Juhola
69,600
70
Vadim Kiseliov
69,600
70
Sondre Stormyr
69,000
69
Samuli Hietala
65,800
66
Jan Granlund
65,500
66
Eero Lehtinen
63,500
64
Marek Selgeveer
63,200
63
Niklas Vakkuri
63,100
63
Virgo Laansoo
63,000
63
Nemo Vilpponen
62,600
63
Gints Ozols
60,000
60
Eirik Kristiansen
59,300
59
Mikko Ylamaki
56,400
56
Osku Karttunen
55,400
55
Peeter Talviste
54,800
55
Daniel Feirer
53,600
54
Sten Talviste
52,800
53
Artjoms Skvarkovskis
52,700
53
Mykola Shapovalov
52,400
52
Peter Hanko
52,300
52
Seppo Parkkinen
51,300
51
Aleksi Naski
50,400
50
Van Tuan Phung
50,300
50
Samuel Richards
50,100
50
Arturs Barkevics
49,600
50
Pekka Virtanen
49,000
49
Marko Keskel
47,900
48
Renato Messina
47,900
48
Vu Vuong
46,700
47
Arturs Martinsons
45,500
46
Anna-Mari Hursti
44,800
45
Alf Hjartberg
43,600
44
Mark Metsla
43,400
43
Herli Olop
43,300
43
Jari Porkka
43,300
43
Antti Vetelainen
43,100
43
Airin Pindis
42,600
43
Max Rotko
42,600
43
Mikk Sibrits
42,300
42
Tomi Lehtinen
42,200
42
Jussi Mattila
42,000
42
Michael Ibba
41,200
41
Raimo Kaljulaid
40,700
41
Kristo Kadastik
40,000
40
Jimmy Dewerdt
37,300
37
Aki Pyysing
37,300
37
Stefan Bergstrom
36,900
37
Benas Jakusevas
36,900
37
Kristian Kostiander
36,900
37
Martin Piik
36,900
37
Lassi Kolari
36,700
37
Yuzhou Yin
35,800
36
Matiss Celmins
35,500
36
Jyrki Lampinen
32,900
33
Evert Andersson
32,200
32
Marius Verikas
30,800
31
Tomas Pinkevicius
30,000
30
Anttu Hurnanen
29,800
30
Rain Molderkivi
29,000
29
Sandris Mukans
27,400
27
Keimo Suominen
27,100
27
Leevi Lindstedt
26,800
27
Joonas Lyttinen
26,500
27
Tomi Arponen
26,400
26
Annie Chen
25,800
26
Marius Morel
24,500
25
Arkadiusz Liszewski
23,600
24
Julius Kettunen
23,500
24
Vladimir Iljunin
22,900
23
Mark Berman
21,700
22
Viktor Eriksson
21,500
22
Andrejs Stenickins
21,000
21
Inigo Martin
20,800
21
Donatas Kiauleikis
20,600
21
Tuomas Roppanen
19,900
20
Teemu Kailasvuo
19,400
19
Lukas Bytautas
19,000
19
Keito Kaljulaid
17,600
18
Mohamed Barre Mohamud
17,400
17
Egle Geniene
15,300
15
Jose Antoni Gonzalez Zaragoza
15,200
15
Rauno Arras
14,600
15
Tomi Hietala
14,000
14
Oskaras Valteris
13,600
14
Hannes Praks
10,000
10
Maksim Petrov
6,000
6
Filatov Among the Chip Leaders Posted Thursday 2nd March, 2023 at 20:47(UTC+2) by Jason Glatzer
Main Event Day 1b Level 8: 400/800 (800) Entries: 143/286
GGPoker Ambassador Anatoly Filatov has been residing nearby the casino and opted to join us for the €500,000 guaranteed Main Event. So far, it looks like a good choice for Filatov as he is among the chip leaders with 175,000 in chips.
Filatov was kind enough to recall a hand that got him a good part of this stack. He opened with a suited big slick and got two players to call. Filatov fired out for 7,000 on the rainbow flop and got one player to call to see the on the turn.
Filatov bet 10,000 and got a call. A brick that Filatov couldn't recall came on the river. Filatov fired out for 30,000. His opponent jammed for a little more and Filatov called. His opponent had and lost his stack to Filatov.
In other news, Day 1b is near a close with the tournament staff announcing that four more hands will be dealt before players start to bag their stacks.
Stay tuned for the final chip counts of the day.
Day 1c will begin as soon as players clear out for Day 1b. We will provide light coverage of this final opening flight.
Player
Chips
Progress
Anatoly Filatov
175,000
145,000
Untimely Bluff for Berg Posted Thursday 2nd March, 2023 at 20:32(UTC+2) by Jason Glatzer
Main Event Day 1b Level 8: 400/800 (800) Entries: 150/286
Mairo Tori bet 8,000 into a pot north of 20,000 after the came on the flop. Roni Berg jammed over the top for about 62,000.
Tori went into the tank for several minutes before ultimately deciding to call.
Mairo Tori: Roni Berg:
Berg's play showed a lot of heart even if it didn't work this time around. Berg was drawing dead after the turn and Tori doubled up with a full house after the river completed the board.
Player
Chips
Progress
Mairo Tori
125,000
82,000
Roni Berg
15,000
45,000
Konttinen Delivers Lindberg a Cooler Posted Thursday 2nd March, 2023 at 20:22(UTC+2) by Jason Glatzer
Main Event Day 1b Level 8: 400/800 (800) Entries: 158/286
Max Rotko opened from the middle position and was called by Bjorne Lindberg from the hijack and Juhana Konttinen from the button.
Rotko and Lindberg both checked the flop. Konttinen fired out for 2,000. Rotko called before Lindberg raised to 10,000. Konttinen called before Rotko got out of the way.
Lindberg jammed the turn for 45,000 and Konttinen, who had Lindberg covered, found a call.
Bjorne Lindberg: Juhana Konttinen:
Both players had trips. However, Konttinen's queen kicker put him ahead. The river didn't change that fact and Konttinen ousted Lindberg on a cooler.
Player
Chips
Progress
Juhana Konttinen
120,000
90,000
Bjorne Lindberg
0
0
Final Day 1b Blind Level Begins Posted Thursday 2nd March, 2023 at 20:08(UTC+2) by Jason Glatzer
Main Event Day 1b Level 8: 400/800 (800) Entries: 158/286
The Day 1b field is approaching a whopping 300 entries with the action moving to the final blind level of the day.
It likely won't get there as many players that have hit the rail recently have already said they will hop into Day 1c starting at 9 p.m. instead but we will likely see a few more before the end of the day.
20:06 (UTC+2)
Start of Level 8 Blinds: 400/800 Ante: 800
Berg Doubles Through Touvinen Posted Thursday 2nd March, 2023 at 19:58(UTC+2) by Jason Glatzer
Main Event Day 1b Level 7: 300/600 (600) Entries: 160/285
Jani Tuovinen squeezed over a raiser and two callers for about 45,000 before Roni Berg called off his stack of around 25,000.
Roni Berg: Jani Touvinen:
The runout let Berg win the flip with a pair of jacks.
Player
Chips
Progress
Roni Berg
60,000
30,000
Jani Touvinen
20,000
10,000
Pihela Doubles With Two Pair Posted Thursday 2nd March, 2023 at 19:32(UTC+2) by Jason Glatzer
Main Event Day 1b Level 7: 300/600 (600) Entries: 173/282
Igor Pihela Sr. (pictured below) checked with the on the board after the turn before Juris Hlibovs bet 6,000 into a pot of 10,000. Pihela min-clicked it back to 12,000 after pausing for a minute.
Hlibovs jammed for more than the 31,400 Pihela had behind and Pihela wasted no time in finding a call.
Igor Pihela Sr.: Juris Hlibovs:
As most poker players might feel on the inside, Hlibovs seemed less than thrilled that he was behind. Hlibovs didn't improve on the river and Pihela doubled his stack with two pair.
Player
Chips
Progress
Igor Pihela Sr.
75,000
45,000
Juris Hlibovs
25,000
30,000
Posted Thursday 2nd March, 2023 at 19:21(UTC+2) by Jason Glatzer
Main Event Day 1b Level 7: 300/600 (600) Entries: 172/277
The TV table has been changed for the final two hours of the Main Event to Table 11.
You can check out everyone at the table listed below and you can watch the stream by heading to Live Stream at the Kings of Tallinn website or also at Main Event Travel.
Player
Chips
Progress
Dainius Antanaitis
117,000
3,000
Tomi Hietala
42,000
12,000
Espen Sandvik
39,000
9,000
Leevi Lindstedt
37,000
7,000
Massimo Casabona
21,000
9,000
Airin Pindis
19,000
11,000
Mohamed Barre Mohamud
16,000
14,000
Oskaras Valteris
14,000
16,000
Posted Thursday 2nd March, 2023 at 19:14(UTC+2) by Jason Glatzer
Main Event Day 1b Level 7: 300/600 (600) Entries: 173/277
Janis Vasiljevs got the last of his short stack in with and was up against Rauno Arras who was also short with .
Vasiljevs was on the rail after the ran out on the board. Arras is still below a starting stack, but earned some breathing room.
Player
Chips
Progress
Rauno Arras
20,000
10,000
Janis Vasiljevs
0
0
Late Registration Reminder Posted Thursday 2nd March, 2023 at 19:05(UTC+2) by Jason Glatzer
Late registration will be open through all of the opening flights. This is not all as it will also remain open for the first two blind levels of tomorrow's Day 2.
19:04 (UTC+2)
Start of Level 7 Blinds: 300/600 Ante: 600
500 Entries! Posted Thursday 2nd March, 2023 at 18:44(UTC+2) by Jason Glatzer
Main Event Day 1b Level 6: 200/500 (500) Entries: 175/274
The Main Event has reached over 500 entries!
Players went on a 20-minute break shortly after this milestone was reached.
Antanaitis Ousts Sandvik with a Full House Posted Thursday 2nd March, 2023 at 18:43(UTC+2) by Jason Glatzer
Main Event Day 1b Level 6: 200/500 (500) Entries: 180/271
Gatis Reigass opened for 1,100 from early position and was called by Dainius Antanaitis from middle position. Reigass continued for 800 on the flop. Antanaitis jacked it up to 3,200 and Reigass called.
Reigass check-called a bet of 6,000 by Antanaitis on the turn before checking one last time after the river. Antanaitis effectively jammed more than the pot and Reigass called off his stack of 27,000. Antanaitis won the hand with a full house with , while Reigass showed the before hitting the showers.
Player
Chips
Progress
Dainius Antanaitis
120,000
90,000
Gatis Reigass
0
0
Posted Thursday 2nd March, 2023 at 18:28(UTC+2) by Jason Glatzer
Main Event Day 1b Level 6: 200/500 (500) Entries: 185/269
Hendrik Uibo checked the flop before Juris Hlibovs bet 1,300 into about 4,000. Uibo raised to 3,800. Hlibovs clicked it back to 8,000 before Uibo jammed for about 24,000. Hlibovs called and the cards were turned over.
Henrik Uibo: Juris Hlibovs:
Hlibovs was ahead with his two pair and won the hand after Uibo was unable to improve from his top pair with the turn and river completing the board on the river.
Player
Chips
Progress
Juris Hlibovs
55,000
25,000
Henrik Uibo
0
0
Posted Thursday 2nd March, 2023 at 18:11(UTC+2) by Jason Glatzer
Main Event Day 1b Level 6: 200/500 (500) Entries: 189/265
Aigars Petrovs checked with not a ton in the pot and the on the board. Kim Holmberg bet 3,200. Petrovs raised to 11,000 and Holmberg went into the tank for at least a minute before he called.
For some reason, neither player was immediately turning over their cards to the dismay of some at the table.
Petrovs eventually turned over the for trip sixes and claimed the pot after Holmberg mucked.
Player
Chips
Progress
Kim Holmberg
105,000
75,000
Aigars Petrovs
70,000
40,000
17:55 (UTC+2)
Start of Level 6 Blinds: 200/500 Ante: 500
Not the Best Blind Level for Vist Posted Thursday 2nd March, 2023 at 17:55(UTC+2) by Jason Glatzer
Main Event Day 1b Level 5: 200/400 (400) Entries: 197/245
Carmen-Elina Vist was likely the first player with a six-figure stack but now she is on the rail. It appears that some of her chips went to tablemates Mairo Toom and Miko Miettinen, who now each hold six-figure stacks, but Toom informed us that Vist spread them around just before Vist's final table took place.
Oleg Lakota opened for 1,600 from the button. Vist jammed for 5,900. Lakota asked for a count and Vist almost accidentally turned over her cards. She caught herself before it was too late.
"I am calling anyway," Lakota said midway through the deal counting up Vist's stack and soon after tossed a chip in to call.
Carmen-Elina Vist: Oleg Lakota:
The board improved both players to a flush. Lakota's flush was better and Vist went from hero to zero in about an hour.
Player
Chips
Progress
Miko Miettinen
120,000
90,000
Mairo Toom
115,000
35,000
Oleg Lakota
45,000
15,000
Carmen-Elina Vist
0
0
PLO PKO Begins Posted Thursday 2nd March, 2023 at 17:09(UTC+2) by Jason Glatzer
Another side event just kicked off in the €250 PLO Progressive Bounty. The tournament features a round of each between four-card PLO and five-card PLO.
Adam Tomasson, Dainius Balynas, Daragh Davey, and Sebastian Simovic were some of the early players in the field.
Flush for Aktell Posted Thursday 2nd March, 2023 at 17:03(UTC+2) by Jason Glatzer
Main Event Day 1b Level 5: 200/400 (400) Entries: 199/243
Greger Aktell fired out for 12,500 into a pot of a bit more with the on the board.
Rudolfs Vegners called a few moments later only to muck his hand after seeing Aktell turned a flush with .
Player
Chips
Progress
Greger Aktell
80,000
50,000
Rudolfs Vegners
6,000
24,000
Cows Delay Lindberg Posted Thursday 2nd March, 2023 at 16:58(UTC+2) by Jason Glatzer
Main Event Day 1b Level 5: 200/400 (400) Entries: 197/240
One player that isn't yet back in his seat is Bjorne Lindberg. During the break, Lindberg went for a smoke and won 150 free spins at the same time at the Invaders from the Planet Moolah slot machine. We very often call this the "Moo Machine" as it features futuristic cows and other fun characters.
Very often, players will win more spins in the free spin mode, so we will likely not see Lindberg for the next 10 minutes.
Player
Chips
Progress
Bjorne Lindberg
45,000
15,000
Various Big Stacks at Break Posted Thursday 2nd March, 2023 at 16:46(UTC+2) by Jason Glatzer
Player
Chips
Progress
Antti Vetelainen
110,000
80,000
Tomi Lehtinen
95,000
65,000
Mart Kalju
95,000
5,000
Seppo Parkkinen
90,000
60,000
Mairo Toom
80,000
50,000
Carmen-Elina Vist
80,000
30,000
Hanno Kerem
76,000
0
Tomas Kirchovas
75,000
45,000
Nijat Rustamov
75,000
45,000
Tomas Pinkevicius
75,000
45,000
Juho Heiska
73,000
43,000
Tuomo Niemela
70,000
40,000
Sergejs Korobovs
65,000
35,000
16:38 (UTC+2)
Start of Level 5 Blinds: 200/400 Ante: 400
Second Break Posted Thursday 2nd March, 2023 at 16:22(UTC+2) by Jason Glatzer
Players are on their second break of Day 1b. We will update some of the bigger chip counts from around the room during the break.
Some of the players will take part in the €150 GGPoker Flip & Go Mystery Bounty. They just take a few minutes with a single hand being dealt. Best of luck to all of the flippers.
Value Town for Vist Posted Thursday 2nd March, 2023 at 16:18(UTC+2) by Jason Glatzer
Main Event Day 1b Level 4: 100/300 (300) Entries: 196/229
Carmen-Elina Vist bet 12,600 into a pot of around 24,000 with the on the board.
"I never bluff," shared Vist to her opponent Myro Lyytinen.
Lyytinen tanked for a few minutes while Vist was chatting it up. Eventually, Lyytinen opted to call. Vist turned over and got paid with Lyytinen turning over a small pair with .
Player
Chips
Progress
Carmen-Elina Vist
110,000
30,000
Myro Lyytinen
5,000
25,000
Day 1b Bigger Than Day 1a Posted Thursday 2nd March, 2023 at 16:15(UTC+2) by Jason Glatzer
Main Event Day 1b Level 4: 100/300 (300) Entries: 197/229
The Day 1b field is now officially already bigger than the Day 1a field with 229 entries with Day 1a attracting 227 entries. The €500,000 guarantee is also already met with 456 entries in total for a €430,520 prize pool and counting.
Kalju Wins the Battle of Estonian Big Stacks Posted Thursday 2nd March, 2023 at 15:52(UTC+2) by Jason Glatzer
Main Event Day 1b Level 4: 100/300 (300) Entries: 201/222
Mart Kalju and Peeter Talviste both had more than double their stacks at Table 3 before getting tangled up in a hand.
Kalju fired out for 6,000 into a pot of around double that with the on the board. Talviste quickly called and mucked his hand after Kalju turned over for trip fours.
Player
Chips
Progress
Mart Kalju
90,000
60,000
Peeter Talviste
60,000
30,000
"OK, I Can Rebuy" Posted Thursday 2nd March, 2023 at 15:37(UTC+2) by Jason Glatzer
Main Event Day 1b Level 4: 100/300 (300) Entries: 199/214
Ronny Albrigtsen, who chipped up since the break, and Jari-Pekka Juhola checked the flop before Jari Porkka fired out for 2,100 into a pot of around 10,000. Albrigtsen raised to 10,100. Juhola quickly folded and Porkka went into the tank for close to a minute before he jammed over the top for 22,900.
"What do you have?" Albrigtsen asked while Porkka remained stoically quiet. "Do you have jacks or tens?"
Albrigtsen tanked a bit longer before he talked himself into a call.
"If you have kings or aces, its a bit of a cooler," Albrigtsen said. "OK, I can rebuy."
Jari Porkka: Ronny Albrigtsen:
Albrigtsen got out of his seat as the turn and river completed the board. However, he sat back down as the dealer and one of the other players at the table pointed out that he had Porkka covered.
Meanwhile, we noticed Ronny Albrigtsen lost his small stack and Stefan Bittger was also recently sent to the rail.
Player
Chips
Progress
Jari Porkka
55,000
25,000
Jari-Pekka Juhola
35,000
15,000
Ronny Albrigtsen
4,000
6,000
Ronny Albrigtsen
0
0
Stefan Bittger
0
0
15:22 (UTC+2)
Start of Level 4 Blinds: 100/300 Ante: 300
Anatoly Filatov in the House! Posted Thursday 2nd March, 2023 at 15:16(UTC+2) by Jason Glatzer
Main Event Day 1b Level 3: 100/200 (200) Entries: 197/209
Niall Farrell isn't the only GGPoker Ambassador to come to the Kings of Tallinn this year as we just had a quick chat with Anatoly Filatov who is now seated at Table 1.
This was a pleasant surprise as we haven't seen Filatov in Tallinn, at least in recent years, for any of the big events.
While is he often smiling, don't let that deceive you about his poker prowess as he is one of the most successful poker players in the field with nearly $5.3 million in live tournament cashes as tracked by The Hendon Mob.
Player
Chips
Progress
Anatoly Filatov
30,000
0
Set of Tens for Simonovicius Posted Thursday 2nd March, 2023 at 15:09(UTC+2) by Jason Glatzer
Main Event Day 1b Level 3: 100/200 (200) Entries: 195/206
Andrius Simonovicius opened for 500 from under the gun. Uri Gilboa called from the cutoff before Eldars Sadih-Zade three-bet to 2,500 from the button. Both Simonovicius and Gilboa called to see the flop.
Simonovicius and Gilboa checked before Sadih-Zade went into the tank for about a minute. Sadih-Zade then opted to bet 3,000. Simonovicius tanked for a minute before he called and Gilboa quickly folded.
Simonovicius checked again on the turn. Sadih-Zade jammed for 23,700 and Simonovicius quickly called off his stack of 22,300.
Andrius Simonovicius: Eldars Sadih-Zade:
Simonovicius turned a set of tens but still had a sweat with Sadih-Zade having some outs to a flush. His flush draw didn't complete on the river for Simonovicius to win the hand and leave his opponent with crumbs.
Player
Chips
Progress
Andrius Simonovicius
60,000
30,000
Uri Gilboa
30,000
0
Eldars Sadih-Zade
1,400
28,600
200 Day 1b Entries! Posted Thursday 2nd March, 2023 at 14:57(UTC+2) by Jason Glatzer
Main Event Day 1b Level 3: 100/200 (200) Entries: 191/200
The Day 1b field has already reached 200 entries. It seems likely that it will pass the 227 entries that Day 1a attracted.
Stream Begins Posted Thursday 2nd March, 2023 at 14:55(UTC+2) by Jason Glatzer
The Kings of Tallinn will be hosting a live stream of the Main Event the rest of the way. Kristjan Laas will be the host.
We embedded the stream below but you can also check it out on a variety of sources by heading including heading to the Live Stream tabs on both the Kings of Tallinn and the Main Event Travel websites.
Joking Around With Anne Bezdek Posted Thursday 2nd March, 2023 at 14:52(UTC+2) by Jason Glatzer
Main Event Day 1b Level 3: 100/200 (200) Entries: 190/198
The Kings of Tallinn has exceeded its already high expectations. Absolutely nothing to complain about so we had to find something.
We just caught up with Anne Bezdek who is about to take her seat in the Main Event.
"Your name is now too long," we said referring to the fact before she got married a few years ago her name was just eight letters long as Anne Meri.
The chatter continued with Finnish poker reporter Juhani Tyriseva also part of the conversation when we found out she will be seated at Table 39, Seat 6.
"Are you taking your seat now?" Tyriseva asked.
"Yeah, in the bathroom," Bezdek replied as a joke. "I will look for Seat 6 there."
Bezdek is in Tallinn for just about every major international event and has had some deep runs over the years. We wish her the best of luck in the Main Event.
Player
Chips
Progress
Anne Bezdek
30,000
0
Pyysing Runs Into the Nuts Posted Thursday 2nd March, 2023 at 14:39(UTC+2) by Jason Glatzer
Main Event Day 1b Level 3: 100/200 (200) Entries: 188/195
Pavels Pecevics fired out for 5,000 into a pot of a bit more with the on the board. Aki Pyysing found the call only to muck his hand after Pecevics turned over the nuts with for the straight.
Player
Chips
Progress
Pavel Pecevics
40,000
10,000
Aki Pyysing
16,000
14,000
Slow Starts for Gronvik and Albrigtsen Posted Thursday 2nd March, 2023 at 14:32(UTC+2) by Jason Glatzer
Main Event Day 1b Level 3: 100/200 (200) Entries: 183/189
We caught up with the Norwegian poker couple Ronny Albrigtsen and Evy Albrigtsen during the break. Evy is up to 40,000 but Ronny is down to about 10,000. Ronny shared that he ran into a few bad beats and hopes to double or triple up before the next break. Although that would be nice, that isn't really necessary with the amazing structure at the Kings of Tallinn Main Event.
Meanwhile, Mikael Gronvik is also off to a slow start. In a recent hand just after the break he bet 2,000 into a pot of a bit more with the on the board. Mairo Tori quickly called. Gronvik was trying to represent a better hand than he had and showed the .
"Nice hand," Gronvik said as Tori turned over to win the pot.
Player
Chips
Progress
Mairo Tori
43,000
13,000
Evy Albrigtsen
40,000
10,000
Mikael Gronvik
19,000
11,000
Ronny Albrigtsen
10,000
20,000
14:25 (UTC+2)
Start of Level 3 Blinds: 100/200 Ante: 200
Vist Chips Up Before the Break Posted Thursday 2nd March, 2023 at 14:07(UTC+2) by Jason Glatzer
Main Event Day 1b Level 2: 100/100 (100) Entries: 169/174
Carmen-Elina Vist chipped up just before the break. She already amassed a decent stack before this hand.
Vist, who opened preflop, continued with a bet of 2,700 on the flop and was called by Tomas Zarankus and Risto Parnat.
Parnat and Vist both checked the turn. Zarankus bet 5,100. Parnat folded and Vist called. Both players checked the river. Vist turned over the which won the hand as Zarankus mucked his hand. Before mucking, Zarankus showed the to the table.
Player
Chips
Progress
Carmen-Elina Vist
80,000
50,000
Risto Parnat
30,000
0
Tomas Zarankus
15,000
15,000
First Break Posted Thursday 2nd March, 2023 at 14:02(UTC+2) by Jason Glatzer
Players are now on a quick 20-minute break. The stream will start shortly after the break, which you will able to check out by clicking on the Live Stream tab at the Kings of Tallinn website, over at the Main Event Travel blog, or many other ways. We will also embed the stream here in a post once it begins.
Meanwhile, players will be flipping during the break with some tables opening for the €150 GGPoker Flip & Go Mystery Bounty.
Player
Chips
Progress
Carmen-Elina Vist
80,000
50,000
Risto Parnat
30,000
0
Tomas Zarankus
15,000
15,000
Sviten Special Champion Tony Westby About to Enter Posted Thursday 2nd March, 2023 at 13:54(UTC+2) by Jason Glatzer
Main Event Day 1b Level 2: 100/100 (100) Entries: 163/166
Last night, Tony Westby won the €250 Sviten Special Event for €4,100 after navigating through a field of 55 entries.
Westby was hanging around with some other Norwegian players and shared with us that he plans to get into the Day 1b action of the Main Event after the break.
The Norwegian has had some success here at the Kings of Tallinn in the past as well with a much bigger score than he notched last night. Westby took fourth place in the Kings of Tallinn €3,000 High Roller back in 2020 for his biggest career live tournament cash for €30,800.
Best of luck to Westby and everyone that came in from Norway!
Player
Chips
Progress
Tony Westby
30,000
0
Ten-Trey Gets the Job Done for Juhola Posted Thursday 2nd March, 2023 at 13:28(UTC+2) by Jason Glatzer
Main Event Day 1b Level 2: 100/100 (100) Entries: 151/153
Tomi Arponen fired out for 2,100 into a pot of around 4,000 with the on the board after the turn. Jari-Pekka Juhola quickly called before both players checked down the river.
Arponen turned over which wasn't enough as Juhola connected with the board with to take down the pot.
Meanwhile, Arnas Lydeka became the second player to hit the rail in the Day 1b field at around the same time at a different table.
Player
Chips
Progress
Jari-Pekka Juhola
50,000
20,000
Tomi Arponen
20,000
10,000
Arnas Lydeka
0
0
Nikitins Freerolling Posted Thursday 2nd March, 2023 at 13:19(UTC+2) by Jason Glatzer
Main Event Day 1b Level 2: 100/100 (100) Entries: 141/142
Stefan Bittger opened for 300 from middle position. Jans Nikitins three-bet to 1,200 before Bittger jammed for 14,800. Nikitins tanked for a minute before he called.
Stefan Bittger: Jans Nikitins:
The saying goes that everyone loves a chop and likely Bittger felt that way after the following runout.
The flop provided both players backdoors to a flush. Nikitins had a true flush draw on the turn. However, the pot ended in a chop after the river completed the board.
Player
Chips
Progress
Jans Nikitins
0
15,000
Stefan Bittger
0
5,000
13:04 (UTC+2)
Start of Level 2 Blinds: 100/100 Ante: 100
Ozuls Felts Gotovusa Posted Thursday 2nd March, 2023 at 13:04(UTC+2) by Jason Glatzer
Main Event Day 1b Level 1: 100/100 Entries: 129/130
Gints Ozols and Fuad Gotovusa got their stacks locked up on the river with the on the board. According to the table, Gotovusa had which proved to be no match to the held by Ozols to win the hand with a flush.
Player
Chips
Progress
Gints Ozols
65,000
35,000
Fuad Gotovusa
0
0
Century Mark Achieved Posted Thursday 2nd March, 2023 at 12:26(UTC+2) by Jason Glatzer
Main Event Day 1b Level 1: 100/100 Entries: 103/103
Players continue to file into the Day 1b field with now over 100 entries in the mix.
Early Entries in the Field Posted Thursday 2nd March, 2023 at 12:07(UTC+2) by Jason Glatzer
Main Event Day 1b Level 1: 100/100 Entries: 67/67
Here is a look at some of the early entries in the Day 1b field.
Player
Chips
Progress
Tero Kilkanen
30,000
0
Vytautas Kacerauskas
30,000
0
Mikael Gronvik
30,000
0
Mairo Toom
30,000
0
Gytis Bernatavicius
30,000
0
Evy Albrigtsen
30,000
0
Day 1b Begins Posted Thursday 2nd March, 2023 at 12:01(UTC+2) by Jason Glatzer
Main Event Day 1b Level 1: 100/100 Entries: 64/64
Day 1b has kicked off with 64 entries already in their seats. It is anticipated that the Day 1b flight will be the biggest of the three opening flights. Best of luck to all of the players!
Welcome to Day 1b of the €500,000 Guaranteed Main Event Posted Thursday 2nd March, 2023 at 11:27(UTC+2) by Jason Glatzer
Welcome back to the 2023 Kings of Tallinn at Olympic Park Casino and the Hilton Tallinn Park.
Today we will be focusing on reporting the final two opening flights of the €500,000 guaranteed Kings of Tallinn €1,100 Main Event starting with Day 1b at 12 p.m with Day 1c beginning after Day 1b players bag their stacks at 9 p.m.
The event boasts one-hour blind levels throughout the four-day affair with the only exception being Day 1c, which is not quite turbo but still will play out quicker with 30-minute blind levels.
Players start with a healthy stack of 30,000 in chips, which will be good for 300 big blinds for the first two blind levels. They will have a chance to build a healthy stack with not only unlimited re-entries permitted throughout all of the opening flights but also during the first two blind levels of Day 2.
Bags will be passed around to the surviving players after eight blind levels of play.
As a side note, players that buy into the Main Event via Luxon Pay will be offered bubble insurance for free! A Luxon Pay representative is nearby if you have any questions.
Day 1a attracted a banner field of 227 entries with 117 players finding a bag. Day 1a chip leader Julius Tihonen was the only player to find a bag with more than 200,000 after advancing to tomorrow's Day 2 with 244,000 in chips.
After today's opening flights, the remainder of the Main Event will feature Day 2, Day 3, and the final day on March 3-5. We will be with you the entire way until a winner is crowned.
11:21 (UTC+2)
Day 1B of King of Tallinn 2023 Started Level: 1 Blinds: 100/100 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.