0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0059 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ_Est/1D/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0003 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.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0006 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.0077 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0006 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_KOT_555_Champ_Est'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '95'
0.0216 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '226'
AND `published` = 1
0.0209 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0044 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '227'
AND `published` = 1
0.0213 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '232'
AND `published` = 1
0.0206 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '235'
AND `published` = 1
0.0206 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '238'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '95'
AND `name` = '1D'
0.0052 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '235'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '235'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '10101'
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` = '10098'
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` = '10096'
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` = '10095'
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` = '10094'
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` = '10093'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10091'
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` = '10090'
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` = '10089'
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` = '10088'
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` = '10087'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10085'
ORDER BY `chip_change` DESC, `busted` ASC
0.0156 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10083'
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` = '10081'
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` = '10080'
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` = '10079'
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` = '10078'
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` = '10077'
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` = '10074'
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` = '10073'
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` = '10072'
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` = '10071'
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` = '10070'
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` = '10069'
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` = '10067'
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` = '10064'
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` = '10062'
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` = '10061'
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` = '10056'
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` = '10054'
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` = '10053'
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` = '10051'
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` = '10050'
ORDER BY `chip_change` DESC, `busted` ASC
0.0164 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10048'
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` = '10047'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10044'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10039'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10038'
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` = '10035'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10033'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10032'
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` = '10031'
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` = '10030'
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` = '10029'
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` = '10027'
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` = '10025'
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` = '10024'
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` = '10023'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '232'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '235'
ORDER BY `busted` ASC, `current_chips` DESC
0.0045 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` = '235'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10101'
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` = '10098'
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` = '10096'
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` = '10095'
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` = '10094'
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` = '10093'
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` = '10091'
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` = '10090'
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` = '10089'
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` = '10088'
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` = '10087'
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` = '10085'
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` = '10083'
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` = '10081'
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` = '10080'
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` = '10079'
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` = '10078'
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` = '10077'
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` = '10074'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10073'
ORDER BY `chip_change` DESC, `busted` ASC
0.0142 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10072'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10071'
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` = '10070'
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` = '10069'
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` = '10067'
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` = '10064'
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` = '10062'
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` = '10061'
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` = '10056'
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` = '10054'
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` = '10053'
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` = '10051'
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` = '10050'
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` = '10048'
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` = '10047'
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` = '10044'
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` = '10039'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10038'
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` = '10035'
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` = '10033'
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` = '10032'
ORDER BY `chip_change` DESC, `busted` ASC
0.0147 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10031'
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` = '10030'
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` = '10029'
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` = '10027'
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` = '10025'
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` = '10024'
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` = '10023'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '238'
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 1D lõpus Posted Tuesday 27th February, 2024 at 01:22(UTC+2) by Mariliis Joras
Player
Chips
Progress
Martti Keel
183,700
153,700
Viktor Blinov
116,000
86,000
Meelis Meliste
86,300
26,300
Richard Koppel
57,800
27,800
Herli Olop
47,300
2,700
Rain Heeringas
37,200
7,200
Masoud Mirza
25,000
17,000
Kaido Mikk
0
0
Päev purgis Posted Tuesday 27th February, 2024 at 01:14(UTC+2) by Mariliis Joras
Day 1D 77-st alustanust jäi järele 41.
Neist seitse on Eesti mängijad. Kohe saavad kirja ka stäkid.
Day 2 jätkub homme kell 12.00. Mängijaid julgustatakse kohale tulema varem, kuna all asuva registreerimislaua juurde on oodata ummikut. Siiski on raske ette kujutada, et keegi siinsest rahvast jaksaks liiga varakult kohale tulla...
Homme mängitakse kuni finaallaua selgumiseni ja FT saab endale eraldi päeva, startides kolmapäeval kl 12.
Player
Chips
Progress
Martti Keel
183,700
153,700
Viktor Blinov
116,000
86,000
Meelis Meliste
86,300
26,300
Richard Koppel
57,800
27,800
Herli Olop
47,300
2,700
Rain Heeringas
37,200
7,200
Masoud Mirza
25,000
17,000
Kaido Mikk
0
0
Eesti nupud kokku Posted Tuesday 27th February, 2024 at 01:06(UTC+2) by Mariliis Joras
Kalle Pops ja Martti Keel panevad stäkid üheks kokku. Muidugi ei ole juhtunu Kallele meele järgi.
ei osutunud lihtsalt seekord tabavaks käeks.
Martti sai lauast kümnele pihta.
Player
Chips
Progress
Kalle Pops
0
0
Ega ometi jälle? Posted Tuesday 27th February, 2024 at 01:02(UTC+2) by Mariliis Joras
Kaido Miku stäkk jäi pärast viimast mängitud jaotust ülihõredaks. Seega ei imestagi, et ta peatselt kõik sisse saab.
Seekord Kaidol käes , vastas .
Kui diiler avab flopis ja veel kaks ärtut, hakkab seis vägisi meenutama seda, mis äsja Kaidoga juba juhtus. Õnneks turn ja river seekord ohutud. Kaido saab duublisse. Siiski on sellest vähe. Homsesse tahaks ta kindlasti liikuda oluliselt särtsakama stäkiga.
Kell seisma Posted Tuesday 27th February, 2024 at 00:58(UTC+2) by Mariliis Joras
Turniirikell peatati ja loosi tahtel jagatakse igas lauas välja veel viis kätt. Siis loetakse päev lõpetatuks.
Õnn ja ebaõnn käivad käsikäes Posted Tuesday 27th February, 2024 at 00:58(UTC+2) by Mariliis Joras
Kaido Mikk avab 2500, mille peale Oleksandr Tarashevkyi all-ini liigub. Tal on veidi vähem kui Kaidol, kuid üsna shortid on mõlemad. Kaido leiab, et on selles olukorras callimiseks piisav.
Oleksandril
Lauda
Kaido läks korraks juhtima, kuid river rikkus asja.
Paarkümmend minutit jäänud Posted Tuesday 27th February, 2024 at 00:48(UTC+2) by Mariliis Joras
5 minutit tagasi läks käima mängupäeva viimane level. Meie mängijatel vaja vastu pidada veel loetud minutid!
00:46 (UTC+2)
Start of Level 9 Blinds: 600/1,200 Ante: 1,200
Herlile toovad samuti kümned õnne Posted Tuesday 27th February, 2024 at 00:46(UTC+2) by Mariliis Joras
Herli Olop liigitab järgmise jaotuse turniiri ilusate hetkede hulka.
Tõstele 4000 saab Herli calli.
Lauda tulevad .
Herlil ehk ei mingit masti lootust, kuid kaunis set tabatud. Panuseks loeb Herli välja kolmandiku pangast. Vastane paneb nuppe ja mõistagi saab ta calli.
Vastase kaardid ehk lootusetu seis.
Herli stäkk 50 000 peal. See on ka praegu keskmise stäki suurus. Mõnus edasi rühkida.
Player
Chips
Progress
Herli Olop
50,000
20,000
Meelisel on rõõmusõnumeid Posted Tuesday 27th February, 2024 at 00:41(UTC+2) by Mariliis Joras
Meelis Meliste saab SB-l kätte kümnete pocketi. Lauakaardid annavad talle koos kuningatega maja, mis on paras retsept ühe vastase välja võtmiseks. -g amängival mehel finito.
Vaikimisvanne Posted Tuesday 27th February, 2024 at 00:40(UTC+2) by Mariliis Joras
Masse on sisse pannud 2000, kui väikse stäkiga vastane all-ini liigub. Callida on nii vähe, sest teisel vaid 10 700. Mida siis teha? Äkki joppab?
Masse otsustabki callida, kuid blogisse jaotuse detaile kirjutada ei luba. Ega sellele suited, kuid muus mõttes pigem kehvakesele kaardile tõesti suuri lootuseid poleks mõtet panna, aga vastase viite pocketi suhtes on tegemist ülekaartidega.
Laud paraku ei aita. Et Masse on vahepealse põua jälle üle elanud, saab ta seda soodsat jaotust endale õnneks lubada.
Päeva ainus naine out Posted Tuesday 27th February, 2024 at 00:29(UTC+2) by Mariliis Joras
Päevasel avapäeval oli naismängijaid pisut rohkem, kuid Anna Astahhova oli hilisõhtuse vahetuse ainus. Nüüd on temagi mängul joon all.
Player
Chips
Progress
Anna Astahhova
0
0
Enne maksa, siis tuku Posted Tuesday 27th February, 2024 at 00:28(UTC+2) by Mariliis Joras
Juho Härkönenile meeldib mängida just Martti Keele vastu.
Mehed on jõudnud turnini, seal ja Martti betib 2500. Juho tõstab 8000 peale. Herli Olop on sel hetkel samuti veel jaotuses, kuid sellise tõste peale loobub. Martti ei allu provokatsioonidele.
River ja Martti on nüüd see, kes 5000 juurde nõuab. Juho ei mõtlegi loobuda, kuigi endal on silmad iga hetk kinni vajumas.
Martti näitab ja sellest piisab. Vastane muckib.
Herli kommenteerib, et Martti kiusamine ei ole Juhol sugugi esmakordne. Kui kiusu tulemus on selline nagu praegu, siis andku kuuma.
00:21 (UTC+2)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
Mängijaid lisandub ka eelviimasel levelil Posted Tuesday 27th February, 2024 at 00:21(UTC+2) by Mariliis Joras
Võiks ju arvata, et turniir hakkab vaikselt lõpu poole triivima ja ega keegi täna enam peoga ei liitu, kuid võta näpust. Ka 8. tasemel on olnud siin-seal uusi liitujaid. Ükski neist pole küll eestlane.
Bluff Meelise vastu õnnestub Posted Tuesday 27th February, 2024 at 00:19(UTC+2) by Mariliis Joras
Ega meil siin kogu aeg kah tabamusi ei ole. Meelis Meliste saab seda oma nahal tunda.
Floppi vaatab ta Mihn Thang Ngoga 1700 eest.
Lauda ja Mihn checkib. Meelis jätkab 1400-ga ja Mihn läheb kaasa.
Turn , kordub sama stsenaarium, ent nüüd on Meelise bet 1700.
Riveris ja Meeliselt 3000. Mihn teeb tõste 8000 ja saabki Meelisest lahti. Kuna tal on nii hea meel, siis näitab ta ka bluffi.
Ei, siiski pole Hendriku päev Posted Tuesday 27th February, 2024 at 00:11(UTC+2) by Mariliis Joras
Raske laud sai saatuslikuks. Hendriku stäkk on tühjaks jooksnud ja enam teda lauas ei näe.
Kindlasti kohtume temaga aga järgmistel turniiridel, kuhu tal pilet juba taskus.
Player
Chips
Progress
Hendrik Uibo
0
0
Veel draamat Posted Tuesday 27th February, 2024 at 00:09(UTC+2) by Mariliis Joras
Segadusi ikka juhtub, eriti saalis, kus mängitakse päeva jooksul läbi sadu pokkerijaotusi.
Nüüd juhtub nii, et üks tähelepanematu mängija jätab lauda panemata SB ja seda teeb tema asemel BB. Suure blindi asetab lauale aga Adrians Imsa, kes pidanuks olema hoopis UTG.
Viga avastatakse, kui Vygerdas Jonikas on juba tõste teinud ja sellele Anna Astahhovalt calligi saanud. Kõigepealt kutsub diiler appi väikse floori. Tema kuulab ära ja vangutab pead. Kutsutakse kohale järgmine floor. Temagi kuulab, mõtleb, kuid peab paremaks kutsuda suur floor. Juba kolmas isik, kes segadust lahendama tuleb. Ja lahendatud see saab. Oma korra unustanud SB peab taskukaartidest loobuma ja ta jäetakse lihtsalt vahele. Teised saavad edasi mängida.
Jaotus suuri pöördeid ei too. Flopis shoveb BB-l istuv Adrians, aga mitte enne, kui ta on ette checkinud. Ühtegi calli ta ei saa, ainult väikse chipilisa.
Tahtsid sõita? Siis sõidame! Posted Monday 26th February, 2024 at 23:58(UTC+2) by Mariliis Joras
Hendrik Uibo avab miinimumtõstega 1600. Vana sõber Rasmus Lundström teeb tõste 4200. Hendrikut ta sellega maha ei saa.
Flopis ja Hendrik checkib. Nüüd paneb Rasmus 2700. Hendrik viib oma stäki, mis kahjuks vahepeal kannatada saanud, keskele, aga nüüd tuleb Rasmuselt kibekiire fold.
Ju siis ei tahtnudki nii väga sõitma minna.
23:52 (UTC+2)
Start of Level 7 Blinds: 400/800 Ante: 800
Niklas ei lase end segada Posted Monday 26th February, 2024 at 23:50(UTC+2) by Mariliis Joras
Niklas Gjersvold on Norra kröösus, kes käis juba päevasel flightil paugutamas ning ei anna alla ka öösel. Kohe kui ta välja kukub, viib tee kassa juurde. Ja juba ongi mees tagasi lauas.
Raini hea tabamus Posted Monday 26th February, 2024 at 23:48(UTC+2) by Mariliis Joras
Rain Heeringas mängib -ga ja floppab kuningate kolmiku. Nice!
See jaotus toob ka tulu, mida hädasti tarvis.
Aleksandr out Posted Monday 26th February, 2024 at 23:44(UTC+2) by Mariliis Joras
Aleksandr Jelpidiforovil järel riismed, aga kaotab ta needki. Jani Vilmunen saab Aleksandri stäki kätte üheksate pocketiga.
Player
Chips
Progress
Aleksandr Jelpidiforov
0
0
Lõpp hea, kõik hea Posted Monday 26th February, 2024 at 23:42(UTC+2) by Mariliis Joras
Kaido Mikk on jaotuses Kauri Jämseniga.
Flop ja Kaido peab rääkima. Ta checkib. Kauri betib 1200 ja Kaido paneb enda ette 5000-lise chipi ning ütleb "Four". Diiler kuulis, et Kaido ütles "call" ja majandab juba "vahetusrahaga", samuti on kibekiirelt lahti turn .
"Mis toimus, kas ta callis?" uurib segaduses Kaido ja alles siis tuleb välja, et midagi on läinud nihu. Probleemi kutsutakse lahendama floor, kes kuulab asjaosalised ära ja on ka mõnevõrra kimbatuses, sest aus viga mõlema poolt. Keelte erinevus, aktsent ja kahe sõna ülim sarnasus teevad olukorra keerukaks. Diiler kuulis valesti, aga ka Kaido ei teinud tehniliselt midagi valesti... Lõpuks jääb Kaido tõste ikkagi calliks ja mäng jätkub.
Turni peale Kaido checkib ja sama teeb vastane.
River toob Kaidolt beti 5500 ja õnneks maksab vastane selle kinni. Õnneks sellepärast, et Kaido oma -ga flopatud kahe paari abil ikkagi mingi teenistuse saaks ja diilerile andestada suudaks.
23:27 (UTC+2)
Start of Level 6 Blinds: 300/600 Ante: 600
Mängijad 15 minutiks pausil Posted Monday 26th February, 2024 at 23:14(UTC+2) by Mariliis Joras
Tasemed võivad Day 1D-l lühemad olla, aga pausid on ikka sama pikad kui teistelgi. Algas 15 minutit vaheaega.
Mängivad küll, aga välja kukkuda ei taha Posted Monday 26th February, 2024 at 23:13(UTC+2) by Mariliis Joras
Alustanute arv on kerkinud 65-ni, kuid väljakukkujate arv kasvab visalt. Ainus, kes seda statistikat kuidagigi elustab, on poolakas Dominik Ostrowski. Ta tegi re-entry ja kukkus siis järgmisena uuesti ise välja.
Läheb soodsalt Posted Monday 26th February, 2024 at 23:10(UTC+2) by Mariliis Joras
Meelis Meliste osaleb jaotuses, kus on peaaegu lõpuni välja juhi rollis.
Flopis ja Mika Rönkkönen betib 1200. Selle tõstab Meelis 3000 peale ja callivad nii buttonil istuv Dmitrijs Rizovs kui Mika.
Turn ja ees check. Panus 2000 tuleb Meeliselt ja saab kaks calli.
River ja nüüd jõuab initsiatiiv Dmitrijsini, sest kumbki vastastest juhivankrit vedada ei võta. Bet on pirakas 10 000. Keegi ei maksa ja see on hea otsus, sest Dmitrijsil on soldat olemas. Seekord pääsesid vastased soodsalt.
Midagi õhtusesse vööndisse Posted Monday 26th February, 2024 at 22:58(UTC+2) by Mariliis Joras
Vaid loetud minutite pärast algab turniir nr 23. See on 80-eurose sisseostuga satelliitturniir 1100-eurose sisseostuga PLO Championshipile, kusjuures garanteeritud on lausa 5 piletit. Hetkel on kirjas vaid 20 mängijat. Põnev turbokas hilisõhtul läbi puremiseks.
22:48 (UTC+2)
Start of Level 5 Blinds: 200/500 Ante: 500
Raske laud Posted Monday 26th February, 2024 at 22:48(UTC+2) by Mariliis Joras
Hendrik Uibo ei hakka salgama, et on sattunud raskesse lauda, kus tuleb edu saavutamiseks korralikult mütata.
Satume pealt nägema jaotust, kus võetakse rahulikult. Floppi tahavad hinnaga 1000 vaadata kokku viis mängijat.
lauda ja ees neli checki.
Hendrik on nupul, kust ta betib 3000. Vaid Rasmus Lundström callib.
Turni checkivad mehed läbi.
River ja Rasmus checkib. Hendrik betib 1500 ja saab ka calli, kuigi Rasmus vaeb käiku tükk aega. Pärast vabandab. "Ma mõtlesin, et bet oli 5500, ajasin värvid segi. Sellepärast mõtlesingi oluliselt kauem, kui oleks pidanud," selgitab ta asja.
Hendrik avab ja on panga sellega endale võitnud.
Massel polnud valikut Posted Monday 26th February, 2024 at 22:40(UTC+2) by Mariliis Joras
Masse kurtis juba tükk aega tagasi, et kätte ei satu midagi mängitavat. Stäkk kuivaski vaikselt väiksemaks ja väiksemaks. Lõpuks muutis ta strateegiat. "Pidin hakkama kehvade kaartidega mängima," ütleb ta, kraapides laualt kokku just äsja võidetud duublit.
Boardil on , Masse ees ja vastasel .
Mis iganes töötab!
Player
Chips
Progress
Masoud Mirza
42,000
12,000
Leedukas lubab actionit Posted Monday 26th February, 2024 at 22:36(UTC+2) by Mariliis Joras
Leedukas Vygerdas Jonikasel on hea tuju ja ta lubab, et kui reporter jääb laua juurde ka järgmiseks käeks, siis saab actionit. No jäämegi ootele.
Käsi algab limpidega. Callib ka Vygerdas. "Aga agressiivselt," kommenteerib kõrvalt lätlane Adrians Imsa, kes ise ainsana foldib. Kõik ülejäänud limbivad family potti sisse.
Avatakse flop, mis siinkohal polegi väga oluline. Ees on checkid. Checkib ka Vygerdas, ent Adrians lisab, et seegi check on pigem agressiivne. Viimasena räägib Erik Hansen Taanist, bettides 1500. "Reporter on laua juures, ma pean panga maha võtma," selgitab ta. "Kas ta on miski kuulsus?" küsib keegi Eriku kohta. "Jah, väga kuulus. Enda sõprade seas," lisab Adrians. Naerdes tuleb üks fold teise järel ja Erik saabki panga kätte.
Paistab üks väga muhe laud, kuhu tasub tagasi tulla.
22:27 (UTC+2)
Start of Level 4 Blinds: 200/400 Ante: 400
Tuju tuleb üleval hoida Posted Monday 26th February, 2024 at 22:27(UTC+2) by Mariliis Joras
Keset kätt tahab iga pokkerimängija jääda võimalikult neutraalseks kivinäoks, kelle ilmet ei saa mitte kuidagi tõlgendada. Soomlane Juha Kinnunen väljendab emotsioone oma lauakaaslaste eest. Täitsa suvalist floppi nähes karjatab ta üle saali: "Jess!" Ise jaotuses osalemata... Eks ole juba ka omajagu vembujooki manustatud, nii et ei pane imestama.
Ülejäänud mängijad on väga reserveeritud ja hetkel on vaikus majas. Mängijaid aga tilgub juurde, sh ka eestlasi.
Player
Chips
Progress
Viktor Blinov
30,000
0
Anna Astahhova
30,000
0
Kalle Pops
30,000
0
Kaido Mikk
30,000
0
Aleksandr Jelpidiforov
30,000
0
Allan lohutab Posted Monday 26th February, 2024 at 22:17(UTC+2) by Mariliis Joras
Allan Arjut tuleb oma turniiri mängimise juurest jalgu sirutama ja saab Phil Grossilt kuulda, kuidas Meelis Meliste juba kaks korda Phili ässade pocketi ära on kräkkinud.
Allan lohutab, et Meelis on nagu pehme banaan ja tema pärast pikalt muretsema ei pea. "Minu jaoks on ässad nagu kaks ja seitse," viskab Meelis õli tulle ja nalja jätkub kauemaks. Õnneks pole Phil esimest päeva pokkerilaua taga, nii et ta teab täpselt, millised Ameerika mäed ees võivad oodata.
21:58 (UTC+2)
Start of Level 3 Blinds: 100/300 Ante: 300
Kas see oli Kalevi eest? Posted Monday 26th February, 2024 at 21:58(UTC+2) by Mariliis Joras
Boardil ja Meelis Meliste on bettinud 1500. Phil Gross on selle üle tõstnud 6500 peale ja Meelisel vaja nüüd välja mõelda, mida teha. Ta on -ga alles rida püüdmas, kuid kuskilt seljaajust jõuab pähe impulss, et tuleb callida.
River on Meelisele jackpot. Veelgi parem on see, et Phil liigub nüüd all-ini ja ainus, mida teha vaja, on lihtsalt calli nupu vajutamine.
Meelis avabki käsi hõõrudes kaardid ja näitamata ei saa jätta ka pettunud Phil. Tüübil ässade pocket.
Ons see kättemaks Kalevi eest?
Player
Chips
Progress
Meelis Meliste
60,000
30,000
Phil peab õnne tänama Posted Monday 26th February, 2024 at 21:51(UTC+2) by Mariliis Joras
Sakslasel Phil Grossil veab. Ta hitib flopist top-paarina kaheksat ja shoveb. Kalev Männastel on üheksate pocket ja ta võtab selle väljakutse vastu. Turnis on Kalevil nii masti- kui reaost, nii et ta on kenasti ees, kuid riverisse potsatab veel üks kaheksa, mis ongi ainus kaart, mis Philile võidu annaks.
Kalevi stäkk väiksem. Selline see pokker on.
Player
Chips
Progress
Kalev Männaste
0
0
21:39 (UTC+2)
Start of Level 2 Blinds: 100/200 Ante: 200
Kas väga hästi või väga halvasti Posted Monday 26th February, 2024 at 21:38(UTC+2) by Mariliis Joras
Masse jalgealune läheb jälle kuumaks, nii nagu see on täna juba mitu korda olnud - päeval tuli teha ju kaks sisseostu. Floppi soovib ta ise vaadata 1100 eest ja saabki kaks mängijat kaasa.
lauda ja kapteni rolli võtab üle Niklas Gjersvold, kes peab esimesena rääkima.
Niklas betib 2100 ja ainult Masse callib.
Turn ja Niklas läheb aplamaks. Küsitud 4400 ta siiski veel saab.
River ja Niklase bet 11 600. Masse krigistab ajukäärusid. Vastasel on ilmselt kas väga hästi või veelgi paremini. Seetõttu peab ta paremaks loobuda.
Kui jaotus juba läbi, kuulutab Niklas, et tal olid ässad. Kas see ka tõele vastab, jääb igavesti saladuseks.
Meelis ka lauas Posted Monday 26th February, 2024 at 21:31(UTC+2) by Mariliis Joras
Turniirile on vahepeal jõudnud Meelis Meliste. Ta on istutatud Kalev Männastega ühte lauda.
Player
Chips
Progress
Meelis Meliste
30,000
0
Nüüd ongi mäng tõsisem Posted Monday 26th February, 2024 at 21:28(UTC+2) by Mariliis Joras
Hendrik Uibo vajas vaid 20 minutit, et oma stäkile kolmandik otsa kasvatada. Mäng on nüüd, kui oma ja sõprade raha kaalul, märgatavalt tõsisem. Samas tuju püsib hea.
Player
Chips
Progress
Hendrik Uibo
40,000
10,000
Kalev pole veel vedama saanud Posted Monday 26th February, 2024 at 21:23(UTC+2) by Mariliis Joras
Esimese käega hittis Kalev Männaste kolmikut. Tema õnnetuseks sai vastane riveris mastile pihta. Siiski jäi Kalev konservatiivseks ja lammutama ei hakanud, mistõttu kogu kadu jäi 1000 piiresse.
Mõni jaotus hiljem tuleb samuti vastasele alla vanduda. Seegi kord on vastas rida, kuid et kaotusi minimeerida, ei hakka Kalev riveri betti enam maha callima.
Keda veel jälgime? Posted Monday 26th February, 2024 at 21:18(UTC+2) by Mariliis Joras
Hetkel on alustanud 29 mängijat. Eesti mehed loetleme siinkohal üles. Robert Relander mängib küll Soome lipu all, aga raske on teda mitte-eestlaseks pidada, seega jälgime loomulikult ka tema käekäiku.
Player
Chips
Progress
Herli Olop
30,000
0
Masoud Mirza
30,000
0
Martti Keel
30,000
0
Rain Heeringas
30,000
0
Kalev Männaste
30,000
0
Robert Relander
30,000
0
Hendrik jälle platsis Posted Monday 26th February, 2024 at 21:13(UTC+2) by Mariliis Joras
Kolm on kohtu seadus ja loodame, et kolmest bulletist Hendrikule piisab, et mõnusalt teise päeva edeneda.
Täpsemalt uurides selgub, et Hendrikul oli kasutada kaks satelliitidelt võidetud piletit, nii et kulu ei olegi õnneks nii suur. "Mul on terve festival piletite peal," ütleb Hendrik.
Käesoleva stardi on ta finantseerinud sõpradega pooleks. Nimelt panid 50% sisseostust välja sõbrad Marius Morel ja Allan Arjut.
Pöidlad pihku!
Player
Chips
Progress
Hendrik Uibo
30,000
0
21:07 (UTC+2)
Day 1D of Kings of Tallinn 2024 Started Level: 1 Blinds: 100/100 Ante: 100
Alles kogunevad Posted Monday 26th February, 2024 at 20:57(UTC+2) by Mariliis Joras
Olemegi õhtus ja peatselt on algamas €555 Championship turniiri viimane avapäev.
Teadupärast mängitakse see turboformaadis, mis tähendab seda, et tasemed kestavad 40 minuti asemel 25 minutit. Seega tegelikult on mänguruumi piisavalt.
Ka 1D kestab 9 taset, nii et hinnanguliselt on kella 1-ks öösel chipid kotis.
Veel on vara hinnata, kui palju mängijaid on valinud õhtuse stardi, kuid paar eestlast on juba kohal. Kalev Männaste kaugelt Tartust ja Herli Olop, kes lasi esimese bulleti juba päeval lendu, on end igatahes laua taga sisse seadnud.
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.
ei osutunud lihtsalt seekord tabavaks käeks. 
sai lauast kümnele pihta.
, vastas 
.
on selles olukorras callimiseks piisav. 
.
ehk ei mingit masti lootust, kuid kaunis set tabatud. Panuseks loeb Herli välja kolmandiku pangast. Vastane paneb nuppe ja mõistagi saab ta calli.
ehk lootusetu seis. 
-g amängival mehel finito.
ja Martti betib 2500. Juho tõstab 8000 peale. Herli Olop on sel hetkel samuti veel jaotuses, kuid sellise tõste peale loobub. Martti ei allu provokatsioonidele.
ja sellest piisab. Vastane muckib. 
ja Mihn checkib. Meelis jätkab 1400-ga ja Mihn läheb kaasa. 
, kordub sama stsenaarium, ent nüüd on Meelise bet 1700.
bluffi.
ja Hendrik checkib. Nüüd paneb Rasmus 2700. Hendrik viib oma stäki, mis kahjuks vahepeal kannatada saanud, keskele, aga nüüd tuleb Rasmuselt kibekiire fold. 
ja ees check. Panus 2000 tuleb Meeliselt ja saab kaks calli.
ja nüüd jõuab initsiatiiv Dmitrijsini, sest kumbki vastastest juhivankrit vedada ei võta. Bet on pirakas 10 000. Keegi ei maksa ja see on hea otsus, sest Dmitrijsil on soldat olemas. Seekord pääsesid vastased soodsalt.
lauda ja ees neli checki. 
, Masse ees 
ja vastasel 
on Meelisele jackpot. Veelgi parem on see, et Phil liigub nüüd all-ini ja ainus, mida teha vaja, on lihtsalt calli nupu vajutamine. 
£ GBP
$ USD
€ EUR
