0.0005 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0144 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_kot_championship_eng/1B/updates'
ORDER BY `views` DESC
0.0003 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.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.0004 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.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0005 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.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` = 'page'
0.0064 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.0007 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.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '11'
0.0318 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` = '37'
AND `published` = 1
0.0268 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` = '38'
AND `published` = 1
0.0267 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` = '39'
AND `published` = 1
0.0272 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` = '48'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '11'
AND `name` = '1B'
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '38'
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` = '38'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '1805'
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` = '1801'
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` = '1799'
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` = '1798'
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` = '1795'
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` = '1793'
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` = '1792'
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` = '1790'
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` = '1788'
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` = '1786'
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` = '1784'
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` = '1780'
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` = '1779'
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` = '1776'
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` = '1778'
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` = '1777'
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` = '1772'
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` = '1770'
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` = '1769'
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` = '1767'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1766'
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` = '1764'
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` = '1765'
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` = '1761'
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` = '1757'
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` = '1756'
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` = '1753'
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` = '1752'
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` = '1751'
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` = '1750'
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` = '1749'
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` = '1748'
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` = '1743'
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` = '1742'
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` = '1740'
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` = '1738'
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` = '1737'
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` = '1736'
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` = '1735'
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` = '1732'
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` = '1731'
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` = '1730'
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` = '1729'
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` = '1727'
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` = '1725'
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` = '1726'
ORDER BY `chip_change` DESC, `busted` ASC
0.0112 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1722'
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` = '1721'
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` = '1717'
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` = '1720'
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` = '1714'
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` = '1713'
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` = '1712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 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.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '38'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 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` = '38'
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` = '1805'
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` = '1801'
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` = '1799'
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` = '1798'
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` = '1795'
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` = '1793'
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` = '1792'
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` = '1790'
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` = '1788'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1786'
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` = '1784'
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` = '1780'
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` = '1779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1776'
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` = '1778'
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` = '1777'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1772'
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` = '1770'
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` = '1769'
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` = '1767'
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` = '1766'
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` = '1764'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1765'
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` = '1761'
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` = '1757'
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` = '1756'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1753'
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` = '1752'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1751'
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` = '1750'
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` = '1749'
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` = '1748'
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` = '1743'
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` = '1742'
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` = '1740'
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` = '1738'
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` = '1737'
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` = '1736'
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` = '1735'
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` = '1732'
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` = '1731'
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` = '1730'
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` = '1729'
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` = '1727'
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` = '1725'
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` = '1726'
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` = '1722'
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` = '1721'
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` = '1717'
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` = '1720'
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` = '1714'
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` = '1713'
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` = '1712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 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.
Ranno Sootla Shines Again at the Kings of Tallinn Posted Sunday 26th February, 2023 at 22:15(UTC+2) by Jason Glatzer
End-of-Day 1b Chip Counts Posted Sunday 26th February, 2023 at 20:43(UTC+2) by Jason Glatzer
Player
Chips
Big Blinds
Ranno Sootla
192,000
96
Sami Starck
165,500
83
Dominik Ostrowski
162,000
81
Anthony Kauzloric
143,500
72
Peder Behr
124,500
62
Sebastian Wahl
118,500
59
Henri Wagner
115,500
58
Kaspars Mallons
110,500
55
Matti Salminen
88,500
44
Victor Prior Fernandez Amat
88,000
44
Adria Comas I Roura
87,500
44
Kent Wulff
85,000
43
Luca Beretta
82,000
41
Priit Brikker
81,500
41
Indre Martoviciute
81,000
41
Lari Pukkila
80,000
40
Masse Mirza
79,000
40
Artiom Goncarenko
76,000
38
Nijat Rustamov
75,500
38
Vesa Leikos
74,500
37
Risto Pärnat
69,000
35
Igor Pihela
66,500
33
Aleksei Smirnov
66,500
33
Yaniv Peretz
64,500
32
Ville Laasanen
60,000
30
Arto Antero Lehtonen
60,000
30
Linus Lauermann
58,000
29
Eeti Löyttyniemi
56,500
28
Dmitri Dudakov
55,000
28
Stanislav Smeljov
54,500
27
Priit Oja
52,000
26
Siim Pindis
50,000
25
Renato Messina
49,000
25
Andrey Koks
47,500
24
Juuso Elsinen
44,500
22
Tomi Arponen
43,000
22
Andrius Bielskis
38,000
19
Rain Mölderkivi
37,500
19
Christian Hoffmann
37,000
19
Algirdas Saveikis
34,000
17
Jevgenijs Kritinins
31,000
16
Victor Fernandez Garcia
28,000
14
Final Three Hands Posted Sunday 26th February, 2023 at 20:04(UTC+2) by Jason Glatzer
Day 1b is down to the final three hands of the day. The Day 1b surviving players will soon bag their stacks. We will share the end-of-the-day chip counts in an hour or less along with a short recap of the day.
Sootla Rewarded With Burger Bounty Posted Sunday 26th February, 2023 at 20:01(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 11: 800/1,600 (1,600) Entries: 44/105
Estonian poker legend Ranno Sootla appears to be the chip leader with about 220,000 in chips. He just eliminated a player with the nickname "Zarev" as follows.
Zarev opened for 3,200. Sootla jammed his massive stack and asked Zarev to call. Zarev obliged and turned over ace-queen and was in a race for his tournament life against sevens. The board was all blanks for Zarev and he was eliminated late on Day 1b.
"I can't believe he called with only one pair," Zarev joked after the hand.
A few moments later, Sootla's friend came by with a burger.
"Burger bounty!" we said as we are friendly with both Sootla and Zarev.
Sootla laughed before repeating: "burger bounty!"
Player
Chips
Progress
Ranno Sootla
220,000
190,000
Zarev
0
0
Posted Sunday 26th February, 2023 at 19:46(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 11: 800/1,600 (1,600) Entries: 45/105
As we were watching a few hands unfold, Masse Mirza asked us to "write this" in back-to-back hands with a smile and we are happy to oblige.
Masse Mirza opened for 5,000 from the button. Linus Lauermann three-bet jammed for more than a starting stack. Mirza checked his cards again before he folded.
"Write about this," Mirza said while flashing the . I had fours, which was a hand we witnessed him with earlier today.
Mirza was back at it again the next hand with an open for 4,000 from the button Lauermann three-bet to 10,000 from the small blind. Mirza jammed and a short while later his opponent folded.
"Write about this," Mirza said again.
Normally we don't write about hands during opening days when there is no showdown but we have no shame as he promised to read the blog if we posted.
Player
Chips
Progress
Masse Mirza
75,000
45,000
Linus Lauermann
40,000
0
Final Blind Level of Day 1b Posted Sunday 26th February, 2023 at 19:27(UTC+2) by Jason Glatzer
Day 1b has advanced to its final blind level of the day. Players will bag and tag chips in about 40 minutes.
19:27 (UTC+2)
Start of Level 11 Blinds: 800/1,600 Ante: 1,600
Posted Sunday 26th February, 2023 at 19:25(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 10: 600/1,200 (1,200) Entries: 48/105
Igor Pihela Sr. was cruising along on his seventh bullet in this event but more recently he was below a starting stack.
Priit Brikker opened for 2,500 from the button. Pihela three-bet to 7,500 from the big blind and Brikker called.
Pihela fired out for 5,500 on the flop. Brikker called and both players checked the turn. Pihela then jammed for more than the 43,000 Brikker had behind after the river completed the board.
Brikker went into the tank for several minutes before he found a hero-call. Pihela reluctantly turned over for a bluff which was picked off lightly by Brikker with .
Player
Chips
Progress
Priit Brikker
100,000
70,000
Igor Pihela Sr.
20,000
25,000
Keskel Ousts Koplimaa Posted Sunday 26th February, 2023 at 19:05(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 10: 600/1,200 (1,200) Entries: 50/104
Markku Koplimaa wasn't able to get much going today and just lost his second bullet on a pair of bad beats to Marko Keskel.
Keskel explained in the first hand, Keskel check-jammed with eights on a jack-nine-seven flop and was up against Koplimaa's top pair with queen-jack. A ten came on the turn to improve Keskel to a straight and Koplimaa's stack was down to just a handful of big blinds.
Shortly after, Koplimaa got it in good with ace-king against Keskel's ace-five. Keskel eventually improved to a wheel and Koplimaa has yet to re-enter today for a third time.
Player
Chips
Progress
Marko Keskel
40,000
10,000
Markku Koplimaa
0
0
Dewerdt and Kacerauskas on the Rail Posted Sunday 26th February, 2023 at 18:55(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 10: 500/1,000 (1,000) Entries: 52/104
We caught up with a couple of the players that used to be in the Day 1b field of the €555 Championship.
We first chatted with Jimmy Dewerdt who shared the following hand:
A player opened for min-raise before Dewerdt three-bet to seven big blinds from the big blind. Dewerdt open-jammed for about 30 big blinds after the came on the flop. his opponent called and Dewerdt was in trouble with his dominated by his opponent's . No miracle came the rest of the way and Dewerdt shared that he plans to get back into the event tomorrow.
Meanwhile, Vytautas Kacerauskas is not coming back from the break. He shared with us a video of the hand along with a brief recap. A player min-raised from under the gun. Three players called including Kacerauskas from the big blind.
Kacerauskas checked the flop. The original opener bet 2,500. Two players folded before Kacerauskas jammed for 15,000. His opponent called and the cards were turned over.
Vytautas Kacerauskas: Opponent:
Neither the turn nor the river saved the day for Kacerauskas and he has also opted not to re-enter this late in the day.
Player
Chips
Progress
Jimmy Dewerdt
0
0
Vytautas Kacerauskas
0
0
18:46 (UTC+2)
Start of Level 10 Blinds: 600/1,200 Ante: 1,200
Final Break Posted Sunday 26th February, 2023 at 18:30(UTC+2) by Jason Glatzer
Day 1b is on its final break of the day. The action will continue for two more blind levels after the break before surviving players bag their stacks into Tuesday's Day 2.
Ladies Not Kind to Mielczarek Posted Sunday 26th February, 2023 at 18:23(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 9: 500/1,000 (1,000) Entries: 56/103
Bartosz Mielczarek jammed the button for less than 20 big blinds. Igor Pihela Sr., who built up a stack at least once before, is now on his fourth bullet of the day, called for slightly more.
Bartosz Mielczarek: Igor Pihela Sr.:
It was looking like Pihela was going to head out of the Day 1b field for the fourth time today and for the seventh time overall after also firing three bullets during yesterday's Day 1a.
Mielczarek remained ahead after the flop and the turn. But Pihela nailed his two outer to improve to a set and snag his opponent's stack after the spiked the river to complete the hand.
Player
Chips
Progress
Igor Pihela Sr.
45,000
25,000
Bartosz Mielczarek
0
0
Pukk Loses a Flip Against Pärnat Posted Sunday 26th February, 2023 at 18:09(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 9: 500/1,000 (1,000) Entries: 60/101
Magnus Pukk open-jammed for about 20 big blinds from under the gun. Risto Pärnat paused for a moment before calling from the small blind.
Magnus Pukk: Risto Pärnat:
Pukk was ahead on the flip after the flop but fell far behind after the turn. His two outer didn't come with the river completing the board and the dealer awarded Pärnat the pot with Pukk still able to re-enter if he so chooses.
Player
Chips
Progress
Risto Pärnat
75,000
45,000
Magnus Pukk
0
0
18:08 (UTC+2)
Start of Level 9 Blinds: 500/1,000 Ante: 1,000
Eight Big Hands Posted Sunday 26th February, 2023 at 17:52(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 8: 400/800 (800) Entries: 61/100
The Day 1b field has just grown to 100 entries with Victor Prior Fernandez Amat appearing to be in the chip lead.
We asked Amat if there were any memorable hands, but before he could respond a few others at the table including Masse Mirza implied that he won tons of big hands.
"He won eight big hands," Mirza said with a smile.
Amat went on to explain that he won a massive pot with a flush with three others along for a ride and also won a big pot when his ace-queen held against ace-ten.
Player
Chips
Progress
Victor Amat
160,000
50,000
Jonikas Quickly Re-Enters Posted Sunday 26th February, 2023 at 17:38(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 8: 400/800 (800) Entries: 64/98
While reporting the previous hand involving Lithuania's Andrius Bielskis, we noticed another Lithuanian leaving his seat and heading to the rail in Vygerdas Jonikas.
Jonikas shared he had some bad luck on his first bullet after getting his ace-queen in good against ace-jack. He explained the board was clean until a jack spiked the river.
He was still in good spirits and immediately re-entered the action.
Player
Chips
Progress
Vygerdas Jonikas
30,000
0
Bielskis Doubles With Two Pair Posted Sunday 26th February, 2023 at 17:25(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 8: 400/800 (800) Entries: 64/98
Stanislav Smeljov checked with the on the board after the turn with nearly 20,000 in the pot. Priit Oja fired out for 12,000 before Andrius Bielskis jammed for 20,400. Smeljov quickly folded before Oja just as quickly called.
Andrius Bielskis: Priit Oja:
Oja seemed less than thrilled this his top pair was up against Bielskis' two pair and slammed the table lightly once. He slammed the table slightly harder the second time after the blank river completed the board.
Player
Chips
Progress
Stanislav Smeljov
70,000
0
Andrius Bielskis
60,000
30,000
Priit Oja
45,000
45,000
PLO Begins Posted Sunday 26th February, 2023 at 17:15(UTC+2) by Jason Glatzer
€250 PLO/PLO5 Round of Each Level 1: 100/100 Entries: 36/37
The €250 PLO/PLO5 Round of Each has kicked off. It has literally just started but a player is already on the rail after Martin "Franke" von Zweigbergk eliminated Iiro Kettunen.
Kettunen is already back in the field alongside many others including Lithuanian mixed-game hero Danius Antanaitis, Anu Lilja, Risto Pönniö, and Jari Porkka.
We noticed both Dmitrijs Prohorovs and Onni Huttunen also in the field. This means it is unlikely we will see them back in action in the Day 1b field of the €555 Championship after earlier losing their stacks.
"Do You Have a Good Hand?" Posted Sunday 26th February, 2023 at 17:07(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 7: 300/600 (600) Entries: 66/97
Markku Koplimaa bet 5,800 into a pot of slightly more with the on the board after the turn. Kent Wulff effectively jammed with a bet more than covering the 22,100 Koplimaa had in his stack before his bet.
Koplimaa tanked for a couple of minutes before he began chatting with Wulff.
"Do you have a good hand?" Koplimaa asked.
Wulff appeared to not hear the question so Koplimaa asked the same thing a second time.
"I'll show you it if you call," Wulff eventually responded.
Koplimaa and others at the table laughed and less than a minute later, Koplimaa called.
Markku Koplimaa: Kent Wulff:
"Nice hand," Wulff said to Koplimaa after the river completed the board. Wulff still appeared to be in good spirits after the hand and perhaps his decent stack had something to do with it.
Player
Chips
Progress
Kent Wulff
85,000
35,000
Markku Koplimaa
55,000
25,000
Fives Good for Michailov Posted Sunday 26th February, 2023 at 16:59(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 7: 300/600 (600) Entries: 66/97
Andrej Michailov and Martynas Racinskas both checked with about 15,000 in the pot and the on the board after the turn. Michailov checked again after the river completed the board. Racinskas went into the tank for a minute before he fired out for 13,000. Michailov then tanked for about two minutes before he called.
Racinskas turned over . His ace-kicker to the board wasn't good as Michailov won the hand against his Lithuanian countrymate with a hero call after turning over .
Player
Chips
Progress
Andrej Michailov
110,000
80,000
Martynas Racinskas
15,000
15,000
16:58 (UTC+2)
Start of Level 7 Blinds: 300/600 Ante: 600
Various Big Stacks at Break Posted Sunday 26th February, 2023 at 16:38(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 7: 300/600 (600) Entries: 67/95
Kent Wulff was on top of the Day 1b field at the second break. Here is a look at some of the bigger stacks around the room:
Player
Chips
Progress
Kent Wulff
120,000
90,000
Victor Amat
110,000
80,000
Priit Oja
90,000
5,000
Lari Pukkila
80,000
50,000
Sebastian Wahl
70,000
40,000
Peder Behr
70,000
35,000
Igor Pihela Sr.
70,000
30,000
Stanislav Smeljov
70,000
15,000
Kaspars Mallons
65,000
39,000
Luca Beretta
65,000
35,000
Zarev
55,000
10,000
Ville Laasanen
55,000
5,000
Break Time Posted Sunday 26th February, 2023 at 16:16(UTC+2) by Jason Glatzer
Players are on a 15-minute break. Blinds will increase to 300/600 with a big blind ante of 600.
"He Opened Into Two Maniacs With Eight-Six Off!" Posted Sunday 26th February, 2023 at 16:04(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 6: 200/500 (500) Entries: 68/91
Linus Lauermann opened from middle position before Edgars Beizaks jammed his short stack of 6,800 from the small blind. Onni Huttunen came in over the top for about 8,300 big blind and Lauermann tanked for a bit. Eventually, Lauermann folded but not before he showed .
Edgars Beizaks: Onni Huttunen:
Beizaks won the flip to double his stack and leave Huttunen on fumes after his jack paired up on the board.
While the hand ended in a coin flip, Beizaks seemed to more appreciate the move by Lauermann.
"He opened into two maniacs," said Beizaks. "And we were both short stacks!"
Early Day 1b Photos by Elena Kask Posted Sunday 26th February, 2023 at 15:50(UTC+2) by Jason Glatzer
Laasanen Doubles Through Pihela with a Better Full House Posted Sunday 26th February, 2023 at 15:44(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 6: 200/500 (500) Entries: 67/89
Igor Pihela Sr. bet 3,500 into a pot of slightly more with the on the board after the turn. Ville Laasanen raised to 8,500. Pihela jacked it up to 18,500. Laasanen jammed for 25,300 and Pihela snap-called.
Ville Laasanen: Igor Pihela Sr.:
Pihela was slow to show his hand but that is often the case for the Estonian whether he is ahead or behind. Unfortunately, this time it was a massive cooler for Pihela as despite flopping a set he was drawing to a single out on the river.
No miracle came for Pihela, while Laasanen got to breath a sigh of relief, with the river pairing the board for Laasenen to double through Pihela with a better full house.
Player
Chips
Progress
Ville Laasanen
60,000
30,000
Igor Pihela Sr.
40,000
10,000
15:33 (UTC+2)
Start of Level 6 Blinds: 200/500 Ante: 500
Selection of Photos From Yesterday's Day 1a by Elena Kask Posted Sunday 26th February, 2023 at 15:33(UTC+2) by Jason Glatzer
Lehtonen Doubles Through Mallons Posted Sunday 26th February, 2023 at 15:28(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 5: 200/400 (400) Entries: 66/86
Arto Lehtonen three-bet jammed for 12,500 from the button. Kaspars Mallons paused from a moment before he called from the cutoff.
Arto Lehtonen: Kaspars Mallons:
Both players failed to connect their hands on the runout. Lehtonen's queen kicker came into play to win the hand and double his stack.
Player
Chips
Progress
Arto Lehtonen
0
35,000
Kaspars Mallons
0
4,000
Hoffman's River Bluff Doesn't Work Against Löyttyniemi Posted Sunday 26th February, 2023 at 15:19(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 5: 200/400 (400) Entries: 65/83
Christian Hoffman and Eeti Löyttyniemi both checked with exactly 7,000 in the pot after the turn with the on the board before the completed the board on the river.
Hoffman checked again. Löyttyniemi fired out for 4,000 and Hoffman snap-called. Löyttyniemi turned over for an attempt to steal the pot after missing his draws and Hoffman was awarded the pot after he turned over for two pair.
Player
Chips
Progress
Eeti Löyttyniemi
32,000
2,000
Christian Hoffman
27,000
38,000
Mifsud Doubles Salminen Posted Sunday 26th February, 2023 at 15:07(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 5: 200/400 (400) Entries: 65/82
Matti Salminen jammed for 19,400 into a pot of slightly more with the on the board after the turn.
Brandon Mifsud went into the tank for more than a minute before flicking in a couple of chips to call.
Matti Salminen: Brandon Mifsud:
Salminen only needed to sweat two outs on the river and doubled up after a blank river completed the board .
Player
Chips
Progress
Matti Salminen
60,000
30,000
Brandon Mifsud
10,000
20,000
15:02 (UTC+2)
Start of Level 5 Blinds: 200/400 Ante: 400
Team Re-Entries Leads the Team Challenge Posted Sunday 26th February, 2023 at 15:01(UTC+2) by Jason Glatzer
One of the fun aspects of the Kings of Tallinn is the Team Challenge. It is absolutely free to register a team and the contest is funded with 2% of the prize pool from each qualifying event. This always creates rails even for side events with teammates cheering each other to victory.
Currently, Team Re-Entries, consisting of WSOP Europe bracelet winner Espen Sandvik, Ronnie Albrigtsen, Sondre Stormyr, and Edgars Beizaks, is on top of the leaderboard after the first two days. Sandvik won the €250 NLH Knockout last night for the highest single score thus far. This team is no stranger to success as they have won the Team Challenge before with the exact same line-up.
Just behind Team Re-Entries is the Estonian team Kunnid. This team is stacked with Markku Koplimaa, Tarmo Tammel, Alan Arjut, and Marius Morel leading the way. Morel has contributed the most after winning last night's €250 PLO affair.
Rockets for Oja Posted Sunday 26th February, 2023 at 14:51(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 4: 100/300 (300) Entries: 66/78
Sondre Stormyr opened from under the gun. Stanislav Smeljov three-bet to 2,200 from the cutoff before Priit Oja four-bet to 3,600 from the button. Stormyr folded and Smeljov called to see the flop.
Smeljov check-called a bet of 6,500 by Oja on the flop before both players checked the turn. The river could have completed some draws if players were on them. Smeljov bet just 500 and Oja snap-called. Smeljov turned over the for two overcards.
Meanwhile, Oja was ahead the entire way and turned over the to win the hand.
Player
Chips
Progress
Priit Oja
95,000
65,000
Stanislav Smeljov
55,000
30,000
Sondre Stormyr
55,000
15,000
Brutal River for Koplimaa Posted Sunday 26th February, 2023 at 14:34(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 4: 100/300 (300) Entries: 63/72
Andrey Koks opened for 600 from the hijack. Bartosz Mielczarek three-bet to 2,100 from the small blind. Estonian poker beast Markku Koplimaa paused for about 30 seconds before he four-bet to 5,400 from the big blind. Koks folded and Mielczarek tanked for less than a minute before he called.
Mielczarek check-called bets of 2,700 on the flop and for 5,500 on the turn. The completed the board on the river and Mielczarek checked again. Koplimaa paused for about a minute before he jammed for more than 10,000. Mielczarek snap-called and what a cooler it was for Koplimaa.
Koplimaa turned over for a turned set of queens. He lost to the nuts with Mielczarek rivering a better set with .
"Oh wow," said Koplimaa in shock as he got up from the table.
Koplimaa wasted no time and immediately headed to the cashier to re-enter for another try in Day 1b.
Meanwhile, Aleksei Smirnov, Dmitrijs Prohorovs, and Anthony Kauzloric also recently hit the rail. Kauzloric is already in a new seat after re-entering while Smirnov and Prohorovs are both still on the rail at least for now.
Player
Chips
Progress
Bartosz Mielczarek
75,000
45,000
Anthony Kauzloric
30,000
0
Markku Koplimaa
30,000
0
Dmitrijs Prohorovs
0
0
Aleksei Smirnov
0
0
Where's Pepe? Posted Sunday 26th February, 2023 at 14:20(UTC+2) by Jason Glatzer
Several players and staff have asked, "Where's Pepe?"
This is because this reporter had little choice but to bring his puppy to Tallinn the last time he reported the Kings of Tallinn. Pepe was a rock star with many players and staff watching after her while I was working.
Unfortunately, she was unable to make the trip up north this time around as she is busy hanging out in Vilnius. That being said, she is attentively following our reports from the comfort of her home.
14:16 (UTC+2)
Start of Level 4 Blinds: 100/300 Ante: 300
First Break Posted Sunday 26th February, 2023 at 13:58(UTC+2) by Jason Glatzer
Players are on their first break of the day. The action will resume with blinds at 100/300 with a big blind ante of 300 when the action resumes.
The field has grown to 67 entries with 62 players still in their seats.
"Very Nice River" Posted Sunday 26th February, 2023 at 13:52(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 3: 100/200 (200) Entries: 61/65
Peder Behr and Dmitrijs Prohorovs got locked up in a hand where Behr called off his stack of 17,200 after facing a five-bet jam by Prohorovs.
Peder Behr: Dmitrijs Prohorovs:
It was looking likely that Behr would head to the rail to either take a break or re-enter. This was more the case after bricking both the flop and the turn. However, his king found a friend on the river to stay alive and double his stack.
"Lucky river," Behr said.
Prohorovs lightly slammed the table after the hand in frustration before sharing with Behr his annoyance about the hand.
"Do you play cash games?" asked Prohorovs. "If so, I'd like to play with you later. I would never play king-ten that way."
Player
Chips
Progress
Dmitrijs Prohorovs
35,000
5,000
Peder Behr
35,000
5,000
13:42 (UTC+2)
Start of Level 3 Blinds: 100/200 Ante: 200
Satellite Guarantees Five €555 Championship Seats Posted Sunday 26th February, 2023 at 13:41(UTC+2) by Jason Glatzer
€60 Satellite to the €555 Championship Level 3: 100/200 (200) Entries: 34/37
A €60 satellite to the €555 Championship is also running in the same room as the €555 Championship.
The field is currently at 37 entries and counting. There is a good chance there will be some value here with five €555 Championship seats guaranteed. Although, with late registration open for a couple of hours, there is an equally good chance that this event will award more than the five guaranteed seats.
Good luck to all of the satellite players looking to score their €555 Championship seat for pennies on the Euro.
Set of Nines for Stormyr Posted Sunday 26th February, 2023 at 13:21(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 2: 100/100 (100) Entries: 51/55
Sondre Stormyr fired out a pot-sized bet of 5,000 with the on the board. Stanislav Smeljov called a few moments later only to get bad news.
Stormyr turned over for a set of nines. Smeljov apparently didn't have this beat with a better set of a straight as he mucked his hand.
Player
Chips
Progress
Stanislav Smeljov
25,000
5,000
Sondre Stormyr
0
40,000
Rockets Good for Pindis Posted Sunday 26th February, 2023 at 13:18(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 1: 100/100 Entries: 49/53
Marijus Vaiginas checked with about 10,000 in the pot and the on the board after the turn. Siim Pandis fired out for 5,500. Aleksei Smirnov went paused for about 30 seconds before he called. Vaiginas also called before checking the river.
Pandis once again bet 5,500. Smirnov quickly called and Vaiginas just as quickly folded.
"Aces," said Pandis before turning over the .
Smirnov shook his head in what appeared to be frustration.
"Kings?" asked Pandis to Smirnov.
"No, queens," replied Smirnov who then opted to show his as Pandis began to pile his chips.
Player
Chips
Progress
Siim Pandis
60,000
30,000
Marijus Vaiginas
24,000
6,000
Aleksei Smirnov
15,000
15,000
13:17 (UTC+2)
Start of Level 2 Blinds: 100/100 Ante: 100
Arponen's Bluff Picked Off Posted Sunday 26th February, 2023 at 12:48(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 1: 100/100 Entries: 42/44
A player with the nickname "Zarev" is full of table chatter on Table 6. His table chatter appeared to get him paid in a hand against Tomi Arponen.
Zarev fired out for 4,000 into a pot of 2,200 with the on the board after the flop.
"Now he knows I am bluffing," Zarev said to the table before both players checked the turn.
The river paired the board and Zarev checked again. Arponen opted to bet 4,000 and Zarev snap-called.
"I only have queen-high," said Arponen before turning over the .
"Oh, you were bluffing me," Zarev responded before showing he called light with tow in the hand.
Meanwhile, Lauri Niemi was the second player to hit the rail on Day 1b.
Player
Chips
Progress
Zarev
45,000
15,000
Tomi Arponen
22,000
8,000
Lauri Niemi
0
0
Jonsson First on the Rail Posted Sunday 26th February, 2023 at 12:30(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 1: 100/100 Entries: 37/38
Albert Jonsson was the first player on the rail during Day 1b. Sondre Stormyr was busy piling up Jonsson's former stack into his when he shared that he nailed two pair with nine-three against his opponent's pair.
Jonsson has plenty of time to get back in with a 300 big blind stack with the next level also featuring blinds at 100/100. The only difference will be that the big blind ante comes into play during Level 2.
Player
Chips
Progress
Sondre Stormyr
65,000
35,000
Christian Hoffman
30,000
0
Albert Jonsson
0
0
Posted Sunday 26th February, 2023 at 12:26(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 1: 100/100 Entries: 33/33
Here is a look at some of the players battling it out early on Day 1b.
Player
Chips
Progress
Marijus Vaiginas
30,000
0
Vygerdas Jonikas
30,000
0
Vytautas Kacerauskas
30,000
0
Anthony Kauzloric
30,000
0
Henri Wagner
30,000
0
Vesa Leikos
30,000
0
Arto Lehtonen
30,000
0
12:25 (UTC+2)
Start of Level 1 Blinds: 100/100 Ante: 0
Action Begins Posted Sunday 26th February, 2023 at 12:04(UTC+2) by Jason Glatzer
€555 Championship Day 1b Level 1: 100/100 Entries: 27/27
The action has kicked off with a tidy field of 27 entries. It was a late night for many of the players as the casino was rocking on Saturday evening. So expect this field to grow in a big way as the day continues.
Day 1b of the €555 Championship Begins at Noon Posted Sunday 26th February, 2023 at 11:02(UTC+2) by Jason Glatzer
Welcome to the coverage of the 2023 Kings of Tallinn at Olympic Park Casino and the adjoining Hilton Tallinn Park. The first event the coverage will be primarily focusing on is the Kings of Tallinn €555 Championship from Feb. 25- 28 before hopping into reports from the €500,000 guaranteed Kings of Tallinn €1,100 Main Event from March 1-5.
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 Monday night'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 not only throughout all of the opening flights but also until late registration closes after the first blind level of Tuesday's Day 2.
The €555 Championship already attracted 107 entries with 44 players surviving after 11 blind levels of play. 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.
Today's action will be identical to yesterday's with 11 blind levels of 40 minutes each. Our coverage will begin when cards are in the air at noon EET.
Sunday's Side Events
The €555 Championship isn't the only event players will battle it out in on Sunday as there are plenty of other events for those that already bagged chips or are looking for something different as follows:
Time
#
Event
1 p.m.
11
€60 Satellite to The Kings Of Tallinn €555 Championship (5 seats GTD)
5 p.m.
12
€250 PL Omaha 4 & 5 Cards Progressive Bounty
9 p.m.
13
€250 NLH, 8 Handed
10 p.m.
14
€60 Satellite to The Kings Of Tallinn €555 Championship (5 seats GTD)
Day 1B of King of Tallinn 2023 Started Level:Blinds: 0/0 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.