0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0062 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event_Est/1B/updates'
ORDER BY `views` DESC
0.0086 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event_Est/1B/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.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.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.0065 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.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '97'
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '242'
AND `published` = 1
0.0251 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` = '247'
AND `published` = 1
0.0277 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '249'
AND `published` = 1
0.0259 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '252'
AND `published` = 1
0.0253 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '257'
AND `published` = 1
0.0252 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '262'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '97'
AND `name` = '1B'
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '247'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '247'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10891'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10885'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10884'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10875'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10870'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10867'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10865'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10861'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10860'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10859'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10854'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10853'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10849'
ORDER BY `chip_change` DESC, `busted` ASC
0.0092 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10848'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10846'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10843'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10840'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10835'
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` = '10832'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10831'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10829'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10826'
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` = '10823'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10822'
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` = '10818'
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` = '10814'
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` = '10812'
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` = '10809'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10808'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10807'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10800'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10799'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10796'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10793'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10792'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10789'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10787'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10784'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10783'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10777'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10776'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10774'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10771'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10768'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10767'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10763'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10762'
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` = '10760'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10758'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10757'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10755'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10754'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '247'
ORDER BY `busted` ASC, `current_chips` DESC
0.0047 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` = '247'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10891'
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` = '10886'
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` = '10885'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10884'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10875'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10870'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10867'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10866'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10865'
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` = '10861'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10860'
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` = '10859'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10854'
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` = '10853'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10849'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10848'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10846'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10843'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10840'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10835'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10832'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10831'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10829'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10826'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10823'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10822'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10818'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10814'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10812'
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` = '10809'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10808'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10807'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10800'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10799'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10796'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10793'
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` = '10792'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10789'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10787'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10784'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10783'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10777'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10776'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10774'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10771'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10768'
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` = '10767'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10763'
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` = '10762'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10760'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10758'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10757'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10755'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10754'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '262'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 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.
Teise päeva pääses 35 eestlast Posted Thursday 29th February, 2024 at 21:16(UTC+2) by maheaaatom
1B lõppedes jäi mängu 167 pokkerisportlast, nende seas 35 eestlast. Meie mängijatest on suurima stäkiga Ranel Käsi.
Sellega loeme 1B ülekande lõppenuks ning alustame 1C-ga.
Player
Chips
Progress
Ranel Käsi
180,500
59,500
Mairo Tori
137,600
17,400
Sten Talviste
131,900
58,100
Markku Koplimaa
126,500
76,500
Kaur-Silver Koha
115,300
19,300
Mauri Dorbek
112,100
7,900
Andrey Koks
106,400
76,400
Mihkel Vitsur
104,000
23,500
Paul Koppe
99,500
2,500
Lauri Laast
85,800
55,800
Marius Morel
78,600
48,600
Igor Pihela vanem
74,500
29,500
Priit Vanem
70,000
40,000
Georgi Abuladze
68,900
38,900
Mark Metsla
64,600
400
Marko Olop
61,600
8,900
Richard Koppel
61,000
31,000
Kaius Kiidli
56,200
26,200
Marko Vest
55,100
25,100
Ivo Rohula
54,100
24,100
Oskar Ojaveer
51,500
21,500
Aleksandr Kuperman
42,600
12,600
Hanna Heinlo
41,300
11,300
Laur Sibold
41,100
21,900
Jaanus Veste
38,900
8,900
Ermo Kosk
34,900
52,100
Allan Arjut
34,200
4,200
Jako Kuusik
26,700
3,300
Stanislav Smeljov
25,500
4,500
Andres Allsalu
24,800
5,200
Risto Pärnat
23,400
6,600
Meelis Suurorg
20,500
9,500
Madis Ormisson
11,500
18,500
Igor paugutab kaheksatega Posted Thursday 29th February, 2024 at 20:43(UTC+2) by maheaaatom
Igor Pihela ei karda ka nüüd pocket kaheksatega keskele minna, kuigi mänguruumi on tal omajagu. Calle paraku ei järgne ning vanameister saab kenasti õhtule.
Ühtlasi on mäng enamikes laudades ka läbi ning me naaseme 20 minuti pärast, et alustada päevaga 1C ning võtta avaldada 1B üleelanud eestlaste lõplikud stäkid.
Markkule suur pank Posted Thursday 29th February, 2024 at 20:41(UTC+2) by maheaaatom
Markku Koplimaal õnnestub saada päeva lõpus kätte suur pank.
Lauas on ning potis tubli 30K. Markku viimane panus 13K callitakse ära ning meie tšempion esitleb pocket ässasid.
Alustatakse viimaste käte jagamist Posted Thursday 29th February, 2024 at 20:38(UTC+2) by maheaaatom
Kell pannakse kinni ning mängijatele jagatakse veel kolm viimast kätt.
Stenil monsterstack Posted Thursday 29th February, 2024 at 20:23(UTC+2) by maheaaatom
Kui papa Talviste maadleb keskmise stäkiga, siis pojal on umbes 190K punkti, mis on kolmekordne keskmine. Samas lauas on ka Mark Metsla umbes 65K-ga.
Player
Chips
Progress
Sten Talviste
190,000
141,000
Mark Metsla
65,000
35,000
Suuri muutusi ei ole Posted Thursday 29th February, 2024 at 20:11(UTC+2) by maheaaatom
Mauri Dorbek on vaikselt juurde korjanud ning hetkel umbes 120K peal. Andrey Koksil on samuti üsna hästi (100K).
Vaikselt on nuppe loovutanud Laur Sibold, kel on järel umbes 35K. Sama palju punkte on ka Georgi Abuladzel, kes on pidanud ka selle nimel suurt tööd tegema, sest mitte kaua aega tagasi oli tal vaid 7K.
Priit Parmasto stäkk on natuke üle keskmise (umbes 70K), Allan Arjutil on 45K ning Peeter Talvistel endiselt 50K.
Player
Chips
Progress
Mauri Dorbek
120,000
30,000
19:48 (UTC+2)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
Fuajee hakkab tühjenema Posted Thursday 29th February, 2024 at 19:48(UTC+2) by maheaaatom
Allesjäänud mängijate arv on juba langenud alla 200 ning fuajeesse on jäänud veel vaid neli lauda.
Päeva lõpuni on jäänud veel vaid üks 60-minutiline tase.
Eesti superässade stäkid Posted Thursday 29th February, 2024 at 19:34(UTC+2) by maheaaatom
Player
Chips
Progress
Mauri Dorbek
90,000
60,000
Ermo Kosk
87,000
57,000
Priit Parmasto
60,000
30,000
Markku Koplimaa
50,000
10,000
Igor Pihela vanem
45,000
15,000
Algas tänane teine kõrvalturniir Posted Thursday 29th February, 2024 at 19:20(UTC+2) by maheaaatom
Äsja läks käima teine tänane kõrvalturniir, 350 € PLO 4/5 Progressive Bounty. Laudades 72 mängijat, eestlasi on nende seas kahjuks küll vaid mõned üksikud.
Üks kõrvalturniir on täna veel - kell 21:30 algab 350 € Shothand NLH.
Mairo saab lisa Posted Thursday 29th February, 2024 at 19:14(UTC+2) by maheaaatom
Risto Ponnio oli oma viimase 18K-ga keskel mulluse WSOPC Tallinn põhiturniiri viienda mehe Mairo Tori vastu.
Risto Ponnio: Mairo Tori:
Soomlane oli küll ees pärast floppi , kuid tõusis juba püsti. Eelaimdus osutus õigeks, sest turni potsatas.
"Ma teadsin, et see tuleb," sõnas Ponnio, kelle käsi oli drawing dead. Meie mehel nüüd 155K.
Player
Chips
Progress
Mairo Tori
155,000
21,000
Poolakas naudib massaaži Posted Thursday 29th February, 2024 at 18:56(UTC+2) by maheaaatom
Teises lauas istuv poolakas Dawid Lukasz Zielinski on nautinud juba mitu tundi massaaži ning ka tema kaart pole üldse pahasti jooksnud.
Massaaž maksab muidu 1,50€/minut. Tund seega tubli 90 eurot.
Ranel juhib turniiri! Posted Thursday 29th February, 2024 at 18:52(UTC+2) by maheaaatom
Ranel Käsi on tõusnud juba 240K peale, mis on hetkel turniiri suurim stäkk. Meie meestest on 100K+ stäkid ka Mairo Toril ja Margus Tuvikesel.
Player
Chips
Progress
Ranel Käsi
240,000
135,000
Mairo Tori
134,000
59,000
Margus Tuvikene
120,000
47,000
Paul Koppe
97,000
23,000
Kaur-Silver Koha
96,000
66,000
Mihkel Vitsur
80,500
26,500
18:49 (UTC+2)
Start of Level 7 Blinds: 400/800 Ante: 800
1B viimane paus Posted Thursday 29th February, 2024 at 18:31(UTC+2) by maheaaatom
Mängijad saavad veel 15 minutit puhata ning valmistuda tänaseks viimaseks kahetunniseks lahinguks.
Markku võtab mängu muretult Posted Thursday 29th February, 2024 at 18:28(UTC+2) by maheaaatom
Markku Koplimaa on oma teise katsega 60K peale tõusnud ning loodab päeva peale lisa hankida. "Kui tuleb, siis tuleb. Aga kui ei tule, pole katki ka midagi. Homme on veel küllaga aega," on Markku muretu.
Ermo Kosk lubab võidelda ainult selle nimel, et oma senine Olympicu-cashi rekord (105K) ületada. Kindlasti pakub seda võimalust põhiturniir (kus Ermo oli 2020. aastal teine) aga mine tea - äkki ka homne 5000 € highroller. On üsna tõenäoline, et kui Ermo peaks põhiturniirilt välja langema, siis võib teda ka seal mängimas näha.
Player
Chips
Progress
Markku Koplimaa
60,000
30,000
Tiimitunne on tähtis Posted Thursday 29th February, 2024 at 18:20(UTC+2) by maheaaatom
Täna lõunase seisuga juhib tiimide arvestuses endiselt soomlaste KIIRED JA VIHASED, eestlaste parim punt TIME on neljandal kohal.
Oma pundile tuli just punktilisa teenima Tarmo Tammel. Ta pääses 1A-lt edasi igati korrraliku 104 000 punktiga ning nüüd on aeg keskenduda teistele turniiridele. 250 € NLH (hetkel 111 sisseostu) sobib selleks väga hästi.
600 sisseostu piir on ületatud Posted Thursday 29th February, 2024 at 18:07(UTC+2) by maheaaatom
Järgmine täissada on ületatud, kahe avapäeva peale kokku on sisseoste juba 608. Pole välistatud, et senine rekord lüüakse üle juba päeval 1B.
Paul võtab veel lisa Posted Thursday 29th February, 2024 at 18:03(UTC+2) by maheaaatom
Paul nõrkade kätega pankasid ei võida. Ikka majade ja royalitega. Natuke tuleb veel juurde pangas, kus lauda oli pandud. Paul panustas 15K ja sai calli pikalt "tankinud" Jesper Hansenilt.
Paul näitas seitset ning korjas panga maha. Tal nüüd umbes 120K.
Player
Chips
Progress
Paul Koppe
120,000
30,000
Priit laseb stäkil tiksuda Posted Thursday 29th February, 2024 at 17:46(UTC+2) by maheaaatom
Juba mõnda aega pole lauas näha olnud tiitlikaitsjat Priit Parmastot, kelle umbes 40K stäkk tiksub tühjalt.
WSOP Circuit'il pälvis Priit tähelepanu sellega, et mängis turniiriga samaaegselt ülikõrget online-cashi, istudes lauas summaga, mis ületab Riigikogu liikme aastapalka. Mis asju Priit praegu ajab, pole teada.
17:40 (UTC+2)
Start of Level 6 Blinds: 300/600 Ante: 600
Rekord numbrites Posted Thursday 29th February, 2024 at 17:30(UTC+2) by maheaaatom
Mullune Kings of Tallinn põhiturniir oli läbi aegade suurim. Milline oli sisseostude arv siis ja praegu?
Päev 1A: 2023 - 227 / 2024 - 238
Päev 1B: 2023 - 286 / 2024 - 353 ja kasvab
Päev 1C: 2023 - 91 / 2024 algab kell 19:00
2. päeva algus: 112 / 2024 kestab 2 levelit kauem
KOKKU: 2023 - 716 / 2024 - 591 ja kasvab veel palju!
Selle käe oleks pidanud cashis saama! Posted Thursday 29th February, 2024 at 17:20(UTC+2) by maheaaatom
Paul Koppe on kõrgete käte mees. Laupäeval võitis ta PLO Royal Flushiga, nüüd aga duubeldas läbi ühe vastase jaotuses, mille eest oleks alumisel korrusel nüüdseks juba 94380-euroseks paisunud Bad Beat Jackpoti saanud. Viimast on jahitud enam kui aasta, Paulil kulus selleks aga vaid 4 tundi.
Paul:
Vastane:
Lauda XX!
Pauli stäkk on umbes 90K. "Mul oli vahepeal ainult 9K alles, aga siis hakkas minema, floppasin seitsmetega seti ja vastane bluffis mind all-in. Ja lõpetuseks see duubel majaga maja vastu."
Player
Chips
Progress
Paul Koppe
90,000
60,000
Ranel saab lisa Posted Thursday 29th February, 2024 at 17:10(UTC+2) by maheaaatom
Albert Martinez Domenech avas CO-lt 1000-ga, Ranel kolmpanustas BB-lt 3000 ning Domenech callis.
Käsi jätkas 2800 panusega pärast floppi ning 8000-ga pärast turniDomenech callis mõlemal tänaval, et näha riverit , mille järel paugutas Ranel juba 40 000, mis oli vastase stäkist suurem. Calli ei tulnud, meie mehel nüüüd 105K.
Player
Chips
Progress
Ranel Käsi
105,000
27,000
Algab tänane esimene kõrvalturniir Posted Thursday 29th February, 2024 at 16:59(UTC+2) by maheaaatom
Kohe läheb käima tänane esimene kõrvalturniir, 250 € NLH. Esialgu on kirjas 34 mängijat.
Põhiturniiri viimane satelliit on osutunud ülimalt populaarseks, sest sisseoste on tehtud juba 174 ning praeguse seisuga antakse ära koguni 11 piletit.
Saabus showmees Jaanus Veste Posted Thursday 29th February, 2024 at 16:55(UTC+2) by maheaaatom
Uutest mängijatest on lauas mullus Summer Showdown 5K highrolleril ehitustöölise riietes muljetavaldava show'd teinud (ning seejuures ka cashinud!) Jaanus Veste.
Samuti saame uuesti tervitada Georgi Abuladzet. Georgi mängis ka eile, kaotades kogu oma stäki valusas käes (200K pank) pocket kuningatega pocket ässadele. Loodetavasti sellist coolerit täna enam ei tule.
10 suurimat eestlaste stäkki Posted Thursday 29th February, 2024 at 16:44(UTC+2) by maheaaatom
Neljanda mängutaseme lõppedes juhib päeva 1B itaallane Luca Beretta, kelle kontol on muide üks Kings of Tallinn Summer Showdown turniirivõit.
Parim eestlane on hetkel Ranel Käsi.
Player
Chips
Progress
Ranel Käsi
78,000
48,000
Mairo Tori
75,000
45,000
Margus Tuvikene
73,000
43,000
Marko Olop
70,500
40,500
Peeter Talviste
65,000
35,000
Laur Sibold
63,000
3,000
Mihkel Vitsur
54,000
24,000
Sten Talviste
49,000
19,000
Romet Martjan
45,000
15,000
Martin Piik
44,300
14,300
16:37 (UTC+2)
Start of Level 5 Blinds: 200/500 Ante: 500
Väike puhkus Posted Thursday 29th February, 2024 at 16:18(UTC+2) by maheaaatom
Pool päevast 1B on läbi ning mängijad lubatakse puhkama. Pausi jooksul loetakse ka chippe, seega saame peagi natuke täpsemat infot eestlaste käekäigu kohta.
Laudades 249 mängijat.
Tipp-päevadel on ametis üle 100 diileri Posted Thursday 29th February, 2024 at 16:04(UTC+2) by maheaaatom
Kas olete mõelnud ka nende inimeste peale, kes mängijatele kaarte jagavad?
Huvitav on teada, et Kings of Tallinn 2024 festivalil jagab kaarte omajagu diilereid, maksimaalselt sadakond diilerit ühes päevas. Neile lisanduvad veel diilerite tööd ja turniiri juhtivad ning samuti alaliselt turniirialal viibivad inimesed (nn. floor).
Ka Ermo on mängus Posted Thursday 29th February, 2024 at 15:56(UTC+2) by maheaaatom
Seitsmekordne Eesti meister Ermo Kosk on samuti tänaste hiliste registreerujate seas. Ermo nimel on siiani eestlaste suurim ühekordne cash Kings of Tallinnalt, mis pärineb 2020. aasta põhiturniirilt. Ta jõudis kahe parima sekka ja tegi hilisema võitjaga diili, teenides 105 tuhat eurot. Ermo algus on olnud korralik, tal umbes 50K.
Kuidas teistel meie omadel läheb? Mairo Tori on oma teisel katse algstäki kahekordistanud (65K). Andrey Koks on 40K peal, Laur on natuke (kuid mitte oluliselt loovutanud). Markku Koplimaa on samuti mängus tagasi ning Mauri üritab oma 7XBB-ga imesid teha. Igatahes bulletit kaotanud ta veel ei ole.
Auhinnagarantii on ületatud Posted Thursday 29th February, 2024 at 15:37(UTC+2) by maheaaatom
Korraldajad lubasid turniirile 500K auhinnagarantiid ning juba praegusega võime kinnitada, et see number on täis. Liigume pigem ikkagi 800K kursil.
Hetkel 541 sisseostu (neist 305 täna), laudades 253 mängijat.
15:35 (UTC+2)
Start of Level 4 Blinds: 200/400 Ante: 400
Priit saabus tiitlit kaitsma Posted Thursday 29th February, 2024 at 15:35(UTC+2) by maheaaatom
Kohal on ka tiitlikaitsja Priit Parmasto, maailmatasemel cashi- ja turnapro, kes eelmisel aastal põhiturniiri kinni koputas.
"Esialgu mängin põhiturniiri, aga võimalusel ka nii 5K kui 3K highrollereid," räägib Priit. Oma stäkile on ta ka umbes kolmandiku võrra lisa saanud.
Tema kõrval istub muide Mauri Dorbek, kel on alles 7XBB. Paistab, et varsti tuleb võtta ette teekond kassa suunas...
Põhiturniiri satelliiti alustas 69 mängijat Posted Thursday 29th February, 2024 at 15:16(UTC+2) by maheaaatom
Põhiturniiri satelliidilt ei tasu overlayd oodata, sest juba alustajaid oli päris palju. Ning vaadates osalejate nimekirja, on seal kirjas enamasti mängijad, kes põhiturniirist nagunii osa võtavad.
Hanna mängus tagasi, Peeter ja Meelis natuke tõusnud Posted Thursday 29th February, 2024 at 15:09(UTC+2) by maheaaatom
Ühe bulleti juba kulutanud Hanno Heinlo on mängus tagasi ning teise katsega pisut lisa teeninud. Esimene katse läks nihu põhjusel, et Hanna ässad jooksid Henri Wagneri pocket neljade otsa (all-in mindi pärast turni, neli oli avatud juba flopis).
Peeter Talviste ja Meelis Meliste on samuti mõlemad umbes veerandi jagu oma alsgtäkki kasvatanud. Hetkel juba 283 sisseostu.
Laur teeb rasket tööd Posted Thursday 29th February, 2024 at 14:48(UTC+2) by maheaaatom
Eestlastest on seni suurima stäkiga endiselt Laur Sibold, kel umbes 75K. Fuajees on Martin Piik samuti üsna kenasti alustanud, tal umbes 50K.
Uutest tulijatest hakkasid silma Tanel Evert, Marius Morel, Paul Koppe, Madis Ormisson ja Priit Vanem. Markku Koplimaal ja Kert Hallikul on esimene bullet tuulde lennanud, ka Hanna Heinlo ei istu enam pokkerilauas.
Player
Chips
Progress
Laur Sibold
75,000
15,000
Martin Piik
50,000
20,000
Millal Rannot näha saab? Posted Thursday 29th February, 2024 at 14:35(UTC+2) by maheaaatom
Eile käis üritusel ETV ning Aet Süvari, kes tegid muuhulgas juttu siiani ainsa eestlasest maailmameistri Ranno Sootlaga.
Esialgse info kohaselt peaks Rannot ning Kings of Tallinnat saama näha pühapäeva õhtul ETV uudistes .
Kas ja millal saame näha Rannot aga hetkel toimuval põhiturniiril? Veel ei tea, päevalt 1A mees igatahes edasi ei pääsenud. Aga võib eeldada, et täna on ta taas kohal, kas siis 1B-l või 1C-l.
Player
Chips
Progress
Laur Sibold
75,000
15,000
Martin Piik
50,000
20,000
500 sisseostu täis Päeva 1A tulemus ammu ületatud Posted Thursday 29th February, 2024 at 14:33(UTC+2) by maheaaatom
Kui päeval 1A tehti 238 sisseostu, siis nüüd on neid kirjas juba 262 ehk kokku 500.
Seejuures pole täna mäng veel õieti alanudki, õhtul on kavas veel 1C ning homme saab osta sisse kuni kella 16:40-ni. Kas auhinnafond päris miljoni euroni jõuab, on küsitav, kuid 800-900K peaks olema igati reaalne.
Kell 15:00 algab viimane põhiturniiri satelliit Posted Thursday 29th February, 2024 at 14:29(UTC+2) by maheaaatom
Täpselt kell 15:00 algab viimane põhiturniiri satelliit, millel osalemine maksab 80 eurot. Garanteeritud on vähemalt 5 x 1100 € piletit, mida saab kasutada õhtusel turbo-päeval 1C.
Turbo-eelvoor algab kell 21:00 ning sellel mängitakse samuti 8 taset, kuid igaüks vältab kõigest 30 minutit. Samas paljudele sobib just selline mänguformaat paremini.
14:21 (UTC+2)
Start of Level 3 Blinds: 100/300 Ante: 300
Esimene paus ja üleskutse flippama Posted Thursday 29th February, 2024 at 14:02(UTC+2) by maheaaatom
Mängijad pääsesid jalgu sirutama ning loomulikult saab pausi ajal osaleda ka 150-eurostel flipamentidel, mis mingeid mänguoskusi ei nõua.
Kui suudad oma flipi võita, oled automaatselt kirjas pühapäevases finaalis, saad Hendoni cashi ning võid koguda ka pearahasid, mis ulatuvad 10 000 euroni. Seega kui raha on ning käed sügelevad, siis tasub igal juhul proovima minna!
Lauri edukas algus Posted Thursday 29th February, 2024 at 13:57(UTC+2) by maheaaatom
ETPF-i president Laur Sibold on alustanud turniiri üsna edukalt ning oma algstäki juba kahekordistanud.
Player
Chips
Progress
Laur Sibold
60,000
30,000
Kelly visiit jäi lühikeseks Posted Thursday 29th February, 2024 at 13:50(UTC+2) by maheaaatom
Kelly Limonova sai kahjuks mängida vähem kui tunni ning on turniirilt väljas. Nagu ka Mairo Tori ja Roman Jezov, neist esimene küll juba re-entryga lauas tagasi.
Hetkel 218 mängijat ja 230 sisseostu. Lisandunud on Mark Metsla, Andrey Koks jt.
Eilne videokokkuvõte Posted Thursday 29th February, 2024 at 13:46(UTC+2) by maheaaatom
Vabanes üks hotellituba Posted Thursday 29th February, 2024 at 13:35(UTC+2) by maheaaatom
Hiltoni hotell on ammu viimse võimaluseni täis broneeritud ning hiljaks jäänud väliskülalised peavad otsima majutust teistest hotellidest.
Ühel õnnelikul veab, sest personali arvelt vabanes üks tuba ning kõige kiirem reageerija saab selle endale. Kuigi keegi soovib teada, siis Hiltoni kaheste tubade hinnavahemik on ürituse ajal sõltuvalt toa kategooriast 165-400 eurot/öö.
Igori karmid viis viimast kätt Posted Thursday 29th February, 2024 at 13:28(UTC+2) by maheaaatom
Kui päeva lõppedes viis viimast kätt välja kuulutatakse, on paljud mängijad juba mentaalselt "õhtul" ning hakkavad mõtlema järgmisele päevale. Seevastu teised otsivad just nendest kätest omi võimalusi iseäranis shortstackid.
Igor Pihela vanem oli eile pikalt üks turniiri liidritest, kuid kolm kätt viimasest viiest olid niivõrd brutaalsed, et Igor jäi nendega oma stäkist sootuks ilma. "Terve päeva ehitasin oma stäkki, aga läks seekord nii," tõdeb ka Igor ise. Aga nüüd on ta lauas tagasi ning asub uuesti ülesannet täitma.
Talvisted on samuti saalis Posted Thursday 29th February, 2024 at 13:18(UTC+2) by maheaaatom
Lisaks isale ja pojale Igor Pihelatele on Eestis veel üks ülitugev isa-poja tandem - Peeter ja Sten Talviste. Kahe peale kokku on mehed võitnud viis Eesti meistritiitlit ning näidanud häid tulemusi mitmetel suurtel festivalidel. Sten on maitsnud aastaid ka profileiba.
Aga mänguga on liitunud ka Martin Piik, Marek Selgeveer, Lauri Laast, Rauno Arras ja Dmitri Dudakov.
13:14 (UTC+2)
Start of Level 2 Blinds: 100/200 Ante: 200
Markku keskendub esialgu põhiturniirile Posted Thursday 29th February, 2024 at 13:13(UTC+2) by maheaaatom
Markku Koplimaa ütles, et hetkel on tema põhifookus suunatud põhiturniirile, kuid kui siin ei peaks hästi minema, kiikab ta kindlasti ka highroller-turniiride suunas.
Neid on tänavusel festivalil kaks - reedel kell 18:00 algab "viietuhandeline", laupäeval kell 15:00 aga "kolmetonnine".
Mullusel 3000 € turniiril oli 59 unikaalset mängijat, Summer Showdown 2023 "kolmetonnisel" aga 43. Eriti kõrget 5000 € Highrollerit pole veebruarikuisel Kings of Tallinnal veel mängitud, see oli esmakordselt kavas mullu suvel. Tollal võttis turnast osa ka ekspertide hinnangul online-mängijate maailma TOP3 kuuluv Ottomar Ladva, keda me sel festivalil küll kahjuks väga tõenäoliselt ei näe. Teadaolevalt ei viibi Ottomar hetkel ka Eestis.
Kelly is in da house Posted Thursday 29th February, 2024 at 12:52(UTC+2) by maheaaatom
Värskete tulijate seas on ka nimekas Eesti naismängija Kelly Limonova, kes on muide Kings of Tallinna esimese naisteturniiri (aastal 2015) võitja.
Kellyl õnnestus panna kinni üks 130 osalejaga freeroll ning just seal ta turniiripileti ka sai. "Kavatsen samas tuules edasi purjetada," on Kelly enesekindel.
Osalejaid on juba 157, lisandunud on ka turniiriäss Mauri Dorbek.
Teelel on uus hobi Posted Thursday 29th February, 2024 at 12:49(UTC+2) by maheaaatom
Kings of Tallinn 2024 hostess Teele Viira on leidnud Hiina pokkeri näol uue hobi ning kasutab igat vaba momenti selle mängimiseks.
"Järgmisel OFC turniiril olen kindlasti kohal. Ja ma ei tule niisama mängima!" lubab Teele ise. Nagu järgnev pilt näitab, on see troon justkui tema jaoks loodud.
Juba 141 mängijat Posted Thursday 29th February, 2024 at 12:39(UTC+2) by maheaaatom
Uksed on valla ning mängijaid lisandub iga minutiga. Eestlastest on istunud lausa veel Andres Allsalu, Toomas Marrandi, Risto Pärnat ja Mairo Tori.
Mis toimus eile, mis on plaanis täna? Posted Thursday 29th February, 2024 at 12:29(UTC+2) by maheaaatom
Kui eestlaste jaoks ebaõnnestunud Championshipist ja ka 1100 € PLO-st (esimesel parim koht 35., teisel ei jõudnud üldse keegi rahadesse) me eile juba kirjutasime, siis olgu mainitud ka teiste täna öösel lõppenud turniiride tulemused.
- 250 € NLH Progressive Bounty (291 sisseostu) – triumfeerisid norralane Ronny Albrigtsen ning rootslanna Gia Ann-Sophie Carneström.
- 150 € NLH Turbol tehti 215 sisseostu ning võit läks Ukrainasse, parima Eesti mängijana oli Dmitri Zatsik viies.
- 555 NLH Shorthandi (111 sisseostu) võitis meile hästi tuntud kivinäoga Soome pokkeriproff Roope Tarmi.
Lisaks põhiturniirile toimuvad täna:
- Kell 17:00 algab 250 € NLH
- Kell 19:00 algab 350 € PLO 4/5 Progressive Bounty
- Kell 21:30 algab 350 € NLH Shorthand.
Kell 15:00 saab mängida veel viimasel põhiturniiri satelliidil ning kell 23:00 võib juba tulla 5000 € Highrolleri pileteid jahtima.
Markku Koplimaa astus saali Posted Thursday 29th February, 2024 at 12:23(UTC+2) by maheaaatom
Tänaste nimekate eestlaste seas on näiteks nii Laur Sibold, Aleksandr Kuperman, Meeliste Meliste ku Ranel Käsi. Kohal on ka kaks naist: "Monsa" ja Hanna Heinlo.
Viimase uue tulijana astus just saali pokkerimiljonär Markku Koplimaa, kes on Eesti läbi aegade edukaim live-mängija.
Päev 1B on alanud Posted Thursday 29th February, 2024 at 12:20(UTC+2) by maheaaatom
Päev 1B on alanud ning mängijad laudades. Täna tõotab tulla veelgi suurema osalejate arvuga eelvooru kui eile, sest juba on kohal 107 pokkerisportlast.
12:19 (UTC+2)
Day 1B of Kings of Tallinn 2024 Started Level: 1 Blinds: 100/100 Ante: 100
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.