0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0117 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/3/updates'
ORDER BY `views` DESC
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.0004 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.0003 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0006 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `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.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0076 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'WSOPCTallinn2023-MainEvent-Est'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '40'
0.0245 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '122'
AND `published` = 1
0.0321 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0082 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '126'
AND `published` = 1
0.0306 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '128'
AND `published` = 1
0.0243 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '131'
AND `published` = 1
0.0336 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0081 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '133'
AND `published` = 1
0.0290 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '137'
AND `published` = 1
0.0260 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0080 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '140'
AND `published` = 1
0.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '40'
AND `name` = '3'
0.0108 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '137'
ORDER BY `busted` ASC, `current_chips` DESC
0.0097 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` = '137'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '5951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5947'
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` = '5944'
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` = '5942'
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` = '5938'
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` = '5934'
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` = '5933'
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` = '5930'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5928'
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` = '5931'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5916'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5913'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5912'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5908'
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` = '5904'
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` = '5902'
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` = '5901'
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` = '5895'
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` = '5893'
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` = '5891'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5888'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5885'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5880'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5876'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5869'
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` = '5868'
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` = '5866'
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` = '5864'
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` = '5859'
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` = '5856'
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` = '5855'
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` = '5851'
ORDER BY `chip_change` DESC, `busted` ASC
0.0094 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5850'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5847'
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` = '5845'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5848'
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` = '5841'
ORDER BY `chip_change` DESC, `busted` ASC
0.0096 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5836'
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` = '5834'
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` = '5830'
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` = '5838'
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` = '5823'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5821'
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` = '5817'
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` = '5815'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '137'
ORDER BY `busted` ASC, `current_chips` DESC
0.0087 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` = '137'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0110 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0110 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5947'
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` = '5944'
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` = '5942'
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` = '5938'
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` = '5934'
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` = '5933'
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` = '5930'
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` = '5928'
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` = '5931'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5916'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5913'
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` = '5912'
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` = '5908'
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` = '5904'
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` = '5902'
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` = '5901'
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` = '5895'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5893'
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` = '5891'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5888'
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` = '5885'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5882'
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` = '5880'
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` = '5876'
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` = '5869'
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` = '5868'
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` = '5866'
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` = '5864'
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` = '5859'
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` = '5856'
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` = '5855'
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` = '5851'
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` = '5850'
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` = '5847'
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` = '5845'
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` = '5848'
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` = '5841'
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` = '5836'
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` = '5834'
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` = '5830'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5838'
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` = '5823'
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` = '5821'
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` = '5817'
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` = '5815'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '140'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 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.
Finaallaua stäkkide seis Posted Saturday 23rd September, 2023 at 18:36(UTC+2) by maheaaatom
Homme kell 12:00 algavat finaali alustab liidrina soomlane Akseli Paalanen, kellel on 10,65 miljonit punkti. Finaalis on kolm eestlast: Artur Külanurk (4,55M), Mairo Tori (1,5M) ja Mario Linno (1,175M).
Pokkeripidu Olympic Casinos on aga alles tuure kogumas - 3000 € 6-max Ring Event #11 on juba meelitanud kokku 93 sisseostu ning mäng saab olema enamale kui veerandile miljonile eurole. Kohal on nii Urmo Velvelt, Markku Koplimaa, Ranno Sootla, Aleksei Smirnov, Pihelad jms. tõelised ässad.
Naistekal on tehtud 38 sisseostu, 150 € NLH jõudis just finaallauani. Käimas on ka 250 € PLO ja 150 € Finnish Stud, samuti võimas cashgame action ning uusi turniire on samuti peagi tulemas.
Meie kohtume blogilugejatega aga juba homme kell 12:00, mil asume selgitame esimest korda Tallinnas toimuva WSOP Circuit põhiturniiri tšempionit.
Player
Chips
Progress
Akseli Paalanen
10,650,000
9,350,000
Jun Chun
6,875,000
6,430,000
Artur Külanurk
4,550,000
250,000
Jesus Martinez
3,450,000
2,350,000
Emil Hovmark
3,250,000
2,695,000
Adria Comas
2,275,000
1,175,000
Garrido Gonzalez
2,200,000
0
Mairo Tori
1,500,000
0
Mario Linno
1,175,000
0
Finaallaud on koos! Posted Saturday 23rd September, 2023 at 18:25(UTC+2) by maheaaatom
Tänane mängupäev oli tõeliselt tempokas. Oli üsna keeruline manööverdada oleviku ja mineviku vahel, kuid loodetavasti said ülekande lugejad siiski arusaadava pildi toimuvast.
Kümnendana langes soomlane Pekka Ikonen ning finaalis on kolm Eesti mängijat.
Telelauas veel üks langeja Posted Saturday 23rd September, 2023 at 18:19(UTC+2) by maheaaatom
Antti Eeva kaotab PFAI-is Emil Hovmarki -le. Kümme mängijat järgi ning käimas on finaallaua mull.
Player
Chips
Progress
Antti Eeva
0
0
Artur võtab korraliku skalbi Posted Saturday 23rd September, 2023 at 18:13(UTC+2) by maheaaatom
Chun avab 250K panusega, Martinez lükkab all-in 1,8M ning ka Artur pressib nupud sisse. Chun loobub.
Martinez:
Artur:
Flopis on veel üks üheksa ning kuigi hispaanlane saab pärast turni gutshot reatõmbe, jääb meie mees peale. Arturil 4,8K.
Player
Chips
Progress
Artur Külanurk
4,800,000
1,400,000
Garrido Gonzalez
2,550,000
1,900,000
Jesus Martinez
0
0
Garrido Gonzalez
0
0
15. koht Hendrik Uibo 7750 € Posted Saturday 23rd September, 2023 at 18:08(UTC+2) by maheaaatom
Hendrik Uibo sai küll pikalt turniiri kindlat eduseisu nautida, kuid kahjuks piisas kahest suurest jaotusest, et oma nuppudest lahti saada.
Viimane all-in oli telelauas -ga Jun Chuni vastu. oli ka Carrido Gonzalezel, kuid hispaanlane viskas selle maha.
Flop andis meie mehele veel kena mastitõmbe, kuid kohale seda paraku ei tulnud. Siiski peame Hendrikule aplodeerima hea ja sisuma mängu pärast. Lisaks ei tasu unustada, et suurturniirile pääses ta läbi OlyBeti, alustades kõigest 11-euroselt satelliidilt.
Peale sai ta 11-euroselt satelliidilt, seega on ka 7750 eurotnautida pikalt
Player
Chips
Progress
Hendrik Uibo
0
0
High-Rolleril käib mäng suurele summale Posted Saturday 23rd September, 2023 at 17:59(UTC+2) by maheaaatom
3000-eurosel turnal on juba 87 sisseostu ning peagi peaks auhinnafond ületatama ka veerand miljoni piiri. Kohal on väga nimekas seltskond, seega saame homme näha koguni kahte ülipõnevat finaali.
Mairo ja Mario stäkid Posted Saturday 23rd September, 2023 at 17:44(UTC+2) by maheaaatom
Mairol on 1,175M ja Mariol umbes 1,5M. Seda pole palju, meestel oleks duubleid vaja.
Player
Chips
Progress
Mairo Tori
1,500,000
200,000
Mario Linno
1,175,000
1,025,000
Asjad arenevad kiirelt Posted Saturday 23rd September, 2023 at 17:43(UTC+2) by maheaaatom
Mitte-telelauast langes pisikese stäkiga (400K) Max Rudolf Rotko - vs. , kuid telelauas on langejaid koguni kaks. Seega oleme jõudnud uskumatu kiirusega 10 parimani!
Olympic Casinos on tulemas suurfestival Queens of Tallinn! Posted Saturday 23rd September, 2023 at 17:36(UTC+2) by maheaaatom
Tänane hostess Teele Viira andis just teada, et 30. novembrist kuni 3. detsembrini toimub Tallinnas, Olympic Park Casinos ainult naistele mõeldud suurfestival Queens of Tallinn 2023.
Mängima oodatakse naisi nii Eestist, Põhjamaadest kui mujalt Euroopast. Kavas nii põhiturniir kui side-eventid.
Kuraditosin parimat Posted Saturday 23rd September, 2023 at 17:33(UTC+2) by maheaaatom
Kaotasime Rootsi vanameistri Skommar Hanssoni, samuti on üks langeja telelauast. Mängu jätkab kuraditosin parimat!
Player
Chips
Progress
Skommar Hansson
0
0
17:23 (UTC+2)
Start of Level 27 Blinds: 50,000/100,000 Ante: 100,000
Mario annab duubli Posted Saturday 23rd September, 2023 at 17:03(UTC+2) by maheaaatom
Rudolf Rutko oli just kaotanud suurema osa oma stäkist PFAI-s -ga vastu.
Viimased 650K läksid sisse Mario Linno vastu.
Flopis , turn - oute kui palju...
River siiski ning Mariol tuli duubel välja maksta.
Oleme 20-minutilisel pausil.
Täna öösel kuuenda eestlasena WSOP Circuit kuldsõrmuse võitnud Toomas Orm annab aru Posted Saturday 23rd September, 2023 at 16:54(UTC+2) by maheaaatom
Tähelepanu "väiksele" telelauale Posted Saturday 23rd September, 2023 at 16:48(UTC+2) by maheaaatom
Väikses telelauas on meie vaatluse all Mairo Tori ja Mario Linno. "Suures telelauas", mille ülekandel on 30-minutiline viivitus, istuvad nii Artur kui Hendrik.
Mairol on umbes 1,3M ja Mariol 2,2M. Ärge neid nimesid sassi ajage, Mario on see maskiga kutt!
Player
Chips
Progress
Mario Linno
2,200,000
1,505,000
Mairo Tori
1,300,000
500,000
16. koht Martin Piik 6000 € Posted Saturday 23rd September, 2023 at 16:44(UTC+2) by maheaaatom
Sel festivalil väga kenasti esinenud Martin tegi juba kolmanda sügava jooksu. Aga finaali polnud tal kahjuks asja ka põhiturniiril.
Viimases jaotuses jooksnud Martin lihtsalt ässade otsa.
Player
Chips
Progress
Martin Piik
0
0
Kell pandi seisma Posted Saturday 23rd September, 2023 at 16:24(UTC+2) by maheaaatom
Eestlaste laua üks shordimaid Tomasz Janusz Mroz leiab end ebamugavast all-in'ist -ga vastu. Laud talle päästvat ässa ei too.
Kuna järel on 16 parimat, ootab meid järjekordne re-draw ning tehniline paus.
Player
Chips
Progress
Tomasz Mroz
0
0
Artur laseb end ära bluffida Posted Saturday 23rd September, 2023 at 16:15(UTC+2) by maheaaatom
Pangas on ca 1,4M ning lauas .
Artur mõtleb pikalt ning checkib seejärel. Skommar Anders Hansson läheb insta-all'in (umbes miljon), Artur insta-foldib.
Rootslane on erakordselt võidurõõmus ning viskab lauale - puhas bluff!
16:07 (UTC+2)
Start of Level 26 Blinds: 40,000/80,000 Ante: 80,000
Artur ampsab natuke Martinilt Posted Saturday 23rd September, 2023 at 16:05(UTC+2) by maheaaatom
Pangas on umbes 600K ning lauas . Artur panustab viimasena piisavalt, et sundida Martinit all-in minema. Martin ei calli. "Kas sul oli kaheksa," uurib Artur aga vastust ei tule.
Nüüd Arturil umbes 3,4M, Martinil 800K.
Väljas Leedulane Bielskis, jätkab 17 parimat.
Player
Chips
Progress
Artur Külanurk
3,400,000
1,400,000
Martin Piik
800,000
400,000
Andrius Bielskis
0
0
Martin duubeldab Posted Saturday 23rd September, 2023 at 15:55(UTC+2) by maheaaatom
11XBB stäkiga Martin läks buttonilt proovima -ga ja sai calli -lt.
River poiss. Huh, see läks küll napilt.
Vahepeal on olnud ka mitmeid langejaid, sh. telelauast. Ka turniiri parim naismängija Anna-Mari Hursti on mängust väljas. Olgu lisatud, et see soomlanna tegi sügava jooksu ka nii tänavusel Kings of Tallinn kui Summer Showdown põhiturniiril.
Jätkab 18 parimat, kõik on endale taganud 6000 eurot.
Player
Chips
Progress
Martin Piik
1,200,000
550,000
Maruen Zormati
0
0
Maciej Komorowski
0
0
Henri Antikainen
0
0
Samuel Richards
0
0
Anna-Mari Hursti
0
0
Artur ja Tomasz liigutavad mägesid Posted Saturday 23rd September, 2023 at 15:46(UTC+2) by maheaaatom
Jaotus 1: Artur ja Tomasz Janusz Mroz on umbes miljonilises pangas, avatud on flop . Artur paneb 100K ja saab calli.
Turn checkitakse läbi. Riveri järel paneb Artur 900K ja saab snapcalli. Meie mees näitab ja korjab panga maha.
Jaotus 2: Mroz (450K) ja Artur on jälle keskel, ka nüüd on meie mees selgelt ees - vs. . Paraku lendab lauda äss.
Telelaua stäkid ülekande alguses Posted Saturday 23rd September, 2023 at 15:38(UTC+2) by maheaaatom
Hendrik on turniiri kindel liider, kuigi kobedaid 1,5-3M stäkke on mängus omajagu.
Player
Chips
Progress
Hendrik Uibo
3,900,000
100,000
Mairo Tori
1,800,000
1,350,000
Pekka Ikonen
1,700,000
920,000
Samuel Richards
1,200,000
860,000
Henri Antikainen
1,200,000
695,000
Adria Comas
1,100,000
890,000
Anna-Mari Hursti
800,000
405,000
Mario Linno
695,000
305,000
Rahulik eestlaste laud Posted Saturday 23rd September, 2023 at 15:33(UTC+2) by maheaaatom
"Eestlaste lauas" mängitakse väga vaikselt ja kaalutlevalt. Viimases kahes jaotuses on näiteks kõik enne blinde foldinud. Martin proovis küll korral BB-lt (SB calli peale) all-in, kuid kaarte lauale ei saanud.
Martin on umbes 650K, Arturil 2M. Väljas soomlane Jimi Koponen.
Player
Chips
Progress
Artur Külanurk
2,000,000
500,000
Martin Piik
650,000
0
Jimi Koponen
0
0
15:27 (UTC+2)
Start of Level 25 Blinds: 30,000/60,000 Ante: 60,000
Queens of Tallinn on alanud Posted Saturday 23rd September, 2023 at 15:18(UTC+2) by maheaaatom
WSOP Circuit naistekas on alanud ning hetkel lauas kuraditosin naisi. Aga kindlasti tuleb neid omajagu juurde.
Naismängijad olevat igal tasemel. Näiteks teadis Ave vaheajal rääkida ühest satelliidilt välja langenud naisest, kes oli väga kurb, et ta ei saagi nüüd naisteturniiril osaleda. Eks ikka sellepärast, et n.ö. "ei kvalifitseerunud". Talle selgitati sõbralikult, et see ei tähenda ju midagi, sisse võib ta end alati osta.
Eestlaste jagunemine laudade vahel Posted Saturday 23rd September, 2023 at 15:12(UTC+2) by maheaaatom
Telelauas on 3 eestlast (Hendrik, Mario ja Mairo). Et teil oleks huvitavam teleülekannet vaadata, siis seda lauda me reaalajas ei jälgi.
Abilauas on nii Artur kui Martin, väikeses telelauas aga Eesti mängijaid ei ole.
25. kohaga on out Soome vanameister Seppo Parkkinen, kes on muide 2004. aasta Eesti pokkerimeister.
Player
Chips
Progress
Seppo Parkkinen
0
0
Kes on Hendrik Uibo? Posted Saturday 23rd September, 2023 at 15:05(UTC+2) by maheaaatom
Re-draw on lõppenud ning mängijad taas laudades. Kõik põhiturniiri lauad on nüüd fuajees - suur ja väike telelaud + üks tavalaud.
Pausi ajal tegime põgusalt juttu ka turniiri liidri Hendrik Uiboga. Hendrik on mänginud pokkerit juba päris kaua, kuid internetis. On turnamees, cashis ei tea enda sõnul suht midagi.
Tavaelus õpetab noori karti sõitma, pokkerit mängib poolprofessionaalselt. On mõningaid viiekohalisi võite, kuid ei midagi üle-mõistuse käivat. Eelmise aasta lõpus võttis tõsisemalt ka live-pokkeri käsile. Kui peaks WSOP Circuit'il võitma, siis vast enam tavatööle ei lähe.
Ühesõnaga - edu Hendrikule!
Eestlaste seis "väikeses telelauas" Posted Saturday 23rd September, 2023 at 14:42(UTC+2) by maheaaatom
Hendrikul on juba neli miljonit või isegi üle selle. Tore näha, kuidas noorel mängumehel kõik sujub!
Kona konkurentsis on veel 24 parimat, on toimumas re-draw ning mängijate liikumine. See tähendab lühikest tehnilist pausi.
Player
Chips
Progress
Hendrik Uibo
4,000,000
800,000
Artur Külanurk
2,500,000
600,000
Martin Piik
650,000
435,000
Side-actionist Posted Saturday 23rd September, 2023 at 14:38(UTC+2) by maheaaatom
3000 € 6-maxil on juba tehtud 55 sisseostu, Eesti pokkerimängijate absoluutne tipp on kohal. Küll peale Ottomari, kes pidavat kuskil soojal maal grindima.
150 € turniir on kogunud 89 huvilist. Kohal ka mitmeid hobimängijaid, keda pole siiani veel WSOP-C-l näha olnud.
Naisteka freeroll läheneb samuti lõpule, Queens of Tallinn alguseni on veel 25 minutit.
Action jätkub Posted Saturday 23rd September, 2023 at 14:34(UTC+2) by maheaaatom
24. mängutaseme esimese kümne minutiga veel kolm langejat, õnneks pole seal eestlasi. Meie peamine tähelepanu läheb nüüd "väikesele telelauale", kus nii Martin Piik, kui kaks chipliidrit- Hendrik ja Artur.
Start of Level 24 Blinds: 20,000/50,000 Ante: 50,000
Pausile eestlaste juhtimisel Posted Saturday 23rd September, 2023 at 14:03(UTC+2) by maheaaatom
Põhiturniir läks pausile ning me oleme tagasi 20 minuti pärast.
Eestlastel peaks olema kaksikjuhtimine - Hendrikul on umbes 3,2M ja Artur Külanurgal 3,1M. Vinge!
Player
Chips
Progress
Hendrik Uibo
3,200,000
600,000
Artur Külanurk
3,100,000
1,100,000
34. koht Hannes Praks, 32. koht Kris Tikka - mõlemad 4750 € Posted Saturday 23rd September, 2023 at 13:57(UTC+2) by maheaaatom
Kris langes "vaese-mehe-telelauast", Hannes Praks siitsamast suurest saalist. Mõlemal olid ka üsna väikesed stäkid.
Langejaid on teisigi, seega olema jõudnud 28 parimani.
Player
Chips
Progress
Marko Härkonen
0
0
Kris Tikka
0
0
Deividas Butnoras
0
0
Bartlomiej Kijak
0
0
Jari Juhola
0
0
Hannes Praks
0
0
Õnnitlused Toomas Ormile Posted Saturday 23rd September, 2023 at 13:52(UTC+2) by maheaaatom
Meenutame korraks veel eilset ning soovime õnne Toomas Ormile, kes tõi Eestisse ajaloo kuuenda WSOP Circuit 2023 meistrisõrmuse. See võit tuli 350 € online-turniiril OlyBetis, mida eestlased meisterlikult domineerisid.
PLO Hi-Lo vältas 17 tundi ning võitis rootslane William Hallenstam, eestlastest oli parim kümnendaks tulnud Igor Pihela noorem.
Kõrvalturniiridel tegi parima tulemuse Egon Kaljulaid, kes saavutas 109 osalejaga 250 € NLH / PLO4/ PLO 5 Mix turniiril kolmanda koha.
35 parimat Posted Saturday 23rd September, 2023 at 13:40(UTC+2) by maheaaatom
Oleme kaotanud vahepeal veel kolm mängijat, õnneks pole keegi neist Maarjamaa poegade hulgast. Jätkab 35, viiendik neist (7) on meie mehed.
Player
Chips
Progress
Steponas Venckus
0
0
Stanislavas Macugins
0
0
Atush Esker
0
0
Mario imeline tõus Posted Saturday 23rd September, 2023 at 13:37(UTC+2) by maheaaatom
Mario Linno kaotas kohe päeva alguses suure flipi -ga vastu ning langes ühel hetkel kõigest 1XBB peale.
Nüüd on mees aga juba miljonäride klubis!
Player
Chips
Progress
Mario Linno
1,000,000
650,000
39. koht Karl Relander 4750 € Posted Saturday 23rd September, 2023 at 13:30(UTC+2) by maheaaatom
Karl on keskel, kui lauas on avatud .
Karlil , vastas Garrido Gonzalese ehk meie mees drawing dead. Tasuks 4750 eurot.
Player
Chips
Progress
Karl Relander
0
0
40. koht Aleksandr Arutjunov 4250 € Posted Saturday 23rd September, 2023 at 13:24(UTC+2) by maheaaatom
Aleksandril kulges tänane algus üle kivide ning kändude ja just alles langes ta lõplikult välja. Tasuks 40. koht ja 4250 €.
Aga rohkem tahaks jagada häid uudiseid. Ning neid on!
Eestlaste suurimad stäkid leiame nn. "varu-telelauast". Kui Hendriku monsterkuhjast oleme juba rääkinud (see on juba julgelt üle 2,5M), siis väga head tööd on teinud ka Artur Külanurk, kel praegu samuti üle kahe miljoni.
Player
Chips
Progress
Hendrik Uibo
2,600,000
835,000
Artur Külanurk
2,000,000
915,000
Aleksandr Arutjunov
0
0
Remigijus Dzerva
0
0
Jose Larios
0
0
Luca Beretta
0
0
Emanuele Mari
0
0
13:21 (UTC+2)
Start of Level 23 Blinds: 20,000/40,000 Ante: 40,000
Eestlaste stäkke suurest saalist Posted Saturday 23rd September, 2023 at 13:10(UTC+2) by maheaaatom
Midagi väga kiita pole, kõik on nuppe loovutanud. Peale vast Hannese Praksi, kes on küll pisut paremas seisus kui teise päeva lõpus.
Õnneks on suurimad favoriidid tele- ja "abi"telelauas. Jätkab 44 parimat, meie mängijaid on endiselt sees üheksa.
Player
Chips
Progress
Hannes Praks
650,000
250,000
Karl Relander
600,000
135,000
Aleksandr Arutjunov
400,000
165,000
Mario Linno
350,000
630,000
Joni Rantamäki
0
0
Adrians Imsa
0
0
Andzej Zinkevic
0
0
Kus on naised - mõistagi siin! Posted Saturday 23rd September, 2023 at 13:00(UTC+2) by maheaaatom
Naisteka freerollil on 29 osalejat, nende seas hulk teada-tuntud kohalikke pokkerikaunitare.
Pileti saab 5 parimat, liituda saab kuni umbes 13:30-ni.
Laudu vähemaks Posted Saturday 23rd September, 2023 at 12:57(UTC+2) by maheaaatom
Põhiturniiril veel mõned langejad ning toimus väike laudade kokkuviimine.
Ühtlasi toimus ka väike money-jump - need kes alles, on võitnud vähemalt 4250 eurot.
Üks vastik bad beat ka: Vu Vuong kaotas Pekka Ikonenile vs. , vastasele flopist nelik!
Mängus on endiselt üheksa eestlast.
Player
Chips
Progress
Gilles Rene Simon
0
0
Juho Suutari
0
0
Amanullah Tahiri
0
0
50 parimat Posted Saturday 23rd September, 2023 at 12:45(UTC+2) by maheaaatom
Põhiturniirilt on väljas ka Igor Yaroshevskyy, seega jätkab 50 parimat.
"High-Rolleril" on sisseoste 22 ning äsja põhiturniirilt langenud Ermo ja Urmo on samuti sellega liitunud. Pluss muidugi ka eilne viimane bust-out Mauri Dorbek.
150 € turniiri mängijad saavad gämmelda fuajees. Seal juba 52 sisseostu ning esimesed re-entryd'ki juba kirjas.
Player
Chips
Progress
Igor Yaroshevskyy
0
0
12:45 (UTC+2)
Start of Level 22 Blinds: 15,000/30,000 Ante: 30,000
57. koht Urmo Velvelt 3300 €, 54. koht Alger Pissarev 3750 € Posted Saturday 23rd September, 2023 at 12:31(UTC+2) by maheaaatom
Põhiturniirilt veel mõned langejad, nende seas kahjuks ka kaks eestlast. Ning millest eriti kahju - nende kahe seas on ka Urmo Velvelt.
Player
Chips
Progress
Aigars Taukacs
0
0
Toms Civcs
0
0
Kasper Mellanen
0
0
Youngseo Yoon
0
0
Alger Pissarev
0
0
Urmo Velvelt
0
0
59. koht Ermo Kosk 3300 € Posted Saturday 23rd September, 2023 at 12:24(UTC+2) by maheaaatom
Kuuekordne Eesti meister Ermo Kosk on kahjuks mängust välja ning teenib 59. koha eest 3300 eurot.
Äsja on alanud ka 3000-eurone 6-max ja 150 € NLH. Esimesel on laudades 16 mängijat.
Player
Chips
Progress
Ermo Kosk
0
0
Tornike Tchitadze
0
0
Tere tulemast jälgima päeva 1C ülekannet Posted Saturday 23rd September, 2023 at 12:09(UTC+2) by maheaaatom
Põhiturniiri jätkavad 60 parimat mängijat on laudades ning action on alanud.
Turniiriala on täis lõbusat sädinat, sest kell 12:00 pandi käima ka naisteka freeroll, kus antakse välja 5 x 150 € piletit. Täiesti niisama!
12:08 (UTC+2)
Day 3 of WSOPC Tallinn Started Level: 21 Blinds: 10,000/25,000 Ante: 25,000
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.