0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0098 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1A/updates' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1A/updates', 1, '2024-07-27')

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

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

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

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

0.0002 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.0002 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.0002 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.0062 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.0002 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '33'

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

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

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

0.0230 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0043 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '130' AND `published` = 1

0.0228 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0046 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '132' AND `published` = 1

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

0.0331 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0041 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` = '1A'

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

0.0045 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '102' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.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` = '5324' 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` = '5319' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5322' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5316' 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` = '5314' 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` = '5313' 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` = '5320' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5310' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5307' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5303' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5298' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5291' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5290' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5286' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5277' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5321' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5272' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5268' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5265' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5267' 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` = '5259' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5255' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5253' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5247' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5243' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5239' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5238' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5236' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5234' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5229' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5228' ORDER BY `chip_change` DESC, `busted` ASC

0.0152 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5222' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5220' 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` = '5212' 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` = '5205' 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` = '5204' 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` = '5194' 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` = '5192' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5191' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5187' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5185' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5184' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5181' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5176' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5173' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5168' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5160' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5159' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5150' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5148' 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` = '5142' 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` = '5137' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0044 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '102' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.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` = '5324' 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` = '5319' 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` = '5322' 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` = '5316' 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` = '5314' 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` = '5313' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5312' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5320' 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` = '5310' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5307' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5303' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5298' 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` = '5291' ORDER BY `chip_change` DESC, `busted` ASC

0.0153 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5290' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5286' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5277' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5321' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5281' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5272' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5268' 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` = '5265' 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` = '5267' 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` = '5259' 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` = '5255' 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` = '5253' 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` = '5248' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5247' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5243' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5239' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5238' ORDER BY `chip_change` DESC, `busted` ASC

0.0163 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5236' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5234' 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` = '5229' 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` = '5228' 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` = '5222' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5220' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5212' 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` = '5205' 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` = '5204' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5194' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5192' 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` = '5191' 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` = '5187' 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` = '5185' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5184' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5181' 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` = '5176' 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` = '5173' 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` = '5168' ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5166' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5160' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5159' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5150' ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5148' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '5142' 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` = '5137' 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` = '5273' 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

English
WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 1A
Joni Rantamaki Bags Day 1a Chip Lead Posted Tuesday 19th September, 2023 at 20:18(UTC+0) by Jason Glatzer

The €1 million guaranteed Main Event was off to a hot start at Olympic Park Casino and the Hilton Tallinn Park with 139 runners getting into the action.

Finland's Joni Rantamaki (pictured above) was the star of the day as after 10 levels of 40 minutes each he parlayed his 50,000 opening stack into a massive pile of 272,000 to lead the 63 Day 1a survivors.

Estonia's Igor Pihela Sr. isn't too far behind in second place with 257,000 and his son Igor Pihela Jr. also managed to bag a top-five stack with 210,000.

In between the father and son duo were Taiwan's Yi-Zhan Peng (215,000) and up-and-coming Dutch superstar Gilles Simon (211,500).

It appeared that two-time WSOP bracelet winner and all-around Finnish baller Juha Helppi (pictured above) would also bag a big stack as he was cruising along most of the day near the top of the chip counts. He first got unlucky against 2018 Estonian Championship of Poker Main Event Champion Ermo Kosk as he witnessed his queens go down the toilet against tens after a ten spiked the river.

Shortly after, Helppi lost another big hand to Pihela Jr. that helped the latter catapult to the top five of the Day 1a chip counts when his two-pair proved to be no match against a straight. He was left with crumbs after that before handing them over the Ilya Nikiforov after jamming in the dark with five-three and not getting there against queen-jack. Helppi is the consummate pro who will shake off his misfortune at the end of the day and has confirmed he will be back battling tomorrow for Day 1b.

The live reporting crew at OlyBet.tv will be back Wednesday at 12 p.m. from when cards are in the air for Day 1b. Best of luck to all of the Day 1b players tomorrow!

Final Day 1a Chip Counts Posted Tuesday 19th September, 2023 at 18:54(UTC+0) by Jason Glatzer

Finland's Joni Rantamaki led the way among the 66 survivors on Day 1a. Check out the full chip counts below and stay tuned for a recap within the hour.

Player Chips Big Blinds
Joni Rantamaki 272,000 109
Igor Pihela Sr. 257,000 103
Yi-Zhan Peng 215,000 86
Gilles Simon 211,500 85
Igor Pihela Jr. 210,000 84
Aleksei Smirnov 204,500 82
Pekka Ikonen 203,500 81
Teemu Toikkanen 203,000 81
Samuel Richards 194,500 78
Marco Kolle 190,000 76
Artur Kulanurk 189,000 76
Eriks Krumins 176,500 71
Maksim Petrov 165,000 66
Vidar Assersen 163,500 65
Jan-Mikael Kesanen 157,500 63
Tomasz Mroz 156,000 62
Ermo Kosk 152,500 61
Sebastian Wahl 150,500 60
Hendrik Ulbo 149,000 60
Juha Elo 137,000 55
Torbjorn Larsen 132,000 53
Max Rotko 129,500 52
Hendry Kullamae 126,500 51
Jesus Ucero 122,000 49
Marko Harkonen 121,000 48
Aleksi Naski 120,500 48
Tornike Tchitadze 116,000 46
Toms Civcs 115,500 46
Verneri Hakkinen 115,000 46
Tapio Aaltonen 113,500 45
Algirdas Saveikis 106,000 42
Arko Akenparg 104,000 42
Tommi Lankinen 102,000 41
Ilya Nikiforov 101,000 40
Jimi Koponen 98,000 39
Rinalds Zimka 98,000 39
Mario Linno 97,000 39
Dmitrijs Meless 82,000 33
Johannes Levola 80,000 32
Karlis Kreslins 75,000 30
Joshua Stewart 74,500 30
Dan Korsunskyy 73,000 29
Alger Pissarev 71,500 29
Sergejs Piratovs 71,000 28
Hanna Heinlo 68,500 27
Damian Siewert 66,500 27
Damian Siewert 65,500 26
DamiaTUVAn Siewert 54,000 22
Kaspars Butans 53,000 21
Kristo Erala 51,000 20
Ken Okada 51,000 20
Dominik Ostrowski 50,500 20
Kris Tikka 50,000 20
Aleksander Lammas 47,500 19
Maikel Homin 44,000 18
Sergei Aleksejev 40,500 16
Rasmus Sepping 34,500 14
Rauno Remmel 30,000 12
Sten Talviste 30,000 12
Marko Vest 28,500 11
Raido Tsmir 19,000 8
Aurelijus Sipavicius 15,500 6
Olafs Karlins 12,000 5
The Unfortunate Demise of Juha Helppi Posted Tuesday 19th September, 2023 at 18:53(UTC+0) by Jason Glatzer

WSOP bracelet winner Juha Helppi (pictured below) was cruising all day long but noticeably missing from the end-of-the-day chip counts.

During the final level of mayhem at the end of the day, Helppi's stack fell apart. It all began with a bad beat delivered by Ermo Kosk who doubled through Helppi when his tens got their on the river against queens.

Igor Pihela Jr. then took most of the rest of what Helppi had left when he nailed a straight against Helppi's two pair. The crumbs then went to a third Estonian in Ilya Nikiforov when he jammed in the dark with five-three and didn't get there against queen-jack.

We will likely see Helppi back tomorrow as he shared with us earlier today that he is here only to grind the Main Event and perhaps also the €3,000 6-Max High Roller if he isn't deep in the Main Event on Day 3.

Players Bagging Chips Posted Tuesday 19th September, 2023 at 17:52(UTC+0) by Jason Glatzer

Players are bagging chips for Friday's Day 2. Stay tuned for the final chip counts of the day along with a recap shortly.

Simon Heads to Broadway Posted Tuesday 19th September, 2023 at 17:49(UTC+0) by Jason Glatzer

Level 10: 1,000/2,000 (2,000)
Entries: 66/138

Teemu Toikkanen went into the tank for several minutes facing a bet by Gilles Simon for 32,500 into a pot of around 50,000 with the on the board after the river.

Eventually, Toikkanen found a call only to muck his hand moments later after Simon turned over the for Broadway.

Player Chips Progress
Gilles Simon 250,000 200,000
Teemu Toikanen 70,000 40,000
Final Five Hands Posted Tuesday 19th September, 2023 at 17:47(UTC+0) by Jason Glatzer

The floor just stopped the clock with nearly 11 minutes remaining on Level 10 and informed the players that each table will play five more hands before bagging up their stacks to Friday's Day 2.

Big Hero Call On The River Posted Tuesday 19th September, 2023 at 17:44(UTC+0) by Alaxandar Georgiev

Level 10: 1,000/2,000 (2,000)
Entries: 68/138

Marko Harkonen was at it again on the  board keeping up the aggression that got him a big stack so far, he bet another 15,000 into the pot and Joni Rantamaki called. 

The river came  and it was Harkonen's turn again, he threw 35,000 chips in the middle, and shortly after Rantamaki made the call.

Marko Harkonen: 
Joni Rentamaki: 

The great read from Rantamaki earned him a pot worth more than 120,000 chips as we are 15 minutes away from ending Day 1.

Player Chips Progress
Joni Rantamaki 270,000 2,000
Marko Harkonen 100,000 21,000
Two-Times Finalist Flips Again Posted Tuesday 19th September, 2023 at 17:26(UTC+0) by Alaxandar Georgiev

Level 10: 1,000/2,000 (2,000)
Entries: 73/138

Joshua Stewert, who has already managed two final tables in his first two WSOP Circuit Events, was involved in another flip as he opened the pot to 4,000 and was re-raised to 12,000 by Ken Okada from the small blind. Stewert made a four-bet to 27,000 which was followed by a quick all-in for Okada's remaining 45,000 chips.

Joshua Stewert:
Ken Okada:

The flop didn't bring Stewert any luck and he was still behind in the hand. The turn was and the river was which secured the pot for Okada.

Joshua Stewert:

Player Chips Progress
Joshua Stewert 120,000 70,000
Ken Okada 90,000 40,000
17:17 (UTC+0)
Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000
Levola Picks Up A Double Posted Tuesday 19th September, 2023 at 17:04(UTC+0) by Alaxandar Georgiev

Level 9: 1000/1,500 (1,500)
Entries: 77/138

Johannes Levola three-bet an early raise from the small blind. Igor Pihela Jr. three-bet jammed from the big blind for 61,000. Levola didn't hesitate and called the all-in for his remaining 56,000 chips.

Johannes Levola:
Igor Pihela Jr:

The flop was a mixed-bag for Pihela Jr. as he was now behind and drawing to a nine or a flush. The turn was and the river came completing the full-house for the Finn.

Pihela was left with only 5,000 chips and he busted the tournament shortly after.



Player Chips Progress
Johannes Levola 115,000 65,000
Igor Pihela Jr. 5,000 45,000
Meet GGPoker Ambassador Anatoly Filatov at the WSOPC Tallinn Posted Tuesday 19th September, 2023 at 16:47(UTC+0) by Jason Glatzer

Snowmen Good for Saveikis Posted Tuesday 19th September, 2023 at 16:41(UTC+0) by Jason Glatzer

Level 8: 600/1,200 (1,200)
Entries: 85/138

Algirdas Saveikis opened for 3,500 from the cutoff and was called by Kaupo Tenno from the button before Stanislav Smeljov three-bet shoved for 51,000. Saveikas went into the tank before he called off his stack of 45,500 while Tenno opted to fold.

Algirdas Saveikis:
Stanislav Smeljov:

Saveikis won the flip to double his stack and leave his opponent with crumbs after Smeljov failed to connect with the runout.

Player Chips Progress
Algirdas Saveikis 95,000 45,000
Kaupo Tenno 85,000 5,000
Stanislav Smeljov 5,500 44,500
Party Chip Stack Update Posted Tuesday 19th September, 2023 at 16:39(UTC+0) by Alaxandar Georgiev

Players are coming back from the break. Most attended the awesome Meet & Greet organized by our hosts.

Check out some of the biggest stacks from around the room at the break below:

Player Chips Progress
Samuel Richards 185,000 70,000
Tornike Tchitadze 180,000 115,000
Aleksei Smirnov 180,000 20,000
Marko Harkonen 170,000 30,000
Igor Pihela 150,000 100,000
Hendrik Uibo 130,000 80,000
Toms Civcs 120,000 5,000
16:35 (UTC+0)
Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500
WSOPC Tallinn Meet & Greet at Break Posted Tuesday 19th September, 2023 at 16:02(UTC+0) by Jason Glatzer

The live music is here and the mission is clear. Now that the Main Event has arrived, it is time for some fun with a Meet & Greet ceremony with free drinks and live entertainment.

Due to the planned entertainment, the break that the players just went on will be extended from 20 to 30 minutes. Action should resume for the final two blind levels of Day 1a at approximately 6:30 p.m. local time.

Big Double For Nikiforov Posted Tuesday 19th September, 2023 at 16:01(UTC+0) by Alaxandar Georgiev

Level 8: 600/1,200 (1,200)
Entries: 93/138

After under the gun raise the pot was re-raised to 8,000 by Marko Harkonen from the cut-off followed by an all-in from Ilya Nikiforov for 45,000 on the small blind.  The bigger stack Harkonen called and we went to show down.

Marko Harkonen:
Ilya Nikiforov:

The flop looked great for Nikiforov and he won the hand after the  turn and
  river completed the board to give the Estonian a full double-up.

Marko Harkonen was left with 120,000 chips, while Ilya Nikiforov doubled up to 92,000

Kreslins Delivers Bad Beat to Sipavicius Posted Tuesday 19th September, 2023 at 15:42(UTC+0) by Jason Glatzer

Level 8: 600/1,200 (1,200)
Entries: 92/138

Karlis Kreslins open-jammed for 25,100 from the hijack and was looked up by Aurelijus Sipavicius from the blinds.

Karlis Kreslins:
Aurelijus Sipavicius:

It wasn't looking good for Kreslins until he improved to a set on the flop. Sipavicius still had some hope alive to get back into the hand after the turn gave him a flush draw but the blank river completed the bad beat delivery service by Kreslins to Sipavicius.

Meanwhile, Maksim Petrov at the same table was sitting on one of the biggest piles of chips in the room with around 200,000.

Player Chips Progress
Maksim Petrov 200,000 150,000
Karlis Kreslins 55,000 25,000
Aurelijus Sipavicius 11,000 69,000
Krumins Coolers Tchitadze Posted Tuesday 19th September, 2023 at 15:29(UTC+0) by Jason Glatzer

Level 8: 600/1,200 (1,200)
Entries: 96/138

Erik's Krumins had his stack of around 40,000 committed into the pot with against Tornike Tchitadze with on a board.

Tchitadze's flush was a strong hand but he doubled up Krumins who was even stronger with a full house.

"Good river for both of us," Krumins said after the hand.

Player Chips Progress
Eriks Krumins 110,000 60,000
Tornike Tchitadze 65,000 65,000
Henri Vaisanen 0 0
Roope Tarmi 0 0
Koit Kann 0 0
15:25 (UTC+0)
Start of Level 8
Blinds: 600/1,200     Ante: 1,200
Post-Flop Action Posted Tuesday 19th September, 2023 at 15:21(UTC+0) by Alaxandar Georgiev

Level 7: 500/1000 (1000)
Entries: 96/137


Henrik Puija opened from the cut-off and Toms Civcs called from the small blind. 

The flop went check-check, but action unfolded on the turn where Puija bet 3,000, and shortly after Civcs raised to 9,000.

Civcs fired out for 30,000 on the river and was called by Puija.

Civcs revealed his  and Puija mucked his hand saying: "I had an ace .."

Player Chips Progress
Toms Civcs 115,000 65,000
Henrik Puija 27,000 23,000
Zabolovskis Loses Short Stack Posted Tuesday 19th September, 2023 at 15:05(UTC+0) by Jason Glatzer

Level 7: 500/1,000 (1,000)
Entries: 99/137

There wasn't much in the pot when Janis Zablovskis (picured below) jammed for 8,000 on the flop. Martin Zobel called while Mauri Dorbek folded.

Janis Zablovskis:
Martin Zobel:

Zablovskis flopped top pair but Zobel was far ahead after he improved to two pair. Neither the turn nor the river saved Zablovskis and he was on the rail at least for now.

Player Chips Progress
Martin Zobel 60,000 0
Mauri Dorbek 20,000 30,000
Rene Peterkopf 0 0
Irmantas Bzeskis 0 0
Janis Zablovskis 0 0
Laja Turns a Flush Posted Tuesday 19th September, 2023 at 14:57(UTC+0) by Jason Glatzer

Level 7: 500/1,000 (1,000)
Entries: 103/136

There wasn't too much in the pot when Henri Vaisanen check-jammed the flop. Heiki Laja already had a good portion of his 16,400 stack committed when he made the call.

Heiki Laja:
Herni Vaisanen:

Vaisanen's cowboys were unable to hold despite improving to a set on the turn. The problem was this improved Laja to a flush. Vaisanen was unable to further improve to a full house or quads on the river and Laja doubled his stack instead of hitting the rail.

Player Chips Progress
Henri Vaisanen 40,000 10,000
Henri Laja 35,000 15,000
Mikael Gronvik 0 0
Vadim Guk 0 0
Big Stacks at Break Posted Tuesday 19th September, 2023 at 14:50(UTC+0) by Alaxandar Georgiev
Player Chips Progress
Juha Helppi 200,000 75,000
Vidar Assersen 180,000 130,000
Marko Harkonen 140,000 90,000
Daniel Korsunskyy 138,000 63,000
Tornike Tchitadze 130,000 99,000
Rudolf Rotko 130,000 80,000
Yi-Zhan Peng 130,000 20,000
Torbjorn Larsen 115,000 40,000
Samuel Richards 115,000 65,000
14:43 (UTC+0)
Start of Level 7
Blinds: 500/1,000     Ante: 1,000
Kann Ousts Garrido at the Break Posted Tuesday 19th September, 2023 at 14:27(UTC+0) by Jason Glatzer

Level 6: 400/800 (800)
Entries: 103/134

While most tables went on break, one table took a little longer. Ignacio Garrido jammed a short stack from the small blind with . Koit Kann snap-called with from the big blind.

Garrido pulled ahead on the flop but Kann was back on top in the hand after the turn. A blank river completed the board and Garrido will need to re-enter for a chance at advancing to Day 2 and beyond.

Player Chips Progress
Koit Kann 50,000 0
Ignacio Garrido 0 0
Break Time! Posted Tuesday 19th September, 2023 at 14:23(UTC+0) by Jason Glatzer

Players are on a 20-minute break. Blinds will increase to 500/1,000 along with a 1,000 big blind ante when the action resumes.

We will provide an update with some of the biggest stacks around the room after the break.

"Give Me a Double-Up or I Go Rebuy" Posted Tuesday 19th September, 2023 at 14:14(UTC+0) by Jason Glatzer

Level 6: 400/800 (800)
Entries: 108/132

Andrey Koks is having some fun over on Table 19 and just talked Tonis Viik into a call.

The was on the flop with not much in the pot when Koks checked. Viik was getting a massage and bet 1,500. Koks jammed for 21,400 and Viik went into the tank.

Viik asked for a count before tanking some more. Koks decided to try some table talk at this point in time.

"I have nothing on the flop," Koks said with a smile. "No connection, or maybe I am joking. Give me a double-up or I go rebuy."

Eventually, Viik found a call and despite not connecting with the board was ahead at that particular moment with the players more or less flipping.

Andrey Koks:
Tonis Viik:

The turn improved Koks to a wheel but he wasn't out of the woods yet.

"Well, you can still get a ten," Koks said.

No ten came. Instead, it was the river to complete the board and Koks doubled through Viik instead of re-entering.

Player Chips Progress
Andrey Koks 50,000 0
Tonis Viik 45,000 5,000
Peng Picks Off Bzeskis Posted Tuesday 19th September, 2023 at 14:02(UTC+0) by Jason Glatzer

Level 6: 400/800 (800)
Entries: 108/132

Yi-Zhan Peng checked with 35,000 in the pot and the on the board before Irmantas Bzeskis bet 12,500. Peng paused for about 20 seconds before he tossed in a chip to call.

Bzeskis turned over the for ace-high before Peng showed the to win the hand with the top pair.

Player Chips Progress
Yi-Zhan Peng 150,000 100,000
Irmantas Bzeskis 30,000 20,000
Day 5 Video Recap Posted Tuesday 19th September, 2023 at 13:49(UTC+0) by Jason Glatzer

13:44 (UTC+0)
Start of Level 6
Blinds: 400/800     Ante: 800
Watch the Mystery Bounty Stream Posted Tuesday 19th September, 2023 at 13:44(UTC+0) by Jason Glatzer

The final table of Event #5: €660 Mystery Bounty has kicked off. You can check out the action at OlyBet.tv.

Time will tell who will win the €10,000 top prize and the €10,000 mystery bounty.

Levin Bricks Flush Draw Posted Tuesday 19th September, 2023 at 13:25(UTC+0) by Jason Glatzer

Level 5: 300/600 (600)
Entries: 108/125

Jelissei Levin donk-jammed the turn for 12,000 with the on the board after the turn and was called by Rene Peterkopf.

Jelissei Levin:
Rene Peterkopf:

Levin was behind but any heart would win him the hand. However, the blank river completed the board and Levin's chips went into Peterkopf's stack.

Player Chips Progress
Rene Peterkopf 65,000 15,000
Jelissei Levin 0 0
"I Thought He Just Called" Posted Tuesday 19th September, 2023 at 13:19(UTC+0) by Jason Glatzer

Level 5: 300/600 (600)
Entries: 109/125

Oliver Kullman bet 5,000 into a pot of around 15,000 with the on the board after the river.

Jussi Hakkinen tanked for about 30 seconds before raising to 15,000. Kullman instantly turned over his cards showing his for the second nut flush.

"Show your cards," the dealer said to Kullman. "It is not a fold when you show your cards."

"My mistake," replied Kullman. "I thought he just called."

Although everyone at the table appeared to agree, just to be safe the floor was called over. The floor confirmed exactly what the dealer told Kullman and he subsequently announced a call.

Hakkinen showed the and had his opponent drawing dead after flopping a flush to win the hand.

Player Chips Progress
Jussi Hakkinen 90,000 40,000
Oliver Kullman 25,000 25,000
13:00 (UTC+0)
Start of Level 5
Blinds: 300/600     Ante: 600
Trip Fives for Zobel Posted Tuesday 19th September, 2023 at 12:48(UTC+0) by Jason Glatzer

Level 4: 200/500 (500)
Entries: 102/114

Martin Zobel fired out for 10,000 into a pot of approximately 15,000 with the on the board and Tomasz Mros quickly called.

"Ace-five," Zobel said before seconds later turning over the .

Mros rechecked his hand before mucking his cards for Zobel to win the pot with trip fives.

Player Chips Progress
Martin Zobel 60,000 15,000
Tomasz Mroz 25,000 25,000
Big Blind Special for Helppi Posted Tuesday 19th September, 2023 at 12:39(UTC+0) by Jason Glatzer

Level 4: 200/500 (500)
Entries: 96/108

Both Joni Rantamaki and Juha Helppi (pictured below) got tangled up in a pot from the blinds when both players checked the  turn with already 15,000 in the pot.

Rantamaki fired out for 3,800 after the river completed the board. Helppi tanked for a minute before he raised to 15,000 and Rantamaki quickly called.

Helppi immediately turned over the for a full house.

"Nice hand," Rantamaki said as he tossed his hand face down into the muck.

Meanwhile, Taago Tamm lost his stack around the same time and will need to re-enter if he wants a shot at WSOPC Tallinn Main Event glory.

Player Chips Progress
Juha Helppi 125,000 25,000
Joni Rantamaki 40,000 10,000
Taago Tamm 0 0
Richards Leads at Break Posted Tuesday 19th September, 2023 at 12:26(UTC+0) by Jason Glatzer

American Samuel Richards is easily the chip leader at the first break with 180,000. He shared during the break that he got it in with kings and was up against aces and queens. The kings got there to give him a lion's share of what he is sitting on now.

Check out the biggest stacks on break below:

Player Chips Progress
Samuel Richards 180,000 130,000
Tomi Rasanen 110,000 15,000
Juha Helppi 100,000 5,000
Juha Elo 90,000 40,000
Kaupo Tenno 90,000 40,000
Alger Pissarev 80,000 30,000
Aurelijus Sipavicius 80,000 30,000
Karlis Kreslins 80,000 30,000
Ori Hasson 80,000 15,000
More Than 100 Entries! Posted Tuesday 19th September, 2023 at 12:22(UTC+0) by Jason Glatzer

Level 4: 200/500 (500)
Entries: 98/106

A handful of players hopped into the Main Event on the break to bring the Day 1a field past 100 entries and counting.

12:21 (UTC+0)
Start of Level 4
Blinds: 200/500     Ante: 500
First Break Posted Tuesday 19th September, 2023 at 12:04(UTC+0) by Jason Glatzer

Main Event players are on their first 20-minute break. Blinds will increase to 200/500 with a 500 big blind ante when the action resumes.

Korsunskyy Chips Up Posted Tuesday 19th September, 2023 at 12:04(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 91/99

Ukraine's Daniel Korsunskyy fired out for 7,200 into a pot of around 12,000 with the on the board after the turn and was called by Rinalds Zimka.

The river completed the board and Korsunskyy tanked for a minute before betting 9,400. Zimka tanked for several minutes. He stared briefly at Korsunskyy who was stoically looking down at the table. A minute later, Zimka gave up on the hand and the dealer pushed a decent pile of chips towards Korsunskyy.

Player Chips Progress
Daniel Korsunskyy 75,000 25,000
Rinalds Zimka 35,000 15,000
Helppi Gets Some Help on the River Posted Tuesday 19th September, 2023 at 11:47(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 91/97

Juha Helppi and Oleh Bohdanov (pictured below) got their stacks in on the turn with the  on the board with Bohdanov at risk but far ahead.

Oleh Bohdanov:
Juha Helppi:

Bohdanov appeared to be primed to double or worst case to chop the pot if the board double pair. However, Helppi nailed his three-outer to improve to a full house and send Bohdanov to the rail after the river completed the board.

"Easy game," Helppi said with a smile.

Player Chips Progress
Juha Helppi 95,000 35,000
Oleh Bohdanov 0 0
Tamm Runs Into Hasson's Flush Posted Tuesday 19th September, 2023 at 11:37(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 86/89

Ori Hasson opened for 900 from the cutoff and was called by Taago Tamm from the button and Vadim Guk from the small blind.

Three monotone clubs came on the flop. Guk and Hasson both checked before Tamm led out for 1,100. This was enough for Guk to fold but Hasson had a different idea and raised to 3,500. Tamm called to see the turn.

Hasson paused for about 30 seconds before he bet 8,600. Tamm tanked for about as long before he called.

The river paired the board and Hasson fired out for 13,500.

Tamm counted out his chips before going into the tank for several minutes.

"Is it always aces with the ace of club or something else?" Tamm said.

Seconds later, Tamm called only to get the bad news with Hasson turning over the for the ace-high flush. This was enough as Tamm mucked his hand facedown.

"It was something better," Tamm said to Hasson as the dealer was getting ready for the next hand.

Player Chips Progress
Ori Hasson 95,000 45,000
Vadim Guk 45,000 5,000
Taago Tamm 35,000 15,000
11:23 (UTC+0)
Start of Level 3
Blinds: 200/400     Ante: 400
Top Set for Rasanen Posted Tuesday 19th September, 2023 at 11:14(UTC+0) by Jason Glatzer

Level 2: 100/300 (300)
Entries: 79/81

Tornike Tchitadze fired out for 7,500 into a spread pot of a bit more with the on the board after the river.

Tomi Rasanen called and won the hand when his top set with was more than good against the top pair with held by Tchitadze.

Player Chips Progress
Tomi Rasanen 95,000 45,000
Tornike Tchitadze 31,000 19,000
Zobel Chips Up Against Remmel Posted Tuesday 19th September, 2023 at 11:02(UTC+0) by Jason Glatzer

Level 2: 100/300 (300)
Entries: 76/77

Latvians Olaf Karlins and Janis Zablovskis are both seated next to each other on Table 6 with both players holding around 75,000 in chips.

It wasn't these two players that locked up in a hand as instead it was Rauno Remmel and Martin Zobel battling it out.

We caught up with the hand with Zobel raising from the big blind to 3,800 and Remmel calling from late position.

Zobel fired out for 6,000 on the flop and Remmel called. The action slowed down on the turn with it taking more than a minute for Zobel to bet 15,000. Remmel tanked for several minutes before he laid down his hand.

Meanwhile, a different Estonian Hendry Kullamae was the first player to hit the rail in the Main Event.

Player Chips Progress
Janis Zablovskis 75,000 25,000
Olaf Karlins 75,000 25,000
Rauno Remmel 55,000 5,000
Martin Zobel 45,000 5,000
Hendry Kullamae 0 0
10:42 (UTC+0)
Start of Level 2
Blinds: 100/300     Ante: 300
Not the Best Start for Gronvik Posted Tuesday 19th September, 2023 at 10:41(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 67/67

Mikael Gronvik hasn't had the best start to the day after losing three big pots. He shared one of the pots he lost involved ace-seven suited against ace-jack with two aces on the board. We caught the last of the three hands which brought him down to 11,500 from his 50,000 starting stack. Still plenty of big blinds but we are sure he'd like to restart the day.

Joel Lindpere checked before Mikael Gronvik checked. Torbjorn Larsen fired out for 7,100 into a pot of around double that with the on the board. Gronvik opted to call, while Lindpere folded.

Gronvik turned over the but his two pair wasn't good enough with Larsen taking down the pot with with a full house.

"I got very lucky there," Lindpere said to the table after the hand. "I had king-queen of clubs and was going for the flush."

If Lindpere hit his flush we would likely see him much lower in the chip counts. But that wasn't the case and, like Larsen, he is also above a starting stack.

Player Chips Progress
Torbjorn Larsen 75,000 25,000
Joel Lindpere 55,000 5,000
Mikael Gronvik 11,500 38,500
Big Slick Good for Helppi Posted Tuesday 19th September, 2023 at 10:23(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 61/61

There were about 1,600 in chips in the pot with the already on the flop when Oleh Bohdanov check-called a 1,000 bet by Juha Helppi.

Bohdanov check-called a bigger bet by Helppi of 4,100 on the turn before leading out for 5,000 once the paired the board on the river.

Helppi tanked for close to a minute before he min-clicked it back with a raise to 10,000. Bohdanov tanked for more than a minute before he tossed a chip in to call. Helppi turned over the and won the hand after Bohdanov mucked his cards.

Player Chips Progress
Juha Helppi 60,000 10,000
Oleh Bohdanov 40,000 10,000
Juha Helppi and Joel Lindpere in the Field Posted Tuesday 19th September, 2023 at 10:13(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 45/45

WSOP bracelet winner Juha Helppi is easily the biggest name in poker already in the field. However, he isn't the only big name in action as former Estonian professional footballer Joel Lindpere also won a satellite yesterday and is in action.

Torbjorn Larsen, who was at the final table of Event #1: €555 No-Limit Hold'em, Mikael Gronvik, and Samuel Richards are among the other players to start the day with chips.

Player Chips Progress
Mikael Gronvik 50,000 0
Samuel Richards 50,000 0
Torbjorn Larsen 50,000 0
Juha Helppi 50,000 0
Joel Lindpere 50,000 0
Action Begins Posted Tuesday 19th September, 2023 at 10:04(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 42/42

Famous tournament director Teresa Nousiainen shared some announcements with the Main Event players before the action kicked off with 42 players in their seats.

Best of luck to all of the players and "Shuffle up and deal!"

Welcome to Day 1a of the €1 Million Guaranteed WSOPC Tallinn Main Event Posted Tuesday 19th September, 2023 at 08:05(UTC+0) by Jason Glatzer

The day we have all been waiting for is finally here as today is the start of the crown jewel of the inaugural World Series of Poker Circuit (WSOPC) Tallinn with the first of four opening flights of the 2023 WSOPC Tallinn €1,500 Main Event kicks off on Tuesday at noon.

The four-day Main Event is a deep-stacked affair boasting four opening flights from Sept. 19-21 with players starting with 50,000 in opening chips. Blinds increase slowly at every 40 minutes during the first three opening flights with the final opening flight moving along a little quicker with 30-minute blind levels.

Players will have plenty of opportunities to accumulate chips with unlimited re-entries permitted throughout the four opening flights and during the first two blind levels of Day 2. The battle will continue on Sept. 22-24 until the first-ever WSOPC Tallinn Main Event winner is crowned.

We will see many big names, including Finnish poker legend Juha Helppi who arrived last night with his eyes on the Main Event gold ring awarded to the winner along with a healthy top prize and an invitation to a $1 million guaranteed 2023 WSOP Tournament of Champions freeroll where a WSOP bracelet is on the line.

Our coverage starts at noon with blinds at 100/200 and a 200 big blind ante. Follow the Main Event journey throughout the week while we report the biggest hands, bad beats, and stories until a winner is crowned.


Your search results are valid for . 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.