0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0061 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-19' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/22' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/22', 1, '2024-05-19')

0.0004 SECONDS:
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '22'

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

0.0265 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` = '89' AND `published` = 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Translate
Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) Live Reporting - Day 1
1 New Update - Click to refresh
Live Updates - Day 1
Finaallauast näed telelaua ülekannet Posted Friday 28th July, 2023 at 20:39(UTC+0) by Mariliis Joras

Kõik 7 tugevat tõstetakse kokku ja viiakse alla kasiinosaali telelauda. 

See tähendab, et õige pea saad sealseid sündmusi oma silmaga seirata.

Blogi tänaseks lõpetame. 

Head ülekande nautimist! Link siin:

https://olybet.tv/kings-of-tallinn-summer-showdown-2023-2/ 

Finaallaud käima Posted Friday 28th July, 2023 at 20:37(UTC+0) by Mariliis Joras

Jukka Ylitalo üheksad saavad Casimir Seire kuningate käest tappa. 

Lauakaardid lihtsalt ei aita.

Nüüd on järel 7 mängijat, kuid selle asemel, et hakata mängima 3 ja 4 mängijaga laudades, tõstetakse kõik 7 ühte lauda kokku. 

Suur duubel Posted Friday 28th July, 2023 at 20:34(UTC+0) by Mariliis Joras

Andre Henning saab suure duubli, kui Robert Rohri vastu tõstma läheb. Nupud saadakse sisse veel enne floppi.

Andrel kuningad, Robertil soldatid. 

Lauakaardid Andret ei ohusta ja Roberti suur stäkk saab rüüstatud.

Järel 8 mängijat Posted Friday 28th July, 2023 at 20:23(UTC+0) by Mariliis Joras

Välja on kukkunud ka Pasi Sormunen. Jätkab 8 parimat. 

6 neist pääseb telelauda, mis ilmselt stardibki just siis, kui finaallaud koos.

Neli pole kohtu seadus Posted Friday 28th July, 2023 at 20:21(UTC+0) by Mariliis Joras

Roope Tormi neli sisseostu täna soovitud tulemust ei toonud. 

Viimases jaotuses Casimir Seire vastu. 

Ässa lauda ei tule.

Nagu liiv sõrmede vahelt Posted Friday 28th July, 2023 at 20:19(UTC+0) by Mariliis Joras

Casimir Seire stäkk on kokku kuivamas. 

16 000 eest läheb ta ühes Andrius Bielskisega floppi vaatama.

lauda.

Casimir check-raiseb Andriuse beti 13 000 suurelt 40 000 peale. Saab calli.

Turn checkitakse läbi.

River toob Casimirilt 32 000. 

Ta ei tahaks mitte seda kaotada, kuid et Andrius callib, siis peab minna laskma.

Casimiril -g bluff.

Andriuse on parem.

20:06 (UTC+0)
Start of Level 13
Blinds: 5,000/10,000     Ante: 10,000
Jussi fännid saavad ka nutta Posted Friday 28th July, 2023 at 19:49(UTC+0) by Mariliis Joras

Jussi Mattila on paraku out. 

Player Chips Progress
Jussi P. K. Mattila 0 0
Hirmus halvad uudised meile Posted Friday 28th July, 2023 at 19:48(UTC+0) by Mariliis Joras

Jukka Ylitalo on käest leidnud monsteri. Tema pre-flopi tõste on 26 000, taga on tal veidi üle 100 000.

Ottomar Ladva stäkk on ka 100 000+ kandis ja leides käest pocketi, näeb ta head võimalust. 

on Jukkal. 

"Kindel värk," teeb ta oma võidu juba teatavaks. 

Diiler veel nii kindel pole, pakkudes ära sõnumise võimalust. Kuid ei, kaardijumal pole kümnete pocketiga mängiva Ottomari poolt. 

Meie mees on out.

Player Chips Progress
Ottomar Ladva 0 0
19:36 (UTC+0)
Start of Level 12
Blinds: 4,000/8,000     Ante: 8,000
Võitjale üle 50k Posted Friday 28th July, 2023 at 19:36(UTC+0) by Mariliis Joras

Väljamaksed on nüüd teada. Võitja läheb koju üle 50 000 euroga.

Kokku jagub krõbisevat viiele parimale.

Mehel on tõsi taga Posted Friday 28th July, 2023 at 19:34(UTC+0) by Mariliis Joras

Andrius Bielskis on ohtlik mees. Ka Ottomar Ladva saab tema jõudu enda peal tunda. 

10 000 eest vaadatakse kahekesi floppi.

ja Andrius checkib.

Ottomarilt bet 9000 ja nüüd Andrius tõstab, nõudes 27 000. Selle Ottomar ka maksab.

Turn ja Andrius checkib.

Ottomar püüab panka 23 000-ga maha võtta, aga kui Andrius all-ini liigub, lülitab Ottomar sisse tagurpidi käigu. 

Casper hoos Posted Friday 28th July, 2023 at 19:25(UTC+0) by Mariliis Joras

Ka Juha Helppi turniirieluküünla kustutas Casper Schantz.

vs

Parem kaart mängib.

Player Chips Progress
Juha Ilmari Helppi 0 0
Väiksed teevad lükkeid Posted Friday 28th July, 2023 at 19:24(UTC+0) by Mariliis Joras

Janne Järvinen shoveb pärast Casper Schantzi tõstet 25 000. Temalt tuleb ka call.

Jannel

Casperil

Board annab Casperile lausa maja. Väiksema stäkiga Janne out.

Veel üks mängija peab kukkuma ja siis on järel kahe laua jagu mängijaid.

Kiirelt läbi Posted Friday 28th July, 2023 at 19:21(UTC+0) by Mariliis Joras

Juan Duenasel on plaan suunduda põhiturniirilt High rollerile. Talle antakse 10 minutit aega ja õnneks mahub ta ajalimiidi sisse.

Nupud kotis, istub ta maha ja saab mängida kõvad 5 minutit.

Nuppe paneb ta flopis

Käes Juanil

Vastas

Turn ja river enam seisu ei muuda ja mees kommenteerib ka ise: "That was quick."

Paistab, et rohkem põhiturniirilt keegi ei liitunudki. Nüüd jätkame 14 mängijaga.

Väike viivitus Posted Friday 28th July, 2023 at 19:08(UTC+0) by Mariliis Joras

Natuke tuli mängijatel oodata, kuid nüüd on kaardid taas õhus. 

Vähemalt üks mängija, kes on veel põhiturniiril sees, soovis tulla mängima ka High rollerit. Sisseostu ta juba tegi, kuid stäkki pole lauale tiksuma veel pandud - oodatakse mulli lõhkmist.

19:01 (UTC+0)
Start of Level 11
Blinds: 3,000/6,000     Ante: 6,000
Ja ongi dinner break Posted Friday 28th July, 2023 at 18:03(UTC+0) by Mariliis Joras

Enne pausi läks, nagu arvata võis, rüseluseks. 

Oma nuppudest jäid ilma nii Pasi Sormunen kui Roope Tarmi. Viimane tegi küll kiire re-entry ja on nüüd konkurentsis tagasi.

Kui kell tiksus nulli, kuulutati välja kolm viimast re-entry kätt ja täpselt kolmanda käega sai otsa ka Markkos Ladevi mäng.

Ta lükkab -ga, sest callida võib teda üksnes BB-l istuv Jukka Ylitalo. Jukka seda ka teeb, pannes vastu .

Esialgu saab kahele pihta Markkos, kuid seejärel hitib Jukka kuut. 

Hetkel jääb eestlaste au kaitsma Ottomar Ladva. Kuid võimalik, et pausi jooksul lisandub meie mängijaid veel. 

Late reg on avatud kella 21-ni.

Player Chips Progress
Ottomar Ladva 248,500 132,500
Markkos Ladev 0 0
Toimub eestlaste rappimine Posted Friday 28th July, 2023 at 17:42(UTC+0) by Mariliis Joras

Oleme sihikul.

All-ini satub Ahto Kingsepp ja enne floppi, nii nagu Priit Parmasto paar minutit varem.

tabab riveris küll soldatit, kuid Andrius Bielskis mängib kuningate pocketiga ja see hoiab.

Player Chips Progress
Ahto Kingsepp 0 0
Kaotame Priidu Posted Friday 28th July, 2023 at 17:39(UTC+0) by Mariliis Joras

Priit Parmasto on pre-flop all-inis üheksate pocketiga. Vastas Max Avela -ga. 

Lauda

Kahjuks on vastasel nuppe rohkem.

Player Chips Progress
Priit Parmasto 0 0
Pasi saab oma koosa Posted Friday 28th July, 2023 at 17:35(UTC+0) by Mariliis Joras

Pasi Sormunen loputas küll Markkos Ladevit, aga sai kohe ka ise hoobi.

boardil.

Andrius Bielskis shoveb 80 000, ka pangas on juba väga palju žetoone.

Pasi otsustab callida.

Andriuse on floppi tabanud ideaalselt.

Pasi tähtsusetu.

Äsja võidetud suur koorem tuleb edasi anda. Loodame, et see jõuab rigniga ka mõne meie meheni. Lisaks Markkosele istub samas lauas Ahto Kingsepp.

17:32 (UTC+0)
Start of Level 10
Blinds: 2,000/5,000     Ante: 5,000
Vot see on valus Posted Friday 28th July, 2023 at 17:30(UTC+0) by Mariliis Joras

Andrius Bielskis teeb miinimumntõste, et 8000 eest floppi näha. Pasi Sormunen kõigest callib. Markkos Ladev buttonil teeb tõste 29 000 ja jääb Pasiga kahekesi.

flopis, mis checkitakse läbi.

Turn ja Pasi betib 20 000. Markkos calllib.

River toob Pasilt 75 000. Sellega paneb ta Markkose proovile, kuid viimane on teadupärast kartmatu. 

Markkose call on väga valus, sest Pasi näitab

Markkose kaarte me ei näe. Järele jääb nüüd väga vähe nuppe...

Ottomar saab ohvri Posted Friday 28th July, 2023 at 17:16(UTC+0) by Mariliis Joras

Ottomar Ladva käes on parem kui vastase .

See tähendab kehvema kaardiga mängijale bustimist. 

Tema iste saab kohe uue omaniku - Juha Helppi on tagasi.

Player Chips Progress
Juha Ilmari Helppi 100,000 0
Helppi vabastab istme Posted Friday 28th July, 2023 at 17:10(UTC+0) by Mariliis Joras

Juha Helppi viimaseks käeks jääb üheksate pocket. 

Vastas Robert Rohr -ga, mis tabab runner-runner masti.

Kogenud pokkerimängijana ei tee Juha teist nägugi. Õigemini teeb ta naerunäo. Aga on ka meest tagasi turniirile oodata?

Player Chips Progress
Juha Ilmari Helppi 0 0
16:56 (UTC+0)
Start of Level 9
Blinds: 2,000/5,000     Ante: 5,000
Priit kühveldab rohelisi Posted Friday 28th July, 2023 at 16:53(UTC+0) by Mariliis Joras

Rohelised chipid on väärt 25 000. Ja neid saab Priit Parmasto juurde.

Üsna kulukaks läheb jaotus boardiga Jani Tuovinenile.

Priidu tabab hästi.

100k piir kenasti ületatud Posted Friday 28th July, 2023 at 16:48(UTC+0) by Mariliis Joras

Juba 25 sisseostu on turniirile tehtud ja auhinnafondis julgelt üle 100 000 euro. Võimalik, et kohe on sisseoste 26, sest Markkos Ladev võttis äsja Roope Tarmi välja. 

Laual oli , kui nupud sisse saadi.

Roopel ja Markkosel

River jättis Markkose kaks paari mängima ja soomlane out. 

Player Chips Progress
Roope O. O. Tarmi 0 0
Rikkad ei nuta Posted Friday 28th July, 2023 at 16:38(UTC+0) by Mariliis Joras

Nad haaravad rinnataskust järgmise 5k ja naasevad lauda. 

Jussi Mattila viimane käsi

Casper Schantzil samal ajal

Lauakaardid tühised ja Jussi viimased 32 500 lähevad Casperile.

Oma kolmanda bulleti on lendu lasknud Markkos Ladev.

Rasked otsused Posted Friday 28th July, 2023 at 16:32(UTC+0) by Mariliis Joras

Ahto Kingsepal on keeruline. 

Flop ja Andrius Bielskis betib. Ahtolt call.

Turn ja Andrius shoveb. Tal on 72 500 nuppu. Ahtol endal ca 10 000 võrra rohkem. Umbes sama palju on ka pangas. 

Mida teha? 

Ahto veeretab käes -d ja ei suuda otsustada. 

Kuigi siin mängus antakse otsustamiseks aega, ütleb ühel lauakaaslasel lõpuks närv üles ja ta kutsub aja välja. Selle kasutab Ahto lõpuni ja foldib oma kaardid siis lahtiselt. 

Kas Andrius hingab kergendatult või oleks ta tegelikult calli soovinud, me teada ei saagi.

16:22 (UTC+0)
Start of Level 8
Blinds: 2,000/4,000     Ante: 4,000
Ja ongi back Posted Friday 28th July, 2023 at 16:20(UTC+0) by Mariliis Joras

Nii Markkos Ladev kui Roope Tarmi on tagasi mängus. 

Player Chips Progress
Roope O. O. Tarmi 100,000 0
Markkos Ladev 72,200 0
BRB Posted Friday 28th July, 2023 at 16:18(UTC+0) by Mariliis Joras

Casper Schantz avab 5000. Roope Tarmi callib. Jussi Mattila callib ja tegelikult noolivad nad kõik BB-l istuva Markkos Ladevi skalpi. Vahepeal on Markkos kukkunud 16 000 peale. 

Markkos vaatab oma kaarti ja shovebki. 

Nonii, Casper callib. Ja kõigile üllatuseks vajutab calli ka Roope. Jussi on ainus soomlane, kes putku paneb.

Markkosel (üks risti)

Roopel

Casperil

Jussi rikub tuju, teatades, et tema foldis kuued.

Boardilt abi ei tulegi:

Markkos on juba lauast püsti tõusnud ja teatab: "Be right back."

Ka Roope ässad on ribadeks.

Player Chips Progress
Roope O. O. Tarmi 0 0
Markkos Ladev 0 0
Uus hingamine Posted Friday 28th July, 2023 at 16:09(UTC+0) by Mariliis Joras

"Kuidas läheb?" uurib Jussi Mattila, nn eestlaste laua värskeim liige. 

"Mitte eriti hästi," vastab Ottomar Ladva.

"Miks?" küsitakse vastu.

"Liiga passiivne laud," kurdab Ottomar. 

Jussi lubab, et see kõik on kohe muutumas, sest tema on ometigi lauas. Kohe hõikab ta kohale baaridaami ja asub uurima, kellele viina tellida. Kuna kõigil on viinad juba olemas, palutakse baaridaamil alles mõne aja pärast uuesti tagasi tulla.

Jussi mängib oma esimese käe, tehes pre-flopis tõste 6000. Nüüd läheb Markkos Ladev 66 000-ga all-ini ja Jussil on võimalus oma agressiivsust demonstreerida. 

Aga see hetk ei ole veel saabunud. Esialgu fold.

Player Chips Progress
Jussi P. K. Mattila 100,000 0
15:51 (UTC+0)
Start of Level 6
Blinds: 1,000/2,500     Ante: 2,500
Mängijad pausil Posted Friday 28th July, 2023 at 15:39(UTC+0) by Mariliis Joras

Algas päeva esimene paus. 

Selliste stäkkidega lähevad meie mehed puhkust pidama.

Player Chips Progress
Priit Parmasto 145,000 45,000
Ottomar Ladva 116,000 16,000
Ahto Kingsepp 115,400 15,400
Markkos Ladev 72,200 27,800
Saab duubli Posted Friday 28th July, 2023 at 15:36(UTC+0) by Mariliis Joras

Ottomar Ladva on endiselt stäki suurendamisega ametis. 

CO-lt teeb ta tõste 4500 ja saab calli buttonil istuvalt Casper Schantzilt. 

Flopis

Ottomar check-raiseb Casperi 5000 hoopis 15 500 peale. Läheb korda. 

Turn toob mõlemalt mehelt veel 13 500 panka, ikka Ottomari soovil.

River ja nüüd Ottomar all-inis. Casperist seekord callijat pole. 

Teised mehed kõrvalt aga kõkutavad, et see jaotus oligi praktiliselt nagu duubel.

Viimaks ka mõni showdown Posted Friday 28th July, 2023 at 15:25(UTC+0) by Mariliis Joras

Mäng on tempo maha võtnud ja ei näe me suuri panuseid ega ka showdowne. 

Üks siiski tuleb. 

Flopis betib Casper Schantz ja saab Ottomar Ladvalt calli.

Turn checkitakse läbi.

River ja Ottomar küsib 6500. Casper vajab väikest mõttepausi, kuid callib ikkagi ära.

See Ottomarile meeldib. Kiirelt kaardid lahti ja näeme -ga riverdatud rida. 

Stäkk sai väikse lisa.

15:02 (UTC+0)
Start of Level 5
Blinds: 1,000/2,000     Ante: 2,000
Ottomar proovib tagasi teenida Posted Friday 28th July, 2023 at 15:01(UTC+0) by Mariliis Joras

Ottomar Ladva stäkk on mõneti kokku kuivanud. 25 000 väärtusega žetoone on tal ainult üks. Aga töö stäki kasvatamise nimel käib. 

Praegusel tasemel ei ole pre-flopi tõsted 15 000 ja rohkemgi mingi haruldus. Mõnikord saadakse ka actionit, kuid mõnikord raugeb kõik turnis-riveris. 

Vahepeal on mänguga liitunud veel üks soomlane, kuid osalejate arvult oleme hetkel 12 peale pidama jäänud.

Üks konkurent taas vähem Posted Friday 28th July, 2023 at 14:41(UTC+0) by Mariliis Joras

Hollandlane Michel Molenaar on tänaseks lõpetanud. 

Tal, nagu kõigil teistelgi, on veel aega end uuesti sisse osta, kui selleks peaks soovi olema. Late reg ja re-entry periood kestab 8. taseme lõpuni. Siis algab õhtusöögipaus. Muide, õhtusöök on kõrgelennulistele täna tasuta. 

Nende hüvanguks, kes soovivad turniiriga liituda vahetult enne late regi lõppu, on tänane struktuur tehtud tavapärasest erinev. Nimelt korratakse pärast pausi levelit 2500/5000/5000. Seda selleks, et alles mängu alustanutel oleks stardipakul 20BB-d.

Player Chips Progress
Michel J.M Molenaar 0 0
Eesti lauda seguneb soomlane Posted Friday 28th July, 2023 at 14:38(UTC+0) by Mariliis Joras

Roope Tarmi ei ole siinsele rahvale sugugi tundmatu mängija. Igal suurfestivalil on ta kohal. Nii tänagi. 

Priit Parmasto selja taha ilmub aga üks vari, kes surub käed õlgadele ja kukub masseerima. "Ranno," pakub Priit nägemata, kellega tegu. Ja ta ei eksi. 

"Miks sa main'i mängima ei tulnud?" küsib Ranno sõbralt. "Netis oli liiga hea run," ütleb Priit. Nüüd siis teame meiegi.

Player Chips Progress
Roope O. O. Tarmi 100,000 0
14:35 (UTC+0)
Start of Level 4
Blinds: 800/1,600     Ante: 1,600
Kui suurelt, siis suurelt Posted Friday 28th July, 2023 at 14:34(UTC+0) by Mariliis Joras

Ahto Kingsepp teeb tavapärase tõste 2400. Ottomar Ladval on ulakas tuju - raise 11 000. Ahtot see ei heiduta. 

Flop

Ottomar jätkab 5500-ga ja  Ahto kaasas. 

Turn ja hetkeks võetakse hoog maha.

River ning ootame Ottomari seisukohta. Ta loeb välja 10 000. 

Ahto callib ja saamegi meeste kaarte näha.

Ottomaril kõigest äss kõrge:

Ahtol

Vot nii mängivad suured poisid.

Pirakas pank läheb Ahtole.

Priit võtab tagasi Posted Friday 28th July, 2023 at 14:23(UTC+0) by Mariliis Joras

Jälle on Ahto Kingsepp ja Priit Parmasto vastakuti. 

Floppi vaadatakse 2400 eest.

checkitakse läbi. 

Turn toob Priidult beti 1800 ja Ahto callib.

River ja Priit küsib 5500. Kui Ahto tõstaks 12 000 peale, tekiks lausa väike deja vu. Aga Ahto piirdub calliga. 

"Full house," ütleb Priit, kui näitab

Ahtol maja pole, tema näitab ühte kaarti, milleks . Oli tabamus temalgi.

Lisandub Soome verd Posted Friday 28th July, 2023 at 14:17(UTC+0) by Mariliis Joras

Juha Helppi oli turniiriliste seast veel puudu. See viga sai äsja parandatud.

Player Chips Progress
Juha Ilmari Helppi 100,000 0
Korralik flop Posted Friday 28th July, 2023 at 14:15(UTC+0) by Mariliis Joras

Ahto Kingsepp ja Priit Parmasto vaatavad 2500 eest floppi. 

maha ja see checkitakse läbi. 

Turn ja mõlemad checkivad uuesti. 

River toob Priidult 5500, kuid nüüd elavneb ka Ahto, bettides 12 000. Priit vaatab oma stäkki ja leiab, et praegu veel võib. Call!

Ahto avab , olles flopanud rea. Sellest panga võitmiseks piisab. Nice hand, kiidab ka Priit.

Teame juba ette, et mänguga on liituma oodata ka Ottomar Ladvat. Aga kas temagi tuuakse siia eestlaste lauda?

Jah, täpselt nii. Meil on turniiril neli eestlast ja kõik nad on tõstetud ühte lauda. 

Ahto Kingespp

Player Chips Progress
Ottomar Ladva 100,000 0
14:10 (UTC+0)
Start of Level 3
Blinds: 600/1,200     Ante: 1,200
Rahvast tuli juurde Posted Friday 28th July, 2023 at 14:01(UTC+0) by Mariliis Joras

Nüüd saame käia kahe laua tegemisi jälgimas. 

Tere tulemast, Markkos Ladev ja Priit Parmasto!

Player Chips Progress
Priit Parmasto 100,000 0
Markkos Ladev 100,000 0
Ja ongi üks väljas Posted Friday 28th July, 2023 at 13:59(UTC+0) by Mariliis Joras

Jõuame laua juurde hetkel, kui kogu board on avatud:

Jube kahju, et ei näinud, kuidas asi sinna jõudis, kuid pangas on ligi 70 000 chippi ja Sondre Stormyr on pärast Robert Rohri checki all-ini liikunud. 

Showdown maksab juba niigi kõvasti kõmmutanud Robertile ca 40 000 nuppu. 

Mees ragistab ajusid, nii et terve saal kajab. Keegi teda tagant ei kiirusta, sest otsus on tõesti oluline. 

Ja näemegi calli! Jess!

Kaardid selili: Sondrel -ga bluff.

Robertil

Player Chips Progress
Sondre Stormyr 0 0
Kui palju osalejaid tuleb? Posted Friday 28th July, 2023 at 13:52(UTC+0) by Mariliis Joras

Kas sina oskad arvata?

Korraldusliku tiimi arvates võiks lõpuks 20 mängijat kokku tiksuda. 

Kuuenda tulijana potsatab lauda hollandlane Michel Molenaar.

Player Chips Progress
Michel J.M Molenaar 100,000 0
Pocketeid liigub Posted Friday 28th July, 2023 at 13:50(UTC+0) by Mariliis Joras

Ahto Kingsepp teeb ületõste ja määrab flopi hinnaks 6000. Robert Rohrile see sobib. 

Board chechitakse läbi kuni turnini. 

Viimasel tänaval küsib Robert 2800 ja selle ta ka saab, sest Ahto ei paista olevat foldija mees.

Roberti paneb Ahto aga muckima.

Uusi mängijaid on praeguse seisuga lisandunud vaid üks. Andrius Bielskis on samuti istet võtnud. 

Põhiturniirilt kukkus välja Igor Pihela Sn, mis võib aga tähendada, et saame peagi ühe Eesti mängija juurde.

13:46 (UTC+0)
Start of Level 2
Blinds: 500/1,000     Ante: 1,000
Neljas mees ka lauas Posted Friday 28th July, 2023 at 13:31(UTC+0) by Mariliis Joras

Kolme mängijaga oleme juba tuttavad, aga neljas saabub väikse hilinemisega. Siiski enne esimese taseme lõppu. 

Lõbus sakslane Robert Rohr tervitab kaasvõitlejaid ja liitub actioniga. 

Sondre on hoos Posted Friday 28th July, 2023 at 13:29(UTC+0) by Mariliis Joras

Sondre Stormyr tõstab buttonilt 1700, callib Ahto Kingsepp BB-lt. 

Flop checkitakse läbi. 

Turn ja Ahto checkib. Sondrelt 2200 ja Ahto callib. 

River ja nüüd on Sondre juba enesekindlam. Kui Ahto checkib, tuleb Sondrelt 5500 lauda. Ahto otsustab maksta. 

Sondre avab ja siia pole Ahtol midagi vastu panna. Muck.

Saab ka kolmekesi Posted Friday 28th July, 2023 at 13:22(UTC+0) by Mariliis Joras

Üks mängijatest ei ole lauda veel jõudnudki, kuid see ei tähenda, et käiks miski fold-fest. Mäng on mõnusalt lahtine. 

SB-l istuv Sondre Stormyr limbib ja BB Anders Bjronsen laseb sellel juhtuda. Ahto Kingsepp ei osale. 

Flop

Sondre betib 1200 ja saab calli. 

Turn ja nüüd Sondre checkib.

Kui Anders betib 2000, siis püüab Sondre tõstega panka kätte saada, kuid Andersi jaoks ei ole probleem nõutud 4700 maksta. 

River on Sondrele tõsiselt halb, sest oma -ga on ta nüüd kahte paari tabanud. 

Bet 4400 lauda ja Anders snäpib. Arusaadav, miks - tal

Selge see, et kõrgemad kaks paari on Andersil ja see mahlane pank läheb talle.

13:11 (UTC+0)
Start of Level 1
Blinds: 400/800     Ante: 800
Eriti High rollerid alustavad Posted Friday 28th July, 2023 at 13:09(UTC+0) by Mariliis Joras

Tere kõigile!

Oleme jõudnud festivali kõige kallima turniirini - tervelt 5000 eurot tuleb välja käia neil, kes soovivad osa saada High roller 6max turniirist. 

Kuigi turniirikell on juba kõlanud, käib mäng hetkel kõigest nelja mehe vahel.  Kas neljast keegi on ka eestlane? Väga hea küsimus, aitäh küsijale. 

Ahto Kingsepp on selline kodumaine nimi, kelle osalejate nimekirjast leiame. Kohe läheme uurima, kuidas Ahtol läheb. 

13:00 (UTC+0)
Day 1 of Kings of Tallinn Summer Showdown 2023 Started
Level:      Blinds: 0/0     Ante: 0
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.