0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0076 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-22' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/134/316/updates' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/134/316/updates', 1, '2024-12-22')

0.0003 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` = '134'

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

0.0293 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0065 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '316' AND `published` = 1

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

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

0.0311 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` = '322' AND `published` = 1

0.0280 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0062 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '325' AND `published` = 1

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

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

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

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

0.0069 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '14025' 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` = '14024' 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` = '14023' 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` = '14022' 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` = '14021' 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` = '14020' 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` = '14019' 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` = '14018' 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` = '14017' 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` = '14016' 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` = '14015' 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` = '14014' ORDER BY `chip_change` DESC, `busted` ASC

0.0095 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '14013' 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` = '14012' 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` = '14011' 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` = '14009' 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` = '14008' 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` = '14007' 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` = '14006' 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` = '14005' 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` = '14004' 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` = '14003' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '14001' 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` = '14000' 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` = '13999' 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` = '13998' 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` = '13997' 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` = '13996' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0070 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '13990' 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` = '13989' 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` = '13988' 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` = '13987' 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` = '13986' 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` = '13985' 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` = '13984' 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` = '13983' 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` = '13982' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '14012' 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` = '14011' 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` = '14009' 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` = '14008' 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` = '14007' 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` = '14006' 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` = '14005' 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` = '14004' 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` = '14003' 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` = '14002' 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` = '14001' 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` = '14000' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '13999' 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` = '13998' 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` = '13997' 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` = '13996' 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` = '13995' 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` = '13994' 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` = '13993' 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` = '13992' 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` = '13991' 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` = '13990' 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` = '13989' 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` = '13988' 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` = '13987' 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` = '13986' 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` = '13985' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

Translate
Olympic Park Casino Event #1: €250 No-Limit Hold'em (Estonian) Live Reporting - Day 2

Current Level 30 Current Day 2
Blinds 40,000/80,000 Ante 80,000
Entries 788 Remaining 1
Prize Pool (EUR) €166,426 First Prize (EUR) €0
1 New Update - Click to refresh
Live Updates - Day 1A
Eestlaste lõplik chipcount (1A) Posted Friday 19th July, 2024 at 22:02(UTC+3) by maheaaatom

Teise päeva pääses 74 mängijat, nende seas 27 eestlast. Suurim stäkk on prantslasel Anthony C. M. Lesoismier-Geniaux'l (169 900), Janek Hin on 104 500-ga kolmas.

Player Chips Progress
Janek Hin 104,500 10,500
Magnus Pukk 90,200 5,200
Mark Metsla 87,300 27,300
Taago Tamm 86,000 9,000
Andrei Mjagkov 78,700 11,700
Lauri Laast 74,800 0
Artur Mäeots 66,700 0
Joonas Kulli 61,500 0
Bahtijar Kulijev 61,000 0
Siim Suviste 58,800 9,200
Kaspar Laursoo 56,300 14,300
Karl-Henri Lauri 54,500 0
Tom Richard Teslon 47,700 0
Tanel Evert 44,900 3,100
Hendrik Uibo 41,100 19,900
Roman Jezov 38,000 7,000
Sergei Kuznetsov 36,000 0
Kaidar Viikman 36,000 27,000
Maksim Petrov 32,000 0
Maksim Paponov 29,100 0
Vitali Rakov 22,000 0
Allan Arjut 21,300 0
Ramon Randma 19,100 0
Madis Ormisson 18,000 0
Priit Valgma 14,600 0
Pavel Solodovnikov 14,200 0
Maksim Onutsin 9,500 0
Taago korjab "Batult" tagasi Posted Friday 19th July, 2024 at 21:32(UTC+3) by maheaaatom

Taago Tamm panustab kõik tänavad ning saab Bahtijarilt kolm järjekindlat calli.

Riveriks on laual ning Taagol on au esimesena avada.

on igati piisav ning umbes 25K pank läheb Taagole. 

Ühtlasi hakatakse chippe kottidesse pakkima ning peagi avaldame kõikide allesjäänud eestlaste täpsed stäkid.

"Batule" hiline duubel Posted Friday 19th July, 2024 at 21:27(UTC+3) by maheaaatom

Mängitakse endiselt viimaseid käsi ning shortstäkkidel tuleb proovida. Eriti kui veel häid kaarte ka jagatakse.

Eestlaste omavahelises all-in'is on Bahtijar Kulijev vastamisi (kelle muu kui) Taago Tammega - "Batul" emandad ja Taagol mustad kaheksad.

Turniks saab Taago veel mastitõmbe, kuid river jätab 20 300 stäkiga Bahtijari ikkagi ellu ning toob vajaliku duubli. Taago endisest superstäkist polegi enam teab kui palju alles...

Hämmastav vaikus Posted Friday 19th July, 2024 at 21:19(UTC+3) by maheaaatom

Mängusaalis on endiselt sadakond inimest, kuid valitseb harukordne vaikus, millesarnast ei mäleta juba väga pikka aega, eriti kui arvestada veel seda, et tegemist on ikkagi reede õhtuga. Kostab vaid chippide klõbinat, ka table-talk'i pole pea üldse.

Paistab, et baari joogikäive on täna ikka väga madal. Kõik võib muidugi veel muutuda, kui algab päev 1B.

Ühtlasi algas viie viimase käe jagamine.

Karl-Henri pääses riveriga Posted Friday 19th July, 2024 at 21:07(UTC+3) by maheaaatom

Modestas Kryzanauskas ning Karl-Henri Lauri võtsid flipi, kus eestlasel ja leedulasel .

Modestas juhtis kuni riverini, kus avati Karl-Henrile päästev äss. Meie mehel umbes 14K, leedulasel napilt enam. Jätkab 82 parimat.

21:00 (UTC+3)
Start of Level 10
Blinds: 500/1,000     Ante: 1,000
Stanislavi hapu all-in Posted Friday 19th July, 2024 at 21:00(UTC+3) by maheaaatom

Pärast lauas avatud kaarte olid kolm meest all-in, nende seas ka meie Stanislav Smeljov. Stanislav avas , olles sellega paraku drawing dead ja vastu. Rida jäigi püsima ning selle omanik - prantslane Anthony C. M. Lesoismier-Geniaux - haaras võidurõõmsalt telefoni, et edukast võidukäest pilti teha.

Algas päeva viimane mängutase.

Natuke lisa Kaidarile Posted Friday 19th July, 2024 at 20:52(UTC+3) by maheaaatom

Juri Verbitski 11K all-in'ile tuli call Kaidar Viikmanilt ning mõlemad näitasid ärtu masti tõmmet.

Juri:

Kaidar:

Muide - flopis oligi kaks ärtut ja lõpuks tuligi mast maha! Oleks Juril suurem stäkk olnud, võinuksime näha juba väga suurt all-in'i. 

Eestlaste stäkke Posted Friday 19th July, 2024 at 20:45(UTC+3) by maheaaatom

Kahjuks on ka mõningaid langejaid, näiteks oleme ilma Siiri Saarest (Eesti naisi seega päeval 1A enam sees ei ole).

Player Chips Progress
Janek Hin 115,000 55,000
Magnus Pukk 85,000 5,000
Taago Tamm 77,000 20,000
Siim Suviste 68,000 0
Mark Metsla 60,000 0
1A viimane mängutund algas Posted Friday 19th July, 2024 at 20:33(UTC+3) by maheaaatom

94 allesjäänud pokkerisportlast on tagasi laudades ning action jätkub. Täna on mängida veel 60 minutit ning keskmine stäkk hetkel umbes 40XBB kandis. 

Kes soovivad, võivad veel liituda, kuid kes mitte - neil on võimalik alustada päeva 1B kell 21:00. 

20:32 (UTC+3)
Start of Level 9
Blinds: 400/800     Ante: 800
Janek, big ballsevitch! Posted Friday 19th July, 2024 at 20:19(UTC+3) by maheaaatom

Kaidar Viikman tõstab CO-lt 1600, Taago Tamm callib ning Janek Hin kolmpanustab BB-lt 4600. Mõlemad eestlased callivad.

Flopis avatakse ning Janek alustab 3500-ga. Kaidarilt kiire fold, Taago callib.

Turn on , Janek seekord checkib ning callib üsna kiirelt Taago 6600 panust.

Riverisse avatakse , Janekilt taas call ning Taago ründab 9500-ga. Janek ei anna alla. 

Taago foldib kinniselt blufi, Janek avab

Vinge käsi, mida saadab "Batu" hüüe: "Janek, big ballsevitch!"

Ühtlasi algas ka päeva 1B teine paus, puhast mänguaega on jäänud veel tund.

P.S. Päeva viimase käega kaotasime Kristjan Laasi, kelle stäki omistas Mark Metsla.

Freebuy-satelliit on lõppenud Posted Friday 19th July, 2024 at 20:07(UTC+3) by maheaaatom

Lubatud seitsme pileti asemel paisus freebuy-satelliidi auhinnafond hulga rebuyde toel 17 piletini.

Pileti lunastas üheksa eestlast, nende seas ka näiteks selline staar nagu Allan Arjut. Palju õnne! Üks satelliit tuleb täna veel - kell 23:00 algab 555 € NLH satelliit, mille sisseost on 80 eurot ning garantiiks 10 piletit.

20:01 (UTC+3)
Start of Level 8
Blinds: 400/800     Ante: 800
Andrei pääseb kuningatega Posted Friday 19th July, 2024 at 20:00(UTC+3) by maheaaatom

Andrei Mjagkov kaotas vahepealse mänguga suure osa oma stäkist, kuid suutis seejärel kenasti kõik tagasi saada.

Käsi järgmine - floppi vaatasid Andrei ja Enea Subashi.

Enea checkis ette, Andrei pani 4000 ning Enea tõstis 10 000 peale. Andrei mõtles väga pikalt ning teatas seejärel, et on all-in (21 600). Enealt call.

Andrei:

Enea:

Meie mehe õnneks oli laud talle armuline ning turn ega river masti maha ei toonud.

Suuremate stäkkidega eestlasi Posted Friday 19th July, 2024 at 19:56(UTC+3) by maheaaatom
Player Chips Progress
Taago Tamm 97,000 12,000
Magnus Pukk 90,000 23,000
Kaidar Viikman 63,000 0
Hendrik Uibo 61,000 4,000
Janek Hin 60,000 0
Tom Richard Telson 58,500 0
Kristjan Laas 48,000 0
Tanel Evert 48,000 0
Roman Jezov 45,000 0
Kaspar Laursoo 42,000 0
Ka kolmed oleksid splitis osalenud Posted Friday 19th July, 2024 at 19:46(UTC+3) by maheaaatom

Tom Richard Teslon avab 1500-ga, saab calli tema järel istuvalt Ramon Randmalt ning all-in panuse (umbes 12K) ameeriklaselt Addy Bassanilt. 

Tom Richard (umbes 60K) stäkk leiab, et seda on pisut palju, samuti ei taha ta n.ö. "võileiva vahele jääda". Aga Ramon callib ära. 

Mõlemal on , flopis avatakse ning väidetavalt kolme pocketit omanud Tom Richard hingab kergendatult. 

Aga turn ja river ning laud mängib.

Mida suudavad leedulased? Posted Friday 19th July, 2024 at 19:38(UTC+3) by maheaaatom

Talvisel Kings of Tallinnal andsid tooni Leedu pokkerimängijad, kes said ka põhiturniiril koguni kaksikvõidu.

WSOP Circuit'il osaleb neid tõenäoliselt siiski pisut vähem ning lootused pole ülearu kõrged. Küll mängis üsna palju Leedu mängijaid kaasa äsja Las Vegases lõppenud "suurel WSOP-l", kus õnnestus võita kaks käevõru, mõlemad seejuures hyper-turnadel. 

Kui Eestil on üks WSOP käevõru, siis leedulastel koguni üheksa. Tõsi, enamus on saadud online-turniiridel.

Kas WSOP Circuit'ile saab ka panustada? Saab ikka! Posted Friday 19th July, 2024 at 19:34(UTC+3) by maheaaatom

WSOP Circuit põhiturniirile on võimalik ka panuseid teha ning kus mujal kui OlyBetis. 

Mõned huvitavad koefid ka:

  • Eestlane võidab 2,75
  • Parim eestlane saab parima koha kui parim soomlane 2,00
  • Ranno Sootla saab finaallauda 20,0
  • Herli Olop saab finaallauda 50,0 
Siiri ootab teist päeva Posted Friday 19th July, 2024 at 19:15(UTC+3) by maheaaatom

Eesti üks paremaid naismängijaid Siiri Saar kurdab kehva kaardijooksu üle ning tõdeb, et natuke igav on mängida. "Kahel korral olen pidanud vastase 3-beti peale pocket kümned foldima ning mõlemal korral olen ka õigesti teinud," tõdeb Siiri. 

"Võiks juba teine päev tulla, siis saaks mängima hakata!" Siiril on umbes algstäkk (20K).

19:12 (UTC+3)
Start of Level 7
Blinds: 300/600     Ante: 600
Tõmme tõmbe vastu, kumbki ei taba Posted Friday 19th July, 2024 at 19:10(UTC+3) by maheaaatom

Turniks on lauas ning pangas umbes 6K. 

Roman Jezov teeb 5200 panuse ning saab omajagu mõelnud Kristjan Laasilt calli. 

River on ning Roman enam panustamiseks jõudu ei leia. Ka Kristjan otsustab checkida, küll sellise ilmega, et seda panka ma nagunii ei võida.

Põhjust selleks ju on, sest Kristjan () püüdis ebaõnnestunult rida ning kuningas-kõrgega midagi hõisata just pole. 

Aga...Ka Romanil polnud midagi enamat kui mööda läinud mastitõmme (! Korralik pank hinnatud pokkerikommentaarile.  

"Rahvaturniirile" ennustatakse kuuekohalist auhinnafondi Posted Friday 19th July, 2024 at 19:01(UTC+3) by maheaaatom

250 € NLH-l on neli avapäeva ning hiline registeerumine on avatud kuni teise päeva teise taseme lõpuni (pühapäeval umbes kell 13:00). 

Päeva 1A on alustanud 146 mängijat ning kõik, kes välja langevad, saavad alati minna uuele katsele kas samal, mõnel järgmisel avapäeval või teisel päeval. Selleks, et auhinnafond oleks kuuekohaline, oleks nõutav umbkaudu 500 sisseostu, mis tundub hetkeseisuga vägagi reaalne number, eriti arvestades asjaolu, et üritus ju alle kogub hoogu. 

See tähendaks võitjale päris magusat palgapäeva ning lisaks auhinnarahale on ju mängus ka festivali esimene kuldsõrmus. 

Teleülekannete kava Posted Friday 19th July, 2024 at 18:54(UTC+3) by maheaaatom

TV-ülekanded on kavas neljast turniirist ning neid saab nautida alates teisipäevast (iga päev üks turniir):

  • Naisteturniiri finaal
  • 555 € NLH finaal
  • 1100 € PLO finaal
  • 1500 € põhiturniir 
18:47 (UTC+3)
Start of Level 6
Blinds: 200/500     Ante: 500
Taneli riskantne panus maksis 250 eurot Posted Friday 19th July, 2024 at 18:39(UTC+3) by maheaaatom

Tanel Evert läks buttonilt blindide järele ning kui Magnus Pukk talle 3K ületõstega vastas, lükkas Tanelo oma nupud kiirelt keskele. "Ma arvasin, et ta nagunii foldib," oli Tanel kindel. 

Aga loodetud foldi asemel Magnus hoopis snapcallis ning seis on Tanelile kõike muud kui hea.

Magnus:

Tanel:

Laud tühi ning Tanelil tuli re-entry järele minna.

Taagol juba 85K, ka Hendrik on alustanud kenasti Posted Friday 19th July, 2024 at 18:37(UTC+3) by maheaaatom

Taago Tamm on suutnud oma stäkiga juba 85K peale kergitada ning virised ei saa ka Hendrik Uibo (57K). 

"Normaalne algus," kõlab Hendriku lühike kommentaar. Väärib mäletamist, et Hendrik tegi endale nime just mullusel WSOP Circuit Tallinn põhiturniiril, mida mees mõnda aega ka juhtis. Lõpuks sai "noor püss" lisaks väärt kogemusele 14. koha ning lubas, et küllap kuuleme me temast veel. Kindlasti kuuleme!

Player Chips Progress
Taago Tamm 85,000 44,000
Hendrik Uibo 57,000 0
Aleksander Sebastian langeb läbi Arturi Posted Friday 19th July, 2024 at 18:26(UTC+3) by maheaaatom

Aleksander Sebastian Lattikas lükkab oma shortstäki (umbes 2,5K) all-in, tema järel teeb sama ka mulluse põhiturniiri kolmas mees Artur Külanurk.

Pisut "sügeleb" ka leedulane Liutauras Armanavicius, kuid calli siiski ei järgne. 

Artur:

Aleksander:

Lauda tuleb ka kolmas äss, kõrgem kicker peab. 

18:21 (UTC+3)
Start of Level 5
Blinds: 200/400     Ante: 400
Pausile sadakond mängijat Posted Friday 19th July, 2024 at 17:58(UTC+3) by maheaaatom

Täna on kaks pausi ning esimene neist sai just alguse. Sisseoste on hetkel tehtud 117 ning laudades sadakond mängijat. 

Satelliit on samuti pausil ning hetkel oleme jõudnud 51 parimani. Tee piletiteni on siiski veel pikk, sest neid jagub kõigest seitsmele parimale.

Kaidar Viikman: Mul pole kindlat plaani, mängin mida jõuan Posted Friday 19th July, 2024 at 17:55(UTC+3) by maheaaatom

Viiekordne Eesti meister Kaidar Viikman on nimekas hobimängija, kes suutnud 2022., 2023 kui ka 2024. aastal vähemalt ühe Eesti meistritiitli napsata.

Selleks WSOP Circuit'iks Kaidaril väga suuri plaane ei ole, mängib mida jõuab. Põhiturniiri piletit pole veel õnnestunud saada, kuid satelliite on siiski veel küllalt tulemas. Ja kindlasti on Kaidar kohal 8-Game'is, mis talle alati väga meeldib ja ka sobib. Ka "rahvaturniiril" on mees kenasti kohal ning selgelt mängule keskendunud.

Andreil 67K Posted Friday 19th July, 2024 at 17:48(UTC+3) by maheaaatom

Andrei Mjagkov on teinud oma lauas head tööd ning tõusnud juba 67K, mis on omadest üks suurimaid. 

Korraliku nupulisa sai äsja ka samas lauas istuv EMV 2024 üks edukamaid mängijaid Bahtijar Kulijev, kelle stäkk hakkas päris õhukeseks muutuma. Nüüd on mees umbes alguses tagasi.

Viljandi vs. Haapsalu Posted Friday 19th July, 2024 at 17:42(UTC+3) by maheaaatom

Tanel Evert ja Magnus Pukk on teada-tuntud live-mängijad, kes ikka ka suurturniiridel kohal. WSOP Circuit avaturniiril on mehed sattunud ühte lauda.

Tanel läheb CO-lt 700-ga ründama ning saab SB-lt Magnuse kaasa.

Flopis avatakse , Magnus checkib ette ja saab Tanelilt 500 panuse, mida ta ka callib.

Turn checkitakse läbi, riveri järel ründab juba Magnus 800-ga. Tanel väntab koheselt 3500 juurde ning saab vastu kiire foldi. Ju see äss seal ikka oli...

17:28 (UTC+3)
Start of Level 4
Blinds: 100/300     Ante: 300
Taagol 41K Posted Friday 19th July, 2024 at 17:28(UTC+3) by maheaaatom

Mulluse EMV põhiturniiri hõbemedalist ning nimekas highroller Taago Tamm (Eesti rahalisti 25. mees) on oma 20K algstäki duublisse saanud hetkel 41K peal.

"Bustinud ei ole, seega siiani kõik okei," naerab Taago ise. 

Ühtlasi oleme juba jõudnud ka saja sisseostuni, väljalangejaid on hetkel kuus. 

Esimesed langejad Posted Friday 19th July, 2024 at 17:17(UTC+3) by maheaaatom

Neli mängijat on saanud turniiriga "ühele poole", nende seas nii Sirle Puustamaa kui Joonas Kulli. 

Tagasi pole kumbki veel ostnud, kuid sellega ei pea ka kiirustama, aga on teise päeva teise mängutaseme lõpuni. Esimesel päeval mängitakse niisiis 10 x 30 minutit.

Uutest tulijatest on laudades Magnus Pukk, Mark Metsla, Rain Kandla, Tanel Evert, Kaidar Viikman ning Madis Ormisson. "Kas see on siin mänguraha laud?" küsis Madis vahetult enne lauda istumist.

Infoks cashimängijatele Posted Friday 19th July, 2024 at 17:13(UTC+3) by maheaaatom

Eelmise nädala keskel võeti pikalt paisunud rahalaudade Bad Beat Jackpot lõpuks maha ning "õnnelikuks kaotajaks" osutus nimekas highroller Rikard Relander.

Olgu siis öeldud ka käsi: Rikardil olid käes pocket emandad, vastas aga .

Lauas avati kolm ässa ning - kaotas maja ja võitis mastirida.

Rikard sai umbes 35K, käe võitja poole vähem ning kõik ülejäänud lauas istunud mängijad umbes 2500/per nägu. Bad Beat Jackpot on hetkel 47K. 

17:10 (UTC+3)
Start of Level 3
Blinds: 100/200     Ante: 200
Tutvustame ka meediatiimi Posted Friday 19th July, 2024 at 16:58(UTC+3) by maheaaatom

Olgu igaks juhuks ka öeldud, et Eesti meediatiim töötab tänavusel WSOP Circuit'il samas koosseisus, mis talvisel Kings of Tallinnal. 

Hostess on Teele, videode eest vastutav Koit, fotode eest Lenka ning blogivad Hannes ja Mariliis. Blogime nii avaturniiri, naistekat (kuni finaallauni), põhiturniiri (alates teisest päevast kuni finaallauani) ning 3000 € highrollerit (algusest lõpuni). 

Infoks neile, kes kõht tühi Posted Friday 19th July, 2024 at 16:49(UTC+3) by maheaaatom

Turniiridirektor Teresa tutvustas just mängijatele tänavust toitlustust. Kergemaid snäkke saab konverentsisaalis asuvast Olybet Bar & Grillist, vähe toekamaid sööke fuajees asuvast buffeest ning keda erutavad burgerid, friikad ja muu nn. tänavatoit, on oodatud külastama Kreutzwaldi ning Kunderi tänava nurgal asuvat food trucki. 

Kevin Amon duubeldas läbi Joonas Kulli Posted Friday 19th July, 2024 at 16:44(UTC+3) by maheaaatom

Pangas umbes 3K ning turni järel oli lauas avatud .

Kevin Amon lükkas oma viimased 4,5K keskele ning sai pikalt mõelnud Joonas Kullilt ägiseva calli.

Kevin:

Joonas:

River ei muutnud midagi, kaks paari pidas.

Mis on täna veel kavas? Posted Friday 19th July, 2024 at 16:37(UTC+3) by maheaaatom

WSOP Circuit avapäev saab olema tõenäoliselt festivali kõige rahulikum, sest kavas on üheainsa sõrmuseturniiri (250 € NLH) kaks avapäeva (teine algab kell 21:00) ning kaks satelliiti. 

Üks neist - nagu juba märgitud - on hetkel käimas (seal alles 108 parimat, pileti saab seitse) ning teine algab kell 23:00. Seal mängitakse välja vähemalt 10 x 555 € piletit ning satellidil osalemine maksab 80 eurot.

Pileteid saab ka flipates Posted Friday 19th July, 2024 at 16:32(UTC+3) by maheaaatom

Satelliidimängijad käisid äsja puhkamas ning selle ajal said soovijad ka "rahvaturniiri" piletitele flipata. Nagu ikka - lauatäis mängijaid ning võitjale pilet. Sateliiti võib muidugi edasi mängida, sest küllap kulub igaühele ka lisaelu ära.

16:31 (UTC+3)
Start of Level 2
Blinds: 100/100     Ante: 100
Tele-Siiri Posted Friday 19th July, 2024 at 16:26(UTC+3) by maheaaatom

Eesti naiste au esindavad hetkel Sirle Puustusmaa ja tänavuse EMV rahvaturniiri viies Siiri Saar, kellele see jääbki suure tõenäosusega selle aasta ainsaks sõrmuseturniiriks. Naisteka ajal tuleb tal teletööd teha ning seega saab kogu oma energia pühendada WSOP Circuit rahvaturniirile. Kerge laud Siiril just pole, tema vastas istub näiteks Artur Külanurk.

Mängu algus on väga rahulik, osalejad alles kogunevad. Vaikselt oleme jõudnud 59 alustajani, re-entry't pole veel keegi kirja saanud.

Kes on kohal 1A-l? Posted Friday 19th July, 2024 at 16:18(UTC+3) by maheaaatom

Tuntud Eesti mängijatest on laudas mullusel põhiturniiril kolmanda koha saavutanud Artur Külanurk ning lisaks temale ka mitmeid teisi tuntud nägusid:

  • Bahtijar Kulijev
  • Kristan Laas
  • Hendrik Uibo
  • Maksim Petrov
  • Siiri Saar
  • Taago Tamm

Turniir on alanud! Posted Friday 19th July, 2024 at 16:13(UTC+3) by maheaaatom

Esimesed 50 julget on laudades ning WSOP Circuit Tallinn rahvaturniiri päev 1A on läinud käima.

Juba kell ühest toimub Hiltoni suures saalis "rahvaturniiri" freebuy-satikas, kus tehtud 172 sisseostu. Overlayd veel tekkinud pole, välja jagatakse 7 piletit. Ka eestlasi on osalejate seas päris palju.

WSOP Circuit avaturniir algab reedel kell 15:00 Posted Thursday 18th July, 2024 at 22:38(UTC+3) by maheaaatom

Reedel, 19. juulil algab Olympic Park Casinos ning Hilton Park hotelli konverentsikeskuses kauaoodatud suurfestival WSOP Circuit Tallinn 2024.

Festivali avaturniiri sisseost on kõigest 250 € ning see sobib hästi ka kõigile hobimängijatele. Ootame kuuekohalist auhinnafondi ning lisaks korralikule preemiarahale ootab võitjat ka WSOP Circuit kuldsõrmus ning koht Las Vegases toimuvale WSOP meistrite turniirile.

Turniiril on neli avapäeva, neist igaüks vältab 10 taset ehk koos pausidega pisut alla kuue tunni. Reedel mängitakse 1A (kell 15:00) ja 1B (kell 21:00). Lubatud on piiramatu re-entry. Eestikeelne ülekanne kestab kuni finaallauani või kuni omad on mängus.

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.