0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_est_2023/2/updates'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/summer_showdown_main_est_2023/2/updates', 1, '2024-11-25')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0039 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

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

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

0.0279 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '82'
AND `published` = 1

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

0.0276 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0055 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '87'
AND `published` = 1

0.0278 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0058 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '91'
AND `published` = 1

0.0287 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0066 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '93'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'
AND `name` = '2'

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

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

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` = '4024'
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` = '4013'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

0.0089 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3996'
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` = '3994'
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` = '3992'
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` = '3986'
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` = '3985'
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` = '3981'
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` = '3977'
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` = '3975'
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` = '3973'
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` = '3966'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0086 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3963'
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` = '3961'
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` = '3959'
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` = '3955'
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` = '3953'
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` = '3952'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

0.0074 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3929'
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` = '3921'
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` = '3918'
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` = '3916'
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` = '3914'
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` = '3913'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0277 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3902'
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` = '3900'
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` = '3898'
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` = '3897'
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` = '3896'
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` = '3895'
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` = '3890'
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` = '3889'
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` = '3888'
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` = '3887'
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` = '3886'
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` = '3885'
ORDER BY `chip_change` DESC, `busted` ASC

0.0273 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3884'
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` = '3883'
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` = '3882'
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` = '3881'
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` = '3880'
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` = '3877'
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` = '3874'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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` = '4024'
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` = '4013'
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` = '4011'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

0.0086 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3963'
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` = '3961'
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` = '3959'
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` = '3955'
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` = '3953'
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` = '3952'
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` = '3948'
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` = '3947'
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` = '3946'
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` = '3943'
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` = '3940'
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` = '3936'
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` = '3934'
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` = '3932'
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` = '3929'
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` = '3921'
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` = '3918'
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` = '3916'
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` = '3914'
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` = '3913'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0119 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3902'
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` = '3900'
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` = '3898'
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` = '3897'
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` = '3896'
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` = '3895'
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` = '3890'
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` = '3889'
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` = '3888'
ORDER BY `chip_change` DESC, `busted` ASC

0.0087 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3887'
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` = '3886'
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` = '3885'
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` = '3884'
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` = '3883'
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` = '3882'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '93'
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(0)
  • APAT(2)
  • APPT(0)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(0)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(2)
  • EPT(4)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(5)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(10)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • 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(12)
  • 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 Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(0)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(2)
  • Women's Winter Festival(0)
  • WPT(4)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(16)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• 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 (Estonian) Live Reporting - Day 4

Kings of Tallinn Summer Showdown 2023 - Live Reporting

2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 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 32 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 E. J. Lehto

17,000,000

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

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 2

Žetoonide seis teise päeva järel Posted Friday 28th July, 2023 at 20:19(UTC+0) by maheaaatom

Viis suurimat stäkki kuuluvad väliskülalistele, eestlasi on mängus 16.

TOP5:

Juan Carlos Vecino Duenas, 709000
Vlads Dolgilevics, 674000
Nils Jakob Elias Linden, 558000
Mikael Johannes Haapaniemi, 536000
Tapio Ilmari Aaltonen, 492000

Eestlased:
Mauri Dorbek, 470000
Siim Suviste, 388000
Magnus Pukk, 321000
Keito Kaljulaid, 307000
Ilya Nikiforov, 258000
Urmo Velvelt, 251000
Herli Olop, 221000
Kaspar Laursoo, 189000
Igor Pihela noorem, 170000
Tarmo Tammel, 170000
Jargo Alaväli, 139000
Jaana Kindsigo, 132000
Kaido Mikk, 126000
Ranno Sootla, 112000
Andrei Mjagkov, 89000
Martin Piik, 12000

Teine päev otsustati lõpetada Posted Friday 28th July, 2023 at 19:13(UTC+0) by maheaaatom

Kuigi teise päeva lõpuni peaks kella järgi jääma veel 13 minutit, otsustas turniiridirektor mängu tänaseks lõpetada.

Chipid aetakse kottidesse ning kõik mängijad naasevad laudadesse juba homme keskpäeval. Avaldame täpse chippide seisu lähema tunni jooksul. 

Mull lõhkes kiiremini kui keegi uskudagi oskas Posted Friday 28th July, 2023 at 19:10(UTC+0) by maheaaatom

Mauri-laua shorstack läheb buttonilt all-in ning Mauri teeb any2 calli. 

Shortstackil on , Mauril . Lauda ärtu mast. Mull ei lõhke.

Aga juba järgmise jaotusega kukub äkitselt mängust välja kaks mängijat korraga ja mullimäng saabki täiesti ootamatu lõpu. Kõigile allesjäänutele on tagatud vähemalt 2000 eurot.  Palju õnne!

Pre-mull Posted Friday 28th July, 2023 at 19:04(UTC+0) by maheaaatom

73 mängijat on alles ning käimas pre-mull. See mäng on veninud juba päris pikale ning midagi olulist vahepeal toimunud pole. 

Väikesed stäkid hoiavad oma pisukesest küünte ja hammatega kinni, lootuses et suured vastamisi jooksevad. Ja suured omakorda loodavad, et väikesed lihtsalt kokku kuivavad või närvid kaotavad. Korra juhtus see isegi Andrei Mjagkoviga, kes oma 57K -ga sisse lükkas.

Call tuli Herli Olopi -lt, flopist sai Herli veel koguni Royali tõmbe. Andrei suureks õnneks siiski nii turn kui river plangud. Risky business.

Tempo on juba pikka aega täielikult maas.

Ranno saab oma ministacki duublisse Posted Friday 28th July, 2023 at 18:34(UTC+0) by maheaaatom

Rannol õnnestub duubeldada -ga vastu. "No mis te arvate, milline range mul hetkel on," naerab Ranno pärast kaartide avamist. Emandad peavad probleemideta vastu. Rannol umbes 85K, endiselt 75 mängijat järgi. 

Kõrvalturniiridelt Posted Friday 28th July, 2023 at 18:32(UTC+0) by maheaaatom

High-Rolleri hetkeseisust saate lugeda eraldi blogist, 150 € NLH-l on hiline registeerumine veel käimas ning hetkel tehtud 121 sisseostu, mida on isegi vähem kui võis oodata. Kuid mitmed tuntud seltskonnamängijad on kõigest hoolimata kohal.

5-Card Omaha on aga väga pop, sisseoste kogunes tervelt 192. 

18:19 (UTC+0)

Start of Level 16
Blinds: 2,000/5,000     Ante: 5,000

Eestlaste seisud Posted Friday 28th July, 2023 at 18:19(UTC+0) by maheaaatom

15. mängutaseme jooksul on suurem osa meie mängijatest pigem ära andnud ning ühtegi väga suurt stäkki enam eestlastel ei ole. Ka Mauri loovutas umbes 100K ühele leedukale, kuid tal on endiselt 400K järgi.

Samuti on igati korralik ühes lauas istuvate Siim Suviste ja Keito Kaljulaiu olukord, mõlemal umbes 360K.

Üsna korraliku stäkiga läks telelauda ka Igor Pihela.

Kokku peaks mängus olema 17 eestlast. 

Player		Chips	Progress
Mauri Dorbek		400,000	205,000
Siim Suviste		360,000	286,000
Keito Kaljulaid		360,000	91,000
Magnus Pukk		310,000	50,000
Herli Olop		295,000	5,000
Kaspar Laursoo		220,000	80,000
Urmo Velvelt		210,000	10,000
Ilya Nikiforov		180,000	83,100
Jaana Kindsigo		180,000	65,000
Jargo Alaväli		180,000	60,000
Tarmo Tammel		170,000	40,000
Kaido Mikk		140,000	96,500
Ranno Sootla		75,000	5,000

Magnus annab väikese duubli Posted Friday 28th July, 2023 at 18:01(UTC+0) by maheaaatom

Magnus ründab blinde ning saab vastu 35K all-in panuse soomlaselt Joonas Helin'ilt.

Magnus avab , Joonasel on . Flopis on küll kaheksa, kuid ka kolm potit. Ja neljas poti on ka turnis. River Magnusele maja või nelikut ei too.

Herli-Mauri-Andrei lauas hoiab ohje esimene. Ta on teinud mitu tõste ja ületõstet ning respecti on piisavalt, et callijaid pole leidunud. Senistel Summer Showdown turniiridel erakordselt halba jooksu kogenud Herli on täna sõiduvees ning puudu ei tule ka enesekindlusest.

Kas Andrei "istub" ära? Posted Friday 28th July, 2023 at 17:52(UTC+0) by maheaaatom

Herli ja Mauri lauas istub väikese, umbes 50K (12X BB) stackiga Andrei Mjagkov. Andrei on suurepärane shortstack mängija, kel on lausa erakordne oskus pea alati ka rahadesse venitada.

Nüüd on rahadeni 8 kohta ning Andrei lootmas järjekordsele cashile.  Üsna samas seisus on Ranno Sootla, kes ajab küll lauakaaslastega elavalt juttu, kuid mängib sama rahulikult.

Mark kaotab nelikule Posted Friday 28th July, 2023 at 17:41(UTC+0) by maheaaatom

Mark Metsla võtab flipi Patrick Johann Schratzi vastu, kaalul on Margi turniirielu.

Mark:

Patrick:

Kohe flopis kaks kümmet! 

Väljas ka Georgi Abuladze ja Iver Rühka. Rahadeni on kõigest 10 kohta, mistõttu on ka mängutempo rahulikum kui enne. Küll mitte Mauri jaoks, kes oma lauakaaslastele raha ei anna.

Player		Chips	Progress
Ivar Rühka		0	0
Georgi Abuladze		0	0
Mark Metsla		0	0

Viimased kaks mängutaset Posted Friday 28th July, 2023 at 17:26(UTC+0) by maheaaatom

Mängijad on pausilt tagasi ning action läheb edasi.

Vaheajal tegime juttu Urmo Velveltiga, kes sai 14. tasemel olulist stäkilisa ning tõusis umbes 200K-le. Kas Urmot võiks isutada ka 5K High-Roller?

"Tase on seal muidugi väga tugev. Ottomar ja need Tartu poisid on väga head," kiidab Urmo, kes ka ise ülikõrges mängus sage külaline. Aga loomulikult kõlab mehe jutust vihje, et kõrges mängus osalemise peamine eeldus on ikkagi see, et seal leidub ka nõrgemaid mängijaid ning mida rohkem, seda parem.

Player		Chips	Progress
Urmo Velvelt		200,000	70,000

17:20 (UTC+0)

Start of Level 15
Blinds: 2,000/4,000     Ante: 4,000

Kaks 600K+ stäkki Posted Friday 28th July, 2023 at 16:57(UTC+0) by maheaaatom

Turniiril on kaks stäkki, mis isegi pisut suuremad 600 tuhandest. Neist ühe omanik on hispaanlane Juan Duenas, teine kuulub aga Markku kukutanud Vlads Dolgilevicsiusele. Eestlastest endiselt edukaim Mauri Dorbek.

Algas põhiturniiri teise päeva viimane paus.

"Sajaviiekümnesed" kogunevad Posted Friday 28th July, 2023 at 16:51(UTC+0) by maheaaatom

Juba umbes veerand tunni pärast algab Olympic Casinos tänane kolmas side-event, mis sobib hästi kõikidele hobimängijatele reedeõhtuseks meelelahutuseks. Sisseost on kõigest 150 eurot.

Mängusaalis "Las Vegas" toimuval 5-kaardi Omahal on hetkel 120 sisseostu ning omahatajatega on teiste seas liitunud ka high-roller Markku Koplimaa. See ei välista, et Markku liitub siiski ka (kas tänase või homse) high-rolleriga. 

Markku on öelnud, et turniiride valikul sõltub kõik enesetundest. Kui on õige olemine, siis pole ka 5K ja 10K turniirid tema jaoks erakordsed. Aga kui mitte, siis pole ka mingit vajadust vägisi pressima minna. Ja tuju on Markkul vaevalt suurem asi, sest põhiturniirilt langes ta välja ikka eriti valusa käega.

Ivar Rühka duubeldab Posted Friday 28th July, 2023 at 16:43(UTC+0) by maheaaatom

Shortstackiga (35K) Ivar Rühkal õnnestub oma -ga Mark Metslalt () duubel võtta. Margil on umbes 100K, nagu ka temaga samas lauas istuval Tarmo Tammelil.

Urmo Velvelt on oma seisu pisut parandanud ning tõusnud 130K peale. Magnus Pukil on selle laua suurim stäkk - umbes 360K. 

Kahjuks ka kaks langejat: Sten Talviste ja Ivar Vendelin. Konkurentsis 88 parimat.

Player		Chips	Progress
Magnus Pukk		360,000	110,000
Urmo Velvelt		130,000	75,000
Mark Metsla		100,000	20,000
Sten Talviste		0	0
Ivar Vendelin		0	0

Mauri võidab võimsa panga Posted Friday 28th July, 2023 at 16:35(UTC+0) by maheaaatom

Mauri Dorbeku 27K kolmpanuse järel vaadatakse koos Anders Christianseniga floppi . Taanlane checkib ette, Mauri paneb 16K ja saab calli.

Turn on . Taanlane checkib taas ette, Mauri paneb 38 500 ning umbes 150K stäkiga Christiansen vastab all-in'iga. Maurilt instacall.

Anders:

Mauri:

Rivermidagi ei muuda. 

"Ega ta ei saanudki sellest käest kuskile," arvas Mauri hiljem. Tema stäkk nüüd hiiglaslik 530K, mis peaks olema eestlastest suurim.

Player		Chips	Progress
Mauri Dorbek		530,000	335,000

Alla saja Posted Friday 28th July, 2023 at 16:13(UTC+0) by maheaaatom

Põhiturniiril on alles 99 parimat, seega pole rahakohad (71 parimat) enam üldsegi kaugel.

Eestlastel on kõik hästi, pärast Markku Koplimaa ülivalusat langemist pole pidanud ükski teine mängija turniirialalt lahkuma. Täna on mängida veel umbes 160 minutit.

Mauri purustas kaks vastast Posted Friday 28th July, 2023 at 16:11(UTC+0) by maheaaatom

Mauri võttis äsja ühe jaotusega välja kaks "turisti".

Üks shortstack pushis -ga, teine umbes 90K stäkiga mängija . Ja Mauril . Seekord oli laud just meie mehele armuline, tuues vajaliku poisi.

Mauril nüüd umbes 320K.

16:07 (UTC+0)

Start of Level 14
Blinds: 0/0     Ante: 0

"Pole see Herli midagi nii konservatiivne" Posted Friday 28th July, 2023 at 15:52(UTC+0) by maheaaatom

Nii kommenteerib Mauri Dorbek, kes näeb Herlit järjekordset kätt võitmas.

Herli läheb keskmiselt positsioonilt "röövima" ja saab buttoni kaasa. Flopis on , turnis . Mõlemal juhul panustab Herli ette (turnil koguni 15K) ja saab calli.

River on , mis checkitakse läbi. 

Herli võtab panga maha, vastane ei näita. Seitse aastat suurturniiri vesise suuga pealt vaatanud Herli on põhiturniiril selgelt sõiduvees ning tema stäkk hetkel juba ca. 300K.

Player		Chips	Progress
Herli Olop		300,000	40,000

Markku Koplimaa ülivalusa käega väljas Posted Friday 28th July, 2023 at 15:47(UTC+0) by maheaaatom

Markku Koplimaa avas 5K, teist päeva liidrina alustanud Vlads Dolgilevics vastas 16K ületõstega. Markku lisas veel 30K ning lätlane lükkas all-in. Markkult kiire call.

Vlads:

Markku:

Emand flopis. Kuigi Markkul oli enne saatuslikku kätt 200K stäkk, oli lätlase oma siiski suurem. Väga valus... 

Player		Chips	Progress
Markku Koplimaa		0	0

Magnus, Kaspar, Herli ja Igor liidrite seas Posted Friday 28th July, 2023 at 15:30(UTC+0) by maheaaatom

Loeme taas eestlaste stäkke. Pidevalt on oma punktisummat suurendanud Magnus Pukk, kel hetkel juba ca. 370K.

Kaspar on selgelt tõusnud (300K) ning ka Herli edeneb ilusti (260K). Umbes sama suur stäkk on ka Igor Pihelal. 

Player		Chips	Progress
Kaspar Laursoo		300,000	140,000
Herli Olop		260,000	110,000
Igor Pihela noorem		260,000	10,000
Jargo Alaväli		240,000	110,000
Markku Koplimaa		205,000	5,000
Mauri Dorbek		195,000	15,000
Andrei Mjagkov		180,000	70,000
Tarmo Tammel		130,000	30,000
Jaana Kindsigo		115,000	25,000
Ranno Sootla		70,000	20,000
Martin Piik		55,000	10,300
Urmo Velvelt		55,000	20,300

Jätame hüvasti... Posted Friday 28th July, 2023 at 15:19(UTC+0) by maheaaatom

...järgmiste põhiturniiril osalevate Eesti mängijatega

Player		Chips	Progress
Andres Aro		0	0
Aleksandr Kuperman		0	0
Priit Vanem		0	0

Peagi on algamas TV-laua ülekanne Posted Friday 28th July, 2023 at 15:17(UTC+0) by maheaaatom

Umbes kell 17:20 algab TV-laua ülekanne. Täna on plaanis vahendada nii põhiturniiril toimuvat kui ka 5K High-Rollerit. Esimesena on telepurgis põhiturniiri mängijad. Actionit jälgi siin: https://olybet.tv/kings-of-tallinn-summer-showdown-2023-2

Algas 13 mängutase ja viie-kaardi Omaha Posted Friday 28th July, 2023 at 15:01(UTC+0) by maheaaatom

Põhiturniir läheb edasi. Turniiri võitja teenib 108 260 eurot, viimane rahakoht saab täpselt kaks tuhat.

Ühtlasi algas ka tänane teine kõrvalturniir - 250 € PLO 5 Card. Viimast alustas 23 mängijat, nende seas ka mitmeid eestlasi.

14:58 (UTC+0)

Start of Level 13
Blinds: 1,000/3,000     Ante: 3,000

Teine paus Posted Friday 28th July, 2023 at 14:43(UTC+0) by maheaaatom

123 allesjäänud mängijat suundusid pausitama. Viimase käega kaotas päris piraka poti Jargo Alaväli, kes langes nüüd umbes 200K peale.

Teist päeva eestlastest suuruselt teise stäkiga alustanud Kaspar Laursoo on umbes samas seisus mis päeva alguses, võib-olla natuke isegi juurde saanud. Keskmine stäkk on hetkel umbes 55XBB.

Player		Chips	Progress
Jargo Alaväli		200,000	150,000

Õnn soosib Igorit Posted Friday 28th July, 2023 at 14:37(UTC+0) by maheaaatom

Igor Pihela on kogu teise päeva hästi mänginud ning oma chipikuhja vaikselt, kuid stabiilselt suurendanud.

Äsja õnnestus veel 60K juurde saada, seda küll üsna kummalise jaotuse võiduga. Nimelt olid nii temal kui Jari-Pekka Juholal pocket soldatid, kuid lauda pandi neli potit ning just Igoril oli poti poiss.

Samas lauas on ka Tarmo Tammel, kes alustas päeva väga pisikese stäkiga, kuid on nüüd juba umbes 100K peal, millega on parasjagu mänguruumi.

Player		Chips	Progress
Igor Pihela noorem		270,000	114,000
Tarmo Tammel		100,000	79,800

Jah - TA on kohal! Posted Friday 28th July, 2023 at 14:25(UTC+0) by maheaaatom

Vahemärkusena olgu öeldud, et Summer Showdownile on saabunud tõeline "küürvaal" Ottomar Ladva, kes võttis natuke aega tagasi istet seisusekohasel 5K High-Rolleril. 

Ja kangeid Eesti mehi on peale Ottomari teisigi. Tore on näha, et Eesti pokker on jõudnud tasemele, kus ülikõrgete sisseostudega turniirid osalemine on mitmete tippmängijate jaoks juba üsna tavaline ettevõtmine.

Eestlaste stäkke Posted Friday 28th July, 2023 at 14:19(UTC+0) by maheaaatom

Vahepealse ajaga on veelgi paranenud Herli seis, seevastu Jaana Kindsigo on pea poole oma stäkist ära andnud. Välja on langenud kaardi- ja stäkisurmas vaevelnud pokkeriproff Tõnis Viik.

Player		Chips	Progress
Magnus Pukk		250,000	40,000
Markku Koplimaa		210,000	49,500
Mauri Dorbek		180,000	30,000
Herli Olop		150,000	50,000
Andrei Mjagkov		110,000	56,600
Jaana Kindsigo		90,000	90,000
Mark Metsla		80,000	40,000

Ranno annab ära Posted Friday 28th July, 2023 at 14:16(UTC+0) by maheaaatom

Artjoms Hromovs ning Ranno Sootla mängivad (meeste stäkke arvestades) võrdlemisi suure panga.

Lauas on ning pangas umbes 30K. Pärast mastihõngulist riverit panustab esimesena juba lätlane, lükates keskele 15K. 

Ranno callib paraja äginaga ära. Vastane avab , mis tekitab pisut hämmeldust. River oli Rannole üsnagi saatanlik, sest tal käes . Rannol umbes 50 järgi.

Player		Chips	Progress
Ranno Sootla		50,000	50,000

Täna polnud Kaido päev Posted Friday 28th July, 2023 at 14:02(UTC+0) by maheaaatom

Kaido Koorits ei suutnud kahjuks oma stäkki üles saada ning on mängust väljas. Sama käib ka kahjuks Kaidar Viikmani, vanema Pihela, Mirza ja Mart Tammoja kohta.

Lisaks neile pidi lauast püsti tõusma ka tänavuse EMV põhiturniiri kolmas mees Andrey Koks. Jätkab 142 parimat. Täpselt pooled neist saavad raha.

Player		Chips	Progress
Kaido Koorits		0	0
Kaidar Viikman		0	0
Mart Tammoja		0	0
Igor Pihela		0	0
Andrey Koks		0	0

Kaidar ja Martin otsivad lükkekohta Posted Friday 28th July, 2023 at 13:41(UTC+0) by maheaaatom

Üsna pisikeste stäkkidega Martin Piik ja Kaidar Viikman otsivad oma lükkekohti, mõlemal on alla 20XBb stäkk. Kaidaril on kõige krooniks ka erakordselt keeruline laud. Tõsi, seal istuvad profid Tõnis Viik ja Urmo Velvelt pole ka just kuigi paremas seisus.

Kahjuks on ka mitmeid langejaid. Nii ei suutnud täna oma mängu kuidagi käima saada Oskar Ojaveer ning ka Ermo Kosk polnud oma paremate päevade tasemel. Samuti on väljas Stanislav Smeljov.

Player		Chips	Progress
Oskar Ojaveer		0	0
Stanislav Smeljov		0	0
Ermo Kosk		0	0

Paul flippas mööda Posted Friday 28th July, 2023 at 13:30(UTC+0) by maheaaatom

Kahjuks langes äsja veel üks Eesti mängija, kelleks osutus Paul Koppe.

Paul olla flipanud kümnetega vastu ning seda ebaõnnestunult. Vastane tabas nimelt kuningat. 

AMETLIK: Põhiturniiri auhinnafond on 530 160 eurot! Posted Friday 28th July, 2023 at 13:26(UTC+0) by maheaaatom

Summer Showdown põhiturniiril ületati senine osalejate arvu ja sisseostude rekord umbes kahekordselt ning mäng käib täpselt 530 160 eurole. Tegemist on kindla peale ühe suurima viimastel aastatel Eestis toimunud pokkeriturniiriga!

Sisseoste kogunes 564. Auhinnafond jaguneb 71 parima vahel, täpsed väljamaksed selguvad lähiajal.  

Vaalad on laudades Posted Friday 28th July, 2023 at 13:20(UTC+0) by maheaaatom

Alanud on 5000 € High-Roller. Esialgu küll vaid neli mängijat, kuid neid tuleb vaikselt juurde. Ja loodetavasti istub lauda ka üks pokkerikuulsus, keda just äsja näha võis. 

High-Roller turniirist valmib Mariliisi vahendusel samuti live-blogi, mida saab siinsamas OlyBet Events keskkonnas jälgida. 

Allan mängust väljas Posted Friday 28th July, 2023 at 13:16(UTC+0) by maheaaatom

Mitu jaotust järjest agressiivselt mänginud Allan Arjut avab 3,5K tõstega, Jargo Alaväli paneb 10K juurde ning Allan nüüd juba 35K. Enam pääsu pole, Jargo vastab all-in'iga ja saab calli (Allani stäkk umbes 95K).

Jargo:

Allan:

Ässa ei tule, Allanile otsekui mõnituseks riverisse veel üks kuningas. Jargo stäkk kena 350K.

Player		Chips	Progress
Jargo Alaväli		350,000	110,000
Allan Arjut		0	0

Kaido Koorits võidab endalegi ootamatult Posted Friday 28th July, 2023 at 13:13(UTC+0) by maheaaatom

Kaido Koorits mängib umbes 20K panga ning saab endalegi ootamatu võidu. 

Flopi järel checkib Vigerdas Jonikas, Kaido vajutab 6500 ja saab calli.

Turn ja river checkitakse läbi. Leedukas näitas ning Kaido saab panga -ga kätte. 

Allan duubeldab Posted Friday 28th July, 2023 at 13:00(UTC+0) by maheaaatom

Allan Arjutil õnnestub üks endaga sama suur (ehk siis tegelikult väga väike) stäkk välja võtta. 

Nupud läksid sisse pärast äss-high floppi, lauas kolm ristit. Allanil oli äss pihtas ja vastasel kuningas-kõrge mastitõmme.  Meie mehe õnneks turn ja river plangud.

Sõjavägi kohustab Posted Friday 28th July, 2023 at 12:48(UTC+0) by maheaaatom

Nii laulis JMKE 1989. aastal ning laulus kõlanud tõde peab paika ka 2023. aastal. 

Milles täpsemalt asi? Septembris toimuvad järjekordsed (massiivsed) kordusõppused, kuhu on kutsutud ka Eesti pokkerimängijaid. See aga tähendab, neil jääb esmakordselt Eestis toimuv WSOP Circuit kahjuks vahele. 

12:42 (UTC+0)

Start of Level 11
Blinds: 1,000/1,500     Ante: 1,500

Palju sagimist Posted Friday 28th July, 2023 at 12:16(UTC+0) by maheaaatom

Turniirialal käib kõva sebimine ja sagimine, sest mängitakse viimaseid pausieelseid jaotusi.

Üle saali kostab aina hüüe "Seat open!" Alanud 20-minutilise pausi jooksul saavad kõik, kel nööbid viimseni otsas, veel turniiriga liituda.

Oleme peagi tagasi.

Tõnis leiab ässad Posted Friday 28th July, 2023 at 12:00(UTC+0) by maheaaatom

Väga pisikese stäkiga mänginud pokkeriproff Tõnis Viik saab viimaks oodatud duubli pocket ässadega vastu. Nuppe peab loovutama Urmo Velvelt, kelle seis on ka kõike muud kui hea. 

Veel 10 minutit re-entry'te sooritamiseks, liiklus kassa vahel on vägagai aktiivne. 

Eestlaste stäkke Posted Friday 28th July, 2023 at 11:51(UTC+0) by maheaaatom

Üheksas ja kümnes mängutase on olnud selgelt edukad Jaana Kindsigole, kes on oma seisu kõvasti parandanud.

Ka Jargo Alaväli on saanud natuke juurde, seevastu Kaspar Laursoo jällegi omajagu loovutanud. 

Täna 30K lauda istunud meestest on Ranno Sootla selle juba umbes kolmekordistanud ning ka Allan Arjut on saanud pisut enam kui duubli.

Player		Chips	Progress
Jargo Alaväli		240,000	27,000
Jaana Kindsigo		180,000	104,100
Kaspar Laursoo		160,000	48,700
Igor Pihela noorem		156,000	6,900
Mark Metsla		120,000	14,500
Ranno Sootla		100,000	70,000
Paul Koppe		90,000	49,000
Allan Arjut		70,000	40,000

Pool miljonit täis! Posted Friday 28th July, 2023 at 11:39(UTC+0) by maheaaatom

Ootasime ja eeldasime, et põhiturniiri auhinnafond paisub poole miljoni euroseks ning täpselt nii on ka läinud. 

Hetkeseisuga on kirjas 532 sisseostu ning pool miljonit on koos!

Kümnenda taseme lõpuni on veel pool tundi ning tõenäoliselt tuleb sisseoste veel omajagu juurde. Keskmine stäkk on 81K ehk 57XBB.

Olukorrast proffide lauas Posted Friday 28th July, 2023 at 11:35(UTC+0) by maheaaatom

Seda lauda valitseb Magnus Pukk (ca. 220K), Markku Koplimaa ja Urmo Velvelt on suhteliselt samas seisus mis päeva alguses (vastavalt 160K ja 80K), Kaidar on natuke ära andnud ning ka Tõnis pole oma mängu õieti käima saanud.

Teises põnevas eestlaste lauas andis just Mauri ca. 50K ära ühele kolmiku flopanud väliskülalisele. Aga Mauri stäkk on endiselt vähemalt kahekordne keskmine, seega pole paanikaks mingit põhjust.

Re-entry sai muide kirja ka pokkerimiljonär Anatoly Filatov ning äsja liitus mänguga ka avapäevadel üsna halvasti jooksnud Eesti superäss Ranno Sootla.

Mauri korjab Herlilt tagasi Posted Friday 28th July, 2023 at 11:18(UTC+0) by maheaaatom

Taas on vastamisi samad mehed, lihtsalt jaotuse stsenaarium on täiesti vastupidine eelmisele.

Seekord läheb Herli Mauri blindi sööma ning viimane alla ei anna.

Enne floppi läheb sisse 2,5, flop checkitakse läbi.

Turni järel panustab juba Mauri 3,5 ning jätkab seda ka pärast riverit . Herli ei usu ja callib.

Mauri avab ning korjab panga maha. Tema stäkk on nüüd taas üle 200K, sest alles õnnestus Mauril ka üks põhjanaaber välja lüüa.

11:14 (UTC+0)

Start of Level 10
Blinds: 0/0     Ante: 0

Kes on turniiri kuulsaim osaleja? Posted Friday 28th July, 2023 at 11:05(UTC+0) by maheaaatom

Ei, see pole Ranno Sootla ega isegi mitte Markku Koplimaa, vaid tõenäoliselt hoopis GGPoker esindusmängija Anatoly Filatov, kes elab muide Tallinnas!

Anatoly on 34-aastane Moskvas sündinud, kuid viimastel aastatel peamiselt Lääne-Euroopas elanud ning tegutsenud tippmängija, kelle kontol on üle 5 miljoni dollari Hendoni cashe ning väga korralik karjäär ka netipokkeris.

2019 aastal sai ta kolmanda koha WSOP Europe High-Roller turniiril (sisseost 100 000 eurot!) ja 2021. aastal võitis $10,300 Super MILLION$ põhiturniiri GG-võrgustikus, mis tõi talle sisse üle miljoni euro. Mees on muide varemgi Eestis mänginud, näiteks tänavusel Kings of Tallinn High-Rolleril oli ta teine. 

Kui 1100-eurone sisseost on enamikule pokkerifännidest väga suur, siis miljonimänguga harjunud Anatoly jaoks on tegemist peenrahaga. Seega on ainult hea meel sellise tasemega meest Summer Showdownil näha. 

500 sisseostu koos Posted Friday 28th July, 2023 at 10:53(UTC+0) by maheaaatom

Teine päev on alanud niivõrd tempokalt, et oodatud 500 sisseostu piir sai õige kiirelt täis. 

Kõigi eelduste kohaselt jõuab ka auhinnafond oodatud poole miljoni euroni, sest sellest on puudu veel vaid paarkümmend sisseostu ning sagimine turniiriala ning kassa vahel on päris aktiivne.

Kõik mängijad on mahu suurde saali ära, neli lauda on viidud fuajeesse. Eestlastest veel niipalju, et Jaana Kindsigo on ka oma seisu märgatavalt parandanud ning nüüd selgelt üle keskmise stäkiga.

Mõned langejad Posted Friday 28th July, 2023 at 10:47(UTC+0) by maheaaatom

Juba on välja langenud / re-entry'le läinud paarkümmend osalejat, nende seas ka neli eestlast: Hendrik Uibo, Kaius Kiidli, Karlo Kivi ning Jüri Roots.

Väga karm laud Posted Friday 28th July, 2023 at 10:45(UTC+0) by maheaaatom

15. lauas on saanud kokku hirmkõva eestlaste seltskond:

- Viimase kahe aasta EMV põhiturniiri võitjad Magnus Pukk ja Kaidar Viikman

- Super High-Roller Urmo Velvelt

- Eesti läbi aegade edukaim turnamängija Markku Koplimaa

- Hinnatud pokkeriproff Tõnis Viik

Vaevalt tahaks keegi selles kambas mängida...

Allan pidas sõna Posted Friday 28th July, 2023 at 10:35(UTC+0) by maheaaatom

Allan ütles eilse päeva 1B ajal, et ainult nõrgad mängivad esimest päeva ning kõvad mehed istuvad lauda alles teisel päeval.

Ei olnud see nali midagi, Allan pidas 100% sõna. Nüüd ongi ta kenasti lauas ning istub täpselt Eesti superprofi Jargo Alavälja kõrval. 25XBB on täpselt see stäkk, millega saab esialgu veel rahulikult oma lükkekohta oodata. 

Herli duubeldab läbi Mauri Posted Friday 28th July, 2023 at 10:31(UTC+0) by maheaaatom

50K stäkiga alustanud Herli Olop võttis kiire duubli, maksjaks oli seekord suur kodumaine konkurent Mauri Dorbek.

Mauri avab CO-lt, Herli kaitseb BB-d -ga.

Flopis , Herli checkib ette, Mauri paneb 3500 ja Herli callib.

Turn toob lauale mastivõimaluse. Herli check-callib taas Mauri 7,5K panust, jättes 30K järgi.

River on blank ning Mauri paneb Herli all-in. Viimane callib ning Mauri avab - puhas bluff. 

"Tal nuppe nii palju, lükkas oma kuhjalt lihtsalt natuke tolmu maha," naerab rahulolev Herli. 

Herli stäkk nüüd c. 100K, Mauril on umbes 150K.

Player		Chips	Progress
Mauri Dorbek		150,000	57,400
Herli Olop		100,000	50,700

Magnus Pukk võtab esimese skalbi Posted Friday 28th July, 2023 at 10:22(UTC+0) by maheaaatom

38K stäkiga Kasparas Drazdauskas tuleb blinde sööma ning BB-d kaitsev tunamullune EMV põhiturniiri võitja Magnus Pukk vastab all-in'iga. 

Kasparaselt kiire call. Magnus avab , leedukal on . Laud tühi ning Magnuse stäkk nüüd 210K.

Player		Chips	Progress
Magnus Pukk		210,000	38,600

Kui kaua me tänane mängime? Posted Friday 28th July, 2023 at 10:17(UTC+0) by maheaaatom

Turniiridirektor Teresa kinnitusel on täna kavas mängida kaheksa taset sõltumata selles, kui palju mängijaid alles jääb. 

See tähendab actionit kuni umbes üheksani. Ülekannet tasub aga kindlatsi jälgida ka pärast seda, sest just hilisõhtul jõuab kulminatsioonini tõeline "vaalade turniir", 5000 € High-Roller, tuntud ka kui "5K". 

39 eestlast Posted Friday 28th July, 2023 at 10:13(UTC+0) by maheaaatom

Kaardid on õhus. 216 alustaja seas on 39 eestlast, täiesti uueks liitujaks meie meestest siiski vaid Jüri Roots. 

Priit Vanem alustab samuti 30K stäkiga, kuid sellega lõpetas ta ka eilse päeva (1B). 

Esimese kahe taseme jooksul on "lubatud" eksida (saab teha re-entry 25xBB), kuid hiljem enam mitte. 

Mängijad kogunevad Posted Friday 28th July, 2023 at 09:58(UTC+0) by maheaaatom

Head pokkerisõbrad, tervitame teid taas kodusest pokkerimekast, Olympic Park Casinost.

Põhiturniiri teise päeva mängijad kogunevad laudadesse, väljas on veel kenake järjekord, mis ulatud lausa kasiino uksest tänavale. Mängu alustab hetkeseisuga 200 mängijat, nende seas nii esimese päeva üleelanud pokkerisportlased kui ka mõned uued liitujad. 

Auhinafondis on juba ligi 450 tuhat eurot ning esikümnes kolm Eesti pokkerimängijat eeotsas Jargo Alaväljaga. Tuleb väga põnev päev!

09:42 (UTC+0)

Day 2 of Kings of Tallinn Summer Showdown 2023 Started
Level: 9     Blinds: 600/1,200     Ante: 1,200

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