0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0059 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-04-30'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ_Est'
ORDER BY `views` DESC

0.0009 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ_Est', 1, '2024-04-30')

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.0003 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.0063 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` = '2024_KOT_555_Champ_Est'

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '95'

0.0194 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0041 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '226'
AND `published` = 1

0.0186 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0037 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '227'
AND `published` = 1

0.0190 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0038 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '232'
AND `published` = 1

0.0395 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0065 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '235'
AND `published` = 1

0.0246 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` = '238'
AND `published` = 1

0.0064 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` = '238'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '95'
AND `name` = '2'

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

0.0046 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` = '238'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '10743'
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` = '10717'
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` = '10362'
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` = '10352'
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` = '10346'
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` = '10345'
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` = '10342'
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` = '10341'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0052 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10312'
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` = '10303'
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` = '10301'
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` = '10299'
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` = '10297'
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` = '10291'
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` = '10286'
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` = '10285'
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` = '10283'
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` = '10279'
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` = '10278'
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` = '10274'
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` = '10272'
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` = '10269'
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` = '10265'
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` = '10262'
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` = '10260'
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` = '10258'
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` = '10256'
ORDER BY `chip_change` DESC, `busted` ASC

0.0150 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10250'
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` = '10248'
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` = '10247'
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` = '10241'
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` = '10238'
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` = '10237'
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` = '10235'
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` = '10231'
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` = '10225'
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` = '10224'
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` = '10220'
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` = '10216'
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` = '10215'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0052 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10213'
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` = '10203'
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` = '10202'
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` = '10198'
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` = '10196'
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` = '10193'
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` = '10191'
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` = '10190'
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` = '10185'
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` = '10182'
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` = '10181'
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` = '10177'
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` = '10176'
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` = '10173'
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` = '10172'
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` = '10167'
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` = '10166'
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` = '10163'
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` = '10162'
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` = '10159'
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` = '10154'
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` = '10153'
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` = '10152'
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` = '10151'
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` = '10144'
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` = '10143'
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` = '10141'
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` = '10140'
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` = '10139'
ORDER BY `chip_change` DESC, `busted` ASC

0.0156 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10136'
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` = '10131'
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` = '10130'
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` = '10128'
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` = '10126'
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` = '10125'
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` = '10124'
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` = '10117'
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` = '10116'
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` = '232'
ORDER BY `busted` ASC, `current_chips` DESC

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

0.0039 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` = '238'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '10743'
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` = '10717'
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` = '10362'
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` = '10352'
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` = '10346'
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` = '10345'
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` = '10342'
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` = '10341'
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` = '10338'
ORDER BY `chip_change` DESC, `busted` ASC

0.0147 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10316'
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` = '10312'
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` = '10303'
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` = '10301'
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` = '10299'
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` = '10297'
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` = '10291'
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` = '10286'
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` = '10285'
ORDER BY `chip_change` DESC, `busted` ASC

0.0052 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10283'
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` = '10279'
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` = '10278'
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` = '10274'
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` = '10272'
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` = '10269'
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` = '10265'
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` = '10262'
ORDER BY `chip_change` DESC, `busted` ASC

0.0252 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10260'
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` = '10258'
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` = '10256'
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` = '10250'
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` = '10248'
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` = '10247'
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` = '10241'
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` = '10238'
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` = '10237'
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` = '10235'
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` = '10231'
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` = '10225'
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` = '10224'
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` = '10220'
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` = '10216'
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` = '10215'
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` = '10214'
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` = '10213'
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` = '10203'
ORDER BY `chip_change` DESC, `busted` ASC

0.0251 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10202'
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` = '10198'
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` = '10196'
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` = '10193'
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` = '10191'
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` = '10190'
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` = '10185'
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` = '10182'
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` = '10181'
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` = '10177'
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` = '10176'
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` = '10173'
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` = '10172'
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` = '10167'
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` = '10166'
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` = '10163'
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` = '10162'
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` = '10159'
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` = '10158'
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` = '10154'
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` = '10153'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0083 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10141'
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` = '10140'
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` = '10139'
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` = '10136'
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` = '10131'
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` = '10130'
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` = '10128'
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` = '10126'
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` = '10125'
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` = '10124'
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` = '10117'
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` = '10116'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(3)
  • 888poker UK Poker League(3)
  • APAT(9)
  • APPT(2)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(2)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(1)
  • British Poker Series(9)
  • BSOP(4)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(11)
  • EAPT(2)
  • EPT(4)
  • Estrellas Poker Tour(2)
  • Eureka Poker Tour(3)
  • France Poker Series(3)
  • Gift Voucher(1)
  • Golden Nugget Grand Poker Series(1)
  • Grosvenor Casino Coventry(4)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/25(1)
  • Grosvenor Poker 25/50(34)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's Summer Fest(0)
  • GUKPT Grosvenor(6)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(0)
  • Irish Poker Tour(12)
  • Kings of Tallinn(0)
  • LAPT(3)
  • London Poker Festival(1)
  • Malta Poker Festival(1)
  • Master Classics of Poker(0)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(10)
  • North American Poker Tour(0)
  • Olympic Park Casino(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • RDS (Royal Dublin Society)(0)
  • Sky Poker Tour(2)
  • The Casino at Portomaso(3)
  • The Festival(3)
  • The Poker Room(1)
  • Triton Super High Roller Series(1)
  • UK Poker Championships(1)
  • UKIPT(3)
  • Unibet DeepStack Open(5)
  • Unibet Open(0)
  • Venetian Deepstack Extravaganza(2)
  • WPT(7)
  • WPT Alpha 8(3)
  • WPT Prime(6)
  • WPT Special Events(2)
  • WPT500(1)
  • WSOP(1)
  • WSOP Circuit Events(3)
  • WSOP International Circuit(3)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Flight FAQs
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll
  • IPT Portugal Adventure X Giveaway

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

Kings of Tallinn 2024 Event #12: €555 Championship (Estonian) Live Reporting - Day 2

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

---

Current Level 21 Current Day 2

---

Blinds 10,000/15,000 Ante 15000

Entries 700 Remaining 1

---

Prize Pool (EUR) €329,000 First Prize (EUR) €0

Chip Leaders Day 2

1

Mikko Ylämäki

21,000,000

Day 1A Day 1B Day 1C Day 1D Day 2

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 2

22:11 (UTC+2)

Day 2 of Kings of Tallinn 2024 Ended
Level: 21     Blinds: 10,000/15,000     Ante: 16,000

Turniiri võitis soomlane Ylämäki Posted Wednesday 28th February, 2024 at 20:15(UTC+2) by maheaaatom

555 € Championship turniiri võitis soomlane Mikko Tapani Ylämäki.

Kaks parimat tegid diili, seega sai Mikko 57 860 ning teiseks tulnud leedulane Andrius Bielskis 49 000 eurot. 

35. koht Dmitri Zatsik 1600 € Posted Tuesday 27th February, 2024 at 22:42(UTC+2) by maheaaatom

Dmitri stäkk on liiga väike, et mingeid trikke lubada - tal on valikus kas all-in või fold. Lõpuks see võimalus tekib - kaartideks ning lauast tuleb külm call -lt. Et vastane veel riverisse rea tõmbab, on muidugi omaette teema.

Kurb tõdeda, et tegemist oli vist eestlaste jaoks kõige ebaõnnestunuma live-turniiriga üldse. Osalejate seas oli ligi sada eestlast, suur osa tipptegijatest nende hulgas, kuid keegi neist ei suutnud pääseda isegi mitte 34 parima sekka!

Lõpetame aga positiivse ütlusega, mis pärinev Tanel Evertilt. "See oli kõigest soojendus. Põhiturniiril me näitame hoopis teist mängu!"

Loodame, et see nii ka läheb ning lõpetame selle turniiri eestikeelse ülekande (ingliskeelne blogi läheb mõistagi edasi). Tulemused avaldame homme, mil alustamegi juba põhiturniiriga. Seniks aga jälgige üliägedat kuulsuste turniiri!

Player		Chips	Progress
Dmitri Zatsik		0	0

40. koht Tanel Evert 1400 € Posted Tuesday 27th February, 2024 at 22:20(UTC+2) by maheaaatom

Konsta Heikkilä avab keskel 2XBB tõstega ning BB-l istuv Tanel Evert mõtleb pikalt. 30 000 on sees, 150 000 järgi, käes ...

Viimaks tuleb call, tema õnnetuseks on soomlasel . Laud jookseb tühja. 

Player		Chips	Progress
Tanel Evert		0	0

Eestlaste stäkid Posted Tuesday 27th February, 2024 at 22:10(UTC+2) by maheaaatom

Blinde arvestades on mõlemad mehed sisuliselt push-fold mängus. Samas kui peaks duublisse saama, on juba võimalus manööverdada.

 

Player		Chips	Progress
Dmitri Zatsik		230,000	50,000
Tanel Evert		180,000	20,000

45. koht Aleksandr Kuperman 1400 € Posted Tuesday 27th February, 2024 at 22:07(UTC+2) by maheaaatom

Niigi on meid vähe ja aina vähemaks jääb. Aleksandr Kuperman jookseb oma viimaste nuppudega -ga otsa. Tasuks 1400 eurot. 

Player		Chips	Progress
Aleksandr Kuperman		0	0

Tiimide hetkeseis Posted Tuesday 27th February, 2024 at 22:02(UTC+2) by maheaaatom

Meie supertiim TIME on tõusnud Allani, Tammeli ja Moreli eilsete vägitegude taustal kolmandaks ning teisele tiimile kaotatakse vaid paari punktiga. Tiimi neljas liige Hendrik Uibo on samuti on panuse juba andnud ühe kolmanda kohaga. Oleks uhke, kui ka selle võistluse esikoht suudetakse Eestisse jätta!

Jätkame Posted Tuesday 27th February, 2024 at 22:00(UTC+2) by maheaaatom

Paus on läbi ja mängijaid laudades tagasi. Melu on nii turniirialal kui kasiinos korralik, nagu polekski lihtsalt teisipäev. 

250 € NLH läks lukku 165 sisseostuga, PLO-s on neid tehtud juba 105. Peamine melupakkuja on muidugi kuulsuste turniir, milles saate lugeda meie eraldi blogist.

21:55 (UTC+2)

Start of Level 21
Blinds: 10,000/15,000     Ante: 16,000

Õhtusöögipausile 45 mängijat Posted Tuesday 27th February, 2024 at 20:56(UTC+2) by maheaaatom

Algas tunnine õhtusöögipaus, millele läheb 45 mängijat, eelpool mainitud kolm eestlast nende seas. 

Oleme tagasi 60 minuti pärast.

50. koht Aleksei Smirnov 1400 €, 49. koht Erik Põlluveer 1400 € Posted Tuesday 27th February, 2024 at 20:44(UTC+2) by maheaaatom

Nüüd läheb küll kehvasti, Aleksei jookseb oma kuningatega ässade vastu. Täpselt samal hetkel langeb välja Erik Põlluveer, kel tõsi - väga pisike stäkk. 

Seega saame elada kaasa vaid kolmele Eesti mängijale. Kõik nad on selgelt alla keskmise stäkiga.

Player		Chips	Progress
Dmitri Zatsik		280,000	220,000
Tanel Evert		200,000	20,000
Aleksandr Kuperman		120,000	80,000
Aleksei Smirnov		0	0

Kõigest viis eestlast Posted Tuesday 27th February, 2024 at 20:28(UTC+2) by maheaaatom

Championshipil on mängus veel vaid viis eestlast, kellest üks vähemalt tipp-proff Aleksei Smirnov. 

Just langes konkurentsist ka maailmakuulus highroller Ilari Sahamies. 

Dmitri pääseb rongi alt Posted Tuesday 27th February, 2024 at 20:19(UTC+2) by maheaaatom

Dmitri Zatsik on preflopis all-in -ga vastu. 

Flop on parim, mida Dmitri võiks oodata ning turn ja river tema eduseisu ei kõiguta.

Siiski on Dmitril ka selle all-in'i järel väga vähe nööpe, vast umbes 130K.

20:18 (UTC+2)

Start of Level 20
Blinds: 6,000/12,000     Ante: 12,000

60. koht Meelis Meliste 1200 €, 58. koht Magnus Pukk 1200 € Posted Tuesday 27th February, 2024 at 20:14(UTC+2) by maheaaatom

Meelis kurtis suhteliselt halva kaardijooksu üle ning premium käsi talle otsustavatel hetkedel ei jagatud.

All-in tuli minna -ga, vastas ning äss floppi. 

Tunamullusel EMV põhiturniiri võitjal Magnusel polnud samuti pea üldse stäkki, vaid mõned blindid. 

Player		Chips	Progress
Meelis Meliste		0	0
Magnus Pukk		0	0

64. koht Kevin Didvig 1200 € Posted Tuesday 27th February, 2024 at 20:04(UTC+2) by maheaaatom

Eestlastest veel üks langeja - Kevin Didvig 64. kohal.

Kohe on algamas 150 € kuulsuste eriturniir ning "tavainimesed" on juba laudades istet võtnud. 

Seda turniiri saab jälgida läbi eraldi blogi, millega toimetab Mariliis. Championshipil on hetkel 61 parimat alles. 

Player		Chips	Progress
Kevin Didvig		0	0

76. koht Kaarel Võhandu 1100 €, 70. koht Igor Pihela vanem 1200 € Posted Tuesday 27th February, 2024 at 19:55(UTC+2) by maheaaatom

Mängijad langeb iga minutiga, eestlastest kahjuks out ka Kaarel Võhandu ning Igor Pihela vanem. Igor elab ka pisikese money-jumpi üle ning teenib 100 eurot rohkem kui Kaarel :)

Player		Chips	Progress
Igor Pihela vanem		0	0
Kaarel Võhandu		0	0

Eestlaste stäkid Posted Tuesday 27th February, 2024 at 19:50(UTC+2) by maheaaatom

"Mul käib see nagu Ameerika mägedel," naerab Aleksi Smirnov, kes on jälle end suht mäele saanud. Alles oli tal vähemalt poole vähem nööpe.

Tanel on rahul, et mull lõhkes, kuid rõhutab, et loomulikult polnud eesmärgiks lihtsalt mull üle elada ja min-cash saada, vaid eesmärgid on ikka hoopis kõrgemad.

Player		Chips	Progress
Aleksei Smirnov		270,000	40,000
Aleksandr Kuperman		200,000	70,000
Tanel Evert		180,000	40,000
Igor Pihela vanem		180,000	110,000
Meelis Meliste		160,000	30,000
Erik Põlluveer		130,000	40,000
Magnus Pukk		80,000	30,000
Dmitri Zatsik		60,000	30,000

77. koht Natalja Manuyko 1100 € Posted Tuesday 27th February, 2024 at 19:47(UTC+2) by maheaaatom

Nataljal oli võrdlemisi väike stäkk ning minimaalne eesmärk - rahadesse jõudmine - sai kenasti täidetud. 

Ühtlasi on selgunud turniiri parim naismängija, kelleks on seekord leedulanna. 

85. koht - Tanel Merida 1100 €, 82. koht - Rain Kandla Posted Tuesday 27th February, 2024 at 19:40(UTC+2) by maheaaatom

Mullimängu järel kukuvad shordid pea iga käega. Eestlastest on paraku väljas Tanel Merida, kes teenib 85. koha ning Rain Kandlale, kellele kuulub 82. koht.

Mängime veel kaks taset, misjärel algab tunnine õhtusöögipaus. 

Player		Chips	Progress
Tanel Merida		0	0

19:37 (UTC+2)

Start of Level 19
Blinds: 5,000/10,000     Ante: 10,000

87. koht Glen Kolmer 1100 € Posted Tuesday 27th February, 2024 at 19:15(UTC+2) by maheaaatom

Glen Kolmer suutis mulli lõhkemise ära oodata, kuid kahjuks mitte enamat. Ega tal väga mänguruumi polnud ka.

Championship'il osalevad mängijad, kes kõik on ühtlasi ka rahades, lubatakse natukeseks ajaks puhkama. See on suurepärane võimalus natuke jalgu sirutada, kasiinos kerge drink teha ja võib-olla ka muusikat kuulata. 

Player		Chips	Progress
Glen Kolmer		0	0

Menukas freeroll Posted Tuesday 27th February, 2024 at 19:11(UTC+2) by maheaaatom

Kuulsuste eriturniiri freebuy-turniiril tehti 144 sisseostu, nende hulgas nii esimesed osalemised (mis olid tasuta) kui ka 10-eurosed juurdeostud ja add'onid. 

250 € NLH-le on kogunenud 165 sisseostu ning 1100 € PLO-le 61. Viimasel käib üsna lahtine mäng, paistab et paljudele pole see 1100 eurot nagu mingi raha...

Kuulsuste eriturniiril on juba kirjas 134 mängijat, alguseni on veel 50 minutit aega.

Mull lõhkes kiirelt Posted Tuesday 27th February, 2024 at 19:06(UTC+2) by maheaaatom

Mull lõhkes esimese võimaliku käega, 150K stäkiga Jussi Kivekäs jäi oma nuppudest ilma -ga vastu. 

87 parima seas on 14 eestlast, kes kõik on taganud endale vähemalt 1100 eurot auhinnaraha.

Pre-mull Posted Tuesday 27th February, 2024 at 18:54(UTC+2) by maheaaatom

Vahepeal veel kaks langejat ning me oleme rahadest kõigest kahe koha kaugusel. 

Üheks, kes peab veel natuke aega värisema, on Natalja Manyoko umbes 80K stäkiga. Naisi on mängus täpselt kaks, lisaks Nataljale ka Viktorija Ignataviciene, kes suutis just oma kuningatega vajaliku duubli saada. 

Tanel ootab rahasid Posted Tuesday 27th February, 2024 at 18:46(UTC+2) by maheaaatom

Tanel Evertil on 170K, mis on küll alla keskmise, kuid siiski täiesti mängitav stäkk. Aga eelkõige on Taneli sooviks rahadesse jõuda. Selleks tuleb elada üle veel kolme konkurendi langemine ning tema õnneks on ka pisistäkke omajagu. 

Olympic Park Casinos on pidu täies hoos ning mürts käimas. Natuke on seda ka suurde saali kuulda.

18:40 (UTC+2)

Start of Level 18
Blinds: 4,000/8,000     Ante: 8,000

Glen kaotab olulise panga Posted Tuesday 27th February, 2024 at 18:40(UTC+2) by maheaaatom

Glen Kolmer alustab EP-lt min-tõstega ja saab vastu all-in panuse Dmitrijs Arsunsilt (69 000). Meie mees mõtleb küll pea minuti, kuid otsustab siiski callida.

Dmitrijs: 
Glen:

Laud annab Glenile küll rea, kuid lätlasele masti. Õnneks on meie mehel oluliselt suurem stäkk.

 

Martin bad beadiga väljas Posted Tuesday 27th February, 2024 at 18:36(UTC+2) by maheaaatom

Martinil täna lihtsalt ei vea! Viimased nupud lähevad vs. ning lauda paraku kümme.

Ka Sander Leigri ja Joonas Kulli on pidanud lauast püsti tõusma. Mull on kõigest 5 koha kaugusel.

Player		Chips	Progress
Joonas Kulli		115,000	0
Sander Leigri		0	0
Martin Kõiv		0	0

Artur mängust väljas Posted Tuesday 27th February, 2024 at 18:14(UTC+2) by maheaaatom

Detaile kahjuks ei tea, kuid nimekas pokkeriäss Artur Külanurk on kahjuks mängust välja langenud. Jätkab 98 parimat ning nii hämmastav kui see ka ei ole, on mullimäng kõigest 10 koha kaugusel.

Player		Chips	Progress
Artur Külanurk		0	0

18:11 (UTC+2)

Start of Level 17
Blinds: 3,000/6,000     Ante: 6,000

Oluline info kuulsuste turniiri kohta Posted Tuesday 27th February, 2024 at 18:10(UTC+2) by maheaaatom

150 € sisseostuga kuulsuste turniiri algusaega on pisut edasi lükatud. Action pidi algama kell 19:30, kuid uue info kohaselt algab see kell 20:00. 

Alumisel korrusel on kohe algamas ka tervituspidu. Pakutakse jooke ja head muusikat, inimesi on kohal juba päris palju.

100 parimat Posted Tuesday 27th February, 2024 at 17:58(UTC+2) by maheaaatom

Oleme jõudnud saja parimani, tuntud tegijatest on väljas Andres Allsalu.

Player		Chips	Progress
Glen Kolmer		225,000	151,100
Meelis Meliste		190,000	103,700
Rain Kandla		160,000	101,000
Joonas Kulli		115,000	62,200
Kevin Didvig		115,000	19,300
Sander Leigri		90,000	17,700
Andres Allsalu		0	0
Stanislav Smeljov		0	0

Kole turn Martinile Posted Tuesday 27th February, 2024 at 17:52(UTC+2) by maheaaatom

Martin Kõiv on hetkel mängus 67K stäkiga, kuid tal võinuks olla ikka märksa rohkem.

Saatuslikuks sai käsi, mis mängiti vahetult enne viimast pausi. All-in mindi blindidel, vastas Thor Morstol ning pank umbes 260K.

Martin:

Thor:

Flop ja elu lill. Aga siis turn.... River meie meest ei päästnud. 

Player		Chips	Progress
Martin Kõiv		67,000	4,400

Aleksei imeline comeback Posted Tuesday 27th February, 2024 at 17:48(UTC+2) by maheaaatom

Nimekas pokkeriproff Aleksei Smirnov on hetkel mängus umbes 360K stäkiga. 

Kuidas ta aga selleni jõudis, on üsna imeline. Re-entry perioodi viimase käe eel oli Aleksei 2XBB, selle käe ta võitis ning jätkas 5XBB-ga, jättes stäkist loobumise võimaluse kasutamata. 

Sealt edasi on kõik lausa ideaalselt sujunud. "Seejuures olen ma kahel korral cooleritega 20XBB ära andnud, stäkki võiks rohkemgi olla," lisab mullu septembris Tallinnas ka WSOP Circuit kuldse meistrisõrmuse võitnud pokkeriproff.

Eestlaste stäkke Posted Tuesday 27th February, 2024 at 17:42(UTC+2) by maheaaatom

Ünsa hästi on edenenud WSOP Circuit Tallinn põhiturniiri kolmas mees Artur Külanurk, ka Igor Pihelal on õnnestunud nuppe juurde korjata.

Player		Chips	Progress
Igor Pihela vanem		290,000	50,000
Artur Külanurk		220,000	177,300
Erik Põlluveer		170,000	60,000
Tanel Merida		140,000	66,400
Tanel Evert		140,000	30,000
Aleksandr Kuperman		130,000	70,000
Magnus Pukk		110,000	90,000

Tarmo saab õhtule Posted Tuesday 27th February, 2024 at 17:33(UTC+2) by maheaaatom

Kings of Tallinnal jubaväga hästi esinenud Tarmo Tammel, kel on olemas üks teine ja üks kolmas koht, on kahjuks Championship'ilt väljas. Kas Tarmo läheb nüüd Omahatama? Vägagi võimalik!

Jätkab 121 parimat.

Player		Chips	Progress
Urmo Velvelt		0	0
Paul-Richard Argus		0	0
Vadim Guk		0	0
Tarmo Tammel		0	0

Algas kahepäevane 1100 € PLO Championship Posted Tuesday 27th February, 2024 at 17:14(UTC+2) by maheaaatom

Suures saalis läks äsja käima ka 1100-eurose osalustasuga PLO, mis vältab kaks päeva. Esialgu 22 mängijat.

Eesti lippu hoiavad kõrgel sellised tuntud tegijad nagu Markku Koplimaa, Allan Arjut, Georgi Voomets ning üleeile samas mänguformaadis teiseks tulnud Henrik Puija. 

17:11 (UTC+2)

Start of Level 16
Blinds: 2,000/5,000     Ante: 5,000

Igor on kenasti edenenud Posted Tuesday 27th February, 2024 at 16:52(UTC+2) by maheaaatom

Igor Pihela vanem läheb teisele pausile 240K stäkiga, järjest on kogunud juurde ka Aleksei Smirnov (230K). Mauri umbes 130K peal.

Kahjuks on out esimesel päeval väga kena mängu näidanud Hendry Kullamäe.

Player		Chips	Progress
Igor Pihela vanem		240,000	210,000
Aleksei Smirnov		230,000	110,000
Mauri Dorbek		130,000	21,000
Hendry Kullamäe		0	0

Turniiri võitja teenib 63360 eurot Posted Tuesday 27th February, 2024 at 16:36(UTC+2) by maheaaatom

Raha jagub 87 parimale ning võitja teenib 63 360 eurot. "Rahadesse pääsemine" tagab minimaalselt 1100-eurose preemia.

Lõplik sisseostude arv - 700 Posted Tuesday 27th February, 2024 at 16:31(UTC+2) by maheaaatom

Lõplikuks sisseostude arvuks jääb 700, kuna üks mängija ei ilmunud kahjuks kohale ning teda osalejate sekka ei arvestata.

Seega käib mäng täpselt 329 tuhandele eurole.

Maikelil jääb tiitel kaitsmata Posted Tuesday 27th February, 2024 at 16:29(UTC+2) by maheaaatom

Championshipi teine päev on jõudnud 155 parimani ning kahjuks on konkurentsist langenud mitmeid eestlasi, nende seas ka tiitlikaitsja Maikel Homin.

Player		Chips	Progress
Allan Arjut		0	0
Masoud Mirza		0	0
Ivo Rohula		0	0
Kaupo Tenno		0	0
Mati Pirn		0	0
Maikel Homin		0	0

Naistekas läks käima, osalejaid 24 Posted Tuesday 27th February, 2024 at 16:27(UTC+2) by maheaaatom

Teresa juhatas naisteturniiri sisse ning informeeris, et tasuta pileteid jagub täpselt viiele parimale. "Aga teeks äkki nii, et kõik 24 saavad?" kavaldab Catlin. 

Turniir toimub tõelises turboformaadis, kuid sellel on ka oma põhjus - kell 18:00 algab tervituspidu ning mõistagi soovitakse sellel ka kõiki naisi näha.

16:07 (UTC+2)

Start of Level 15
Blinds: 2,000/4,000     Ante: 4,000

Naised kogunevad Posted Tuesday 27th February, 2024 at 16:04(UTC+2) by maheaaatom

Alanud on väike kogunemine naismängijatele ning kohal on ka mitmed Eesti tipud nagu Kairit Leibold, Catlin, Müür, Ave Lepik, Kelly Limonova, Christel P. jpt. 

"Noh, kui tasuta jooke antakse, siis peab ju kohale tulema," viskab Kairit nalja.

Eestlaste dream-team täies koosseisus väljas Posted Tuesday 27th February, 2024 at 15:52(UTC+2) by maheaaatom

Ranno Sootlal õnnestus oma stäkk alguses küll enam kui kahekordistada, kuid mitte enamat. Selge oli muidugi ka see, et niisama tiksuma ja rahasid ootama Ranno kindlasti ei läinud, kindlasti mängis mees agressiivselt ja lahtiselt.

Player		Chips	Progress
Svjatoslav Plohhotnitsenko		0	0
Kris Tikka		0	0
Priit Vanem		0	0
Mairo Tori		0	0
Ranno Sootla		0	0

Eestlaste stäkke Posted Tuesday 27th February, 2024 at 15:48(UTC+2) by maheaaatom

Väga hästi on edenenud Aleksandr Kuperman, kes suutnud oma stäkki tänasega ligikaudu kuuekordistada ning on hetkel 200K peal. 

Ka vahepeal natuke ära andnud Magnus Pukk on 200K peal tagasi. 

Player		Chips	Progress
Aleksandr Kuperman		200,000	162,000
Magnus Pukk		200,000	22,200
Aleksei Smirnov		120,000	60,000
Kaupo Tenno		110,000	80,000
Erik Põlluveer		110,000	43,500
Tanel Evert		110,000	500
Kaarel Võhandu		90,000	48,600
Tarmo Tammel		60,000	23,000

Liigume turbokiirusel Posted Tuesday 27th February, 2024 at 15:35(UTC+2) by maheaaatom

"Seat out" aina kõlab ja kõlab ning allesjäänud mängijate arv on juba langenud alla 200.

Player		Chips	Progress
Richard Koppel		0	0
Eduard Kruglov-Arutiunian		0	0
Rasmus Aavisto		0	0
Mark Metsla		0	0
Rain Heeringas		0	0
Tarmo Anton		0	0
Tanel Tammela		0	0

15:30 (UTC+2)

Start of Level 14
Blinds: 1,500/3,000     Ante: 3,000

Paulile seekord Royaleid ei jagata Posted Tuesday 27th February, 2024 at 15:30(UTC+2) by maheaaatom

Paul Koppe meeldejääv triumf PLO turniiril jääb tõenäoliselt aastateks meelde, nagu ka erakordne võidukäsi turniiri viimases jaotuses.

Täna alustas Paul 30 000 punktiga, sai sellele küll natuke juurde, kuid jäi oma stäkist siiski just mõned minutid tagasi ilma. Viimane käsi PFAI vs. , Paulil oli selleks hetkeks umbes 8XBB ning vastasel õnnestus kuningas floppi hittida. 

Halvasti on käinud ka Eesti dream-tiimi Solid Puntamentals käsi. Väga lühikese ajaga langesid välja nii Markku Koplimaa, Tõnis Viik kui Oskar Ojaveer. Tiimi viimane liige Ranno Sootla hängib lauas umbes 75K stäkiga.

Player		Chips	Progress
Oskar Ojaveer		0	0
Markku Koplimaa		0	0
Tõnis Viik		0	0
Paul Koppe		0	0

Progress on korralik Posted Tuesday 27th February, 2024 at 15:22(UTC+2) by maheaaatom

Juba mullused Kings of Tallinn Championship turniirid olid igas mõttes rekordilised - veebruaris tehti sellele turniirile koguni 559 sisseostu, suvisel Summer Showdown'il koguni 573. Nüüd on neid aga tervelt 701.

Tiitlikaitsjaks on "suveturniir" võitja Maikel Homin, kel hetkel umbes 170K stäkk.

Player		Chips	Progress
Maikel Homin		170,000	55,400

Algas 250 € NLH Posted Tuesday 27th February, 2024 at 15:17(UTC+2) by maheaaatom

Fuajees läks käima tänane esimene kõrvalturniir, hetkel 49 osalejaga  250 € NLH. Hiline registreerumine on avatud umbes kuni kella 19:30-ni ehk ajani, mil läheb käima kauaoodatud kuulsuste turniir. 

Superässade stäkid Posted Tuesday 27th February, 2024 at 15:14(UTC+2) by maheaaatom

Turniiriga viimasel minutil liitunud Eesti high-rollerid on näidanud üldiselt päris head mängu. Parimana neist on Urmo jõudnud kiirelt juba umbes keskmise stäki peale.

Player		Chips	Progress
Urmo Velvelt		90,000	60,000
Ranno Sootla		75,000	45,000
Aleksei Smirnov		60,000	30,000
Markku Koplimaa		60,000	30,000

Täna ei olnud Martti päev Posted Tuesday 27th February, 2024 at 15:05(UTC+2) by maheaaatom

Martti Keel alustas päeva suuruselt teise stäkiga, andis alguses kõvasti ära ning on nüüd kahjuks mängust väljas.

Player		Chips	Progress
Martti Keel		0	0

Lõplikult väljalangenud Eesti mängijad Posted Tuesday 27th February, 2024 at 15:02(UTC+2) by maheaaatom

Eraldi tähelepanu väärib Martin Piik, kelle kuningad "kägistati" ära poolt. Martinil jäi küll 10K järgi, kuid sellega ta mängu tagasi tulla ei suutnud.

Player		Chips	Progress
Mart Rinken		0	0
Raimo Reimann		0	0
Viktor Blinov		0	0
Marko Vest		0	0
Aleksandr Gamonovits		0	0
Marius Morel		0	0
Toomas Nurme		0	0
Anton Pereyaslov		0	0
Maksim Petrov		0	0
Vladislav Han		0	0
Mart Tammoja		0	0
Siim Suviste		0	0
Dmitri Dudakov		0	0
Risto Pärnat		0	0
Herli Olop		0	0
Martin Piik		0	0
Artjom Kovalevski		0	0

Saimegi 700 sisseostu täis! Posted Tuesday 27th February, 2024 at 14:54(UTC+2) by maheaaatom

Mäng jätkub ning esialgsetel andmetel on sisseostude lõplik arv 701. Mängus on 244 pokkerisportlast ning pangas 329 740 eurot.

Superässadest liitusid mänguga ka Ranno Sootla ja Urmo Velvelt.

14:52 (UTC+2)

Start of Level 13
Blinds: 1,000/2,500     Ante: 2,500

Kui ei saa üles, siis ei saa Posted Tuesday 27th February, 2024 at 14:27(UTC+2) by maheaaatom

Herli Olop kolmas bullet lendab samuti tuulde, viimaseks käeks vs. . Seejuures saab Herli turnil veel Royali tõmbe, kuid sellist õnne nagu üleeile Paul Koppel, tal paraku ei ole. 

Hetkeseisuga Herli edasisest mängust loobub. Aga ei saa välistada, et pausi ajal mõtleb mees ümber. Mängijad lubatigi just 20 minutiks jalgu sirutama.

Viimased kolm re-entry kätt Posted Tuesday 27th February, 2024 at 14:22(UTC+2) by maheaaatom

Paus on peagi käes ning mängijatel lubatakse veel kolm kätte "gämmelda". 700 sisseostust on veel 14 puudu ning pole välistatud, et maagiline tähis saab ka ületatud. 

Re-entry on lubatud kuni pausi lõpuni. Juhul kui mõnel mängijal on väga vähe nööpe (n. 5000 punkti), siis võib ta soovi korral oma stäkist ka loobuda ning ikkagi re-entry teha. 

Mauri ja Magnus on samuti loovutanud Posted Tuesday 27th February, 2024 at 14:16(UTC+2) by maheaaatom

Päeva TOP10 stäkkidega alustanud Magnus Pukk ja Mauri Dorbek on samuti ära andnud, mõlemal umbes 120K järgi.

"Karm mäng on," võtab Mauri esimesed tasemed kokku. Pilte on ta väga harva näinud, korra sai vaid ja korra pocket viied. Nii on raske.

Flippama! Posted Tuesday 27th February, 2024 at 14:11(UTC+2) by maheaaatom

Pausini on jäänud veel kümmekond minutit juba juba teavitatakse ka kõiki mängijaid, et soovi korral saab seda kasutada flippidel osalemiseks. 

Üks flip maksab 150 eurot ning kui sul veab, oled teeninud koha 3. märtsil toimuvasse finaali, kus on mängus ka Mystery Bountyd, mis ulatuvad kuni 10 000 euroni. 

Artjom uuele katsele Posted Tuesday 27th February, 2024 at 14:04(UTC+2) by maheaaatom

Artjom Kovalevski viimased nupud lähevad sisse 3-way all-in'is -ga ja vastu. 

Õnnega on koos neljade omanik Nils Burman, kes suudab riveriks rea lauda saada.

Herli kasutab kolmandat bulletit Posted Tuesday 27th February, 2024 at 13:54(UTC+2) by maheaaatom

Herli istub lauas algstäkiga ning tõdeb, et pole veel õieti millelegi pihta saanud. "Aga tuleb mängida, vajadusel kasutan ühte bulletit veel. 300K on ikka 300K, selle raha nimel tuleb mängida," sõnab mees ise. 

Viimasel aastal on Herli suurepäraselt mänginud ning pea kõikidel suurematel turniiridel mingi cashi ikka kätte saanud. Oktoobris toimunud Battle of Malta põhiturniiril, kus tehti pea 3500 (!) sisseostu, oli ta koguni kaheksas.

Martti on ära andnud Posted Tuesday 27th February, 2024 at 13:51(UTC+2) by maheaaatom

Teist päeva suuruselt teise stäkiga alustanud volle- ja pokkeriäss Martti Keel suutis päeva alguses ka üle 200K tõusta, kuid pidi pärast seda kahjuks suurema osa oma stäkist ära andma. 

"Jäin blufiga vahele. Aga ta tegi väga hea calli ka," tunnustas Martti vastast. Hetkel tal umbes 80K alles.

Player		Chips	Progress
Martti Keel		80,000	103,700

Viimane re-entry tase Posted Tuesday 27th February, 2024 at 13:46(UTC+2) by maheaaatom

Sisseostude arv on kasvanud juba 644-ni ning hetkel istub laudades 269 mängijat. 300K auhinnafondi täitumine on tõenäoliselt ainult minutite küsimus :)

13:45 (UTC+2)

Start of Level 12
Blinds: 1,000/2,000     Ante: 2,000

Uued ässad, kes täna mängu tulid Posted Tuesday 27th February, 2024 at 13:19(UTC+2) by maheaaatom

Nii mõnigi mängija on turniiriga liitunud alles täna ning selles nimekirjas on mitmeidki aukartust äratavaid tegelasi. Näiteks Igor Pihela vanem, Paul "Royal Flush" Koppe, Eesti läbi aegade edukaim turnamängija Markku Koplimaa aga ka Martin Piik ja Mati Pirn.

Teist päeva ministäkiga alustanus Allan Arjut on juba jõudnud re-entry teha, mis on igati loogiline samm.

Hetkel 286 mängijat ning 300K auhinnafondist on puudu vaid 14400 eurot. Tõenäoliselt selleni ka jõutakse, sest re-entry perioodi lõpuni on veel tund aega.

Mis on täna veel kavas? Posted Tuesday 27th February, 2024 at 13:11(UTC+2) by maheaaatom

Täna tasub kindlasti Olympic Park Casinosse kohale tulla, sest päev saab olema väga põnev. Kell 18:00 toimub Olympic Casinos avapidu koos tervitusjookide ja esinejatega. Sellele järgneb kell 19:30 algav kuulsuste eriturniir, mille sisseost on 150 eurot. Nimekirjas on palju tõeliselt põnevaid tegelasi!

Lisaks viiakse läbi 250 € NLH 8-handed (algab kell 15:00) ning antakse stardipauk ka kahepäevasele 1100 € Pot-Limit Omaha Championship 6-max 4/5 Cards turniirile (kell 17:00).  Päeva lõpetab põhiturniiri megasatelliit (10 x 1100 piletit GTD), mis algab kell 22:00.

Kuulsuste turniiri freeroll on alanud Posted Tuesday 27th February, 2024 at 13:08(UTC+2) by maheaaatom

Kuulsuste turniiri freerollil on juba laudades 87 mängijat ning liitumiseks on aega 2 tundi ehk umbes kell 15:00-ni. Viis parimat saavad 150 € pileti. 

13:03 (UTC+2)

Start of Level 11
Blinds: 1,000/1,500     Ante: 1,600

Tähelepanuks naistele! Posted Tuesday 27th February, 2024 at 13:00(UTC+2) by maheaaatom

Head naised, palume teie tähelepanu!

Täna kell 16:00 toimub Sidney Roomis eriline ainult naistele mõeldud freeroll, mille auhinnafondis on 5x150 € naisteturniiri piletit. Tasub kohale tulla!

Täna mängime finaallauani või kuni kella 02:00-ni Posted Tuesday 27th February, 2024 at 12:57(UTC+2) by maheaaatom

Täna on plaanis mängida kuni finaallauni, kuid kuna mängijaid on tõesti väga palju, siis võib juhtuda, et selle eesmärgi saavutamiseks kulub väga kaua aega. 

Hulluks ei minda, mängitakse maksimaalselt kuni kella kaheni öösel. "Mängijad peavad saama puhata. Kui selle ajaga finaalini ei jõuta, siis võime jätkata ka homme kahel-kolmel laual," kommenteerib turniiridirektor Teresa.

Eilne kokkuvõte läbi filmilindi Posted Tuesday 27th February, 2024 at 12:48(UTC+2) by maheaaatom

Frerollima! Posted Tuesday 27th February, 2024 at 12:48(UTC+2) by maheaaatom

Kõigil, kes tahavad tulla täna õhtusele Celebrity Special turniirile, paremal juhul näiteks BSH enda kõrval istuda ning seda seejuures veel täiesti tasuta, tasub osaleda kell 13:00 algaval freebuy-satelliidil. 

5 x 150 € piletit on garanteeritud, lubatud on ka 10-eurose re-buyd ja add'on. 

Eesti tiimi TIME edukas õhtu Posted Tuesday 27th February, 2024 at 12:44(UTC+2) by maheaaatom

Eesti pokkeriässade tiimil TIME oli eile väga edukas õhtu:

- 52 sisseostuga 250 € Deuce to Seven Pot Limit Triple Draw võitis soomlane Miko Miettinen, kuid TIME liikmetest oli Marius Morel teine ja Allan Arjut neljas. Nende vahele kiilus ka tuntud Eesti pokkeripersoon Jaan Vaabel. 

- 350 € NLH Progressive Bounty said nii Tarmo Tammel kui Pekka Ikonen 7400 eurot, võit läks paraku küll soomlasele. 

"Me võtsime peaaegu maksimumi," on tiimi liige Allan Arjut rahul. "Tammel ja Morel läksid mõlemasse FT-sse chipleadritena, kuid kirkamad medalid jäid seekord vormistamata," lisab Allan.

Tiimide lõplik seis pole hetkel veel teada, kuid eestlased teevad kindlasti väga suure tõusu.

Sihikul 300 tuhat või enam Posted Tuesday 27th February, 2024 at 12:35(UTC+2) by maheaaatom

Juba praegu on selge, et senised Kings of Tallinn Championshipi rekordid ületatakse täna päris kindlasti, sest auhinnafond on juba praegu 269 500 eurot ning hiline registeerumine/re-entry kestab veel 3 mängutaset ehk umbes kuni kell 14:20- ni. 

Kes tahavad nüüd liituda, pääsevad lauda üsna mängitava 25XBB-ga. Seega, mida varem kohale tuled, seda parem.

Mäng on alanud Posted Tuesday 27th February, 2024 at 12:33(UTC+2) by maheaaatom

Nagu arvata oli, siis algus natuke venis, sest garderoobi järjekord ulatus Kunderi tänava otsani. 

Aga mängid on kenasti laudades ning hetkel tehtud juba pea 300 sisseostu.

12:32 (UTC+2)

Start of Level 10
Blinds: 600/1,200     Ante: 1,200

Turniir teine päev algab kell 12:00 Posted Tuesday 27th February, 2024 at 10:58(UTC+2) by maheaaatom

555 € Championship-turniiri teine päeb algab teisipäeval kell 12:00 ning kuna seda alustab koguni 250 unikaalset mängijat, soovitame kõikidel osalejatel varakult kohale tulla. 

Eestlasi on hetkel kümne parima seas kolm, Martti Keelel on 183 700, Magnus Pukil 177 800 ning Mauri Dorbekul 151 000 punkti.

10:55 (UTC+2)

Day 2 of Kings of Tallinn 2024 Started
Level: 9     Blinds: 600/1,200     Ante: 1,200

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter