0.0005 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0076 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event_Fin/1B/updates'
ORDER BY `views` DESC
0.0142 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_Fin/1B/updates'
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0004 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0108 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0009 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0005 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.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.0071 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_KOT_1100_Main_Event_Fin'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '101'
0.0611 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '243'
AND `published` = 1
0.0690 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` = '246'
AND `published` = 1
0.0302 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0057 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '248'
AND `published` = 1
0.0802 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '253'
AND `published` = 1
0.0274 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` = '259'
AND `published` = 1
0.0573 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0057 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '265'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '101'
AND `name` = '1B'
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '246'
ORDER BY `busted` ASC, `current_chips` DESC
0.0062 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` = '246'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '10910'
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` = '10889'
ORDER BY `chip_change` DESC, `busted` ASC
0.0471 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10888'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10883'
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` = '10880'
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` = '10876'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10868'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10862'
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` = '10856'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10855'
ORDER BY `chip_change` DESC, `busted` ASC
0.0615 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10852'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10845'
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` = '10842'
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` = '10841'
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` = '10836'
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` = '10834'
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` = '10824'
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` = '10820'
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` = '10817'
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` = '10813'
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` = '10811'
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` = '10805'
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` = '10804'
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` = '10802'
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` = '10797'
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` = '10794'
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` = '10791'
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` = '10785'
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` = '10782'
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` = '10775'
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` = '10773'
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` = '10769'
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` = '10766'
ORDER BY `chip_change` DESC, `busted` ASC
0.0115 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10759'
ORDER BY `chip_change` DESC, `busted` ASC
0.0118 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10752'
ORDER BY `chip_change` DESC, `busted` ASC
0.0116 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10751'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10749'
ORDER BY `chip_change` DESC, `busted` ASC
0.0095 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10746'
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` = '246'
ORDER BY `busted` ASC, `current_chips` DESC
0.0052 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` = '246'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '10910'
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` = '10889'
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` = '10888'
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` = '10883'
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` = '10880'
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` = '10876'
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` = '10868'
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` = '10862'
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` = '10856'
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` = '10855'
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` = '10852'
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` = '10845'
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` = '10842'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10841'
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` = '10836'
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` = '10834'
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` = '10824'
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` = '10820'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10817'
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` = '10813'
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` = '10811'
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` = '10805'
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` = '10804'
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` = '10802'
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` = '10797'
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` = '10794'
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` = '10791'
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` = '10785'
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` = '10782'
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` = '10775'
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` = '10773'
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` = '10769'
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` = '10766'
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` = '10759'
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` = '10752'
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` = '10751'
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` = '10749'
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` = '10746'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '265'
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.
Suomalaisten pinot erästä 1B Posted Thursday 29th February, 2024 at 22:46(UTC+2) by Juhani Tyriseva
Suomalaiset:
Henri Wagner 193K Jani Tuovinen 173K Roope Tarmi 156K Kaisa Suorsa 121K Sauli Haapaniemi 117K Jani Vilmunen 107K Aleksi Naski 103K Antti Perttula 102K Simo Räikkönen 102K Mikael Haapaniemi 100K Mikko Ylämäki 93K Santtu Leinonen 92K Kyösti Isberg 86K Juuso Wiksten 83K Arto Lehtonen 81K Kalle Parkkinen 79K Ville Jantunen 76K Miro Lehtinen 76K Jan-Mikael Kesänen 74K Petteri Laiho 72K Jussi Vanhanen 62K JP Juhola 61K Jyrki Lampinen 58K Jari Mähönen 55K Jimi Koponen 54K Jari Hurri 52K Aki Pyysing 51K Hengtao Zhu 51K Erkka Lepola 44K Kristian Kostiander 41K Tommi Lankinen 40K Henri Ojala 34K Silja Kinnunen 32K Seppo Parkkinen 32K Jonatan Fors 28K Mikko Aro 27K Ari Varonen 26K John Lundqvist 26K Juho Suutari 24K Pekka Ikonen 23K
Erässä 1B tehtiin 385 sisäänostoa, jatkopaikan sai 167 pelaajaa.
Muistakaa rannekkeet Posted Thursday 29th February, 2024 at 20:58(UTC+2) by Juhani Tyriseva
Tässä on myös hyvä hetki muistuttaa tärkeästä asiasta:
Huomenna kasinon respassa on todella pitkä jono ennen turnauksen alkua. Jos asut tässä hotellissa, hae ranneke aamiaisreissulla. Jos asut muualla, ole silti kasinolla jo klo 11.30. Sateessa ei ole mukava seisoa, jono on todennäköisesti pisimmillään luokkaa 100 henkeä!!
Päivä 1B on päättynyt, merkit pussiin Posted Thursday 29th February, 2024 at 20:50(UTC+2) by Juhani Tyriseva
Päivä 1B on saatu päätökseen. Merkit alkavat olla pussissa, joten melko pian päästään aloittamaan päivää 1C.
Alustavien numeroiden mukaan erässä 1B tehtiin 385 sisäänostoa, ja jatkopaikan pelasi 167 pelaajaa.
Toimitus kaivaa meikäläisten chip countit järjestäjien listoista, eiköhän ne tunnin sisällä saada näkyviin (jos en kämmäile).
Juho törmäsi suoraan Posted Thursday 29th February, 2024 at 20:29(UTC+2) by Juhani Tyriseva
Riverissä pöydässä oli:
Marius Morel meni all in 24K, hieman yli potillisen. Juho Suutari miettimään, maksu.
Marius näytti suoran.
Juho näytti rattaat, joten Marius tuplasi, hänellä nyt noin 70K.
Lyhyttukkaisten tiukka matsi päättyi Akin voittoon Posted Thursday 29th February, 2024 at 20:20(UTC+2) by Juhani Tyriseva
Jani Vilmunen reissasi 3K total pienestä, Aki Pyysing maksoi isosta.
Floppi Aki löi 4K, maksu.
Turn Aki löi 7K, maksu.
River sököteltiin.
Jani näytti kuutoset ja neloset.
Aki näytti kuutoset ja viitoset, ja vei potin.
Juusolle mukavaa nousua Posted Thursday 29th February, 2024 at 19:53(UTC+2) by Juhani Tyriseva
Riverissä pöydässä oli:
Adrians Imsa löi 5500, Juuso Wiksten meni all in 16000, Jyrki Lampinen miettimään, kippi. Adrians mietti hetken ja maksoi.
Juuso näytti värin.
Adrians näytti pienemmän värin.
"Kymppi oli, mutta ei täyskättä", huokaili Jyrki.
Juuson pinossa nyt noin 50K.
Suomalaiset tason 7 lopulla Posted Thursday 29th February, 2024 at 19:28(UTC+2) by Juhani Tyriseva
Suomalaiset:
Silja Kinnunen 18K John Lundqvist 26K Jani Tuovinen 140K Jari Mähönen 55K Henri Ojala 30K Simo Räikkönen 105K Kyösti Isberg 85K Sauli Haapaniemi 130K Henri Wagner 175K Miro Lehtinen 65K Arto Lehtonen 60K Tomi Arponen 100K Jari Hurri 35K Juuso Wiksten 13K Jyrki Lampinen 48K Antti Perttula 70K JP Juhola 85K Seppo Parkkinen 28K Petteri Laiho 60K Aki Pyysing 68K Jonatan Fors 35K Jani Vilmunen 75K Pekka Ikonen 68K Jussi Vanhanen 30K Kristian Kostiander 46K Roope Tarmi 45K Jan-Mikael Kesänen 60K Juuso Kauppi 12K Jimi Koponen 55K Kasper Mellanen 23K Mikko Ylämäki 100K Veli-Pekka Penttinen 20K Kaisa Suorsa 75K Terno Palmroos 37K Santtu Leinonen 33K Anne Bezdek 16K Ilari Sahamies 33K Ari Varonen 55K Mikael Haapaniemi 75K Ville Jantunen 58K Tommi Lankinen 48K Teemu Kailasvuo 35K Luka Sorainen 37K Aleksi Naski 75K
Unlucky Sevens Posted Thursday 29th February, 2024 at 19:03(UTC+2) by Juhani Tyriseva
Risto Pönniö ja Mairo Tori menivät all in ennen floppia.
Risto
Mairo
Floppi
Turn
River ja Mairon suora oli voitokas. Risto poistui kassan suuntaan, katsotaan tekeekö hän vielä comebackin.
18:42 (UTC+2)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
Pidetäänpä vielä yksi tauko Posted Thursday 29th February, 2024 at 18:42(UTC+2) by Juhani Tyriseva
Erässä 1B on nyt saatu kuusi tasoa pelattua, kaksi jäljellä. Tauon jälkeen huiskaistaan nuokin, ja sitten merkit pussiin.
Näillä näkymin pussittamaan päästään noin 20.45, joten erä 1C saataneen käyntiin melko tarkkaan klo 21.00.
Matte hakemaan uutta vauhtia Posted Thursday 29th February, 2024 at 18:27(UTC+2) by Juhani Tyriseva
Matte Karjalainen ja Ranel Käsi menivät all in ennen floppia.
Matte
Ranel
Floppi
Turn
River ja Matten merkit siirtyivät Ranelin pinoon. Matte puolestaan lähti pohtimaan, tehdäkö re-entry vai ostaa sisään erään 1C.
Rattaat voittavat yhden parin Posted Thursday 29th February, 2024 at 17:53(UTC+2) by Juhani Tyriseva
Sergejs Kacapovs avasi, Teemu Kailasvuo puolusti isoa.
Floppi [6c3d2d) Sergejs löi 2600, maksu.
Turn sököteltiin.
River Sergejs löi 3200, maksu.
Sergejs näytti kärkiparin.
Teemu käänsi näkyviin rattaat ja vei potin.
Toimitukselle menestystä sivuvedossa Posted Thursday 29th February, 2024 at 17:45(UTC+2) by Juhani Tyriseva
Jo perinteeksi muodostuneet allekirjoittaneen ja Jason Glatzerin väliset sivuvedot saatiin vasta tänään vauhtiin. Kohteena oli erän 1B sisäänostojen määrä:
Jason 309
Juhani 352
Kun arvaukset oli saatu paperille, Jason totesi: "Toivon että voitat tämän vedon".
Nyt taululla on jo 359 sisäänostoa. Tappion kärsinyt osapuoli käy seuraavalla tauolla hakemassa baarista oluen kaikille kisaan osallistuneille.
Petterin naulat eivät pärjänneet Posted Thursday 29th February, 2024 at 17:41(UTC+2) by Juhani Tyriseva
Reissatussa potissa floppi oli:
Morten Norland löi 4200, Petteri Laiho reissasi 12K total, Norland all in 25K, maksu.
Petteri
Morten
Turn
River ja Norland tuplasi värillään.
Petterille jäi noin 80K.
17:32 (UTC+2)
Start of Level 7 Blinds: 400/800 Ante: 800
Suomalaispinot tason 5 puolivälissä Posted Thursday 29th February, 2024 at 17:24(UTC+2) by Juhani Tyriseva
Silja Kinnunen 31K John Lundqvist 10K Jani Tuovinen 95K Jari Mähönen 16K Henri Ojala 22K Simo Räikkönen 65K Kyösti Isberg 100K Sauli Haapaniemi 58K Henri Wagner 80K Miro Lehtinen 70K Arto Lehtonen 40K Tomi Arponen 125K Jari Hurri 51K Juuso Wiksten 20K Jyrki Lampinen 30K Antti Perttula 23K JP Juhola 80K Roope Holma 25K Seppo Parkkinen 20K Petteri Laiho 85K Aki Pyysing 36K Jonatan Fors 18K Jani Vilmunen 25K Pekka Ikonen 65K Jussi Vanhanen 58K Konsta Heikkilä 13K Kristian Kostiander 31K Roope Tarmi 75K Matte Karjalainen 22K Jan-Mikael Kesänen 44K Juuso Kauppi 68K Jimi Koponen 20K Kasper Mellanen 22K Mikko Ylämäki 82K Torsti Kettula 22K Veli-Pekka Penttinen 35K Kaisa Suorsa 90K Terno Palmroos 37K Anne Bezdek 25K Juha Kaitanen 33K Ilari Sahamies 35K Henri Tanskanen 28K Ari Varonen 45K Mikael Haapaniemi 10K Ville Jantunen 25K
Noin 10 meikäläistä on tällä hetkellä pudonnutkin. Osa heistä tietysti tulee takaisin tähän erään, osa palaa erään 1C. Ja muutamille yksi yritys saattaa tällä kertaa riittää.
Suomalaisilmeitä päivän alussa Posted Thursday 29th February, 2024 at 16:50(UTC+2) by Juhani Tyriseva
Elias Jalovaara.
Henri Wagner.
Pekka Virtanen.
Anna-Mari Hursti.
Antti Perttula.
16:35 (UTC+2)
Start of Level 6 Blinds: 300/600 Ante: 600
Aleksin kympit olivat lujat Posted Thursday 29th February, 2024 at 16:34(UTC+2) by Juhani Tyriseva
Aleksi Naski ja Sander Lithun menivät all in ennen floppia.
Aleksi
Sander
Floppi
Turn
River ja Aleksin kympit tuottivat hänelle tuplat, hänellä nyt noin 26K.
Juholan poliisivoimat tehokkaina Posted Thursday 29th February, 2024 at 15:56(UTC+2) by Juhani Tyriseva
Riverissä pöydässä oli:
JP Juhola löi 6000, isäntämaan Martjan Romet reissasi 12500 total buttonista, JP miettimään, maksu.
Romet näytti rouvahain.
JP käänsi näkyviin kolmoset, ja vei mukavan potin.
John törmäsi tiilimuuriin Posted Thursday 29th February, 2024 at 15:46(UTC+2) by Juhani Tyriseva
John Lundqvist ja Yana Gorskaya reissatussa potissa, floppi oli:
John löi 1500, maksu.
Turn John löi 3500, maksu.
River John löi 6400, Yana mietti hetken ja meni all in. John miettimään, kippi.
"Näytä neloset", kannusti yksi pelaajista. Hieman vastahakoisesti Yana näytti saletit.
Suomalaiset tason 4 alussa Posted Thursday 29th February, 2024 at 15:24(UTC+2) by Juhani Tyriseva
Suomalaiset:
Elias Jalovaara 12K Silja Kinnunen 16K John Lundqvist 33K Mikko Saarremaa 29K Noel Suomalainen 20K Verneri Häkkinen 33K Anna-Mari Hursti 32K Jani Tuovinen 53K Jari Mähönen 28K Henri Ojala 24K Simo Räikkönen 44K Kyösti Isberg 35K Sauli Haapaniemi 20K Henri Wagner 105K Arto Lehtonen 68K Tomi Arponen 60K Jari Hurri 26K Juuso Wiksten 35K Jyrki Lampinen 27K Antti Perttula 32K JP Juhola 42K Roope Holma 25K Seppo Parkkinen 20K Petteri Laiho 36K Aki Pyysing 44K Niklas Vakkuri 27K Jonatan Fors 23K Jani Vilmunen 24K Jussi Vanhanen 55K Konsta Heikkilä 25K Kristian Kostiander 35K Roope Tarmi 35K Mika Surakka 22K Matte Karjalainen 37K Jan-Mikael Kesänen 36K Markus Ylänne 30K Juuso Kauppi 26K Jimi Koponen 18K Kasper Mellanen 36K Mikko Ylämäki 38K Torsti Kettula 27K Veli-Pekka Penttinen 38K
15:23 (UTC+2)
Start of Level 5 Blinds: 200/500 Ante: 500
Seppo tarkisti turhaan Posted Thursday 29th February, 2024 at 14:49(UTC+2) by Juhani Tyriseva
Riverissä pöydässä oli:
Mihkel Vitsur löi 4K, Seppo Parkkinen miettimään, maksu.
Mihkel näytti ja Seppo kippasi.
"Toivoin, että siellä olisi AK tai AQ", pohti Seppo.
Henri vei Hannan merkit Posted Thursday 29th February, 2024 at 14:41(UTC+2) by Juhani Tyriseva
Henri Wagner avasi, Hanna Heinlo reissasi takaa, maksu.
Floppi Hanna löi jatkolyönnin, maksu.
Turn Hanna löi, Henri checkreissasi, Hanna all in, maksu.
Hanna
Henri
River ja Henrin nelossetti lähetti Hannan miettimään re-entryä.
Aki haki uusia ammuksia Posted Thursday 29th February, 2024 at 14:30(UTC+2) by Juhani Tyriseva
Aki Pyysingin päivä alkoi vähän nihkeästi. "Ensin en osannut kipata kättäni riverissä, vaikka oli pitänyt. Vihu löi pelokkaan näköisenä boardiin ja sieltä sitten tuli kurkattua.
Tuon jälkeen löysin kädelläni vastaan josta ei ohi menty, joten ei muuta kuin kättä taskuun ja iloista ilmettä", virnisteli Aki.
14:17 (UTC+2)
Start of Level 3 Blinds: 100/300 Ante: 300
Suomalaisten chip countit tason 2 lopulla Posted Thursday 29th February, 2024 at 13:56(UTC+2) by Juhani Tyriseva
Suomalaiset tason 2 lopussa:
Elias Jalovaara 20K Silja Kinnunen 20K John Lundqvist 32K Mikko Saarremaa 26K Noel Suomalainen 9K Verneri Häkkinen 30K Anna-Mari Hursti 16K Jani Tuovinen 32K Jari Mähönen 24K Henri Ojala 28K Simo Räikkönen 50K Kyösti Isberg 29K Sauli Haapaniemi 28K Henri Wagner 34K Pekka Virtanen 27K Arto Lehtonen 57K Tomi Arponen 35K Jari Hurri 30K Juuso Wiksten 31K Jyrki Lampinen 23K Antti Perttula 25K JP Juhola 33K Rasmus Lundström 25K Roope Holma 34K Seppo Parkkinen 30K Petteri Laiho 37K Aki Pyysing 17K Niklas Vakkuri 32K Jonatan Fors 24K Jani Vilmunen 32K Jussi Vanhanen 33K Konsta Heikkilä 36K
Yksi huone nopealle Posted Thursday 29th February, 2024 at 13:34(UTC+2) by Juhani Tyriseva
"Hilton on täyteen bookattu, mutta loppuviikoksi minulla on peukalon alla yksi huone", kertoi TD Teresa Nousiainen.
Tässä nopeat syövät hitaat, jos siis olet tulossa ja ilman huonetta, ota nyt heti yhteys Teresaan.
Suomalaisten pinot erästä 1A Posted Thursday 29th February, 2024 at 13:27(UTC+2) by Juhani Tyriseva
Tekniikka on ihmeellistä, olen näköjään (kiitos tarkkaavaiselle lukijalle) onnistunut ampumaan eilisen chip countin erästä 1A bittien taivaaseen.
87/238 pelaajaa siis pelasi jatkopaikan. Tanskalais-Liettualainen Christian Ryssgaard johtaa 304K pinollaan. Toivotaan että Christian ei huomenna nuku pommiin.
Suomalaisten pinot:
Roni Berg 142K Ville Mesiranta 138K Jarmo Salonen 107K Sebastian Wahl 103K Mathias Siljander 79K Jarkko Suokas 78K Petteri Miettinen 67K Joni Liimatta 65K Matias Arosuo 64K Matias Knaapinen 60K Jussi Mattila 59K Tomi Rissanen 57K Touko Berndtson 52K Tapio Aaltonen 52K Samuli Hietala 47K Juha Elo 20K
Mukana olevat suomalaiset Posted Thursday 29th February, 2024 at 13:14(UTC+2) by Juhani Tyriseva
Suomalaisia mukana tänään:
Tomi Arponen Sauli Haapaniemi Konsta Heikkilä Anna-Mari Hursti Elias Jalovaara Silja Kinnunen Jyrki Lampinen Arto Lehtonen John Lundqvist Jari Mähönen Henri Ojala Antti Perttula Mikko Saarremaa Noel Suomalainen Pekka Virtanen Henri Wagner Juuso Wiksten
Nyt on neljä pelaajaa jo menettänyt koko pinonsa, joten re-entrysuunnitelmia tehdään. Meikäläisiä ei kassalle ole vielä joutunut.
13:03 (UTC+2)
Start of Level 2 Blinds: 100/200 Ante: 200
Erä 1B tulee olemaan todella suuri Posted Thursday 29th February, 2024 at 12:29(UTC+2) by Juhani Tyriseva
Erässä 1B tullaan näkemään vauhtia ja vaarallisia tilanteita, sen tietää jo nyt. Peliä on nyt pelattu 30 minuuttia ja salissa on 126 pelaajaa!
Kukaan ei ole ihme kyllä vielä pudonnut.
Mitäs kaikkea muuta voi tänään pelata? Posted Thursday 29th February, 2024 at 12:15(UTC+2) by Juhani Tyriseva
Päivän ohjelma:
Klo 12.00 1.100€ NLH Main Event 1B Klo 14.00 150€ Olybet Flip&Go to Mystery Bounty Klo 15.00 80€ NLH Satellite to Main Event 1C (5 Guaranteed) Klo 17.00 250€ NLH Klo 19.00 350€ PLO4/5 Progressive Bounty Klo 21.00 1.100€ NLH Main Event 1C Klo 21.30 350€ NLH 6 Max Klo 23.00 150€ NLH Satellite to 5.000€ NLH Highroller (3 Guaranteed)
Päivän kulku on selkeä Posted Thursday 29th February, 2024 at 12:08(UTC+2) by Juhani Tyriseva
Päivän kulku on todella selkeä. Alkupino on 30.000 ja tasot tunnin mittaisia. Ensimmäinen taso on bb ante 100, blindit 100/100. Kahdeksan tasoa pelataan, viimeinen taso on bb ante 1000, blindit 500/1000.
Aina kahden tunnin jälkeen pidetään 15 minuutin tauko. Näin erä 1B päättyy noin klo 21.00, jos mitään isompia viivytyksiä ei matkalle satu.
Pä
Shuffle Up and Deal! Posted Thursday 29th February, 2024 at 12:03(UTC+2) by Juhani Tyriseva
Kings of Tallinn turnausviikon pääturnauksen erä 1B alkaa nyt. 80 pelaajaa on jo nyt salissa ja lisää tulee tasaisena virtana. Oletus on, että tämä erä 1B on kolmesta aloituserästä selvästi suurin.
Toimitukselle tämä päivä on selkeä, seurataan aloituserä 1B ja sitten siirrytään melko suoraan erään 1C.
Pysykää kanavalla!
Paljon mielenkiintoista seurattavaa siis luvassa, pysykää kanavalla!
11:59 (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.