0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0085 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-22' AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1C/updates' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1C/updates', 1, '2024-12-22')

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.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

0.0003 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.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.0039 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

0.0005 SECONDS:
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stop_blogs` LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id` LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `friendly_url` = 'wsopctallinn_2023_event6'

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '33'

0.0285 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0084 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '102' AND `published` = 1

0.0291 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0068 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '125' AND `published` = 1

0.0281 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0062 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '129' AND `published` = 1

0.0273 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` = '130' AND `published` = 1

0.0273 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` = '132' AND `published` = 1

0.0302 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0057 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '135' AND `published` = 1

0.0275 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` = '138' AND `published` = 1

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '33' AND `name` = '1C'

0.0062 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.0064 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.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` = '5595' 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` = '5591' 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` = '5593' ORDER BY `chip_change` DESC, `busted` ASC

0.0114 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0102 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5581' ORDER BY `chip_change` DESC, `busted` ASC

0.0114 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0114 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0095 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5577' ORDER BY `chip_change` DESC, `busted` ASC

0.0114 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5572' 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` = '5570' ORDER BY `chip_change` DESC, `busted` ASC

0.0114 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0114 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0114 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0081 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5560' 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` = '5559' ORDER BY `chip_change` DESC, `busted` ASC

0.0081 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0083 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5550' ORDER BY `chip_change` DESC, `busted` ASC

0.0079 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5547' 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` = '5541' 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` = '5539' 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` = '5538' 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` = '5536' 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` = '5534' 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` = '5528' 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` = '5529' 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` = '5527' 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` = '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.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` = '5523' 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` = '5518' 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` = '5517' 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` = '5515' 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` = '5510' ORDER BY `chip_change` DESC, `busted` ASC

0.0081 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5506' 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` = '5502' 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` = '5501' 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` = '5499' 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` = '5498' 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` = '5494' 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` = '5493' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 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.0059 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '129' 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` = '5595' 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` = '5592' 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` = '5591' 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` = '5593' 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` = '5587' 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` = '5583' 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` = '5581' 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` = '5585' 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` = '5579' 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` = '5578' 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` = '5577' 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` = '5573' 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` = '5572' 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` = '5571' 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` = '5570' 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` = '5568' 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` = '5567' 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` = '5565' 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` = '5561' 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` = '5560' 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` = '5559' 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` = '5555' 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` = '5552' 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` = '5550' 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` = '5549' 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` = '5547' 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` = '5541' 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` = '5544' 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` = '5539' 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` = '5538' 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` = '5536' 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` = '5534' 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` = '5528' 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` = '5529' ORDER BY `chip_change` DESC, `busted` ASC

0.0110 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0125 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5526' ORDER BY `chip_change` DESC, `busted` ASC

0.0128 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0123 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0123 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5517' 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` = '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.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` = '5509' 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` = '5506' 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` = '5502' 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` = '5501' 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` = '5499' 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` = '5498' 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` = '5494' 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` = '5493' ORDER BY `chip_change` DESC, `busted` ASC

0.0058 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '138' ORDER BY `busted` ASC, `current_chips` DESC

0.0003 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2143

English
WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 1C
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 . More 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.