0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0105 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1_est'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1_est', 1, '2024-11-22')

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

0.0004 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.0003 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.0004 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

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

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

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

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

0.0003 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0005 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

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

0.0040 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0005 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'wsopctallinn_2023_event1_est'

0.0006 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'

0.0326 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0089 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '95'
AND `published` = 1

0.0270 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '105'
AND `published` = 1

0.0275 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '107'
AND `published` = 1

0.0277 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0063 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '110'
AND `published` = 1

0.0277 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0062 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '114'
AND `published` = 1

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '114'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'
AND `name` = '2'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    

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(1)
  • 888poker UK Poker League(0)
  • APAT(2)
  • APPT(1)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(0)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(3)
  • EPT(4)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(5)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(1)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • Kings of Vilnius(1)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(13)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(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(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(1)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(0)
  • Unibet DeepStack Open(3)
  • Venetian Deepstack Extravaganza(3)
  • Women's Winter Festival(1)
  • WPT(4)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(16)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• 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
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

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

WSOPC Tallinn Event #1: €555 No-Limit Hold'em (Estonian) Live Reporting - Day 2

WSOPC Tallinn - Live Reporting

Event #1: €555 No-Limit Hold'em (Estonian) See other events

Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)

WSOPC Tallinn - Live Reporting Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)

---

Current Level 25 Current Day 2

---

Blinds 20,000/40,000 Ante 40000

Entries 382 Remaining 1

---

Prize Pool (EUR) €183,360 First Prize (EUR) €34,435

Chip Leaders Day 2

1

Viacheslav Sultanov

11,460,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

555 € NLH Ring Event #1 võitis ukrainlane Viacheslav Sultanov Posted Sunday 17th September, 2023 at 17:15(UTC+3) by maheaaatom

Esimese WSOP Ring Eventi finaallaud vältas vaid neli tundi ning võit läks Ukrainasse.

Hinnalise WSOP meistrisõrmuse ning 34435 € auhinnaraha teenis Ukraina pokkerimängija Viacheslav Sultanov. Palju edu ka WSOP Tournament of Championsil Las Vegases!

TV-stream Posted Sunday 17th September, 2023 at 13:58(UTC+3) by maheaaatom

Finaallauas toimuvat saad jälgida siit (klõpsa lingile selle avamiseks). Ülekanne on 30-minutilise viivitusega.

Finaallaud on koos Posted Sunday 17th September, 2023 at 00:04(UTC+3) by maheaaatom

Finaallaua mullimeheks jääb leedulane Dominykas Ruskys ning kõik allesjäänud jätkavad mängu homme keskpäeval. Finaali läheb liidrina norralane Torbjörn Larsen.

Toimuvale saab kaasa elada läbi TV-laua otseülekande, mille lingid lisame ka siia ülekandesse. Meie programm jätkub samuti homme keskpäeval, mil võtame peamise vaatluse alla WSOP #3 350 Ring Event'i, kuid hoiame silma peal ka 555 € ja 1100 € finaallaudadel ning muul põneval.

Head ööd!

Player		Chips	Progress
Torbjörn Larsen		2,445,000	2,415,000
Pawel Fraczek		1,640,000	1,610,000
Charles Benoit		1,400,000	110,000
Viacheslav Sultanov		1,115,000	50,000
Mikael Naski		995,000	175,000
Mikael Lundström		555,000	525,000
Petras Boguzas		555,000	525,000
Georgios Skarparis		550,000	265,000
Jonathan Mandara		210,000	180,000

11. koht Martin Piik 3000 € Posted Saturday 16th September, 2023 at 23:36(UTC+3) by maheaaatom

Martin pidi lükkama ning -ga võis selles olukorras kindlasti rahul olla (3XBB). Paraku oli Petras Boguzasel ning selle vastu jäi Martin võimetuks. 

Vahetult enne Martinit langes välja ka vahepeal turnat juhtinud leedukas Jonas Ruginis. Seega on hetkel käimas finaallaua mullimäng. 

Player		Chips	Progress
Martin Piik		0	0
Jonas Ruginis		0	0

13. koht - Viktor Blinov 2450 € Posted Saturday 16th September, 2023 at 23:27(UTC+3) by maheaaatom

Eesti mängijad on tõelises kriisis - nagu oleks vähe Tõnise ja Andrese kaotusest, langes kohe nende järel ka Viktor. 

Viktor Blinovil on kirjas ainult üks pisike Hendoni cash. Mais sai ta viimasel Olympic Casinos toimunud Win TV Live'il üheksanda koha ning võitis 220 eurot. Nüüd lisandub sellele juba märksa suurem summa - 2450 €.

Eestlaste au jääb ainsana kaitsma Martin Piik, kellel on imepisike umbes 4XBB stäkk. Aga miski pole võimatu.

Player		Chips	Progress
Viktor Blinov		0	0

23:22 (UTC+3)

Start of Level 25
Blinds: 20,000/40,000     Ante: 40,000

14. koht - Andres Leppik 2450 € Posted Saturday 16th September, 2023 at 23:16(UTC+3) by maheaaatom

15XBB-le langenud Andres Leppik läks SB-lt shovema ning kukkus otseteed BB pocket ässade otsa. Midagi polnud teha, kuid tulemus siiski väga hea. 14. koht tõi sisse 2450 eurot.

Player		Chips	Progress
Andres Leppik		0	0

15. koht - Tõnis Viik 2450 € Posted Saturday 16th September, 2023 at 23:12(UTC+3) by maheaaatom

Üsna uniseks muutunud mängu lõpetas korralik pauk 18. lauas, kus preflopis läksid all-in kolm mängijat.

Viacheslav Sultanov:

Mikael Lundström:

Tõnis Viik:

Lauda jooksis kuningas. Kuna Tõnise stäkk oli kõige väiksem ning ta kaotas ka mõlemale vastasele, on meie mees kahjuks mängust väljas. Ukrainlasel oli Lindströmist enne saatuslikku jaotust küll palju suurem stäkk, kuid valus kaotus viis sellest umbes poole minema.

Näete, kui palju võivad seisud muutuda. Polnud ammu, kui Lindström ägises oma 5XBB-ga...aga kõik all-in'is on ta kenasti pihta saanud ning nüüd koguni turniiri liider. 14 mängijat jätkab.

Player		Chips	Progress
Tõnis Viik		0	0

Põhiturniiri satelliidil tuligi taas overlay Posted Saturday 16th September, 2023 at 23:01(UTC+3) by maheaaatom

Seekord maksid korraldajad mängijatele peale 2700 €, jäi 82 sisseostu (100 olnuks vaja garantii täitumiseks). NB! Sama turniir on kavas ka pühapäeval ja esmaspäeval, soovitame silma peal hoida.

"Hiinakal" on alles viis parimat, eestlased jäid esikümne piirimaile ehk rahadest kaugele.

1100 € NLH Ring Event #2 on jõudnud 24 parimani. Eestlasi on mängus viis: Ermo Kosk, Kaspar Valk, Aleksei Smirnov, Andrey Koks ja Tanel Evert. 

2-7 Triple Draw satikas on osutunud isegi ootamatult populaarseks (paistab, et on neid segamängude huvilisi küll) - tehtud on 26 sisseostu.

TOP3 + Eesti mängijate stäkid Posted Saturday 16th September, 2023 at 22:46(UTC+3) by maheaaatom

Liidrid vahetuvad pidevalt, vahepeal suuurelt juhtinud norrakas Jon Kyte on üldse 16. kohaga mängust väljas. 

Hetkel on esikolmikus hoopis Kanada, Soome ja Ukraina mängija. Eesti hobimängija Viktor Blinovi leiame kohe nende järelt neljandalt kohalt.

Player		Chips	Progress
Charles Benoit		1,290,000	1,260,000
Mikael Naski		1,170,000	1,140,000
Viacheslav Sultanov		1,065,000	1,035,000
Viktor Blinov		975,000	355,000
Andres Leppik		755,000	95,000
Tõnis Viik		570,000	80,000
Martin Piik		195,000	225,000

22:42 (UTC+3)

Start of Level 24
Blinds: 15,000/30,000     Ante: 30,000

Tänane viimane paus? Posted Saturday 16th September, 2023 at 22:30(UTC+3) by maheaaatom

Mängijad lubati 20 minutiks puhkama, endiselt on 16 parimat järgi. 

On suur tõenäosus, et järgmise 4 x 30 min. tsükliga saab finaallaua koosseis selgeks. Viimase tsükli alguses on blindid 40K/80K, mis tähendab, et BB on 146x kõikide nuppude kogusumma.

Tõnis annab väikese duubli Posted Saturday 16th September, 2023 at 22:17(UTC+3) by maheaaatom

Blindidel on Tõnis Viik ning rootslane Mikael Lundström. Ilmselgelt läheb Tõnis suruma, kuid paraku leiab Mikael käest pocket poisid. Ja Tõnisel kõigest

Turni järel on vastasel pulss üleval, sest maas on mastitõmme. Rootslane õnneks ning Tõnise kahjuks siiski river midagi ei muuda.

Re-draw Posted Saturday 16th September, 2023 at 21:56(UTC+3) by maheaaatom

Pärast Johan Grave langemist on turniiril on lühike tehniline paus, mille jooksul viiakse läbi re-draw. 

Edasi jätkame kahel laual, alles on 16 parimat. Nende seas nii Tõnis, Andres, Viktor kui Martin. Tõenäosus, et eestlane WSOP Circuit'i võidab, on seega täpselt...25%.

18. koht - Maksim Solodilov 1550 € Posted Saturday 16th September, 2023 at 21:49(UTC+3) by maheaaatom

Maksim jättis endast turniirist väga tagasihoidliku mulje. Samas mängis kannatlikult, ootas omi kohti ning tõusis vahepeal ka liidrite sekka. 

Enne väljalangemist oli tal umbes 5-6BB stäkk, seega mänguruum lihtsalt puudus.

Player		Chips	Progress
Maksim Solodilov		0	0

Põhiturniiri satelliit kisub jälle overlay suunas Posted Saturday 16th September, 2023 at 21:47(UTC+3) by maheaaatom

Pausini on jäänud 20 minutit ning tehtud 68 sisseostu. Vaevalt küll, et sajani jõutakse.

Kell 21:00 algab tänane viimane satelliit, 60-eurone 2-7 Triple Draw. Parimale viiele on nähtud ette 555 € pilet homme algavale sõrmseturniirile nr. 4, mis viiakse samuti läbi 2-7 Triple Draw formaadis. Segamängude austajad - lennake peale!

21:43 (UTC+3)

Start of Level 23
Blinds: 10,000/25,000     Ante: 25,000

Martin jaksab oodata Posted Saturday 16th September, 2023 at 21:40(UTC+3) by maheaaatom

Shortstackiga virelevast Martin Piigist käis üle blindiring, lisaks üritas mees ka ühel korral ise blinde "varastada", kuid sai ületõste vastu. Kolmandik stäkist läinud nagu niuhti...

Aga viimaks leidis ta ikkagi õige koha, kust oma -ga lükata ning saada sellele ka poolt call.

Lauast kumbki midagi ei saanud, kicker mängis. Martinil nüüd 420K. Ja finaallaud tuleb järjest lähemale, sest saime vahepeal lahti ka kahest soomlasest.

Player		Chips	Progress
Martin Piik		420,000	210,000

Viie meie mehe stäkid Posted Saturday 16th September, 2023 at 21:32(UTC+3) by maheaaatom

Väga hästi on edenenud Andres Leppik, kelle stäkk on juba selgelt üle keskmise. Ka Tõnis Viik purjetab pärituules.

Player		Chips	Progress
Andres Leppik		850,000	500,000
Tõnis Viik		650,000	70,000
Viktor Blinov		620,000	120,000
Martin Piik		210,000	10,000
Maksim Solodilov		200,000	70,000

22. koht - Anatoly Filatov, 21. koht - Ranno Sootla - 1550 € Posted Saturday 16th September, 2023 at 21:25(UTC+3) by maheaaatom

Mõlemad mehed olid väga shordid (stäkk alla 10XBB), mistõttu tuleb väljalangemist pidada asjade loomulikuks käiguks.

Kahju on sellest muidugi küll. Tegemist ikkagi ülimalt kõvade mängumeestega, kes eeskujuks paljudele.

Player		Chips	Progress
Ranno Sootla		0	0
Anatoly Filatov		0	0

Kiita see seis just pole Posted Saturday 16th September, 2023 at 21:09(UTC+3) by maheaaatom

Vaid Tõnis Viigil on pisut üle keskmise stäkk ning Viktor Blinovil umbes keskmisega võrdne. Kõik teised jäävad sellele juba alla.

Hetkel on blindid 10K/20K ning keskmine stäkk seega 25XBB. Ei ole just väga palju mänguruumi...

Player		Chips	Progress
Tõnis Viik		580,000	400,000
Viktor Blinov		500,000	380,000
Andres Leppik		350,000	30,000
Maksim Solodilov		270,000	25,000
Anatoly Filatov		250,000	340,000
Ranno Sootla		220,000	250,000
Martin Piik		200,000	100,000

Telepurgis on Taago Tamm! Posted Saturday 16th September, 2023 at 21:01(UTC+3) by maheaaatom

24. koht - Risto Pärnat 1550 € Posted Saturday 16th September, 2023 at 20:56(UTC+3) by maheaaatom

Lõviosa Risti Pärnati nööpidest läheb Charles Benoit'le. Flopis on avatud , turn on . 

Charles checkib ette, Risto paneb 40K ning vastane lükkab all-in. Ristolt call. 

Mõlemad said kolmikult pihta, kuid Risto kicker oli Charles'i vastu. Kuna river oli blank, siis sellest piisas.

Ristol jäi paarkümmend tuhat järgi, millega ta oli järgmises jaotuses sisuliselt sund all-in. Ei tulnud sealt ka midagi.

Seega olema jõudnud 23 parimani ning tehti ka re-draw, et mägnida edasi kolmel laual. Igaks juhuks võime veel mainida, et 26. koha sai näiteks Tallinnas korduvalt hästi mänginud WSOPC sõrmuseomanik Glen Gaines.

Player		Chips	Progress
Risto Pärnat		0	0

20:44 (UTC+3)

Start of Level 22
Blinds: 10,000/20,000     Ante: 20,000

Kuidas läheb tonnine turniir? Posted Saturday 16th September, 2023 at 20:41(UTC+3) by maheaaatom

Kell 14:00 alanud 1100 € Ring Eventiga on veel võimalik liituda, juba on kirjas tervelt 102 sisseostu. 

Järel on 42 mängijat, nende hulgas ka näiteks Ermo Kosk, Markku Koplimaa, mõlemad Pihelad ja Aleksei Smirnov. Seegi turniir mängitakse täna kuni finaallauani ning homne finaal viiakse läbi juba telelauas.

Jätkuvad ka hiinakas (27 sisseostu, Mati Pirn ja Eha Pinsel endiselt sees) ning kulminatsioonile on üsna lähedal ka rahvaturniiri satikas (17 järgi, välja antakse vähemalt 10 piletit). 

Alanud on ka põhiturniiri megasatikas Posted Saturday 16th September, 2023 at 20:37(UTC+3) by maheaaatom

Nii neljapäeval kui reedel korralikku overlayd pakkunud 10 x 1500 € põhiturniiri megasatikas on samuti alanud. 

Süsteem sama, sisseost 150 eurot ning 10 parimat saavad põhiturniiri pilet. Hetkel on 42 sisseostu tehtud, "piirid" saavutatakse saja sisseostuga. Aega veel liituda kuni kella 21:00-ni. 

Anatoly annab soomlasele duubli Posted Saturday 16th September, 2023 at 20:33(UTC+3) by maheaaatom

555 € turniir on jõudnud 26 parimani, meie kaheksane tiim on endiselt sees. 

Anatoly Filatovil õnnestus korraks jälle üle 700K tõusta, nüüd tuli küll üks umbes 150K duubel anda. Nupud läksid soomlase Mikael Naski vastu pärast floppi , mis mõlemale hästi sobis. 

Anatoly:

Mikael:

River tõi lauda rea ning põhjanaabrile vajaliku duubli.

Kõrvallauas madistavad omavahel Ranno Sootla ja Tõnis Viik. Kahel korral on Ranno enne floppi tõstnud, kuid mõlemal korral on positsioonil olnud Tõnis all-in'iga vastanud. Ranno stäkk on langenud juba natuke alla keskmise, nii 400K peale.

Mäng jätkub, TOP3+ eestlaste täpsed stäkid Posted Saturday 16th September, 2023 at 20:15(UTC+3) by maheaaatom

Turniiri juhib norralane Jon Kristian Kyte, teine koht kuulub kreeklasele ja kolmas leedukale, kuid mäng on niivõrd kiire, et kõik võib kiirelt muutuda.

Nagu manitud, mängus on kaheksa Eesti esindajat, kellest kolmel on TOP10 stäkid.

Player		Chips	Progress
Kristian Kyte		990,000	420,000
Georgios Skarparis		815,000	265,000
Jonas Ruginis		655,000	15,000
Anatoly Filatov		590,000	190,000
Risto Pärnat		470,000	30,000
Ranno Sootla		470,000	80,000
Andres Leppik		320,000	12,000
Martin Piik		300,000	80,000
Maksim Solodilov		245,000	120,000
Tõnis Viik		180,000	70,000
Viktor Blinov		120,000	30,500

20:09 (UTC+3)

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

35. koht - Hanno Kerem, 34. koht - Sami-Sander Kivi, 32. koht - Roland Luik - kõik 1100 € Posted Saturday 16th September, 2023 at 19:15(UTC+3) by maheaaatom

Turniirilt pudeneb mängijaid niivõrd kiiresti, et käsi jälgida on suhteliselt võimatu ning kassas on lausa väike järjekord moodustunud.

Oleme jäänud ilma veel kolmest eestlasest. Vähemalt on nad kõik rahades  - nagu ka suhteliselt tundmatu Sami-Sander Kivi, kolmekordne Eesti meister Hanno Kerem kui paljude lemmik Roland Luik. Mängu jätkab kaheksa Eesti värvide kaistjat.

Konkurentsis püsib 31 mängijat ning küllap on finaallaud juba märksa varem kui südaööks teada. Pisut pidurdab suurt tempot vaid õhtusöögipaus. Me oleme tagasi 60 minuti pärast ehk umbes kell 19:10. 

Player		Chips	Progress
Sami-Sander Kivi		0	0
Hanno Kerem		0	0
Roland Luik		0	0

43. koht Dmitri Dudakov, 42. koht Rauno Remmel - mõlemad 1000 € Posted Saturday 16th September, 2023 at 19:05(UTC+3) by maheaaatom

Dmitri alustas turniiri viienda stäkiga ning sihid olid kindlasti kõrgemad, kuid vähemalt rahadesse ta jõudis.

Rauno Remmelil on väga lühike "Hendoni-ajalugu", siit tuleb vähemalt üks cash juurde.

Player		Chips	Progress
Rauno Remmel		0	0
Dmitri Dudakov		0	0

Endalegi ootamatu võit? Posted Saturday 16th September, 2023 at 19:02(UTC+3) by maheaaatom

Pangas on norrakas Kjetil Hanstvedt ning meie Ranno Sootla. Esimene üritab survet avaldada, teine konkurenti üle mängida.

Flopi järel panustab norralane 23K ning saab Rannolt calli.

Turn on , kas ühel või mõlemal mängijal majad? Kumbki ei panusta.

River on ning nüüd teeb juba Ranno 35K panuse. Kjetil callib hirmsa ägina järel, tema ainuke lootus on see, et Ranno mängib ässa-kickerile.

Norralasel on , Rannol ! Rida ja pank talle. 

12 eestlast Posted Saturday 16th September, 2023 at 18:48(UTC+3) by maheaaatom

Meie andmetel on mängus tosin eestlast. Tõsi, Dmitri Dudakovi nende seas enam pole.

Tegelikult pole ju üldse paha seis. Mäng on muiudgi väga kiire ning juhtuda võib kõike - nii positiivses kui negatiivses võtmes. All-in kostub endiselt pea igal minutil ning mis seal imestada - keskmine stäkk on umbes 25 X BB.

Player		Chips	Progress
Dmitri Dudakov		0	0

Mull on lõhkenud, palju õnne allesjäänutele Posted Saturday 16th September, 2023 at 18:43(UTC+3) by maheaaatom

All-in ja call oli samaaegselt koguni kolmes lauas. 

Esimeses duubeldas vastu.

Teises flipati: vs. , lauda veel üks poiss ning poiste omanikul väga napilt suurem stäkk.

Kolmandas lauas oli all-in'is olev mängija selgelt eest ( vs. ) ning ka võitis.

Seega jääb mullimeheks lätlane Matiss Celmins.

13 hiinlast Posted Saturday 16th September, 2023 at 18:28(UTC+3) by maheaaatom

"Las Vegase" nime kandvas toas on juba mõnda aega käimas nn. "kallis hiinakas". Mäng sama (OFC Pineapple), kuid sisseost suurem kui neljapäeval ehk 350 eurot. 

Osaleb ka kaks eestlast, Mati Pirn ja Eha Pinsel. Istuvad muide ka ühes lauas.

Unlimited re-entry kestab 180 minutit. 

Risto Pärnat pääses napilt mullist Posted Saturday 16th September, 2023 at 18:19(UTC+3) by maheaaatom

Risto Pärnat avastas end väga ebamugavas seisus all-in'is - pocket kuningatega pocket ässade vastu.

Aga seekord oli pokkerujumal eestlane. Turni kuningas ning mäng jätkub. Ristol nüüd väga korralik 440K stäkk!

Player		Chips	Progress
Risto Pärnat		440,000	193,000

18:15 (UTC+3)

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

Algas mullimäng Posted Saturday 16th September, 2023 at 18:15(UTC+3) by maheaaatom

Iirlane James Noonan lükkab oma pisikese, ca 50K stäki keskele ning saab calli buttonil istuvalt Tõnis Viigilt.

James:

Tõnis:  

Lauda veel üks kuus ja iirlane mängust väljas. Sellega koos algas ka mullimäng, sest alles on vaid 48 parimat. Mängitakse hand-by-hand.

Player		Chips	Progress
Alexander Nemchin		0	0

Kas "milliseid" stäkke ka on? Posted Saturday 16th September, 2023 at 18:03(UTC+3) by maheaaatom

Seda uurib Roland Luik, kuid peame talle vastama, et veel ei ole. Turniiri juhib Jonas Ruginis, kel on natuke üle 700K.

Filatov on oluliselt ära andnud, paistab et kreeklasele Skarparisele. Viimasel on tubli 550K, Filatovil vaid pisut üle 400K.

Rannol sama seis, ikka umbes 550K. Ranno on aktiivne ja agressiivne, mis on talle taganud ka piisava respekti.

Avapäeval välismaalastest floorile usinalt Eesti numbreid ning nende moodustamist õpetanud Rauno Remmel püsib samuti visalt mängus, tal ligikaudu keskmine stäkk. Dmitri Dudakov on veel natuke ära andnud (140K), Martin Piik istub aga stabiilselt 220K peal.

Player		Chips	Progress
Georgios Skarparis		550,000	520,000
Anatoly Filatov		400,000	260,000
Martin Piik		220,000	188,500
Rauno Remmel		200,000	152,000
Dmitri Dudakov		140,000	40,000

17:56 (UTC+3)

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

Roland saab olulist lisa Posted Saturday 16th September, 2023 at 17:49(UTC+3) by maheaaatom

Sergei Guljajev pushib keskelt oma ca. 60K stäki keskele ning blindi kaitsev Roland Luik instacallib.

Sergei:

Roland: . Kuigi river on kaheksa, peavad poisid ilusti. Rolandil nüüd 200K, mis pole küll hirmsuur, kuid pisut üle keskmise ja annab mänguruumi juurde. 

Oleme jõudnud viie koha kaugusele mullist.

Player		Chips	Progress
Roland Luik		200,000	110,000

Päevad pole vennad Posted Saturday 16th September, 2023 at 17:38(UTC+3) by maheaaatom

Väljas on ka teist päeva chipliidrina alustanud Raivo Pinsel.

Raivol oli megahea esimene päev, kuid teisel ei sujunud õieti midagi. Stäkk aina langes ja langes, kuniks vastased selle täielikult ära õgisid.

54 parimat järgi, veel vaid seitse kohta mullini.

Player		Chips	Progress
Raivo Pinsel		0	0

Jõujooned endised Posted Saturday 16th September, 2023 at 17:36(UTC+3) by maheaaatom

Kahju on Martin Vennost, kes siiski ei suutnud rahadesse jõuda. Eks laud oli ka suhteliselt keeruline. Viimased nööbid läksid -ga Ranno Sootla vastu, kuid see oli juba ebaoluline jaotus, sest Martinil oli selleks hetkels tõesti vaid paar BB-d järgi.

Ranno peaks aga olema turniiril suuruselt neljas stäkk ning vahed on õige väikesed. Filatov endiselt juhib, tal ca. 660K.

Player		Chips	Progress
Anatoly Filatov		660,000	263,000
Jonas Ruginis		640,000	610,000
Kristian Kyte		570,000	540,000
Ranno Sootla		550,000	521,000
Arko Akenpärg		0	0
Martin Venno		0	0

17:27 (UTC+3)

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

Mull läheneb hirmuäratava kiirusega Posted Saturday 16th September, 2023 at 17:27(UTC+3) by maheaaatom

Oleme jõudnud juba 59 parimani. Kümne parima seas paistab olevat neli Eesti mängijat, Filatov on neist endiselt suurim stäkk, kuid üsna napilt. 

Jätkajate seas on meie arvestuse kohaselt 18 eestlast.

"Suures saalis" on nüüd ka märksa rohkem suminat kui varem, sest siia toodi ka 1100 € turniir. Seal hetkel 62 sisseostu.

Player		Chips	Progress
Ilya Nikiforov		0	0

Jätkame naisteta Posted Saturday 16th September, 2023 at 17:06(UTC+3) by maheaaatom

Soomlanna Anna-Mari Hursti langes just mängust välja ning nii jätkavad 555 € turniiri eranditult mehed. Meie kaotasime veel ka Andrei Mjagkovi.

Player		Chips	Progress
Andrei Mjagkov		0	0

Turniiri juhib Anatoly Filatov Posted Saturday 16th September, 2023 at 17:02(UTC+3) by maheaaatom

Pausile läks suurima stäkiga Anatoly Filatov, ka teine koht on meie mehe Maksim Solodilovi käes. Seejuures on viimane teinud lausa metsiku tõusu, sest kogu eelmise päeva vaevles ta mägnus väga pisikese stäkiga.

Aga väga hea meel on ka Andres Leppiku üle, kes alustas mängu täna sarnaselt Rannole 30K-ga, kuid on suutnud selle samuti kümnekordistada.

Player		Chips	Progress
Anatoly Filatov		397,000	97,000
Maksim Solodilov		365,000	336,000
Andres Leppik		308,000	266,000
Ranno Sootla		29,000	271,000

Algas järgmine mängutsükkel Posted Saturday 16th September, 2023 at 16:58(UTC+3) by maheaaatom

70 mängijat on laudades ning lähme edasi. Tulemas järjekordne tsükkel 4 x 30 min, mille lõpus on BB juba alla 1000x turniiril kokku mängus olevatest nuppudest. Kas selle jooksul ka mull lõhkeb, on aga pisut kahtlane, sest vahetult mulli lõhkemise eel läheb tavaliselt ikka korralikuks "kabetamiseks".

16:55 (UTC+3)

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

70 mängijat pausile Posted Saturday 16th September, 2023 at 16:35(UTC+3) by maheaaatom

70 mängijat läheb 20 minutiks puhkama. Kui tempo püsib endine, siis hiljemalt õhtusöögiks on mull juba lõhkenud.

Paha uudis on see, et väljas on alles hiljuti väga head stäkki omanud Igor Pihela noorem. Aga mäng ongi väga kiire, keskmine stäkk ju alla 30XBB.

Player		Chips	Progress
Vladislav Topilskiy		0	0
Maksim Petrov		0	0
Janar Kokk		0	0

Martin Venno loodab algaja õnnele Posted Saturday 16th September, 2023 at 16:31(UTC+3) by maheaaatom

Eile väga tempokalt mängu sisenenud Martin Venno mängib enda sõnul oma ESIMEST live-turniiri. Mitte esimest suurfestivali, vaid üldse esimest turniiri.

"Online'is olen muidugi mänginud ja vahel sõpradega ka. Aga kui kuulsin, et Tallinnas toimub selline üritus, tulin isegi kohale."

Martinil on umbes 220K stäkk, mis on üle keskmise ja igati korralik. "Algaja õnn," muigab Martin ise. Soovime talle edu ning loodame, et esimene katsetud toob kohe ka vähemalt cashimise!

Player		Chips	Progress
Martin Venno		220,000	169,000

Pilk teistesse tubadesse Posted Saturday 16th September, 2023 at 16:18(UTC+3) by maheaaatom

Fuajees toimuval satikal on juba 50 sisseostu ning nagu arvata võis, osaleb turniiril ka mitmeid hobimängijaid.

1100 € Ringe Event'il on kirjas 46 sisseostu ning osalejate seas päris arvukalt eestlasi. Üldiselt tundub olevat nii, et kõik vähe asisemad mängijad, kes 555-selt välja langevad, leiavad end juba loetud minutite pärast kõrvalsaalis "Las Vegas" toimuvalt kaks korda kallimalt turniirilt.

80 parimat Posted Saturday 16th September, 2023 at 16:14(UTC+3) by maheaaatom

Action on tõesti megakiire. Umbes poole tunniga oleme kaotanud veel tubli 15 mängijat, kelle seas kahjuks ka agressiivne Eesti pokkeriproff Taago Tamm.

Lisaks temale on väljas Marko Vest, meie õnneks on aga ülejäänud langejad väliskülalised.

Player		Chips	Progress
Marko Vest		0	0
Taago Tamm		0	0

16:11 (UTC+3)

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

Skill ikkagi määrab Posted Saturday 16th September, 2023 at 16:11(UTC+3) by maheaaatom

Ranno Sootla alustas tänast päeva 30K-ga, nüüd on tal aga umbes kümme korda rohkem.

Sama heas seisus on Anatoly Filatov, kes on küll rahvuselt venelane ja sündinud Moskvas, kuid elanud viimased aastad Euroopas, sh. Eestis. Tal on ka Eesti ID-kaart taskus, seega peaaegu nagu oma mees. Filatovi live-teenistus on Hendoni andmetel üle 5,3 miljoni dollari, kuid erinevalt Rannost tal WSOP käevõru pole. 

Ranno on tituleeritud mängija ka WSOP mastaabis. Tal on ikkagi olemas käevõru (see saadud küll online'is) ning ette näidata kõrge teine koht "päris WSOP-lt" Las Vegases. Loodame, et mees jõuab Tallinnas ka sõrmuseni!

Player		Chips	Progress
Ranno Sootla		300,000	270,000
Anatoly Filatov		300,000	270,000

Eestlaste read hõrenevad Posted Saturday 16th September, 2023 at 15:57(UTC+3) by maheaaatom

Tänavuse Summer Showdown põhiturniiri kolmas mees, kuulus High-Roller Urmo Velvelt on kahjuks mängust väljas. Ning jällegi, ta pole ainuke. Oma mängu ei saanud kuidagi käima ka näiteks Tarmo Tammel.

Tuntud tegijatest peame ütlema head-aega ameeriklasele James Little'ile, kes on "suurel WSOP-l" ka korra teiseks tulnud.

Player		Chips	Progress
Tarmo Tammel		0	0
Janek Tammsaar		0	0
Alari Kadanik		0	0
Urmo Velvelt		0	0

Algamas tõeliselt soodne satelliit Posted Saturday 16th September, 2023 at 15:52(UTC+3) by maheaaatom

Kell 15:00 algab (eeldavalt) fuajees kõigest 40-eurose sisseostuga satelliit homsele 350 € WSOPC "rahvaturniirile". Tegemist muide samuti Ring Eventiga.

Satelliidi võimalikud re-entryd maksavad kõigest 20 € ning on reigivabad. Garanteeritud on 10 x 350 € piletit.

Viimane sada Posted Saturday 16th September, 2023 at 15:47(UTC+3) by maheaaatom

Oleme juba jõudnud 100 mängijani, turniir edeneb tõesti väga kiirelt. 

Meie arvestuse kohaselt jätkab mängu 27 Eesti mängijat ning rikkaimad paistavad olevat Dmitri Dudakov ja Igor Pihela noorem.

Päeva liidrina alustanud Raivo Pinsel on veel pisut kaotanud ning tema stäkk nüüd veel napilt üle keskmise.

Player		Chips	Progress
Raivo Pinsel		125,000	35,000

Kes üles, kes alla, kes üldse väljas Posted Saturday 16th September, 2023 at 15:44(UTC+3) by maheaaatom

Igor Pihela noorem on kenasti edenenud ning tõusnud umbes 180K peale. Äsja vastase pangast välja surunud Dmitri Dudakovil on umbes sama suur stäkk, seega temaga ka kõik okei. Ja tõusnud on ka Taago Tamm (umbes 140K)

Olulisel on ära andnud Urmo Velvelt ja Roland Luik. Väljas teiste seas ka Ermo Kosk ja Markku Koplimaa.

Player		Chips	Progress
Igor Pihela noorem		180,000	71,000
Dmitri Dudakov		180,000	42,000
Taago Tamm		140,000	73,000
Tõnis Viik		110,000	59,500
Roland Luik		90,000	55,000
Urmo Velvelt		60,000	97,000
Markku Koplimaa		0	0
Andrey Koks		0	0
Martti Keel		0	0
Ermo Kosk		0	0
Tanel Koht		0	0
Mairo Tori		0	0

15:38 (UTC+3)

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

Ranno on kenasti edenenud Posted Saturday 16th September, 2023 at 15:28(UTC+3) by maheaaatom

Ranno Sootla istuski alles täna esimest korda pokkerilauda 30K stäkiga, kuid on selle juba enam kui kolmekordistanud. 

Ranno enda sõnul on tema fookus hetkel WSOP Circuit'il, kuid ta hoiab silma peal ka OlyBetis toimuval WSOP Online'il. Aga live-pokker on siiski netimängudest tähtsam, sest ega WSOP Circuit'i toimumine Tallinnas pole ju midagi igapäevast.

Alles on 113 mängijat, kahjuks on päris palju langejaid taas ka eestlaste seast. Nende seas on paraku ka tänavune komeet Martti Keel.

Player		Chips	Progress
Ranno Sootla		97,000	67,000
Kert Hallik		0	0
Vladimir Iljunin		0	0
Artur Külanurk		0	0
Aleksei Smirnov		0	0
Oskar Ojaveer		0	0
Mark Metsla		0	0
Maikel Homin		0	0

Eilne videokokkuvõte Posted Saturday 16th September, 2023 at 15:17(UTC+3) by maheaaatom

Algas teine tänane suurturniir Posted Saturday 16th September, 2023 at 15:08(UTC+3) by maheaaatom

Äsja läks kõrvalsaalis käima ka Ring Event #2 1100 € No Limit Holdem. See turniir on kahepäevane ning esimese 5 tunni jooksul (10 taset) võib teha tagasioste (re-entry) nii palju süda lustib või rahakott kannatab.

Turniir algas 18 mängijaga, laudades ka neli eestlast. Eesotsas äsja 555-selt välja langenud Igor Pihela vanema ning Rasmus Seppinguga.

Janarile kiire duubel Posted Saturday 16th September, 2023 at 15:03(UTC+3) by maheaaatom

Alles teisel päeval mänguga liitunud Janar Kokk saab kiire duubli Tallinnas sageli mängiva soomlase Juho Heiska vastu. 

Janar juhib enne floppi vs. ) ning jääb ka peale. Nagu nipsti peaaegu keskmine stäkk käes!

Kahjuks on ka langejaid eesotsas vanema Pihelaga. Ja Rasmus Sepping, kes kulutas enda sõnul kolm bulletit ei saanud kahjuks oma mängu samuti käima.

Player		Chips	Progress
Janar Kokk		67,000	26,500
Magnus Pukk		0	0
Siim Suviste		0	0
Danel Kunman		0	0
Igor Pihela vanem		0	0
Rasmus Sepping		0	0

15:01 (UTC+3)

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

Raja jagub 47 parimale Posted Saturday 16th September, 2023 at 14:47(UTC+3) by maheaaatom

Turniiridirektori sõnutsi saab 183 360 € auhinnarahast osa 47 parimat mängijat. 

Võitja saab 38510 €, viimane rahakoht täpselt tonni. Ja mõistagi ootab võitjat ka WSOP Circuit kuldne sõrmus ning pääse 2024. aasta juunis toimuvale WSOP Tournament of Champions'ile Las Vegases.

Suurte stäkkidega eestlased pausi ajal Posted Saturday 16th September, 2023 at 14:42(UTC+3) by maheaaatom

Risto Pärnat peaks olema väga napilt ka turniiri chipliider. Korraliku tõusu on teinud ka high-roller Urmo Velvelt.

Player		Chips	Progress
Risto Pärnat		247,000	107,000
Raivo Pinsel		160,000	59,000
Alexander Nemchin		159,000	102,500
Urmo Velvelt		157,000	67,500
Roland Luik		145,000	7,000
Dmitri Dudakov		138,000	14,000
Sami-Sander Kivi		113,000	83,000

Lõplikult väljalangenud Eesti mängijad Posted Saturday 16th September, 2023 at 14:38(UTC+3) by maheaaatom

Player		Chips	Progress
Tanel Merida		0	0
Kaur Ajamaa		0	0
Mart Rinken		0	0
Kaupo Tenno		0	0
Erki Evert		0	0
Tanel Evert		0	0
Raimo Reimann		0	0
Marten Oks		0	0
Mario Jürgens		0	0

Late reg. läbi, mäng jätkub Posted Saturday 16th September, 2023 at 14:34(UTC+3) by maheaaatom

Hiline registeerumine on lõppenud, lauas on 159 mängijat. Hetkeseisuga mängime 183 360 eurole, kuid see pole veel lõplik info.

Ülihiliste registeerujate hulgas on ka Ranno Sootla - ainus mees Eestis, kel ka WSOP käevõru kodus šeifis olemas.

14:32 (UTC+3)

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

Mängijad asuvad end pausile sättima Posted Saturday 16th September, 2023 at 14:08(UTC+3) by maheaaatom

Mõnes lauas on 3 viimast kätt juba lõppenud, mõnes aga veel käimas.

Fakt on see, et pärast seda kui kõikides laudades on mäng lõppenud, läheme 20-minutilisele pausile. Seega peaks turniir jätkuma umbes kell 13:30. 

Raivo ei olegi enam liider Posted Saturday 16th September, 2023 at 13:58(UTC+3) by maheaaatom

Raivo Pinsel on teise päeva alguses umbes 50K ära andnud, enda sõnul mehel kahel korral paarid ei pidanud.

Aga kui selles midagi head näha, siis vähemalt on Raivo nupud läinud omadele meestele. Veel viis minutit 12. taseme lõpuni, mis tähendab seda, et mängitakse veel kolm viimast kätt.

Juba 35 langejat Posted Saturday 16th September, 2023 at 13:54(UTC+3) by maheaaatom

Tänane päev on juba (!) lõppenud 35 mängijale. Tõsi, osad neist on siiski teinud re-entry. 

Langenud on ka mitmeid eestlasi, kuid me ei hakka nende nimesid veel eraldi kirja panema. Juba umbes poole tunni pärast peaks olema selge, kes jätkab ja kes mitte. 

Maikel veel ootab oma kohta Posted Saturday 16th September, 2023 at 13:49(UTC+3) by maheaaatom

"Tiitlikaitsja" Maikel Homin on nagu mainitud, mängus üsna väikese stäkiga. Sisuliselt on tal push-fold mäng, sest lauas ei juhtu vist ühtegi jaotust, kus keegi teine ei lükkaks.

Samas lauas andis just duubli turniiri ainsana Venemaa lipu all võistlev Aleksander Klochkov. Mees istus BB-l ning callis oma ässadega suurima heameelega laua keskelt tulnud lüket -ga. Flop oli aga juba üsna kurjakuulutav ning riveriga sai duublit jahtinud mees küll mitte rea, aga võiduks piisava poiste kolmiku.  

Risto sai korraliku chiplisa Posted Saturday 16th September, 2023 at 13:42(UTC+3) by maheaaatom

Risto Pärnati ning Eestis elava "Mirza" stäkid läksid sisse pärast lauas avatud . 

"Mirza"-l olid poisid, Ristol emandad. Ja emandad jäid peale ka pärast riverit. 

Player		Chips	Progress
Risto Pärnat		140,000	85,500

Täna mängitakse kuni finaallauani Posted Saturday 16th September, 2023 at 13:38(UTC+3) by maheaaatom

Esialgse plaani kohaselt peaks tänane mäng kestma kuni finaallauani. Kuigi saalis on ligi 200 mängijat, tuleb siiski arvestada sellega, et mäng on suhteliselt kiire.

Suvel alustas teist päeva 259 mängijat ning 13 tunniga jõuti 14 parimani. Praegu on aga mängijaid siiski vähem ning mängutasemed vältavad Summer Showdown'i 40 minuti asemel 30 minutit. Seega julgeks küll prognoosida, et südaööks on meil finalistide nimed teada.

13:32 (UTC+3)

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

WSOP Circuit või Summer Showdown? Posted Saturday 16th September, 2023 at 13:32(UTC+3) by maheaaatom

Hoolimata teise päeva aktiivsest algusest on selge, et juulikuise Summer Showdown'i rekordit see turniir ei purusta. Hetkel on sisseoste 349, suvel saadi aga kokku koguni 573. 

Suvine 555 € NLH Championship oli ka selles mõttes meeldejääv, et võitjaks tituleeriti meie oma mees Maikel Homin. Maikel on ka täna mängus ning alustas teist päeva 38 500 punktiga.

Tanel Evert kaotas kuulsale jaapanlasele Posted Saturday 16th September, 2023 at 13:30(UTC+3) by maheaaatom

Haapsalu pokkerihai Tanel Evert kaotas lõviosa oma 30K+ stäkist nimekale jaapanlasele Ken Okadale -ga vastu. Allesjäänud väheste nuppudega ei õnnestunud mängu tagasi tulla. Noh, re-entry on siiski veel võimalik...

Ka Roland on vahepeal natuke ära andnud, kuid selle ka samas peagi tagasi saanud. "Raske laud, siin on mitmeid suuri stäkke," kommenteerib Roland.

Aga milleks üldse see esimene päev? Posted Saturday 16th September, 2023 at 13:23(UTC+3) by maheaaatom

Turniirialale saabus just Eesti läbi aegade edukaim pokkerimängija Markku Koplimaa, kes avapäevade peale aega ei kulutanud. 20XBB on täpselt see, millega täna alustada.

Uute lisandujate seas on ka näiteks tuntud Eesti naismängija Monika L., Erki Evert, EMV põhiturniiri teine Taago Tamm ja teisigi.

Mängija on laudades ja action alanud Posted Saturday 16th September, 2023 at 13:09(UTC+3) by maheaaatom

170 allesjäänud mängijat ning 12 uut tulijat on kohad laudades sisse võtnud ning kaardid õhus. 

Meid ootab 60 minutit toorest nupulükkamist, mis väga midagi ei muuda. Kell 13:15 on re-entry periood läbi ning enam sihitult gämmelda ei saa.

555 € Ring Event #1 teine päev algab kell 12:00 Posted Saturday 16th September, 2023 at 11:19(UTC+3) by maheaaatom

WSOP Circuit Tallinn 2023 avaturniiri, 555 € No Limit Holdem Ring Event #1, teine päev algab laupäeval kell 12:00. Täna peate leppima veel live-blogiga, kuid alates homsest saab jälgida turniiri ka läbi TV-ülekande.

Mängu avapäevadel tehti kokku 320 sisseostu, edasi pääses 170 mängijat. Nende seas on ka 49 eestlast, kogu turniiri liidriohje hoiab Raivo Pinsel 219 000 punktiga. Korralikus seisus on ka viiendat kohta jagavad Dmitri Dudakov ja Roland Luik.

Turniiriga saab liituda kuni 12. mängutaseme lõpuni ehk umbes kuni kell 13:15-ni. 

11:15 (UTC+3)

Day 2 of WSOPC Tallinn Started
Level: 11     Blinds: 1,000/1,500     Ante: 1,500

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