0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0109 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/3/updates'
ORDER BY `views` DESC

0.0009 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/3/updates', 1, '2024-12-26')

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

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

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

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

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

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

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

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

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

0.0005 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

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

0.0058 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.0007 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` = 'summer_showdown_main_2023'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'

0.0357 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0077 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '75'
AND `published` = 1

0.0318 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0048 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '83'
AND `published` = 1

0.0284 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0049 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '85'
AND `published` = 1

0.0283 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0044 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '86'
AND `published` = 1

0.0304 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0051 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '90'
AND `published` = 1

0.0437 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0087 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '92'
AND `published` = 1

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
AND `name` = '3'

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

0.0070 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` = '90'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

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

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

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

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

0.0104 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4217'
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` = '4214'
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` = '4211'
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` = '4208'
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` = '4207'
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` = '4202'
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` = '4196'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0071 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4179'
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` = '4178'
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` = '4173'
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` = '4170'
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` = '4165'
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` = '4163'
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` = '4159'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0171 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4143'
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` = '4135'
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` = '4132'
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` = '4129'
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` = '4130'
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` = '4122'
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` = '4114'
ORDER BY `chip_change` DESC, `busted` ASC

0.0076 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4112'
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` = '4107'
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` = '4101'
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` = '4091'
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` = '4090'
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` = '4087'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4072'
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` = '4070'
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` = '4069'
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` = '4065'
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` = '4063'
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` = '4056'
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` = '4054'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4053'
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` = '4050'
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` = '4045'
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` = '4042'
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` = '4038'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4031'
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` = '90'
ORDER BY `busted` ASC, `current_chips` DESC

0.0056 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '90'
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` = '4259'
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` = '4251'
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` = '4250'
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` = '4248'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4244'
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` = '4241'
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` = '4239'
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` = '4235'
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` = '4230'
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` = '4229'
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` = '4217'
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` = '4214'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4202'
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` = '4196'
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` = '4193'
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` = '4189'
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` = '4186'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4178'
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` = '4173'
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` = '4170'
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` = '4165'
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` = '4163'
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` = '4159'
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` = '4158'
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` = '4152'
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` = '4143'
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` = '4135'
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` = '4132'
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` = '4129'
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` = '4130'
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` = '4122'
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` = '4114'
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` = '4112'
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` = '4107'
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` = '4101'
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` = '4091'
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` = '4090'
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` = '4087'
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` = '4075'
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` = '4072'
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` = '4070'
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` = '4069'
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` = '4065'
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` = '4063'
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` = '4056'
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` = '4054'
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` = '4053'
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` = '4050'
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` = '4045'
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` = '4042'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4038'
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` = '4034'
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` = '4033'
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` = '4032'
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` = '4031'
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` = '92'
ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(3)
  • 888poker UK Poker League(6)
  • APAT(1)
  • APPT(0)
  • Aria Resort & Casino(1)
  • Asian Poker Tour(5)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(11)
  • BSOP(0)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(1)
  • EPT(2)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(70)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(0)
  • GUKPT Grosvenor(9)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • Kings of Tallinn(1)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(11)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Open(5)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(0)
  • The Caribbean Poker Series(0)
  • The Festival(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(1)
  • Women's Winter Festival(0)
  • WPT(1)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(13)
  • WSOP International Circuit(5)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €1,100 Main Event Live Reporting - Day 4

Kings of Tallinn Summer Showdown 2023 - Live Reporting

2023 Tallinn Summer Showdown €1,100 Main Event See other events

2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event

Kings of Tallinn Summer Showdown 2023 - Live Reporting 2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event

---

Current Level 33 Current Day 4

---

Blinds 100,000/200,000 Ante 200000

Entries 564 Remaining 1

---

Prize Pool (EUR) €530,160 First Prize (EUR) €108,260

Chip Leaders Day 4

1

Kai Lehto

17,000,000

Day 1A Day 1B Day 1C Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 3

Final Day 3 Chip Counts Posted Sunday 30th July, 2023 at 02:23(UTC+0) by Jason Glatzer

Place	Player	Chips	Big Blinds
1	Kai Lehto	3,020,000	50
2	Urmo Velvelt	2,665,000	44
3	Tarmo Tammel	2,340,000	39
4	Mikael Haapaniemi	2,130,000	36
5	Magnus Pukk	1,605,000	27
6	Tomi Arponen	1,535,000	26
7	Phil Gross	1,360,000	23
8	Nils Linden	990,000	17
9	Ville-Matti Keranen	730,000	12
10	Tapio Aaltonen	345,000	6

Player		Chips	Progress
Kai Lehto		3,320,000	75,000
Urmo Velvelt		2,665,000	95,000
Tarmo Tammel		2,340,000	610,000
Mikael Haapaniemi		2,130,000	90,000
Magnus Pukk		1,605,000	635,000
Tomi Arponen		1,535,000	155,000
Phil Gross		1,360,000	240,000
Nils Linden		990,000	305,000
Ville-Matti Keranen		730,000	905,000
Tapio Aaltonen		345,000	375,000

23:12 (UTC+0)

Start of Level 27
Blinds: 25,000/50,000     Ante: 50,000

Updated Chip Counts Posted Saturday 29th July, 2023 at 23:09(UTC+0) by Jason Glatzer

Player	Chips	Big Blinds
Kai Lehto	3,395,000	68
Urmo Velvelt	2,760,000	55
Mikael Haapaniemi	2,040,000	41
Tarmo Tammel	1,730,000	35
Ville-Matti Keränen	1,635,000	33
Phil Gross	1,600,000	32
Tomi Arponen	1,380,000	28
Magnus Pukk	970,000	19
Tapio Aaltonen	720,000	14
Nils Linden	685,000	14

Ilya Nikiforov Out at TV Table and Break Posted Saturday 29th July, 2023 at 22:57(UTC+0) by Jason Glatzer

Level 26: 20,000/40,000 (40,000)
Entries: 10/564

Ilya Nikiforov just hit the rail moments before the break at the TV table. The action will resume one player away from the final table after a short 15-minute break.

Player		Chips	Progress
Ilya Nikiforov		0	0

Gross Doubles Again Posted Saturday 29th July, 2023 at 22:39(UTC+0) by Jason Glatzer

Level 26: 20,000/40,000 (40,000)
Entries: 11/564

Phil Gross doubled his short stack before doubling it again in the following hand.

There wasn't much in the pot when Mikael Haapaniemi checked-raised the flop from 75,000 to 300,000. Gross jammed for 670,000 and Haapaniemi called.

Phil Gross:
Mikael Haapaniemi:

Both players had the same flush draw with Gross drawing to the nuts. However, Gross was behind Haapaniemi's sevens if no spade came with both players holding blockers to each other. The turn was irrelevant but the river pushed Gross ahead with a better pair.

"Yes!" said Gross as his rail cheered.

Player		Chips	Progress
Mikael Haapaniemi		2,500,000	700,000
Phil Gross		1,400,000	600,000

Big Slick for Aaltonen Posted Saturday 29th July, 2023 at 22:19(UTC+0) by Jason Glatzer

Level 26: 20,000/40,000 (40,000)
Entries: 11/564

Mikael Haapaniemi jammed from the small blind. Tapio Aaltonen (pictured below) looked down at his cards and called off his stack of 350,000.

Tapio Aaltonen:
Mikael Haapaniemi:

Haapaniemi didn't soar past Aaltonen's big slick on the and Aaltonen let out a big smile after doubling his stack instead taking a bad beat and going to the rail.

Player		Chips	Progress
Mikael Haapaniemi		3,200,000	90,000
Tapio Aaltonen		740,000	170,000

Velvelt Dispatches Filatov Posted Saturday 29th July, 2023 at 22:12(UTC+0) by Jason Glatzer

Level 26: 20,000/40,000 (40,000)
Entries: 11/564

GGPoker Ambassador Anatoly Filatov (pictured below) had a bit of bad luck losing two hands while he was ahead when the action was down to two tables. Moments ago, he lost a crucial flip and hit the rail in 12th place for €5,300 as follows.

Filatov three-bet jammed for 650,000 from the big blind and was called by Urmo Velvelt who opened from middle position.

Anatoly Filatov:
Urmo Velvelt:

Velvelt connected not only connected but improved to a full house on the board to oust the most accomplished player that was remaining in the field.

Player		Chips	Progress
Urmo Velvelt		2,600,000	1,515,000
Anatoly Filatov		0	0

Heiska Out at TV Table Posted Saturday 29th July, 2023 at 22:08(UTC+0) by Jason Glatzer

Level 26: 20,000/40,000 (40,000)
Entries: 12/564

Juho Heiska hit the rail at the TV table during the opening moments of Level 26 in 13th place for €4,500.

He got it in from the cutoff with suited against Ville-Matti Keranen's . You can check out the hand on the stream at OlyBet.tv.

Player		Chips	Progress
Ville-Matti Keranen		1,100,000	315,000
Juho Heiska		0	0

21:58 (UTC+0)

Start of Level 26
Blinds: 20,000/40,000     Ante: 40,000

Arponen Cracks Filatov's Cowboys Posted Saturday 29th July, 2023 at 21:56(UTC+0) by Jason Glatzer

Level 25: 15,000/30,000 (30,000)
Entries: 13/564

"Just when I thought I was out, they pulled me back in," is a famous saying from the Sopranos. That saying applies to Tomi Arponen (pictured below) after he delivered GGPoker Ambassador Anatoly Filatov a bad beat.

Mikael Haapaniemi opened for a min-raise from the button before Arponen three-bet shoved for 365,000 from the small blind. Filatov four-bet shoved for close to 1,000,000 and Haapaniemi got out of the way.

Tomi Arponen:
Anatoly Filatov:

It looked like we would be down to a dozen players but we remained at a dirty dozen but not without some drama. Nothing fancy happened on either the flop or the turn. Arponen began to stand up and even wished a player a 'good game' before shock came across on his face with the spiking the river to pull ahead of Filatov with a full house.

The rail around the outer table erupted as well. Filatov appeared to take it all well and just continued along with his massage despite suffering two bad beats this blind level in all-in and call situations.

Player		Chips	Progress
Tomi Arponen		850,000	275,000
Anatoly Filatov		600,000	1,100,000

Gross Delivers Bad Beat to Filatov Posted Saturday 29th July, 2023 at 21:06(UTC+0) by Jason Glatzer

Level 25: 15,000/30,000 (30,000)
Entries: 13/564

Phil Gross three-bet shoved over the open by Anatoly Filatov for 375,000 and Filatov called.

Phil Gross:
Anatoly Filatov:

Gross was asking for a jack and none came on the flop. He shouted from joy after the turn pushed him ahead and now begged the dealer not to deal a queen. Instead, it was the completing the board for Gross to double with two pair.

Player		Chips	Progress
Anatoly Filatov		1,700,000	425,000
Phil Gross		800,000	425,000

Updated Chip Counts Posted Saturday 29th July, 2023 at 21:02(UTC+0) by Jason Glatzer

Player	Chips	Big Blinds
Mikael Haapaniemi	3,110,000	104
Anatoly Filatov	2,125,000	71
Kai Lehto	2,100,000	70
Magnus Pukk	1,745,000	58
Ilya Nikiforov	1,550,000	52
Tarmo Tammel	1,490,000	50
Urmo Velvelt	1,085,000	36
Tapio Aaltonen	910,000	30
Ville-Matti Keranen	785,000	26
Tomi Arponen	575,000	19
Nils Linden	540,000	18
Juho Heiska	525,000	18
Phil Gross	375,000	13

Player		Chips	Progress
Mikael Haapaniemi		3,110,000	330,000
Anatoly Filatov		2,125,000	1,055,000
Kai Lehto		2,100,000	175,000
Magnus Pukk		1,745,000	1,145,000
Ilya Nikiforov		1,550,000	60,000
Tarmo Tammel		1,490,000	1,170,000
Urmo Velvelt		1,085,000	215,000
Tapio Aaltonen		910,000	100,000
Ville-Matti Keranen		785,000	307,000
Tomi Arponen		575,000	200,000
Nils Linden		540,000	65,000
Juho Heiska		525,000	545,000
Phil Gross		375,000	75,000

20:53 (UTC+0)

Start of Level 25
Blinds: 15,000/30,000     Ante: 30,000

Break Time Posted Saturday 29th July, 2023 at 20:35(UTC+0) by Jason Glatzer

The final 13 players are on a short 20-minute break. Blinds will increase to 15,000/30,000 with a 30,000 big blind ante when the action resumes.

Abid Out at TV Table Posted Saturday 29th July, 2023 at 20:34(UTC+0) by Jason Glatzer

Level 24: 10,000/25,000 (25,000)
Entries: 13/564

Yet another elimination happened at the TV table. This time it was the formidable Feras Abid hitting the rail in 14th place for €4,500.

Player		Chips	Progress
Feras Abid		0	0

"I am the Best!" Posted Saturday 29th July, 2023 at 20:19(UTC+0) by Jason Glatzer

Level 24: 10,000/25,000 (25,000)
Entries: 14/564

Phil Gross (pictured below) defended his big blind from the under the gun open by Urmo Velvelt before he jammed the 145,000 in chips he had remaining on the flop. Velevelt quickly called and the cards were turned over with Gross at risk.

Phil Gross:
Urmo Velvelt:

Gross was grossly behind and that didn't change on the turn. However, the improved him to two pair to stay alive and double his stack.

"I am the best!" shouted an entertaining Gross at the table.

Velvelt appreciated the humor and was the first to laugh.

Player		Chips	Progress
Urmo Velvelt		1,300,000	65,000
Phil Gross		450,000	230,000

Two More Out at the TV Table Posted Saturday 29th July, 2023 at 20:12(UTC+0) by Jason Glatzer

Level 24: 10,000/25,000 (25,000)
Entries: 14/564

Table redraw or no table redraw, it seems fireworks are taking place once again at the TV table as we are down to just 14 hopefuls Karolis Kutkauskas (pictured below) and Siim Suviste (pictured below Kutkauskas) hit the rail.

Player		Chips	Progress
Siim Suviste		0	0
Karolis Kutkauskas		0	0

Two Table Seat Draw and Updated Chip Counts Posted Saturday 29th July, 2023 at 20:05(UTC+0) by Jason Glatzer

Table	Seat	Player	Country	Chips	Big Blinds
11	1	Anatoly Filatov	Estonia	1,070,000	43
11	2	Tapio Aaltonen	Finland	810,000	32
11	3	Phil Gross	Germany	680,000	27
11	4	Urmo Velvelt	Estonia	1,365,000	55
11	5	Tarmo Tammel	Estonia	320,000	13
11	6	Mikael Haapaniemi	Finland	2,780,000	111
11	7	Tomi Arponen	Finland	775,000	31
11	8	Feras Abid	Finland	335,000	13
18	1	Siim Suviste	Estonia	460,000	18
18	2	Juho Heiska	Finland	1,070,000	43
18	3	Ville-Matti Keränen	Finland	400,000	16
18	4	Karolis Kutkauskas	Lithuania	370,000	15
18	5	Ilya Nikiforov	Estonia	1,610,000	64
18	6	Nils Linden	Denmark	475,000	19
18	7	Kai Lehto	Finland	1,925,000	77
18	8	Magnus Pukk	Estonia	600,000	24

Rumba Dusts It Off to Laiho Posted Saturday 29th July, 2023 at 19:53(UTC+0) by Jason Glatzer

Level 24: 10,000/25,000 (25,000)
Entries: 16/564

The clock has stopped as the action is down to just two tables. There will be a redraw after Roberts Rumba dusted off his small stack with ace-trey to Kai Lehto's nine-seven after a seven hit the turn.

The final 16 players locked up at least €4,500 and the plan of the day is for players to bag up their stacks when the final table of nine players were reached.

Player		Chips	Progress
Kai Lehto		1,600,000	200,000
Roberts Rumba		0	0

Lehto Doubles Through Rumba Posted Saturday 29th July, 2023 at 19:50(UTC+0) by Jason Glatzer

Level 24: 10,000/25,000 (25,000)
Entries: 17/564

Kai Lehto three-bet jammed the button for 670,000 and was called by a frustrated Roberts Rumba from the big blind.

Kai Lehto:
Roberts Rumba:

It was a classic coin flip with Rumba pulling ahead after the flop and the turn. However, the spiked the river for Lehto to double his stack.

"Why is this always happening?" Rumba asked after losing yet another flip. 

Rumba did double up his crumbs a short while later when his ace-deuce was good against jack-four but this didn't add too much breathing room to his stack.

Meanwhile, mayhem must be taking place at the TV as both Vygerdas Jonikas and Vlads Dolgilevics hit the rail under the lights and camera.

Player		Chips	Progress
Kai Lehto		1,400,000	995,000
Roberts Rumba		120,000	380,000
Vygerdas Jonikas		0	0
Vlads Dolgilevics		0	0

GG Gordo Posted Saturday 29th July, 2023 at 19:32(UTC+0) by Jason Glatzer

Guillermo Gordo Cifuentes hit the rail at the TV table in 20th place for €3,900. You can check out the action at OlyBet.tv. 

Player		Chips	Progress
Guillermo Cifuentes		0	0

19:29 (UTC+0)

Start of Level 24
Blinds: 10,000/25,000     Ante: 25,000

Big Slick Good for Aaltonen Posted Saturday 29th July, 2023 at 19:29(UTC+0) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 20/564

It was a blind-on-blind battle between Roberts Rumba and Tapio Aaltonen with Altonen getting his 470,000 stack in the middle from the big blind and getting called by Rumba.

Tapio Aaltonen:
Roberts Rumba:

Both players had premium cards in a cooler of a hand for Rumba. Aaltonen doubled his stack after the dry board kept ace-king ahead of ace-queen.

Player		Chips	Progress
Tapio Aaltonen		960,000	505,000
Roberts Rumba		500,000	395,000

Pihela Jr. Runs Into a Flush Posted Saturday 29th July, 2023 at 19:16(UTC+0) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 20/564

Igor Pihela Jr. just hit the rail around the same time Tomi Arponen doubled through Siim Suviste. The table shared that he min-raised with ace-jack. Flopped top pair but ran into a flush held by the player in the big blind.

Player		Chips	Progress
Igor Pihela Jr.		0	0

Cowboys for Arponen Posted Saturday 29th July, 2023 at 19:12(UTC+0) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 21/564

Siim Suveste min-raised from early position. Tomi Arponen (pictured below) three-bet the button to 130,000. Suveste ripped it in with a four-bet that covered the 630,000 Arponen had in his stack. Arponen called to create a pot north of 1 million in chips with Arponen at risk.

Tomi Arponen:  
Siim Suveste: .

Suveste improved to top pair on the flop but Arponen had that dominated with a set of cowboys. Arponen still had a sweat with a ten to Broadway for Silveste along with some backdoor outs. But the turn and river were drama free for Arponen to take a huge chunk from Suveste's stack.

Player		Chips	Progress
Tomi Arponen		1,300,000	400,000
Siim Suviste		250,000	650,000

A No Look Big Slick No Good for Penning Posted Saturday 29th July, 2023 at 18:42(UTC+0) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 21/564

Nick Penning (pictured below) came back from dinner break with just half a big blind. He folded a few hands until he tossed it in blind from under the gun.

Tapio Altonen limped from the small blind and Siim Suviste checked back his option from the big blind.

Tapio check-folded facing a bet of 25,000 from Suviste after the landed on the flop and the cards were turned over.

Nick Penning:
Siim Suviste:

Penning was shocked at what he turned over but he was behind the two pair held by Suviste. Neither the turn nor the river helped start a Cinderella story for Penning and the tournament was down to 21 players.

Player		Chips	Progress
Siim Suviste		900,000	145,000
Nick Penning		0	0

Olop Loses Two Flips Posted Saturday 29th July, 2023 at 18:35(UTC+0) by Jason Glatzer

Level 23: 10,000/20,000 (20,000)
Entries: 22/564

Herli Olop had an amazing run. But sometimes, good things must come to an end. Olop lost most of his 210,000 stack to Feras Abid after his eights were unable to win a flip against king-jack. Soon after, he lost the rest on another flip with sevens against Tomi Arponen's queen-jack.

Player		Chips	Progress
Tomi Arponen		900,000	25,000
Feras Abid		280,000	150,000
Herli Olop		0	0

18:23 (UTC+0)

Start of Level 23
Blinds: 10,000/20,000     Ante: 20,000

Updated Chip Counts at Dinner Break of Final 23 Players Posted Saturday 29th July, 2023 at 18:13(UTC+0) by Jason Glatzer

Place	Name	Chips	Big Blinds
1	Mikael Haapaniemi	2,405,000	120
2	Urmo Velvelt	1,365,000	68
3	Ilya Nikiforov	1,160,000	58
4	Magnus Pukk	960,000	48
5	Roberts Rumba	895,000	45
6	Tomi Arponen	875,000	44
7	Siim Suviste	755,000	38
8	Vygerdas Jonikas	690,000	35
9	Phil Gross	680,000	34
10	Vlads Dolgilevics	674,000	34
11	Nils Linden	595,000	30
12	Juho Heiska	575,000	29
13	Ville-Matti Keranen	478,000	24
14	Tapio Aaltonen	455,000	23
15	Kai Lehto	405,000	20
16	Guillermo Cifuentes	352,000	18
17	Igor Pihela Jr.	330,000	17
18	Karolis Kutkauskas	326,000	16
19	Anatoly Filatov	213,000	11
20	Herli Olop	210,000	11
21	Tarmo Tammel	170,000	9
22	Feras Abid	130,000	7
23	Nick Penning	10,000	1

Dinner Break Posted Saturday 29th July, 2023 at 17:17(UTC+0) by Jason Glatzer

Players are on a one-hour dinner break. We will update the full chip counts during the second half of the break. Bon appétit!

"You Can Watch it on TV Later" Posted Saturday 29th July, 2023 at 16:38(UTC+0) by Jason Glatzer

Level 22: 10,000/15,000 (15,000)
Entries: 23/564

Phil Gross three-bet from the small blind preflop to bring the pot close to 200,000 after Mikael Haapaniemi called from the button.

Gross was quietly speaking in a whisper to Haapaniemi throughout the hand including after he continued for 100,000 on the flop. Haapaniemi called and Gross jammed the turn for 318,000.

Haapaniemi went into the tank and asked for a count. He appeared to be in pain about what to do and checked his cards more than once while also occasionally responding to the small talk by Gross.

Eventually, Haapaniemi folded and asked Gross if he'd show his hand.

"You can watch it on TV later," joked Gross as he was on the feature table earlier today.

A few seconds later, Gross showed his for an overpair to the board as the dealer began pushing the pot to him.

Meanwhile, Hendrik Diegenant hit the rail shortly before this hand in 24th place.

Player		Chips	Progress
Mikael Haapaniemi		1,325,000	52,000
Phil Gross		810,000	404,000

Players Cashing for €3,300 Posted Saturday 29th July, 2023 at 16:09(UTC+0) by Jason Glatzer

Place	Player	Prize
25	Touko Berndtson	€3,300
26	Patrick Schantz	€3,300
27	Kristian Larsson	€3,300
28	Anna-Mari Hursti	€3,300
29	Joonas Helin	€3,300
30	Edgars Beizaks	€3,300
31	Jari Saviaho	€3,300
32	Stefan Bittger	€3,300

Pihela Jr. Ousts Berndtson Posted Saturday 29th July, 2023 at 16:06(UTC+0) by Jason Glatzer

Level 22: 10,000/15,000 (15,000)
Entries: 24/564

Touko Berndtson (pictured below) jammed the button for about five big blinds and was called by Igor Pihela Jr. from the big blind.

Touko Berndtson:
Igor Pihela Jr.:

The flop improved Berndston to a pair but it wasn't as big of a pair as his opponent's paired-up jack. Neither the turn nor the river were cards Berndtson wanted to see and there will be a three-table redraw for the remaining 24 players after he hit the rail.

The action is resuming very soon and we will wait until the upcoming dinner break after this blind level to update the full chip counts of all remaining players.

Player		Chips	Progress
Igor Pihela Jr.		980,000	300,000
Touko Berndtson		0	0

15:55 (UTC+0)

Start of Level 22
Blinds: 10,000/15,000     Ante: 15,000

Slow Blind Level Posted Saturday 29th July, 2023 at 15:54(UTC+0) by Jason Glatzer

Level 21: 7,000/14,000 (14,000)
Entries: 25/564

As is the case in most well-structured tournaments, there becomes a time when the action slows down before it heats up again.

After a flurry of eliminations, the action was slow most of Level 21. Patrick Schratz (pictured below) was one of two players to hit the rail during the level. 

There will be a table redraw after we lose one more unfortunately sole from the Main Event.

Larsson Dusts Off His Short Stack Posted Saturday 29th July, 2023 at 15:21(UTC+0) by Jason Glatzer

Level 21: 7,000/14,000 (14,000)
Entries: 26/564

Kristian Larsson (pictured below) was all-in from the big blind when Touko Berndtson limped from late position and Igor Pihela Jr. limped from the small blind to see the flop.

Pihela Jr. check-called a min-bet of 140,000 by Berndstson before both players checked the turn.

The river completed the board. Pihela Jr. checked again. Berndston fired out for 55,000 and Pihela's cards went into the muck nearly as fast as Berndston chips went into the pot.

Larsson turned over the which didn't get the job done against Berndtson's . Meanwhile, Anna-Mari Hursti just hit the rail right before this hand. She was not only the last woman standing in the Main Event, but also the €555 Championship.

Player		Chips	Progress
Igor Pihela Jr.		680,000	495,000
Touko Berndtson		400,000	162,000
Kristian Larsson		0	0
Anna-Mari Hursti		0	0

15:01 (UTC+0)

Start of Level 21
Blinds: 7,000/14,000     Ante: 14,000

Big Stacks at Break Posted Saturday 29th July, 2023 at 15:01(UTC+0) by Jason Glatzer

Player		Chips	Progress
Siim Suviste		1,680,000	280,000
Juho Heiska		1,357,000	627,000
Mikael Haapaniemi		1,273,000	313,000
Vlads Dolgilevics		1,250,000	540,000
Urmo Velvelt		1,000,000	749,000
Karolis Kutkauskas		800,000	150,000

Beizaks Runs Into Suviste's One Outer Posted Saturday 29th July, 2023 at 14:40(UTC+0) by Jason Glatzer

Level 20: 6,000/12,000 (12,000)
Entries: 29/564

Jari Saviaho three-bet jammed for 250,000 from the button and was called by Siim Suviste from the small blind before Edgars Beizaks (pictured below), who originally opened, four-bet shoved for 450,000. Suviste asked for a count and about 30 seconds later found a call.

Jari Saviaho:
Edgars Beizaks:
Siim Suviste:

"Oh nice," Saviaho said about his ace being live. "Ace!"

While Saviaho needed some help it seemed like a dream spot for Beizaks as even if the ace came Silveste had only one out for a set. So, it seemed at least the side pot was in Beizaks' pocket. Dreams were shattered for Beizaks, but he took it well, after the case jack popped up on the board for Suviste to send Saviaho and Beizaks to the rail while likely taking the chip lead.

Players went on break shortly after this hand. We will update some of the top stacks from around the room during the break.

Player		Chips	Progress
Siim Suviste		1,400,000	1,012,000
Jari Saviaho		0	0
Edgars Beizaks		0	0

Players Cashing for €3,000 Posted Saturday 29th July, 2023 at 14:21(UTC+0) by Jason Glatzer

The following players including the start-of-the-day chip leader Juan Carlos Vecino Duenas (pictured above).

Place	Player	Prize
33	Lukas Rutkauskas	€3,000
34	Yanis Sahli	€3,000
35	James Noonan	€3,000
36	Aleksi Naski	€3,000
37	Christian Steinbo	€3,000
38	Jaana Kindsigo	€3,000
39	Juan Carlos Vecino Duenas	€3,000
40	Samuli Hietala	€3,000

Player		Chips	Progress
Samuli Hietala		0	0
Juan Carlos Vecino Duenas		0	0
Jaana Kindsigo		0	0
Christian Steinbo		0	0
Aleksi Naski		0	0
James Noonan		0	0
Yanis Sahli		0	0
Lukas Rutkauskas		0	0

13:44 (UTC+0)

Start of Level 20
Blinds: 6,000/12,000     Ante: 12,000

Full House Not Strong Enough for Noonan Posted Saturday 29th July, 2023 at 13:44(UTC+0) by Jason Glatzer

Level 19: 5,000/10,000 (10,000)
Entries: 40/564

There was a 700,000 pot with the chips getting in on the river with the on the board. James Noonan turned over the for a full house. 

He was on the losing end of the pot as Kristian Larsson (pictured below) turned over for a better full house to earn a full double-up.

Player		Chips	Progress
Kristian Larsson		700,000	434,000
James Noonan		190,000	192,000
Igor Pihela Jr.		185,000	15,000

Players Cashing for €2,700 Posted Saturday 29th July, 2023 at 13:39(UTC+0) by Jason Glatzer

Place	Player	Prize
41	Daniel Jullumstro	€2,700
42	Jordi Baixas	€2,700
43	Hein Haraldsen	€2,700
44	Kasper Mellanen	€2,700
45	Matias Arosuo	€2,700
46	Andrei Mjagkov	€2,700
47	Mauri Dorbek	€2,700
48	Dmitrijs Kornevs	€2,700

Player		Chips	Progress
Andrei Mjagkov		0	0
Matias Arosuo		0	0
Kasper Mellanen		0	0
Hein Haraldsen		0	0
Jordi Baixas		0	0
Daniel Jullumstro		0	0

Dorbek Done Multi-Tabling Posted Saturday 29th July, 2023 at 13:01(UTC+0) by Jason Glatzer

Level 19: 5,000/10,000 (10,000)
Entries: 46/564

Mauri Dorbek was running back and forth between the €150 GGPoker Flip&Go Mystery Bounty and the Main Event. Although he likely would have wished to continue this pattern, he will now be able to focus solely on the Mystery Bounty where he has some chips after losing his short stack in the Main Event.

Dorbek jammed for 45,000 from middle position and was called by Roberts Rumba.

Mauri Dorbek:
Roberts Rumba:

Dorbek stood up and looked ready to run as soon as he saw how dominating his opponent's hand was. He stuck around to watch both the flop and the turn as he was drawing eight outs to a chop. The river paired the board and Dorbek hit the rail in 47th place. We wish him the best of luck in the Mystery Bounty!

Player		Chips	Progress
Roberts Rumba		325,000	45,000
Dmitrijs Kornevs		0	0
Mauri Dorbek		0	0

Big Stacks at Break Posted Saturday 29th July, 2023 at 12:42(UTC+0) by Jason Glatzer

Player		Chips	Progress
Juan Carlos Vecino Duenas		920,000	211,000
Anatoly Filatov		750,000	50,000
Juho Heiska		730,000	290,000
Nils Linden		700,000	0
Karolis Kutkauskas		650,000	0
Jordi Baixas		610,000	438,000
Anna-Mari Hursti		555,000	335,000
Magnus Pukk		512,000	191,000

12:38 (UTC+0)

Start of Level 19
Blinds: 5,000/10,000     Ante: 10,000

First Break Posted Saturday 29th July, 2023 at 12:23(UTC+0) by Jason Glatzer

Players are on their first break of Day 3. Blinds will increase to 5,000/10,000 with a 10,000 big blind ante when the action resumes.

Player		Chips	Progress
Anatoly Filatov		750,000	430,000
Nils Linden		700,000	142,000
Karolis Kutkauskas		650,000	324,000

Players Cashing for €2,400 Posted Saturday 29th July, 2023 at 12:17(UTC+0) by Jason Glatzer

Place	Player	Prize
49	Keito Kaljulaid	€2,400
50	Ranno Sootla	€2,400
51	Anders Auset	€2,400
52	Tero Kilkanen	€2,400
53	Henri Schalin	€2,400
54	Kasparas Klezys	€2,400
55	Maksim Rusinov	€2,400
56	Kaspar Laursoo	€2,400

Player		Chips	Progress
Keito Kaljulaid		0	0

Rumba Rivers Broadway Posted Saturday 29th July, 2023 at 12:14(UTC+0) by Jason Glatzer

Level 18: 4,000/8,000 (8,000)
Entries: 49/564

Roberts Rumba four-bet jammed for 178,000 from the hijack and was called by Ilya Nikiforov from the button.

Roberts Rumba:
Ilya Nikiforov:

It wasn't looking great for Rumba although oddly enough he gained some outs despite a king hitting the flop on the flop as now he had four jacks to draw to instead of three queens.

The turn didn't create any drama. However, Rumba shouted "yes" in delight after the river completed his Broadway draw to double his stack instead of hitting the rail.

Player		Chips	Progress
Roberts Rumba		370,000	292,000
Ilya Nikiforov		300,000	42,000
Maksim Rusinov		0	0
Kasparas Klezys		0	0
Henri Schalin		0	0
Tero Kilkanen		0	0
Anders Auset		0	0
Ranno Sootla		0	0

Payouts for €2,200 Posted Saturday 29th July, 2023 at 11:29(UTC+0) by Jason Glatzer

The following players including Harri Seppa (pictured above) banked €2,200 in the Main Event with the remaining field locking up at least a €2,400 payout.

Place	Player	Prize
57	Kaido Mikk	€2,200
58	Kristaps Deksnis	€2,200
59	Harri Seppa	€2,200
60	Espen Sandvik	€2,200
61	Luis Cruz	€2,200
62	Sebastian Van Wonterghem	€2,200
63	Ramunas Mika	€2,200
64	Grantas Naujokas	€2,200

11:24 (UTC+0)

Start of Level 18
Blinds: 4,000/8,000     Ante: 8,000

Filatov Calls With a "Very Bad Hand" to Eliminate Laursoo Posted Saturday 29th July, 2023 at 11:23(UTC+0) by Jason Glatzer

Level 18: 4,000/8,000 (8,000)
Entries: 56/564

Kaspar Laursoo (pictured below) four-bet jammed from the small blind. One player folded before GGPoker Ambassador Anatoly Filatov appeared to get his hand caught in the cookie jar.

"I have a very bad hand," Filatov said.

A few players couldn't hold back their laugh and shortly after Filatov called.

Kaspar Laursoo:
Anatoly Filatov:

Laursoo was still ahead in the hand after the safe flop. However, he got out of his chair and began to gather his belongings after Filatov paired up on the turn. The river didn't get Laursoo back into the hand and he hit the rail early on Day 3.

Player		Chips	Progress
Anatoly Filatov		320,000	107,000
Harri Seppa		0	0
Kristaps Deksnis		0	0
Kaido Mikk		0	0
Kaspar Laursoo		0	0

Sandvik Loses a Flip & His Stack to Dolgilevics Posted Saturday 29th July, 2023 at 11:09(UTC+0) by Jason Glatzer

Level 17: 3,000/6,000 (6,000)
Entries: 59/564

Yesterday's start-of-the-day chip leader Vlads Dolgilevics (pictured below) opened from the cutoff and was called by Vygerdas Jonikas from the button. 

WSOP bracelet winner Espen Sandvik ripped it in for 25 big blinds. Dolgilevics called and Jonikas folded.

Espen Sandvik:
Vlads Dolgilevics:

Dolgilevics won the flip after his queen found a friend on the board to eliminate the formidable Sandvik.

It is also time to say goodbye to Sandvik as after the hand he shared he will be leaving today to spend time with some of his family in Norway. As always, it was a pleasure to watch you compete throughout the week and we hope to see you at the WSOP Circuit Tallinn on Sept. 14-24.

Player		Chips	Progress
Vlads Dolgilevics		710,000	36,000
Ramunas Mika		0	0
Sebastian Van Wonterghem		0	0
Luis Cruz		0	0
Espen Sandvik		0	0

Min-Cash Club Posted Saturday 29th July, 2023 at 10:45(UTC+0) by Jason Glatzer

The following players (including Jargo Alavali pictured below) min-cashed the Main Event for €2,000. The remaining 64 players each locked up at least €2,200 with many more pay jumps to come.

Place	Player	Prize
65	Matias Kesanen	€ 2,000
66	Jargo Alavali	€ 2,000
67	Konstantin Ärber	€ 2,000
68	Kalle Parkkinen	€ 2,000
79	Martin Piik	€ 2,000
70	Julian Herold	€ 2,000
71	Hyunsil Park	€ 2,000

Naujokas Loses His Short Stack to Dorbek Posted Saturday 29th July, 2023 at 10:39(UTC+0) by Jason Glatzer

Level 17: 3,000/6,000 (6,000)
Entries: 64/564

Grantas Naujokas jammed his short stack of 13,000 from the button. Mauri Dorbek (pictured below) three-bet to 40,000 from the small blind and it was a heads-up showdown with Naujokas at risk after Maksim Rusinov folded from the big blind.

Grantas Naujokas:
Mauri Dorbek:

Naujokas bricked the board to lose his short stack to Dorbek.

"Good game," Naujokas said with a smile showing good sportsmanship.

Meanwhile, Matias Kesanen, poker streamer Jargo Alavali, Konstantin Arber, Kalle Parkkinen, and Martin Piik all recently hit the rail.

Player		Chips	Progress
Mikael Haapaniemi		530,000	6,000
Mauri Dorbek		500,000	30,000
Konstantin Arber		0	0
Kalle Parkkinen		0	0
Jargo Alavali		0	0
Martin Piik		0	0
Matias Kesanen		0	0
Grantas Naujokas		0	0

Only Quads for Van Wonterghem Posted Saturday 29th July, 2023 at 10:21(UTC+0) by Jason Glatzer

Level 16: 2,000/5,000 (5,000)
Entries: 69/564

Sebastian Van Wonterghem open-jammed for 59,000 from middle position and was looked up by Matias Kesanen.

Sebastian Van Wonterghem:
Matias Kesanen:

While it was a coin flip when the chips went in, the board gave Van Wonterghem a hand to remember as he improved to quad sevens.

"Only quads," Edgars Beizaks said.

Meanwhile, Julian Herold and Hyunsil Park were the first two players to hit the rail on Day 3.

While we didn't witness Beizaks' "epic hand" he shared he had a big hand to start the day.

"I got a walk the very first hand," Beizaks said with a smile.

Player		Chips	Progress
Sebastian Van Wonterghem		130,000	69,000
Matias Kesanen		65,000	71,000
Julian Herold		0	0
Hyunsil Park		0	0

Action Begins Posted Saturday 29th July, 2023 at 10:09(UTC+0) by Jason Glatzer

Level 16: 2,000/5,000 (5,000)
Entries: 71/564

The action has kicked off for Day 3 with just a few minutes remaining in Level 16. The big blind stacks listed in the seat draw are based on Level 17 as Level 16 will be history very soon.

Best of luck to all of the remaining Main Event players. The t.v. table began from the beginning. We will not report off the t.v. table today but you can check out the action at the OlyBet.tv website on a 30-minute delay with Andreas Hoglund hosting the action.

Juan Carlos Vecino Duenas Leads Main Event Posted Saturday 29th July, 2023 at 08:49(UTC+0) by Jason Glatzer

Juan Carlos Vecino Duenas (pictured above) is among the Spanish poker community that has lived in the Estonian capital of Tallinn for a number of years. The pressure is on, as Duenas comes into the penultimate day of the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event with a chip-leading stack of 709,000 good for 118 big blinds when the action resumes. Duenas is closely followed by the start of Day 2 chip leader Vlads Dolgilevics (674,000) with Nils Linden (558,000) and Mikael Haapaniemi (536,000) also more than halfway to becoming chip millionaires.

The Day 2 action ended with the final 71 players in the money for at least a €2,000 min-cash. However, today players will be moving up the payout ladder until eventually on Sunday the last player standing will win the €108,260 top prize. You can check out the full payouts by clicking on the Payouts tab within our coverage.

Blinds will begin at 3,000/6,000 along with a 6,000 big blind ante and increase every hour. The day's plan is to play down to a final table of nine players but it is possible that the day will end sooner depending on the pace of play.

The microphone was carefully stored away and the pen and pad you are used to are back with Jason Glatzer resuming the live reporting duties the rest of the way. The Day 3 action kicks off at noon on Saturday and we will be right along with you reporting many of the biggest hands, bad beats, and, of course, every payout ladder. As if this isn't all, there will be a televised feature table from the start of the day which you can view at olybet.tv and on a variety of Facebook channels.

Best of luck to all of the players!

Day 3 Seat Draw Posted Saturday 29th July, 2023 at 08:35(UTC+0) by Jason Glatzer

Table	Seat	Player	Chips	Big Blinds
11	1	Ville-Matti Keranen	478,000	80
11	2	Samuli Hietala	137,000	23
11	3	Konstantin Arber	320,000	53
11	4	Tomi Arponen	422,000	70
11	5	Martin Piik	12,000	2
11	6	Phil Gross	406,000	68
11	7	Kaido Mikk	126,000	21
11	8	Luis Cruz	114,000	19
12	1	Touko Berndtson	238,000	40
12	2	James Noonan	382,000	64
12	3	Igor Pihela Jr.	170,000	28
12	4	Kristian Larsson	266,000	44
12	5	Jari Saviaho	238,000	40
12	6	Henri Schalin	183,000	31
12	7	Christian Steinbo	233,000	39
12	8	Tarmo Tammel	170,000	28
13	1	Daniel Jullumstro	191,000	32
13	2	Stefan Bittger	136,000	23
13	3	Ranno Sootla	112,000	19
13	4	Kalle Parkkinen	53,000	9
13	5	Maksim Rusinov	39,000	7
13	6	Juho Heiska	440,000	73
13	7	Matias Arosuo	287,000	48
13	8	Aleksi Naski	182,000	30
14	1	Kai Lehto	405,000	68
14	2	Espen Sandvik	180,000	30
14	3	Grantas Naujokas	33,000	6
14	4	Mauri Kristjan Dorbek	470,000	78
14	5	Urmo Velvelt	251,000	42
14	6	Yanis Sahli	457,000	76
14	7	Vlads Dolgilevics	674,000	112
14	8	Siim Suviste	388,000	65
15	1	Matias Kesanen	136,000	23
15	2	Magnus Pukk	321,000	54
15	3	Hendrik Diegenant	405,000	68
15	4	Edgars Beizaks	134,000	22
15	5	Roberts Rumba	78,000	13
15	6	Ramunas Mika	51,000	9
15	7	Sebastian Van Wonterghem	61,000	10
15	8	Hein Haraldsen	155,000	26
18	1	Patrick Schratz	94,000	16
18	2	Ilya Nikiforov	258,000	43
18	3	Joonas Helin	84,000	14
18	4	Anders Auset	172,000	29
18	5	Kasper Mellanen	379,000	63
18	6	Tapio Aaltonen	492,000	82
18	7	Nils Linden	558,000	93
18	8	Kristaps Deksnis	211,000	35
19	1	Juan Carlos Vecino Duenas	709,000	118
19	2	Vygerdas Jonikas	164,000	27
19	3	Anatoly Filatov	213,000	36
19	4	Jordi Baixas	172,000	29
19	5	Keito Kaljulaid	307,000	51
19	6	Kaspar Laursoo	189,000	32
19	7	Guillermo Cifuentes	352,000	59
19	8	Jargo Alavali	139,000	23
20	1	Andrei Mjagkov	89,000	15
20	2	Dmitrijs Kornevs	352,000	59
20	3	Herli Olop	221,000	37
20	4	Feras Abid	285,000	48
20	5	Lukas Rutkauskas	192,000	32
20	6	Kasparas Klezys	168,000	28
20	7	Anna-Mari Hursti	220,000	37
20	8	Tero Kilkanen	144,000	24
21	1	Mikael Haapaniemi	536,000	89
21	2	Julian Herold	28,000	5
21	3	Jaana Kindsigo	132,000	22
21	4	Karolis Kutkauskas	326,000	54
21	5	Hyunsil Park	58,000	10
21	6	Harri Seppa	295,000	49
21	7	Nick Penning	314,000	52

08:34 (UTC+0)

Day 3 of Kings of Tallinn Summer Showdown 2023 Started
Level: 17     Blinds: 3,000/6,000     Ante: 6,000

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter