0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/1B/updates' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/1B/updates', 1, '2024-11-22')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0033 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` = 'WSOPCTallinn2023-MainEvent-Est'

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '40'

0.0282 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0061 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '122' AND `published` = 1

0.0281 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0098 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '126' AND `published` = 1

0.0282 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0059 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '128' AND `published` = 1

0.0400 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0084 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '131' AND `published` = 1

0.0281 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0061 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '133' AND `published` = 1

0.0276 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` = '137' AND `published` = 1

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

0.0005 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '40' AND `name` = '1B'

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

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

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

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

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

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

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

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

0.0071 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5429' 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` = '5428' 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` = '5426' 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` = '5424' 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` = '5419' 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` = '5417' 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` = '5414' 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` = '5412' 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` = '5411' 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` = '5408' 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` = '5406' 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` = '5405' 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` = '5404' 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` = '5397' 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` = '5395' 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` = '5394' 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` = '5392' 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` = '5387' 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` = '5385' 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` = '5381' 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` = '5378' 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` = '5377' 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` = '5376' 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` = '5373' 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` = '5372' 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` = '5371' 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` = '5370' 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` = '5366' 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` = '5364' 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` = '5363' 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` = '5362' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0075 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5348' 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` = '5346' 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` = '5344' 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` = '5343' 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` = '5342' 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` = '5341' 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` = '5338' 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` = '5337' 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` = '5335' 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` = '5333' 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` = '5332' 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` = '5330' 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` = '5329' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0056 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` = '126' 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` = '5448' 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` = '5446' 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` = '5441' 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` = '5437' 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` = '5436' 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` = '5434' 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` = '5433' 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` = '5429' 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` = '5428' 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` = '5426' 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` = '5424' 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` = '5419' 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` = '5417' 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` = '5414' 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` = '5412' 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` = '5411' 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` = '5408' 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` = '5406' 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` = '5405' 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` = '5404' 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` = '5397' 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` = '5395' 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` = '5394' 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` = '5392' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0075 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5373' 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` = '5372' 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` = '5371' 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` = '5370' 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` = '5366' 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` = '5364' 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` = '5363' 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` = '5362' 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` = '5360' 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` = '5359' 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` = '5356' 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` = '5353' 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` = '5350' 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` = '5349' 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` = '5348' 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` = '5346' 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` = '5344' 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` = '5343' 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` = '5342' 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` = '5341' 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` = '5338' 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` = '5337' 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` = '5335' 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` = '5333' 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` = '5332' 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` = '5330' 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` = '5329' ORDER BY `chip_change` DESC, `busted` ASC

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

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

English
WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event (Estonian) Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 1B
1B edukaim mängija on Urmo Velvelt (eestlaste stäkid) Posted Wednesday 20th September, 2023 at 20:06(UTC+2) by maheaaatom

Päevast 1B pääseb edasi 42 mängijat (kokku 107 sisseostu) ning nelja parima seas on kaks eestlast ja kaks soomlast. Meie lipu au kaitsevad kõige kõrgemal tasemel Urmo Velvelt ja Raivo Pinsel.

Kohtume uuesti homme keskpäeval!

Player Chips Progress
Urmo Velvelt 293,000 123,000
Joonas Suutari 251,500 201,500
Roope Tarmi 233,500 183,500
Raivo Pinsel 231,500 91,500
Touko Berndtson 219,000 169,000
Ruslan Stserbjuk 169,500 119,500
Andrey Koks 127,000 77,000
Mauri Dorbek 109,500 20,500
Gert Laanemets 91,000 41,000
Risto Pärnat 86,000 36,000
Kert Hallik 70,000 60,000
Aleksandr Jelpidiforov 65,000 15,000
Keito Kaljulaid 40,500 9,500
Steven Seller 17,500 32,500
Nupud kottidesse! Posted Wednesday 20th September, 2023 at 19:50(UTC+2) by maheaaatom

Niipalju veel infoks, et Urmol õnnestus üks konkurent välja võtta ja oma stäkki oluliselt suurendada.

Sellega on mängupäev läbi ning chippe aetakse kottidesse. Peagi avaldame üldised TOP3 stäkid + kõikide allesjäänud eestlaste stäkid.

Omaha lõplikud numbrid Posted Wednesday 20th September, 2023 at 19:39(UTC+2) by maheaaatom

Turniirile tehti 143 sisseostu ning mängitakse 137 280 eurole. Alles on 36 mängijat, eestlastest vaid Igor Pihela noorem, Markku Koplimaa ja Jaagup Luhakooder. Raha saavad 17 parimat ning täna mängitakse turniir ka lõpuni.

Põhiturniiril mängitakse nelja viimast kätt. Kohe on tänane action läbi. 

Mairo langeb kickeriga Posted Wednesday 20th September, 2023 at 19:35(UTC+2) by maheaaatom

Mairo Tori ja Jon Ander vaatasid viimase kolmpanuse peale floppi  . Mairo check-callis Anderi väikest panust nii nüü kui pärast turni  . Pärast riverit läksid nupud sisse.

Mairo: 
Jon Ander:

Parem kicker tõi Jonile 140K panga.

Väikseid panku ikka tuleb Posted Wednesday 20th September, 2023 at 19:30(UTC+2) by maheaaatom

Nii röögib Mauri, kes endiselt keskmine stäkk - pole saanud väga üles, kuid ka mitte langenud. Selle laua liider ja tooniandja on endiselt Urmo umbes 180K punktisummaga. 

Tempo on samuti vaikselt langenud, eks päeva lõpp on ka suhteliselt lähedal. 51 mängijat alles.

Mees pingviinide maalt Posted Wednesday 20th September, 2023 at 19:18(UTC+2) by maheaaatom

Omaha turniiril osaleb teiste seas Maximilian Sanders, kellel on ette näidata sellise põneva koha nagu Briti Antarktika ala dokument. 

Tegemist on Antarktise sektor, mida Suurbritannia üheks omaks meretaguseks alaks peab, jäädes pikkuskraadidelt 20°W ja 80°W vahele ning ulatudes laiuskraadidelt 60-st kuni lõunapooluseni. Teadaolevalt elab seal 250 inimest ning HÄSTI PALJU pingviine!

Tänane viimane mängutase Posted Wednesday 20th September, 2023 at 19:09(UTC+2) by maheaaatom

Keskmine stäkk on hetkel umbes 50XBB ning meil on veel täpselt 40 minutit mängida. Mängus 54 parimat, kahjuks ka mõned eestlastest bust-outid. Tarmo Tammel, Erik Põlluveer ning Toomas Nurme. 

19:07 (UTC+2)
Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000
Algas SVITEN Posted Wednesday 20th September, 2023 at 19:07(UTC+2) by maheaaatom

Suure saali vaiksemas nurgas läks käima €250 Five Card PLO & Draw (rohkem tuntud kui SVITEN). Kohal on 19 mängijat, peamiselt soomlased ja rootslased. Ainsa eestlasena istub (hetkel) lauas Henrik Puija.

Põhiturniiril, eestlastye action-lauas mängisid kopsaka panga (umbes 70K) Mauri Dorbek ja Urmo Velvelt. Seekord oli Urmol tõesti korralik käsi ning riveril tema 20K panust callinud Mauri pidi foldima. 

Mauril on ca. 80K alles.

Keeruline koht Posted Wednesday 20th September, 2023 at 18:57(UTC+2) by maheaaatom

Lauas on avatud ning pangas tubli 80K.

Urmo checkib ette, Jakub Bujok mõtleb terve igaviku ning lõpuks pannakse talle kell käima. Viimas poolakas siiski checkib.

Kaardid avatakse ning on selge, et kogu actioni põhjuseks oli turni avatud kaheksa. Urmol , Jakub näitas aga koguni . Eks ta juhuslikku üheksat kartis, mis muud...

Urmo stäkile on see muidugi oluline löök, kuid õnneks on suurem osa nööpe alles.

Laudu viiakse kokku Posted Wednesday 20th September, 2023 at 18:49(UTC+2) by maheaaatom

Suurde saali on jäänud 8 lauda, kus hetkel 59 mängijat. See tähendab, et ruumi on lahedalt. 

Langejate seas on Martin Piik ja Priit Parmasto, kellest esimene tuleb kindlasti uuesti proovima. Ja kui tihe online turnakava Priitu ei sega, siis küllap on tema ka kohal.

Kesköine satelliit! Posted Wednesday 20th September, 2023 at 18:35(UTC+2) by maheaaatom

Turniirikavasse on lisatud kesköine satelliit, millel on 15 X 1500 € piletit garanteeritud.

Sisseost on jätkuvalt 150 € ning turniir läheb käima, kui kohal on vähemalt 24 osalejat. Siit võib tulla väga korralik overlay, lisaks on nagunii kell 21:00 algamas ka "tavasatelliit".

18:30 (UTC+2)
Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500
Päeva viimane paus Posted Wednesday 20th September, 2023 at 18:08(UTC+2) by maheaaatom

107 alustajast on mängus 64, kes kõik pääsesid ka päeva viimasele pausile. 

Väljalangejate seas on kahjuks ka Herli Olop, kellel on küll re-entry pilet olemas, kuid ta ei kavatse seda veel täna kasutada. Parem juba homme algusest alustada.

Andrey saab blindide heitluses duubli Posted Wednesday 20th September, 2023 at 18:04(UTC+2) by maheaaatom

Adria Comas I Roura alustas buttonilt 2500 panusega, Morten Bremseth tõstis SB-lt 8600 peale ja sai calli BB-l istuvalt Andrey Koksilt. Nemad kahekesi vaatasid ka floppi  Norralane alustas 6500 panusega, Andrey jammis 36 200 ning sai calli. 

Andrey: 
Morten:

Turn ja river on mõlemad seitsmed ning Andreyle kindel duubel. 

Uudiseid rindelt Posted Wednesday 20th September, 2023 at 17:59(UTC+2) by maheaaatom

Henry Arnhold on oluliselt tõusnud ning umbes 90K peal. Seevastu Raivo Pinsel on pidanud jälle tibake ära andma ning temal hetkel ünsa keskmine (85K) stäkk.

Omaha osalejate nimekiri pole veel lõplikult lukku läinud, kuid sisseoste on rohkem kui põhiturniiril (135 vs 107). Kuna suur osa neist on soomlased, siis võib eeldada, et 1C (aga miks mitte ka 1D) kujuneb suuresti "Soome katsevõistlusteks".

Menukas on ka 250 € turniir, hetkel 116 sisseostu kirjas.

Urmole nelikuga duubel Posted Wednesday 20th September, 2023 at 17:48(UTC+2) by maheaaatom

Vasilij Barna ja Urmo Velvelt tõstsid kordamööda panuseid, kuniks olid mõlemad all-in.

Urmo:

Vasilij:

Flopist Urmole nelik ja leedulane hoobilt drawing dead. Urmol nüüd umbes 170K.

Player Chips Progress
Urmo Velvelt 170,000 120,000
Paveli semibluff ei õnnestunud Posted Wednesday 20th September, 2023 at 17:38(UTC+2) by maheaaatom

Pavel Solodovnikov check-raise'is suurelt turni järel ning sai calli pikalt mõelnud Ori Hassonilt. 

Seejärel paugutas Pavel ka 25 000 pärast riverit  , kuid sai ka siin Hassonilt calli. Pavel avas semiblufi:  , millel polnud lootustki Iisraeli mängija vastu.

Meie mehel jäi küll umbes 20K järgi, kuid pisut hiljem langes ta ikkagi mängust välja. 

17:31 (UTC+2)
Start of Level 8
Blinds: 600/1,200     Ante: 1,200
Urmol 90K Posted Wednesday 20th September, 2023 at 17:31(UTC+2) by maheaaatom

Eesti ühel parimal turniiriprofil Urmo Velveltil on õnnestunud hankida umbes 90K stäkk ning mees paistab mängu nautivat.

"Eilne bounty oli lõpus ikkagi suht turbo ja suht palju mõeldi bountyde peale," rääkis Urmo, kes teenis üldpotist neljanda koha eest 4000 eurot, kuid bountyd tõid talle sisse 16500 eurot. Turniiri võitnud Ranno sai märksa vähem, koos bountydega vist 16K. 

"Aga see on õiglane ka, eriti kui arvestada, mis käega ta mu välja võttis," naeris Urmo. Üldiselt pole tal pettumuseks põhjust, sõrmus on ka nagunii juba varasemast olemas ja Ranno ja Urmo on head sõbrad.

Player Chips Progress
Urmo Velvelt 90,000 40,000
Kolmel eestlasel 2X keskmine stäkk Posted Wednesday 20th September, 2023 at 17:11(UTC+2) by maheaaatom

Kui keskmine stäkk on hetkel 69K, siis põgusa vaatluse põhjal on kolmel eestlasel pea kaks korda rohkem.

Mauri Dorbek on kogu päev suht hästi edenenud, kuid lõpus siiski ka natuke loovutanud. "Tuuakse ikka maa peale tagasi ka vahel," arvab mees ise. 

Raivo Pinsel jagas vahepeal oma nööpe laiali, kuid sai suure osa neist nüüd kenasti tagasi. Suurem kaotus on aga see, et abikaasa Eha on mängust väljas. 

Samuti on korralik seis Kert Hallikul, samuti umbes 130K. 

Player Chips Progress
Raivo Pinsel 140,000 30,000
Mauri Dorbek 130,000 80,000
Kert Hallik 130,000 80,000
Üks paus veel tulekul Posted Wednesday 20th September, 2023 at 17:03(UTC+2) by maheaaatom

Seitsmes tase on käimas ning hea on teada, et pärast kaheksandat on kavas veel üks 20-minutiline paus. Ja siis jääb veel kaks taset päeva lõpuni.

Laudaes 78 mängijat, alustajaid oli 104. Priit Parmasto ja Tarmo Tammel on sunnitud re-entry tegema, väljas on ka Kaidar Viikman, kes veel mänguga uuesti liitunud pole (ega ole teada, kas ta kavatsebki seda teha).

Eesti Itaalia diileri silme läbi Posted Wednesday 20th September, 2023 at 17:00(UTC+2) by maheaaatom

Eestlasi on ikka huvitanud, et mida teised meist arvavad. Kuna turniiril on palju välismaalastest diilereid, sh. meile juba ammu tuttavaid itaallasi, siis vast on huvitav ka teada, mis arvavad eestlased Eestist ja eestlastest.

Kõlab, et muidu on siin tor, ainult ilm on vilets. Ja kõik on väga kallis (eriti palkadege võrreldes). Ühtlasi hakkab elavaloomulistele itaallastele silma, et eestlased on väga kinnised ning rahulikud. 

16:58 (UTC+2)
Start of Level 7
Blinds: 500/1,000     Ante: 1,000
Omahal samuti üle 100 sisseostu Posted Wednesday 20th September, 2023 at 16:25(UTC+2) by maheaaatom

"Las Vegase" toas toimuval Omahl on samuti juba tehtud üle 100 sisseostu ning nii mõnelgi mängijal kirjas juba üle ühe re-entry. Üheks neist on ka näiteks Markku Koplimaa.

Põhiturniir on kohe minemas pausile, täna on mängida veel 4 x 40 minutit. Ühtlasi on alanud 250 € NLH, kus ka juba tubli 75 sisseostu kirjas.

Järgmine turniir, SVITEN on algamas kell 19:00.

"Oleks vist pidanud eile mängima" Posted Wednesday 20th September, 2023 at 16:20(UTC+2) by maheaaatom

Herli Olop kurdab, et laud on suhteliselt keeruline ning fieldi vaadates olevat eilne päev märksa lihtsam. Juhtus ju päevale 1A suur osa online-kvalifitseerujatest.

Hetkel on koos 101 sisseostu ning liitunud on ka sellised Eesti ässad nagu Urmo Velvelt, Keito Kaljulaid ja Marius Morel.

Laud mängib Posted Wednesday 20th September, 2023 at 16:11(UTC+2) by maheaaatom

"Poisid, olge valvel! Ma kohe tunnen, et võtan selle käega kellegi välja," ütleb Kelly ja lükkab 4000 keskele. Eesti mängija Albert Jegorõtsev kaitseb blindi.

Flop on ning Albert checkib kohe ette. Kelly paugutab 6,5K ning saab välkkiire calli. 

Turn on ning enam Kelly ei paugutagi, vast hoopis checkib. Samaga vastab ka meie mees.

Niisamuti checkiti läbi ka river . Kellyl oli kahtede paar, Albertil aga flopanud mastitõmme . Seega laud mängib ja pank pooleks.

Aleksandr hangib lisa Posted Wednesday 20th September, 2023 at 15:52(UTC+2) by maheaaatom

Martin Piik avab 1200-ga, Semjons Karuckis tõstab kohe panused 2700-le ning SB-l istuv Eesti mängija Aleksandr Jelpidiforov paneb veel juurde - 5,5K. Martin foldib kohe, kuid Semjons tuleb kaasa.

Flop on , Aleksandr alustab kohe 11500-ga ning saab calli.

Turn on ning paistab, et Aleksandr ei taha midagi juhuse hooleks jätta. All-in (ca. 30K)

Lätlasel on küll kordades rohkem raha järel, kuid ta instafoldib. Kas või paar kaheksatest soldatiteni? Või midagi muud?

15:48 (UTC+2)
Start of Level 6
Blinds: 400/800     Ante: 800
Kert püüab Henry blufi kinni Posted Wednesday 20th September, 2023 at 15:39(UTC+2) by maheaaatom

Henry Arnhold tuleb buttonilt 2400-ga blinde "sööma" ning saab calli BB-l istuvalt viidekordselt Eesti meistrilt Kert Hallikult.

Flop on . Kert check, Henry 4600 ja Kert callib.

Turn on , Kert checkib taas ning callib seejärel Henry 10 200 panust.

River on , Kert ei haara ikka initsiatiivi ning Henry panustab nüüd juba 20 200. Kert veeretab natuke nuppe, kuid on üsna kindel, et Henry blufib ning callib ära. 

"Sul on õigus, hea call", ütleb Henry ja avab . Kerdil on , vaevalt talle see turn meeldis...

Kert Halliku stäkk nüüd umbes 100K.

Nimekad välismaalased Posted Wednesday 20th September, 2023 at 15:26(UTC+2) by maheaaatom

Nimekatest välismängijatest (jätame kõrvale soomlased, keda täna esindamas muuhulgas online high-roller Roope Tarmi) on meil täna laudades näiteks:

- Nikolay Ponomarev (UK)
- Georgios Tsouloftas (Küpros)
- Ori Hasson (Iisrael)

Kõik ned mehed on teeninud live-pokkeriga vähemalt 700 tuhat eurot, Ori on väga lähedal ka miljonile.

Raivole veel üks skalp Posted Wednesday 20th September, 2023 at 15:15(UTC+2) by maheaaatom

Raivo Pinselist õhkub rahulolu. "Sain oma kuningatega lauast kolmiku, vastasele nut-mast. River andis neli, ta maksis oma mastiga kõik kenasti kinni."

Raivo hetkel umbes 170K. "Võin nüüd natuke puhata," arvab mees.

Player Chips Progress
Raivo Pinsel 170,000 120,000
15:11 (UTC+2)
Start of Level 5
Blinds: 300/600     Ante: 600
Kas overlay tuleb? Posted Wednesday 20th September, 2023 at 15:11(UTC+2) by maheaaatom

See küsimus on paelunud vist küll enamikke mängijaid, kes turniiril osalevad. Lihtne matemaatika näitab, et selleks peaks olema alla 666 sisseostu (kui me ei arvesta riigi- ega muid makse).

Hetkel on neist kirjas 229, kuid tuleb arvestada, et:

- Käimas on alles 1B ning seegi veel pigem alguses (jäänud veel 1C ja 1D)

- Suured soomlaste hordid, kes tavaliselt Tallinnas mängivad, pole veel saabunud

- Hiline registreerumine on lubatud kuni teise mängupäeva (reede) teise taseme lõpuni.  

Reporter julgeks pakkuda, et overlayd siiski pigem ei tule. Summer Showdownil oli sisseoste 564, Kings of Tallinnal 716. Kummagi ürituse ajal ei toimunud ühtegi väga suurt online-festivali, kuid see-eest on on WSOP Circuitil kohal palju selliseid mängijaid, keda me enne Tallinnas väga näinud ei ole. Ja väga palju on ka Eesti esindajad, kes on tegemas on suurvõistluste debüüti, seda iseäranis just venekeelsest pokkerikommuunist. 

Maurile 40K pank Posted Wednesday 20th September, 2023 at 14:53(UTC+2) by maheaaatom

Kolmandas lauas on jaotus jõudnud niikaugele, et umbes 20K pangas on Mauri Dorbek ja Jakub Bujok. 

Lauas on ning esimesena käiguõigust omanud Mauri just teinud 10 200 panuse. 

Poolakas mõtleb pikalt ning katsub mõista, et mis Mauril küll olla võiks. "Mul on hea äss," ütleb mees ning uurib, et juhul kui ta foldib, siis kas Mauri näitab oma kaarte? Ülikogenud mängumehena Mauri muidugi selliste lihtlabaste trikkide ohvriks ei lange. 

Viimaks call tuleb ning Mauri esitleb . Poolaka lehed jäävad saladuseks.

Markku PLO-d proovimas Posted Wednesday 20th September, 2023 at 14:38(UTC+2) by maheaaatom

Eesti läbi aegade edukaim pokkerimängija Markku Koplimaa on proovimas kätt PLO-l. Eks põhiturniiriga on veel aega ning Markku on näidanud juba pikka aega huvi segamängude vastu. Tõsi, juba on tulnud ka teha ka üks re-entry ning isegi mõnevõrra üllatuslikult on mängust välja langenud Andres Abakanov. 

Omaha on muide ühepäevane turniir, mis peaks lõppema eeldavalt kuskil öösel.

Algus on tehtud! Posted Wednesday 20th September, 2023 at 14:32(UTC+2) by maheaaatom

Nii sõnab Raivo Pinsel, kes on näidanud esimese 3 taseme jooksul väga head mängu. Päris lõpus elimineeris ta ka ühe soomlase ning nüüd on Raivol juba umbes 120K.

Turniiri liider võiks hetkek olla Semjons Karuckis (140K), kuid ka Kanada mehel Kellneril on korralik 127K stäkk. 

Mängu jätkab 77 pokkerisportlast.

14:30 (UTC+2)
Start of Level 4
Blinds: 200/500     Ante: 500
Põhiturniir pausile Posted Wednesday 20th September, 2023 at 14:07(UTC+2) by maheaaatom

Esimesed 3 taset on läbi, laudades 70 mängijat. Ja nad pääsevad nüüd 20 minutiks värsket õhku hingama.

Omaha läheb kiirkäigul Posted Wednesday 20th September, 2023 at 14:06(UTC+2) by maheaaatom

Kirjas on 62 sisseostu ning juba kaheksa mängijat on turniirilt välja langenud. Tõenäoliselt mitte lõplikult, sest esimese 10 x 30 min. jooksul on lubatud ka re-entry. Seega saab Omahaga liituda täna umbes kella kuueni.

Põhiturniiril on juba 76 sisseostu, uue mängijana lauas Eesti rahalisti 15. mees Mauri Dorbek.

Tarmo ja Erik nagistavad blindidel Posted Wednesday 20th September, 2023 at 14:00(UTC+2) by maheaaatom

Kõik foldivad kuni blindideni, Tarmo Tammel loodab "odavalt" floppi näha ning kõigest callib. Erik nii ei arva ja lükkab BB-lt 1200 juurde. Tarmolt call.

Flop on , Tarmolt check, Erik paneb 1200 ja saab calli.

Turn checkitakse läbi. Kas kardetakse masti?

River on ning nüüd paneb juba Tarmo 2K. Erikult tuleb natuke vastumeelne call.

Tarmo avab , Erikul on

Herli Olop: "8-Game oli mängitav!" Posted Wednesday 20th September, 2023 at 13:52(UTC+2) by maheaaatom

Eilne 8-Game, mille võitja selgus alles täna varahommikul, läks eestlastel üle kivide ja kändude ning ükski meie omadest auhinnarahadesse ei jõudnud. Õigemine, ei jõudnud rahade lähedalegi.

Eile sel turniiril osalenud Herli Olop ütles, et küllap oli põhjuseks siiski väga halb kaardijooks, mida ta ka ise otsustavatel tasemetel koges. "Igas lauas oli paar mängijat, kel puudusid suht igasugused oskused. Kindlasti mängitav turniir," võttis Herli eilse actioni kokku.

Tarmo Tammeli eilne mäng lõppes valusalt Posted Wednesday 20th September, 2023 at 13:41(UTC+2) by maheaaatom

Tarmo Tammel suutis päeval 1A oma stäki 150K peale ajada ning oli veel 10 minutit enne päeva lõppu igati korraliku 100K peal.

Siis tuli aga -ga minna ja sattuda vastamisi -ga...

"Kusjuures, selsamal mehel olid ka varem ühel korral minu vastu ässad," meenutab Tarmo. "Minul olid siis üheksad, suutsin maha visata. Aga ebareaalne, et üks ja sama mees nii lühikese aja jooksul just minu vastu ainult ässad saab."

Midagi pole teha, nüüd peab Tarmo päeva 1B otsast alustama.

Mul on alati midagi! Posted Wednesday 20th September, 2023 at 13:38(UTC+2) by maheaaatom

Kelly Kellner paistab harrastavat väga agressiivset mängu ning ega tal suu ka paigal seisa.

Just vaatas selles lauas 3,5-ga (9 X BB) floppi neli mängijat, nende seas ka Erik Põlluveer.

Flopis avati ning Kellner avas 6,5K-ga, mida kõik ülejäänud (peale Eriku) callisid.

Turni järel jätkas Kanada mees panustamist ning seekord enam huvilisi polnud. Kelly pööras ümber ning praalis, et "mul on kogu aeg midagi." 

"Küllap sai mingi äss-viiega pihta," naerab Tarmo Tammel, kes istub samas lauas.

13:31 (UTC+2)
Start of Level 3
Blinds: 200/400     Ante: 400
Kellner hammustab Priitu Posted Wednesday 20th September, 2023 at 13:19(UTC+2) by maheaaatom

Võrdlemisi suure panga on omavahel mänginud värvikas Kanada pokkerimängija Kelly Kellner ning meie Priit Parmasto.

Riveriks oli lauas neli ruutut ning Priidu 10K panusele tuli Kellnerilt vastu 31 600 panus. Kellneril on muide kombeks teha panuseid, kus esindatud võimalikult palju erineva väärtusega žetoone. 

Priit callima ei hakanud ning õieti tegi, sest Kellner välgatas nutsu - 

Priidul kolmandik stäkist läinud.

Esimesed re-entryd Posted Wednesday 20th September, 2023 at 13:15(UTC+2) by maheaaatom

Teise mängutaseme keskel jõudsime esimeste väljalangemisteni. Kuna tegemist oli Türgi ja Küprose esindajatega, võime olla kindlad, et varem või hiljem on nad mängus tagasi.

62 sisseostu on kirjas ning mängijaid lisandub pidevalt. Lauas on ka Gert Laanemets ja Herli Olop. 

Kuuenda päeva videokokkuvõte Posted Wednesday 20th September, 2023 at 13:12(UTC+2) by maheaaatom

Mis toimub Omahal? Posted Wednesday 20th September, 2023 at 13:02(UTC+2) by maheaaatom

"Las Vegase" ruumis toimub PLO on meelitanud kohale eeskätt soomlased, mängijaid on hetkel tubli 27. 

Eestlastest võime näha laudades Georgi Voometsa, Andres Abakanovit, Jaagup Luhakoodrit ning Henrik Puijat. Kõik nad on tugevad mängijad, esimesed kaks kohe eriti head just Omaha-mängudes.

54 mängijat Posted Wednesday 20th September, 2023 at 13:00(UTC+2) by maheaaatom

Mängusaali on saabunud ka valitsev Eesti meister Kaidar Viikman, niisamuti Mart Tammoja, Kert Hallik, Risto Pärnat ja Dmitri Dudakov.

Hetkel osalevast 54 mängijast kaitsevad seega koguni 20 Eesti lipuvärve. Öelge veel, et 1500 eurot on kole suur summa ja inimestel pole raha... Muidugi on meie pokkeripunti aidanud ka soodsad satelliidid ning (eilsel Airini näitel) isegi loosimised!

Action on muidu väga rahulik, keegi välja langenud ei ole.

12:46 (UTC+2)
Start of Level 2
Blinds: 100/300     Ante: 300
Saabus Martin Piik Posted Wednesday 20th September, 2023 at 12:43(UTC+2) by maheaaatom

Martin Piik on näidanud sellel festivalil siiani väga head mängu. Ta on võitnud ühe kõrvalturniiri ning teinud kaks sügavat jooksu sõrmuseturniiridel (vastavalt 10. ja 11. koht).

Põhiturniiril valis ta alustamiseks just 1B.

Suurfestivalid teevad proffide elu keeruliseks Posted Wednesday 20th September, 2023 at 12:34(UTC+2) by maheaaatom

Nagu mitmed profid enne teda, rõhutab ka Priit Parmasto, et WSOP Circuit Tallinn toimub üsna keerulisel ajal, mil online-pokkeris viiakse läbi aasta suurimaid pokkerifestivale. GG-Poker'is (Eestis vaid OlyBet) toimuv WSOP Online on eestlaste seas ülimalt menukas, kuid kindlasti leidub omajagu ka WCOOP-i mängijaid.

Priit kahtleb, kas kõik kohalikud tipud mängima tulevad, näiteks Ottomar pidavat praegu kõvasti netis grindima. Aga nagu näete, osalenud on nii Aleksei, Ranno kui Markku, esimesed neist kohe vägagi edukalt.

Lauas ka nimekas Eesti turniiriproff Priit Parmasto Posted Wednesday 20th September, 2023 at 12:18(UTC+2) by maheaaatom

Kõige nimekama osalejana hakkab silma märtsis Kings of Tallinn põhiturniiri võitnud tuntud pokkeriproff Priit Parmasto.

Aga eestlastest on kohal ka näiteks härra ja proua Pinselid, Kaupo Puusepp, Steven Seller, Mairo Tori ja Rene Peterkopf.

1B on alanud Posted Wednesday 20th September, 2023 at 12:13(UTC+2) by maheaaatom

Väikese hilinemisega läks 1B käima, hetkel laudades 32 mängijat. Samuti on alanud 1100 € Omaha, seal on võistlejaid hetkel kuraditosin.

Võime oodata üsna rahulikku hommikut, sest TV-laudades on vaikus ning ühtegi teist turniiri pooleli ei ole. 

Põhiturniir jätkub kell 12:00 Posted Wednesday 20th September, 2023 at 11:10(UTC+2) by maheaaatom

Hommikust pokkerisõbrad!

Põhiturniir jätkub täna kell 12:00 ning samaaegselt läheb käima ka 1100-eurone Omaha 4/5 Cards Ring Event.

Ühtekokku on põhiturniiril neli alguspäeva, tänane on seega 1B. Eilne 1A oli võrdlemisi populaarne, tehti 139 sisseostu ning osales palju Eesti tippe. Tänane ja eriti homne mängupäev peaksid tooma kasiinosse aga juba märksa enam välismängijaid. 1B vältab eeldatavalt kuni 19:40-ni.

11:07 (UTC+2)
Day 1B of WSOPC Tallinn Started
Level: 1     Blinds: 100/200     Ante: 200

Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.