0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0072 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/1B/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.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.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.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0034 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` = 'summer_showdown_main_2023'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '75'
AND `published` = 1
0.0287 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` = '83'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '85'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '86'
AND `published` = 1
0.0280 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '90'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '92'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
AND `name` = '1B'
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '83'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 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` = '83'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3870'
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` = '3866'
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` = '3862'
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` = '3858'
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` = '3857'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3856'
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` = '3852'
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` = '3849'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3847'
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` = '3846'
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` = '3845'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3843'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3840'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3838'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3835'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3831'
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` = '3830'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3828'
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` = '3825'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3823'
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` = '3822'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3820'
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` = '3816'
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` = '3814'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3811'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3809'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3808'
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` = '3807'
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` = '3805'
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` = '3803'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3800'
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` = '3799'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3795'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3790'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3789'
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` = '3788'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '83'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '83'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3870'
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` = '3866'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3862'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3858'
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` = '3857'
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` = '3856'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3852'
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` = '3849'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3847'
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` = '3846'
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` = '3845'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3843'
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` = '3840'
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` = '3838'
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` = '3835'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3831'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3830'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3828'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3825'
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` = '3823'
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` = '3822'
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` = '3820'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3816'
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` = '3814'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3811'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3809'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3808'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3807'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3805'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3803'
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` = '3800'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3799'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3795'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3790'
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` = '3789'
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` = '3788'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '92'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
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.
End-of-Day 1b Chip Counts Posted Thursday 27th July, 2023 at 20:08(UTC+0) by Jason Glatzer
Player
Chips
Big Blinds
Vlads Dolgilevics
264,500
220
Kalle Parkkinen
218,100
182
Kaspar Laursoo
208,700
174
Mauri Dorbek
207,400
173
Markku Koplimaa
160,500
134
Nick Penning
157,400
131
Michailas Miserkejevas
157,100
131
Igor Pihela Jr.
149,100
124
Kristaps Renga
134,400
112
Anders Auset
131,400
110
Kristaps Deksnis
130,400
109
Kaspars Kalnozols
127,900
107
Keito Kaljulaid
125,400
105
Ville Konttinen
111,400
93
Jussi Mattila
110,500
92
Daniel Jullumstro
105,700
88
Ilya Nikiforov
96,900
81
Espen Sandvik
92,000
77
Jari Karkkainen
89,000
74
Kasparas Klezys
88,100
73
Sten Talviste
87,900
73
Olli Muukkonen
84,500
70
Ingus Arajs
83,900
70
Sami Pulliainen
82,000
68
Ville Pohjalainen
81,900
68
Christian Steinbo
81,000
68
Harri Seppa
80,900
67
Niko Petro
80,100
67
Sebastian Wahl
78,000
65
Jaana Kindsigo
75,900
63
Ville-Matti Keranen
74,300
62
Vygerdas Jonikas
71,800
60
Roberto Caprio
69,800
58
Jari Porkka
68,500
57
Teemu Leppalahti
67,300
56
Janne Jarvinen
66,500
55
Kaido Koorits
64,400
54
Jan Svendsen
62,000
52
Erik Borkvik
61,200
51
Anders Christiansen
58,900
49
Dmitrijs Kornevs
58,900
49
Tarjei Forus
58,200
49
Liutauras Armanavicius
57,400
48
Fatih Gulgonul
55,200
46
Hein Haraldsen
53,800
45
Andrei Mjagkov
53,400
45
Aleksandr Kuperman
51,700
43
Markus Isosalo
50,900
42
Aki Pyysing
49,800
42
Roni Berg
49,500
41
Peter Bumba
49,300
41
Herli Olop
49,300
41
Kevin Karenius
48,100
40
Amid Zulkowitz
47,500
40
Kaidar Viikman
46,700
39
Samuli Hietala
45,700
38
Thor Morstol
45,300
38
Vaclav Hlasek
45,100
38
Rafael Gancedo
44,400
37
Ramunas Mika
42,600
36
Petteri Miettinen
42,500
35
Teemu Toikkanen
42,500
35
Christian Arstad
42,200
35
Tero Kilkanen
41,000
34
Paul Koppe
41,000
34
Konstantin Arber
40,000
33
Roope Tarmi
40,000
33
Julius Kettunen
38,100
32
Joonas Helin
38,000
32
Jordi Baixas
37,900
32
Raffael Wadl
37,900
32
Mario Colavita
37,800
32
Steponas Venckus
36,900
31
Julian Herold
34,300
29
Maksim Petrov
32,500
27
Aleksejs Gusevs
31,500
26
Priit Vanem
30,000
25
Jorgen Jakobsen
29,700
25
Henrik Veldhoen
28,900
24
Kasper Mellanen
28,800
24
Mart Tammoja
28,400
24
Jorn Martinsen
27,400
23
Petteri Laiho
24,200
20
Tomas Pinkevicius
22,900
19
Sergei Oganesjan
22,300
19
Pasi Laihinen
21,700
18
Tarmo Tammel
20,200
17
Mikael Haapaniemi
19,200
16
Kaius Kiidli
18,800
16
Thomas Haverstad
14,500
12
Final Three Hands Posted Thursday 27th July, 2023 at 18:36(UTC+0) by Jason Glatzer
Level 8: 500/1,000 (1,000) Entries: 96/205
The clock stopped and the floor announced the final three hands for the day. We will update the chip counts shortly after the action has concluded along with a short recap of the day.
Tomorrow's coverage will be sporadic as we will need to focus on the live-stream for the inaugural €5,000 High Roller. We will do our best to get a few updates but the blog will resume in full on Day 3 and Day 4 until a winner is crowned.
Parkkinen Soars With Rockets Posted Thursday 27th July, 2023 at 18:15(UTC+0) by Jason Glatzer
Level 8: 500/1,000 (1,000) Entries: 97/205
Fireworks erupted at Table 12 with Kalle Parkkinen (pictured below) now sitting with a massive pile of chips. The hand began with Pasi Sormunen jamming for 22,300 from middle position. The action paused on Parkkinen who opted to call from the hijack. Stein Borkvik three-bet jammed for 93,300 from the button and Parkkinen, who had his opponent covered, snap-called.
Pasi Sormunen: Stein Borkvik: Kalle Parkkinen:
What a spot for pocket rockets. Right near the end of Day 2 with two other players committing their stacks and Parkkinen a 90% favorite to win it all.
No drama happened on the board for Parkkinen to dispatch his two opponents in one hand.
Player
Chips
Progress
Kalle Parkkinen
210,000
180,000
Stein Borkvik
0
0
Pasi Sormunen
0
0
Final Day 1b Blind Level Begins Posted Thursday 27th July, 2023 at 17:51(UTC+0) by Jason Glatzer
The final blind level of Day 1b has kicked off with blinds at 500/1,000 along with a big blind ante of 1,000. The clock will stop with just a few minutes remaining and players will be informed how many hands will be played out at each table before surviving players bag their chips for tomorrow's Day 2.
17:50 (UTC+0)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
Straight Not Enough for Hatipoglu Posted Thursday 27th July, 2023 at 17:50(UTC+0) by Jason Glatzer
Level 7: 400/800 (800) Entries: 107/204
There wasn't a boatload of chips in the pot when Julius Kettunen bet 2,300 with the on the board after the turn. Bahadir Hatipoglu jammed over the top for about half a starting stack and Kettunen snap-called.
Bahadir Hatipolgu: Julius Kettunen:
Despite turning a straight, Hatipoglu was drawing dead to Kettunen's full house. The blank river completed the board and Hatipoglu was on the rail for the third time during Day 1b.
Fortunately, this isn't baseball. So it isn't three strikes and you are out. He can hop back in not only during the rest of Day 1b but also during tonight's Day 1c which kicks off at 9 p.m. If this doesn't suit his tastes, he also can pop back into the action on Friday's Day 2 with late registration still open for the first two levels.
Player
Chips
Progress
Julius Kettunen
60,000
30,000
Bahadir Hatipoglu
0
0
Laursoo Wakes Up With Cowboys Posted Thursday 27th July, 2023 at 17:16(UTC+0) by Jason Glatzer
Level 7: 400/800 (800) Entries: 118/199
There are nearly 200 entries in the Day 1b field surpassing the 188 entries attracted during yesterday's Day 1a. Jukka Ylitalo just accounted for one of the new entries as he re-entered after losing his stack on the following hand.
Ylitalo opened and two players called. Kaspar Laursoo three-bet from the big blind and Ylitalo let it rip for his stack of more than 60,000. The two players that originally called, snap-folded and Laursoo wasted no time in calling in what became a massive pot.
Jukka Ylitalo: Kaspar Laursoo:
It was bad timing for Ylitalo to jam 75 big blinds. He would have likely gotten a lot of hands to fold but Laursoo was going nowhere with his cowboys.
Despite showing tons of heart with the jam, Ylitalo got nowhere on the board and re-entered for his third bullet for the day after hitting the rail.
Player
Chips
Progress
Kaspar Laursoo
200,000
170,000
Jukka Ylitalo
30,000
0
16:55 (UTC+0)
Start of Level 7 Blinds: 400/800 Ante: 800
Break Time! Posted Thursday 27th July, 2023 at 16:30(UTC+0) by Jason Glatzer
Players are on their final break of Day 1b.
Berg Dusts Off His Short Stack Posted Thursday 27th July, 2023 at 16:30(UTC+0) by Jason Glatzer
Level 6: 300/600 (600) Entries: 125/195
Roni Berg three-bet jammed his last 6,000 and was called by Jonatan Fors, who opened up the action with a short stack from late position.
Roni Berg: Jonatan Fors:
Berg pulled out ahead after his five connected with the flop and was still ahead after the turn. However, the came raining down on the river for Fors to pull ahead and Berg will need to re-enter if he wishes to have a shot at becoming the latest Kings of Tallinn Summer Showdown Main Event champion.
Player
Chips
Progress
Jonatan Fors
25,000
22,000
Roni Berg
0
0
Mattila Lays Down Two Pair Posted Thursday 27th July, 2023 at 16:17(UTC+0) by Jason Glatzer
Level 6: 300/600 (600) Entries: 127/193
Jussi Mattila (pictured below) was doing "Pot-Jussi" things and built up a nice stack on Day 1b. He lost a little of it in the following hand but not much.
Four players were still in the hand in a bloated pot of around 18,000 with the on the board after the turn. Both Jukka Ylitalo and Tarieli Ustiashvili checked. Mattila bet 3,400. Pasi Sormunen raised to 7,800 Ylitalo and Ustiashvili folded.
Mattila folded a second later and immediately tabled the to the shock of Sormunen.
"I laid that down because it was you," said Mattila implying that his opponent always has it there.
"You play much differently than I remember," replied Sormunen.
Player
Chips
Progress
Jussi Mattila
120,000
90,000
Pasi Sormunen
55,000
25,000
Muukkonen Shows One Posted Thursday 27th July, 2023 at 15:57(UTC+0) by Jason Glatzer
Level 6: 300/600 (600) Entries: 134/190
Olli Muukkonen busted one bullet today but is off to a better start on the second bullet. He opened from early position for 1,200. Guillermo Cifuentes three-bet to 3,500 from middle position. The action paused on Muukkonen who eventually called to see the flop.
Cifuentes checked before Muukkonen bet 2,000. Cifuentes went into the tank for a couple of minutes and checked his cards multiple times before he over-jammed the pot for close to a starting stack. Cifuentes snap-folded and Muukkonen took down the pot.
"Show one, show one," said Jussi "Potti-Jussi" Mattila, who often attends major poker festivals in Tallinn.
Muukkonen quickly obliged and turned over the .
"Not that one," said someone else at the table.
We won't ever know whether it was a good fold or not for Cifuentes as we don't know what he had either. What we do know, is that he is off to a great start despite losing this smaller pot with 70,000 in chips.
Player
Chips
Progress
Guillermo Cifuentes
70,000
40,000
Olli Muukkonen
35,000
5,000
Jussi Mattila
30,000
0
15:37 (UTC+0)
Start of Level 6 Blinds: 300/600 Ante: 600
Dolgilevics Leading Day 1b Posted Thursday 27th July, 2023 at 15:24(UTC+0) by Jason Glatzer
Level 5: 200/500 (500) Entries: 143/172
Latvia's Vlads Dolgilevics appears to have the early chip lead on Day 1b with about 165,000 in chips.
Dolgilevics shared a hand that recently took place on Table 14. He already had a stack when he opened the cutoff with . The big blind defended and Dolgilevics check-called a bet of around 80% of the pot on the flop.
The big blind fired out for 80% after the paired the board on the turn. Dolgilevics shared he bet 2.5x and his opponent jammed for about 30,000 total. Dolgilevics called and his opponent tabled for an open-ended straight draw with no flush draw.
The blank completed the board on the river and it was happy days for Dolgilevics.
Player
Chips
Progress
Vlads Dolgilevics
165,000
135,000
Bumba Folds Top Pair Posted Thursday 27th July, 2023 at 14:49(UTC+0) by Jason Glatzer
Level 5: 200/500 (500) Entries: 143/172
Massimo Altieri opened for 1,100 from the hijack. Peter Bumba bumped the pot up to 3,100 from the button and Altieri called.
Altieri check-called a bet of 2,500 on the flop before both players checked the turn. Altieri bet 9,000 on the river. Bumba went into the tank for a couple of minutes.
Eventually, Bumba folded but not before showing he had at least top pair after turning the face-up.
Player
Chips
Progress
Massimo Altieri
55,000
25,000
Peter Bumba
38,000
8,000
14:34 (UTC+0)
Start of Level 5 Blinds: 200/500 Ante: 500
Break Time Posted Thursday 27th July, 2023 at 14:23(UTC+0) by Jason Glatzer
Players are on a 15-minute break. Some are doing some more pineapple flips in the €150 GGPoker Flip&Go Mystery Bounty, while others heading to the OlyBet Bar & Grill pop-up restaurant.
We just checked out the pop-up restaurant, and it was pasta with tasty chorizo sauce and salad. It was both light and full of flavor, two qualities great for poker players and the media crew alike. Bon appetit!
Mika Leaves Muller With Crumbs Posted Thursday 27th July, 2023 at 14:03(UTC+0) by Jason Glatzer
Level 4: 200/400 (400) Entries: 137/154
A pot grew to 15,000 preflop between Ramunas Mika and Martin Muller when Mika bet 5,500 on the flop. Muller min-clicked it back to 11,000 and Mika called.
Both players checked the turn and Mika checked again on the river. Muller jammed for slightly more than the 16,000 remaining in his opponent's stack. Mika snap-called and it didn't end well for Muller as he was bluffing with . Mika was more than happy to double with his and Muller will need to re-enter in order to have a chance to run deep assuming he doesn't spin up his crumbs.
Player
Chips
Progress
Ramunas Mika
70,000
40,000
Martin Muller
600
29,400
Ustiashvili Felts Helin Posted Thursday 27th July, 2023 at 13:41(UTC+0) by Jason Glatzer
Level 4: 200/400 (400) Entries: 129/144
Tarieli Ustiashvili bet 4,000 into a pot of slightly more with the on the board on the river. Joonas Helin jammed for about 20,000 more and Ustiashvili tanked for several minutes.
He eventually decided his hand was too strong to lay down and called. Helin turned over the and got his hand caught in the cookie jar with Ustiashvili calling with the for the straight.
Player
Chips
Progress
Tarieli Ustiashvili
70,000
40,000
Joonas Helin
0
0
Cowboys for Haverstad Posted Thursday 27th July, 2023 at 13:33(UTC+0) by Jason Glatzer
Level 4: 200/400 (400) Entries: 122/138
We went to check out if anything was happening with GGPoker Ambassador Anatoly Filatov, who has called Tallinn his home for a number of years. The short answer to this question was not much is happening as he is down to 20,000 in chips.
However, the trip wasn't wasted as we did witness a hand at his table between Estonian resident Anthony Kauzloric and Thomas Haverstad.
There was around 8,000 in the pot in a three-bet pot when Haverstad continued from the small blind for 2,000 on the flop. Kauzloric called and more action came on the turn. Haverstad checked before he called a bet of 4,000. Both players checked the river.
Haverstad tabled and his cowboys held on an ace-high board with Kauzloric tossing his hand into the muck.
Player
Chips
Progress
Anthony Kauzloric
60,000
30,000
Thomas Haverstad
50,000
50,000
Anatoly Filatov
20,000
10,000
13:28 (UTC+0)
Start of Level 4 Blinds: 200/400 Ante: 400
"You Call the River?" Posted Thursday 27th July, 2023 at 13:20(UTC+0) by Jason Glatzer
Level 3: 100/300 (300) Entries: 119/130
Roberts Rumba fired out for 6,100 into a pot of around 15,000 with the on the board after the turn. Anders Christiansen went into the tank for a short time before he called.
Both players checked the river and Rumba turned over the for two pair. Christiansen won the pot with a better two pair after tabling the .
"You call river?" asked Rumba to Christiansen if he was facing a jam for his remaining 10,000 in chips.
Christiansen grinned and then came a small laugh.
"I don't know," Christiansen eventually replied. "It was a shitty spot."
Player
Chips
Progress
Anders Christiansen
49,000
19,000
Roberts Rumba
10,000
20,000
Good Start for Olop Posted Thursday 27th July, 2023 at 13:00(UTC+0) by Jason Glatzer
Level 3: 100/300 (300) Entries: 107/116
Back when this author was still in diapers was breaking into the industry, Herli Olop was always doing his best to help make the events in Estonia as amazing as he could for the players and staff. Olop is still around every festival but now as a poker player.
He's off to a good start and just stacked Jari Hurri to catapult his stack to more than double the starting stack.
He shared that Martin Haidberg opened and was called by Hurri and and Olop before the flop was checked around. Olop then shared that he fired out a small bet on the turn which got Haidberg to fold.
Hurri called and what he thought was a good river in the turned out to be a disaster. Olop bet 8,000 into a built up pot of a bit more. Hurri jammed and Olop snapped him off.
Hurri held the for Broadway. However, this wasn't good enough as Olop flopped the absolute goods with to win the hand with a full house.
Player
Chips
Progress
Herli Olop
60,000
30,000
Jari Hurri
0
0
Perhaps Bielskis Gave Tammel Too Much Credit Posted Thursday 27th July, 2023 at 12:43(UTC+0) by Jason Glatzer
Level 3: 100/300 (300) Entries: 102/107
Tarmo Tammel jammed for 18,500 into a pot of what appeared to be slightly less with the on the board before Andrius Bielskis (pictured below) went into the tank.
A few minutes went by and you were visibly able to watch the wheels of thought go through Bielskis's head.
"OK, I will give you credit," Bielskis said as he folded his hand.
Bielskis showed the for the top pair. While this was a very strong hand, Tammel could have had this beat if he wasn't on a draw.
"I will only do this once," Tammel said as he tabled the . He had a monster draw on the turn with an open-ended straight draw, a flush draw, and his king still being live. As it turned out, it was a very nice bluff as it did get Bielskis make a huge laydown.
Bielskis is well-known in the Baltics as one of the best players in Lithuania and won a massive prize a few years back in the Sunday Millions Anniversary event. He also founded the "Pliusine Sesija" brand that boasts an amazing podcast if you can understand Lithuanian.
Player
Chips
Progress
Tarmo Tammel
40,000
8,000
Andrius Bielskis
16,000
14,000
12:17 (UTC+0)
Start of Level 3 Blinds: 100/300 Ante: 300
Break Time Posted Thursday 27th July, 2023 at 12:01(UTC+0) by Jason Glatzer
Level 2: 100/200 (200) Entries: 83/86
Players are on their first 15-minute break. More pineapple flips for the €150 GGPoker Flip&Go Mystery Bounty. There will be €10,000 added by GGPoker and the top mystery bounty prize will be at least €5,000 when Day 2 takes place on Saturday.
Meanwhile, Oskars Gailums, Olli Muukkonen, and Bahadir Hatipoglu all hit the rail during the second half of Level 2. This doesn't mean they won't have a chance to bag chips during Day 1b, as all three players already re-entered back into the action.
Player
Chips
Progress
Bahadir Hatipoglu
30,000
0
Olli Muukkonen
30,000
0
Oskars Gailums
30,000
0
Meet Yesterday's €555 Championship Winner Maikel Homin Posted Thursday 27th July, 2023 at 11:49(UTC+0) by Jason Glatzer
Kings of Tallinn Summer Showdown host Evely Pihela interviewed yesterday's €555 Championship winner Maikel Homin.
Homin dazzled his opponents and spectators alike with an amazing performance. Check out what he had to say in the video below:
Team Competition Registration Closing Soon Posted Thursday 27th July, 2023 at 11:46(UTC+0) by Jason Glatzer
The Kings of Tallinn Summer Showdown tournament director Teresa Nousiainen just announced that registration will close after the first break for the Team Competition. So be sure to get your teams together before its too late. Please see one of the staff if you need assistance forming your team.
"I Didn't Call Because You Are a Nice Guy" Posted Thursday 27th July, 2023 at 11:40(UTC+0) by Jason Glatzer
Level 2: 100/200 (200) Entries: 69/69
Lithuanian poker player Irmantas Bzeskis lives in Norway and since last year we have seen him around sporting a variety of NBA jerseys while walking around and playing. Yesterday was Vince Carter day and today is also an old-school look with the Sacramento Kings "Williams" Jersey with a 55 on the back. Old-school NBA followers will know that this is Jason "White Chocolate" Williams, who had his moments back in the day dazzling the crowds with his impressive passes.
That being said, it sounds like Bzeskis just made a decent laydown. He has been having fun with the other players at the table including Lasse Kolari. Kolari fired out for 6,500 into a pot of around 10,000 with the on the board after the river. Bzeskis tanked for a couple of minutes before he folded. Risto Parnat quickly folded after that.
Bzeskis shared he laid down for top two pair.
"I didn't call because you are a nice guy," Bzeskis said to Kolari.
Kolari showed he was betting for value as he tabled the before collecting the pot.
Player
Chips
Progress
Lasse Kolari
45,000
15,000
Irmantas Bzeskis
30,000
0
Top Two Pair for Stiedl Posted Thursday 27th July, 2023 at 11:33(UTC+0) by Jason Glatzer
Level 2: 100/200 (200) Entries: 66/66
Tomas Pinkevicius fired out for 2,500 into a pot of around 4,000 with the on the board after the turn. Yvonne Stiedl called to see the river. Pinkevicius checked before Stiedl fired out for 4,000. Pinkevicius tanked for a couple of minutes before he called.
Stiedl turned over the for the top two pair. This was good enough as she took down the pot after Pinkevicius mucked his cards.
Player
Chips
Progress
Yvonne Stiedl
40,000
10,000
Tomas Pinkevicius
31,000
1,000
11:04 (UTC+0)
Start of Level 2 Blinds: 100/200 Ante: 200
Auset First to Double on Day 1b Posted Thursday 27th July, 2023 at 11:01(UTC+0) by Jason Glatzer
Level 1: 100/100 (100) Entries: 52/52
A bit of a cooler took place at Table 2 for Jonatan Fors but it isn't likely that Anders Auset (pictured below) is complaining one bit at all.
The hand began to build up preflop and it all started with Hein Haraldsen opening for 300 from under the gun. Auset called from one seat over and Triinu Ammussar did the same from the small blind before Fors three-bet to 1,500 from the big blind. Only Auset called with the other two players folding.
Fors fired out for 2,800 on the flop. Auset called and he called a bet of 3,000 after the turn. The river paired the board. You will see why this wasn't the best of cards for Fors soon enough. Fors bet 12,500. Auset tanked for a few moments before jamming over the top for about 18,000. Fors snap-called only to get some bad news.
Auset turned over the for a full house. Fors pushed his cards facedown before the dealer tabled his hand showing the for rivered trips.
Player
Chips
Progress
Anders Auset
60,000
30,000
Jonatan Fors
3,000
27,000
Early Two Pair for Tammel Posted Thursday 27th July, 2023 at 10:33(UTC+0) by Jason Glatzer
Level 1: 100/100 (100) Entries: 40/40
The Day 1b field has grown to 40 entries with more players continuously filing into the venue including local hero Tarmo Tammel.
It has been mostly small ball early on, including the following hand with Tammel where he bet 1,500 into a pot of 2,000 with the when he was first to act from the big blind. Kristaps Renga quickly called and mucked his cards after Tammel showed the for the top two pair.
Player
Chips
Progress
Tarmo Tammel
32,000
2,000
Kristaps Renga
28,000
2,000
Cards in the Air Posted Thursday 27th July, 2023 at 10:08(UTC+0) by Jason Glatzer
Level 1: 100/100 (100) Entries: 18/18
The cards are in the air to start Day 1a. Players will battle for eight one-hour blind levels until surviving players resume action for Day 2 on Friday at 12 p.m.
Gytis Bernatavicius, Tero Kilkanen, Maksim Petrov, Kristaps Renga, and Oskars Gailums are among the players opting to play from the start.
Player
Chips
Progress
Oskars Gailums
30,000
0
Kristaps Renga
30,000
0
Maksim Petrov
30,000
0
Tero Kilkanen
30,000
0
Gytis Bernatavicius
30,000
0
Welcome to Day 1b of the Kings of Tallinn Summer Showdown Main Event Posted Thursday 27th July, 2023 at 08:51(UTC+0) by Jason Glatzer
Get ready for some fun and excitement as poker players battle for what promises to be a massive prize pool in the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event at Olympic Park Casino and the Hilton Tallinn Park.
The event provides an amazing structure with hour-long blind levels throughout the event providing players plenty of opportunities to showcase their skills. The only exception to this rule is the Day 1c flight kicking off at 9 p.m. This isn't exactly a turbo flight either but it does play twice as fast with 30-minute blind levels.
Players begin each opening flight with a deep stack of 30,000 in chips for 300 big blinds and can re-enter until their heart is content until late registration closes after the second blind level of Friday's Day 2. Surviving players will battle it out for three more days until a winner is crowned on Sunday.
Finnish poker powerhouse Feras Abid found himself in a familiar place in Tallinn as he bagged the Day 1a chip lead with 221,000. Day 1a attracted 188 players with 75 players advancing and we expect the Day 1b field to eclipse these figures. In other words, we can comfortably say that this will easily grow into the largest Main Event of the Kings of Tallinn Summer Showdown history.
Our coverage will focus today on Day 1c starting when the cards are in the air and will then continue throughout the week with detailed reports from Friday until a winner is crowned on Sunday.
Best of luck to everyone playing and for those that aren't, sit back, relax, and enjoy the coverage.
08:40 (UTC+0)
Day 1B of Kings of Tallinn Summer Showdown 2023 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.
board for Parkkinen to dispatch his two opponents in one hand.
on the board after the turn. Bahadir Hatipoglu jammed over the top for about half a starting stack and Kettunen snap-called.
river completed the board and Hatipoglu was on the rail for the third time during Day 1b.
flop and was still ahead after the 
turn. However, the 
on the board after the turn. Both Jukka Ylitalo and Tarieli Ustiashvili checked. Mattila bet 3,400. Pasi Sormunen raised to 7,800 Ylitalo and Ustiashvili folded. 
to the shock of Sormunen.
flop.
. The big blind defended and Dolgilevics check-called a bet of around 80% of the pot on the 
for an open-ended straight draw with no flush draw.
completed the board on the river and it was happy days for Dolgilevics.
turn. Altieri bet 9,000 on the 
. Mika was more than happy to double with his 
and got his hand caught in the cookie jar with Ustiashvili calling with the 
flop. Kauzloric called and more action came on the 
flop was checked around. Olop then shared that he fired out a small bet on the turn which got Haidberg to fold.
turned out to be a disaster. Olop bet 8,000 into a built up pot of a bit more. Hurri jammed and Olop snapped him off.
on the board after the river. Bzeskis tanked for a couple of minutes before he folded. Risto Parnat quickly folded after that.
on the board after the turn. Yvonne Stiedl called to see the 
£ GBP
$ USD
€ EUR
