WSOP International Circuit - Olympic Park Casino - Live Coverage

        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0078 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-18'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event1_est/1A/updates'
ORDER BY `views` DESC

0.0028 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event1_est/1A/updates', 1, '2024-11-18')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0305 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.0292 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` = '318'
AND `published` = 1

0.0288 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` = '319'
AND `published` = 1

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

0.0286 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` = '325'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '134'
AND `name` = '1A'

0.0063 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.0066 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.0278 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '14027'
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` = '14026'
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` = '14025'
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` = '14024'
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` = '14023'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0281 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '14015'
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` = '14014'
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` = '14013'
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` = '14012'
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` = '14011'
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` = '14009'
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` = '14008'
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` = '14007'
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` = '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.0280 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '14002'
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` = '14001'
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` = '14000'
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` = '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.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` = '13997'
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` = '13996'
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` = '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.0415 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '13992'
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` = '13991'
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` = '13990'
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` = '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.0088 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0128 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0401 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '13984'
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` = '13983'
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` = '13982'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0132 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0194 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.0126 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.0306 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '14027'
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` = '14026'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0129 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0129 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0128 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '14021'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0118 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0154 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '14016'
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` = '14015'
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` = '14014'
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` = '14013'
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` = '14012'
ORDER BY `chip_change` DESC, `busted` ASC

0.0278 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '14008'
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` = '14007'
ORDER BY `chip_change` DESC, `busted` ASC

0.0114 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0116 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0091 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14004'
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` = '14003'
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` = '14002'
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` = '14001'
ORDER BY `chip_change` DESC, `busted` ASC

0.0281 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '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.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` = '13997'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0278 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '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.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` = '13985'
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` = '13984'
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` = '13983'
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` = '13982'
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` = '13981'
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` = '13980'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 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.0006 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553

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

English

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

Olympic Park Casino - Live Reporting Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)

Current Level 30 Current Day 2

Blinds 40,000/80,000 Ante 80000

Entries 788 Remaining 1

Prize Pool (EUR) €166,426 First Prize (EUR) €0

Chip Leaders Day 2

1	Eriks Krumins		15,670,000

Day 1A Day 1B Day 1C Day 1D Day 2

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.

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

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.

Browse

Useful Links

Subscribe to our newsletter