0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0082 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1_est/1C/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0004 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.0003 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.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0003 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.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 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.0039 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.0006 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.0293 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0067 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '95'
AND `published` = 1
0.0274 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '105'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0068 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '107'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '110'
AND `published` = 1
0.0273 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '114'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'
AND `name` = '1C'
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '107'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 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` = '107'
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` = '4514'
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` = '4513'
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` = '4512'
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` = '4508'
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` = '4505'
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` = '4503'
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` = '4502'
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` = '4501'
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` = '4500'
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` = '4499'
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` = '4498'
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` = '4497'
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` = '4496'
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` = '4495'
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` = '4494'
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` = '4493'
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` = '4492'
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` = '4491'
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` = '4490'
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` = '4489'
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` = '4488'
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` = '4487'
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` = '4486'
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` = '4485'
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` = '4484'
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` = '4483'
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` = '4482'
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` = '4481'
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` = '4480'
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` = '4479'
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` = '4478'
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` = '4477'
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` = '4476'
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` = '4475'
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` = '4474'
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` = '4473'
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` = '4472'
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` = '4471'
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` = '4470'
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` = '4469'
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` = '4468'
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` = '4467'
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` = '4466'
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` = '4465'
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` = '107'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 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` = '107'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4514'
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` = '4513'
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` = '4512'
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` = '4508'
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` = '4505'
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` = '4503'
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` = '4502'
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` = '4501'
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` = '4500'
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` = '4499'
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` = '4498'
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` = '4497'
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` = '4496'
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` = '4495'
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` = '4494'
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` = '4493'
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` = '4492'
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` = '4491'
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` = '4490'
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` = '4489'
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` = '4488'
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` = '4487'
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` = '4486'
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` = '4485'
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` = '4484'
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` = '4483'
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` = '4482'
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` = '4481'
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` = '4480'
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` = '4479'
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` = '4478'
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` = '4477'
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` = '4476'
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` = '4475'
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` = '4474'
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` = '4473'
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` = '4472'
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` = '4471'
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` = '4470'
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` = '4469'
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` = '4468'
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` = '4467'
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` = '4466'
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` = '4465'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 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 1C järel Posted Friday 15th September, 2023 at 19:03(UTC+3) by maheaaatom
Päeval 1C tehti 123 sisseostu ning üles elas selle koguni 76 mängijat. Nii kõrget "ellujäämise protsenti" pole olnud ei päeval 1A ega 1B. Eestlasi jätkab 23, koos päevadega 1A ja 1B on neid seega kokku 39.
Päevade 1A, 1B ja 1C peale kokku on tehtud meie arvestuse kohaselt 224 sisseostu ning edasipääsejaid on kokku 125. Lisa on aga oodata päevast 1D ning ka homsest, sest esimese kahe taseme jooksul on samuti sisseostud lubatud.
Oleme tagasi kell 19:00 ning jätkame siis juba Ring Event #1 neljanda ehk viimase alagrupiga (1D).
Player
Chips
Progress
Igor Pihela noorem
109,000
79,000
Arko Akenpärg
100,500
70,500
Mario Jürgens
90,500
60,500
Viktor Blinov
89,500
59,500
Urmo Velvelt
89,500
59,500
Janek Tammsaar
78,500
48,500
Tanel Evert
52,000
22,000
Martin Venno
51,000
21,000
Janar Kokk
40,500
0
Maksim Petrov
40,000
500
Maikel Homin
38,500
8,500
Danel Kunman
35,500
5,500
Marko Vest
35,000
5,000
Tanel Koht
34,000
4,000
Marten Oks
33,000
3,000
Aleksei Smirnov
29,000
1,000
Siim Suviste
28,500
1,500
Tarmo Tammel
27,000
3,000
Andrei Mjagkov
26,000
4,000
Hanno Kerem
25,000
5,000
Ermo Kosk
25,000
5,000
Kaur Ajamaa
24,000
36,000
Oskar Ojaveer
22,500
7,500
Iga käsi võib võita Posted Friday 15th September, 2023 at 18:42(UTC+3) by maheaaatom
Üsna paljudel mängijatel on kombeks viimaste kätega suruma minna, sest lõppude lõpuks, mis mõte on ministäkiga teist päeva alustada?
Mario Jürgensil oli enne viimast jaotust 28K, mis üsna võrdne algstäkiga. Aga proovima ta ometi läks - -ga.
Vastas veel kolm all-in'i: , ja . Aga lauda kenasti rida ja Mario saigi ühtäkki mäele.
Nüüd on päev 1C läbi ning ootame lõplikku stäkkide seisu.
3 viimast kätt Posted Friday 15th September, 2023 at 18:34(UTC+3) by maheaaatom
Päev 1C läheneb lõpule, turniiridirektor palus jagada välja kolm viimast kätt. Vahepeal on oma stäkist saanud lahti ka Ermo Kosk, kuid loomulikult tegi kuuekordne Eesti meister ka kohese re-entry. Küllap üritab ta viimaste kätega lisa saada.
Tarmole ikkagi re-entry. Aga õnnetult. Posted Friday 15th September, 2023 at 18:22(UTC+3) by maheaaatom
Tarmo Tammel läheb esimese duubli järele ning saab vägagi soodsa olukorra: seitsmed kolmede vastu.
Ja mis peamine, riverisse tuleb seitse ka. Kena punane ärtu seitse. Aga häda selles, et tegemist on neljanda ärtuga ning vastasel on ärtu kolm...
Midagi pole teha, tuleb re-entry ikkagi ära teha.
Käes on Omaha-aeg! Posted Friday 15th September, 2023 at 18:13(UTC+3) by maheaaatom
Fuajees pandi käima PLO 4/5 Cards, mida alustas 14 mängijat. Nende seas on ka kaks Eesti esindajat, Olympicu pokkeriklubi all-time regular nr. 1 nende seas. Kellega tegemist? Mõistagi vanameister Aleksandr Klepatšiga!
18:11 (UTC+3)
Start of Level 10 Blinds: 600/1,200 Ante: 1,200
Tammel vajab kolme duublit Posted Friday 15th September, 2023 at 18:09(UTC+3) by maheaaatom
Tarmo Tammel on jäänud 1C-l üsna märkamatuks ning põhjus on lihtne - ega tal pole ka väga nuppe, millega mängida. Hetkel vireleb Tarmo umbes 5K stäkiga ning vajab enda sõnul kolme duublit, et keskmise peale saada.
Teisalt on Tarmo jälle see mängija, kes isegi väikese stäki ja re-entry võimaluse olemasolul oma nuppe niisama tuulde ei pillu ega asjatult gämblema ei lähe. Hoiab üsna visalt igast oma nööbist kinni.
Dmitri kaotas oma nupud Igorile, Jesuse ebaõnn jätkus Posted Friday 15th September, 2023 at 17:58(UTC+3) by maheaaatom
Dmitri Dudakov lükkas oma viimased 10K sisse -ga ning sai calli Igor Pihela -lt.
Lauda veel üks kuningas. "Sa said ühe-oudise," naerdi lauast.
Kõrvallauas jätkus Jesus Martineze tragöögia. Ta sai küll sisse kuningatega Kazimieras Ramaska vastu, kuid viimasel õnnestus turni äss tõmmata. Meeste stäkid olid üsna võrdsed, leedukal küll pisut enam. Eesti hispaanlane tänas konkurente viisakalt mängu eest ning suundus tuniirialalt välja. Kas re-entry järele?
Igoril on hea seis, Ermo naudib massaaži, Martin Venno duubeldas Posted Friday 15th September, 2023 at 17:51(UTC+3) by maheaaatom
Põgus pilguheit eestlaste stäkkidele näitab, et igati heas seisus on Igor Pihela noorem, kel umbes 100K. Nurgatagune "eestlaste laud" on laiali löödud, selle rikkaim mees Kaur Ajamaa istub nüüd uues lauas 75K stäkiga. Ermo on ka natuke tõusnud (50K) ning on teadaolevalt esimene mees, kes massööridele tööd annab.
Ka Martin Vennol õnnestus just duubel saada läbi Eesti hispaanlase Jesus Martinezi. Nupud läksid enne floppi, Martin oli ees (ässad versus emandad) ning ette ta ka jäi.
Player
Chips
Progress
Igor Pihela noorem
110,000
80,000
17:41 (UTC+3)
Start of Level 9 Blinds: 500/1,000 Ante: 1,000
Aeg valmistuda Omahaks Posted Friday 15th September, 2023 at 17:41(UTC+3) by maheaaatom
Tänane kõrvalturniir, 350 € PLO 4/5 Cards algab kell 17:00 ehk umbes 20 minuti pärast. Alustatakse 30 000 punktiga, tasemed vältavad 20 minutit ning re-entry periood kestab kuni kaheksanda taseme lõpuni.
Kuna tegemist on kõrvalturniiriga, siis olgu igaks juhuks öeldud, et võitjale WSOP sõrmust ei anta.
Kas teadsite, kes võitis esimese WSOP Circuit'i? Posted Friday 15th September, 2023 at 17:36(UTC+3) by maheaaatom
WSOP Circuit algas 2005. aastal jaanuaris Atlantic Citys ning sarja esimese põhiturniiri võitis Kanada esindaja Nghi Tran, kes saigi seal oma karjääri suurima võidu.
Kokku on see mees teeninud live-pokkeriga ligi 1,93 miljonit dollarit. Hoopis tuntumad tegijad jäid tollal aga tema selja taha - kahekordne maailmameister ja kahe WPT põhiturniiri tšempion Erick Lindgren oli teine, Chad Brown seitsmes ning kuue WSOP käevõru omanik Chris Ferguson kaheksas. Ferguson krooniti muide juba järgmise WSOP Circuit põhiturniiri võitjaks.
WSOP Circuit esimesel hooajal viidigi läbi vaid viis turniiri. Neist viimasel, New Orleansis, osales ka Imre Leibold, kus saavutas mälestusväärse seitsmenda koha. Selle turniiri võitis Walter Chambers, hilisem maailma esinumber Antonio Esfaniari oli kolmas.
1C viimane mängutsükkel Posted Friday 15th September, 2023 at 17:16(UTC+3) by maheaaatom
Kolm viimast taset on veel mängida ning kuna keskmine stäkk on nüüd 50xBB, siis võime oodata pisut teravamat actionit.
Laudades 84 mängijat, alustajaid oli 113.
17:14 (UTC+3)
Start of Level 8 Blinds: 400/800 Ante: 800
Teine paus Posted Friday 15th September, 2023 at 16:53(UTC+3) by maheaaatom
Mängijad lubati teist korda puhkama. See on hea võimalus ka einestamiseks, sest OlyBet Bar and Grill pakub alates kell 16:00-st sooje toite. Eine maksab kõigest 10 eurot.
Mõned langejad ka: Janar Kokk, Alar Neemsalu, Hanno Kerem ja Arvo-Mart Elvisto. Lisandunud on aga netihai Aleksei Smirnov.
Sõna on Ermol Posted Friday 15th September, 2023 at 16:49(UTC+3) by maheaaatom
Äsja liitus turniiriga ka kuuekordne Eesti meister ning nii live- kui online-turniiridel erakordselt tugev harrastusmängija Ermo Kosk.
Ermo lööb aktiivselt kaasa ka hetkel OlyBetis toimuval megafestivalil WSOP Online 2023, kus saavutas eelmisel nädalal juba ühe kolmanda koha. Ega WSOP käevõru seega kuigi kaugele jäänud.
Aga Ermole võib WSOP Online'il terendada peagi veelgi suurem palgapäev. Nimelt jõudis ta MILLIONAIRE MAKER turniiril 100 parima hulka, kes asuvad võitjat selgitama luksuslikus Atlantis Resortis Bahamal. Mäng käib kolmele miljonile dollarile ning võitja saab täpselt miljoni. Mis aga peamine - Ermo alustab mängu suuruselt teise stäkiga.
"Positsioon peaks olema igati hea," lisab Ermo. "Lisaks on palju mängijaid, kes pääsesid Bahamale vaid mõne BB-ga." Ta pole ainuke eestlane, kes sinna sõidab, kindlasti on kambas ka Igor Pihela vanem.
WSOP Circuit'il on mehe fookus põhiturniiril, tänast turnat võtabki ta pigem soojendusena. Aga eks sõrmuse tahaks temagi sõrme saada.
Mängijaid aina lisandub Posted Friday 15th September, 2023 at 16:32(UTC+3) by maheaaatom
Oleme jõudnud juba 106 mängijani, meie omadest liitusid äsja Siim Suviste ning "betoonmees" Andrei Mjagkov.
Tähelepanuks neile, kes tahavad samuti mängida, kuid täna kohe kuidagi ei jõua - hiline regamine kestab kuni 12. taseme lõpuni, mis on kõigi eelduste kohaselt homme umbes kell 13:00-13:15. Siis tuleb muidugi arvestada üsna push-fold mänguga.
16:28 (UTC+3)
Start of Level 7 Blinds: 300/600 Ante: 600
Eestlaste laud Posted Friday 15th September, 2023 at 16:16(UTC+3) by maheaaatom
Mäng käib tosinal laual, kuhu ühele on sattunud hämmastaval kombel kõik eestlased. Tõsi - ühe väikese erandina. Jesus Martinez elab samuti Eestis, kuid tegemist on ikkagi Hispaania pokkeriprofiga.
Laua chipliider on äsja sinna suunatud Kaur Ajamaa.
Väike struktuurimuudatus Posted Friday 15th September, 2023 at 16:04(UTC+3) by maheaaatom
Sarnaselt päevadele 1A ja 1B on tänagi kaks pausi, kuid kui eile olid teised pausid pärast 8-ndat mängutaset, siis nüüd pärast seitsmendat. Tundub mõistlik otsus.
Päevad on aga endiselt sama pikkusega, väldates koos pausidega 5 tundi ja 50 minutit. See tähendab, et ülekanne lõppeb tänagi pisut enne kella ühte ning pikem paus tuleb 6-7 vahel.
Saabusid norralased Posted Friday 15th September, 2023 at 16:01(UTC+3) by maheaaatom
Norrakatel on ikka meeldinud Eestis mängida ning nii ei saa imestada, et mitmeid neist on meelitanud kohale võimalus WSOP Circuit meistrisõrmus saada. Esimesed kolm 1C-l osalevat trollidemaa poega on igatahes lauas!
Esimese eestlane on nüüd ka mängust väljas, tegemist Martin Piigiga. Aga küllap Martin tuleb tagasi.
15:52 (UTC+3)
Start of Level 6 Blinds: 200/500 Ante: 500
Pea täiesti meeste värk Posted Friday 15th September, 2023 at 15:52(UTC+3) by maheaaatom
Nüüdseks juba 101 1C-l osaleva mängija seas on vaid üks naine - soomlanne Anna-Mari Hursti. Tegemist on samas üsna tubli tegijaga, kes suutnud jõuda auhinnarahadesse nii tänavusel Kings of Tallinn kui Kings of Tallinn Summer Showdown põhiturniiril.
Eile proovis teatavasti kätt Jaana Kindsigo, võimalik et näeme teda ka uuel katsel.
WSOP Circuit naistepäev on järgmisel laupäeval, mil viiakse läbi 150 € Queens of Tallinn. Sellele saab kvalifitseeruda ka läbi samal päeval toimuva freezeout satika, millel osalemine on kõigile tasuta!
100 mängijat täis Posted Friday 15th September, 2023 at 15:46(UTC+3) by maheaaatom
Päeva 1C osalejate arv on jõudnud sajani ning väga lähedal oleme ka saja tuhandese auhinnafondi tähiseni.
"Ei tea palju õhtul (1D) mängima tuleb?" uurib Igor Pihela. Aga võib eeldada, et huvilisi saab siiski omajagu olema. Soome keelt on mängualal endiselt vähe kuulda, kuigi umbes kümmekond põhjanaabrit peaks juba laudades olema.
Taas Martin vs. Marten Posted Friday 15th September, 2023 at 15:37(UTC+3) by maheaaatom
Martin Venno ja Marten Oks omavahel madalaid panku ei mängi, kui juba - siis pannakse ikka täiega. Viimane jaotus oli üsna intrigeeriv.
Floppi vaadati 2200-ga.
Martin checkis ette, Marten pani 3000 ja sai calli.
Turni avati ning kordus sama, panused küll juba 5500 kummaltki.
River tegi asja juba eriti põnevaks. Lauas neli ristit, mida teha?
Martin checkis taas ning Marten ei leidnud pärast mõningast mõttepausi samuti jõudu panustamiseks. Kui Martin avas , rehmas Marten pahaselt käega. Tal nimelt
15:21 (UTC+3)
Start of Level 5 Blinds: 200/400 Ante: 400
Esimene paus Posted Friday 15th September, 2023 at 15:02(UTC+3) by maheaaatom
Mängijad lubati 20 minutiks puhkama ning kuna samal ajal siin midagi muud ei toimu, siis puhkame meiegi.
Auhinnafond läheneb sajale tuhandele Posted Friday 15th September, 2023 at 14:55(UTC+3) by maheaaatom
Turniiri auhinnafond on juba 96 000 eurot ning jätkub paisumist, 100 tuhande tähis saab küllap juba õige pea ületatud.
Eestlastest veel juures Maikel Homin, Martin Piik ja Marko Vest. Väljalangejaid (re-entry tegijaid) on hetkel viis ning kuni keskmine stäkk on veel üle 100XBB, siis enamasti mängitakse suhteliselt rahulikult.
Kaur on väga agressiivne Posted Friday 15th September, 2023 at 14:39(UTC+3) by maheaaatom
Neljadas lauas on selgelt kõige agressiivsem mängija Kaur Ajamaa. Kauri mängitud pangad on suured, on ta käinud ta all-in'is ning võitnud mõned õige kõrgete pottidega jaotused. Eks midagi on ära ka andnud, kuid mehe stäkk on umbes kaks korda suurem kui mängu alguses.
Player
Chips
Progress
Kaur Ajamaa
60,000
30,000
14:36 (UTC+3)
Start of Level 4 Blinds: 100/300 Ante: 300
Tervitame Tõusva Päikese Maa mängijaid! Posted Friday 15th September, 2023 at 14:36(UTC+3) by maheaaatom
Turniirile on saabunud ka väike jaapanlaste delegatsioon.
Kolmest mängijast tuntuim on Ken "King" Okada, kes võitnud live-turniiridelt üle 400 tuhande dollari, peamiselt Aasias toimunud turniiridelt. WSOP käevõru ega sõrmust tal aga veel ei ole.
Hirmkuulsaid pokkerimängijaid Jaapanis ei ole. Rahalist tipus on Tsugunari Toma 2,8 miljoni dollariga, pokkerimiljonäre on selles Eestist pea sada korda suuremas riigis 14.
Kohe paugutama Posted Friday 15th September, 2023 at 14:28(UTC+3) by maheaaatom
Turniirile saabunud Martin Venno alustab kohe esimest kätt 1000 tõstega (5XBB), kuid BB-l istuv Marten Oks re-raise'ib 3000-le.
Flop on . Martin ei kõhkle, vaid viskab kohe lauda 5000. Marten vastab suhteliselt kiire all-in'iga ning kuigi Martinil on rohkem, ta callima ei kipu.
Kiire mäng, suured panused, just seda me ootame!
Veel nimekaid Eesti mängijaid Posted Friday 15th September, 2023 at 14:16(UTC+3) by maheaaatom
Oleme jõudnud juba 75 sisseostuni ning mängijatega on lisandunud live-turniirdel alati ohtlik Dmitri Dudakov, EMV 2022 põhiturniiri teine Arvo-Mart Elvisto, kolmakordne Eesti meister Hanno Kerem ja pokkeriproff Oskar Ojaveer. Action käib üheksal laual.
Osalejate geograafia on lai Posted Friday 15th September, 2023 at 14:14(UTC+3) by maheaaatom
Lisaks eestlastele, lätlastele, leedulastele, soomlastele ning mõistagi ka HISPAANLASTE on turniiril väga erinevate riikide esindajaid. Näiteks Hong Kong, Gambia, Kreeka, Iisrael, USA, Kanada. On ka ukrainlasi.
14:02 (UTC+3)
Start of Level 3 Blinds: 100/200 Ante: 200
Veel suuri meistreid Posted Friday 15th September, 2023 at 14:02(UTC+3) by maheaaatom
Turniirile on saabunud ka Eesti rahalistis vastavalt 14. ja 17. kohta hoidvad Igor Pihela noorem ja Tarmo Tammel, kelle nimed tuttavad kõikidele Eesti pokkerimängijatele. Kuna mõlemad on väga aktiivsed mängijad, näeme neid küllap kogu festivali vältel sõrmuseid jahtimas.
Igor Pihela vanem jõudis muide teise päeva üsna viisaka 81K stäkiga, saame näha, kas poeg on seekord kõvem kui isa või mitte.
Hetkel turniiril juba 66 sisseostu. Kaks mängijat on juba pidanud ka re-entry tegema, kumbki pole eestlane.
Urmole sobivad nii käevõrud kui sõrmused Posted Friday 15th September, 2023 at 13:44(UTC+3) by maheaaatom
Lauas on ka esimene tõeline Eesti pokkerikuulsus Urmo Velvelt. Eeskätt on tegemist high-stakes online-mängijaga, kel ka üks WSOP finaallaud. 2020. aastal sai ta 5000 $ 6-max turniiril neljanda koha ning teenis üle 200 tuhande dollari.
Tuletagem aga meelde, et just Urmo oli parim eestlane juulis lõppenud Kings of Tallinn Summer Showdown põhiturniiril, kus ta saavutas kolmanda koha. Suurematest turniiridest on ta võitnud ka Unibet DeepStack Open ning 888poker Live põhiturniirid Tallinnas. Seega pole vähimatki kahtlust, et tegemist on ka väga tugeva live-mängijaga.
Uksed on valla Posted Friday 15th September, 2023 at 13:36(UTC+3) by maheaaatom
Tänane päev erineb ikka märkimisväärselt eilsest. Uksed on valla ning pea iga minut siseneb sealt uus pokkerimängija. Lisandunud on ka omajagu eestlasi nagu Tanel Evert, Janar Kokk, Danel Kunman, Alar Neemsalu, Marten Oks jt.
13:31 (UTC+3)
Start of Level 2 Blinds: 100/100 Ante: 100
Mis on täna kavas? Posted Friday 15th September, 2023 at 13:31(UTC+3) by maheaaatom
Täna mängime siis kaks 555 € turniiri avapäeva, 1C ja 1D (viimane algab kell 19:00). Levelid ikka 30 minutit, algstäkk 30 000 punkti ning piiramatu re-entry.
Täna kell 17:00 algab päeva ainus kõrvalturniir - 350 € PLO 4/5 Cards. Sel turniiril sõrmust ei saa!
Ka satelliite on kaks nagu eilegi, neil mõlemal on eriti magusad auhinnad:
- Kell 21:00 algab 150 € mega-satikas põhiturniirile, 10 kohta GTD!
- Kell 23:00 algab 60 € satikas homsele 1100 € NLH Ring Eventile, 5 kohta GTD
Tagasivaade eilsele päevale Posted Friday 15th September, 2023 at 13:25(UTC+3) by maheaaatom
Nagu eeldada võis, polnud festivali esimene päev just kuigi osalejaterohke, sest eestlastel on töönädal ning väliskülalised alles hakkavad Tallinnasse saabuma. 555 € Ring Event päevadel 1A ja 1B tehti ühtekokku 101 sisseostu ning umbes pooled (49 mängijat) suutsid avapäeva ka üle elada. Turniiri kindel liider on Eesti mees Raivo Pinsel.
Kõrvalturniire oli vaid üks - 150 € "hiinaka" esikoht läks Saksamaale, kuid pjedestaalile jõudis ka üks eestlane, endine Olympic Park Casino boss Jaan Vaabel sai kolmanda koha.
10 garanteeritud piletiga põhiturniiril satelliidil tekkis korralik 4200-eurone overlay (sisseost 150 €). Teiste seas sai pileti ka neljakordne Eesti meister Kristo Erala, kes oli ettenägelik ning tuligi overlay ootuses mängima.
Hilisõhtusel 66 € satelliidil hetkel käimasolevale turniirile overlayd ei tekkinud, välja jagati seitse piletit. Üks tuli ka Eestisse - selle sai Peeter Nooni.
Eestlased laudades Posted Friday 15th September, 2023 at 13:15(UTC+3) by maheaaatom
Kohe reporterite eest istub viimasel kahel EMV põhiturniiril finaallauda jõudnud Kaur Ajamaa, kes on tugev live-turnade mängija.
Lisaks temale hakkavad Eesti mängijatest silma ka Maksim Petrov ja Mario Jürgens Suhteliselt palju on leedukaid meie vana sõbra Vytautas Kacerauskesega eesotsas.
Tere tulemast päevale 1C Posted Friday 15th September, 2023 at 13:13(UTC+3) by maheaaatom
Oleme tagasi Olympic Casinos ning päev 555 € Ring Event päev 1C on alanud. Täna algas kõik õigeaegselt ning põhjus selles, et Tallinnasse hakkavad vaikselt jõudma välismaalaste hordid.
Hetkel juba 43 mängijat.
13:10 (UTC+3)
Day 1C of WSOPC Tallinn Started Level: 1 Blinds: 100/100 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.
-ga. 
. Aga lauda kenasti rida ja Mario saigi ühtäkki mäele.
-ga ning sai calli Igor Pihela 
vaadati 2200-ga. 
ning kordus sama, panused küll juba 5500 kummaltki.
tegi asja juba eriti põnevaks. Lauas neli ristit, mida teha?
£ GBP
$ USD
€ EUR
