0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0106 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-25' AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_est_2023/4/updates'

0.0003 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.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.0008 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.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

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

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

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

0.0043 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.0302 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0072 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '82' AND `published` = 1

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

0.0285 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` = '87' AND `published` = 1

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

0.0278 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` = '93' AND `published` = 1

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

0.0060 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.0055 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` = '93' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '4375' 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` = '4374' 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` = '4372' 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` = '4371' 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` = '4370' 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` = '4368' 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` = '4365' 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` = '4364' 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` = '4363' 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` = '4361' 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` = '4359' 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` = '4357' 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` = '4355' 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` = '4354' 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` = '4351' 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` = '4350' 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` = '4349' 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` = '4346' 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` = '4344' 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` = '4341' 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` = '4340' 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` = '4338' 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` = '4336' 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` = '4334' 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` = '4333' 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` = '4332' 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` = '4325' 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` = '4320' 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` = '4318' 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` = '4316' 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` = '4314' 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` = '4311' 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` = '4309' 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` = '4305' 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` = '4303' 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` = '4301' 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` = '4297' 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` = '4294' 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` = '4290' 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` = '4287' 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` = '4285' 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` = '4280' 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` = '4274' 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` = '4268' 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` = '4267' 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` = '4265' 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` = '4264' 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` = '4263' ORDER BY `chip_change` DESC, `busted` ASC

0.0058 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '93' 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` = '93' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '4375' 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` = '4374' 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` = '4372' 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` = '4371' 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` = '4370' 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` = '4368' 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` = '4365' 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` = '4364' 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` = '4363' 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` = '4361' 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` = '4359' 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` = '4357' 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` = '4355' 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` = '4354' 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` = '4351' 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` = '4350' 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` = '4349' 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` = '4346' 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` = '4344' 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` = '4341' 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` = '4340' 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` = '4338' 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` = '4336' 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` = '4334' 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` = '4333' 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` = '4332' 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` = '4325' 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` = '4320' 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` = '4318' 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` = '4316' 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` = '4314' 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` = '4311' 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` = '4309' 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` = '4305' 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` = '4303' 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` = '4301' 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` = '4297' 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` = '4294' 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` = '4290' 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` = '4287' 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` = '4285' 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` = '4280' 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` = '4274' 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` = '4268' 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` = '4267' 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` = '4265' 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` = '4264' 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` = '4263' ORDER BY `chip_change` DESC, `busted` ASC

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

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

English
Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 4
1. koht Kai Lehto 108 260 € Posted Sunday 30th July, 2023 at 18:04(UTC+0) by Mariliis Joras

Phil Gross avab 400 000. Tal täitsa ok kaart

Kai Lehto on vähem võimas, aga floppi võib ju vaadata.

Lauda ehk kõigile midagi.

Phili soovil panevad mõlemad veel 300 000 juurde.

Turn ja nüüd betib Phil 500 000. Tuleb call.

River !

Kai suudab end nüüdki vaos hoida ja checkib, aga kui Phil betib 1,3 miljonit, siis shoveb.

Nagu arvata võis, ei saa vastane enam foldida. 

Ja lõpplahendus on käes. 

Aega läks, aga mõlemad on tõelised tšempionid. 

Player Chips Progress
Kai E. J. Lehto 17,000,000 8,100,000
2. koht Phil Gross 72 700 € Posted Sunday 30th July, 2023 at 18:01(UTC+0) by Mariliis Joras

Phil Grossi stäkk aina väheneb, kuniks see on Kai Lehto omast märgatavalt väiksem. 

Mäng on mõlemad mehed ära väsitanud, kuid võitjana väljub olukorrast seekord soomlane.

Player Chips Progress
Phil Gross 0 0
Kolmas all-in ja call Posted Sunday 30th July, 2023 at 17:45(UTC+0) by Mariliis Joras

Kai Lehtol käes ja ta limbib.

Phil Gross leiab aga ja põrutab kõik sisse. 

Kai läheb kaasa.

Lauda

Lõpplahendust ei saabu ikka veel.

Player Chips Progress
Phil Gross 8,600,000 500,000
Phil Gross 8,400,000 300,000
Phil kaotab veel ühe miljoni Posted Sunday 30th July, 2023 at 17:41(UTC+0) by Mariliis Joras

Phil Gross üritab Kai Lehtole kohta kätte näidata.

Kai tõstab 400 000 kahtede pocketiga.

Phil paneb 1,1 miljonit, ehkki endal vaid

Kai liigub nüüd all-ini ja Phil foldib. 

Miljon lännu nagu mutiauku.

Phil kaotab suure hunniku žetoone Posted Sunday 30th July, 2023 at 17:39(UTC+0) by Mariliis Joras

Phil Gross ei usu, et Kai Lehto on tabanud.

Board

Phil ise on hittinud kuut. Kai aga kuningat. 

Koos pre-flopi ja turni panusega kaotab Phil oma stäkist üle miljoni.

Täiesti võrdseks Posted Sunday 30th July, 2023 at 17:25(UTC+0) by Mariliis Joras

Kai Lehto ja Phil Gross vaatavad koos floppi ja sellise kõrge hinna eest nagu 1,2 miljonit.

Boardile saab Phil -ga pihta,

Kai midagi ei taba. 

Kuigi rohkem actionit ei toimugi, on märkamatult stäkid peaaegu võrdseks tasakaalustunud.

Player Chips Progress
Kai E. J. Lehto 8,900,000 3,100,000
Phil Gross 8,100,000 3,000,000
17:22 (UTC+0)
Start of Level 32
Blinds: 100,000/200,000     Ante: 200,000
Phil teeb hea blufi Posted Sunday 30th July, 2023 at 17:19(UTC+0) by Mariliis Joras

Phil Grossil on flopis kahepoolne reatõmme, mis aga kohale ei tule. 

Kai Lehto ei saa lauale samuti pihta, kuid showdowni korral võtaks võidu. Phil teeb riveris julge käigu ja surub all-ini. Calli ei tule.

Chipilisa on väike, aga alla 5 miljoni käes hoidva Phili jaoks on iga žetoon oluline.

Mõnus snooze-fest Posted Sunday 30th July, 2023 at 17:05(UTC+0) by Mariliis Joras

Mitte mingeid arenguid pole. 

Vaadates kaarte, mis mängijatele kätte jagatakse, tuleb natuke ahastus peale. Aga lootust ka ei saa kaotada.

Sellise karika peale käib mäng:

Teine all-in ja call Posted Sunday 30th July, 2023 at 16:52(UTC+0) by Mariliis Joras

Phil Grossil on käes kaheksate pocket. Ta teeb tõste 300 000. 

Kai Lehto pole midagi erilist, aga ta otsustab callida.

Flop ja Kai checkib.

Phil betib 300 000, aga Kai liigub nüüd all-ini ja saab ka calli.

Turn paneb pealtvaatajad ohkama.

River ja ei mingit lõpplahendust.

Player Chips Progress
Kai E. J. Lehto 12,000,000 2,000,000
Phil Gross 5,100,000 2,100,000
Esimene all-in ja call Posted Sunday 30th July, 2023 at 16:44(UTC+0) by Mariliis Joras

Phil Gross teeb tõste 375 000. Kai Lehtol on parem plaan - kui vaataks floppi õige 1,1 miljoni eest? Phil nõustub.

 

Kai betib 600 000, kuid Phil liigub nüüd all-ini.

Kail läheb natuke aega, et otsusele jõuda, kuid siit tulebki esimene all-ini call.

Kai avab

Phil püüab -ga masti.

Turn ei muuda midagi.

River ja Kai duublis.

Player Chips Progress
Kai E. J. Lehto 14,000,000 6,800,000
Phil Gross 3,000,000 6,700,000
Natuke juurde Posted Sunday 30th July, 2023 at 16:31(UTC+0) by Mariliis Joras

Flop sobib Kai Lehtole, kellel .

Ta laseb Phil Grossil show'd juhtida. Phil panustabki 300 000 ja saab calli. Endal tal käes

Turn annab paari ka Philile. 500 000 maksab Kai muidugi välja.

River checkitakse läbi. Kaardid lahti ja pank Kaile.

See muudab vahekorda oluliselt võrdsemaks.

Player Chips Progress
Phil Gross 9,700,000 2,900,000
Kai E. J. Lehto 7,200,000 2,875,000
Kai võitleb Posted Sunday 30th July, 2023 at 16:12(UTC+0) by Mariliis Joras

Kai Lehtol on küll väiksem stäkk, aga väikeste jaotuste haaval ronib ta stäkiredelil üles. 

Jäme ots on Phili käes Posted Sunday 30th July, 2023 at 16:02(UTC+0) by Mariliis Joras

Stäkid heads upi eel.

Player Chips Progress
Phil Gross 12,600,000 400,000
Kai E. J. Lehto 4,325,000 1,875,000
Heads up algab pärast pisukest pausi Posted Sunday 30th July, 2023 at 15:48(UTC+0) by Mariliis Joras

Mängijad soovivad 20 minutit puhata ja on siis valmis välja selgitama, kelle Hendon Mobi andmed 100 000 võrra kasvavad.

3. koht Urmo Velvelt 49 300 € Posted Sunday 30th July, 2023 at 15:43(UTC+0) by Mariliis Joras

Urmo Velvelti agressiivne mäng on langetanud ta väikseimaks stäkiks. Kahjuks on vastastel rohkem õnne olnud.

Nüüd lähevad 1,9 miljonit sisse kaheksate taskupaariga, kuid seda alles pärast Phil Grossi all-ini. Philil .

Kuni riverini on kõik ilus, aga viimase kaardina avatakse äss ja meie mees out. Õnneks saab pisarad ära kuivatada 100-eurostega, sest neid antakse Urmole kassast terve hunnik.

Player Chips Progress
Phil Gross 13,000,000 7,400,000
Urmo Velvelt 0 0
Mees, kes ei karda all-inis käia Posted Sunday 30th July, 2023 at 15:36(UTC+0) by Mariliis Joras

Urmo Velvelt on mitu korda üritanud jõuga panka endale murda. Küll pre-flopis kipaka kaardiga tõsteid tehes kui ka juba avatud flopiga suurelt bettides. 

Tema jõunumbritega läheb kaasa või sõidab nende peale all-ini Phil Gross. Mis tal viga - kogu aeg on pihtas. 

Urmo on selliselt kaotanud juba õige mitu miljonit.

Phil võtab lisa Posted Sunday 30th July, 2023 at 15:30(UTC+0) by Mariliis Joras

Phil Gross mängib -ga ja hitib runner-runner masti. 

Boardile

Kai Lehto üritab vastast üle kavaldada, tal -ga ebaõnnestunud reatõmme.

Riveri beti teeb ta 1,3 miljoni suuruse. Phil teeskleb nuputamise nägu, kuniks shoveb. Kai nägu vajub morniks ja kaardid lendava dmucki. 

Väga hea chipilisa Philile.

Urmo mängib vastase üle Posted Sunday 30th July, 2023 at 15:23(UTC+0) by Mariliis Joras

Urmo Velvelt võtab jõuga panga maha. 

Ta teeb pre tõste 250 000 ja saab uudishimuliku Phil Grossi kaasa, tollel .

Phil tabab flopis seitset ja lisatakse kummaltki veel 200 000 panka. 

Turn ja Phil checkib. Urmo betib nüüd suurelt 500 000. Phil on ees, aga et lauas kaks pildikaarti, hakkab ta endas kahtlema. Kuniks näemegi foldi.

Hea töö!

Player Chips Progress
Urmo Velvelt 5,800,000 600,000
Võrdne seis Posted Sunday 30th July, 2023 at 15:08(UTC+0) by Mariliis Joras
Player Chips Progress
Kai E. J. Lehto 6,200,000 2,200,000
Phil Gross 5,600,000 3,000,000
Urmo Velvelt 5,200,000 900,000
4. koht Ville-Matti Keränen 34 900 € Posted Sunday 30th July, 2023 at 15:03(UTC+0) by Mariliis Joras

Nüüd lähevad soomlased omavahel sotte selgeks tegema. 

Kai Lehto tõstab 250 000, mille peale Ville-Matti Keränen all-ini liigub. 

Kail on taga natuke üle 4 miljoni ja Ville 2,3 miljonit saab selle kaardiga ära callida küll.

Kail

Villel

Kaardijumal potsatab floppi kümne ja turn ega river seisu enam ei muuda.

Oleme jõudnud TOP 3-ni!

Player Chips Progress
Ville-Matti Keränen 0 0
14:58 (UTC+0)
Start of Level 31
Blinds: 75,000/150,000     Ante: 150,000
Ville duubeldab Posted Sunday 30th July, 2023 at 14:48(UTC+0) by Mariliis Joras

Ville-Matti Keränen soovib stäkki suurendada, sest hetkel on ta kõige pisem.

Urmo Velvelt on ees teinud tõste 200 000 ja Ville shoveb 1,8 miljonit sisse. 

Kuigi ka Phil Gross oli Urmo tõste callinud, tema kolmandaks ei tule. 

Villel ja Urmol

Kohe flopis Villel kaheksate paar, kuid turnis juba kolmik. 

Urmo peab välja maksma.

5. koht Tarmo Tammel 25 600 € Posted Sunday 30th July, 2023 at 14:25(UTC+0) by Mariliis Joras

Tarmo Tammeli kukkumine on tõeliselt õnnetu. 

Phil Gross on ees 3bettinud 500 000 ja Tarmo näeb käes -d. Väike mõttepaus, kuid sisse need nupud lähevad. 

Keegi teine ei calli, aga Phil võtab oma -ga väljakutse vastu. 

Lauda jooksevad

Alles river annab Philile rea. 

Mehed suruvad kätt ja mänguga minnakse edasi.

Player Chips Progress
Tarmo Tammel 0 0
Žetoonide seis Posted Sunday 30th July, 2023 at 14:09(UTC+0) by maheaaatom
Player Chips Progress
Urmo Velvelt 6,100,000 700,000
Kai E. J. Lehto 4,000,000 700,000
Phil Gross 2,600,000 1,000,000
Ville-Matti Keränen 2,600,000 1,200,000
Tarmo Tammel 1,700,000 300,000
14:07 (UTC+0)
Start of Level 30
Blinds: 50,000/100,000     Ante: 100,000
Side-actionit Posted Sunday 30th July, 2023 at 13:53(UTC+0) by maheaaatom

High-Roller läheneb samuti lõppelahendusele, ülemisel korrusel on aga toimumas kaks turniiri. 

250 € NLH Progressive Bountyl on 105 sisseostu, re-entry ammu lõppenud ning 27 mängijat veel laudades.

Põhiturniiri turboversioon on meelitanud kohale umbes 50 erinevat mängijat, sellega on veel võimalik liituda. Peagi jätkub ka põhiturniiri finaali ülekanne.

Viimane pausieelne käsi annab Tarmole duubli Posted Sunday 30th July, 2023 at 13:38(UTC+0) by maheaaatom

Phil ) tuleb buttonilt blinde "sööma", Tarmo () vastab SB-lt 620K all-in'iga. Sakslaselt call.

Pole just kiita seis...Aga seekord on pokkerijumal meie mehe poolt. Flopis on kolm ning Tarmol taas 1,4M. 

Põhiturniir läks esimesele pausile.

Player Chips Progress
Tarmo Tammel 1,400,000 420,000
Urmole 1,3M pank Posted Sunday 30th July, 2023 at 13:34(UTC+0) by maheaaatom

Urmo () avab 175K-ga ning Phil ) vastab kolmpanusega. Urmolt call.

Flop on ning sakslane katsetab uuesti - bet 250K. Urmolt taas call.

Turni järel saab Grossil julgus otsa ning ta checkib kiirelt. Nõrkust haistval Urmol piisab teha pisike panus, et 1,3M pank endale saada.

Viie parima VPIP näitajad finaallauas Posted Sunday 30th July, 2023 at 13:26(UTC+0) by maheaaatom

See number (34%) on selgelt kõrgeim Grossil ning madalaim Urmol ja Villel (25%). Tarmo ja Kai VPIP on 28%. 

6. koht - Mikael Johannes Haapaniemi 19300 € Posted Sunday 30th July, 2023 at 13:21(UTC+0) by maheaaatom

Urmo () avab 175K-ga, Phil Gross ) tuleb kaasa. 

BB-l istuv Mikael Johannes Haapaniemi  ei löö aga kartma, vaid läheb oma 1,4M stäkiga all-in.

Urmo foldib kiirelt, kuid sakslane, kes on teinud varemgi võrdlemisi loogikavastaseid käike ... callib!

Flopis ongi poiss ning Gross võtab turniiri pikalt juhtinud Haapaniemi välja!

Player Chips Progress
Phil Gross 3,600,000 1,500,000
Mikael Johannes Haapaniemi 0 0
Urmo duubeldab läbi Tarmo Posted Sunday 30th July, 2023 at 13:10(UTC+0) by maheaaatom

Telelauas mängitakse väga suur käsi.

Phul Gross () avab 175K-ga, Tarmo kolmpanustab CO-lt 555K (), kuid BB-l istuval Urmol on !

Urmo ei taha midagi juhuse hooleks jätta ja läheb kohe all-in. Tarmol on ülimalt raske foldida ning call tuleb võrdlemisi kiirelt.

Flopis on (Phil oleks saanud kaks paari!), turn annab Tarmole mastitõmbe. River tagab võidu aga ikkagi Urmole.

Urmol nüüd 5,4M, Tarmol jääb 980K järgi.

Player Chips Progress
Urmo Velvelt 5,400,000 2,700,000
Tarmo Tammel 980,000 2,620,000
Milline on tiimide hetkeseis? Posted Sunday 30th July, 2023 at 13:05(UTC+0) by maheaaatom

"Antikaisen Opetuslapset" on endiselt edetabeli tipus ning paistab, et nende võitu ei kõiguta enam miski.

Eesti tiimidest on edukaim "Oskari Jooks" (hetkel kolmandad) aga High-Rollerilt on tulemas lisapunkte (Ranno ja Markku). Edetabel on seisuga täna kell 11:30. 

Eesti tiimidest on hetkel "rahades" ka "Diamonds are Forever" (Mjagkov, Smeljov, Petrov, Dudakov). Aga vahed on väikesed.

Stäkkide seis Posted Sunday 30th July, 2023 at 12:52(UTC+0) by maheaaatom
Player Chips Progress
Ville-Matti Keränen 3,800,000 200,000
Tarmo Tammel 3,600,000 0
Kai E. J. Lehto 3,300,000 105,000
Urmo Velvelt 2,700,000 60,000
Phil Gross 2,100,000 400,000
Mikael Johannes Haapaniemi 1,500,000 800,000
12:50 (UTC+0)
Start of Level 29
Blinds: 40,000/80,000     Ante: 80,000
7. koht - Tomi Tapani Arponen 13400 € Posted Sunday 30th July, 2023 at 12:44(UTC+0) by maheaaatom

965K stäkiga Tomi Arponen lükkab oma nupud keskele (). Tarmo Tammel leiab , kuid ei tõtta sugugi kiirelt vastu all-in lükkama, vaid mõtleb, kas kuidagi õnnestuks ka Kai sisse meelitada.

Lõpuks Tarmo "vaid" callib, kuid Kail on niivõrd kehv kaart, et ta foldib kiirelt ega lähegi mingit actionit otsima.

Flop annab Tomile pisikesed võimalused panga poolitamiseks (rida või mast), kuid turni järel on ta drawing dead.

Tarmol nüüd 3,6M.

Player Chips Progress
Tarmo Tammel 3,600,000 700,000
Tomi Tapani Arponen 0 0
8. koht - Magnus Pukk 10 100 € Posted Sunday 30th July, 2023 at 12:37(UTC+0) by maheaaatom

Magnus avab 120K tõstega, Ville paneb natuke juurde (205K) ja Magnus callib.

Flop on

Ville avab 140K-ga, Magnus (1,4M) vastab aga all-in'iga. Villelt kiire call.

Magnus:

Ville:

Turn ja river meie meest ei päästa. Milline cooler!

Player Chips Progress
Ville-Matti Keränen 4,000,000 2,600,000
Magnus Pukk 0 0
Urmo suudab ka AK foldida Posted Sunday 30th July, 2023 at 12:29(UTC+0) by maheaaatom

Tarmo Tammel () avab 120K, Magnus () tõstab panused 280K-le ning tagatipuks lükkab Ville ) veel otsa - 430K.

BB-l istub aga Urmo , kes - uskuge või mitte - foldib.

Magnus aga asja niisama ei jäta, vaid callib.

Flop on Villele ideaalne. Ta panustab küll vaid 140K, kuid see on piisav, et Magnus foldiks.

Aga Urmo AK-fold on siiski tähelepanuväärne. Ju olid riidid väga hästi paigas. Ja tagatipuks tuleb tunnistada, et väga hea fold.

Sakslane duubeldab Posted Sunday 30th July, 2023 at 12:19(UTC+0) by maheaaatom

Haapanieme avab 120K (), chipliider Kai lükkab veel otsa - 320K. Phil Gross läheb oma stäkiga (700K) seejärel all-in ning pot committed Kai peab callima.

Phil:

Kai: . Lauda pudi, soomlane on juba pärast turni drawing dead.

Grossil nüüd 1,7M. Kai juhib endiselt (3,2M), kuid vahe eestlastega on vähenenud.

Player Chips Progress
Kai E. J. Lehto 3,200,000 205,000
Urmo Velvelt 2,600,000 40,000
Tarmo Tammel 2,500,000 400,000
Phil Gross 1,700,000 700,000
9. koht - Nils Jakob Elias Linden 7700 € Posted Sunday 30th July, 2023 at 12:15(UTC+0) by maheaaatom

Shortstäkiga (690K) Jakob lükkab -ga ning saab calli Magnus Puki -lt. 

Jakobile lauas küll mastitõmme, kuid lauda lisandub ka kaks ässa. 

Magnusel nüüd 2,1M. Väga hea!

Player Chips Progress
Magnus Pukk 2,100,000 675,000
Nils Jakob Elias Linden 0 0
Kaks väikest panka Tarmo ja Urmo vahel Posted Sunday 30th July, 2023 at 12:10(UTC+0) by maheaaatom

Urmo ja Tarmo mängivad omavahel kaks väikest panka, mis üldpilti küll väga palju ei muuda. 

Esimesel korral teeb Tarmo tõelise hero-calli. Lauas , Tarmol , Urmol . Ju paistis ikka väga blufi moodi.

Teisel korral on hoopis Tarmol ning Urmol pisut nõrgem . Flopis on äss, kuid panused taas väga väikesed. See pank seega juba Tarmole.

Ville pääseb "auku" reaga Posted Sunday 30th July, 2023 at 11:56(UTC+0) by maheaaatom

Tarmo Tammel () avab 120K, Ville lükkab oma shortstacki all-in 610K ning sama teeb ka Tomi (1,6M). Tarmo loobub.

Ville:

Tomi:

Flop vaid kindlustab Tomi eduseisu, turn  ei muuda samuti midagi.

. Kas esimene langeja? Villel on aga neli outi "auku rea" saamiseks ning üks neist - - sajab ka riverisse.  

Player Chips Progress
Ville-Matti Keränen 1,400,000 670,000
Finaal algas Posted Sunday 30th July, 2023 at 11:19(UTC+0) by maheaaatom

Just mõni minut tagasi läks alumisel korrusel käima Summer Showdown põhiturniiri finaal.

Selleks, et vaatajatel oleks huvitavam põhiturniiri jälgida, toimub blogi sünkroonis TV-lauaga ehk 30-minutilise viivitusega. Kes aga januneb kohe pokkeriactioni järele, võib juba nüüd avada High-Rolleri finaali blogi.

Finaali blogi ja TV-ülekanne algab umbes kell 13:42. 

Player Chips Progress
Kai E. J. Lehto 3,405,000 203,000
Tarmo Tammel 2,900,000 558,000
Urmo Velvelt 2,640,000 25,000
Mikael Johannes Haapaniemi 2,300,000 170,000
Tomi Tapani Arponen 1,665,000 130,000
Magnus Pukk 1,425,000 180,000
Phil Gross 1,000,000 360,000
Nils Jakob Elias Linden 840,000 150,000
Ville-Matti Keränen 730,000 0
Ja ongi finaallaud koos Posted Sunday 30th July, 2023 at 10:49(UTC+0) by maheaaatom

Finaalpäeva shortstack Tapio Ilmari Aaltonen küll eile natuke venitas mängu, kuid erilist tulemust sel ei olnud - pigem stäkk vähenes ning alustada tuli ikkagi selgest kaotusseisust.

Enam polnud aga venitada midagi ning Aaltonenil tuli üsna kiirelt nupud sisse lükata. Call tuli Tarmo Tammelilt.

Aaltonen:

Tarmo:

Lauda

Finaallaud on sellega koos ning me kolime peagi kasiinosse. See tähendab vähemalt poole tunnist pausi, misjärel algab action juba TV-lauas.

Player Chips Progress
Tapio Ilmari Aaltonen 0 0
Sakslane mängib eelkõige inimesi, mitte kaarte Posted Sunday 30th July, 2023 at 10:43(UTC+0) by maheaaatom

Seda arvas eile õhtul Tarmo Tammel, kes mängis Phil Grossi vastu päris mitu huvitavat kätt.

Igatahes esimeses suures jaotuses annab Gross Haapaniemile umbes 350K ära. Turni järel sakslane murdub, kuigi praeb eelnevalt omajagu oma vastast ning katsub viimaselt sõnu välja pigistada. Grossi strateegia on pea alati sarnane - keerulistes kohtades alustab ta vastasega juttu, jälgides vastuseid, kehkeelt ja muud.

Gong on kõlanud! Posted Sunday 30th July, 2023 at 10:33(UTC+0) by maheaaatom

TOP10 on laudades ning kaardid läinud liikvele.

Täna on kavas veel High-Rolleri finaal (algab kell 13:00, saab jälgida läbi eraldi live-blogi), 250 € NLH Progressive Bounty (juba alanud, hetkel kohal umbes 50 mängijat) ning põhiturniiri turboversioon (sisseost 150 €, algab kell 14:00).

Neljas päev algab kell 12:30 Posted Sunday 30th July, 2023 at 10:15(UTC+0) by maheaaatom

Mängu algus natuke venib, alustatakse kell 12.30. 

Mõlemad lauad pannakse käima ülemisel korrusel ning kui finaallaud on selge, siis kolitakse kasiinosse. 

10:15 (UTC+0)
Day 4 of Kings of Tallinn Summer Showdown 2023 Started
Level: 28     Blinds: 30,000/60,000     Ante: 60,000

Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.