0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0099 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-20' AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_kot_championship_eng/1B/updates' ORDER BY `views` DESC

0.0165 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-20' AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_kot_championship_eng/1B/updates'

0.0003 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0003 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

0.0005 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0006 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0005 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.0010 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.0120 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.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '11'

0.0350 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.0326 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` = '38' AND `published` = 1

0.0325 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.0322 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0054 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '48' AND `published` = 1

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '11' AND `name` = '1B'

0.0101 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.0066 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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0091 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1798' ORDER BY `chip_change` DESC, `busted` ASC

0.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0092 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0096 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1765' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1757' 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` = '1756' 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` = '1753' 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` = '1752' 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` = '1751' 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` = '1750' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1737' 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` = '1736' 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` = '1735' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1731' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1729' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1725' 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` = '1726' 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` = '1722' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1717' ORDER BY `chip_change` DESC, `busted` ASC

0.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0099 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.0101 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.0063 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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0091 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0091 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0152 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1772' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0091 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0108 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1729' 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` = '1727' 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` = '1725' 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` = '1726' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1721' ORDER BY `chip_change` DESC, `busted` ASC

0.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '1720' ORDER BY `chip_change` DESC, `busted` ASC

0.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0094 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0101 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.0005 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 1912

English
King of Tallinn 2023 2023 Kings Of Tallinn €555 Championship (English) Live Reporting - Day 2

Current Level 31 Current Day 2
Blinds 75,000/150,000 Ante 150000
Entries 559 Remaining 1
Prize Pool (EUR) €262,730 First Prize (EUR) €55,500
1 New Update - Click to refresh
Live Updates - Day 1B
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.

Head to the Kings of Tallinn Team Standings page for the fully updated results.

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)

Head to the Kings of Tallinn schedule page to check out the full schedule of the 2023 Kings of Tallinn.

10:47 (UTC+2)
Day 1B of King of Tallinn 2023 Started
Level:      Blinds: 0/0     Ante: 0

Your search results are valid for . More 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.