0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0061 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1C/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 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.0001 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.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0067 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.0004 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.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1
0.0264 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0056 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '129'
AND `published` = 1
0.0460 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '130'
AND `published` = 1
0.0256 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '132'
AND `published` = 1
0.0662 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0106 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '135'
AND `published` = 1
0.0263 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0079 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` = '1C'
0.0516 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '129'
ORDER BY `busted` ASC, `current_chips` DESC
0.0098 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` = '129'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0115 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0156 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5591'
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` = '5593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0099 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5578'
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` = '5577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0209 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5555'
ORDER BY `chip_change` DESC, `busted` ASC
0.0096 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0101 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5547'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5541'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5539'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5538'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5536'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5534'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5529'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5527'
ORDER BY `chip_change` DESC, `busted` ASC
0.0098 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5526'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5523'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5517'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5515'
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` = '5510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5509'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5506'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5502'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5501'
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` = '5499'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5498'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5494'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5493'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '129'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 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` = '129'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5592'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5583'
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` = '5581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5578'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5555'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5547'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5541'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5544'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5539'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5538'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5536'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5534'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5529'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5527'
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` = '5526'
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` = '5524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5523'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5517'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5515'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5509'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5506'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5502'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5501'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5499'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5498'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5494'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5493'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 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.0003 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.
Joel Holmberg Bags Overall Chip Lead on Day 1c Posted Thursday 21st September, 2023 at 18:40(UTC+0) by Jason Glatzer
Joel Holmberg parlayed his opening stack of 50,000 into 318,000 to lead the 115 Day 1c survivors out of the 260 entries in the field. This also placed him on top of the overall chip counts with Jonatan Fors coming out of Day 1c in second place overall with 297,000 with Tarmo Tammel nearly bagging up around the same.
Check out all of the Day 1c chip counts below:
Player
Chips
Big Blinds
Joel Holmberg
318,000
127
Jonatan Fors
297,000
119
Tarmo Tammel
290,000
116
Mantas Bagocius
284,500
114
Santeri Piiroinen
281,000
112
Pyry Kekalainen
267,500
107
Jun Beum Chun
246,000
98
Oskar Ojaveer
227,500
91
Andrius Bielskis
205,000
82
Hannes Praks
199,500
80
Lars Jonsson
191,000
76
Priit Vallap
190,500
76
Juuso Elsinen
181,000
72
Mark Metsla
181,000
72
Kimmo Kurko
177,500
71
Mauro-Mark Musting
175,000
70
Agnius Ismailovas
175,000
70
Hai Hoang
165,000
66
Maruen Zormati
162,000
65
Mathias Siljander
159,500
64
Albert Ostrovskij
159,000
64
Deividas Butnoras
155,500
62
Antti Karkkainen
155,000
62
Vu Hoang Vuong
153,000
61
Mikko Ylamaki
152,500
61
Aigars Taukacs
149,500
60
Niko Linnama
148,000
59
Martin Naveiro
147,500
59
Jaime Susarte
145,000
58
Tanaka Yusuke
145,000
58
Andrius Simonovicius
142,000
57
Martin Valent
140,000
56
Mantas Ramanaukas
140,000
56
Eirimas Tomkevicius
137,000
55
Robin Palm
132,500
53
Aleksandrs Kasincevs
126,000
50
Anders Hansson
126,000
50
David Asqino
125,500
50
Arturs Daugis
123,500
49
Juha Helppi
123,000
49
Dmitri Dudakov
122,500
49
Justus Kursi
121,500
49
Amanullah Tahiri
120,000
48
Markuss Rukkalns
120,000
48
Tomi Hietala
120,000
48
Eeti Loyttyniemi
118,000
47
Priit Parmasto
116,000
46
Maciej Komorowski
115,500
46
Jordi Baixas
115,000
46
Stephen Groom
115,000
46
Tero Hakanen
114,000
46
Emil Hovmark
113,500
45
Niko Petro
111,000
44
Priit Oja
111,000
44
Rasmus Eino
108,500
43
Calle Hansson
107,000
43
Adrians Imsa
105,000
42
Kai Lehto
102,500
41
Einar Hersdal
102,000
41
Xiaolei Chen
101,500
41
Vilius Zabarauskas
101,500
41
Claudio Cecchi
100,000
40
Domene Jose Larios
99,500
40
Antti Eeva
98,000
39
Magnus Pukk
93,500
37
Pavel Solodovnikov
92,500
37
Davis Modans
92,000
37
Quang Doan
92,000
37
Kasper Mellanen
90,000
36
Mustafa Biz
89,000
36
Juha Nikkola
88,500
35
Edgars Gendvilis
88,000
35
Santtu Leinonen
87,000
35
Lukasz Balbierz
83,500
33
Matias Arosuo
82,000
33
Bartlomiej Kijak
79,000
32
Ignacio Garrido
75,000
30
Kevin Karenius
74,500
30
Glen Gaines
70,000
28
James Noonan
69,500
28
Matias Knaapinen
68,500
27
Niko Palonen
67,500
27
Joona Ranta-Nilkku
66,500
27
Ville-Matti Keranen
66,000
26
Aleksei Gontsar
65,000
26
Silver Simulask
65,000
26
Anne Bezdek
62,000
25
Giuseppe Rosa
61,000
24
Carl Halvarsson
60,000
24
Jani Haarala
58,000
23
Aurelijus Sipavicius
58,000
23
Ilari Sahamies
56,500
23
Kaspars Renga
56,000
22
Jari Mahonen
56,000
22
Viacheslav Sultanov
56,000
22
Paulius Mikaliunas
55,000
22
Michele Tocci
52,500
21
Kaido Mikk
51,000
20
Ramunas Mika
51,000
20
Jorge Bravo
51,000
20
Viktors Semjonovs
50,500
20
Roberts Rumba
50,000
20
Valters Cernevskis
50,000
20
Juha Kaitanen
48,500
19
Jon Kyte
47,000
19
Akseli Paalanen
46,000
18
Matus Fecisko
46,000
18
Niki Nurmisto
44,000
18
Min Ho Cho
42,500
17
Ryan Mandara
42,000
17
Seppo Parkkinen
38,000
15
Tomi Arponen
38,000
15
Edgars Beizaks
34,500
14
Sami Suominen
27,000
11
Davor Pavic
19,500
8
Final Four Hands Posted Thursday 21st September, 2023 at 17:36(UTC+0) by Jason Glatzer
The tournament director announced the final four hands of Day 1c. While we focus on the chip counts of the nearly 120 survivors, we will also start reporting Day 1d after the first break.
The Big Boy Bluff Posted Thursday 21st September, 2023 at 17:35(UTC+0) by Alaxandar Georgiev
Level 10: 1,000/2,000 (2,000) Entries: 127/260
Big action on the turn as the board was dealt , Anders Hansson was the original raiser and he made another 10,000 bet on the turn. His opponent was Pyry Kekalainen and he re-raised him to 35,000 which Hansson called.
On the river Hansson checked, shortly after Kekalainen put another 40,000 into the pot, and the Swede folded.
Pyry Kekalainen showed to everyone after Hansson revealed he had the .
The big bluff earned Finland's Kekalainen a pot worth over 130,000 chips.
Player
Chips
Progress
Pyry Kekalainen
220,000
10,000
Anders Hansson
180,000
53,000
Larsson Doesn't Love Queens Posted Thursday 21st September, 2023 at 17:14(UTC+0) by Lina Olofsson
Greger Larsson hit the rail in the end of last level after loosing his good stack in a few pretty harsh hands against Justus Kursi.
First he doubled Kursi with versus on a very dry board and lost 37,000 to the Finn. A few hands later they were five to see the flop . Larsson who had flopped the nut flush with on his hand checked and the guy after him made a tiny tiny raise to 1,5 big blinds as Justus Kursi raised. Action was folded to Larsson who pushed his chips in and was called by Kursi who turned over for a flopped set. So far so good but that didn't last long as another queen came on the turn and his opponent got a full house leaving Larsson down to only 4,500 left in his stack.
Larsson managed to spin his last chips up to 27,000 until he ran into eights with his sevens and the journey was over for our Swede .
"At least Calle managed to double up", Larsson commented as he walked around in the tournament area deciding if he wanted to fire another bullet in the tournament as day 1D was just about to start (and you can buy in all the way until tomorrow morning). When saying Calle he refers to Calle Hansson who managed to get a good beat as his survived against his opponents doubling up to around 125,000.
Player
Chips
Progress
Calle Hansson
94,000
0
Justus Kursi
50,000
0
Greger Larsson
0
0
Final Day 1c Blind Level Begins; Day 1d Kicks Off Posted Thursday 21st September, 2023 at 17:04(UTC+0) by Jason Glatzer
Level 10: 1,000/2,000 (2,000) Entries: 146/256
Day 1c has progressed to its final blind level of the day before surviving players bag their chips for tomorrow's Day 2.
Meanwhile, the final opening flight in Day 1d just began with a field of 20 entries. This flight is a little different than the others as it boasts 30-minute blind levels instead of the 40-minute levels prevalent during the rest of the event.
Our Day 1d coverage will begin after the first break while we focus on the tail end of Day 1c.
17:02 (UTC+0)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Its Always Coming Seven Posted Thursday 21st September, 2023 at 17:01(UTC+0) by Alaxandar Georgiev
Level 9: 600/1,200 (1,200) Entries: 146/258
Eirimas Tomkevicius raised from the button, followed by a big blind jam for 37,500 chips by Renars Sakauskis, not long after Tomkevicius called.
Eirimas Tomkevicius: Renars Sakauskis:
Quite behind with the lower pair Tomkevicius was hoping for one of the sevens on the flop as he shouted "seeeveen" and that is exactly what he got on the flop.
Sakauskis didn't look happy with this flop and needed a King to stay in the tournament. The turn was and the river was .
Unlucky for Renars Sakauskis as he busts 1 level before Day 1C Finishes.
Player
Chips
Progress
Eirimas Tomkevicius
115,000
65,000
Renars Sakauskis
0
0
Ramanauskas is "Sorry" for Ousting Bering Posted Thursday 21st September, 2023 at 16:51(UTC+0) by Jason Glatzer
Level 9: 1,000/1,500 (1,500) Entries: 153/256
Christoffer Bering three-bet from the button before Mantas Ramanauskas four-bet shoved from the small blind for 65,000. The initial raiser, folded while Bering called off his stack of a little less.
"Oh no," said Ramanauskas. "What did I do?"
Christoffer Bering: Mantas Ramanauskas:
Unlike most players who would root for a jack, Ramanauskas began to apologize to his opponent after his jack connected on the flop. Neither the turn nor the river saved the day. Bering began to leave but not before Ramanauskas got out of his chair to say sorry once again and give his opponent a hug.
"You've been doing that to me all day," Bering said in a friendly tone.
"Sorry, again," Ramanauskas.
Player
Chips
Progress
Mantas Ramanauskas
125,000
75,000
Christoffer Bering
0
0
Swedish Poker Federation Chairman Svedin On the Line Posted Thursday 21st September, 2023 at 16:44(UTC+0) by Lina Olofsson
The Swedish Poker Federations chairman Robert Svedin is one of the players in today's field and had a good start to the day as he was up to 120,000 in chips after a few levels but the past two of them weren't as successful and he's holding on to a thread as he's now playing with only 9,000 in front of him on the blinds 1,000/1,500 with a big blind ante of another 1,500.
But it's like they say. A chip and a chair and Svedin is known for his skills to spin up and we wish him good luck as the play resumes for the last two levels of today here in flight 1C.
Svedin's good friend and a Swede who's doing much better is Anders Hansson who sits with 233,000 in front of him right next to his fellow countryman Davor Pavic who just moved to his table.
Player
Chips
Progress
Anders Hansson
233,000
50,000
Davor Pavic
43,000
7,000
Robert Svedin
9,000
111,000
Not A Bad Flop Posted Thursday 21st September, 2023 at 16:44(UTC+0) by Alaxandar Georgiev
Level 9: 600/1,200 (1,200) Entries: 158/254
Andres Leppik raised from the cut-off to 3,000, followed by a call and a three-bet to 15,000 by Maruen Zormati on the big blind. With no hesitation, Leppik put forward all of his chips and just as quickly Zormati called for 70,500 chips.
Andres Leppik: Maruen Zormati:
To the flop which was not bad at all for Leppik as he picked up a lot of outs to win the hand. He needed a spade, ace or a deuce to win over his opponent, but the turn and the river didn't get him there.
The Finn scoops the whole pot and Leppik was left with just 3,000 chips.
Player
Chips
Progress
Maruen Zormati
141,000
91,000
Andres Leppik
3,000
47,000
Big Stacks at Break Posted Thursday 21st September, 2023 at 16:27(UTC+0) by Alaxandar Georgiev
Player
Chips
Progress
Joel Holmberg
280,000
165,000
Jun Beum Chun
225,000
106,000
Oskar Ojaveer
220,000
170,000
Pyry Kekalainen
210,000
160,000
Tarmo Tammel
190,000
100,000
Kristoffer Hovmark
180,000
130,000
Skommar Hansson Sr.
180,000
5,000
Ville Keranen
140,000
105,000
16:22 (UTC+0)
Start of Level 9 Blinds: 1,000/1,500 Ante: 1,500
Final Day 1c Break Posted Thursday 21st September, 2023 at 16:03(UTC+0) by Jason Glatzer
Players are on their final break of Day 1c. Blinds will increase to 1,000/1,500 with a 1,500 big blind ante before moving to the final blind level of the day with blinds at 1,000/2,000 with a 2,000 big blind ante when the action resumes. After these two levels, players will bag and tag chips into Saturday's Day 2.
Tuominen Dusts Off Vaitiekunas & Doubles Thru Butnoras Posted Thursday 21st September, 2023 at 15:50(UTC+0) by Jason Glatzer
Level 9: 600/1,200 (1,200) Entries: 174/249
Paulius Vaitiekunas jammed his crumbs from under the gun and was called by Deividas Butnoras (pictured below) before Eemil Tuominen three-bet jammed for more than 30,000. Butnoras called this as well and the cards were turned over.
Paulius Vaitiekunas: Eemil Tuominen: Deividas Butnoras:
Touminen eliminated Vaitiekunas while doubling through another Lithuanian in Deividas Butnoras after the ran out on the board.
Player
Chips
Progress
Deividas Butnoras
140,000
90,000
Eemil Tuominen
65,000
15,000
Paulius Vaitekunas
0
0
Tammel Binks It On The River Posted Thursday 21st September, 2023 at 15:48(UTC+0) by Alaxandar Georgiev
Level 8: 600/1,200 (1,200) Entries: 179/249
Tarmo Tammel raised the button and Paulius Vaitiekunas defended from the big blind.
The flop went check-check. Vaitekunas led the turn for 10,000 chips which was an overbet and Tammel jammed it all in for 45,000. After a short thought, his opponent called.
Tarmo Tammel: Paulius Vaitekunas:
Vaitekunas was ahead with his two-pair, while Tarmo needed a ten, ace, or a king on the river.
And indeed he binked the on the river wining 90,000 chips. Vaitekunas was left with only 2,600 chips which he doubled the next hand.
Player
Chips
Progress
Tammel Tarmo
90,000
40,000
Paulius Vaitekunas
2,600
47,400
Day 1c Larger Than Day 1a & Day 1b Combined! Posted Thursday 21st September, 2023 at 15:33(UTC+0) by Jason Glatzer
Level 8: 600/1,200 (1,200) Entries: 179/249
Day 1a and Day 1b attracted 246 entries behind. There are already 249 entries in Day 1c making not only the largest opening flight but also larger than Day 1a and Day 1b combined.
15:22 (UTC+0)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Too Many Outs For Herrero Posted Thursday 21st September, 2023 at 15:22(UTC+0) by Alaxandar Georgiev
Level 7: 500/1,000 (1,000) Entries: 183/245
Sandro Herrero jammed about half a starting stack over a raise by Jari-Pekka Juhola and was snap-called by Juhola.
Sandro Herrero: Jari-Pekka Juhola:
A great flop gave Herrero better odds of winning the pot as he was drawing to a flush, an ace, or perhaps one of the two Kings left.
The turn wasn't what the Spanish player wanted, neither the on the river.
Player
Chips
Progress
Jari-Pekka Juhola
75,000
25,000
Sandro Herrero
0
0
Jon Kyte Trying on Rings Posted Thursday 21st September, 2023 at 15:20(UTC+0) by Jason Glatzer
Level 7: 500/1,000 (1,000) Entries: 185/244
Norwegian poker sensation Jon Kyte (pictured below) was busy deciding which finger he wanted the majestic WSOP Circuit gold ring to be fitted for after winning Event #8: €1,100 PLO 4, 5, & 6 Cards for €34,780. After he decides which finger, he will also have to deliberate on design decisions.
Kyte isn't off to a hot start on Day 1c as he has already lost more than half his starting stack but after winning a ring last night, Kyte appears to be very low-stress and ready for another day under the lights and cameras competing for a coveted WSOP gold ring.
Meanwhile, a hand took place at his table as we were having a chat. Antti Karkkainen got his last 16,600 into the pot with the on the board after the flop and was up against Timo Ruuska.
Antti Karkkainen: Timo Ruuska:
Ruuska's top pair wasn't good enough and it didn't get any better the rest of the way to double Karkainen. Karkkainen's good fortunes were short-lived as shortly after he was witnessed leaving the tournament arena.
Player
Chips
Progress
Timo Ruuska
85,000
35,000
Jon Kyte
20,000
30,000
Antti Karkkainen
0
0
Big Slick for Rosa to Felt Arras Posted Thursday 21st September, 2023 at 14:54(UTC+0) by Jason Glatzer
Level 7: 500/1,000 (1,000) Entries: 191/240
Lithuanian poker beast Paulius Vaitiekunas opened for 2,200. 2022 Battle of Malta Spring Edition Main Event champion Giuseppe Rosa three-bet to 7,000 before Rauno Arras four-bet shoved for approximately 15,000. Vaitiekunas folded while Rosa snap-called.
Rauno Arras: Giuseppe Rosa:
Arras got out of his seat but kept his eyes on the table. Shortly after he left the room after bricking the runout.
We Have A New Sheriff In Town Posted Thursday 21st September, 2023 at 14:50(UTC+0) by Lina Olofsson
As the 190 players still in the field (of 238 already bought in) have left for their second break here on day 1C of the €1,500 Main Event we have spotted some notable stacks around the tables.
Jun Beum Chun is in the lead with 191,000 in his stack just before Anders Hansson with 183,000. Below you'll find some more chips across the grand ballroom here at the Hilton Park and Olympic Casino.
Player
Chips
Progress
Jun Beum Chun
191,000
141,000
Jun Beum Chun
190,000
140,000
Anders Hansson
183,000
133,000
Priit Vallap
140,000
90,000
Steven Tool
140,000
75,000
Tomi Matias Rasanen
132,000
82,000
Robert Svedin
120,000
70,000
Hai Hoang
115,000
65,000
Joel Holmberg
115,000
65,000
Matus Fecisko
96,000
9,000
Calle Hansson
94,000
44,000
Antonios Onoufriou
93,000
43,000
Matti Lasanen
88,000
66,000
Aleksandrs Kasincevs
85,000
35,000
Juha Helppi
75,000
25,000
14:40 (UTC+0)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
Second Break Posted Thursday 21st September, 2023 at 14:24(UTC+0) by Jason Glatzer
Players are on their second 20-minute break. Blinds will increase to 500/1,000 with a 1,000 big blind ante when the action resumes.
Swedish Father and Son Battling in the Main Event Posted Thursday 21st September, 2023 at 14:10(UTC+0) by Jason Glatzer
Level 6: 400/800 (800) Entries: 196/229
Cho Min Ho opened the pot from an early position to 1,800 and was called by two players, one of them being Skommar Hansson Jr., but he got re-raised from Henri Wagner on the big blind to 5,600. Min Ho folded, Hansson called the three-bet, and one more player called.
The flop was dangerous and everyone checked it down. The turn was which paired the board and Wagner bet 7,200 into the pot followed by an all-in from Hansson who was wearing a black hoodie over his head and looked just as dangerous.
Not long after Wagner folded which led to the Swede scooping up a nice pot.
Meanwhile, Skommar Hansson Sr., the father of Skommar Hansson Jr., is also in the field beasting it up on a nearby table with 175,000 in chips.
Player
Chips
Progress
Skommar Hansson Sr.
175,000
125,000
Skommar Hansson Jr.
65,000
15,000
Henri Wagner
20,000
30,000
Flush for Pukk Posted Thursday 21st September, 2023 at 14:08(UTC+0) by Jason Glatzer
Level 6: 400/800 (800) Entries: 196/229
Edgars Beizaks checked with about 20,000 in the pot and the on the board.
Magnus Pukk (pictured below) tanked for a couple of minutes before he bet 9,000. Beizaks tossed in two black chips designating a call only to much his hand after Pukk exposed the for a flush.
Meanwhile, Lithuanian poker hero Andrius Bielskis was at the same table and has been continuing to climb up the chip count leaderboard with a stack of 160,000.
Player
Chips
Progress
Andrius Bielskis
160,000
20,000
Magnus Pukk
80,000
30,000
Edgars Beizaks
30,000
20,000
Anna-Mari Hursti
0
0
Ricardo Usai
0
0
13:43 (UTC+0)
Start of Level 6 Blinds: 400/800 Ante: 800
Parmasto Attempting to Multitable Posted Thursday 21st September, 2023 at 13:42(UTC+0) by Jason Glatzer
The 2023 WSOP Circuit Tallinn €1,500 Main Event is a huge tournament to be playing. For most it is about the money, the ring, and the prestige. For others, it is just about the ring and prestige. This is the case for Estonia's Priit Parmasto, who already has a big stack on Day 1c but is also multitabling high-stakes cash games on his telephone simultaneously.
Parmasto is an absolute cash game wizard according to any well-versed Estonian we asked and we tend to agree with this opinion. However, in recent times Parmasto showed he can beast it up in tournaments as well as back in March of this year, Parmasto shipped the €500,000 guaranteed Kings of Tallinn €1,100 Main Event here at Olympic Park Casino for €97,400.
We wish Parmasto the best of luck in his pursuit of the ring, and, of course, we also wish him to crush the cash games he is playing at the same time.
Player
Chips
Progress
Priit Parmasto
140,000
90,000
Avots Runs Into Sultanov's Big Slick Posted Thursday 21st September, 2023 at 13:36(UTC+0) by Jason Glatzer
Level 5: 300/600 (600) Entries: 199/224
Kaspars Avots three-bet jammed for close to 15,000 and was called by 2023 WSOPC Tallinn Event #1: €555 NLH champion Viacheslav Sultanov (pictured below), who originally opened from under the gun.
Kaspars Avots: Viacheslav Sultanov:
Both players connected with their ace on the flop.
"Chop," a player not in the hand requested.
The turn reduced one of Avots' outs who now was down to a two outer.
"Eight," pleaded Avots.
No eight came, not even the which wouldn't have been good for him as this would have completed a flush for Sultanov. Instead, it was the river completing the board and Avots will need to re-enter if he wishes to advance to Day 2 and beyond.
Player
Chips
Progress
Viacheslav Sultanov
65,000
15,000
Kaspars Avots
0
0
Deuces Never Loses Posted Thursday 21st September, 2023 at 13:27(UTC+0) by Alaxandar Georgiev
Level 5: 300/600 (500) Entries: 200/223
We had Aki Pyysing (pictured below) again in action against Ville Keranen, after some two-sided aggression both went all-in preflop for about 45,000 each.
Aki Pyysing: Ville Keranen:
Aki managed to hold his hand on the all-low cards board and doubled up to a healthy 90,000 stack.
Player
Chips
Progress
Aki Pyysing
90,000
40,000
Ville Keranen
35,000
15,000
13:05 (UTC+0)
Start of Level 5 Blinds: 300/600 Ante: 600
Big Play From Modans Posted Thursday 21st September, 2023 at 13:05(UTC+0) by Alaxandar Georgiev
Level 4: 200/500 (500) Entries: 192/214
Davis Modans was already in a three-bet pot against Karl Relander, in which he re-raised pre-flop.
The flop was bet from modas for 7,000 with already 14,000 in the pot. The turn was checked by both players.
The river was and Modans bet 9,000 which was quickly raised to 18,000 by Relander. Not long after Davis Modans pushed all of his chips in covering Relander's remaining stack.
Relander folded and Modans revealed his to everyone. The big play earned him more than 32,000 chips.
Player
Chips
Progress
Davis Modans
100,000
50,000
Karl Relander
22,000
28,000
Larsson Needs a Break - Wins Too Many Hands Posted Thursday 21st September, 2023 at 13:01(UTC+0) by Lina Olofsson
The Swede Greger Larsson was just seen walking around with his WSOPC bottle of water in the tournament room. After our last post, we assumed he might have lost a hand but it was the total opposite. We asked if something had happened since he looked a bit shaken up but he replied with a big smile on his face: "I'm running too good right now, I needed to walk around a little and shake it off a bit". "But if you're running hot you should sit at your table", we replied and he agreed and said it was between two hands.
He had just added another 35,000 to his stack and almost tripled his starting stack of today in only four levels and is one of the chip leaders in the big field we have here today which is up to 214 players in total.
Player
Chips
Progress
Greger Larsson
140,000
35,000
"I Was So Happy!" Posted Thursday 21st September, 2023 at 12:37(UTC+0) by Jason Glatzer
Level 4: 200/500 (500) Entries: 189/199
Matti Lasanen bet 6,500 into a pot of around 10,000 with the on the board after the turn. Greger Larsson called and the action river completed the board.
Lasanen bet 16,500. Larsson went into the tank before he called.
Lasanen turned over the for a flush.
"Ooooh," Larsson said as if it was a pleasant surprise before turning over the for a stronger flush. "Lucky!"
"I was so happy to see that river," Lasanen said. "I was going to give up if I didn't get a heart."
Player
Chips
Progress
Greger Larsson
105,000
35,000
Matti Lasanen
22,000
28,000
Various Stacks at Break Posted Thursday 21st September, 2023 at 12:33(UTC+0) by Jason Glatzer
Player
Chips
Progress
Andrius Bielskis
140,000
100
Silver Simulask
108,000
0
Matus Fecisko
105,000
0
Yusuke Kakiuchi
90,000
40,000
Jevgenijs Udalovs
80,000
0
Greger Larsson
70,000
2,000
Steven Tool
65,000
0
12:27 (UTC+0)
Start of Level 4 Blinds: 200/500 Ante: 500
First Break Posted Thursday 21st September, 2023 at 12:00(UTC+0) by Jason Glatzer
Players are on their first break of Day 1c. The action will resume in 20 minutes with blinds at 200/500 along with a 500 big blind ante.
Friberg's Fives Get Fried Posted Thursday 21st September, 2023 at 11:59(UTC+0) by Jason Glatzer
Level 3: 200/400 (400) Entries: 162/171
Christopher Berggren called a jam by fellow Swede Erik Friberg with the on the board after the turn.
Erik Friberg: Christopher Berggren:
Berggren was far ahead with his turned trips with Friberg down to just two outs. The river wasn't one of them and Friberg was on the rail.
Player
Chips
Progress
Christopher Berggren
135,000
85,000
Ramunas Mika
60,000
10,000
Erik Friberg
0
0
Salonen Connects With His King Posted Thursday 21st September, 2023 at 11:47(UTC+0) by Jason Glatzer
Level 3: 200/400 (400) Entries: 154/161
Riccardo Usai and Martti Keel both checked the board after the turn when Jarmo Salonen fired out for 6,000. Usai called and Keel shrugged his shoulders before he folded.
The floor then came by to ask Keel to move tables so he wasn't able to see the rest of the hand which first involved Usai and Salonen checking the river. Keel turned over the and let out a whisper of a celebration after his pair of kings was good against a pair of sevens after Usai failed to get there on the river with .
Player
Chips
Progress
Jarmo Salonen
70,000
70,000
Martin Keel
65,000
15,000
Ricardo Usai
35,000
15,000
11:21 (UTC+0)
Start of Level 3 Blinds: 200/400 Ante: 400
Hursti Left Short After Eeva Bets Out of Turn Posted Thursday 21st September, 2023 at 11:20(UTC+0) by Jason Glatzer
Level 2: 100/300 (300) Entries: 144/147
The floor was called over with the on the board and 50,000 in the pot due to Antti Eeva betting 12,000 out of turn.
The floor explained to Anna-Mari Hursti and the rest of the table that all of her options were open. She can check, and then the bet by Eeva would have stood. If she bets instead, Eeva's bet gets taken back and the hand moves on from there.
A few minutes passed by before Hursti opted to fold.
Player
Chips
Progress
Anna-Mari Hursti
20,000
30,000
Antti Eeva
0
45,000
Rasanen Display Aggression Posted Thursday 21st September, 2023 at 11:03(UTC+0) by Jason Glatzer
Level 2: 100/300 (300) Entries: 135/137
The Day 1c field stands at 137 entries and counting with 135 players in their seats after Yusuke Kakiuchi joined Adrians Imsa on the rail.
Meanwhile, things are proceeding slightly better for the formidable Tomi Rasanen. There was 7,000 in the pot with the on the flop when Claudio Cecchi fired out for 2,800. Marius Vaitkevicius folded before Rasanen jacked it up to 7,500.
Cecchi took his time but eventually called to see the turn. Rasanen bet 12,000 after afte Cecchi checked and his opponent went into the tank for a couple of minutes before he folded.
Player
Chips
Progress
Tomi Rasanen
65,000
15,000
Aurelijius Sipavicius
60,000
10,000
Claudio Cecchi
55,000
5,000
Yusuke Kakiuchi
0
0
10:41 (UTC+0)
Start of Level 2 Blinds: 100/300 Ante: 300
Helppi, Pyysing, Sootla, and More in the Field Posted Thursday 21st September, 2023 at 10:39(UTC+0) by Jason Glatzer
WSOP bracelet winners Ranno Sootla and Juha Helppi went back to their roots last night and both entered different WSOPC Tallinn Main Event mega satellites.
Both players would have hopped into the Main Event regardless of whether they won a seat in their perspective satellites or not after a quick chat with both players late in the evening.
Finnish poker legend and journalist Aki Pyysing also is hunting for the most prestigious gold ring of them. Hassan Sey, Aurelijus Sipavicius, Justas Semaska, and the popular Swedish player Gregor Larsson are also already in the mix.
Player
Chips
Progress
Ranno Sootla
50,000
0
Justas Semeika
50,000
0
Juha Helppi
50,000
0
Gregor Larsson
50,000
0
Aurelijius Sipavicius
50,000
0
Aki Pyysing
50,000
0
Hassan Sey
50,000
0
Century Mark Achieved Posted Thursday 21st September, 2023 at 10:34(UTC+0) by Jason Glatzer
Level 1: 100/200 (200) Entries: 113/114
The Day 1c field has already grown to 114 entries. Adrians Imsa was the first players out on the rail on Day 1c but still has plenty of time to re-enter if he so chooses.
Player
Chips
Progress
Adrians Imsa
0
0
Cards in the Air Posted Thursday 21st September, 2023 at 10:26(UTC+0) by Jason Glatzer
Level 1: 100/200 (200) Entries: 61/61
Cards are in the air for Day 1c with 61 entries. There are many more gathering their seat slips at the cashier line, so expect this figure to grow quickly.
Welcome to Day 1c of the Main Event Posted Thursday 21st September, 2023 at 09:15(UTC+0) by Jason Glatzer
Get ready for some action on Thursday at the 2023 World Series of Poker Circuit (WSOPC) Tallinn with the final two of four opening flights of the 2023 WSOPC Tallinn €1,500 Main Event starting its action on Tuesday at noon. Not only will a play win a coveted WSOPC gold ring but also a lion's share of what promises to be a massive prize pool with a €1 million guarantee slapped on this event.
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 with one hour blind levels until the first-ever WSOPC Tallinn Main Event winner is crowned.
We will see many big names, including Finnish poker legend and two-time WSOP bracelet winner Juha Helppi (pictured below), who built up a big stack on Day 1a only for bad beats and coolers to take it away, hunting for 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.
The first two flights thus far attracted 246 entries with Estonian poker beast Urmo Velvelt advancing with the largest stack of 293,000 on Day 1b with Day 1a chip leader Joni Rantamaki from Finland is just behind with 276,000.
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.
09:00 (UTC+0)
Day 1C of WSOPC Tallinn Started Level: 1 Blinds: 100/200 Ante: 200
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.