0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0088 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1_est/1A/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.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0005 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.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` = 'page'
0.0038 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` = 'wsopctallinn_2023_event1_est'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'
0.0314 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0070 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '95'
AND `published` = 1
0.0361 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0088 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '105'
AND `published` = 1
0.0362 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0087 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '107'
AND `published` = 1
0.0470 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0077 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '110'
AND `published` = 1
0.0380 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0092 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '114'
AND `published` = 1
0.0006 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'
AND `name` = '1A'
0.0083 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '95'
ORDER BY `busted` ASC, `current_chips` DESC
0.0082 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` = '95'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0101 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4424'
ORDER BY `chip_change` DESC, `busted` ASC
0.0205 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4423'
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` = '4422'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4421'
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` = '4420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4419'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4418'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4417'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4416'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4415'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4414'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4413'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4412'
ORDER BY `chip_change` DESC, `busted` ASC
0.0172 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4411'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4410'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4409'
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` = '4408'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4407'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4406'
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` = '4405'
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` = '4404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4403'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4402'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4401'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4400'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4399'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4397'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4396'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4395'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4394'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4393'
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` = '4392'
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` = '4391'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4390'
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` = '4389'
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` = '4388'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4387'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4386'
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` = '4385'
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` = '4384'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4383'
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` = '4382'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4381'
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` = '4380'
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` = '4379'
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` = '4378'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '95'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 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` = '95'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4424'
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` = '4423'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4422'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4421'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4420'
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` = '4419'
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` = '4418'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4417'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4416'
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` = '4415'
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` = '4414'
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` = '4413'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4412'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4411'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4410'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4409'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4408'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4407'
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` = '4406'
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` = '4405'
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` = '4404'
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` = '4403'
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` = '4402'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4401'
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` = '4400'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4399'
ORDER BY `chip_change` DESC, `busted` ASC
0.0116 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4397'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4396'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4395'
ORDER BY `chip_change` DESC, `busted` ASC
0.0116 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4394'
ORDER BY `chip_change` DESC, `busted` ASC
0.0116 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4393'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4392'
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` = '4391'
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` = '4390'
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` = '4389'
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` = '4388'
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` = '4387'
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` = '4386'
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` = '4385'
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` = '4384'
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` = '4383'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4382'
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` = '4381'
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` = '4380'
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` = '4379'
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` = '4378'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '114'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 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.
Eestlaste stäkid päeva 1A järel Posted Thursday 14th September, 2023 at 19:26(UTC+3) by maheaaatom
Raivo Pinsel lõpetab päeva 1A ülivõimsa liidrina - tema stäkk on kaks korda suurem kui järgmisel!
Mängu pääses jätkama täpselt tosin Eesti mängijat. Kohtume nendega uuesti juba laupäeval. Meie ülekanne jätkub aga juba kell 19:00, mil algab päev 1B.
Player
Chips
Progress
Raivo Pinsel
219,000
144,000
Ilya Nikiforov
92,000
62,000
Igor Pihela vanem
81,000
51,000
Mart Rinken
72,500
42,500
Kert Hallik
61,500
31,500
Magnus Pukk
49,500
28,500
Rasmus Sepping
48,500
18,500
Rauno Remmel
48,000
18,000
Mairo Tori
44,500
45,500
Alari Kadanik
43,500
13,500
Raimo Reimann
43,500
13,500
Tanel Merida
13,000
17,000
Päev 1A on lõppenud Posted Thursday 14th September, 2023 at 19:07(UTC+3) by maheaaatom
Päev 1A on lõppenud ning allesjäänud mängijad ajavad nuppe kottidesse. Mängu jätkab 28 parimat.
Peagi avaldame allesjäänute täpsed stäkid ning WSOP Circuit Ring Event #1 jätkub juba täna kell 19:00 päevaga 1B. Lisaks on meil täna kavas ka kaks väga korraliku value'ga satelliiti, mis algavad vastavalt kell 21:00 ning 23:00.
Läheneme lõpule Posted Thursday 14th September, 2023 at 19:00(UTC+3) by maheaaatom
Mängitakse kolme viimast kätt, alles on 28 mängijat neljal laual.
Eestlastest on väljas nii Jaana Kindsigo kui Taago Tamm, kuid kõigi eelduste kohaselt võime neid näha mängimas juba järgmistel stardipäevadel.
Meelis käis tuttavat õhku nuusutamas Posted Thursday 14th September, 2023 at 18:57(UTC+3) by maheaaatom
Turniirialalt kõndis läbi mitmekordne Eesti meister ning endine Olympic Casino pokkerimänedžer Meelis Vist, kes ütles tuttavatele tere ning suundus siis kõrvalsaali Hiina pokkerit mängima. Seal on juba 16 osalejat, teiste seas ka tema endine ülemus Jaan Vaabel.
Meelise hinnangul on päris mõnus taas mängijana turniirisaalis käia. "Pokkerimänedžeri töö on raske, eriti suurfestivalide ajal," sõnas Meelis ning palus kindlasti hinnata ka oma järeltulija - samuti Meelise (Ahman) - tööd ja panust.
Raivo on sõiduvees Posted Thursday 14th September, 2023 at 18:53(UTC+3) by maheaaatom
Raivo mängib kartmatult ning tal pole midagi väikeste stäkkide all-in'ide callimise vastu.
Ukrainlane Yehor Moroz on viimane, kes proovib. Ja Raivo võtab kohe ka väljakutse vastu.
Yehor:
Raivo: . Äss ja paar tulevad küll lauda, kuid kicker jääb mängima. Ja see on meie mehel suurem. Raivo nüüd julgelt üle 200K.
Igor võtab duubli Posted Thursday 14th September, 2023 at 18:44(UTC+3) by maheaaatom
Floppi vaatab kolm meest - Igor Pihela, Mairo Tori ja Jose Zaragoza.
Jose ja Igor checkivad ette, jättes käiguõiguse Mairole. Tulebki 2500 panus. Jose callib, Igor tõstab 7500-le ja saab kaks calli.
Turn on , seekord avab juba Igor 8000-ga. Mairo loobub, kuid konkurentidest selgelt suurema stäkiga Jose läheb all-in. Igor callib.
Jose:
Igor: . River blank.
18:39 (UTC+3)
Start of Level 10 Blinds: 600/1,200 Ante: 1,200
Raivo Pinsel 150K Posted Thursday 14th September, 2023 at 18:23(UTC+3) by maheaaatom
Hetkeseisuga on liidriohjad Raivo Pinseli käes. Tal on umbes 150K stäkk ning rohkem pole kellelgi vastu panna.
"Vara veel žetoone lugeda. Kui saab nupud kottidesse, siis vaatame," kommenteerib Raivo ise.
Player
Chips
Progress
Raivo Pinsel
150,000
75,000
Kes ütles, et "hiinlasi" pole. On ikka! Posted Thursday 14th September, 2023 at 18:11(UTC+3) by maheaaatom
150-eurone Hiina pokker läks kenasti käima. Hetkel 10 alustajat, neist neli on eestlased. Mati Pirni osalejate nimekirjas (veel) ei ole.
Soomlastest on aga juba kohal vanameister Jukka Juvonen, kes mängis Eestis kaarte tõenäoliselt vist juba siis kui Viru hotelli ehitati. Texas Holdem turniiridel teda juba ammu vähga ei näe, kuid Hiina pokker on Jukkale vägagi südamelähedane.
Viimased kaks taset Posted Thursday 14th September, 2023 at 18:09(UTC+3) by maheaaatom
555 € turniiri avapäeva on mängida veel kaks mängutaset, mis vältavad täpselt tunni. Seejärel on tund aega pausi ning algab päev 1B.
Hetkel laudades 33 mängijat, alustajaid oli 52. Eestlastest on mänguga liitunud veel viiekordne Eesti meister Kert Hallik.
18:05 (UTC+3)
Start of Level 9 Blinds: 500/1,000 Ante: 1,000
Too many outs Posted Thursday 14th September, 2023 at 17:50(UTC+3) by maheaaatom
Viimases pausieelses käes kaotab umbes neljandiku oma stäkist Taago Tamm, kes on sunnitud callima Jose Zaragoza all-in panust pärast floppi .
Taagol on küll kümned, kuid hispaanlasel suht ideaalne tõmme -ga. "Too many outs," pomiseb Taago ning õigus tal on. Turn toob rea, river ka masti.
Taagol jääb umbes 70K järgi ning algas teine paus.
"Hiinlane" Roland ootab mängukaaslasi Posted Thursday 14th September, 2023 at 17:41(UTC+3) by maheaaatom
Kuna Roland ei saa laupäeval mängima tulla, jätab ta 555-eurose avaturniiri vahele. Küll suundub ta aga kell 17:00 algavale hiinakale.
"Kas sa tead, et oled hetkel ainuke mängija?" kuuldub floorilt. Aga Roland ei lase tujul langeda. "Küll tuleb siit juurde, vahet pole - võin ka heads-up mängida. Siis on kuueks läbi."
Ajalugu on näidanud, et peamise Hiina-pokkeri mängijaskonna moodustavad põhjanaabrid. Aga tänaseks pole nad veel Olympic Casinosse saabuda. Seega, kas ootame tõesti Rolandi ja hiinakate regulari Mati Pirni heads-up?
17:26 (UTC+3)
Start of Level 8 Blinds: 400/800 Ante: 800
Raivo tõuseb 100K peale Posted Thursday 14th September, 2023 at 17:25(UTC+3) by maheaaatom
Mark Metsla lükkab oma 26 900 keskele ning Raivo Pinsel ei jäta callimata. Tulemuseks flip - Raivol ja Markil . Lauda jookseb rida , Marki õnnestuseks on aga ülemine ots Raivo käes.
Niigi heas seisus olnud Eesti vanameister tõuseb nüüd juba 100K peale.
Hullumeelne bluff ja hullumeelne call Posted Thursday 14th September, 2023 at 17:15(UTC+3) by maheaaatom
Rasmus Sepping ja Mairo Tori mängisid hullumeelse jaotuse, mida ei õnnestunud küll kahjuks algusest peale näha.
Kui lauas olid avatud kõik viis kaarti - (ilma mastivõimaluseta), checkis Rasmus Sepping ette, Mairo tegi 5K panuse ning Rasmus läks oma 40K stäkiga all-in. Ega Mairolgi rohkem olnud.
Mairo mõtles terve igaviku, kuid otsustas siis callida. Kui kaardid avati, oli kogu laud enam kui hämmeldunud.
Rasmus:
Mairo: !
"Bu...t!" karjatas meeste vastas istuv Jaana. "Ma mõtlesin, et sul olid ikka kunnid või midagi."
Mairol nüüd umbes 90K. Rasmus ainult muigas ning kommenteeris, et tundus nagu hea koht lükkamiseks...
Player
Chips
Progress
Mairo Tori
90,000
60,000
Alessandro hammustas Igorilt Posted Thursday 14th September, 2023 at 17:00(UTC+3) by maheaaatom
Alari Kadanik, Igor Pihela ja Alessandro Angotti ajasid panga päris suureks juba enne floppi .
Eestlased checkisid kuni itaallaseni, kes panustas 3500 ning sai calli vaid Igorilt.
Turn checkiti läbi, riveri järel ründas juba Igor 6600-ga. Tulutult, Alessandro callis hetkega maha. Igor avas pocket soldatid, itaallasel oli .
16:50 (UTC+3)
Start of Level 7 Blinds: 300/600 Ante: 600
Kreeka vs. Hispaania Posted Thursday 14th September, 2023 at 16:49(UTC+3) by maheaaatom
Et turniiril osaleb ka Hispaania mängijaid, ei tuleks tulla kellelegi üllatuseks, sest Eestis elab ju lausa trobikond matadooride-maa pokkeriproffe, kes ka aktiivselt live-festivalidest osa võtavad. Aga lauas on (juba) ka vähemalt kolm kreeklast.
Üks hispaanlane - nimelt Victor Garcia - sai aga just suuremast osast oma stäkist lahti. Vastas Kreeka mees Enea Subashi ning juba flopieelne paugutamine viitas sellele, et kumbki ei kavatsegi enne riveri alla anda.
Flopile järgnes Victori 5K panus (Enea checki järel) ning Enea call.
Turni järel checkis Enea taas ette ning läks Victori 10K panuse järel all-in (ega tal palju rohkem järgi olnudki).
Victor avas ning lootis vist küllap ainult sellele, et kreeklasel jumala eest ässasid ei oleks.
EI olnudki, hoopis flopis tabatud set -ga.
Raivo flippab mööda Posted Thursday 14th September, 2023 at 16:37(UTC+3) by maheaaatom
Turske leedulane Vasilij Barna on kasutamas juba oma kolmandat bulletit ning kaugele ei jäänud ka see, et tulnuks neljanda järele haarata.
Mehe viimased 12 100 läksid keskele Raivo Pinseli vastu ning tulemuseks seekord flip.
Raivo:
Vasilij:
Lauas numbripuru ja Leedu esindajale duubel.
16:32 (UTC+3)
Start of Level 6 Blinds: 200/500 Ante: 500
Kolm suurimat eestlast Posted Thursday 14th September, 2023 at 16:32(UTC+3) by maheaaatom
Meie mängijatest on üsna korralik seis nii Magnus Pukil, Raivo Pinselil kui ka Taago Tammel.
Tuletame meelde, et algstäkk on 30 000 ning hetkel on käimas kuues tase (blindid 200/500/500). Kuna mõned mängijad on ka välja langenud, toimetatakse keskmiselt umbes 70XBB stäkkidega.
Player
Chips
Progress
Magnus Pukk
78,000
48,000
Raivo Pinsel
75,000
45,000
Taago Tamm
67,000
37,000
Tõsine tegija USA-st Posted Thursday 14th September, 2023 at 16:21(UTC+3) by maheaaatom
Kolmandasse lauda on jõudnud ameeriklane James Little, kes on juba võrdlemisi kõva tegija.
Oma karjääri jooksul on mees kogunud enam kui 680 tuhande dollari väärtuses Hendoni-cashe, seejuures tulnud korra ka teiseks 2019. aasta WSOP PLO-turniiril. Teadaolevalt tal küll ühtegi WSOP käevõru või sõrmust ei ole, küllap ta nende järgi Tallinnasse saabus.
Eeldatavalt võib Tallinnasse tulla 20-30 ameeriklast, neist paljudele on Eesti uus ja põnev sihtkoht. Samas tuleb jällegi arvestada, et tegemist on ikkagi Euroopa äärealaga ning proffide jaoks on siia sõitmine üsna aeganõudev ja kulukas.
Mart on mängus tagasi...ja annab kohe duubli Posted Thursday 14th September, 2023 at 16:10(UTC+3) by maheaaatom
Raimo Reimann lükkab oma 10K stäki keskele ning saab kiire calli äsja re-entry teinud Mart Rinkenilt.
Raimo:
Mart:
Floppi potsatab kaheksa ning et turn toob lauda maja, millega Mart on drawing dead.
Uusi mängijaid Posted Thursday 14th September, 2023 at 15:56(UTC+3) by maheaaatom
Pausiga lisandus veel kuus uut mängijat. Üheks neist on Rasmus Sepping, kes sai tuntuks 2022. aasta suurfestivalil King of Tallinn, kus võitis kahepäevase 550 € NLH turniiri.
Aga lauda on istunud ka Ilya Nikiforov, kes istub Eesti rahalistis üheksandal kohal. Sel mehel on samuti WSOP-ga oma suhe, nimelt sai ta mullu suvel Las Vegases toimunud 7000 $ turboturniiril kõrge kolmanda koha.
Mart Rinken ei suutnud oma 3000 nööbiga imesid teha ning peab re-entry järele minema.
15:52 (UTC+3)
Start of Level 5 Blinds: 200/400 Ante: 400
Magnusel läheb hästi Posted Thursday 14th September, 2023 at 15:25(UTC+3) by maheaaatom
2022. aasta EMV põhiturniiri võitja Magnus Pukk on esimesed neli levelit korralikult "laamendanud" ning läheb esimese pausile umbes 85K stäkiga. Rohkem ei paista kellelgi olemat.
Oleme tagasi 20 minuti pärast.
Mart on raskustes Posted Thursday 14th September, 2023 at 15:23(UTC+3) by maheaaatom
Nimekas Tartu pokkeriproff Mart Rinken kaotas just suure panga ning hetkel on tal vaid mõni tuhat nööpi järgi.
-ga agressiivselt mänginud Mart sai pärast turni rea (lauas ), kuid tema õnnetuseks riveril () laud paardus. Ning Mart mõtles end vastase all-in tõste järel otsekui halliks, kuid foldida ei suutnud. Oligi ...
Pidurid maas? Posted Thursday 14th September, 2023 at 15:17(UTC+3) by maheaaatom
Kuigi mänguruumi on keskmiselt veel 100xBB jagu, on juba leidnud paar mängijat, kes on mängukaaslaste sõnul "hulluks läinud".
Tulemuseks see, et saime pärast Tanel Everti langemist veel kaks kiiret väljakukkujat. Kuna tegemist on välismaalastega, võime olla ka üsna kindlad, et nad lähevad otsemaid re-entryt tegema.
Vee üks laud juurde Posted Thursday 14th September, 2023 at 15:06(UTC+3) by maheaaatom
Oleme jõudnud viienda lauani, hetkel mängus 32 pokeristi. Kuna alustajaid oli 33, siis on tõepoolest üks mängija ka välja langenud. Ja tegemist on kogenud Haapsalu harrastusmängija Tanel Evertiga.
Vähesed uued tulijad on kõik välismaalased. Juba oli näha ka ühte pokkerisõpra turniirialal ka päris suure reisikohvriga ringi kärutamas.
15:03 (UTC+3)
Start of Level 4 Blinds: 100/300 Ante: 300
Tanel Royalit ei saa Posted Thursday 14th September, 2023 at 14:50(UTC+3) by maheaaatom
Jaana-Taago lauas (nimetagem seda nii, sest nemad kaks on seal kõige aktiivsemad mängijad) läheb viimane tavapärase 3XBB tõstega blindide järele ning saab kaasa Tanel Merida.
Flop chckitakse läbi, turni järel paneb Taago 1200. Ja saab calli ka.
River on , masti lauda ei tule. Tanel alustab taas checkiga ning samaga vastab ka Taago.
Tanel näitab ning pomiseb juurde, et "näe Royal ka ei tule". Taago korjab pisike panga maha.
Jaana varbad on jääs Posted Thursday 14th September, 2023 at 14:40(UTC+3) by maheaaatom
Turniiri (seni) ainsal Eesti naismängijal Jaana Kindsigol on külm, naise jutu järgi olevat tal varbad suisa jääs. Turniirialal on muidu sama temperatuur nagu alati, ju on siis Jaana lihtsalt kliimaseadme alla sattunud.
"Tooge talle teed," vihjab Mart Rinken kõrvallauast, kuid Jaana vastab kiirelt, et teed ta küll ei tohi. Floor pakub bleedi, kuid seegi Jaanale ei meeldi. "Homme tuleb vist kasukaga tulla," kommenteerib ta viimaks.
Mõned mängijad on veel juurde tulnud, oleme hetkel 29-kesi. Ohvreid veel ei ole.
14:27 (UTC+3)
Start of Level 3 Blinds: 100/200 Ante: 200
Kaks mängutaset lõppenud, laudades 26 mängijat Posted Thursday 14th September, 2023 at 14:27(UTC+3) by maheaaatom
26 siiani alustanud mängijast on kõik 26 ka kenasti laudades, re-entry järele pole veel keegi jooksnud. Hiiglaslikul turniirialal on muidugi veel väga vaikne, sest välismaalaste hordid pole veel kohale jõudnud.
Just liitus turniiriga esimene soomlane Tapio Aaltonen, aga ka tema elab ju teatavasti Eestis ning ei pea Olympic Casinosse laeva või lennukiga sõitma.
Meistrisõrmuse jahil Posted Thursday 14th September, 2023 at 14:22(UTC+3) by maheaaatom
Teadaolevalt pole veel ükski eestlane siiani WSOP Circuit meistrisõrmust võitnud. Jah, meil on WSOP käevõru omanik Ranno Sootla (kes sai sellega samuti õigus Meistrite Turniiril osaled), kuid Circuit turniire pole Eestis veel kunagi toimunud ning USA-s ja vähemalt määral ka Euroopas tiirelnud WSOP Circuit pole Eesti mängijate seas veel piisavalt tuntud.
Käimasoleva turniiri võitja saab aga WSOP Circuit meistrisõrmuse ning miks ei võiks see olla eestlane? Üks asi on sõrmus, teine aga sellega kaasnev pääse 2024. aasta juunis Las Vegases toimuvale WSOP Tournament of Champions 1M$ freerollile.
Seega - tulge julgelt mängima ning kui teil läheb hästi, siis oletegi juba omadega Las Vegases!
Rahulik kolmveerandtund Posted Thursday 14th September, 2023 at 14:18(UTC+3) by maheaaatom
Esimesed 45 minutit on möödunud erakordselt rahulikult, Taago Tamm on küll kolleegide sitkust proovinud, kuid ülearu pea ees pole küll keegi veel tormama hakanud.
Päeval 1A (nagu ka päeval 1B, 1C ja 1D) on kaks pausi, vastavalt pärast neljandat ja kaheksandat taset.
14:09 (UTC+3)
Start of Level 2 Blinds: 100/100 Ante: 100
Liitunud ka Taago Tamm ja Igor Pihela vanem Posted Thursday 14th September, 2023 at 14:01(UTC+3) by maheaaatom
Lauas on võtnud istet ka vaalad Taago Tamm ja Igor Pihela vanem. Mõlemad on tuntud oma agressiivse mängu poolest ning küllap hakkavad nad mõlemad ka gaasi vajutama.
Lisainfoks, et alustati 30K algstäkiga ning blindid hetkel 100/100/100 (mängutase 2). Lubatud on piiramatu re-entry kuni 12 mängutaseme lõpuni (see siis juba laupäeval).
TV-lauad alustavad 17. septembril Posted Thursday 14th September, 2023 at 13:49(UTC+3) by maheaaatom
Infoks neile, kes ootavad TV-lauda : see läheb käima 17. septembril (pühapäev) kell 12:30. Kantakse üle nii 555 € kui 1100 € Ring Eventi finaallauda. (Üritusel on kaks telelauda).
Seni piirdume blogiga ning nagu lubatud - lisaks hetkel fookuses olevalt 555 € turniirile hoiame siin silma peal ka kogu üritusel.
WSOP Circuit Tallinn 2023 on alanud! Posted Thursday 14th September, 2023 at 13:29(UTC+3) by maheaaatom
Esimesed 20 mängijat on laudades ning kaardid õhus. Alustatakse kolmel laual.
Täpselt tosina osalejatest moodustavad eestlased, kelleks on Mark Metsla, Tanel Evert, Jaana Kindsigo, Alari Kadanik, Rain Kandla , Tanel Merida, Raivo Pinsel, Magnus Pukk, Raimo Reimann, Rauno Remmel, Mart Rinken ja Mairo Tori.
Tänased turniirid Posted Thursday 14th September, 2023 at 13:25(UTC+3) by maheaaatom
Täna on fookuses 555 € RING EVENT #1, toimumas kaks heat'i - 1A ja 1B. Mõlemat mängitakse 10x30 min., heat 1B algab kell 19:00 ning lõppeb pisut pärast südaööd.
Lisaks on kavas 150 OFC Pineapple (Hiina pokker) algusega kell 17:00 ning kaks satelliiti:
- Kell 21:00 algab 150 € mega-satikas põhiturniirile, 10 kohta GTD!
- Kell 23:00 algab 60 € satikas 555 € turniirile, 5 kohta GTD
Olympic Casino on festivaliks valmis Posted Thursday 14th September, 2023 at 13:18(UTC+3) by maheaaatom
Olympic Casino on festivaliks valmis ning turniiriala on enneolematult suur. Lauad on avatud nii fuajees, suures konverentsisaalis kui ka teistes ruumides. Cashi saab mängida kasiinos ning vajadusel ka ülemisel korrusel. Ühesõnaga - kõik näeb välja piisavalt uhke!
Turniiri algus veidi venib, sest kohal on veel liiga vähe mängijaid. Aga see on küllap vaid aja küsimus.
Tere tulemast suurfestivalile WSOP Circuit Tallinn! Posted Wednesday 13th September, 2023 at 00:07(UTC+3) by maheaaatom
14.-24. septembril toimub esmakordselt Tallinnas kauaoodatud megafestival WSOP Circuit, mis kulmineerub 1M € GTD põhiturniiriga. OlyBet ning Olympic Casino toovad Eesti lugejateni eestikeelse live- blogi, mis keskendub meie mängijate tegemistele ning jagab vahetuid muljeid turniirialalt.
Festivali esimesel neljal päeval on fookuses Ring Event #1 555 € No Limit Holdem, mille võitja saab WSOP Circuit meistrisõrmuse ning pääsme 2024. aasta juunis Las Vegases toimuvale WSOP meistrite turniirile. Selle turniiri kõrvalt jälgime vilksamisi ka kõiki teisi turniire, millel toimuvaid kõige olulisemaid sündmusi saate lugeda siinsamas blogis.
Kuna üritus on tõeliselt erakordne, siis soovitame kõikidel Eesti pokkerifännidel seda Olympic Casinosse kasvõi niisama vaatama tulla. Soovime häid pokkerielamusi nii mängijatele kui kõikidele kaasaelajatele, parimaid ootab Las Vegas!
23:55 (UTC+3)
Day 1A of WSOPC Tallinn Started Level:Blinds: 0/0 Ante: 0
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.
vaatab kolm meest - Igor Pihela, Mairo Tori ja Jose Zaragoza.
, seekord avab juba Igor 8000-ga. Mairo loobub, kuid konkurentidest selgelt suurema stäkiga Jose läheb all-in. Igor callib.
-ga. "Too many outs," pomiseb Taago ning õigus tal on. Turn 
toob rea, river 
ka masti. 
.
checkiti läbi, riveri 
-ga agressiivselt mänginud Mart sai pärast turni rea (lauas 
ning pomiseb juurde, et "näe Royal ka ei tule". Taago 
£ GBP
$ USD
€ EUR
