0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0082 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_kot_championship_eng/1C/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.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.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.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.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.0037 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` = '2023_kot_championship_eng'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '11'
0.0274 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` = '37'
AND `published` = 1
0.0273 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` = '38'
AND `published` = 1
0.0271 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` = '39'
AND `published` = 1
0.0269 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` = '48'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '11'
AND `name` = '1C'
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '39'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 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` = '39'
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` = '1925'
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` = '1909'
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` = '1907'
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` = '1906'
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` = '1904'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1903'
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` = '1902'
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` = '1899'
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` = '1898'
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` = '1895'
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` = '1893'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1891'
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` = '1890'
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` = '1888'
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` = '1887'
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` = '1886'
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` = '1885'
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` = '1884'
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` = '1883'
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` = '1880'
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` = '1878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1876'
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` = '1875'
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` = '1872'
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` = '1871'
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` = '1868'
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` = '1867'
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` = '1864'
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` = '1862'
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` = '1860'
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` = '1857'
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` = '1856'
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` = '1855'
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` = '1852'
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` = '1851'
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` = '1850'
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` = '1847'
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` = '1846'
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` = '1845'
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` = '1843'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1840'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1839'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1837'
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` = '1836'
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` = '1833'
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` = '1832'
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` = '1830'
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` = '1829'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1827'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1824'
ORDER BY `chip_change` DESC, `busted` ASC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1823'
ORDER BY `chip_change` DESC, `busted` ASC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1822'
ORDER BY `chip_change` DESC, `busted` ASC
0.0115 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '37'
ORDER BY `busted` ASC, `current_chips` DESC
0.0089 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '39'
ORDER BY `busted` ASC, `current_chips` DESC
0.0056 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` = '39'
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` = '1925'
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` = '1909'
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` = '1907'
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` = '1906'
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` = '1904'
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` = '1903'
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` = '1902'
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` = '1899'
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` = '1898'
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` = '1895'
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` = '1893'
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` = '1891'
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` = '1890'
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` = '1888'
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` = '1887'
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` = '1886'
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` = '1885'
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` = '1884'
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` = '1883'
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` = '1880'
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` = '1878'
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` = '1876'
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` = '1875'
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` = '1872'
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` = '1871'
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` = '1868'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1867'
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` = '1864'
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` = '1862'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1861'
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` = '1860'
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` = '1857'
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` = '1856'
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` = '1855'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1852'
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` = '1851'
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` = '1850'
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` = '1847'
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` = '1846'
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` = '1845'
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` = '1843'
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` = '1840'
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` = '1839'
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` = '1837'
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` = '1836'
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` = '1833'
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` = '1832'
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` = '1830'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1829'
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` = '1827'
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` = '1824'
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` = '1823'
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` = '1822'
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` = '48'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1912
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 1d Chip Counts Posted Tuesday 28th February, 2023 at 10:22(UTC+2) by Jason Glatzer
Day 1d attracted 71 entries with 30 players finding a bag into Tuesday's Day 2. This brings the total up to 482 entries establishing a new record for the Championship event. This figure will surpass more than 500 entries with late registration still open during the first blind level of the second and final day. Here is a look at the chip counts from Day 1d led by Jari Hurri with 171,500.
Jari Hurri
171,500
86
Johan Martinsen
160,000
80
Kalle Persson
144,500
72
Priit Vanem
120,000
60
Allesandro Giordano
117,500
59
Matti Lasanen
105,000
53
Zydrunas Karcemarskas
99,500
50
Denis Kockinas
96,500
48
Shiyan Fang
95,500
48
Aki Pyysing
94,000
47
Keimo Suominen
78,500
39
Stanislovas Vinicenka
78,000
39
Lasse Enojarvi
70,000
35
Andrej Michailov
64,500
32
Eero Lehtinen
61,500
31
Mairo Tori
60,000
30
Toni Ylitervo
59,500
30
Reinis Reinbergs
58,500
29
Todd Belsick
52,500
26
Kristian Kostiander
50,500
25
Uri Gilboa
41,000
21
Kyosti Isberg
38,000
19
Andrei Silencov
37,000
19
Antti Vetelainen
33,000
17
Irmantas Bzeskis
32,000
16
Juha-Pekka Rissanen
31,500
16
Timo Ruuska
26,500
13
Elias Suhonen
25,000
13
Renaldas Mankauskas
23,500
12
Juho Suutari
14,500
7
Final Day 1c Chip Counts Posted Monday 27th February, 2023 at 20:59(UTC+2) by Jason Glatzer
Day 1c attracted the largest field in the €555 Championship thus far with 199 entries to bring the total entry count up to 411 with still one more flight to go starting at 9 p.m. with the turbo Day 1d. This figure will also continue to grow with late registration still open during tomorrow's final day throughout the first blind level.
Finland's Iiro Kettunen bagged the biggest stack on Day 1c of 195,000. This puts him in fourth place overall behind Day 1a chip leader Juri Vassin (211,500) and Lithuania's Gediminas Dirmantas (209,000). Day 1b chip leader and 2015 Kings of Tallinn Main Event champion Ranno Sootla is thus far entering Day 2 in fourth place with 192,000.
A total of 75 players survived on Day 2 to bring the total count of survivors up to 161 and counting. Here is a look at the final end-of-Day 1c chip counts:
Player
Chips
Big Blinds
Iiro Kettunen
195,000
98
Girts Fridrihsons
179,500
90
Leonardo Romeo
178,000
89
Juuso Kauppi
170,500
85
Raiki Reinsoo
168,000
84
Matias Knaapinen
166,500
83
Giovanni Nava
163,000
82
Martin Piik
144,000
72
Aleksandr Kuperman
143,500
72
Arminas Nemeika
136,000
68
Laurynas Cerniauskas
135,500
68
Madis Müür
131,000
66
Mohammed Halafi
130,500
65
Stefan Bittger
126,500
63
Paulius Vaitiekunas
121,000
61
Sebastian Gotthardt
116,500
58
Juri Vinkel
116,500
58
Bartosz Mielczarek
114,500
57
Kimmo Matias Kurko
106,000
53
Harald Redl
101,500
51
Joakim Brochard
101,000
51
Mario Colavita
100,500
50
Martynas Racinskas
98,500
49
Mathias Siljander
98,000
49
Kasparas Klezys
94,000
47
Jevgeni Voitovits
93,500
47
Viktor Smyrnov
91,500
46
Markku Koplimaa
90,500
45
Marten Rimmel
89,500
45
Brandon Mifsud
88,500
44
Jose Larios Domene
87,000
44
Kaupo Tenno
85,500
43
Justas Semaška
80,500
40
Michailas Miserkejevas
80,000
40
Urmo Einard
75,000
38
Niko Sivunen
73,500
37
Krzysztof Budka
73,000
37
Janne Ojala
72,500
36
Erno Suominen
72,500
36
Joni Rantamäki
72,000
36
Vygerdas Jonikas
67,000
34
Arto Mansner
66,500
33
Jari Kärkkäinen
66,000
33
Sven Reimaa
65,000
33
Arkadiusz Liszewski
62,500
31
Ville Jantunen
62,000
31
Davide Muccini
61,500
31
Marco Regonaschi
58,000
29
Gisle Guldbrandsen
55,500
28
Hans Erlandsson
53,500
27
Dainius Antanaitis
50,000
25
Mantas Bagocius
50,000
25
Henri Schalin
48,500
24
Oleh Bohdanov
47,000
24
Herli Olop
43,500
22
Tarmo Tammel
43,500
22
Onni Huttunen
41,500
21
Marijus Vaiginas
41,000
21
Viktors Caikins
39,500
20
Touko Berndtson
37,000
19
Matiss Celmins
35,000
18
Michael Ibba
34,500
17
Tuomo Turunen
34,000
17
Julius Tiihonen
33,500
17
Vita Veidemane
32,500
16
Viktor Eriksson
31,500
16
James Noonan
30,000
15
Eirimas Tomkevicius
30,000
15
Luigi Shehadeh
29,500
15
Arvydas Vilcinskas
27,000
14
Rokas Barzdzius
26,500
13
Totti Arosuo
26,000
13
Mohamed Barre Mohamud
22,500
11
Jia Juen Tse
14,000
7
Keito Kaljulaid
7,000
4
Players Bagging Chips Posted Monday 27th February, 2023 at 20:04(UTC+2) by Jason Glatzer
The floor announced the final four hands. Some tables are already bagging up chips.
Day 1d will begin at 9 p.m. EEST. We will post the final chip counts of Day 1c within the hour and Day 1d in the morning.
Surviving players from all the opening flights will reconvene on Tuesday at noon for the final day. Players will still be able to enter and re-enter during the first blind level tomorrow as well.
Posted Monday 27th February, 2023 at 20:03(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 11: 800/1,600 (1,600) Entries: 84/199
Jimmy Dewerdt jammed for 28,000 from the hijack. The action folded to Paulius Vaitiekunas in the big blind.
"How much?" Vaitiekunas asked.
"About 28k," Dewerdt responded.
The dealer began counting Dewerdt's stack but Vaitiekunas called before she was through.
Jimmy Dewerdt: Paulius Vaitiekunas:
Dewerdt was ahead and remained that way after the came on the flop. The turn was a different story as this paired up with Vaitiekunas's nine to take the lead. The river didn't save Dewerdt and he left the tournament arena after the hand.
Player
Chips
Progress
Paulius Vaitiekunas
80,000
50,000
Jimmy Dewerdt
0
0
Toumi Runs Into Ojala's Aces Posted Monday 27th February, 2023 at 19:45(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 10: 600/1,200 (1,200) Entries: 90/1968
Joona Toumi checked with the on the board before Janne Ojala fired out a pot-sized bet of around 30,000. Toumi called off his stack of about the same and needed some help.
Joona Toumi: Janne Ojala:
The river didn't help Toumi's top pair pull ahead of Ojala's rockets and he was out of chips at least on this bullet.
Player
Chips
Progress
Janne Ojala
100,000
50,000
Joona Toumi
0
0
19:35 (UTC+2)
Start of Level 11 Blinds: 800/1,600 Ante: 1,600
Piik Picks One Off Posted Monday 27th February, 2023 at 19:35(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 10: 600/1,200 (1,200) Entries: 95/196
Martin Piik (pictured below) has performed well since the break and has grown his stack to 175,000 since the break. We had a quick chat with Piik who shared how he picked off another player.
Piik opened with from under the gun for 2,500 and got called by two players from the cutoff and the small blind.
The small blind checked the flop before Piik fired out for 5,500. The player in the cutoff folded while the player in the big blind called.
The player in the small blind fired out for 12,000 after the turn and Piik called. The paired the board on the river. The small blind busted out a bet for 22,000. Piik called and won the hand after his opponent tried to steal one away with .
Player
Chips
Progress
Martin Piik
175,000
55,000
Posted Monday 27th February, 2023 at 19:14(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 10: 600/1,200 (1,200) Entries: 101/196
Barre Mohamud Mohamed opened for 2,500 from early position and was called by Kimmo Kurko from middle position, James Noonan from late position, and Egon Kaljulaid from the small blind. Jevgeni Voitovits three-bet to 14,200 from the big blind which cleared everyone out except Kaljulaid from the small blind.
Kaljulaid check-called a bet by Voitovits for 11,000 on the flop and for another 15,000 on the turn. Both players checked the river. Kaljulaid turned over for a ton of missed draws. Voitovits didn't need much to beat this hand and his did the job to win the pot.
Player
Chips
Progress
Jevgeni Voitovits
105,000
75,000
Egon Kaljulaid
30,000
0
Team Re-entries Leads the Team Competition Posted Monday 27th February, 2023 at 19:03(UTC+2) by Jason Glatzer
Team Re-entries, featuring WSOP Bracelet winner Espen Sandvik, Ronnie Albrigtsen, Sondre Stormyr, and Edgars Beizaks was in the lead in the Kings of Tallinn Team Competition yesterday after Sandvik shipped the €250 NLH PKO on Saturday. They remained in the lead today after Albrigtsen won the €250 PLO PKO event on Sunday.
However, their lead was narrowed despite Albrigtsen shipping an event with Team KETTU 2 just points behind. This is primarily due to the amazing performance by Risto Ponnio who has finished runner-up in two separate events thus far. Below is a look at the standings.
Various Big Stacks at Break Posted Monday 27th February, 2023 at 18:53(UTC+2) by Jason Glatzer
Player
Chips
Big Blinds
Raiki Reinsoo
240,000
200
Iiro Kettunen
200,000
167
Martin Piik
120,000
100
Mathias Siljander
115,000
96
Leonardo Romeo
110,000
92
Paulius Vaitiekunas
110,000
92
Onni Huttunen
105,000
88
Sebastian Gotthardt
105,000
88
Juuso Kauppi
105,000
88
Mario Colavita
90,000
75
Brandon Mifsud
90,000
75
Player
Chips
Progress
Reiki Reinsoo
240,000
0
Iiro Kettunen
200,000
75,000
Martin Piik
120,000
90,000
Mathias Siljander
115,000
85,000
Paulius Vaitekunas
110,000
80,000
Leonardo Romeo
110,000
80,000
Juuso Kauppi
105,000
75,000
Onni Huttunen
105,000
75,000
Sebastian Gotthardt
105,000
20,000
Brandon Mifsud
90,000
60,000
Mario Colavita
90,000
60,000
18:49 (UTC+2)
Start of Level 10 Blinds: 600/1,200 Ante: 1,200
Final Day 1c Break Posted Monday 27th February, 2023 at 18:34(UTC+2) by Jason Glatzer
Players are on their final break of Day 1c. Players will fight it out for two more blind levels before surviving players will bag into tomorrow's Day 2.
Shehadeh's Lucky Double Was Short Lived Posted Monday 27th February, 2023 at 18:26(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 9: 500/1,000 (1,000) Entries: 110/190
Arto Mansner jammed for under 20 big blinds with Luigi Shehadeh calling off for a little less.
Luigi Shehadeh: Arto Mansner:
Shehadeh hit a lucky lady on the board to double his stack and leave Mansner on fumes.
However, Shehadeh's luck was short lived as he ran his tens the very next hand against Reika Reinsoo's queens. Tuomo Turunen also got his crumbs in the pot with eights. An eight spiked the flop for Turunen to win the smaller main pot while Reinsoo cheered in joy after he won the side pot to oust Shehadeh. One hand later, Mansner also lost his short stack of around 4 big blinds.
Meanwhile, Reinsoo not only has the chip lead in the Day 1c opening flight but has more chips than both Day 1a chip leader Juri Vassin (211,500) and Day 1b chip leader Ranno Sootla (192,000) bagged during earlier flights.
Player
Chips
Progress
Reika Reinsoo
240,000
210,000
Tuomo Turunen
20,000
10,000
Luigi Shehadeh
0
0
Arto Mansner
0
0
Haller Shares Her Free Path to the €350 Opening Event Posted Monday 27th February, 2023 at 18:10(UTC+2) by Jason Glatzer
The €350 NLH Opening Event has just kicked off with already 52 entries in the field. One of those entries is Estonia's Christel Haller, who is one of the many female players to come out for events consistently at Olympic Park Casino.
Haller took a little time before she hopped into the action to explain why she is playing this event over the many others. It all is thanks to the strong women's poker community here in Estonia.
"In Estonia, we have an amazing women's league," shared Haller. "The first event was in 2009."
Haller explained how the women's league works.
"At first, we play online and we get some points," Haller explained. "Then we have two live events in Tartu and Tallinn. We get some points and the top 50 made the final with the stacks based on the number of points earned. I began the final in 25th place but this didn't matter at the end of the day as I was able to finish runner-up in this event with Catlin Muur. Catlin and I are now on the same team in the Kings of Tallinn alongside Anne Bezdek and Evy Albrigtsen. We aptly called our team 'Queens of F*&ing Everything.'"
While Haller did win a ticket valued at €350 and a Ladies Event ticket valued at €120, both prizes could have been more if she managed to beat Muur heads-up.
"The first-place winner was awarded a Main Event ticket valued at €1,100, where I got a €350 ticket for finishing one spot shy," said Haller. "I am not at all complaining as I am happy for what I won and also happy for Catlin. In addition, I also won a Kings of Tallinn Ladies Event alongside others at the final table.
18:00 (UTC+2)
Start of Level 9 Blinds: 500/1,000 Ante: 1,000
Einard Posted Monday 27th February, 2023 at 17:59(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 8: 400/800 (800) Entries: 114/183
Stanislovas Vinicenka jammed a short stack from early position and called by Urmo Einard for the big blind.
Stanislovas Vinicenka: Urmo Einard:
The board didn't get Vinicenka ahead and he was on the rail.
Player
Chips
Progress
Urmo Einard
45,000
15,000
Cowboys for Kettunen Posted Monday 27th February, 2023 at 17:39(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 8: 400/800 (800) Entries: 124/182
Iiro Kettunen jammed for more than the 16,500 Bengt-Anders Johnsson had in his stack with the on the board after the turn and about 15,000 in the pot.
Johnsson went into the tank for a minute before he called.
Bengt-Anders Johnsson: Iiro Kettunen:
Johnsson needed one of the two remaining sevens to stay alive and double his stack. Today was not his lucky day as the blank river completed the board.
"Nice hand," Johnsson said as he began to leave the table.
Player
Chips
Progress
Iiro Kettunen
125,000
95,000
Bengt-Anders Johnsson
0
0
Posted Monday 27th February, 2023 at 17:26(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 8: 400/800 (800) Entries: 128/176
Arvydas Vilcinskas jammed for less than 15 big blinds from middle position before Sebastian Gotthardt isolated with a bigger jam from one seat over. The rest of the table folded and the cards were turned over.
Arvydas Vilcinskas: Sebastian Gotthardt:
Gotthardt was ahead when the chips went in but had a sweat on the flop with his opponent holding one overcard and a flush draw. The turn opened up even more outs for Vilcinskas with an open-ended straight draw. However, the river didn't push Vilcinskas ahead and his chips went over to Gotthardt.
Player
Chips
Progress
Sebastian Gotthardt
85,000
35,000
Arvydas Vilcinskas
0
0
17:19 (UTC+2)
Start of Level 8 Blinds: 400/800 Ante: 800
Amazing Action in the GGPoker Flip&Go Mystery Bounty Posted Monday 27th February, 2023 at 17:12(UTC+2) by Jason Glatzer
Players are having a blast flipping on Tables 29 & 30 for the start of the €150 GGPoker Flip&Go.
Check it out if you are reading from Tallinn if you are looking for a good time or a break from the tournament action you are in. Of course, there is also potentially a ton of money on the line with a €5,000 top mystery bounty on the line when this event progresses to Day 2.
Rest assured for those of you at home. We promise some video and photo footage of this unique event later in our coverage when it is available.
Big Slick Good for Cerniauskas Posted Monday 27th February, 2023 at 16:55(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 7: 300/600 (600) Entries: 128/163
Laurynas Cerniauskas opened for 1,200 from under the gun. Kristaps Kalva called from one seat over before Henri Schalin three-bet to 3,500 from the cutoff. Cerniauskas and Kalva called.
All three players checked the flop before Cerniauskas bet 4,000 on the turn. Kalva and Schalin both called to see the river completed the board.
Cerinauskas led out for 11,000. Kalva looked at his stack and would have committed his chips if he called. He opted to fold less than a minute later before Schalin went into the tank for a couple of minutes. Schalin called but mucked his hand after Cerniauskas turned over for top pair with the best kicker.
Player
Chips
Progress
Henri Schalin
115,000
85,000
Laurynas Cerniauskas
100,000
30,000
Kristaps Kalva
10,000
20,000
GGPoker Flip&Go Mystery Bounty Rules Posted Monday 27th February, 2023 at 16:45(UTC+2) by Jason Glatzer
The €150 GGPoker Flip&Go Mystery Bounty will kick off shortly. The rules are similar but not identical to the online Flip&Go games at GGPoker and OlyBet Poker with a few small changes and one big one in the mystery bounty component.
Here is how it works:
1) Players enter for a GGPoker Flip&Go opening flight at the cash desk. 2) A game begins when there are nine available players who sit together at one table. 3) Players are dealt three cards facedown. 4) A flop is dealt and players then discard one card and turn the other two over. 5) A turn and a river are dealt and the best hand at the table advances to Day 2 on Friday March 3 already in the money.
A few other notes:
Players on Day 2 will not only be in the money but also collect a mystery bounty prize. The event guarantees at least a €5,000 top mystery bounty prize.
Players that advance to Day 2 may not re-enter other opening flights. Those that haven't advanced to Day 2 can re-enter as many times as they wish until they advance.
Best of luck to all of the players. The Kings of Tallinn staff will be around the action in case players have any questions.
16:39 (UTC+2)
Start of Level 7 Blinds: 300/600 Ante: 600
Second Break Posted Monday 27th February, 2023 at 16:18(UTC+2) by Jason Glatzer
Players are on their second break. Very soon, the €150 GGPoker Mystery Bounty Flip&Go event will kick off, while late registration is now closed in the €150 NLH 8-Max.
Straight for Gotthardt Posted Monday 27th February, 2023 at 15:59(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 6: 200/500 (500) Entries: 124/146
Sebastian Gotthardt bet 5,000 into a pot of slightly more with the on the board.
Joakim Brochard called only to muck his cards after he witnessed Gotthardt turn over for a straight.
Player
Chips
Progress
Sebastian Gotthardt
50,000
20,000
Joakim Brochard
40,000
10,000
Posted Monday 27th February, 2023 at 15:52(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 6: 200/500 (500) Entries: 121/142
James Noonan checked with about 15,000 in the pot and the on the board. Jose Domene jammed for about the 12,000 or so Noonan had behind.
Noonan snap-called and turned over for two pair. This wasn't good enough as Domene held for top set to send Noonan to the rail. Noonan shared he might re-enter after a short break.
Player
Chips
Progress
Jose Domene
70,000
40,000
James Noonan
0
0
15:47 (UTC+2)
Start of Level 6 Blinds: 200/500 Ante: 500
"Could Have Taken More?" Posted Monday 27th February, 2023 at 15:26(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 5: 200/400 (400) Entries: 115/130
Eirimas Tomkevicius check-called a bet by fellow Lithuanian Laurynas Cerniauskas of 6,000 into a pot of around double that with the on the board.
Both players checked the river. Cerniauskas turned over for trip nines and was awarded the pot after Tomkevicius folded.
"Could have taken more?" Cerinauskas asked.
Tomkevicius didn't respond one way or the other as the table got ready for the next hand.
Player
Chips
Progress
Laurynas Cerniauskas
70,000
40,000
Eirimas Tomkevicius
12,000
2,000
Day 1c Photos by Elena Kask Posted Monday 27th February, 2023 at 15:14(UTC+2) by Jason Glatzer
Soul Read by Kurko Posted Monday 27th February, 2023 at 15:10(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 5: 200/400 (400) Entries: 114/124
Kimmo Kurko bet 2,500 into a pot of a bit more with the on the board. Joni Viikki jammed for 6,900. Kurko tanked for a minute before he folded.
Kurko showed he made a great fold with a straight holding . Viikki was kind enough to show Kurko he made the correct soul read and showed he had the goods with for a full house.
Player
Chips
Progress
Kimmo Kurko
36,500
6,500
Joni Viikki
14,000
16,000
14:53 (UTC+2)
Start of Level 5 Blinds: 200/400 Ante: 400
"You Got Lucky" Posted Monday 27th February, 2023 at 14:50(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 4: 100/300 (300) Entries: 110/117
Janne Ojala check-called a bet of 1,500 by Eirimas Tomkevicius into a pot of around 4,000 after the came on the flop. Ojala checked again on the turn. Tomkevicius bet 4,000 and Ojala called.
Ojala jammed for about 17,000 the river. Tomkevicius snap-called and wasn't too happy about what he saw.
Ojala turned over for a full house to win the hand after Tomkevicius showed for flopped trips.
"You got lucky," Tomkevicius said after the hand.
"I got lucky? Ojala asked with a laugh.
"You hit your two-outer," Tomkevicius replied as the dealer was shuffling the deck for the next hand.
Player
Chips
Progress
Janne Ojala
50,000
10,000
Eirimas Tomkevicius
10,000
28,000
Pepe Misses Tallinn Posted Monday 27th February, 2023 at 14:41(UTC+2) by Jason Glatzer
We brought our puppy, Pepe, last time we came to the Kings of Tallinn and everyone now expects she will come every trip.
Unfortunately, Pepe has a job to watch over the rest of the family when I am on the road. Today, she was scoping out the forest behind our home in hopes of seeing her old friends in Tallinn.
Treys Win a Flip for Ojala Posted Monday 27th February, 2023 at 14:36(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 4: 100/300 (300) Entries: 109/114
Janne Ojala checked the flop. Eirimas Tomkevicius bet 2,500 into a pot of around 7,000 and Ojala called.
Both players checked down the turn and the river. Tomkevicius turned over for the two pair on the board plus the ace-kicker. Ojala squeezed out a better two pair after showing to win the hand.
Player
Chips
Progress
Janne Ojala
40,000
10,000
Eirimas Tomkevicius
38,000
8,000
Various Big Stacks at Break Posted Monday 27th February, 2023 at 14:25(UTC+2) by Jason Glatzer
Here is a look at some of the bigger stacks from around the room at the first break of Day 1c.
Player
Chips
Big Blinds
Johan Grave
60,000
200
Jia Juen Tse
60,000
200
Raiki Reinsoo
55,000
183
Girts Fridrihsons
52,000
173
Dainius Antanaitis
52,000
173
Herli Olop
50,000
167
John Watz
50,000
167
Andrei Silencov
50,000
167
Stanislovas Vinicenka
50,000
167
Player
Chips
Progress
Jie Juen Tse
60,000
30,000
Johan Grave
60,000
30,000
Raiki Reinsoo
55,000
25,000
Girts Fridrihsons
52,000
22,000
Andrei Silencov
50,000
20,000
John Watz
50,000
20,000
Herli Olop
50,000
20,000
Stanislovas Vinicenka
50,000
5,000
14:22 (UTC+2)
Start of Level 4 Blinds: 100/300 Ante: 300
First Break Posted Monday 27th February, 2023 at 14:04(UTC+2) by Jason Glatzer
Players are on their first 15-minute break. Blinds will increase to 100/300 with a 300 big blind ante when the action resumes.
8-Handed Fun Begins! Posted Monday 27th February, 2023 at 14:03(UTC+2) by Jason Glatzer
The €150 NLH - 8 Handed event has just kicked off with 19 entries. The field will grow in leaps-and-bounds with late registration open for eight blind levels.
Laura Cornelius in the House Posted Monday 27th February, 2023 at 13:57(UTC+2) by Jason Glatzer
We have a special treat for those here at the Kings of Tallinn. Laura Cornelius (pictured below) has joined us for a special appearance this week as our host and interviewer.
She will capture as many fun moments as possible and it is pleasure to welcome Laura to her first Kings of Tallinn.
Romeo Doubles Short Stack with Rockets Posted Monday 27th February, 2023 at 13:50(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 3: 100/200 (200) Entries: 89/93
Phenporn Laatikainen jammed for more than the about 5,000 Leonardo Romeo had left in his stack into a pot of around 20,000 with the on the board. Romeo called and was far ahead.
Leonardo Romeo: Phenporn Laatikainen:
A blank river completed the board for Romeo to double up through Laatikainen.
Laatikainen is far from the only lady playing today as based on our recent count there are a full dozen women in the Day 1c field!
Player
Chips
Progress
Leonardo Romeo
30,000
20,000
Phenporn Laatikainen
25,000
5,000
13:32 (UTC+2)
Start of Level 3 Blinds: 100/200 Ante: 200
Only Quads for Berman Posted Monday 27th February, 2023 at 13:32(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 2: 100/100 (100) Entries: 82/85
There was 9,000 in the pot with the on the board when Bartosz Wesolek check-raised a bet of 4,400 by Mark Berman.
Wesolek checked again on the river. Berman paused for a moment before firing out for 12,000.
"Uggggg," Wesolek said in frustration. "Flush?"
Wesolek found a call a minute later. Berman didn't have a flush but something much better with the nuts. He turned over for a quads. Wesolek snap-mucked his hand upon seeing what he was up against and was short on chips after the hand.
Player
Chips
Progress
Mark Berman
55,000
25,000
Bartosz Wesolek
7,000
23,000
Pinsel First on the Rail After Running Into Rockets Posted Monday 27th February, 2023 at 13:15(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 2: 100/100 (100) Entries: 72/73
Raivo Pinsel was the first player out on Day 1c of the €555 Championship.
The Estonian was down to just 7,500 in chips and had his stack committed preflop with . Stanislovas Vinicenka, who recently finished runner-up in the Vilnius Ace Breaker Main Event at Olympic Casino Vilnius, woke up with .
There was no drama with Vinicenka's rockets holding to claim Pinsel's short stack.
Player
Chips
Progress
Stanislovas Vinicenka
45,000
15,000
Raivo Pinsel
0
0
Ace-Ten Good for Tiihonen Posted Monday 27th February, 2023 at 13:00(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 2: 100/100 (100) Entries: 70/70
Julius Tiihonen checked with about 7,000 in the pot and the on the board before Mohammed Halafi fired out for 3,100. Vytautas Kacerauskas and Tiihonen both called to see the river. All three players checked. Tiihonen turned over and won the hand with his two pair after both his opponents mucked their cards.
Player
Chips
Progress
Vytautas Kacerauskas
27,500
2,500
Mohammed Halafi
0
18,000
Julius Tiihonen
0
18,000
12:47 (UTC+2)
Start of Level 2 Blinds: 100/100 Ante: 100
Romeo Gives Up Posted Monday 27th February, 2023 at 12:45(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 1: 100/100 Entries: 64/64
Leonardo Romeo, who won a handful of tickets to side events at the Kings of Tallinn during the Battle of Malta, check-raised the turn with the on the board from 2,000 to 6,000 and was called by Alar Neemsalu.
Romeo fired out for 9,000 after the completed the board on the river. Neemsalu paused for a few moments before he jammed for 18,000. Romeo counted his chips before he opted to fold.
Player
Chips
Progress
Alar Neemsalu
45,000
15,000
Leonardo Romeo
10,000
20,000
Huge Fields at the Kings of Tallinn Posted Monday 27th February, 2023 at 12:27(UTC+2) by Jason Glatzer
Big Slick Good for Petruskevicius Posted Monday 27th February, 2023 at 12:23(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 1: 100/100 Entries: 51/51
Juri Vinkel, Hans Erlandsson, and Linas Petruskevicius all checked the turn with the on the board to see the free river.
Vinkel checked again before Erlandsson fired out for 2,700 into a spread pot of around 4,000. Both Petruskevicius and Vinkel called. Erlandsson showed the for two pair. Petruskevicius had that beat with a better two pair with and was awarded the pot after Vinkel mucked his cards.
Player
Chips
Progress
Linas Petruskevicius
40,000
10,000
Hans Erlandsson
26,000
4,000
Juri Vinkel
26,000
4,000
Early Entrants in Day 1c Posted Monday 27th February, 2023 at 12:19(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 1: 100/100 Entries: 50/50
The Day 1c field has grown to 50 entrants. Here is a look at some of the early players in the field.
Player
Chips
Progress
Bartosz Mielczarek
30,000
0
Phenporn Laatikainen
30,000
0
Jarmo Salonen
30,000
0
Linas Petruskevicius
30,000
0
Vytautas Kacerauskas
30,000
0
Jaana Kindsigo
30,000
0
Mark Berman
30,000
0
Dainius Antanaitis
30,000
0
Day 1c Begins Posted Monday 27th February, 2023 at 12:03(UTC+2) by Jason Glatzer
€555 Championship Day 1c Level 1: 100/100 Entries: 39/39
Tournament Director Teresa Nousianen announced the plan of the day before asking dealers to shuffle up and deal.
There were 39 entries in the Day 1c field to start the action. Best of luck to all of the Day 1c players!
Day 1c of the Kings of Tallinn €555 Championship Begins at Noon Posted Monday 27th February, 2023 at 09:56(UTC+2) by Jason Glatzer
Welcome back to the 2023 Kings of Tallinn coverage at Olympic Park Casino and the adjoining Hilton Tallinn Park. Today's coverage will continue with Day 1c of the €555 Championship while also providing some smaller updates on some of today's side events.
The €555 Championship boasts four opening flights with players kicking off the action with 30,000 in starting chips. The structure provides plenty of play with 40-minute blind levels throughout the event with the only exception to this rule being tonight's turbo Day 1d flight which features very playable 25-minute blind levels.
Players will have plenty of time to build a massive stack with unlimited re-entries permitted throughout all of the opening flights and until late registration closes after the first blind level of Tuesday's Day 2.
The €555 Championship already attracted 212 entries with 86 players surviving during the first two opening flights. Juri Vassin was the star of the day after bagging up the Day 1a chip leading stack of 211,500 with Gediminas Dirmantas not too far behind after surviving with 209,000 in chips. Day 1b chip leader Ranno Sootla (pictured below) is currently in third place with 192,000 in chips.
09:52 (UTC+2)
Day 1C of King of Tallinn 2023 Started Level: 1 Blinds: 100/100 Ante: 0
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.