0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0009 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2023_kot_championship_eng/1C/updates', 1, '2024-04-26')

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

0.0001 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.0003 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

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

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

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT `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.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

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

0.0195 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0036 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '37' AND `published` = 1

0.0193 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0031 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '38' AND `published` = 1

0.0193 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0036 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '39' AND `published` = 1

0.0193 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0031 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '48' AND `published` = 1

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '11' AND `name` = '1C'

0.0050 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '39' ORDER BY `busted` ASC, `current_chips` DESC

0.0033 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '39' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1925' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1909' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1907' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1906' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1904' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1903' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1902' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1899' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1898' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1895' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1893' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1891' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1890' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1888' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1887' ORDER BY `chip_change` DESC, `busted` ASC

0.0146 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1886' ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1885' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1884' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1883' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1880' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1878' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1876' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1875' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1872' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1871' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1868' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1867' ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '1864' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1862' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1860' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1857' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1856' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1855' ORDER BY `chip_change` DESC, `busted` ASC

0.0247 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1852' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1851' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1850' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1847' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1846' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1845' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1843' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1840' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1839' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1837' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1836' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1833' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1832' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1830' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1829' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1827' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1824' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1823' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1822' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 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.0046 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '39' ORDER BY `busted` ASC, `current_chips` DESC

0.0071 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '39' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1925' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1909' ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1907' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1906' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1904' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1903' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1902' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1899' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1898' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1895' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1893' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1891' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1890' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1888' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1887' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1886' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1885' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1884' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1883' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1880' ORDER BY `chip_change` DESC, `busted` ASC

0.0160 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1878' ORDER BY `chip_change` DESC, `busted` ASC

0.0076 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1876' 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` = '1875' ORDER BY `chip_change` DESC, `busted` ASC

0.0081 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1872' ORDER BY `chip_change` DESC, `busted` ASC

0.0081 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1871' ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1868' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1867' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1864' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1862' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1861' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1860' ORDER BY `chip_change` DESC, `busted` ASC

0.0053 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1857' 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` = '1856' 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` = '1855' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1852' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1851' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1850' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1847' ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1846' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1845' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1843' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1840' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1839' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1837' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1836' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1833' ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1832' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1830' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1829' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1827' ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1824' ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1823' ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1822' ORDER BY `chip_change` DESC, `busted` ASC

0.0047 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

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 1C
End-of-Day 1d Chip Counts Posted Tuesday 28th February, 2023 at 10:22(UTC+2) by Jason Glatzer

Day 1d attracted 71 entries with 30 players finding a bag into Tuesday's Day 2.  This brings the total up to 482 entries establishing a new record for the Championship event. This figure will surpass more than 500 entries with late registration still open during the first blind level of the second and final day. Here is a look at the chip counts from Day 1d led by Jari Hurri with 171,500.

Jari Hurri 171,500 86
Johan Martinsen 160,000 80
Kalle Persson 144,500 72
Priit Vanem 120,000 60
Allesandro Giordano 117,500 59
Matti Lasanen 105,000 53
Zydrunas Karcemarskas 99,500 50
Denis Kockinas 96,500 48
Shiyan Fang 95,500 48
Aki Pyysing 94,000 47
Keimo Suominen 78,500 39
Stanislovas Vinicenka 78,000 39
Lasse Enojarvi 70,000 35
Andrej Michailov 64,500 32
Eero Lehtinen 61,500 31
Mairo Tori 60,000 30
Toni Ylitervo 59,500 30
Reinis Reinbergs 58,500 29
Todd Belsick 52,500 26
Kristian Kostiander 50,500 25
Uri Gilboa 41,000 21
Kyosti Isberg 38,000 19
Andrei Silencov 37,000 19
Antti Vetelainen 33,000 17
Irmantas Bzeskis 32,000 16
Juha-Pekka Rissanen 31,500 16
Timo Ruuska 26,500 13
Elias Suhonen 25,000 13
Renaldas Mankauskas 23,500 12
Juho Suutari 14,500 7
Final Day 1c Chip Counts Posted Monday 27th February, 2023 at 20:59(UTC+2) by Jason Glatzer

Day 1c attracted the largest field in the €555 Championship thus far with 199 entries to bring the total entry count up to 411 with still one more flight to go starting at 9 p.m. with the turbo Day 1d. This figure will also continue to grow with late registration still open during tomorrow's final day throughout the first blind level.

Finland's Iiro Kettunen bagged the biggest stack on Day 1c of 195,000. This puts him in fourth place overall behind Day 1a chip leader Juri Vassin (211,500) and Lithuania's Gediminas Dirmantas (209,000). Day 1b chip leader and 2015 Kings of Tallinn Main Event champion Ranno Sootla is thus far entering Day 2 in fourth place with 192,000.

A total of 75 players survived on Day 2 to bring the total count of survivors up to 161 and counting. Here is a look at the final end-of-Day 1c chip counts:

Player Chips Big Blinds
Iiro Kettunen 195,000 98
Girts Fridrihsons 179,500 90
Leonardo Romeo 178,000 89
Juuso Kauppi 170,500 85
Raiki Reinsoo 168,000 84
Matias Knaapinen 166,500 83
Giovanni Nava 163,000 82
Martin Piik 144,000 72
Aleksandr Kuperman 143,500 72
Arminas Nemeika 136,000 68
Laurynas Cerniauskas 135,500 68
Madis Müür 131,000 66
Mohammed Halafi 130,500 65
Stefan Bittger 126,500 63
Paulius Vaitiekunas 121,000 61
Sebastian Gotthardt 116,500 58
Juri Vinkel 116,500 58
Bartosz Mielczarek 114,500 57
Kimmo Matias Kurko 106,000 53
Harald Redl 101,500 51
Joakim Brochard 101,000 51
Mario Colavita 100,500 50
Martynas Racinskas 98,500 49
Mathias Siljander 98,000 49
Kasparas Klezys 94,000 47
Jevgeni Voitovits 93,500 47
Viktor Smyrnov 91,500 46
Markku Koplimaa 90,500 45
Marten Rimmel 89,500 45
Brandon Mifsud 88,500 44
Jose Larios Domene 87,000 44
Kaupo Tenno 85,500 43
Justas Semaška 80,500 40
Michailas Miserkejevas 80,000 40
Urmo Einard 75,000 38
Niko Sivunen 73,500 37
Krzysztof Budka 73,000 37
Janne Ojala 72,500 36
Erno Suominen 72,500 36
Joni Rantamäki 72,000 36
Vygerdas Jonikas 67,000 34
Arto Mansner 66,500 33
Jari Kärkkäinen 66,000 33
Sven Reimaa 65,000 33
Arkadiusz Liszewski 62,500 31
Ville Jantunen 62,000 31
Davide Muccini 61,500 31
Marco Regonaschi 58,000 29
Gisle Guldbrandsen 55,500 28
Hans Erlandsson 53,500 27
Dainius Antanaitis 50,000 25
Mantas Bagocius 50,000 25
Henri Schalin 48,500 24
Oleh Bohdanov 47,000 24
Herli Olop 43,500 22
Tarmo Tammel 43,500 22
Onni Huttunen 41,500 21
Marijus Vaiginas 41,000 21
Viktors Caikins 39,500 20
Touko Berndtson 37,000 19
Matiss Celmins 35,000 18
Michael Ibba 34,500 17
Tuomo Turunen 34,000 17
Julius Tiihonen 33,500 17
Vita Veidemane 32,500 16
Viktor Eriksson 31,500 16
James Noonan 30,000 15
Eirimas Tomkevicius 30,000 15
Luigi Shehadeh 29,500 15
Arvydas Vilcinskas 27,000 14
Rokas Barzdzius 26,500 13
Totti Arosuo 26,000 13
Mohamed Barre Mohamud 22,500 11
Jia Juen Tse 14,000 7
Keito Kaljulaid 7,000 4
Players Bagging Chips Posted Monday 27th February, 2023 at 20:04(UTC+2) by Jason Glatzer

The floor announced the final four hands. Some tables are already bagging up chips.

Day 1d will begin at 9 p.m. EEST. We will post the final chip counts of Day 1c within the hour and Day 1d in the morning.

Surviving players from all the opening flights will reconvene on Tuesday at noon for the final day. Players will still be able to enter and re-enter during the first blind level tomorrow as well.

Posted Monday 27th February, 2023 at 20:03(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 11: 800/1,600 (1,600)
Entries: 84/199

Jimmy Dewerdt jammed for 28,000 from the hijack. The action folded to Paulius Vaitiekunas in the big blind.

"How much?" Vaitiekunas asked.

"About 28k," Dewerdt responded.

The dealer began counting Dewerdt's stack but Vaitiekunas called before she was through.

Jimmy Dewerdt:
Paulius Vaitiekunas:

Dewerdt was ahead and remained that way after the came on the flop. The turn was a different story as this paired up with Vaitiekunas's nine to take the lead. The river didn't save Dewerdt and he left the tournament arena after the hand.

Player Chips Progress
Paulius Vaitiekunas 80,000 50,000
Jimmy Dewerdt 0 0
Toumi Runs Into Ojala's Aces Posted Monday 27th February, 2023 at 19:45(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 10: 600/1,200 (1,200)
Entries: 90/1968

Joona Toumi checked with the on the board before Janne Ojala fired out a pot-sized bet of around 30,000. Toumi called off his stack of about the same and needed some help.

Joona Toumi:
Janne Ojala:

The river didn't help Toumi's top pair pull ahead of Ojala's rockets and he was out of chips at least on this bullet.

Player Chips Progress
Janne Ojala 100,000 50,000
Joona Toumi 0 0
19:35 (UTC+2)
Start of Level 11
Blinds: 800/1,600     Ante: 1,600
Piik Picks One Off Posted Monday 27th February, 2023 at 19:35(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 10: 600/1,200 (1,200)
Entries: 95/196

Martin Piik (pictured below) has performed well since the break and has grown his stack to 175,000 since the break. We had a quick chat with Piik who shared how he picked off another player.

Piik opened with from under the gun for 2,500 and got called by two players from the cutoff and the small blind.

The small blind checked the flop before Piik fired out for 5,500. The player in the cutoff folded while the player in the big blind called.

The player in the small blind fired out for 12,000 after the turn and Piik called. The paired the board on the river. The small blind busted out a bet for 22,000. Piik called and won the hand after his opponent tried to steal one away with .

Player Chips Progress
Martin Piik 175,000 55,000
Posted Monday 27th February, 2023 at 19:14(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 10: 600/1,200 (1,200)
Entries: 101/196

Barre Mohamud Mohamed opened for 2,500 from early position and was called by Kimmo Kurko from middle position, James Noonan from late position, and Egon Kaljulaid from the small blind. Jevgeni Voitovits three-bet to 14,200 from the big blind which cleared everyone out except Kaljulaid from the small blind.

Kaljulaid check-called a bet by Voitovits for 11,000 on the flop and for another 15,000 on the turn. Both players checked the river. Kaljulaid turned over for a ton of missed draws. Voitovits didn't need much to beat this hand and his did the job to win the pot.

Player Chips Progress
Jevgeni Voitovits 105,000 75,000
Egon Kaljulaid 30,000 0
Team Re-entries Leads the Team Competition Posted Monday 27th February, 2023 at 19:03(UTC+2) by Jason Glatzer

Team Re-entries, featuring WSOP Bracelet winner Espen Sandvik, Ronnie Albrigtsen, Sondre Stormyr, and Edgars Beizaks was in the lead in the Kings of Tallinn Team Competition yesterday after Sandvik shipped the €250 NLH PKO on Saturday. They remained in the lead today after Albrigtsen won the €250 PLO PKO event on Sunday.

However, their lead was narrowed despite Albrigtsen shipping an event with Team KETTU 2 just points behind. This is primarily due to the amazing performance by Risto Ponnio who has finished runner-up in two separate events thus far. Below is a look at the standings.

Team Points
Team Re-entries 59.27
KETTU 2 51.99
Kunnid 34.52
Vodkasoodalimellä 31.48
Bingoplayers 22.12
AMFC 19.64
Harjauksen ABC 16.01
(S)QUAD 15.7
5th Bullet 15.63
Berzloy 15.1
Team Random 14.85
Ison rahan pelaajat 13.71
Fast & Furious 13.6
Gia & The Boys 13.09
Unemployed STARS 10.7
Lion Poker 10.36
TOPIT 9.92
ZBIRY 9.49
Sugar Daddies 8.91
Pandaarmy 8
La French Connection 7.75
Diamonds forever 7
MaiUnaGioia 5
Belly Busters 5
Kings of Bams 4
The Italians 3.15
JarmoJengi 3
Tilteist K.O. 3
PURI 2
Queens Of F***ing Everything 2
Luckytime 2
Dr.Goldfox 1
Bullz 1
Vilnius Magic 1
No set No bet 1
The Catalan 1
AC Milan 1
Sairas Riveri 0
TriplaKasi 0
Blessed 0
CT-Sirkus 0
Team Come to Afters (it’s sick)
0
Moose N’ Mouses 0
Adelsö Poker 0
Yläpeli kuntoon 0
Team Loikkanen 0
Mitu õlut? 0
RunGood 0
Kindergarten suckout 0
TULE SIIA ! 0
Half to Verund 0
Low Rollers 0
Karlsson på taket 0
HP Sauce 0
Insane asylum 0
Ohiveto 0
punters 0
T??eri 0
Casan Novat 0

Various Big Stacks at Break Posted Monday 27th February, 2023 at 18:53(UTC+2) by Jason Glatzer
Player Chips Big Blinds
Raiki Reinsoo 240,000 200
Iiro Kettunen 200,000 167
Martin Piik 120,000 100
Mathias Siljander 115,000 96
Leonardo Romeo 110,000 92
Paulius Vaitiekunas 110,000 92
Onni Huttunen 105,000 88
Sebastian Gotthardt 105,000 88
Juuso Kauppi 105,000 88
Mario Colavita 90,000 75
Brandon Mifsud 90,000 75
Player Chips Progress
Reiki Reinsoo 240,000 0
Iiro Kettunen 200,000 75,000
Martin Piik 120,000 90,000
Mathias Siljander 115,000 85,000
Paulius Vaitekunas 110,000 80,000
Leonardo Romeo 110,000 80,000
Juuso Kauppi 105,000 75,000
Onni Huttunen 105,000 75,000
Sebastian Gotthardt 105,000 20,000
Brandon Mifsud 90,000 60,000
Mario Colavita 90,000 60,000
18:49 (UTC+2)
Start of Level 10
Blinds: 600/1,200     Ante: 1,200
Final Day 1c Break Posted Monday 27th February, 2023 at 18:34(UTC+2) by Jason Glatzer

Players are on their final break of Day 1c. Players will fight it out for two more blind levels before surviving players will bag into tomorrow's Day 2.

Shehadeh's Lucky Double Was Short Lived Posted Monday 27th February, 2023 at 18:26(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 9: 500/1,000 (1,000)
Entries: 110/190

Arto Mansner jammed for under 20 big blinds with Luigi Shehadeh calling off for a little less.

Luigi Shehadeh:
Arto Mansner:

Shehadeh hit a lucky lady on the board to double his stack and leave Mansner on fumes.

However, Shehadeh's luck was short lived as he ran his tens the very next hand against Reika Reinsoo's queens. Tuomo Turunen also got his crumbs in the pot with eights. An eight spiked the flop for Turunen to win the smaller main pot while Reinsoo cheered in joy after he won the side pot to oust Shehadeh. One hand later, Mansner also lost his short stack of around 4 big blinds.

Meanwhile, Reinsoo not only has the chip lead in the Day 1c opening flight but has more chips than both Day 1a chip leader Juri Vassin (211,500) and Day 1b chip leader Ranno Sootla (192,000) bagged during earlier flights.

Player Chips Progress
Reika Reinsoo 240,000 210,000
Tuomo Turunen 20,000 10,000
Luigi Shehadeh 0 0
Arto Mansner 0 0
Haller Shares Her Free Path to the €350 Opening Event Posted Monday 27th February, 2023 at 18:10(UTC+2) by Jason Glatzer

The €350 NLH Opening Event has just kicked off with already 52 entries in the field. One of those entries is Estonia's Christel Haller, who is one of the many female players to come out for events consistently at Olympic Park Casino.

Haller took a little time before she hopped into the action to explain why she is playing this event over the many others. It all is thanks to the strong women's poker community here in Estonia.

"In Estonia, we have an amazing women's league," shared Haller. "The first event was in 2009."

Haller explained how the women's league works.

"At first, we play online and we get some points," Haller explained. "Then we have two live events in Tartu and Tallinn. We get some points and the top 50 made the final with the stacks based on the number of points earned. I began the final in 25th place but this didn't matter at the end of the day as I was able to finish runner-up in this event with Catlin Muur. Catlin and I are now on the same team in the Kings of Tallinn alongside Anne Bezdek and Evy Albrigtsen. We aptly called our team 'Queens of F*&ing Everything.'" 

While Haller did win a ticket valued at €350 and a Ladies Event ticket valued at €120, both prizes could have been more if she managed to beat Muur heads-up. 

"The first-place winner was awarded a Main Event ticket valued at €1,100, where I got a €350 ticket for finishing one spot shy," said Haller. "I am not at all complaining as I am happy for what I won and also happy for Catlin. In addition, I also won a Kings of Tallinn Ladies Event alongside others at the final table.

18:00 (UTC+2)
Start of Level 9
Blinds: 500/1,000     Ante: 1,000
Einard Posted Monday 27th February, 2023 at 17:59(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 8: 400/800 (800)
Entries: 114/183

Stanislovas Vinicenka jammed a short stack from early position and called by Urmo Einard for the big blind.

Stanislovas Vinicenka:
Urmo Einard:

The board didn't get Vinicenka ahead and he was on the rail.

Player Chips Progress
Urmo Einard 45,000 15,000
Cowboys for Kettunen Posted Monday 27th February, 2023 at 17:39(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 8: 400/800 (800)
Entries: 124/182

Iiro Kettunen jammed for more than the 16,500 Bengt-Anders Johnsson had in his stack with the on the board after the turn and about 15,000 in the pot.

Johnsson went into the tank for a minute before he called.

Bengt-Anders Johnsson:
Iiro Kettunen:

Johnsson needed one of the two remaining sevens to stay alive and double his stack. Today was not his lucky day as the blank river completed the board.

"Nice hand," Johnsson said as he began to leave the table.

Player Chips Progress
Iiro Kettunen 125,000 95,000
Bengt-Anders Johnsson 0 0
Posted Monday 27th February, 2023 at 17:26(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 8: 400/800 (800)
Entries: 128/176

Arvydas Vilcinskas jammed for less than 15 big blinds from middle position before Sebastian Gotthardt isolated with a bigger jam from one seat over. The rest of the table folded and the cards were turned over.

Arvydas Vilcinskas:
Sebastian Gotthardt:

Gotthardt was ahead when the chips went in but had a sweat on the flop with his opponent holding one overcard and a flush draw. The turn opened up even more outs for Vilcinskas with an open-ended straight draw. However, the river didn't push Vilcinskas ahead and his chips went over to Gotthardt.

Player Chips Progress
Sebastian Gotthardt 85,000 35,000
Arvydas Vilcinskas 0 0
17:19 (UTC+2)
Start of Level 8
Blinds: 400/800     Ante: 800
Amazing Action in the GGPoker Flip&Go Mystery Bounty Posted Monday 27th February, 2023 at 17:12(UTC+2) by Jason Glatzer

Players are having a blast flipping on Tables 29 & 30 for the start of the €150 GGPoker Flip&Go.

Check it out if you are reading from Tallinn if you are looking for a good time or a break from the tournament action you are in. Of course, there is also potentially a ton of money on the line with a €5,000 top mystery bounty on the line when this event progresses to Day 2.

Rest assured for those of you at home. We promise some video and photo footage of this unique event later in our coverage when it is available.

Big Slick Good for Cerniauskas Posted Monday 27th February, 2023 at 16:55(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 7: 300/600 (600)
Entries: 128/163

Laurynas Cerniauskas opened for 1,200 from under the gun. Kristaps Kalva called from one seat over before Henri Schalin three-bet to 3,500 from the cutoff. Cerniauskas and Kalva called.

All three players checked the flop before Cerniauskas bet 4,000 on the turn. Kalva and Schalin both called to see the river completed the board.

Cerinauskas led out for 11,000. Kalva looked at his stack and would have committed his chips if he called. He opted to fold less than a minute later before Schalin went into the tank for a couple of minutes. Schalin called but mucked his hand after Cerniauskas turned over for top pair with the best kicker.

Player Chips Progress
Henri Schalin 115,000 85,000
Laurynas Cerniauskas 100,000 30,000
Kristaps Kalva 10,000 20,000
GGPoker Flip&Go Mystery Bounty Rules Posted Monday 27th February, 2023 at 16:45(UTC+2) by Jason Glatzer

The €150 GGPoker Flip&Go Mystery Bounty will kick off shortly. The rules are similar but not identical to the online Flip&Go games at GGPoker and OlyBet Poker with a few small changes and one big one in the mystery bounty component. 

Here is how it works:

1) Players enter for a GGPoker Flip&Go opening flight at the cash desk.
2) A game begins when there are nine available players who sit together at one table.
3) Players are dealt three cards facedown.
4) A flop is dealt and players then discard one card and turn the other two over.
5) A turn and a river are dealt and the best hand at the table advances to Day 2 on Friday March 3 already in the money.

A few other notes:

  • Players on Day 2 will not only be in the money but also collect a mystery bounty prize. The event guarantees at least a €5,000 top mystery bounty prize.
  • Players that advance to Day 2 may not re-enter other opening flights. Those that haven't advanced to Day 2 can re-enter as many times as they wish until they advance.

Best of luck to all of the players. The Kings of Tallinn staff will be around the action in case players have any questions.

16:39 (UTC+2)
Start of Level 7
Blinds: 300/600     Ante: 600
Second Break Posted Monday 27th February, 2023 at 16:18(UTC+2) by Jason Glatzer

Players are on their second break. Very soon, the €150 GGPoker Mystery Bounty Flip&Go event will kick off, while late registration is now closed in the €150 NLH 8-Max.

Straight for Gotthardt Posted Monday 27th February, 2023 at 15:59(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 6: 200/500 (500)
Entries: 124/146

Sebastian Gotthardt bet 5,000 into a pot of slightly more with the on the board.

Joakim Brochard called only to muck his cards after he witnessed Gotthardt turn over for a straight.

Player Chips Progress
Sebastian Gotthardt 50,000 20,000
Joakim Brochard 40,000 10,000
Posted Monday 27th February, 2023 at 15:52(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 6: 200/500 (500)
Entries: 121/142

James Noonan checked with about 15,000 in the pot and the on the board. Jose Domene jammed for about the 12,000 or so Noonan had behind.

Noonan snap-called and turned over for two pair. This wasn't good enough as Domene held for top set to send Noonan to the rail. Noonan shared he might re-enter after a short break.

Player Chips Progress
Jose Domene 70,000 40,000
James Noonan 0 0
15:47 (UTC+2)
Start of Level 6
Blinds: 200/500     Ante: 500
"Could Have Taken More?" Posted Monday 27th February, 2023 at 15:26(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 5: 200/400 (400)
Entries: 115/130

Eirimas Tomkevicius check-called a bet by fellow Lithuanian Laurynas Cerniauskas of 6,000 into a pot of around double that with the on the board.

Both players checked the river. Cerniauskas turned over for trip nines and was awarded the pot after Tomkevicius folded.

"Could have taken more?" Cerinauskas asked.

Tomkevicius didn't respond one way or the other as the table got ready for the next hand.

Player Chips Progress
Laurynas Cerniauskas 70,000 40,000
Eirimas Tomkevicius 12,000 2,000
Day 1c Photos by Elena Kask Posted Monday 27th February, 2023 at 15:14(UTC+2) by Jason Glatzer

Soul Read by Kurko Posted Monday 27th February, 2023 at 15:10(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 5: 200/400 (400)
Entries: 114/124

Kimmo Kurko bet 2,500 into a pot of a bit more with the on the board. Joni Viikki jammed for 6,900. Kurko tanked for a minute before he folded.

Kurko showed he made a great fold with a straight holding . Viikki was kind enough to show Kurko he made the correct soul read and showed he had the goods with for a full house.

Player Chips Progress
Kimmo Kurko 36,500 6,500
Joni Viikki 14,000 16,000
14:53 (UTC+2)
Start of Level 5
Blinds: 200/400     Ante: 400
"You Got Lucky" Posted Monday 27th February, 2023 at 14:50(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 4: 100/300 (300)
Entries: 110/117

Janne Ojala check-called a bet of 1,500 by Eirimas Tomkevicius into a pot of around 4,000 after the came on the flop. Ojala checked again on the turn. Tomkevicius bet 4,000 and Ojala called.

Ojala jammed for about 17,000 the river. Tomkevicius snap-called and wasn't too happy about what he saw.

Ojala turned over for a full house to win the hand after Tomkevicius showed for flopped trips.

"You got lucky," Tomkevicius said after the hand.

"I got lucky? Ojala asked with a laugh.

"You hit your two-outer," Tomkevicius replied as the dealer was shuffling the deck for the next hand.

Player Chips Progress
Janne Ojala 50,000 10,000
Eirimas Tomkevicius 10,000 28,000
Pepe Misses Tallinn Posted Monday 27th February, 2023 at 14:41(UTC+2) by Jason Glatzer

We brought our puppy, Pepe, last time we came to the Kings of Tallinn and everyone now expects she will come every trip. 

Unfortunately, Pepe has a job to watch over the rest of the family when I am on the road. Today, she was scoping out the forest behind our home in hopes of seeing her old friends in Tallinn. 

Treys Win a Flip for Ojala Posted Monday 27th February, 2023 at 14:36(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 4: 100/300 (300)
Entries: 109/114

Janne Ojala checked the flop. Eirimas Tomkevicius bet 2,500 into a pot of around 7,000 and Ojala called.

Both players checked down the turn and the river. Tomkevicius turned over for the two pair on the board plus the ace-kicker. Ojala squeezed out a better two pair after showing to win the hand.

Player Chips Progress
Janne Ojala 40,000 10,000
Eirimas Tomkevicius 38,000 8,000
Various Big Stacks at Break Posted Monday 27th February, 2023 at 14:25(UTC+2) by Jason Glatzer

Here is a look at some of the bigger stacks from around the room at the first break of Day 1c.

Player Chips Big Blinds
Johan Grave 60,000 200
Jia Juen Tse 60,000 200
Raiki Reinsoo 55,000 183
Girts Fridrihsons 52,000 173
Dainius Antanaitis 52,000 173
Herli Olop  50,000 167
John Watz 50,000 167
Andrei Silencov 50,000 167
Stanislovas Vinicenka 50,000 167
Player Chips Progress
Jie Juen Tse 60,000 30,000
Johan Grave 60,000 30,000
Raiki Reinsoo 55,000 25,000
Girts Fridrihsons 52,000 22,000
Andrei Silencov 50,000 20,000
John Watz 50,000 20,000
Herli Olop 50,000 20,000
Stanislovas Vinicenka 50,000 5,000
14:22 (UTC+2)
Start of Level 4
Blinds: 100/300     Ante: 300
First Break Posted Monday 27th February, 2023 at 14:04(UTC+2) by Jason Glatzer

Players are on their first 15-minute break. Blinds will increase to 100/300 with a 300 big blind ante when the action resumes.

8-Handed Fun Begins! Posted Monday 27th February, 2023 at 14:03(UTC+2) by Jason Glatzer

€150 NLH - 8 Handed
Level 1: 100/100
Entries: 19/19

The €150 NLH - 8 Handed event has just kicked off with 19 entries. The field will grow in leaps-and-bounds with late registration open for eight blind levels.

Laura Cornelius in the House Posted Monday 27th February, 2023 at 13:57(UTC+2) by Jason Glatzer

We have a special treat for those here at the Kings of Tallinn. Laura Cornelius (pictured below) has joined us for a special appearance this week as our host and interviewer.

She will capture as many fun moments as possible and it is pleasure to welcome Laura to her first Kings of Tallinn.

Romeo Doubles Short Stack with Rockets Posted Monday 27th February, 2023 at 13:50(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 3: 100/200 (200)
Entries: 89/93

Phenporn Laatikainen jammed for more than the about 5,000 Leonardo Romeo had left in his stack into a pot of around 20,000 with the on the board. Romeo called and was far ahead.

Leonardo Romeo:
Phenporn Laatikainen:

A blank river completed the board for Romeo to double up through Laatikainen.

Laatikainen is far from the only lady playing today as based on our recent count there are a full dozen women in the Day 1c field! 

Player Chips Progress
Leonardo Romeo 30,000 20,000
Phenporn Laatikainen 25,000 5,000
13:32 (UTC+2)
Start of Level 3
Blinds: 100/200     Ante: 200
Only Quads for Berman Posted Monday 27th February, 2023 at 13:32(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 2: 100/100 (100)
Entries: 82/85

There was 9,000 in the pot with the on the board when Bartosz Wesolek check-raised a bet of 4,400 by Mark Berman.

Wesolek checked again on the river. Berman paused for a moment before firing out for 12,000.

"Uggggg," Wesolek said in frustration. "Flush?"

Wesolek found a call a minute later. Berman didn't have a flush but something much better with the nuts. He turned over for a quads. Wesolek snap-mucked his hand upon seeing what he was up against and was short on chips after the hand.

Player Chips Progress
Mark Berman 55,000 25,000
Bartosz Wesolek 7,000 23,000
Pinsel First on the Rail After Running Into Rockets Posted Monday 27th February, 2023 at 13:15(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 2: 100/100 (100)
Entries: 72/73

Raivo Pinsel was the first player out on Day 1c of the €555 Championship. 

The Estonian was down to just 7,500 in chips and had his stack committed preflop with . Stanislovas Vinicenka, who recently finished runner-up in the Vilnius Ace Breaker Main Event at Olympic Casino Vilnius, woke up with

There was no drama with Vinicenka's rockets holding to claim Pinsel's short stack.

Player Chips Progress
Stanislovas Vinicenka 45,000 15,000
Raivo Pinsel 0 0
Ace-Ten Good for Tiihonen Posted Monday 27th February, 2023 at 13:00(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 2: 100/100 (100)
Entries: 70/70

Julius Tiihonen checked with about 7,000 in the pot and the on the board before Mohammed Halafi fired out for 3,100. Vytautas Kacerauskas and Tiihonen both called to see the river. All three players checked. Tiihonen turned over and won the hand with his two pair after both his opponents mucked their cards.

Player Chips Progress
Vytautas Kacerauskas 27,500 2,500
Mohammed Halafi 0 18,000
Julius Tiihonen 0 18,000
12:47 (UTC+2)
Start of Level 2
Blinds: 100/100     Ante: 100
Romeo Gives Up Posted Monday 27th February, 2023 at 12:45(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 1: 100/100
Entries: 64/64

Leonardo Romeo, who won a handful of tickets to side events at the Kings of Tallinn during the Battle of Malta, check-raised the turn with the on the board from 2,000 to 6,000 and was called by Alar Neemsalu.

Romeo fired out for 9,000 after the completed the board on the river. Neemsalu paused for a few moments before he jammed for 18,000. Romeo counted his chips before he opted to fold.

Player Chips Progress
Alar Neemsalu 45,000 15,000
Leonardo Romeo 10,000 20,000
Huge Fields at the Kings of Tallinn Posted Monday 27th February, 2023 at 12:27(UTC+2) by Jason Glatzer

Big Slick Good for Petruskevicius Posted Monday 27th February, 2023 at 12:23(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 1: 100/100
Entries: 51/51

Juri Vinkel, Hans Erlandsson, and Linas Petruskevicius all checked the turn with the on the board to see the free river.

Vinkel checked again before Erlandsson fired out for 2,700 into a spread pot of around 4,000. Both Petruskevicius and Vinkel called. Erlandsson showed the for two pair. Petruskevicius had that beat with a better two pair with and was awarded the pot after Vinkel mucked his cards.

Player Chips Progress
Linas Petruskevicius 40,000 10,000
Hans Erlandsson 26,000 4,000
Juri Vinkel 26,000 4,000
Early Entrants in Day 1c Posted Monday 27th February, 2023 at 12:19(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 1: 100/100
Entries: 50/50

The Day 1c field has grown to 50 entrants. Here is a look at some of the early players in the field.

Player Chips Progress
Bartosz Mielczarek 30,000 0
Phenporn Laatikainen 30,000 0
Jarmo Salonen 30,000 0
Linas Petruskevicius 30,000 0
Vytautas Kacerauskas 30,000 0
Jaana Kindsigo 30,000 0
Mark Berman 30,000 0
Dainius Antanaitis 30,000 0
Day 1c Begins Posted Monday 27th February, 2023 at 12:03(UTC+2) by Jason Glatzer

€555 Championship Day 1c
Level 1: 100/100
Entries: 39/39

Tournament Director Teresa Nousianen announced the plan of the day before asking dealers to shuffle up and deal.

There were 39 entries in the Day 1c field to start the action. Best of luck to all of the Day 1c players!

Day 1c of the Kings of Tallinn €555 Championship Begins at Noon Posted Monday 27th February, 2023 at 09:56(UTC+2) by Jason Glatzer

Welcome back to the 2023 Kings of Tallinn coverage at Olympic Park Casino and the adjoining Hilton Tallinn Park. Today's coverage will continue with Day 1c of the €555 Championship while also providing some smaller updates on some of today's side events.

The €555 Championship boasts four opening flights with players kicking off the action with 30,000 in starting chips. The structure provides plenty of play with 40-minute blind levels throughout the event with the only exception to this rule being tonight's turbo Day 1d flight which features very playable 25-minute blind levels.

Players will have plenty of time to build a massive stack with unlimited re-entries permitted throughout all of the opening flights and until late registration closes after the first blind level of Tuesday's Day 2.

The €555 Championship already attracted 212 entries with 86 players surviving during the first two opening flights.  Juri Vassin was the star of the day after bagging up the Day 1a chip leading stack of 211,500 with Gediminas Dirmantas not too far behind after surviving with 209,000 in chips. Day 1b chip leader Ranno Sootla (pictured below) is currently in third place with 192,000 in chips.

09:52 (UTC+2)
Day 1C of King of Tallinn 2023 Started
Level: 1     Blinds: 100/100     Ante: 0

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