0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0098 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1A/updates'
ORDER BY `views` DESC
0.0003 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.0004 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.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.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.0071 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.0006 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` = 'wsopctallinn_2023_event6'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
0.0353 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0086 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1
0.0330 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0070 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1
0.0302 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` = '129'
AND `published` = 1
0.0281 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '130'
AND `published` = 1
0.0279 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` = '132'
AND `published` = 1
0.0280 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` = '135'
AND `published` = 1
0.0278 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` = '138'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
AND `name` = '1A'
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '102'
ORDER BY `busted` ASC, `current_chips` DESC
0.0063 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` = '102'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '5324'
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` = '5319'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5322'
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` = '5316'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5314'
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` = '5313'
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` = '5320'
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` = '5310'
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` = '5307'
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` = '5303'
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` = '5298'
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` = '5291'
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` = '5290'
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` = '5286'
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` = '5277'
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` = '5321'
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` = '5272'
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` = '5268'
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` = '5265'
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` = '5267'
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` = '5259'
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` = '5255'
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` = '5253'
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` = '5247'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5243'
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` = '5239'
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` = '5238'
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` = '5236'
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` = '5234'
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` = '5229'
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` = '5228'
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` = '5222'
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` = '5220'
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` = '5212'
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` = '5205'
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` = '5204'
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` = '5194'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5192'
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` = '5191'
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` = '5187'
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` = '5185'
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` = '5184'
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` = '5181'
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` = '5176'
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` = '5173'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5168'
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` = '5160'
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` = '5159'
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` = '5150'
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` = '5148'
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` = '5142'
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` = '5137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '102'
ORDER BY `busted` ASC, `current_chips` DESC
0.0056 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` = '102'
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` = '5324'
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` = '5319'
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` = '5322'
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` = '5316'
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` = '5314'
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` = '5313'
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` = '5312'
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` = '5320'
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` = '5310'
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` = '5307'
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` = '5303'
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` = '5298'
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` = '5291'
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` = '5290'
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` = '5286'
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` = '5277'
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` = '5321'
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` = '5281'
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` = '5272'
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` = '5268'
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` = '5265'
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` = '5267'
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` = '5259'
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` = '5255'
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` = '5253'
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` = '5248'
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` = '5247'
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` = '5243'
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` = '5239'
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` = '5238'
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` = '5236'
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` = '5234'
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` = '5229'
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` = '5228'
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` = '5222'
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` = '5220'
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` = '5212'
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` = '5205'
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` = '5204'
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` = '5194'
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` = '5192'
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` = '5191'
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` = '5187'
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` = '5185'
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` = '5184'
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` = '5181'
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` = '5176'
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` = '5173'
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` = '5168'
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` = '5166'
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` = '5160'
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` = '5159'
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` = '5150'
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` = '5148'
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` = '5142'
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` = '5137'
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` = '5273'
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` = '138'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
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.
Joni Rantamaki Bags Day 1a Chip Lead Posted Tuesday 19th September, 2023 at 20:18(UTC+0) by Jason Glatzer
The €1 million guaranteed Main Event was off to a hot start at Olympic Park Casino and the Hilton Tallinn Park with 139 runners getting into the action.
Finland's Joni Rantamaki (pictured above) was the star of the day as after 10 levels of 40 minutes each he parlayed his 50,000 opening stack into a massive pile of 272,000 to lead the 63 Day 1a survivors.
Estonia's Igor Pihela Sr. isn't too far behind in second place with 257,000 and his son Igor Pihela Jr. also managed to bag a top-five stack with 210,000.
In between the father and son duo were Taiwan's Yi-Zhan Peng (215,000) and up-and-coming Dutch superstar Gilles Simon (211,500).
It appeared that two-time WSOP bracelet winner and all-around Finnish baller Juha Helppi (pictured above) would also bag a big stack as he was cruising along most of the day near the top of the chip counts. He first got unlucky against 2018 Estonian Championship of Poker Main Event Champion Ermo Kosk as he witnessed his queens go down the toilet against tens after a ten spiked the river.
Shortly after, Helppi lost another big hand to Pihela Jr. that helped the latter catapult to the top five of the Day 1a chip counts when his two-pair proved to be no match against a straight. He was left with crumbs after that before handing them over the Ilya Nikiforov after jamming in the dark with five-three and not getting there against queen-jack. Helppi is the consummate pro who will shake off his misfortune at the end of the day and has confirmed he will be back battling tomorrow for Day 1b.
The live reporting crew at OlyBet.tv will be back Wednesday at 12 p.m. from when cards are in the air for Day 1b. Best of luck to all of the Day 1b players tomorrow!
Final Day 1a Chip Counts Posted Tuesday 19th September, 2023 at 18:54(UTC+0) by Jason Glatzer
Finland's Joni Rantamaki led the way among the 66 survivors on Day 1a. Check out the full chip counts below and stay tuned for a recap within the hour.
Player
Chips
Big Blinds
Joni Rantamaki
272,000
109
Igor Pihela Sr.
257,000
103
Yi-Zhan Peng
215,000
86
Gilles Simon
211,500
85
Igor Pihela Jr.
210,000
84
Aleksei Smirnov
204,500
82
Pekka Ikonen
203,500
81
Teemu Toikkanen
203,000
81
Samuel Richards
194,500
78
Marco Kolle
190,000
76
Artur Kulanurk
189,000
76
Eriks Krumins
176,500
71
Maksim Petrov
165,000
66
Vidar Assersen
163,500
65
Jan-Mikael Kesanen
157,500
63
Tomasz Mroz
156,000
62
Ermo Kosk
152,500
61
Sebastian Wahl
150,500
60
Hendrik Ulbo
149,000
60
Juha Elo
137,000
55
Torbjorn Larsen
132,000
53
Max Rotko
129,500
52
Hendry Kullamae
126,500
51
Jesus Ucero
122,000
49
Marko Harkonen
121,000
48
Aleksi Naski
120,500
48
Tornike Tchitadze
116,000
46
Toms Civcs
115,500
46
Verneri Hakkinen
115,000
46
Tapio Aaltonen
113,500
45
Algirdas Saveikis
106,000
42
Arko Akenparg
104,000
42
Tommi Lankinen
102,000
41
Ilya Nikiforov
101,000
40
Jimi Koponen
98,000
39
Rinalds Zimka
98,000
39
Mario Linno
97,000
39
Dmitrijs Meless
82,000
33
Johannes Levola
80,000
32
Karlis Kreslins
75,000
30
Joshua Stewart
74,500
30
Dan Korsunskyy
73,000
29
Alger Pissarev
71,500
29
Sergejs Piratovs
71,000
28
Hanna Heinlo
68,500
27
Damian Siewert
66,500
27
Damian Siewert
65,500
26
DamiaTUVAn Siewert
54,000
22
Kaspars Butans
53,000
21
Kristo Erala
51,000
20
Ken Okada
51,000
20
Dominik Ostrowski
50,500
20
Kris Tikka
50,000
20
Aleksander Lammas
47,500
19
Maikel Homin
44,000
18
Sergei Aleksejev
40,500
16
Rasmus Sepping
34,500
14
Rauno Remmel
30,000
12
Sten Talviste
30,000
12
Marko Vest
28,500
11
Raido Tsmir
19,000
8
Aurelijus Sipavicius
15,500
6
Olafs Karlins
12,000
5
The Unfortunate Demise of Juha Helppi Posted Tuesday 19th September, 2023 at 18:53(UTC+0) by Jason Glatzer
WSOP bracelet winner Juha Helppi (pictured below) was cruising all day long but noticeably missing from the end-of-the-day chip counts.
During the final level of mayhem at the end of the day, Helppi's stack fell apart. It all began with a bad beat delivered by Ermo Kosk who doubled through Helppi when his tens got their on the river against queens.
Igor Pihela Jr. then took most of the rest of what Helppi had left when he nailed a straight against Helppi's two pair. The crumbs then went to a third Estonian in Ilya Nikiforov when he jammed in the dark with five-three and didn't get there against queen-jack.
We will likely see Helppi back tomorrow as he shared with us earlier today that he is here only to grind the Main Event and perhaps also the €3,000 6-Max High Roller if he isn't deep in the Main Event on Day 3.
Players Bagging Chips Posted Tuesday 19th September, 2023 at 17:52(UTC+0) by Jason Glatzer
Players are bagging chips for Friday's Day 2. Stay tuned for the final chip counts of the day along with a recap shortly.
Simon Heads to Broadway Posted Tuesday 19th September, 2023 at 17:49(UTC+0) by Jason Glatzer
Level 10: 1,000/2,000 (2,000) Entries: 66/138
Teemu Toikkanen went into the tank for several minutes facing a bet by Gilles Simon for 32,500 into a pot of around 50,000 with the on the board after the river.
Eventually, Toikkanen found a call only to muck his hand moments later after Simon turned over the for Broadway.
Player
Chips
Progress
Gilles Simon
250,000
200,000
Teemu Toikanen
70,000
40,000
Final Five Hands Posted Tuesday 19th September, 2023 at 17:47(UTC+0) by Jason Glatzer
The floor just stopped the clock with nearly 11 minutes remaining on Level 10 and informed the players that each table will play five more hands before bagging up their stacks to Friday's Day 2.
Big Hero Call On The River Posted Tuesday 19th September, 2023 at 17:44(UTC+0) by Alaxandar Georgiev
Level 10: 1,000/2,000 (2,000) Entries: 68/138
Marko Harkonen was at it again on the board keeping up the aggression that got him a big stack so far, he bet another 15,000 into the pot and Joni Rantamaki called.
The river came and it was Harkonen's turn again, he threw 35,000 chips in the middle, and shortly after Rantamaki made the call.
Marko Harkonen: Joni Rentamaki:
The great read from Rantamaki earned him a pot worth more than 120,000 chips as we are 15 minutes away from ending Day 1.
Player
Chips
Progress
Joni Rantamaki
270,000
2,000
Marko Harkonen
100,000
21,000
Two-Times Finalist Flips Again Posted Tuesday 19th September, 2023 at 17:26(UTC+0) by Alaxandar Georgiev
Level 10: 1,000/2,000 (2,000) Entries: 73/138
Joshua Stewert, who has already managed two final tables in his first two WSOP Circuit Events, was involved in another flip as he opened the pot to 4,000 and was re-raised to 12,000 by Ken Okada from the small blind. Stewert made a four-bet to 27,000 which was followed by a quick all-in for Okada's remaining 45,000 chips.
Joshua Stewert: Ken Okada:
The flop didn't bring Stewert any luck and he was still behind in the hand. The turn was and the river was which secured the pot for Okada.
Joshua Stewert:
Player
Chips
Progress
Joshua Stewert
120,000
70,000
Ken Okada
90,000
40,000
17:17 (UTC+0)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Levola Picks Up A Double Posted Tuesday 19th September, 2023 at 17:04(UTC+0) by Alaxandar Georgiev
Level 9: 1000/1,500 (1,500) Entries: 77/138
Johannes Levola three-bet an early raise from the small blind. Igor Pihela Jr. three-bet jammed from the big blind for 61,000. Levola didn't hesitate and called the all-in for his remaining 56,000 chips.
Johannes Levola: Igor Pihela Jr:
The flop was a mixed-bag for Pihela Jr. as he was now behind and drawing to a nine or a flush. The turn was and the river came completing the full-house for the Finn.
Pihela was left with only 5,000 chips and he busted the tournament shortly after.
Player
Chips
Progress
Johannes Levola
115,000
65,000
Igor Pihela Jr.
5,000
45,000
Meet GGPoker Ambassador Anatoly Filatov at the WSOPC Tallinn Posted Tuesday 19th September, 2023 at 16:47(UTC+0) by Jason Glatzer
Snowmen Good for Saveikis Posted Tuesday 19th September, 2023 at 16:41(UTC+0) by Jason Glatzer
Level 8: 600/1,200 (1,200) Entries: 85/138
Algirdas Saveikis opened for 3,500 from the cutoff and was called by Kaupo Tenno from the button before Stanislav Smeljov three-bet shoved for 51,000. Saveikas went into the tank before he called off his stack of 45,500 while Tenno opted to fold.
Algirdas Saveikis: Stanislav Smeljov:
Saveikis won the flip to double his stack and leave his opponent with crumbs after Smeljov failed to connect with the runout.
Player
Chips
Progress
Algirdas Saveikis
95,000
45,000
Kaupo Tenno
85,000
5,000
Stanislav Smeljov
5,500
44,500
Party Chip Stack Update Posted Tuesday 19th September, 2023 at 16:39(UTC+0) by Alaxandar Georgiev
Players are coming back from the break. Most attended the awesome Meet & Greet organized by our hosts.
Check out some of the biggest stacks from around the room at the break below:
Player
Chips
Progress
Samuel Richards
185,000
70,000
Tornike Tchitadze
180,000
115,000
Aleksei Smirnov
180,000
20,000
Marko Harkonen
170,000
30,000
Igor Pihela
150,000
100,000
Hendrik Uibo
130,000
80,000
Toms Civcs
120,000
5,000
16:35 (UTC+0)
Start of Level 9 Blinds: 1,000/1,500 Ante: 1,500
WSOPC Tallinn Meet & Greet at Break Posted Tuesday 19th September, 2023 at 16:02(UTC+0) by Jason Glatzer
The live music is here and the mission is clear. Now that the Main Event has arrived, it is time for some fun with a Meet & Greet ceremony with free drinks and live entertainment.
Due to the planned entertainment, the break that the players just went on will be extended from 20 to 30 minutes. Action should resume for the final two blind levels of Day 1a at approximately 6:30 p.m. local time.
Big Double For Nikiforov Posted Tuesday 19th September, 2023 at 16:01(UTC+0) by Alaxandar Georgiev
Level 8: 600/1,200 (1,200) Entries: 93/138
After under the gun raise the pot was re-raised to 8,000 by Marko Harkonen from the cut-off followed by an all-in from Ilya Nikiforov for 45,000 on the small blind. The bigger stack Harkonen called and we went to show down.
Marko Harkonen: Ilya Nikiforov:
The flop looked great for Nikiforov and he won the hand after the turn and river completed the board to give the Estonian a full double-up.
Marko Harkonen was left with 120,000 chips, while Ilya Nikiforov doubled up to 92,000
Kreslins Delivers Bad Beat to Sipavicius Posted Tuesday 19th September, 2023 at 15:42(UTC+0) by Jason Glatzer
Level 8: 600/1,200 (1,200) Entries: 92/138
Karlis Kreslins open-jammed for 25,100 from the hijack and was looked up by Aurelijus Sipavicius from the blinds.
Karlis Kreslins: Aurelijus Sipavicius:
It wasn't looking good for Kreslins until he improved to a set on the flop. Sipavicius still had some hope alive to get back into the hand after the turn gave him a flush draw but the blank river completed the bad beat delivery service by Kreslins to Sipavicius.
Meanwhile, Maksim Petrov at the same table was sitting on one of the biggest piles of chips in the room with around 200,000.
Player
Chips
Progress
Maksim Petrov
200,000
150,000
Karlis Kreslins
55,000
25,000
Aurelijus Sipavicius
11,000
69,000
Krumins Coolers Tchitadze Posted Tuesday 19th September, 2023 at 15:29(UTC+0) by Jason Glatzer
Level 8: 600/1,200 (1,200) Entries: 96/138
Erik's Krumins had his stack of around 40,000 committed into the pot with against Tornike Tchitadze with on a board.
Tchitadze's flush was a strong hand but he doubled up Krumins who was even stronger with a full house.
"Good river for both of us," Krumins said after the hand.
Player
Chips
Progress
Eriks Krumins
110,000
60,000
Tornike Tchitadze
65,000
65,000
Henri Vaisanen
0
0
Roope Tarmi
0
0
Koit Kann
0
0
15:25 (UTC+0)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Post-Flop Action Posted Tuesday 19th September, 2023 at 15:21(UTC+0) by Alaxandar Georgiev
Level 7: 500/1000 (1000) Entries: 96/137
Henrik Puija opened from the cut-off and Toms Civcs called from the small blind.
The flop went check-check, but action unfolded on the turn where Puija bet 3,000, and shortly after Civcs raised to 9,000.
Civcs fired out for 30,000 on the river and was called by Puija.
Civcs revealed his and Puija mucked his hand saying: "I had an ace .."
Player
Chips
Progress
Toms Civcs
115,000
65,000
Henrik Puija
27,000
23,000
Zabolovskis Loses Short Stack Posted Tuesday 19th September, 2023 at 15:05(UTC+0) by Jason Glatzer
Level 7: 500/1,000 (1,000) Entries: 99/137
There wasn't much in the pot when Janis Zablovskis (picured below) jammed for 8,000 on the flop. Martin Zobel called while Mauri Dorbek folded.
Janis Zablovskis: Martin Zobel:
Zablovskis flopped top pair but Zobel was far ahead after he improved to two pair. Neither the turn nor the river saved Zablovskis and he was on the rail at least for now.
Player
Chips
Progress
Martin Zobel
60,000
0
Mauri Dorbek
20,000
30,000
Rene Peterkopf
0
0
Irmantas Bzeskis
0
0
Janis Zablovskis
0
0
Laja Turns a Flush Posted Tuesday 19th September, 2023 at 14:57(UTC+0) by Jason Glatzer
Level 7: 500/1,000 (1,000) Entries: 103/136
There wasn't too much in the pot when Henri Vaisanen check-jammed the flop. Heiki Laja already had a good portion of his 16,400 stack committed when he made the call.
Heiki Laja: Herni Vaisanen:
Vaisanen's cowboys were unable to hold despite improving to a set on the turn. The problem was this improved Laja to a flush. Vaisanen was unable to further improve to a full house or quads on the river and Laja doubled his stack instead of hitting the rail.
Player
Chips
Progress
Henri Vaisanen
40,000
10,000
Henri Laja
35,000
15,000
Mikael Gronvik
0
0
Vadim Guk
0
0
Big Stacks at Break Posted Tuesday 19th September, 2023 at 14:50(UTC+0) by Alaxandar Georgiev
Player
Chips
Progress
Juha Helppi
200,000
75,000
Vidar Assersen
180,000
130,000
Marko Harkonen
140,000
90,000
Daniel Korsunskyy
138,000
63,000
Tornike Tchitadze
130,000
99,000
Rudolf Rotko
130,000
80,000
Yi-Zhan Peng
130,000
20,000
Torbjorn Larsen
115,000
40,000
Samuel Richards
115,000
65,000
14:43 (UTC+0)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
Kann Ousts Garrido at the Break Posted Tuesday 19th September, 2023 at 14:27(UTC+0) by Jason Glatzer
Level 6: 400/800 (800) Entries: 103/134
While most tables went on break, one table took a little longer. Ignacio Garrido jammed a short stack from the small blind with . Koit Kann snap-called with from the big blind.
Garrido pulled ahead on the flop but Kann was back on top in the hand after the turn. A blank river completed the board and Garrido will need to re-enter for a chance at advancing to Day 2 and beyond.
Player
Chips
Progress
Koit Kann
50,000
0
Ignacio Garrido
0
0
Break Time! Posted Tuesday 19th September, 2023 at 14:23(UTC+0) by Jason Glatzer
Players are on a 20-minute break. Blinds will increase to 500/1,000 along with a 1,000 big blind ante when the action resumes.
We will provide an update with some of the biggest stacks around the room after the break.
"Give Me a Double-Up or I Go Rebuy" Posted Tuesday 19th September, 2023 at 14:14(UTC+0) by Jason Glatzer
Level 6: 400/800 (800) Entries: 108/132
Andrey Koks is having some fun over on Table 19 and just talked Tonis Viik into a call.
The was on the flop with not much in the pot when Koks checked. Viik was getting a massage and bet 1,500. Koks jammed for 21,400 and Viik went into the tank.
Viik asked for a count before tanking some more. Koks decided to try some table talk at this point in time.
"I have nothing on the flop," Koks said with a smile. "No connection, or maybe I am joking. Give me a double-up or I go rebuy."
Eventually, Viik found a call and despite not connecting with the board was ahead at that particular moment with the players more or less flipping.
Andrey Koks: Tonis Viik:
The turn improved Koks to a wheel but he wasn't out of the woods yet.
"Well, you can still get a ten," Koks said.
No ten came. Instead, it was the river to complete the board and Koks doubled through Viik instead of re-entering.
Player
Chips
Progress
Andrey Koks
50,000
0
Tonis Viik
45,000
5,000
Peng Picks Off Bzeskis Posted Tuesday 19th September, 2023 at 14:02(UTC+0) by Jason Glatzer
Level 6: 400/800 (800) Entries: 108/132
Yi-Zhan Peng checked with 35,000 in the pot and the on the board before Irmantas Bzeskis bet 12,500. Peng paused for about 20 seconds before he tossed in a chip to call.
Bzeskis turned over the for ace-high before Peng showed the to win the hand with the top pair.
Player
Chips
Progress
Yi-Zhan Peng
150,000
100,000
Irmantas Bzeskis
30,000
20,000
Day 5 Video Recap Posted Tuesday 19th September, 2023 at 13:49(UTC+0) by Jason Glatzer
13:44 (UTC+0)
Start of Level 6 Blinds: 400/800 Ante: 800
Watch the Mystery Bounty Stream Posted Tuesday 19th September, 2023 at 13:44(UTC+0) by Jason Glatzer
The final table of Event #5: €660 Mystery Bounty has kicked off. You can check out the action at OlyBet.tv.
Time will tell who will win the €10,000 top prize and the €10,000 mystery bounty.
Levin Bricks Flush Draw Posted Tuesday 19th September, 2023 at 13:25(UTC+0) by Jason Glatzer
Level 5: 300/600 (600) Entries: 108/125
Jelissei Levin donk-jammed the turn for 12,000 with the on the board after the turn and was called by Rene Peterkopf.
Jelissei Levin: Rene Peterkopf:
Levin was behind but any heart would win him the hand. However, the blank river completed the board and Levin's chips went into Peterkopf's stack.
Player
Chips
Progress
Rene Peterkopf
65,000
15,000
Jelissei Levin
0
0
"I Thought He Just Called" Posted Tuesday 19th September, 2023 at 13:19(UTC+0) by Jason Glatzer
Level 5: 300/600 (600) Entries: 109/125
Oliver Kullman bet 5,000 into a pot of around 15,000 with the on the board after the river.
Jussi Hakkinen tanked for about 30 seconds before raising to 15,000. Kullman instantly turned over his cards showing his for the second nut flush.
"Show your cards," the dealer said to Kullman. "It is not a fold when you show your cards."
"My mistake," replied Kullman. "I thought he just called."
Although everyone at the table appeared to agree, just to be safe the floor was called over. The floor confirmed exactly what the dealer told Kullman and he subsequently announced a call.
Hakkinen showed the and had his opponent drawing dead after flopping a flush to win the hand.
Player
Chips
Progress
Jussi Hakkinen
90,000
40,000
Oliver Kullman
25,000
25,000
13:00 (UTC+0)
Start of Level 5 Blinds: 300/600 Ante: 600
Trip Fives for Zobel Posted Tuesday 19th September, 2023 at 12:48(UTC+0) by Jason Glatzer
Level 4: 200/500 (500) Entries: 102/114
Martin Zobel fired out for 10,000 into a pot of approximately 15,000 with the on the board and Tomasz Mros quickly called.
"Ace-five," Zobel said before seconds later turning over the .
Mros rechecked his hand before mucking his cards for Zobel to win the pot with trip fives.
Player
Chips
Progress
Martin Zobel
60,000
15,000
Tomasz Mroz
25,000
25,000
Big Blind Special for Helppi Posted Tuesday 19th September, 2023 at 12:39(UTC+0) by Jason Glatzer
Level 4: 200/500 (500) Entries: 96/108
Both Joni Rantamaki and Juha Helppi (pictured below) got tangled up in a pot from the blinds when both players checked the turn with already 15,000 in the pot.
Rantamaki fired out for 3,800 after the river completed the board. Helppi tanked for a minute before he raised to 15,000 and Rantamaki quickly called.
Helppi immediately turned over the for a full house.
"Nice hand," Rantamaki said as he tossed his hand face down into the muck.
Meanwhile, Taago Tamm lost his stack around the same time and will need to re-enter if he wants a shot at WSOPC Tallinn Main Event glory.
Player
Chips
Progress
Juha Helppi
125,000
25,000
Joni Rantamaki
40,000
10,000
Taago Tamm
0
0
Richards Leads at Break Posted Tuesday 19th September, 2023 at 12:26(UTC+0) by Jason Glatzer
American Samuel Richards is easily the chip leader at the first break with 180,000. He shared during the break that he got it in with kings and was up against aces and queens. The kings got there to give him a lion's share of what he is sitting on now.
Check out the biggest stacks on break below:
Player
Chips
Progress
Samuel Richards
180,000
130,000
Tomi Rasanen
110,000
15,000
Juha Helppi
100,000
5,000
Juha Elo
90,000
40,000
Kaupo Tenno
90,000
40,000
Alger Pissarev
80,000
30,000
Aurelijus Sipavicius
80,000
30,000
Karlis Kreslins
80,000
30,000
Ori Hasson
80,000
15,000
More Than 100 Entries! Posted Tuesday 19th September, 2023 at 12:22(UTC+0) by Jason Glatzer
Level 4: 200/500 (500) Entries: 98/106
A handful of players hopped into the Main Event on the break to bring the Day 1a field past 100 entries and counting.
12:21 (UTC+0)
Start of Level 4 Blinds: 200/500 Ante: 500
First Break Posted Tuesday 19th September, 2023 at 12:04(UTC+0) by Jason Glatzer
Main Event players are on their first 20-minute break. Blinds will increase to 200/500 with a 500 big blind ante when the action resumes.
Korsunskyy Chips Up Posted Tuesday 19th September, 2023 at 12:04(UTC+0) by Jason Glatzer
Level 3: 200/400 (400) Entries: 91/99
Ukraine's Daniel Korsunskyy fired out for 7,200 into a pot of around 12,000 with the on the board after the turn and was called by Rinalds Zimka.
The river completed the board and Korsunskyy tanked for a minute before betting 9,400. Zimka tanked for several minutes. He stared briefly at Korsunskyy who was stoically looking down at the table. A minute later, Zimka gave up on the hand and the dealer pushed a decent pile of chips towards Korsunskyy.
Player
Chips
Progress
Daniel Korsunskyy
75,000
25,000
Rinalds Zimka
35,000
15,000
Helppi Gets Some Help on the River Posted Tuesday 19th September, 2023 at 11:47(UTC+0) by Jason Glatzer
Level 3: 200/400 (400) Entries: 91/97
Juha Helppi and Oleh Bohdanov (pictured below) got their stacks in on the turn with the on the board with Bohdanov at risk but far ahead.
Oleh Bohdanov: Juha Helppi:
Bohdanov appeared to be primed to double or worst case to chop the pot if the board double pair. However, Helppi nailed his three-outer to improve to a full house and send Bohdanov to the rail after the river completed the board.
"Easy game," Helppi said with a smile.
Player
Chips
Progress
Juha Helppi
95,000
35,000
Oleh Bohdanov
0
0
Tamm Runs Into Hasson's Flush Posted Tuesday 19th September, 2023 at 11:37(UTC+0) by Jason Glatzer
Level 3: 200/400 (400) Entries: 86/89
Ori Hasson opened for 900 from the cutoff and was called by Taago Tamm from the button and Vadim Guk from the small blind.
Three monotone clubs came on the flop. Guk and Hasson both checked before Tamm led out for 1,100. This was enough for Guk to fold but Hasson had a different idea and raised to 3,500. Tamm called to see the turn.
Hasson paused for about 30 seconds before he bet 8,600. Tamm tanked for about as long before he called.
The river paired the board and Hasson fired out for 13,500.
Tamm counted out his chips before going into the tank for several minutes.
"Is it always aces with the ace of club or something else?" Tamm said.
Seconds later, Tamm called only to get the bad news with Hasson turning over the for the ace-high flush. This was enough as Tamm mucked his hand facedown.
"It was something better," Tamm said to Hasson as the dealer was getting ready for the next hand.
Player
Chips
Progress
Ori Hasson
95,000
45,000
Vadim Guk
45,000
5,000
Taago Tamm
35,000
15,000
11:23 (UTC+0)
Start of Level 3 Blinds: 200/400 Ante: 400
Top Set for Rasanen Posted Tuesday 19th September, 2023 at 11:14(UTC+0) by Jason Glatzer
Level 2: 100/300 (300) Entries: 79/81
Tornike Tchitadze fired out for 7,500 into a spread pot of a bit more with the on the board after the river.
Tomi Rasanen called and won the hand when his top set with was more than good against the top pair with held by Tchitadze.
Player
Chips
Progress
Tomi Rasanen
95,000
45,000
Tornike Tchitadze
31,000
19,000
Zobel Chips Up Against Remmel Posted Tuesday 19th September, 2023 at 11:02(UTC+0) by Jason Glatzer
Level 2: 100/300 (300) Entries: 76/77
Latvians Olaf Karlins and Janis Zablovskis are both seated next to each other on Table 6 with both players holding around 75,000 in chips.
It wasn't these two players that locked up in a hand as instead it was Rauno Remmel and Martin Zobel battling it out.
We caught up with the hand with Zobel raising from the big blind to 3,800 and Remmel calling from late position.
Zobel fired out for 6,000 on the flop and Remmel called. The action slowed down on the turn with it taking more than a minute for Zobel to bet 15,000. Remmel tanked for several minutes before he laid down his hand.
Meanwhile, a different Estonian Hendry Kullamae was the first player to hit the rail in the Main Event.
Player
Chips
Progress
Janis Zablovskis
75,000
25,000
Olaf Karlins
75,000
25,000
Rauno Remmel
55,000
5,000
Martin Zobel
45,000
5,000
Hendry Kullamae
0
0
10:42 (UTC+0)
Start of Level 2 Blinds: 100/300 Ante: 300
Not the Best Start for Gronvik Posted Tuesday 19th September, 2023 at 10:41(UTC+0) by Jason Glatzer
Level 1: 100/200 (200) Entries: 67/67
Mikael Gronvik hasn't had the best start to the day after losing three big pots. He shared one of the pots he lost involved ace-seven suited against ace-jack with two aces on the board. We caught the last of the three hands which brought him down to 11,500 from his 50,000 starting stack. Still plenty of big blinds but we are sure he'd like to restart the day.
Joel Lindpere checked before Mikael Gronvik checked. Torbjorn Larsen fired out for 7,100 into a pot of around double that with the on the board. Gronvik opted to call, while Lindpere folded.
Gronvik turned over the but his two pair wasn't good enough with Larsen taking down the pot with with a full house.
"I got very lucky there," Lindpere said to the table after the hand. "I had king-queen of clubs and was going for the flush."
If Lindpere hit his flush we would likely see him much lower in the chip counts. But that wasn't the case and, like Larsen, he is also above a starting stack.
Player
Chips
Progress
Torbjorn Larsen
75,000
25,000
Joel Lindpere
55,000
5,000
Mikael Gronvik
11,500
38,500
Big Slick Good for Helppi Posted Tuesday 19th September, 2023 at 10:23(UTC+0) by Jason Glatzer
Level 1: 100/200 (200) Entries: 61/61
There were about 1,600 in chips in the pot with the already on the flop when Oleh Bohdanov check-called a 1,000 bet by Juha Helppi.
Bohdanov check-called a bigger bet by Helppi of 4,100 on the turn before leading out for 5,000 once the paired the board on the river.
Helppi tanked for close to a minute before he min-clicked it back with a raise to 10,000. Bohdanov tanked for more than a minute before he tossed a chip in to call. Helppi turned over the and won the hand after Bohdanov mucked his cards.
Player
Chips
Progress
Juha Helppi
60,000
10,000
Oleh Bohdanov
40,000
10,000
Juha Helppi and Joel Lindpere in the Field Posted Tuesday 19th September, 2023 at 10:13(UTC+0) by Jason Glatzer
Level 1: 100/200 (200) Entries: 45/45
WSOP bracelet winner Juha Helppi is easily the biggest name in poker already in the field. However, he isn't the only big name in action as former Estonian professional footballer Joel Lindpere also won a satellite yesterday and is in action.
Torbjorn Larsen, who was at the final table of Event #1: €555 No-Limit Hold'em, Mikael Gronvik, and Samuel Richards are among the other players to start the day with chips.
Player
Chips
Progress
Mikael Gronvik
50,000
0
Samuel Richards
50,000
0
Torbjorn Larsen
50,000
0
Juha Helppi
50,000
0
Joel Lindpere
50,000
0
Action Begins Posted Tuesday 19th September, 2023 at 10:04(UTC+0) by Jason Glatzer
Level 1: 100/200 (200) Entries: 42/42
Famous tournament director Teresa Nousiainen shared some announcements with the Main Event players before the action kicked off with 42 players in their seats.
Best of luck to all of the players and "Shuffle up and deal!"
Welcome to Day 1a of the €1 Million Guaranteed WSOPC Tallinn Main Event Posted Tuesday 19th September, 2023 at 08:05(UTC+0) by Jason Glatzer
The day we have all been waiting for is finally here as today is the start of the crown jewel of the inaugural World Series of Poker Circuit (WSOPC) Tallinn with the first of four opening flights of the 2023 WSOPC Tallinn €1,500 Main Event kicks off on Tuesday at noon.
The four-day Main Event is a deep-stacked affair boasting four opening flights from Sept. 19-21 with players starting with 50,000 in opening chips. Blinds increase slowly at every 40 minutes during the first three opening flights with the final opening flight moving along a little quicker with 30-minute blind levels.
Players will have plenty of opportunities to accumulate chips with unlimited re-entries permitted throughout the four opening flights and during the first two blind levels of Day 2. The battle will continue on Sept. 22-24 until the first-ever WSOPC Tallinn Main Event winner is crowned.
We will see many big names, including Finnish poker legend Juha Helppi who arrived last night with his eyes on the Main Event gold ring awarded to the winner along with a healthy top prize and an invitation to a $1 million guaranteed 2023 WSOP Tournament of Champions freeroll where a WSOP bracelet is on the line.
Our coverage starts at noon with blinds at 100/200 and a 200 big blind ante. Follow the Main Event journey throughout the week while we report the biggest hands, bad beats, and stories until a winner is crowned.
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.