0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0061 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-350RingEvent-Est/1A/updates'
ORDER BY `views` DESC
0.0002 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.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 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.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0005 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.0002 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.0061 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.0004 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` = 'WSOPCTallinn2023-350RingEvent-Est'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '27'
0.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0038 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '96'
AND `published` = 1
0.0250 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0039 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '117'
AND `published` = 1
0.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0462 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '121'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '27'
AND `name` = '1A'
0.0099 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '96'
ORDER BY `busted` ASC, `current_chips` DESC
0.0078 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` = '96'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4941'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4939'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4938'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4937'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4936'
ORDER BY `chip_change` DESC, `busted` ASC
0.0463 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4934'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4932'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4930'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4928'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4926'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4924'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4923'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4921'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4919'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0455 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4916'
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` = '4911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4908'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4906'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4905'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4899'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4896'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4893'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4890'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4884'
ORDER BY `chip_change` DESC, `busted` ASC
0.0465 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4876'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4865'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4863'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4856'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4852'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4850'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4841'
ORDER BY `chip_change` DESC, `busted` ASC
0.0462 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4836'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4832'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4829'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4826'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4823'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4822'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4821'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4820'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4819'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4818'
ORDER BY `chip_change` DESC, `busted` ASC
0.0459 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4794'
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` = '4791'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '96'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 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` = '96'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4941'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4939'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4938'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4937'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4936'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4934'
ORDER BY `chip_change` DESC, `busted` ASC
0.0464 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4932'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4930'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4928'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4926'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4924'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4923'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4921'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4919'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4916'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0465 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4908'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4906'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4905'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4899'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4896'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4893'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4890'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4884'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4876'
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` = '4874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0097 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0197 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4865'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4863'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4856'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4852'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4850'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4841'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4836'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4832'
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` = '4829'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4826'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4823'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4822'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4821'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4820'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4819'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4818'
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` = '4794'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4791'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '121'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Päeva 1A lõplik chippide seis Posted Sunday 17th September, 2023 at 17:22(UTC+0) by maheaaatom
Mängu jätkab 27 parimat, nende seas koguni 12 eestlast. Nüüd keskendume juba päevale 1B. Parim seis on vanemal Igor Pihelal, kel on turniiri teine stäkk.
Nüüd keskendume juba päevale 1B.
Player
Chips
Progress
Norkus Stanislovas Norkus
352,000
332,000
Igor Pihela vanem
329,000
309,000
Dan Korsunskyy
314,000
294,000
Kjetil Hanstvedt
306,000
286,000
Kaur Ajamaa
296,000
0
Andres leppik
241,000
221,000
Martin Piik
175,000
155,000
Tanel Merida
161,000
141,000
Artur Külanurk
130,000
110,000
Joonas Kulli
114,000
94,000
Igor Pihela noorem
101,000
81,000
Mairo Tori
87,000
67,000
Viktor Mägi
77,000
57,000
Marek Selgeveer
65,000
45,000
Priit Brikker
34,000
14,000
Mull lõhkeb üsna inetult Posted Sunday 17th September, 2023 at 17:07(UTC+0) by maheaaatom
Nedas Nanys on küll shortstack ja peabki all-in minema, kuid viis, kuidas ta välja langeb on ometi inetu.
vs.
Flop on kurjakuulutav , turn blank ning river..., mis toob masti ja lõhkab mulli.
Umbes 15 minuti pärast avaldame kõikde allesjäänud eestlaste + TOP 3 stäkid, et siirduda siis juba päeva 1B juurde.
1A natuke pikeneb Posted Sunday 17th September, 2023 at 16:53(UTC+0) by maheaaatom
Selgub, et raha jagub siiski 26, mitte 30 parimale. Kuna hetkel on 27 mängijat alles, siis tuleb veel väheke kannatada.
Et tegemist on mulliga, siis jätkub action hand-by-hand.
Järgmise Ring Eventi ootel Posted Sunday 17th September, 2023 at 16:40(UTC+0) by maheaaatom
Kell 19:00 algab Ring Event #4, mis viiakse läbi PL 2-7 Triple Draw formaadis ning pole eeldatavalt kaugeltki nii populaarne kui mistahes NLH turniir. Kõigil, kes seda formaati valdavad, tasub kindlasti kohale tulla, sest hetkel on kirjas vaid 5 mängijat. Muidugi - küll neid lisandub!
Kes on tule all? Posted Sunday 17th September, 2023 at 16:37(UTC+0) by maheaaatom
Silmnähtavalt tillukesi stäkke ei eristu, eestlastest on kõige keerulisemas seisus nimekas Kaupo Tenno, kel umbes 40K stäkk. Kuna blindid on juba 3000/6000, siis palju seda just pole.
Mõned mängijad on ajavad rohkem juttu ja võtavad asju vabalt, kui keskenduvad täielikult pokkerile. Näiteks Marek Selgeveer ja noorem Pihela, kes sattunud kõrvuti istuma. Rahadeni on täpselt kolm kohta, tõenäoliselt enam kaua ei lähe.
Tagasi 350 € turniirile Posted Sunday 17th September, 2023 at 16:29(UTC+0) by maheaaatom
Kuna päeva esimese poole tähelepanu oli suunatud Aleksei heitlusele, jäi meil kahjuks väga vähe aega 350 € turniiri päeva 1A jälgimiseks. Lubame 1B-l paremad olla.
1A on muidu lõpule väga lähedal, sest mull on vaid nelja koha kaugusel. 34 allesjäänud hulgas on 14 eestlast, nende seas näiteks mõlemad Igor Pihelad, Kaur Ajamaa, Martin Piik ja Kaupo Tenno.
Aleksei Smirnov sõidab Las Vegasesse! Posted Sunday 17th September, 2023 at 16:24(UTC+0) by maheaaatom
Santtu Leinonen (1,3M) avab 130K tõstega, Aleksei vastab all-in'iga (1,6M) ning soomlane mõtleb pikalt. Ilmselt ta teab, et saab paremal juhul vaid flipi. Aga viimaks tuleb siiski call ning puhtmatemaatiliselt oli tegemist kindlasti õige otsusega.
Leinonen:
Aleksei:
Flopis avatakse , turn on ning river . Olemas!
Sellega tegi nimekas netiproff Aleksei kindlasti ajalugu, võites live-pokkeris esimese Eesti mängijana kuldse WSOPC sõrmuse (nagu mainitud, on sellega netipokkeris varasemalt saanud hakkama ka Urmo Velvelt ja Jaanus Veste). Lisaks 27840 eurole ja sõrmusele saab Aleksei ka pääsme järgmisel suvel Las Vegases toimuvale WSOP meistrite turniirile, millel on miljodollariline garanteeritud auhinnafond.
Kõva sõna, suured õnnitlused!
Soomlane võrdustab seisu Posted Sunday 17th September, 2023 at 16:14(UTC+0) by maheaaatom
Võidust on veel vara rääkida, mehed sees enne floppi:
Aleksei:
Leinonen:
Kohe flopis ning kuigi turn on , siis riverisse kahe-oudist ei tule.
Seis üsna võrdne.
Aleksei võit oleks küll ajalooline, kuid... Posted Sunday 17th September, 2023 at 16:10(UTC+0) by maheaaatom
Igaks juhuks olgu mainitud, et kahel korral on eestlased siiski varem WSOP Circuit meistrisõrmuse võitnud, kuid mõlemal korral on see saavutatud netipokkeris.
- Urmo Velvelt 2020. aasta detsembris (sisseost 315 $, 4852 sisseostu, auhinnaraha 56 726 dollarit)
- Jaanus Veste 2021. aasta mais (sisseost 52,50 $, 6233 sisseostu, auhinnaraha 21 747 dollarit)
Kuna mõlemal korral toimus WSOP Circuit COVID-19 viiruse tõttu internetis, jäi meestel ära ka sõit Las Vegasesse. Kui Aleksei võidaks, siis oleks ta Eesti esimene live-turniiri WSOPC meister, kes pääseb ka WSOP meistrite turniirile.
Aleksei juba 3:1 ees Posted Sunday 17th September, 2023 at 15:58(UTC+0) by maheaaatom
Žetoonide seis hetkel järgmine: Aleksei 2,45M, Leinonen 865K. See on tulnud puhtalt esimese agressiivsema mängu arvelt, kaarte pole suht kummalgi olnud.
Vaikus suures saalis Posted Sunday 17th September, 2023 at 15:53(UTC+0) by maheaaatom
Mõlemad 350 € turniiri avapäevad (1A ja 1B) on saadetud puhkama ning saalis valitseb vaikus. Küll aga mitte fuajees ega telelaua ümbruses ning põhjused selleks on mõistetavad.
Aleksei on selgelt agressiivsem Posted Sunday 17th September, 2023 at 15:48(UTC+0) by maheaaatom
Aleksei (O) tõstab SB-lt 100K ja saab Leinonenilt () calli.
Flop läheb küll soomlasele pihta, kuid ta checkib. Hoopis Aleksei panustab 75K, mida Leinonen ka callib.
Turn on , soomlane checkib taas ning mastitõmbe saanud Aleksei paneb uljalt 300K. Sellele reageerib Leinonen foldiga.
Kuidas edeneb 350 € turniir? Posted Sunday 17th September, 2023 at 15:40(UTC+0) by maheaaatom
Paistab, et päeva 1A lõpp võib saabuda juba üsna pea, sest alles on vaid 40 mängijat 200-st. Lõpetatakse siis kui oleme jõudnud 30 parimani.
Aga ka 1B on populaarne - hetkel 119 sisseostu ning 102 mängijat laudades. Mõlemad heat'id on peagi jõudmas ka pausini, 1B näiteks juba kahe minuti pärast.
Lühike paus Posted Sunday 17th September, 2023 at 15:36(UTC+0) by maheaaatom
Mängijad palusid lühikest puhkust. Aleksei 2,2M, Leinonen 1,1M. Ehk siis meie mees täpselt 2:1 ees.
Aleksei võtab Pyysingu välja! Posted Sunday 17th September, 2023 at 15:30(UTC+0) by maheaaatom
Aleksei (1,6M) pressib SB-lt ja Pyysing (515K) callib BB-lt ära
Aleksei:
Pyysing:
Lauda
Heads-up algab meie mehe selges eduseisus, tal on üle kahe korra rohkem nööpe kui Leinonenil.
Stäkid Posted Sunday 17th September, 2023 at 15:25(UTC+0) by maheaaatom
Aleksei - 1,5M
Leinonen - 990K
Pyysing - 615K
Aleksei annab vanameistrile duubli Posted Sunday 17th September, 2023 at 15:23(UTC+0) by maheaaatom
Vastaseid usinalt kiusanud Aleksei läheb ka SB-lt all-in'iga Pyysingu BB järele (vastas 345K) stäkk, kuid viimane leiab ja teeb calli koheselt ära.
Alekseil on , lauda temale midagi sobivat ei jookse.
Paistab, et soomlased - eriti Leinonen - on võrreldes Alekseiga võrdlemisi passiivsed. Võib-olla ei peaks, sest stäkid pole just kuigi sügavad?
Jõujooned soomlaste vahel muutuvad Posted Sunday 17th September, 2023 at 15:11(UTC+0) by maheaaatom
Santtu Leinonen pushib ning Aki Pyysing võtab pika mõtlemise järel väljakutse vastu.
Leinonen:
Pyysing:
Lauda nii äss kui kuningas, kõrgem paar toob duubli Leinonenile. Tal nüüd 1,3M, Pyysingul jääb 490K järgi.
Kumbki soomlane pole kindlasti papist poiss ning mõlemal on pikk turniiriajalugu. Pyysingul alates 90-ndates, Leinonenil "nullindatest". Hendoni cashe on meestel vastavalt 793 ja 354 tuhat dollarit. Aleksil on vastu panna umbes 100K, kuid tegemist on selgelt ikkagi netiprofiga.
Aleksei elimineerib vastase Posted Sunday 17th September, 2023 at 14:58(UTC+0) by maheaaatom
Shortstack (400K) Josh Stewart ning Aleksei Smirno võtavad flipi.
Josh:
Aleksei:
Lauda
Alekseil nüüd 1,6M, Pyysingul umbes miljon ja Leinonenil 635K.
Nännimüük WSOP Hiltoni alumisel korrusel Posted Sunday 17th September, 2023 at 14:55(UTC+0) by maheaaatom
Kõigil, kes ihaldavad WSOP Circuit nänni (nokatseid, prille, särke, pusasid jne.) tasub tulla Hiltoni alumisele korrusele, kus on kogu festivali vältel avatud väike müügipunkt.
Hinna on meeldivalt soodsad, näiteks pusa saab kätte 50 euroga, kõik muu on veelgi odavam.
Allesjäänute stäkid 1100 € turniiril Posted Sunday 17th September, 2023 at 14:25(UTC+0) by maheaaatom
Meid eelkõige huvitav 1100 € NLH Ring Event #2 algab järgmiselt seisult. Varuge veel pisut kannatust, kuniks viivitus läbi saab ning hetkel toimuv ka TV-ülekandesse jõuab.
Aleksei Smirnov, 1 250 000 Aki Pyysing, 805 000 Santtu Leinonen, 635 000 Joshua Stewart, 580 000
1A mängitakse kuni 30 parimani Posted Sunday 17th September, 2023 at 14:20(UTC+0) by maheaaatom
1A-le kogunes 200 sisseostu ning mängitakse kuni 30 parimani. Hetkel laudades 83 mängijat.
1B-d on alustanud 53 pokkerisportlast, seal on kõik veel väga noor.
Kuna hetkel on käimas ülimalt olulised sündmused 1100 € turniiril, siis suuname hetkel oma peamise tähelepanu sellele! Vaadake ka live-ülekannet, mis (nagu blogigi) on 30-minutilise viivitusega.
WSOP-C Tallinn esimese meistrisõrmus läks Ukrainasse Posted Sunday 17th September, 2023 at 14:02(UTC+0) by maheaaatom
Äsja sai ka TV-striimis läbi 555 € turniir, mille võitis Ukraina pokkerisportlane Viacheslav Sultanov.
Mehed olid eelnevalt teinud ka diili, millega jäeti võitjale 3500 eurot + sõrmus, mis aitab Sultanovi järgmiseks suveks Las Vegasse.
Palju õnne Ukrainale ning hea uudis on selles ka Eestile - 1100 € turniir kolitakse kohe "õigesse telelauda" ning me saame vahetult Alekseile kaasa elada!
Kohe algab päev 1B Posted Sunday 17th September, 2023 at 13:59(UTC+0) by maheaaatom
Mängijatel palutakse istet võtta, kohe on algamas 350 € turniiri päev 1B. Reganud on hetkeseisuga 24 mängijat, nende seas ka mitmeid tuntud tegijaid Eestist nagu Marko Keskel, Kristo Erala ja Virgo Laansoo.
Head uudised Alekseilt! Posted Sunday 17th September, 2023 at 13:51(UTC+0) by maheaaatom
Aleksei võitis üliolulise flipi Aki Pyysingi vastu ning tõusis talle vahetult kannule, rutates sündmustest pisut ette - sai peagi ka mööda ning meie mees on turniiri uus chipliider!
Tegemist oli klassikalise mündiviskega - vs. . Flop andis Alekseile seti, turni järel oli vastane drawing dead.
"Küll ma juba tean, mida nende nuppudega teha," pakatas Aleksei enesekindlusest.
Annemar kahjuks mängust väljas Posted Sunday 17th September, 2023 at 13:43(UTC+0) by maheaaatom
Turniiril Eesti naiste au kaitsenud Annemar Neiland on mängust väljas, viimases käes kaotas ta -ga -le, vastane sai maast emanda.
Annemar on Eesti pokkerist siiani veel üsna tundmatu tegija, kuigi võttis näiteks osa tänavusest EMV naisteturniirist.
"Tal polnud muidugi täna üldse kaarti ka," tõdes Annemari kõrval istunud Janek Hin.
350 € turniiril jätkab 100 parimat Posted Sunday 17th September, 2023 at 13:33(UTC+0) by maheaaatom
Kirjas on juba 198 sisseostu ning laudades täpselt 100 mängijat. Hetkel oleme juba selgelt punktis, kus uusi sisseoste naljalt ei lisandu ning allesjäänute mäng arv väheneb pidevalt. Re-entry periood saab samuti pärast järgmist pausi (mis algab umbes 10 minuti pärast) otsa.
Neil, kes tahavad alustada algusest, tasub suunata oma pilk pigem kell 16:00 algavale 1B-le.
Alekseil vähemalt 9650 € juba käes Posted Sunday 17th September, 2023 at 13:29(UTC+0) by maheaaatom
Soomlane Aki Pyysing elimineeris turniiri shortstacki Steponas Venckuse vs. ) ning 1100 € finaali jätkab neli parimat. Tõsi, nüüd on juba Aleksei stäkk esimesena tule all, kuid natuke mänguruumi tal siiski veel on. Ühest duublist piisaks, et mängu korralikult tagasi tulla.
Hetkeseis meid enim huvitavalt 1100 € turniirilt Posted Sunday 17th September, 2023 at 13:13(UTC+0) by maheaaatom
Aki Pyysing juhib kindlalt 1 285 000 punktiga, päris korralik seis on ka Joshua Stewartil (920K). Santtu Leinonenil on 520K, Aleksei Smirnovil 390K ning laua chiplooser on Steponas Venckus (155K).
Olympic Casino rahamängude Jackpot on kasvanud juba 62 380 euroni Posted Sunday 17th September, 2023 at 13:09(UTC+0) by maheaaatom
Kuna cashimängud on suurfestivalide ajal populaarsed (reede ja eile õhtul käis action julgelt kümnel laual), siis paisub nende toel ka rahamängude Jackpot, mis on jõudnud enneolematu 62 380 euroni.
Floor teadis rääkida, et see oleks äsja ka kätte saadud, kui potentsiaalse bad beadi omanik poleks oma kaarte vastase suure tõste peale maha visanud. Aga osakese Jackpotist (500 eurot) võib saada ka Royal Flushi eest ning royalimehi on ikka jagunud.
Jackpoti saamise reeglid erinevad mänguti, kuid näiteks Texas Holdemis tuleb kaotada vähemalt käega ning käest peab kasutama mõlemat kaarti.
Näide: sul on käes , vastasel ning lauda tuleb . Sel juhul käsi kvalifitseerub Jackpoti saamiseks.
Mis toimub meile armsal 555 € turniiril? Posted Sunday 17th September, 2023 at 12:59(UTC+0) by maheaaatom
555 € Ring Event #1 pakkus meile küll kolm päeva põnevat meelelahutust, kuid kahjuks ükski eestlane finaali ei jõudnud. Edukaim mees, Martin Piik, on aga kenasti kohal hetkel toimuval 350 € turniiril.
Seis on seal selline, et käimas on heads-up Pawel Fraczeki (Poola) ja Viacheslav Sultanovi (Ukraina) vahel.
Põhiturniir juba ülehomme Posted Sunday 17th September, 2023 at 12:52(UTC+0) by maheaaatom
WSOP Circuit põhiturniir algab 19-ndal septembril ehk siis juba ülehomme. Julgustame veelkord kõiki huvilisi satelliitidel kätt proovima. Kõik senised põhiturniiri satikad (!) on pakkunud üsna korralikku overlayd ning kuna homme pidi hotell juba ääreni täis olema, võib täna olla viimane hea aeg põhiturniiri piletit püüdma minna.
Sisseost on 150 € ning garanteeritud 10 x 1500 € piletit. Kõik osalejad on kasumis kui sisseoste koguneb alla 100 ning siiani pole seda numbrit veel kunagi täis saadud.
Tegemist on ikkagi turboga Posted Sunday 17th September, 2023 at 12:37(UTC+0) by maheaaatom
350 € turniiril oleme jõudnud 300/600 blindideni ning keskmine stäkk on pisut üle 40XBB. Seega on mäng võrdlemisi terav ning re-entrysid koguneb kõvasti (hetkel 43). Fondis 55 642 eurot - seega on ka fond juba päris kopsakas ning peaks tõenäoliselt minema ka kuuekohaliseks.
Suuri liidreid turniiril veel ei eristu.
Massöörid otsivad Ermot Posted Sunday 17th September, 2023 at 12:33(UTC+0) by maheaaatom
WSOPC esimesel neljal päeval on hakanud silma, et massöörid on olnud sisuliselt ilma tööta. Ükskuid kliente on, kuid palju vähem kui muidu. Ja Ermot pole ka täna veel kasiinos nähtud.
1100 € jätkub viiekesi Posted Sunday 17th September, 2023 at 12:20(UTC+0) by maheaaatom
Meid hetkel tõenäoliselt enim huvitaval turniiril, 1100 € NLH Ring Event #2-l langes veel üks mängija ning Aleksei ka ennustas, jõutigi umbes tunniga 5-handed mänguni.
Aleksei on mängus alles, kuid ta seis pole kerge, sest mees on selgelt kõige väiksema stäkiga, mis on umbes 18XBB. Juhib endiselt Soome pokkerihai Aki Pyysing, kes tegi mehetegusid juba 90-ndatel.
350 € turniiril juba 171 sisseostu Posted Sunday 17th September, 2023 at 12:13(UTC+0) by maheaaatom
Pausilt naases 141 mängijat ning sisseoste on kogunenud juba 171. See tähendab, et mängitakse üsna suurele auhinnafondile, lisaks on ju ees ka päev 1B.
Eestlastest on lisandnud näiteks hirmkuulus pokkerihai Mauri Dorbek ning lõuapoolikust hobimängija Marek Selgeveer, kellega koos mängides kunagi igav ei hakka.
1100 € turniiri jätkab kuus parimat Posted Sunday 17th September, 2023 at 12:09(UTC+0) by maheaaatom
Väheke infot 1100 € turniirilt.
Tanel Evert suutis küll ühe blindiringi üle elada, kuid teisel tuli ikkagi sundseisus sisse minna. Seejuures polnud see seis üldse halb - vs. . Paraku sai aga vastane floppi üheksa. Taneli kaheksanda koha eest 3750 eurot.
Aleksei Smirnov on oma seisu õige pisut parandanud ning elimineerinud ka ühe konkurendi. Alles on kuus parimat, igaüks on juba teeninud vähemalt 5950 eurot.
Rahvaturniir pausile, mõned põnevad avapäeva numbrid Posted Sunday 17th September, 2023 at 11:46(UTC+0) by maheaaatom
555 € turniiril osalesid 31 erineva riigi mängijad. Seejuures kogunes ühele soomlasele kaheksa ning ühele hispaanlasele 6 re-entryt.
1100 € turniiril olid esindatud 17 riiki. Leidus üks mängija, kes vajutas neljal korral korral re-entry nupule, kolme re-entry tegijaid kogunes kolm.
Oleme tagasi 20 minuti pärast.
Ela Alekseile ja Tanelile kaasa! Posted Sunday 17th September, 2023 at 11:38(UTC+0) by maheaaatom
Nagu mainitud, alustab Aleksei 1100 € turniiri finaali 16xBB ning Tanel kõigest 2XBB-ga.
Veel põnevaid liitujaid Posted Sunday 17th September, 2023 at 11:30(UTC+0) by maheaaatom
Mänguga on liitunud 555 € turniiril Eesti parimana 11-ndaks tulnud Martin Piik, juba 2010. aastal Eesti meistritiitli võitnud Priit Brikker, loomulikult ka Dmitri Dudakov, Stanislav Smeljov, esimese eestlasena Coolbet Open põhiturniiril triumfeerinud Ott-Kaarli Toome ning live-pokkeris alles esimesi samme astuv Martin Venno.
Ka Raivo ja Eha Pinsel on lauas. Raivo alustas mäletatavasti 555 € turniiri teist päeva liidrina, kuid langes üsna peagi välja. Hiljem rääkis Raivo, et see oli tema elu kõige koledam pokkeripäev. Ükski kaart ei pidanud, isegi mitte ässapaar, millele lauast veel üks äss lisaks tuli.
Algas 1100 € Ring Event'i finaal Posted Sunday 17th September, 2023 at 11:13(UTC+0) by maheaaatom
Viimased pildid telelaua ees on tehtud ning üheksa parimat istusid just lauda. Kui Alekseil on vähemalt 16xBB stäkk, siis Tanel Evert peab alustama vaid 2XBB-ga.
"Nüüd sõltub kõik selles, kuhu button loositakse," rõhutab Haapsalu mees. Sedagi turniiri saab jälgida 30-minutilise viivitusega läbi TV-ülekande. Hoiame ka blogilugejaid seal toimuvaga kursis ning lubame, et telepildist ette ei jookse.
Vaheldust meestekarjale Posted Sunday 17th September, 2023 at 11:03(UTC+0) by maheaaatom
Kõige jutukam on turniiril kolmas laud, kus tuntud lõuapoolikud Janek Hin ja Erik Int. Meestele pakub seltski ka Annemar Neiland, keda tuntakse eelkõige ühe Eesti parima rannavõrkpallurina.
Paistab, et pokker volleinimestele sobib. Heaks näiteks Martti Keel, kes tuli kevadel Eesti meistriks ning võiks olla kindlasti üks kandidaate ETPF-i "Aasta Läbimurdja" tiitlile.
121 mängijat Posted Sunday 17th September, 2023 at 10:50(UTC+0) by maheaaatom
WSOPC "rahvakas" aina kogub tuure, hetkel on tehtud juba 121 sisseostu ning mõnel õige tarmukal juba ka re-entry kirjas.
Lisandunud on näiteks noorem Pihela, Kaur Ajamaa, Mark Metsla ja Tarmo Tammel.
Aleksei valmistub finaaliks Posted Sunday 17th September, 2023 at 10:46(UTC+0) by maheaaatom
Eesti üks parimaid pokkerimängijaid Aleksei Smirnov valmistub kell 13:00 algavaks 1100 € finaaliks. "Mul on 16xBB stäkk, seega olen üsna short. Aga kokku on shorte viis, seega ma ei imestaks kui juba tunni järel jätkuks turniir 5-handed," räägib Aleksei.
Tema hinnangul on turniir vägagi mängitav, finaali tase olevat kindlasti nõrgem kui suurtel netiturniiridel, milles mees igapäevaselt osaleb. Kui ainult stäkki rohkem oleks...
Aleksei on tuntud oma suure töötahte ning väga distsilineeritud suhtumise poolest. Aleksei on korduvalt rääkinud, et tippmängijaks olemiseks peab oleme tugev nii vaimselt kui füüsiliselt ning oluline on ka näiteks toitumine. Täpsemalt saad Alekseist lugeda siit.
Muljetab Ranno Sootla Posted Sunday 17th September, 2023 at 10:30(UTC+0) by maheaaatom
Mängijatest puudust ei ole Posted Sunday 17th September, 2023 at 10:27(UTC+0) by maheaaatom
Juba on laudades 93 mängijat ning leidub nii hobi-, harrastus- ka professionaalseid mängijaid. Teiste seas on kohal nii viimase kahe aasta EMV põhiturniiri tšempionid Kaidar Viikman ja Magnus Pukk kui ka Igor Pihela vanem.
Tänased TV-striimid Posted Sunday 17th September, 2023 at 10:18(UTC+0) by maheaaatom
555 NLH Ring Event #1 finaallaud on juba käimas ning otseülekannet saab jälgida siit alates kell 12:30-st. Kahjuks pole seal küll ühtegi Eesti mängijat.
Kell 13:00 algab aga 1100 € NLH Ring Event #2 finaal (otseülekanne samuti 30-minutilise viivitusega), kus on juba märksa rohkem pinget õhus. Mängus on Aleksei Smirnov ja Tanel Evert, viimane küll väga pisikese stäkiga. Aga suurturniire võib võita ka üheainsa žetooniga, mida suutis teha näiteks Jack Straus 1982. aasta WSOP põhiturniiril, kus ta end kõigest üheainsa juhuslikult leitud 500 $ nupuga võitjaks mängis ning pani taskusse üle poolt miljoni dollari.
WSOP-C rahvaturniir on alanud! Posted Sunday 17th September, 2023 at 10:06(UTC+0) by maheaaatom
Vihmases ja tuulises on alanud WSOP Circuit Tallinn 2023 üks kahes "odavast", 350 € NLH turniirist. Rannailma pole, seened on ka nagunii juba eile ära korjatud, seega tulge mängima!
Täna võib oodata kiiret mängu, sest alustatakse 200xBB-ga ning tasemed on vaid 20 minutit. Kell 16:00 algab sama turniiri teine heat (2A), mis mängitakse täpselt samadel põhimõtetel. Teise päeva pääseb mõlema avapäeva 15% parimatest ehk täna mängitakse rahadeni.
WSOPC "rahvaturniir" algab pühapäeval kell 12:00 Posted Saturday 16th September, 2023 at 21:08(UTC+0) by maheaaatom
Pühapäeval kell 12:00 algab 350 € WSOPC Ring Event #3, mida võib tinglikult nimetada ka n.ö. WSOP rahvaturniiriks. Selles blogis jälgime ka teisi põnevaid sündmusi eesotsas 555 €- ja 1100 € turniiri finaaliga.
See on kõige soodsam võimalus WSOP Circuit meistrisõrmuse teenimiseks. Tulge proovima!
20:56 (UTC+0)
Day 1A of WSOPC Tallinn Started Level: 1 Blinds: 100/200 Ante: 200
Your search results are valid for .
Go to checkoutMore 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.