0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0076 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event1_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.0001 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.0001 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.0003 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.0063 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` = '2024_wsop_tallinn_event1_est'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '134'
0.0253 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '316'
AND `published` = 1
0.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '318'
AND `published` = 1
0.0256 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0045 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '319'
AND `published` = 1
0.0250 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0042 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '322'
AND `published` = 1
0.0259 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0044 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '325'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '134'
AND `name` = '1A'
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '316'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '316'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.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` = '14028'
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` = '14027'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14026'
ORDER BY `chip_change` DESC, `busted` ASC
0.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` = '14025'
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` = '14024'
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` = '14023'
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` = '14022'
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` = '14021'
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` = '14020'
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` = '14019'
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` = '14018'
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` = '14017'
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` = '14016'
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` = '14015'
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` = '14014'
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` = '14013'
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` = '14012'
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` = '14011'
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` = '14009'
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` = '14008'
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` = '14007'
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` = '14006'
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` = '14005'
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` = '14004'
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` = '14003'
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` = '14002'
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` = '14001'
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` = '14000'
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` = '13999'
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` = '13998'
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` = '13997'
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` = '13996'
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` = '13995'
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` = '13994'
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` = '13993'
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` = '13992'
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` = '13991'
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` = '13990'
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` = '13989'
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` = '13988'
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` = '13987'
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` = '13986'
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` = '13985'
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` = '13984'
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` = '13983'
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` = '13982'
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` = '13981'
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` = '13980'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '316'
ORDER BY `busted` ASC, `current_chips` DESC
0.0050 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '316'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14028'
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` = '14027'
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` = '14026'
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` = '14025'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14024'
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` = '14023'
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` = '14022'
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` = '14021'
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` = '14020'
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` = '14019'
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` = '14018'
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` = '14017'
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` = '14016'
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` = '14015'
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` = '14014'
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` = '14013'
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` = '14012'
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` = '14011'
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` = '14009'
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` = '14008'
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` = '14007'
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` = '14006'
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` = '14005'
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` = '14004'
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` = '14003'
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` = '14002'
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` = '14001'
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` = '14000'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13999'
ORDER BY `chip_change` DESC, `busted` ASC
0.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` = '13998'
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` = '13997'
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` = '13996'
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` = '13995'
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` = '13994'
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` = '13993'
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` = '13992'
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` = '13991'
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` = '13990'
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` = '13989'
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` = '13988'
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` = '13987'
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` = '13986'
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` = '13985'
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` = '13984'
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` = '13983'
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` = '13982'
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` = '13981'
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` = '13980'
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` = '325'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
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.
Eestlaste lõplik chipcount (1A) Posted Friday 19th July, 2024 at 22:02(UTC+3) by maheaaatom
Teise päeva pääses 74 mängijat, nende seas 27 eestlast. Suurim stäkk on prantslasel Anthony C. M. Lesoismier-Geniaux'l (169 900), Janek Hin on 104 500-ga kolmas.
Player
Chips
Progress
Janek Hin
104,500
10,500
Magnus Pukk
90,200
5,200
Mark Metsla
87,300
27,300
Taago Tamm
86,000
9,000
Andrei Mjagkov
78,700
11,700
Lauri Laast
74,800
0
Artur Mäeots
66,700
0
Joonas Kulli
61,500
0
Bahtijar Kulijev
61,000
0
Siim Suviste
58,800
9,200
Kaspar Laursoo
56,300
14,300
Karl-Henri Lauri
54,500
0
Tom Richard Teslon
47,700
0
Tanel Evert
44,900
3,100
Hendrik Uibo
41,100
19,900
Roman Jezov
38,000
7,000
Sergei Kuznetsov
36,000
0
Kaidar Viikman
36,000
27,000
Maksim Petrov
32,000
0
Maksim Paponov
29,100
0
Vitali Rakov
22,000
0
Allan Arjut
21,300
0
Ramon Randma
19,100
0
Madis Ormisson
18,000
0
Priit Valgma
14,600
0
Pavel Solodovnikov
14,200
0
Maksim Onutsin
9,500
0
Taago korjab "Batult" tagasi Posted Friday 19th July, 2024 at 21:32(UTC+3) by maheaaatom
Taago Tamm panustab kõik tänavad ning saab Bahtijarilt kolm järjekindlat calli.
Riveriks on laual ning Taagol on au esimesena avada.
on igati piisav ning umbes 25K pank läheb Taagole.
Ühtlasi hakatakse chippe kottidesse pakkima ning peagi avaldame kõikide allesjäänud eestlaste täpsed stäkid.
"Batule" hiline duubel Posted Friday 19th July, 2024 at 21:27(UTC+3) by maheaaatom
Mängitakse endiselt viimaseid käsi ning shortstäkkidel tuleb proovida. Eriti kui veel häid kaarte ka jagatakse.
Eestlaste omavahelises all-in'is on Bahtijar Kulijev vastamisi (kelle muu kui) Taago Tammega - "Batul" emandad ja Taagol mustad kaheksad.
Turniks saab Taago veel mastitõmbe, kuid river jätab 20 300 stäkiga Bahtijari ikkagi ellu ning toob vajaliku duubli. Taago endisest superstäkist polegi enam teab kui palju alles...
Hämmastav vaikus Posted Friday 19th July, 2024 at 21:19(UTC+3) by maheaaatom
Mängusaalis on endiselt sadakond inimest, kuid valitseb harukordne vaikus, millesarnast ei mäleta juba väga pikka aega, eriti kui arvestada veel seda, et tegemist on ikkagi reede õhtuga. Kostab vaid chippide klõbinat, ka table-talk'i pole pea üldse.
Paistab, et baari joogikäive on täna ikka väga madal. Kõik võib muidugi veel muutuda, kui algab päev 1B.
Ühtlasi algas viie viimase käe jagamine.
Karl-Henri pääses riveriga Posted Friday 19th July, 2024 at 21:07(UTC+3) by maheaaatom
Modestas Kryzanauskas ning Karl-Henri Lauri võtsid flipi, kus eestlasel ja leedulasel .
Modestas juhtis kuni riverini, kus avati Karl-Henrile päästev äss. Meie mehel umbes 14K, leedulasel napilt enam. Jätkab 82 parimat.
21:00 (UTC+3)
Start of Level 10 Blinds: 500/1,000 Ante: 1,000
Stanislavi hapu all-in Posted Friday 19th July, 2024 at 21:00(UTC+3) by maheaaatom
Pärast lauas avatud kaarte olid kolm meest all-in, nende seas ka meie Stanislav Smeljov. Stanislav avas , olles sellega paraku drawing dead ja vastu. Rida jäigi püsima ning selle omanik - prantslane Anthony C. M. Lesoismier-Geniaux - haaras võidurõõmsalt telefoni, et edukast võidukäest pilti teha.
Algas päeva viimane mängutase.
Natuke lisa Kaidarile Posted Friday 19th July, 2024 at 20:52(UTC+3) by maheaaatom
Juri Verbitski 11K all-in'ile tuli call Kaidar Viikmanilt ning mõlemad näitasid ärtu masti tõmmet.
Juri:
Kaidar:
Muide - flopis oligi kaks ärtut ja lõpuks tuligi mast maha! Oleks Juril suurem stäkk olnud, võinuksime näha juba väga suurt all-in'i.
Eestlaste stäkke Posted Friday 19th July, 2024 at 20:45(UTC+3) by maheaaatom
Kahjuks on ka mõningaid langejaid, näiteks oleme ilma Siiri Saarest (Eesti naisi seega päeval 1A enam sees ei ole).
Player
Chips
Progress
Janek Hin
115,000
55,000
Magnus Pukk
85,000
5,000
Taago Tamm
77,000
20,000
Siim Suviste
68,000
0
Mark Metsla
60,000
0
1A viimane mängutund algas Posted Friday 19th July, 2024 at 20:33(UTC+3) by maheaaatom
94 allesjäänud pokkerisportlast on tagasi laudades ning action jätkub. Täna on mängida veel 60 minutit ning keskmine stäkk hetkel umbes 40XBB kandis.
Kes soovivad, võivad veel liituda, kuid kes mitte - neil on võimalik alustada päeva 1B kell 21:00.
20:32 (UTC+3)
Start of Level 9 Blinds: 400/800 Ante: 800
Janek, big ballsevitch! Posted Friday 19th July, 2024 at 20:19(UTC+3) by maheaaatom
Kaidar Viikman tõstab CO-lt 1600, Taago Tamm callib ning Janek Hin kolmpanustab BB-lt 4600. Mõlemad eestlased callivad.
Flopis avatakse ning Janek alustab 3500-ga. Kaidarilt kiire fold, Taago callib.
Turn on , Janek seekord checkib ning callib üsna kiirelt Taago 6600 panust.
Riverisse avatakse , Janekilt taas call ning Taago ründab 9500-ga. Janek ei anna alla.
Taago foldib kinniselt blufi, Janek avab
Vinge käsi, mida saadab "Batu" hüüe: "Janek, big ballsevitch!"
Ühtlasi algas ka päeva 1B teine paus, puhast mänguaega on jäänud veel tund.
P.S. Päeva viimase käega kaotasime Kristjan Laasi, kelle stäki omistas Mark Metsla.
Freebuy-satelliit on lõppenud Posted Friday 19th July, 2024 at 20:07(UTC+3) by maheaaatom
Lubatud seitsme pileti asemel paisus freebuy-satelliidi auhinnafond hulga rebuyde toel 17 piletini.
Pileti lunastas üheksa eestlast, nende seas ka näiteks selline staar nagu Allan Arjut. Palju õnne! Üks satelliit tuleb täna veel - kell 23:00 algab 555 € NLH satelliit, mille sisseost on 80 eurot ning garantiiks 10 piletit.
20:01 (UTC+3)
Start of Level 8 Blinds: 400/800 Ante: 800
Andrei pääseb kuningatega Posted Friday 19th July, 2024 at 20:00(UTC+3) by maheaaatom
Andrei Mjagkov kaotas vahepealse mänguga suure osa oma stäkist, kuid suutis seejärel kenasti kõik tagasi saada.
Käsi järgmine - floppi vaatasid Andrei ja Enea Subashi.
Enea checkis ette, Andrei pani 4000 ning Enea tõstis 10 000 peale. Andrei mõtles väga pikalt ning teatas seejärel, et on all-in (21 600). Enealt call.
Andrei:
Enea:
Meie mehe õnneks oli laud talle armuline ning turn ega river masti maha ei toonud.
Suuremate stäkkidega eestlasi Posted Friday 19th July, 2024 at 19:56(UTC+3) by maheaaatom
Player
Chips
Progress
Taago Tamm
97,000
12,000
Magnus Pukk
90,000
23,000
Kaidar Viikman
63,000
0
Hendrik Uibo
61,000
4,000
Janek Hin
60,000
0
Tom Richard Telson
58,500
0
Kristjan Laas
48,000
0
Tanel Evert
48,000
0
Roman Jezov
45,000
0
Kaspar Laursoo
42,000
0
Ka kolmed oleksid splitis osalenud Posted Friday 19th July, 2024 at 19:46(UTC+3) by maheaaatom
Tom Richard Teslon avab 1500-ga, saab calli tema järel istuvalt Ramon Randmalt ning all-in panuse (umbes 12K) ameeriklaselt Addy Bassanilt.
Tom Richard (umbes 60K) stäkk leiab, et seda on pisut palju, samuti ei taha ta n.ö. "võileiva vahele jääda". Aga Ramon callib ära.
Mõlemal on , flopis avatakse ning väidetavalt kolme pocketit omanud Tom Richard hingab kergendatult.
Aga turn ja river ning laud mängib.
Mida suudavad leedulased? Posted Friday 19th July, 2024 at 19:38(UTC+3) by maheaaatom
Talvisel Kings of Tallinnal andsid tooni Leedu pokkerimängijad, kes said ka põhiturniiril koguni kaksikvõidu.
WSOP Circuit'il osaleb neid tõenäoliselt siiski pisut vähem ning lootused pole ülearu kõrged. Küll mängis üsna palju Leedu mängijaid kaasa äsja Las Vegases lõppenud "suurel WSOP-l", kus õnnestus võita kaks käevõru, mõlemad seejuures hyper-turnadel.
Kui Eestil on üks WSOP käevõru, siis leedulastel koguni üheksa. Tõsi, enamus on saadud online-turniiridel.
Kas WSOP Circuit'ile saab ka panustada? Saab ikka! Posted Friday 19th July, 2024 at 19:34(UTC+3) by maheaaatom
WSOP Circuit põhiturniirile on võimalik ka panuseid teha ning kus mujal kui OlyBetis.
Mõned huvitavad koefid ka:
Eestlane võidab 2,75
Parim eestlane saab parima koha kui parim soomlane 2,00
Ranno Sootla saab finaallauda 20,0
Herli Olop saab finaallauda 50,0
Siiri ootab teist päeva Posted Friday 19th July, 2024 at 19:15(UTC+3) by maheaaatom
Eesti üks paremaid naismängijaid Siiri Saar kurdab kehva kaardijooksu üle ning tõdeb, et natuke igav on mängida. "Kahel korral olen pidanud vastase 3-beti peale pocket kümned foldima ning mõlemal korral olen ka õigesti teinud," tõdeb Siiri.
"Võiks juba teine päev tulla, siis saaks mängima hakata!" Siiril on umbes algstäkk (20K).
19:12 (UTC+3)
Start of Level 7 Blinds: 300/600 Ante: 600
Tõmme tõmbe vastu, kumbki ei taba Posted Friday 19th July, 2024 at 19:10(UTC+3) by maheaaatom
Turniks on lauas ning pangas umbes 6K.
Roman Jezov teeb 5200 panuse ning saab omajagu mõelnud Kristjan Laasilt calli.
River on ning Roman enam panustamiseks jõudu ei leia. Ka Kristjan otsustab checkida, küll sellise ilmega, et seda panka ma nagunii ei võida.
Põhjust selleks ju on, sest Kristjan () püüdis ebaõnnestunult rida ning kuningas-kõrgega midagi hõisata just pole.
Aga...Ka Romanil polnud midagi enamat kui mööda läinud mastitõmme (! Korralik pank hinnatud pokkerikommentaarile.
"Rahvaturniirile" ennustatakse kuuekohalist auhinnafondi Posted Friday 19th July, 2024 at 19:01(UTC+3) by maheaaatom
250 € NLH-l on neli avapäeva ning hiline registeerumine on avatud kuni teise päeva teise taseme lõpuni (pühapäeval umbes kell 13:00).
Päeva 1A on alustanud 146 mängijat ning kõik, kes välja langevad, saavad alati minna uuele katsele kas samal, mõnel järgmisel avapäeval või teisel päeval. Selleks, et auhinnafond oleks kuuekohaline, oleks nõutav umbkaudu 500 sisseostu, mis tundub hetkeseisuga vägagi reaalne number, eriti arvestades asjaolu, et üritus ju alle kogub hoogu.
See tähendaks võitjale päris magusat palgapäeva ning lisaks auhinnarahale on ju mängus ka festivali esimene kuldsõrmus.
Teleülekannete kava Posted Friday 19th July, 2024 at 18:54(UTC+3) by maheaaatom
TV-ülekanded on kavas neljast turniirist ning neid saab nautida alates teisipäevast (iga päev üks turniir):
Naisteturniiri finaal
555 € NLH finaal
1100 € PLO finaal
1500 € põhiturniir
18:47 (UTC+3)
Start of Level 6 Blinds: 200/500 Ante: 500
Taneli riskantne panus maksis 250 eurot Posted Friday 19th July, 2024 at 18:39(UTC+3) by maheaaatom
Tanel Evert läks buttonilt blindide järele ning kui Magnus Pukk talle 3K ületõstega vastas, lükkas Tanelo oma nupud kiirelt keskele. "Ma arvasin, et ta nagunii foldib," oli Tanel kindel.
Aga loodetud foldi asemel Magnus hoopis snapcallis ning seis on Tanelile kõike muud kui hea.
Magnus:
Tanel:
Laud tühi ning Tanelil tuli re-entry järele minna.
Taagol juba 85K, ka Hendrik on alustanud kenasti Posted Friday 19th July, 2024 at 18:37(UTC+3) by maheaaatom
Taago Tamm on suutnud oma stäkiga juba 85K peale kergitada ning virised ei saa ka Hendrik Uibo (57K).
"Normaalne algus," kõlab Hendriku lühike kommentaar. Väärib mäletamist, et Hendrik tegi endale nime just mullusel WSOP Circuit Tallinn põhiturniiril, mida mees mõnda aega ka juhtis. Lõpuks sai "noor püss" lisaks väärt kogemusele 14. koha ning lubas, et küllap kuuleme me temast veel. Kindlasti kuuleme!
Player
Chips
Progress
Taago Tamm
85,000
44,000
Hendrik Uibo
57,000
0
Aleksander Sebastian langeb läbi Arturi Posted Friday 19th July, 2024 at 18:26(UTC+3) by maheaaatom
Aleksander Sebastian Lattikas lükkab oma shortstäki (umbes 2,5K) all-in, tema järel teeb sama ka mulluse põhiturniiri kolmas mees Artur Külanurk.
Pisut "sügeleb" ka leedulane Liutauras Armanavicius, kuid calli siiski ei järgne.
Artur:
Aleksander:
Lauda tuleb ka kolmas äss, kõrgem kicker peab.
18:21 (UTC+3)
Start of Level 5 Blinds: 200/400 Ante: 400
Pausile sadakond mängijat Posted Friday 19th July, 2024 at 17:58(UTC+3) by maheaaatom
Täna on kaks pausi ning esimene neist sai just alguse. Sisseoste on hetkel tehtud 117 ning laudades sadakond mängijat.
Satelliit on samuti pausil ning hetkel oleme jõudnud 51 parimani. Tee piletiteni on siiski veel pikk, sest neid jagub kõigest seitsmele parimale.
Kaidar Viikman: Mul pole kindlat plaani, mängin mida jõuan Posted Friday 19th July, 2024 at 17:55(UTC+3) by maheaaatom
Viiekordne Eesti meister Kaidar Viikman on nimekas hobimängija, kes suutnud 2022., 2023 kui ka 2024. aastal vähemalt ühe Eesti meistritiitli napsata.
Selleks WSOP Circuit'iks Kaidaril väga suuri plaane ei ole, mängib mida jõuab. Põhiturniiri piletit pole veel õnnestunud saada, kuid satelliite on siiski veel küllalt tulemas. Ja kindlasti on Kaidar kohal 8-Game'is, mis talle alati väga meeldib ja ka sobib. Ka "rahvaturniiril" on mees kenasti kohal ning selgelt mängule keskendunud.
Andreil 67K Posted Friday 19th July, 2024 at 17:48(UTC+3) by maheaaatom
Andrei Mjagkov on teinud oma lauas head tööd ning tõusnud juba 67K, mis on omadest üks suurimaid.
Korraliku nupulisa sai äsja ka samas lauas istuv EMV 2024 üks edukamaid mängijaid Bahtijar Kulijev, kelle stäkk hakkas päris õhukeseks muutuma. Nüüd on mees umbes alguses tagasi.
Viljandi vs. Haapsalu Posted Friday 19th July, 2024 at 17:42(UTC+3) by maheaaatom
Tanel Evert ja Magnus Pukk on teada-tuntud live-mängijad, kes ikka ka suurturniiridel kohal. WSOP Circuit avaturniiril on mehed sattunud ühte lauda.
Tanel läheb CO-lt 700-ga ründama ning saab SB-lt Magnuse kaasa.
Flopis avatakse , Magnus checkib ette ja saab Tanelilt 500 panuse, mida ta ka callib.
Turn checkitakse läbi, riveri järel ründab juba Magnus 800-ga. Tanel väntab koheselt 3500 juurde ning saab vastu kiire foldi. Ju see äss seal ikka oli...
17:28 (UTC+3)
Start of Level 4 Blinds: 100/300 Ante: 300
Taagol 41K Posted Friday 19th July, 2024 at 17:28(UTC+3) by maheaaatom
Mulluse EMV põhiturniiri hõbemedalist ning nimekas highroller Taago Tamm (Eesti rahalisti 25. mees) on oma 20K algstäki duublisse saanud hetkel 41K peal.
"Bustinud ei ole, seega siiani kõik okei," naerab Taago ise.
Ühtlasi oleme juba jõudnud ka saja sisseostuni, väljalangejaid on hetkel kuus.
Esimesed langejad Posted Friday 19th July, 2024 at 17:17(UTC+3) by maheaaatom
Neli mängijat on saanud turniiriga "ühele poole", nende seas nii Sirle Puustamaa kui Joonas Kulli.
Tagasi pole kumbki veel ostnud, kuid sellega ei pea ka kiirustama, aga on teise päeva teise mängutaseme lõpuni. Esimesel päeval mängitakse niisiis 10 x 30 minutit.
Uutest tulijatest on laudades Magnus Pukk, Mark Metsla, Rain Kandla, Tanel Evert, Kaidar Viikman ning Madis Ormisson. "Kas see on siin mänguraha laud?" küsis Madis vahetult enne lauda istumist.
Infoks cashimängijatele Posted Friday 19th July, 2024 at 17:13(UTC+3) by maheaaatom
Eelmise nädala keskel võeti pikalt paisunud rahalaudade Bad Beat Jackpot lõpuks maha ning "õnnelikuks kaotajaks" osutus nimekas highroller Rikard Relander.
Olgu siis öeldud ka käsi: Rikardil olid käes pocket emandad, vastas aga .
Lauas avati kolm ässa ning - kaotas maja ja võitis mastirida.
Rikard sai umbes 35K, käe võitja poole vähem ning kõik ülejäänud lauas istunud mängijad umbes 2500/per nägu. Bad Beat Jackpot on hetkel 47K.
17:10 (UTC+3)
Start of Level 3 Blinds: 100/200 Ante: 200
Tutvustame ka meediatiimi Posted Friday 19th July, 2024 at 16:58(UTC+3) by maheaaatom
Olgu igaks juhuks ka öeldud, et Eesti meediatiim töötab tänavusel WSOP Circuit'il samas koosseisus, mis talvisel Kings of Tallinnal.
Hostess on Teele, videode eest vastutav Koit, fotode eest Lenka ning blogivad Hannes ja Mariliis. Blogime nii avaturniiri, naistekat (kuni finaallauni), põhiturniiri (alates teisest päevast kuni finaallauani) ning 3000 € highrollerit (algusest lõpuni).
Infoks neile, kes kõht tühi Posted Friday 19th July, 2024 at 16:49(UTC+3) by maheaaatom
Turniiridirektor Teresa tutvustas just mängijatele tänavust toitlustust. Kergemaid snäkke saab konverentsisaalis asuvast Olybet Bar & Grillist, vähe toekamaid sööke fuajees asuvast buffeest ning keda erutavad burgerid, friikad ja muu nn. tänavatoit, on oodatud külastama Kreutzwaldi ning Kunderi tänava nurgal asuvat food trucki.
Kevin Amon duubeldas läbi Joonas Kulli Posted Friday 19th July, 2024 at 16:44(UTC+3) by maheaaatom
Pangas umbes 3K ning turni järel oli lauas avatud .
Kevin Amon lükkas oma viimased 4,5K keskele ning sai pikalt mõelnud Joonas Kullilt ägiseva calli.
Kevin:
Joonas:
River ei muutnud midagi, kaks paari pidas.
Mis on täna veel kavas? Posted Friday 19th July, 2024 at 16:37(UTC+3) by maheaaatom
WSOP Circuit avapäev saab olema tõenäoliselt festivali kõige rahulikum, sest kavas on üheainsa sõrmuseturniiri (250 € NLH) kaks avapäeva (teine algab kell 21:00) ning kaks satelliiti.
Üks neist - nagu juba märgitud - on hetkel käimas (seal alles 108 parimat, pileti saab seitse) ning teine algab kell 23:00. Seal mängitakse välja vähemalt 10 x 555 € piletit ning satellidil osalemine maksab 80 eurot.
Pileteid saab ka flipates Posted Friday 19th July, 2024 at 16:32(UTC+3) by maheaaatom
Satelliidimängijad käisid äsja puhkamas ning selle ajal said soovijad ka "rahvaturniiri" piletitele flipata. Nagu ikka - lauatäis mängijaid ning võitjale pilet. Sateliiti võib muidugi edasi mängida, sest küllap kulub igaühele ka lisaelu ära.
16:31 (UTC+3)
Start of Level 2 Blinds: 100/100 Ante: 100
Tele-Siiri Posted Friday 19th July, 2024 at 16:26(UTC+3) by maheaaatom
Eesti naiste au esindavad hetkel Sirle Puustusmaa ja tänavuse EMV rahvaturniiri viies Siiri Saar, kellele see jääbki suure tõenäosusega selle aasta ainsaks sõrmuseturniiriks. Naisteka ajal tuleb tal teletööd teha ning seega saab kogu oma energia pühendada WSOP Circuit rahvaturniirile. Kerge laud Siiril just pole, tema vastas istub näiteks Artur Külanurk.
Mängu algus on väga rahulik, osalejad alles kogunevad. Vaikselt oleme jõudnud 59 alustajani, re-entry't pole veel keegi kirja saanud.
Kes on kohal 1A-l? Posted Friday 19th July, 2024 at 16:18(UTC+3) by maheaaatom
Tuntud Eesti mängijatest on laudas mullusel põhiturniiril kolmanda koha saavutanud Artur Külanurk ning lisaks temale ka mitmeid teisi tuntud nägusid:
Bahtijar Kulijev
Kristan Laas
Hendrik Uibo
Maksim Petrov
Siiri Saar
Taago Tamm
Turniir on alanud! Posted Friday 19th July, 2024 at 16:13(UTC+3) by maheaaatom
Esimesed 50 julget on laudades ning WSOP Circuit Tallinn rahvaturniiri päev 1A on läinud käima.
Juba kell ühest toimub Hiltoni suures saalis "rahvaturniiri" freebuy-satikas, kus tehtud 172 sisseostu. Overlayd veel tekkinud pole, välja jagatakse 7 piletit. Ka eestlasi on osalejate seas päris palju.
WSOP Circuit avaturniir algab reedel kell 15:00 Posted Thursday 18th July, 2024 at 22:38(UTC+3) by maheaaatom
Reedel, 19. juulil algab Olympic Park Casinos ning Hilton Park hotelli konverentsikeskuses kauaoodatud suurfestival WSOP Circuit Tallinn 2024.
Festivali avaturniiri sisseost on kõigest 250 € ning see sobib hästi ka kõigile hobimängijatele. Ootame kuuekohalist auhinnafondi ning lisaks korralikule preemiarahale ootab võitjat ka WSOP Circuit kuldsõrmus ning koht Las Vegases toimuvale WSOP meistrite turniirile.
Turniiril on neli avapäeva, neist igaüks vältab 10 taset ehk koos pausidega pisut alla kuue tunni. Reedel mängitakse 1A (kell 15:00) ja 1B (kell 21:00). Lubatud on piiramatu re-entry. Eestikeelne ülekanne kestab kuni finaallauani või kuni omad on mängus.
Your search results are valid for .
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.