0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0064 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-05-20'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event_Est/1A/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0003 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0061 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0004 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_KOT_1100_Main_Event_Est'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '97'
0.0207 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0042 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '242'
AND `published` = 1
0.0207 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0035 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '247'
AND `published` = 1
0.0203 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0034 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '249'
AND `published` = 1
0.0255 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '252'
AND `published` = 1
0.0208 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '257'
AND `published` = 1
0.0203 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0038 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '262'
AND `published` = 1
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '97'
AND `name` = '1A'
0.0048 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '242'
ORDER BY `busted` ASC, `current_chips` DESC
0.0036 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` = '242'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10742'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10730'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10728'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10725'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10709'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10703'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10701'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10696'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10692'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10689'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10679'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10677'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10668'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10661'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10659'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10654'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10649'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10644'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10639'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10633'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10632'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10621'
ORDER BY `chip_change` DESC, `busted` ASC
0.0149 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10612'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10611'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10603'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10557'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10553'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10543'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10538'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10537'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10535'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10534'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10529'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10527'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10523'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10521'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10514'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '242'
ORDER BY `busted` ASC, `current_chips` DESC
0.0040 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` = '242'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10742'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10730'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10728'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10725'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0102 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10709'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10703'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10701'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10696'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10692'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10689'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10679'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10677'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10668'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10661'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10659'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10654'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10649'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10644'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10639'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10633'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10632'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10621'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10612'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10611'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10603'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10557'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10553'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10543'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10538'
ORDER BY `chip_change` DESC, `busted` ASC
0.0150 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10537'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10535'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10534'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10529'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10527'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10523'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10521'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10514'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '262'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
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 Wednesday 28th February, 2024 at 22:07(UTC+2) by maheaaatom
Avapäeva 1A elas üle 87 mängijat, neist 16 eestlast. Päeva liidriks on Christian Rysgaard, parimad meie mängijad (Kaido Mikk ja Aleksei Smirnov) asuvad üldises pingereas vastavalt viiendal ja kuuendal kohal.
Päev 1B algab neljapäeval kell 12:00 ning liituda võivad nii uued mängijad kui need, kes täna välja langesid. Peatse kohtumiseni!
Player
Chips
Progress
Kaido Mikk
171,700
141,700
Aleksei Smirnov
170,000
140,000
Kris Tikka
141,600
111,600
Herli Olop
131,500
24,500
Aleksander Sebastian Lattikas
113,600
83,600
Maksim Petrov
110,400
80,400
Tarmo Tammel
104,000
24,000
Henri Käsper
101,600
71,600
Neeme Org
69,600
39,600
Silver Simulask
65,200
35,200
Siim Suviste
56,900
26,900
Artur Külanurk
36,900
6,900
Martin Zobel
34,500
4,500
Eedi Kirves
32,700
2,700
Ragnar Toompere
32,200
2,200
Rauno Tahvonen
24,800
5,200
Danielsson püüab auku-rea, Pihela kahjuks väljas Posted Wednesday 28th February, 2024 at 20:49(UTC+2) by maheaaatom
Päeva ühes viimases käes saab Igor Pihela üsna valusa kaotuse osaliseks.
Flopi järel panustab Malca Eli Danielsson 7500, Igor teeb vastu tavapärase min-tõste 15 000 ja saab calli.
Turni järel on nupud keskel, Igoril ning Danielssonil . Igoril vähemalt pool stäkki läinud ning päris päeva lõpus läks kahjuks ka see.
Ühtlasi on mäng tänaseks läbi, peagi avaldame kõikide allesjäänud eestlaste täpse punktiseisu.
Player
Chips
Progress
Kaido Mikk
171,700
141,700
Aleksei Smirnov
170,000
140,000
Kris Tikka
141,600
111,600
Herli Olop
131,500
24,500
Aleksander Sebastian Lattikas
113,600
83,600
Maksim Petrov
110,400
80,400
Tarmo Tammel
104,000
24,000
Henri Käsper
101,600
71,600
Neeme Org
69,600
39,600
Silver Simulask
65,200
35,200
Siim Suviste
56,900
26,900
Artur Külanurk
36,900
6,900
Martin Zobel
34,500
4,500
Eedi Kirves
32,700
2,700
Ragnar Toompere
32,200
2,200
Rauno Tahvonen
24,800
5,200
Igor Pihela vanem
0
0
Algab viimaste käte jagamine Posted Wednesday 28th February, 2024 at 20:38(UTC+2) by maheaaatom
Alustatakse viie viimase käe jagamist, seega on päev peagi läbi.
Neile, kes veel soovivad täna mängima tulla, infoks, et kell 21:30 algab 555 € NLH shorthand ning kell 23:00 150-eurone põhiturniiri satelliit.
Kaidol ja Maksimil 100K Posted Wednesday 28th February, 2024 at 20:28(UTC+2) by maheaaatom
Üsna korralike stäkkidega on turniiril veel Kaido Mikk ja Maksim Petrov, mõlemal on umbes 100K.
Kahjuks väljas Ralf Hamburg ja Margus Tuvikene.
Veel pool tundi lõpuni Posted Wednesday 28th February, 2024 at 20:20(UTC+2) by maheaaatom
Saalis on märksa vaiksemaks jäänud, sest laudades juba alla 100 mängija. Ja eks igaüks üritab nüüd maksimumi anda, et võimalikult hea stäkiga teise päeva jõuda.
Kahjuks on out Ranno Sootla, kuid kindlasti võtab see mees juba homme ette uue katse. Ka Hendrik Uibo ja Allan Arjut ei istu enam omal kohal.
Player
Chips
Progress
Tanel Merida
0
0
Hendrik Uibo
0
0
Championshipi võitis soomlane Posted Wednesday 28th February, 2024 at 20:12(UTC+2) by maheaaatom
Eestlastele väga hapult kulgenud 700 sisseostuga 555 € Championship sai ka läbi ning selle võitis Mikko Tapani Ylämäki. Kaks parimat tegid diili, seega sai Mikko 57 860 ning teiseks tulnud leedulane Andrius Bielskis 49 000 eurot.
Eestlaste parimaks jäi mäletatavasti Dmitri Zatsiki 35. (!) koht. See häbi tuleb nüüd põhiturniiril kindlasti maha pesta.
Mathias Siljander on tänagi lauas Posted Wednesday 28th February, 2024 at 19:58(UTC+2) by maheaaatom
Aastaid tagasi Tallinnas imetegusid teinud Mathias Siljander (muuhulgas ka 2019. aasta Summer Showdown põhiturniiri võitja) istub samas lauas Herli Olopiga, kuid on sel korral vähem agressiivne kui tavaliselt. "Varem ikka 3-betid pea iga käega ja iga kaardiga, täna on ta rahulikum," iseloomustab Herli.
Tõsi, Mathiasel pole täna kõrval ka tavapärast õllekannu. Ja stäkki ka mitte kuigivõrd, vast ainult nii 70K, mis on täiesti keskmine.
Herli ise on pidevalt actionis olnud, alles sai ta ühe shordi kätte -ga vs. , siis andis jälle teisele ära (blindide sõda vs. ), mõlemal korral kõrgem pocket pidas. Ja korra bluffis ta 6-kõrgega ka Siljanderi enda välja.
Herlil igati tubli 135K stäkk ehk kahekordne keskmine.
19:48 (UTC+2)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
Tammelile duubel, Pihela võtab ka juurde Posted Wednesday 28th February, 2024 at 19:48(UTC+2) by maheaaatom
Tammeli-Pihela lauast kaks head uudist.
1. Flopi järel on Tammel sees pocket kuningatega mastitõmbe vastu. Kunnid peavad.
2. Kohe selle järel mängivad action-panga Mindaugas Kriauciunas ja Igor Pihela vanem.
Kolmpanustatud flopi järel avab leedulane 6200-ga, Igor teeb min-tõste 12400. Leedulaselt call.
Turni järel checkib vastane ette ja Igor panustab 7500. Calli ei tule.
Tarmol umbes 80K, Igoril 150K.
Player
Chips
Progress
Igor Pihela vanem
150,000
20,000
Tarmo Tammel
80,000
50,000
Kairit mängust väljas Posted Wednesday 28th February, 2024 at 19:36(UTC+2) by maheaaatom
Kairit on natuke pahane, sest suur osa tema stäkist oli läinud ühele vastasele, kes tema - enda sõnul ülitight mängija imagoga - blufi - boardiga pocket neljadega ära callis.
Päris viimaseks käeks jäi vs. ning lauast abi ei tulnud.
Player
Chips
Progress
Kairit Leibold
0
0
Herli püüab veel ühe blufi Posted Wednesday 28th February, 2024 at 19:23(UTC+2) by maheaaatom
Herli () avab UTG-lt ning saab kaasa BB-l istuva hispaanlase.
Flopis on , Herli teeb väikese panuse ja saab calli.
Turni järel panustab juba vastane terve panga ulatuses ning Herli callib.
River on , hispaanlane paneb nüüd juba 17K ning Herli mõtleb pikalt. Viimaks tuleb call, vastas on puhas bluff (). Herlil nüüd 107K.
Player
Chips
Progress
Herli Olop
107,000
32,000
Georgi kaotab hiigelpanga Posted Wednesday 28th February, 2024 at 19:18(UTC+2) by maheaaatom
Georgi Abuladze ja Maximilian Johnnie Sanders kütavad juba enne floppi sisse 14K.
Avatakse . Inglane avab 6K panusega ja saab calli.
Turn on , Sanders paneb nüüd juba 25K ning Georgi mõtleb pikalt, kuniks teatab, et on all-in (ca. 75K) Sanders callib koheselt.
Georgi:
Sanders:
River ei muuda midagi, punktid loetakse kokku ning Georgile jääb 1,5xBB järgi. Pank oli ligi 200K, seega väga valus kaotus.
Mängu jätkab 130 pokkerisportlast Posted Wednesday 28th February, 2024 at 18:59(UTC+2) by maheaaatom
130 mängijat on laudades tagasi. Eestlastest on üks suuremaid stäkke Joosep Toolil (125 000), kelle oleme siiani kahetsusväärselt tähelepanuta jätnud.
Kohe on algamas 150-eurone turboturniir.
18:56 (UTC+2)
Start of Level 7 Blinds: 400/800 Ante: 800
Viimane paus Posted Wednesday 28th February, 2024 at 18:39(UTC+2) by maheaaatom
Mängijad läksid viimasele pausile. Hea uudis on see, et Herli callis meisterlikult ära ühe vastase bluffi ja Allan jäi ise bluffides vahele. Aga mõlemad on kenasti mängus, Herli koguni 85K stäkiga.
Player
Chips
Progress
Herli Olop
75,000
45,000
Kris saab neliku Posted Wednesday 28th February, 2024 at 18:28(UTC+2) by maheaaatom
Eesti värve kaitsev Kris Tikka on tõusnud juba 120K peale, saades äsja duubli Soome highrollerilt Roope Tarmilt.
PFAI jaotuses oli Krisil , Roopel seevastu.
Laud andis veel kaks kuningat - võimas käsi!
Allan duubeldab Posted Wednesday 28th February, 2024 at 18:24(UTC+2) by maheaaatom
Allanil õnnestub oma 25K stäkk duublisse saada.
Nupud läksid sisse pärast floppi ja turni . Õigemine oli Allanil selleks hetkeks juba nii palju raha keskel, et foldida polnud enam kuidagi võimalik.
Tema õnneks ilmnes, et ka vastane panustas õhuga ().
-ga mänginud Allani õnneks tõi river open-enderi kohale.
Lätlane kukutab Erki Posted Wednesday 28th February, 2024 at 18:17(UTC+2) by maheaaatom
Riveriks oli lauas ning niigi suure stäkiga Läti pokkerimängija Yaniv Peretz lükkas oma nupud meie Erki Andressoo vastu keskele.
Erki mõtles mitu minutit, otsustades viimaks oma allesjäänud 16 000 punktiga ikkagi calli. Ei olnud õige otsus:
Yaniv:
Erki:
See oli Erkile juba teine bullet ning hetkeseisuga ta turniirile naasnud ei ole.
Murdepunkt? Posted Wednesday 28th February, 2024 at 18:07(UTC+2) by maheaaatom
Oleme jõudnud päevaga 1A faasi, mil aktiivsete mängijate arv hakkab pigem vähenema. Uusi liitujaid enam väga peale ei tule ja väljalangejatel on küll võimalik end 60XBB tagasi osta, kuid paljud eelistavad ikkagi algusest alustada. Selleks on veel kaks võimalust - homme kell 12:00 algav 1B ja 21:00 turbo-versioonis mängitav 1C.
Lauas ka Henri Käsper Posted Wednesday 28th February, 2024 at 17:56(UTC+2) by maheaaatom
Eesti pokkerilegend ning live-turniiridel üle miljoni euro teeninud Henri Käsper on samuti kohal ning istub samas lauas Tarmo Tammeli ning Herli Olopiga.
Henril oli iseäranis edukas 2023. aasta ning tõenäoliselt valitakse aasta live-mängijaks just kas tema või Tarmo Tammel. Loodame, et mehed annavad teineteisele väärika lahingu ka Kings of Tallinn 2024 põhiturniiril.
Ülimenukas 250 € Bounty Posted Wednesday 28th February, 2024 at 17:49(UTC+2) by maheaaatom
250-eurosel bounty-turniiril on juba tehtud 265 sisseostu ning re-entry periood pole veel kaugeltki lõppenud.
Kuna tegemist on tänase odavaima (mitte-turbo) turniiriga, on kohal ka hulk hobimängijaid.
Lauas ka tõeline küürvaal Posted Wednesday 28th February, 2024 at 17:40(UTC+2) by maheaaatom
Multimiljonärist ettevõtja ning pokkerisõber Paul Newey on samuti kohal. Tegemist mehega, kes muuhulgas cashinud ka kuulsal WSOP miljonidollarilise sisseostuga turniiril. Et sellised mehed Tallinnas mängivad, annab tunnistust sellele, et oleme Euroopas ikka väga kõrgelthinnatud sihtkoht!
Igor on veelgi juurde saanud Posted Wednesday 28th February, 2024 at 17:35(UTC+2) by maheaaatom
Igor Pihela stäkk on juba 130K, mis on eestlastest suurim. Hendrik Uibo on ka pisut juurde saanud ning hetkel 80K peal. Georgil on umbes 60K.
Suurem osa eestlastest istub aga endiselt algstäkil. Muidugi mäng on veel noor, ainuüksi esimest päeva on veel jäänud 3 taset.
Player
Chips
Progress
Igor Pihela vanem
130,000
40,000
Hendrik Uibo
80,000
50,000
Georgi Abuladze
60,000
30,000
17:32 (UTC+2)
Start of Level 6 Blinds: 300/600 Ante: 600
Võõrad suled Posted Wednesday 28th February, 2024 at 17:32(UTC+2) by maheaaatom
Aleksei Smirnov on üks kuuest Eesti mängijast, kel sõrmes ka WSOP Circuit meistrisõrmus. Ja seda kannab Aleksei uhkusega.
Paraku ilmneb, et sõrmusekandjaid on teisigi, üks neist istub koguni tema vastas ning sel mehel on sõrmes kaks WSOP Circuit kuldsõrmust. Ja temagi ei häbene neid näitada. Mis aga kõige veidram, Hendoni andmetel pole see mees ühtegi sõrmust tegelikult võitnud.
"Ebay's, igal pool ju müüakse kõike," naerab Aleksei ise.
Profid omavahel Posted Wednesday 28th February, 2024 at 17:28(UTC+2) by maheaaatom
Kolmandas lauas võitlevad Eesti pokkeriproff Urmo Velvelt (CO) ning Eestis elab Hispaania pokkeripro I Roura Adria Comas (BB). Enne floppi läheb panka juba 8000 punkti.
Flopis avatakse , Urmo panustab 4K ette ja saab calli.
Turn on , Urmo proovib nüüd 10K-ga, kuid hispaanlane callib järjekindlalt.
Riverisse avatakse , nüüd Urmo checkib ja vastane läheb all-in. Urmo foldib, jättes umbes 25K alles.
Algas tänane esimene põhiturniiri megasatelliit Posted Wednesday 28th February, 2024 at 17:15(UTC+2) by maheaaatom
Fuajees läks käima põhiturniiri megasatelliit, mille sisseost on 80 eurot. Garanteeritud on vähemalt 5 x 1100 € piletit. Turniiri alustas 49 mängijat ning mõistagi tuleb neid juurde. Overlayd oodata pigem ei tasu, küll on tegemist aga soodsaima allesjäänud võimalusega pileti hankimiseks.
Omaha-turniiri esikoht läks Saksamaale Posted Wednesday 28th February, 2024 at 17:10(UTC+2) by maheaaatom
1100 € PLO leidis just oma lõpplahenduse, võitjaks tuli sakslane Per-Thorben Kasten, kes teenis 21 150 €. Heads-up'is sõlmiti diil ning nii sai finaalivastane Jacob Plickert Reinholdt Taanist isegi 100 eurot rohkem. Kolmandaks tuli eestlastele juba märksa rohkem tuttav lätlane Davis Modans.
Mängiti 101 520 eurole ning sisseoste tehti 108. Nagu varem juba mainitud, ei õnnestunud ühelgi eestlasel auhinnarahadesse jõuda.
5. päeva videokokkuvõte Posted Wednesday 28th February, 2024 at 17:01(UTC+2) by maheaaatom
200 sisseostu täis Posted Wednesday 28th February, 2024 at 16:56(UTC+2) by maheaaatom
Teise täissaja plaan on täidetud, kohalikest staaridest on viimasena liitunud Allan Arjut.
Pudeneb ka. Stanislav Smeljovi stäkk sulas nagu tänavune lumi ning mees on mängust väljas. Ka Tarmo Tammel pidi korra kassas käima.
Aleksandr kaitseb edukalt blindi Posted Wednesday 28th February, 2024 at 16:52(UTC+2) by maheaaatom
Ranno Sootla ründab CO-lt blinde 1100-ga ning saab calli BB-ll istuvalt Aleksandr Kupermanil.
Flop on , Aleksandr checkib, Ranno panustab 2000 ja saab calli.
Turni järel kordub sama.
River järel checkib Aleksandr taas ette ja Ranno koputab samuti lauale.
Aleksandr avab ning korjab panga maha.
Kuidas mängida pokkerit ilma käteta? Posted Wednesday 28th February, 2024 at 16:43(UTC+2) by maheaaatom
Erivajadustega inimesi on suurtel turniiridel ennegi nähtud - kohe meenub näiteks pime pokkerimängija Steven Iglesias - ning me näeme ka Kings of Tallinnal.
Tugiisikut pole vaja. Mängija istub lihtsalt diileri vasakul käel, kes näitab talle kaardid ette ning mängija ütleb seejärel oma otsuse. Žetoone liigutab seejärel juba diiler.
Meeldiv, et ka erivajadustega inimesed saavad pokkerit mängides lõbusalt aega veeta ning et nendega arvestatakse. Muide - seesama mees kasutab aktiivselt ka varvastega täiesti tavaliselt nutitelefoni. Proovige, kas saate samaga hakkama :)
16:38 (UTC+2)
Start of Level 5 Blinds: 200/500 Ante: 500
Puhkama Posted Wednesday 28th February, 2024 at 16:20(UTC+2) by maheaaatom
Mängijad lubatakse puhkama, pool tänasest päevast on mängitud.
Hendrik Uibo palub öelda, et tema stäkk on umbes 60K. "Alles oli ka 80K. Aga mul oli flush-draw, mis ei tulnud kokku. Vastane callis ässadega ära."
Pausi ajal saab osaleda nii flipamentidel kui ka minna sööma. Täna pakub Olybet Bar & Grill näiteks kanavardaid riisiga.
Läheneme 200 sisseostule Posted Wednesday 28th February, 2024 at 16:13(UTC+2) by maheaaatom
Hetkel on tehtud 193 sisseostu ning aega mänguga liitumiseks on veel küllaga. Tuntud tegijatest on lauda istunud veel Tõnis Viik, Kaido Mikk ja Rauno Tahvonen.
Georgi ja Ralf katsuvad pilkudega jõudu Posted Wednesday 28th February, 2024 at 15:56(UTC+2) by maheaaatom
Ralf Hamburg ja Georgi Abuladze peavad maha korraliku psühholoogilise lahingu. Paugutamine käib enne floppi ning ületõsteid on tehtud korduvalt, lõpuks lükkab Ralf 8000 ning Georgi vastab sellele 19K panusega.
"Palju sul on?" uurib Ralf ning Georgi vastab, et 47K. Seejärel jõllitavad veel mõlemad teineteist, Georgi varjab seejuures veel eriti hoolikalt oma pead ja nägu, Ralf seevastu on väga vaba hoiakuga. Lõpuks ta siiski foldib ja Georgi korjab nupud kokku.
Herli haukab tükikese Stanislavi stäkist Posted Wednesday 28th February, 2024 at 15:45(UTC+2) by maheaaatom
Herli Olop on lauas tagasi ning peab just maha väikese heitluse Stanislav Smeljoviga.
Riveriks on pangas 10 100 punkti ning lauas ning Stanislav avab 5100-ga. Herli vastab 15K ületõstega ning Stanislav foldib.
Herlil umbes keskmine stäkk, Stanislavil oluliselt alla selle.
Six-six-six Posted Wednesday 28th February, 2024 at 15:39(UTC+2) by maheaaatom
Eedi Kirves tõstab buttonilt 800, Roman Jezov callib ning Maikel Homin lükkab BB-lt 3300 juurde. Kõik callivad.
Lauas avatakse saatanlik flop
Roman checkib, Maikel paneb 3500 ning saab calli vaid Eedilt.
Turni avatakse ning seekord ründab Maikel veelgi tõsisemalt 6500-ga. Sellele Eedi enam vastama ei hakka.
15:28 (UTC+2)
Start of Level 4 Blinds: 200/400 Ante: 400
Eestlaste laud Posted Wednesday 28th February, 2024 at 15:28(UTC+2) by maheaaatom
Neljandasse lauda on sattunud koguni neli Eesti mängijat - Maikel Homin, Rene Krause, Eedi Kirves ja Roman Jezov. Viimane neist oli meie parim eilsel 250 € NLH turniiril, saavutades seal kuuenda koha. Neile on pakkumas konkurentsi muuhulgas nimekas Soome pokkeriproff ning tõeline kivinägu Roope Tarmi, kes võitis muuhulgas mulluse WSOP Circuit Tallinn highroller turniiri.
Laua selgelt aktiivseim mängija on Maikel, kuid erilist edu ta veel saavutanud pole, sest mehel on natuke alla algstäki.
Igor ruulib Posted Wednesday 28th February, 2024 at 15:09(UTC+2) by maheaaatom
Kiire ülevaade näitab, et ühelgi eestlasel peale Igor Pihela vanema keskmisest märksa suuremat stäkki veel ei ole.
Igoril on kuskil 90K ning see on tulnud kõik esimese bulletiga. Tarvo Mäesepp ja Andres Reisenbuk on aga paraku mängust väljas ning pole näha, et nad oleksid turniiriga taasliitunud.
Player
Chips
Progress
Igor Pihela vanem
90,000
60,000
Algab tänane esimene kõrvalturniir Posted Wednesday 28th February, 2024 at 15:00(UTC+2) by maheaaatom
Kohe on algamas tänane esimene kõrvalturniir, 250 € sisseostuga NLH Progressive Bounty. Hetkel on kirjas juba 57 võistlejat ning võib eeldada, et see turniir kujuneb võrdlemisi rahvarohkeks.
800-900K auhinnafond on reaalne Posted Wednesday 28th February, 2024 at 14:58(UTC+2) by maheaaatom
Mängijad usuvad, et tänavusel põhiturniiril lüüakse kindlasti eelmiste aastate rekord üle ning auhinnafond võib ulatuda isegi 800-900 tuhande euroni. Miljonit veel esialgu ei usuta.
Tuletame meelde, et mullune auhinnafond oli 673 050 eurot ning sisseoste kogunes 716. Mis veelgi tähtsam - turniiri esikoht jäeti Eestisse ning selle ei saanud juhuslik mängijad, vaid hinnatud pokkeriproff, eelkõige cashgame-eksperina tuntud Priit Parmasto.
164 sisseostu Posted Wednesday 28th February, 2024 at 14:48(UTC+2) by maheaaatom
Mängijaid aina lisandub, lauas on juba Maikel Homin, Mart Rinken ja Ranno Sootla.
Herli Olopi esimene katse läks aia taha, ka Lauri Raag ja Ivar Rühka peavad kasutama järgmist õlekõrt.
Tiimide võistlusel eestlased endiselt kolmandad Posted Wednesday 28th February, 2024 at 14:32(UTC+2) by maheaaatom
Tiimide arvestuses on hetkeseisuga liidrid "KIIRED JA VIHASED", kuid sellest nimest ei tasu veel euroofiasse sattuda, sest tegemist on soomlastega.
Parim Eesti tiim "TIME" (Tammel, Arjut, Uibo ja Morel) on kolmandad. Neist ainsana on hetkel võistlustules Hendrik Uibo.
Kohal on ETV Posted Wednesday 28th February, 2024 at 14:26(UTC+2) by maheaaatom
Turniirile on saabunud ETV kaamerad ning Aet Süvari isiklikult. Väga tore, et pokker saab taaskord meedias head tähelepanu ning nagu me teame, sisaldub peagi ilmuvas loos ka intervjuu ühe tuntud Eesti superässaga.
Põhiturniir jätkub ning ka 555 € Championship on jõudnud viimaks finaallauani, mis mängitakse telekaamerate all.
14:23 (UTC+2)
Start of Level 3 Blinds: 100/300 Ante: 300
Esimene paus Posted Wednesday 28th February, 2024 at 14:04(UTC+2) by maheaaatom
Põhiturniiril osalejad lubati esimest korda puhkama. Esimese kahe taseme jooksul tehti 143 sisseostu ning hetkel on laudades 134 mängijat. Et midagi väga märgilist veel juhtunud pole, tuleneb eelkõige sellest, et keskmine stäkk on 150xBB ning niisama tõmblemiseks puudub igasugune vajadus.
Tuletame meelde, et me mängime täna kaheksa taset, igaüks vältab täpselt tunni . Pausid toimuvad iga kahe tunni järel ning kokku on neid kavas kolm.
Championshipil veeretatakse nuppe Posted Wednesday 28th February, 2024 at 13:52(UTC+2) by maheaaatom
Kui suures saalis toimub PLO edeneb kiirelt (päeva alustas 14 parimat, nüüd on neist pooled juba välja langenud), siis Championship'il käib paras passimine - alustas 13 mängijat, nad on juba umbes tunni mänginud ning välja pole kukkunud keegi.
Suuremat tähelepanu ma kummalegi turniirile selles blogis pöörama ei hakka, sest eestlasi mängus pole.
Tanelil korralik algus Posted Wednesday 28th February, 2024 at 13:50(UTC+2) by maheaaatom
Tanel Merida on suutnud oma stäki juba enam kui kahekordistada ja istub hetkel 64K peal.
"Õnnestus alguses kaks suuremat panka võita," on Tanel enda algusega rahul.
Kairit lauas on nüüd ka rohkem rahvast, ka äsjased SPA-mehed on puhanud ja värskete nägudega seal istet võtnud.
Player
Chips
Progress
Tanel Merida
64,000
34,000
Veel uusi tulijaid Posted Wednesday 28th February, 2024 at 13:40(UTC+2) by maheaaatom
Oleme jõudnud 128 sisseostuni, viis mängijat on pidanud ka re-entry tegema.
Meie ässadest on lisandunud Mark Metsla ja Igor Pihela vanem. Viimane on avapäevadel tuntud väga lahtise ja agressiivse mängu poolest. Eks põhjus ikka selles, et Igorit huvitavad ainult tipmised kohad ning oma stäki kindlustamiseks tuleb alguses ka riske võtta.
Põrgusse see pokker, SPA on lahedam Posted Wednesday 28th February, 2024 at 13:38(UTC+2) by maheaaatom
Kairiti-lauas on endiselt vaid neli "elus" mängijat, kaks stäkki tiksuvad tühja. Põhjus olevat selles, et nende omanikud panid oma stäkid küll jooksma, kuid pokkerit mängida ei viitsi. SPA-s olevat lahedam.
Teistele lauakaaslastele see olukord muidugi meeldib. Tasuta raha on laual, loomulikult võetakse see hea meelega vastu.
13:09 (UTC+2)
Start of Level 2 Blinds: 100/200 Ante: 200
100 mängija piir ületatud Posted Wednesday 28th February, 2024 at 13:08(UTC+2) by maheaaatom
Mängijaid tuleb iga minutiga juurde ning saja mängija piir sai sellega ületatud. Teiste seas on lisandunud näiteks Herli Olop ja Stanislav Smeljov.
Magnus haarab re-entry järele Posted Wednesday 28th February, 2024 at 13:05(UTC+2) by maheaaatom
2022. aasta EMV põhiturniiri võitja Magnus Puki esimene bullet läks "piima järele" ning mees on pidanud võtma ette teise katse. "Midagi hullu pole, võitsin selle pileti nagunii online-satelliidilt," tõdeb mees ise.
Suur action olla toimunud enne floppi - UTG avas, CO kolmpanustas, Magnus tegi buttonilt nelipanuse ja UTG vastas veel 5-betiga. Magnuselt call.
Flopis avati ning pank suurenes kahe panuste arvelt veel umbes 40% võrra.
Turn checkiti läbi, riveri järel läks vastane all-in ning Magnus callis -ga. Vastas paraku .
Tänased turniirid Posted Wednesday 28th February, 2024 at 12:44(UTC+2) by maheaaatom
Lisaks põhiturniirile ja kahele täna lõppevale kahepäevasele turniirile viiakse täna läbi veel kolm turniiri:
- Kell 15:00 250 € NLH Progressive Bounty
- Kell 19:00 150 € NLH Turbo
- Kell 21:30 555 € NLH Shorthand
Lisaks ka pauside ajal toimuvad 150-eurosed flipid ning kaks põhiturniiri satelliiti, mis algavad vastavalt kell 17:00 ja 23:00. Neist esimesel osalemine maksab 80 eurot (5 piletit GTD) ja teisel 150 eurot (10 piletit GTD).
Teisipäevane kiire kokkuvõte Posted Wednesday 28th February, 2024 at 12:38(UTC+2) by maheaaatom
Eestlastest kuulub eilse suurima kangelase au kindlasti kossuässale Merike Andersonile, kes saavutas 500 sisseostuga (!) kuulsuste eriturniiril kõrge viienda koha ning teenis 3320 eurot. "Kuulsustest" jõudsid rahadesse ka Ott Kiivikas ja Silver Laas, parima Eesti mängijana oli Viktor Blinov kolmas. Võitis Küprose pokkerimängija Sinnos Eleftherio.
555 € Championshipi teine päev läks eestlastel totaalselt aia taha, parimana saavutas Dmitri Zatsik 35. koha. Kohe hakatakse ka selgitama turniiri võitjat ning finaal mängitakse telelauas. Päris finaalini läheb veel aega, hetkel on alles 13 parimat.
Kahepäevasel 1100 € PLO 4/5 Championshipil tehti 108 sisseostu ning kohe on algamas ka finaalpäev. Eestlasi kahjuks mängus enam ei ole.
165 sisseostuga 250 € NLH 8-handed lõppes soomlase Jarmo Saloneni võiduga. Ning mõistagi tekitas omajagu melu ka Olympic Casinos toimunud vastuvõtt naismängijatele koos tasuta turniiriga, mille viis parimat teenisid pileti laupäevasele naisteturniirile.
Urmo on lauas tavapärasest varem Posted Wednesday 28th February, 2024 at 12:26(UTC+2) by maheaaatom
Maailmaklassi superässadest on juba lauas Urmo Velvelt, kes tunnistab isegi, et see on tema jaoks üsna ebatavaliselt vara.
Aga kohal on ka Magnus Pukk, Tanel Merida, Hendrik Uibo, Silver Simulask jt.
"Aga mulle meeldibki shorthand!" Posted Wednesday 28th February, 2024 at 12:23(UTC+2) by maheaaatom
Kui enamikes laudades on viis-kuus mängijat, siis selles, kuhu sattus Kairit Leibold (ning peagi ka Aleksandr Kuperman) on mängijaid vaid kolm.
"Aga mulle meeldibki shorthand," ei lase Kairit tujul langeda. Naerab ka diiler.
Mäng on alanud Posted Wednesday 28th February, 2024 at 12:17(UTC+2) by maheaaatom
Esimesed 68 julget on laudades istet võtnud, umbes kümmekond eestlast nende seas. Täna mängitakse 8x60 minutit ehk umbes kella üheksani.
12:16 (UTC+2)
Day 1A of Kings of Tallinn 2024 Started Level: 1 Blinds: 100/100 Ante: 100
Põhiturniir algab kell 12:00 Posted Wednesday 28th February, 2024 at 11:33(UTC+2) by maheaaatom
Head pokkerisõbrad! Täna algab Kings of Tallinn 2024 põhiturniir. Avapäev mängitakse kolmes voorus ning kolmapäeval on kavas neist esimene - 1A.
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.
järel panustab Malca Eli Danielsson 7500, Igor teeb vastu tavapärase min-tõste 15 000 ja saab calli.
järel on nupud keskel, Igoril 
ning Danielssonil 
. Igoril vähemalt pool stäkki läinud ning päris päeva lõpus läks kahjuks ka see.
), mõlemal korral kõrgem pocket pidas. Ja korra bluffis ta 6-kõrgega ka Siljanderi enda välja.
järel on Tammel sees pocket kuningatega 
mastitõmbe vastu. Kunnid peavad. 
järel avab leedulane 6200-ga, Igor teeb min-tõste 12400. Leedulaselt call.
- boardiga pocket neljadega ära callis.
) avab UTG-lt ning saab kaasa BB-l istuva hispaanlase. 
järel panustab juba vastane terve panga ulatuses ning Herli callib.
, hispaanlane paneb nüüd juba 17K ning Herli mõtleb pikalt. Viimaks tuleb call, vastas on puhas bluff (
). Herlil nüüd 107K.
. Inglane avab 6K panusega ja saab calli.
. Õigemine oli Allanil selleks hetkeks juba nii palju raha keskel, et foldida polnud enam kuidagi võimalik.
open-enderi kohale. 
ning niigi suure stäkiga Läti pokkerimängija Yaniv Peretz lükkas oma nupud meie Erki Andressoo vastu keskele.
, Urmo panustab 4K ette ja saab calli.
, Urmo proovib nüüd 10K-ga, kuid hispaanlane callib järjekindlalt. 
järel checkib Aleksandr taas ette ja Ranno koputab samuti lauale. 
ning Stanislav avab 5100-ga. Herli vastab 15K ületõstega ning Stanislav foldib.
ning seekord ründab Maikel veelgi tõsisemalt 6500-ga. Sellele Eedi enam vastama ei hakka.
.
£ GBP
$ USD
€ EUR
