0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0083 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/london_mega_series_april_23'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 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.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0003 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0002 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.0002 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.0036 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0004 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'london_mega_series_april_23'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '18'
0.0269 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '66'
AND `published` = 1
0.0272 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '68'
AND `published` = 1
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0066 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '69'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0067 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '70'
AND `published` = 1
0.0001 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '70'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '18'
AND `name` = '2'
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '70'
ORDER BY `busted` ASC, `current_chips` DESC
0.0067 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` = '70'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '3348'
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` = '3347'
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` = '3346'
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` = '3345'
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` = '3344'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3343'
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` = '3342'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3341'
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` = '3340'
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` = '3339'
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` = '3338'
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` = '3337'
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` = '3336'
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` = '3335'
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` = '3334'
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` = '3333'
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` = '3332'
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` = '3331'
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` = '3330'
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` = '3329'
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` = '3328'
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` = '3327'
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` = '3326'
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` = '3325'
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` = '3324'
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` = '3323'
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` = '3322'
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` = '3321'
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` = '3320'
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` = '3319'
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` = '3318'
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` = '3317'
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` = '3316'
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` = '3315'
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` = '3314'
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` = '3313'
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` = '3312'
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` = '3311'
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` = '3310'
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` = '3309'
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` = '3308'
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` = '3307'
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` = '3306'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3305'
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` = '3304'
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` = '3303'
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` = '3302'
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` = '3301'
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` = '3300'
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` = '3299'
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` = '3298'
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` = '3297'
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` = '3296'
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` = '3295'
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` = '3294'
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` = '3293'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3292'
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` = '3291'
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` = '3290'
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` = '3289'
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` = '3288'
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` = '3287'
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` = '3286'
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` = '3285'
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` = '3284'
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` = '3283'
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` = '3282'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3281'
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` = '3280'
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` = '3279'
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` = '3278'
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` = '3277'
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` = '3276'
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` = '3275'
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` = '3274'
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` = '3273'
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` = '3272'
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` = '3271'
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` = '3270'
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` = '3269'
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` = '3268'
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` = '3267'
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` = '3266'
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` = '3265'
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` = '3264'
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` = '3263'
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` = '3262'
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` = '3261'
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` = '3260'
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` = '3259'
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` = '3258'
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` = '3257'
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` = '3256'
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` = '3255'
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` = '3254'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '70'
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` = '70'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '3348'
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` = '3347'
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` = '3346'
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` = '3345'
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` = '3344'
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` = '3343'
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` = '3342'
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` = '3341'
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` = '3340'
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` = '3339'
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` = '3338'
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` = '3337'
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` = '3336'
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` = '3335'
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` = '3334'
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` = '3333'
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` = '3332'
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` = '3331'
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` = '3330'
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` = '3329'
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` = '3328'
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` = '3327'
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` = '3326'
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` = '3325'
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` = '3324'
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` = '3323'
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` = '3322'
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` = '3321'
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` = '3320'
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` = '3319'
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` = '3318'
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` = '3317'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3316'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3315'
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` = '3314'
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` = '3313'
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` = '3312'
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` = '3311'
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` = '3310'
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` = '3309'
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` = '3308'
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` = '3307'
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` = '3306'
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` = '3305'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3304'
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` = '3303'
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` = '3302'
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` = '3301'
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` = '3300'
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` = '3299'
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` = '3298'
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` = '3297'
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` = '3296'
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` = '3295'
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` = '3294'
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` = '3293'
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` = '3292'
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` = '3291'
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` = '3290'
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` = '3289'
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` = '3288'
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` = '3287'
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` = '3286'
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` = '3285'
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` = '3284'
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` = '3283'
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` = '3282'
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` = '3281'
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` = '3280'
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` = '3279'
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` = '3278'
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` = '3277'
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` = '3276'
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` = '3275'
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` = '3274'
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` = '3273'
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` = '3272'
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` = '3271'
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` = '3270'
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` = '3269'
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` = '3268'
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` = '3267'
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` = '3266'
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` = '3265'
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` = '3264'
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` = '3263'
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` = '3262'
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` = '3261'
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` = '3260'
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` = '3259'
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` = '3258'
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` = '3257'
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` = '3256'
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` = '3255'
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` = '3254'
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` = '70'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1983
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.
Congrats to Sunil Mistri for Winning the Mega Series Main Event (£32,825) Posted Monday 17th April, 2023 at 03:01(UTC+0) by Jason Glatzer
Sunil Mistri just shipped the Mega Series Main Event for £32,825 after nearly 14 hours of play on the second and final day of the event.
Congrats to Mistri for a huge score and the trophy! Here is a look at the full payouts.
Place
Player
Country
Prize
1
Sunil Mistri
United Kingdom
£ 32,825
2
Dost Ghrabie
United Kingdom
£ 22,347
3
Beihao Wang
China
£ 14,771
4
Yuval Rosenberg
United Kingdom
£ 12,173
5
Sebastien Jung
United Kingdom
£9,779
6
Chris Da Silva
United Kingdom
£7,659
7
Tamer Ovutmen
Turkey
£5,744
8
Luke Porter
United Kingdom
£4,240
9
Tommy Channell
United Kingdom
£3,282
10
Gary Bluston
United Kingdom
£2,735
11
Charlie Whitehouse
United Kingdom
£2,735
12
Colin O'Rielly
United States
£2,395
13
Harry Lodge
United Kingdom
£2,395
14
Ken Chow
United Kingdom
£2,190
15
Christopher Yong
United Kingdom
£2,190
16
Kully Sidhu
United Kingdom
£1,985
17
Jen-Yue Chiang
United States
£1,985
18
Josef-Daniel Spulber
Romania
£1,780
19
Alan Stearn
United Kingdom
£1,780
20
Andy Wilson
United Kingdom
£1,780
Dost Ghrabie Eliminated in 2nd Place (£22,347) Posted Monday 17th April, 2023 at 02:59(UTC+0) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 2/141
Sunil Mistri opened for 100,000 from the button. Dost Ghrabie three-bet to 250,000. Mistri jammed and Ghrabie thought for a moment before he called.
Dost Ghrabie: Sunil Mistri:
Ghrabie wound up with a full house on the board. However, with one of the board cards being a ten, Mistri improved to a better full house to win the tournament for £32,285.
Meanwhile, Mistri not only won the £22,347 runner-up prize but also won a Las Vegas package in the 'Spin to Win' promotion that took place when there were just 36 players remaining.
Baihao Wang Eliminated in 3rd Place (£14,771) Posted Monday 17th April, 2023 at 02:42(UTC+0) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 2/141
Beihao Wang (pictured below) open-jammed the button for about 15 big blinds and was up against Sunil Mistri from the small blind.
Beihao Wang: Sunil Mistri:
Mistri's eights held after the rolled out on the board.
A deal was briefly discussed between Dost Ghrabie and Mistri but Mistri didn't seem interested after seeing the figures. Thus the action resumed moments later.
Player
Chips
Progress
Sunil Mistri
2,600,000
1,020,000
Dost Ghrabie
1,600,000
215,000
Beihao Wang
0
0
02:30 (UTC+0)
Start of Level 26 Blinds: 20,000/40,000 Ante: 40,000
Another Deal Shot Down Posted Monday 17th April, 2023 at 02:30(UTC+0) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 3/141
The break took a little longer than planned as players discussed a deal again. They couldn't agree on numbers and the action has moved on.
Meanwhile, the clock is now just 20 minutes in length for three-handed play.
Yuval Rosenberg Eliminated in 4th Place (£12,173) Posted Monday 17th April, 2023 at 02:17(UTC+0) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 3/141
Yuval Rosenberg (pictured below) doubled his short stack twice. Once with fives against five-trey and another time with against to get his stack up to 295,000.
He jammed his 295,000 moments later with but needed a miracle after Dost Ghrabie called with .
Rosenberg connected with his ten on the flop but didn't get any further to pull ahead of his opponent's pocket rockets with the turn and river completing the board.
While Rosenberg was unable to complete a back-to-back Mega Series Main Event victory, he did get awarded with the handsome fourth-place prize of £12,173.
Meanwhile, Ghrabie grabbed the chip lead for the first time at the final table after being short-stacked moments ago.
The final three players asked for a 10-minute break after the hand.
Player
Chips
Progress
Dost Ghrabie
1,815,000
465,000
Sunil Mistri
1,580,000
660,000
Beihao Wang
830,000
95,000
Yuval Rosenberg
0
0
Big Slick for Ghrabie Posted Monday 17th April, 2023 at 02:11(UTC+0) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 4/141
Sunil Mistri opened the button for 60,000. Yuval Rosenberg three-bet to 165,000 from the small blind before Dost Ghrabie four-bet shoved for 635,000.
Mistri folded and the action paused on Rosenberg.
"Alright," said Rosenberg as he made the call.
Dost Ghrabie: Yuval Rosenberg:
The board was good enough for big slick to hold.
"Unlucky," Ghrabie told Rosenberg after the hand.
Player
Chips
Progress
Dost Ghrabie
1,350,000
1,110,000
Yuval Rosenberg
75,000
725,000
Mistri With More Than Half the Chips Posted Monday 17th April, 2023 at 01:52(UTC+0) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 4/141
Yuval Rosenberg opened for 65,000 from under the gun. Sunil Mistri defended his big blind to see the flop.
Mistri check-called a bet of 75,000 by Rosenberg before doing the same for 150,000 on the turn. The river completed the board and both players checked.
Mistri turned over the to win the hand. Rather than muck his cards, Rosenberg showed the . After the hand, Mistri had more than half the chips in play.
Player
Chips
Progress
Sunil Mistri
2,240,000
290,000
Yuval Rosenberg
800,000
800,000
"Let's Just Keep Playing" Posted Monday 17th April, 2023 at 01:38(UTC+0) by Jason Glatzer
No deal was agreed with Sunil Mistri asked for a little more than the ICM figures. Yuval Rosenberg just wanted to keep playing which put an end to the discussion until it is at least three-handed play.
"Let's just keep playing," said Rosenberg.
Sebastien Jung Eliminated in 5th Place (£9,779) Posted Monday 17th April, 2023 at 01:26(UTC+0) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 4/141
Yuval Rosenberg min-raised from under the gun and was called by both Sunil Mistri from the small blind and Sebastien Jung (pictured below) from the big blind.
Mistri and Jung both checked the flop. Rosenberg continued for 100,000. Mistri called before Jung jammed for 435,000. Rosenberg went into the tank before he folded. Mistri paused for 30 seconds before he called.
Sebastien Jung: Sunil Mistri:
Jung flopped two pair but was in a bit of trouble after Mistri completed his flush draw on the turn. No full house came for Jung on the river and he hit the rail in fifth place for £9,779.
The final four players agreed to pause the clock to discuss a deal.
Player
Chips
Progress
Sunil Mistri
1,950,000
700,000
Yuval Rosenberg
1,260,000
340,000
Beihao Wang
665,000
70,000
Dost Ghrabie
355,000
115,000
Sebastien Jung
0
0
01:18 (UTC+0)
Start of Level 25 Blinds: 15,000/30,000 Ante: 30,000
Tens Good for Wang Posted Monday 17th April, 2023 at 01:12(UTC+0) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 5/141
Sunil Mistri opened for a min-raise from under the gun. Dost Ghrabie three-bet jammed for about 600,000 from the small blind. Beihao Wang tanked for less than a minute before he called off his stack of 330,000. Mistri quickly folded and the players showed their hands.
Beihao Wang: Dost Ghrabie:
It was looking like Ghrabie would hit the showers after Ghrabie improved to a pair of jacks on the flop. Wang was still down to just two outs after the turn.
"Oooooh," the table gasped as the river spiked the board to save Wang and double his stack.
"I had king-jack," shared Mistri after the hand.
Player
Chips
Progress
Beihao Wang
735,000
245,000
Dost Ghrabie
240,000
160,000
Defending Champ Rosenberg Regains the Lead With Jacks Posted Monday 17th April, 2023 at 01:03(UTC+0) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 5/141
Sunil Mistri opened for 50,000 from the button. Defending Mega Series Main Event Champion Yuval Rosenberg three-bet to 175,000 and Mistri called.
Rosenberg continued for 150,000 on the flop. Mistri called and both players checked the turn.
The river paired the board. Rosenberg bet 175,000. Mistri tanked for a minute before he called.
Rosenberg turned over . This was enough as he won the hand after Mistri mucked his cards.
Player
Chips
Progress
Yuval Rosenberg
1,600,000
400,000
Sunil Mistri
1,250,000
350,000
Updated Payouts Posted Monday 17th April, 2023 at 00:46(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
£ 32,825
2
£ 22,347
3
£ 14,771
4
£ 12,173
5
£9,779
6
Chris Da Silva
United Kingdom
£7,659
7
Tamer Ovutmen
Turkey
£5,744
8
Luke Porter
United Kingdom
£4,240
9
Tommy Channell
United Kingdom
£3,282
10
Gary Bluston
United Kingdom
£2,735
11
Charlie Whitehouse
United Kingdom
£2,735
12
Colin O'Rielly
United States
£2,395
13
Harry Lodge
United Kingdom
£2,395
14
Ken Chow
United Kingdom
£2,190
15
Christopher Yong
United Kingdom
£2,190
16
Kully Sidhu
United Kingdom
£1,985
17
Jen-Yue Chiang
United States
£1,985
18
Iosef-Daniel Spulber
Romania
£1,780
19
Alan Stearn
United Kingdom
£1,780
20
Andy Wilson
United Kingdom
£1,780
Chris Da Silva Eliminated in 6th Place (£7,659) Posted Monday 17th April, 2023 at 00:45(UTC+0) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 5/141
Sunil Mistri opened for 50,000 from the button. Chris Da Silva (pictured below) jammed for about 325,000 from the big blind and Mistri snap-called.
Chris Da Silva: Sunil Mistri:
Da Silva ran into a monster and didn't get enough help on the board to pull ahead. The PokerStars at the Hippodrome Ambassador won't go home empty-handed as he will collect the sixth place prize of £7,659.
Player
Chips
Progress
Sunil Mistri
1,600,000
500,000
Chris Da Silva
0
0
00:27 (UTC+0)
Start of Level 24 Blinds: 10,000/25,000 Ante: 25,000
Trips for Rosenberg Posted Monday 17th April, 2023 at 00:13(UTC+0) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 6/141
Chris Da Silva checked the river with the on the board before Yuval Rosenberg fired out for half the pot for 125,000.
Da Silva paused for a moment before he called. Rosenberg turned over for trips.
"Nice hand," Da Silva said to Rosenberg as he tossed his hand into the muck.
Player
Chips
Progress
Yuval Rosenberg
1,200,000
200,000
Chris Da Silva
300,000
300,000
Updated Chip Counts Posted Monday 17th April, 2023 at 00:05(UTC+0) by Jason Glatzer
There are still no big hands to report during Level 23. Here is a look at the chip counts:
Player
Chips
Progress
Sunil Mistri
1,100,000
140,000
Yuval Rosenberg
1,000,000
100,000
Sebastien Jung
835,000
0
Chris Da Silva
600,000
40,000
Beihao Wang
490,000
10,000
Dost Ghrabie
400,000
110,000
Players Agree to Structure Change Posted Sunday 16th April, 2023 at 23:51(UTC+0) by Jason Glatzer
Chris Da Silva asked the table if they want to reduce the 50-minute clock. Instead of reducing immediately, the table agreed that it will be a 40-minute clock when the action is down to five-handed play and a 30-minute clock when it is down to four-handed play.
Meanwhile, the action has been a little slower with most pots taken down preflop and others taken down on the flop.
23:36 (UTC+0)
Start of Level 23 Blinds: 10,000/20,000 Ante: 20,000
Updated Chip Counts at Break Posted Sunday 16th April, 2023 at 23:31(UTC+0) by Jason Glatzer
Player
Chips
Progress
Yuval Rosenberg
1,100,000
0
Sunil Mistri
960,000
135,000
Sebastien Jung
835,000
165,000
Chris Da Silva
640,000
10,000
Beihao Wang
500,000
75,000
Dost Ghrabie
290,000
50,000
Short Break Posted Sunday 16th April, 2023 at 23:21(UTC+0) by Jason Glatzer
Players are on a 15-minute break. Blinds will increase to 10,000/20,000 with a 20,000 big blind ante when the action resumes.
Da Silva Doubles With Ladies Posted Sunday 16th April, 2023 at 23:15(UTC+0) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 6/141
Sunil Mistri opened for 30,000 from under the gun. Chris Da Silva jammed for 296,000 from the cutoff. Mistri asked for a count before he called with Da Silva at risk.
Chris Da Silva: Sunil Mistri:
Da Silva's ladies held after the ran out on the board to double his stack through Mistri.
Player
Chips
Progress
Sunil Mistri
825,000
435,000
Chris Da Silva
630,000
330,000
Tamer Ovutmen Eliminated in 7th Place (£5,744) Posted Sunday 16th April, 2023 at 22:52(UTC+0) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 6/141
Despite just doubling his short stack twice, Tamer Ovutmen (pictured below) found himself on the rail shortly after. He three-bet jammed for 71,000 from the button and as called by Yuval Rosenberg from early position.
Tamer Ovutmen: Yuval Rosenberg:
Rosenberg's big slick was good on the runout to eliminate Ovutmen in seventh place for £5,744.
Player
Chips
Progress
Yuval Rosenberg
1,100,000
50,000
Tamer Ovutmen
0
0
Jung Doubles Again Through Ovutmen Posted Sunday 16th April, 2023 at 22:50(UTC+0) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 7/141
Tamer Ovutmen opened for 32,000 from under the gun. Sebastien Jung three-bet to 85,000 from the hijack. Ovutmen four-bet jammed for 469,000 and Jung called off for 455,000.
Sebastien Jung: Tamer Ovutmen:
Jung's ladies held on the board to double through Ovutmen for the second time at the final table. Meanwhile, Ovutmen was down to less than a big blind before he doubled it up through Beihao Wang when his held against .
The next hand, Ovutmen doubled again when his from the small blind got there against held by Sunil Mistri when the board improved Ovutmen to a flush.
Player
Chips
Progress
Sebastien Jung
1,000,000
634,000
Tamer Ovutmen
71,000
929,000
22:35 (UTC+0)
Start of Level 22 Blinds: 10,000/15,000 Ante: 15,000
"You Never Believe Me" Posted Sunday 16th April, 2023 at 22:35(UTC+0) by Jason Glatzer
Level 21: 6,000/12,000 (12,000) Entries: 7/141
Chris Da Silva opened for 25,000 from the cutoff and was called by Yuval Rosenberg from the button.
Da Silva continued for 25,000 on the flop and was called by Rosenberg. Da Silva then check-called a bet of 50,000 by Rosenberg on the turn before leading out for 85,000 on the river.
Rosenberg tanked for several moments before he raised to 210,000. Da Silva then paused for about a minute before he called. Rosenberg turned over the nuts with and Da Silva mucked his cards.
"You never believe me," Rosenberg said to Da Silva.
"Nice hand," said Tamer Ovutmen to Rosenberg as the blinds went up the following hand with Rosenberg back with the chip lead.
Player
Chips
Progress
Yuval Rosenberg
1,050,000
225,000
Chris Da Silva
300,000
255,000
Luke Porter Eliminated in 8th Place (£4,240) Posted Sunday 16th April, 2023 at 22:23(UTC+0) by Jason Glatzer
Level 21: 6,000/12,000 (12,000) Entries: 7/141
Chris Da Silva opened for 25,000 from early position. Luke Porter jammed for 234,000 from middle position. Da Silva had his opponent covered by a little and made the call.
Luke Porter: Chris Da Silva:
Da Silva binked a set to eliminate Porter in eighth place for £4,240 after the ran out on the board.
The final seven players have now each locked up at least £5,744.
Player
Chips
Progress
Chris Da Silva
555,000
180,000
Luke Porter
0
0
Friendly River for Rockets for Mistri Posted Sunday 16th April, 2023 at 22:18(UTC+0) by Jason Glatzer
Level 21: 6,000/12,000 (12,000) Entries: 8/141
Sunil Mistri opened for 24,000 from under the gun and was called by Dost Ghrabie from the big blind. Ghrabie led out for 50,000 on the flop and for 125,000 on the turn and was called both times by Mistri.
Ghrabie checked the river and Mistri jammed for 290,000. Ghrabie counted out his chips and called a couple of minutes later.
Mistri turned over for a rivered set of aces. Ghrabie shooked his head in frustration and doubled up Mistri after he turned over for a flopped two pair.
Mistri held the chip lead after doubling his stack.
Player
Chips
Progress
Sunil Mistri
1,000,000
610,000
Tamer Ovutmen
550,000
150,000
Dost Ghrabie
240,000
510,000
Jung Doubles Through Ovutmen Posted Sunday 16th April, 2023 at 21:53(UTC+0) by Jason Glatzer
Level 21: 6,000/12,000 (12,000) Entries: 8/141
Tamer Ovutmen opened for 25,000 from the cutoff before Sebastien Jung jammed for 171,000. Ovutmen snap-called with Jung at risk.
Sebastien Jung: Tamer Ovutmen:
Jung paired up his jack to push ahead of his opponent's tens to double his stack after the ran out on the board.
Player
Chips
Progress
Tamer Ovutmen
400,000
181,000
Sebastien Jung
366,000
181,000
Ace-Jack Suited for Wang Posted Sunday 16th April, 2023 at 21:46(UTC+0) by Jason Glatzer
Level 21: 6,000/12,000 (12,000) Entries: 8/141
Sebastien Jung opened for 25,000 from middle position and was called by Beihao Wang from the big blind.
Wang check-called bets by Jung of 15,000 on the flop and for 30,000 on the turn. Both players checked the river. Wang turned over and won the hand after Jung mucked.
Player
Chips
Progress
Beihao Wang
575,000
28,000
Sebastien Jung
185,000
150,000
21:39 (UTC+0)
Start of Level 21 Blinds: 6,000/12,000 Ante: 12,000
First Final Table Break Posted Sunday 16th April, 2023 at 21:29(UTC+0) by Jason Glatzer
Players are on a quick official break. Here is a look at the official final table.
Tommy Channell Eliminated in 9th Place (£3,282) Posted Sunday 16th April, 2023 at 21:26(UTC+0) by Jason Glatzer
Level 20: 5,000/10,000 (10,000) Entries: 8/141
Tommy Channell (pictured below) opened for 25,000 from middle position. Chris Da Silva called from the small blind before Yuval Rosenberg three-bet to 90,000 from the big blind. Channell jammed for about 200,000. Da Silva quickly folded and Rosenberg snap-called.
Tommy Channell: Yuval Rosenberg:
Rosenberg's pocket rockets held on the board to eliminate Channell in ninth place for £3,282.
The action paused for a minute for the official final table photo after the hand. Rosenberg is in prime position for back-to-back Mega Series Main Event victories after shipping this event in November as he will kick off the official final table with the chip lead.
Player
Chips
Progress
Yuval Rosenberg
825,000
278,000
Tommy Channell
0
0
Da Silva Takes it Down With a Check-Jam Posted Sunday 16th April, 2023 at 21:17(UTC+0) by Jason Glatzer
Level 20: 5,000/10,000 (10,000) Entries: 9/141
Chris Da Silva min-raised from under the gun and was called by Tommy Channell from the hijack, Beihao Wang from the button, and Sebastian Yong from the big blind.
The action checked around to Channell on the flop, who fired out for 40,000. Wang and Yong folded, while Da Silva called to see the paired the board on the turn.
Da Silva checked again. Channell bet 75,000. Da Silva tanked for a minute before he jammed for 147,000. Channell tanked for a couple of minutes before he folded and the dealer awarded Da Silva the pot.
Player
Chips
Progress
Chris Da Silva
375,000
40,000
Tommy Channell
240,000
260,000
Ghrabie Takes the Chip Lead Posted Sunday 16th April, 2023 at 20:59(UTC+0) by Jason Glatzer
Level 20: 5,000/10,000 (10,000) Entries: 9/141
Tommy Channell opened for 20,000 from under the gun before Dost Ghrabie (pictured below) defended his big blind.
Both players checked the flop. Ghrabie check-raised the turn from 35,000 to 105,000 and Channell called.
Ghrabie jammed the river for about 400,000 in chips. This was most of Channell's stack. Channell went into the tank for about a minute before he folded. Ghrabie grabbed the chip lead after the hand.
Player
Chips
Progress
Dost Ghrabie
750,000
247,000
Tommy Channell
500,000
104,000
Unofficial Final Table Seat Draw Posted Sunday 16th April, 2023 at 20:35(UTC+0) by Jason Glatzer
Seat
Player
Chips
Big Blinds
1
Sebastien Jung
335,000
34
2
Chris Da Silva
335,000
34
3
Yuval Rosenberg
547,000
55
4
Luke Porter
332,000
33
5
Dost Ghrabie
503,000
50
6
Tommy Channell
604,000
60
7
Beihao Wang
603,000
60
8
Tamer Ovutmen
581,000
58
9
Sunil Mistri
390,000
39
Player
Chips
Progress
Tommy Channell
604,000
96,000
Beihao Wang
603,000
123,000
Tamer Ovutmen
581,000
1,000
Yuval Rosenberg
547,000
153,000
Dost Ghrabie
503,000
3,000
Sunil Mistri
390,000
135,000
Sebastien Jung
335,000
35,000
Chris Da Silva
335,000
15,000
Luke Porter
332,000
266,500
Updated Payouts Posted Sunday 16th April, 2023 at 20:29(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
£ 32,825
2
£ 22,347
3
£ 14,771
4
£ 12,173
5
£9,779
6
£7,659
7
£5,744
8
£4,240
9
£3,282
10
Gary Bluston
United Kingdom
£2,735
11
Charlie Whitehouse
United Kingdom
£2,735
12
Colin O'Rielly
United States
£2,395
13
Harry Lodge
United Kingdom
£2,395
14
Ken Chow
United Kingdom
£2,190
15
Christopher Yong
United Kingdom
£2,190
16
Kully Sidhu
United Kingdom
£1,985
17
Jen-Yue Chiang
United States
£1,985
18
Iosef-Daniel Spulber
Romania
£1,780
19
Alan Stearn
United Kingdom
£1,780
20
Andy Wilson
United Kingdom
£1,780
Player
Chips
Progress
Tommy Channell
604,000
96,000
Beihao Wang
603,000
123,000
Tamer Ovutmen
581,000
1,000
Yuval Rosenberg
547,000
153,000
Dost Ghrabie
503,000
3,000
Sunil Mistri
390,000
135,000
Sebastien Jung
335,000
35,000
Chris Da Silva
335,000
15,000
Luke Porter
332,000
266,500
Unofficial Final Table Reached After Bluston Loses His Short Stack Posted Sunday 16th April, 2023 at 20:21(UTC+0) by Jason Glatzer
Level 20: 5,000/10,000 (10,000) Entries: 9/141
Gary Bluston jammed for 10 big blinds with ten-nine and was called by Dost Ghrabie with ace-ten. No miracle came for Bluston and he was eliminated in 10th place.
The unofficial final table will kick off after a 10-minute break. We will post a seat draw along with the chip counts shortly.
Player
Chips
Progress
Dost Ghrabie
500,000
50,000
Gary Bluston
0
0
20:17 (UTC+0)
Start of Level 20 Blinds: 5,000/10,000 Ante: 10,000
Da Silva Sends Whitehouse to the Rail on a Bad Beat Posted Sunday 16th April, 2023 at 20:16(UTC+0) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 10/141
Charlie Whitehouse jammed for 99,000 from the button. The action paused on Chris Da Silva from the small blind who jammed for twice as much from the small blind. The player in the big blind folded and the cards were exposed.
Charlie Whitehouse: Chris Da Silva:
Whitehouse was ahead but fell behind after Da Silva's three found a partner on the flop. Neither the turn nor the river helped Whitehouse get back ahead and he was on the rail in 11th place.
Player
Chips
Progress
Chris Da Silva
320,000
112,000
Charlie Whitehouse
0
0
Ghrabie Grabs O'Rielly's Stack Posted Sunday 16th April, 2023 at 20:05(UTC+0) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 11/141
It was a heck of a run for the 20-year-old American Colin O'Rielly (pictured below). But sometimes all good things must come to an end.
O'Rielly jammed for 110,000 from the cutoff and was called by Dost Ghrabie from the small blind.
Colin O'Rielly: Dost Ghrabie:
O'Rielly was unable to improve on the board and was on the rail in 12th place.
Player
Chips
Progress
Dost Ghrabie
450,000
378,000
Colin O'Reilly
0
0
Lodge Runs Nines Into Ovutmen's Tens Posted Sunday 16th April, 2023 at 19:53(UTC+0) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 12/141
Tamer Ovutmen opened the button for 20,000. Harry Lodge three-bet jammed for close to 20 big blinds from the small blind and Ovutmen called.
Harry Lodge: Tamer Ovutmen:
Lodge was unable to get his nines ahead of tens on the board and was on the rail in 13th place.
Player
Chips
Progress
Tamer Ovutmen
580,000
200,000
Harry Lodge
0
0
Rockets for Da Silva Posted Sunday 16th April, 2023 at 19:45(UTC+0) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 13/141
Harry Lodge min-raised the cutoff. Chris Da Silva jammed for 92,000 from the small blind and Lodge called after deliberating for half a minute.
Chris Da Silva: Harry Lodge:
Da Silva doubled his stack after his rockets held on the runout.
Player
Chips
Progress
Chris Da Silva
208,000
92,000
Harry Lodge
200,000
30,000
Lodge Eliminated Chow With a Better Straight Posted Sunday 16th April, 2023 at 19:39(UTC+0) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 13/141
Ken Chow (pictured below) got his short stack in the middle with and was up against the held by Harry Lodge.
Both players improved to a straight on the runout. Lodge's straight was better and Chow hit the rail in 14th place.
Player
Chips
Progress
Harry Lodge
230,000
30,000
Ken Chow
0
0
Yong Loses a Flip to Bluston on the River Posted Sunday 16th April, 2023 at 19:34(UTC+0) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 14/141
Gary Bluston jammed for 160,000 from middle position and was called by Christopher Yong for a little less from the button.
Christopher Yong: Gary Bluston:
"It isn't looking good," said Bluston after getting nowhere on the flop.
The turn didn't change anything. However, the spiked the river to improve Bluston to a better pair to eliminate Yong.
Meanwhile, Kully Sidhu went out moments before so Yong was able to ladder up from a £1,985 payout to £2,190.
Player
Chips
Progress
Gary Bluston
300,000
85,000
Kully Sidhu
0
0
Christopher Yong
0
0
Yong Doubles His Short Stack Posted Sunday 16th April, 2023 at 19:29(UTC+0) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 16/141
Tommy Channell opened from the small blind before he called a three-bet jam by Christopher Yong in the big blind for 57,000.
Christopher Yong: Tommy Channell:
Yong remained ahead the entire way and doubled with a pair of kings after the ran out on the board.
"Nice hand," Channell told Yong after he was drawing dead on the turn.
Player
Chips
Progress
Tommy Channell
700,000
50,000
Christopher Yong
122,000
69,000
19:25 (UTC+0)
Start of Level 19 Blinds: 4,000/8,000 Ante: 8,000
Payouts Thus Far Posted Sunday 16th April, 2023 at 19:23(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
17
Jen-Yue Chiang
United States
£1,985
18
Iosef-Daniel Spulber
Romania
£1,780
19
Alan Stearn
United Kingdom
£1,780
20
Andy Wilson
United Kingdom
£1,780
Big Stacks at Break Posted Sunday 16th April, 2023 at 19:15(UTC+0) by Jason Glatzer
Player
Chips
Progress
Tommy Channell
750,000
50,000
Yuval Rosenberg
700,000
250,000
Beihao Wang
480,000
80,000
Tamer Ovutmen
380,000
75,000
"Still Running Good, Baby" Posted Sunday 16th April, 2023 at 19:05(UTC+0) by Jason Glatzer
Level 18: 3,000/6,000 (6,000) Entries: 16/141
Kully Sidhu opened the button for 12,000 before Colin O'Rielly jammed his stack of 57,000. Sidhu called and the cards were turned over.
Colin O'Rielly: Kully Sidhu:
"You looked at me like you don't have it," Sidhu said.
"I always have it," O'Rielly said with a smile.
O'Rielly doesn't necessarily always have it but he always seems to get there. This time his cowboys held on the runout to double up with a set.
"Still running good, baby," said O'Rielly after the hand.
Meanwhile, Jen-Yue Chiang hit the rail in 17th place and the remaining players went on a 20-minute break after the hand.
Player
Chips
Progress
Kully Sidhu
140,000
15,000
Colin O'Reilly
125,000
25,000
Jen-Yue Chiang
0
0
Jung Ousts Stearn Posted Sunday 16th April, 2023 at 18:56(UTC+0) by Jason Glatzer
Level 18: 3,000/6,000 (6,000) Entries: 18/141
Alan Stearn opened for 15,000 before he called off his stack of around 100,000 facing a jam by Sebastian Jung.
Stearn held ace-jack and was unable to improve against Jung's ace-queen to hit the rail in 19th place for £1,780. Moments later, Iosef-Daniel Spulber hit the rail in 18th place. The final 17 players earned a pay jump to £1,985.
Player
Chips
Progress
Sebastien Jung
400,000
192,500
Alan Stearn
0
0
Iosef-Daniel Spulber
0
0
Wilson First Out in the Money Posted Sunday 16th April, 2023 at 18:51(UTC+0) by Jason Glatzer
Level 18: 3,000/6,000 (6,000) Entries: 19/141
Andy Wilson was the first player out in the money. He was grinding a short stack at the same time he was grinding a Day 2 in an online event at PokerStars.
We didn't catch the hand but we wish Wilson the best of luck winning his online event.
Player
Chips
Progress
Andy Wilson
0
0
Tommy Winstone Eliminated on the Bubble Posted Sunday 16th April, 2023 at 18:49(UTC+0) by Jason Glatzer
Level 18: 3,000/6,000 (6,000) Entries: 20/141
Tom Winstone (pictured below) jammed for 57,000 from the hijack and was called by Tommy Channell from the button.
The action paused for nearly 10 minutes with Chris Da Silva having a big decision to make after jammed upon by Yuval Rosenberg. Da Silva kept asking when Rosenberg's birthday. Rosenberg remained stoic throughout and Da Silva eventually folded.
A crowd surrounded Winstone's table as the cards were being turned over.
Tom Winstone: Tommy Channell:
The board didn't push ace-deuce ahead of ace-jack and Winstone hit the rail on the bubble.
"Good game and good luck," Winstone said on his way out to the remaining players.
The final 20 players have now locked up at least a min-cash of £1,780. Congrats to the final 20 players!
Player
Chips
Progress
Tommy Channell
700,000
100,000
Tom Winstone
0
0
"Absolutely Nothing Happening Here" Posted Sunday 16th April, 2023 at 18:20(UTC+0) by Jason Glatzer
Level 18: 3,000/6,000 (6,000) Entries: 21/141
Andy Wilson jammed for 57,000 from early position and was called by Beihao Wang.
Both players had an offsuit big slick and immediately the tournament director who was announcing the hand said: "Absolutely nothing is happening here," which got a laugh from nearly all of the players.
As the hand was being dealt, Wilson said: "I've already lost one of these today."
The two players chopped it up and the money bubble, which has been going on for more than 30 minutes, will continue.
Player
Chips
Progress
Beihao Wang
400,000
25,000
Andy Wilson
64,500
15,500
18:13 (UTC+0)
Start of Level 18 Blinds: 3,000/6,000 Ante: 6,000
Turbo Bounty Begins Posted Sunday 16th April, 2023 at 18:07(UTC+0) by Jason Glatzer
The £225 Turbo Bounty has just kicked off with a tidy field of 12 players. Late registration will be open for the first six blind levels of 15 minutes each.
Best of luck to the Turbo Bounty players.
Hand-For-Hand After Rosenberg Coolers Miller Posted Sunday 16th April, 2023 at 17:53(UTC+0) by Jason Glatzer
Level 17: 2,500/5,000 (5,000) Entries: 21/141
There were heaps in the pot when Gary Miller fired out for 35,000 with the on the board. Yuval Rosenberg raised to 100,000 and called after Miller three-bet shoved for 25,000.
Miller turned over for a full house. But his full house wasn't good enough as Rosenberg turned over to eliminate Miller with a better full house.
The action went hand-for-hand on the money bubble after this hand.
Another interesting fact was until now, all players that started the day on Table 6 were in action. They nearly all made the money but Miller also began the day at that table to break the streak.
Player
Chips
Progress
Yuval Rosenberg
500,000
230,000
Gary Miller
0
0
McKinney Loses His Chips to Miller Posted Sunday 16th April, 2023 at 17:40(UTC+0) by Jason Glatzer
Level 17: 2,500/5,000 (5,000) Entries: 22/141
Andrew McKinney three-bet squeezed from the big blind for 10 big blinds and was called by Gary Miller.
Andrew McKinney: Gary Miller:
McKinney lost the flip and his stack after Miller's jack found a friend on the runout.
Player
Chips
Progress
Gary Miller
190,000
50,500
Andrew McKinney
0
0
34 Entries in the Ladies Event Posted Sunday 16th April, 2023 at 17:37(UTC+0) by Jason Glatzer
The £175 Ladies Event attracted 34 entries to generate a £4,947 prize pool. A total of 10 entries busted during the late registration period, but each of them got back into the action with 24 ladies battling it out for the title.
Chow Doubles Through Lodge Posted Sunday 16th April, 2023 at 17:31(UTC+0) by Jason Glatzer
Level 17: 2,500/5,000 (5,000) Entries: 23/141
Ken Chow jammed for 51,500 from the button and the flip was on after he was snap-called by Harry Lodge.
Ken Chow: Harry Lodge:
Chow began to pile up his chips instead of hitting the rail after Lodge whiffed the runout.
Player
Chips
Progress
Harry Lodge
200,000
60,000
Ken Chow
110,000
45,000
17:17 (UTC+0)
Start of Level 17 Blinds: 2,500/5,000 Ante: 5,000
Second Main Event Break Posted Sunday 16th April, 2023 at 16:58(UTC+0) by Jason Glatzer
The Main Event is on its second break of Day 2. The blinds will increase to 2,500/5,000 with a 5,000 big blind ante when the action resumes in 20 minutes.
It is expected that sometime before the next break, the money bubble will break with the top 20 players each guaranteed at least a £1,780 min-cash.
10 Minutes of Late Reg in the Ladies Event Posted Sunday 16th April, 2023 at 16:56(UTC+0) by Jason Glatzer
The Ladies Event has been hopping and let's just say it seems like all the women playing are having a good time laughing and cheering.
That being said, it hasn't been the smoothest start for seven of the women with the unlucky seven hitting the rail. All seven got back into play so the field is at 31 entries with 24 players remaining. We will try to provide more updates as the day goes on, but the action in the Main Event has been hot and heavy.
Wang Doubles Through Da Silva Posted Sunday 16th April, 2023 at 16:53(UTC+0) by Jason Glatzer
Level 16: 2,000/4,000 (4,000) Entries: 23/141
We caught up to the table when Belhao Wang with was collecting a massive pot of 425,000 against Chris Da Silva with with the on the board.
Da Silva shared with us after the hand that the chips went in on the turn. While this was a temporary end to the uphill tick on Da Silva's ongoing rollercoaster ride of a day, he is still in good shape with 300,000 despite getting his aces cracked.
Player
Chips
Progress
Beihao Wang
425,000
385,500
Chris Da Silva
300,000
225,000
Channell Takes the Lead After Picking Off Wilson Posted Sunday 16th April, 2023 at 16:42(UTC+0) by Jason Glatzer
Level 16: 2,000/4,000 (4,000) Entries: 23/141
Tommy Channell (pictured below) just won a massive pot against Andy Wilson as follows.
Channell bet 15,000 with a bunch of chips already in the pot with the on the board after the turn. Christopher Yong called before Wilson jacked it up to 67,000. Channell called and Yong folded.
Channell checked again on the river. Wilson jammed for more than the 208,500 his opponent had behind. Channell went into the tank for several minutes.
"You don't have the nuts," said Channell. "I have the king of diamonds."
After some more time, Channell found the hero-call. Wilson turned over and nearly got away with stealing away the pot. However, Channell turned over for the straight to win the hand and take the chip lead.
"I told myself this morning that I am here to win," said Channell.
Meanwhile, we are getting closer to the money as we are just three players off after Eliran Argelazi hit the rail at another table shortly after this hand to leave just 23 players remaining and 20 players finishing in the money.
Player
Chips
Progress
Tommy Channell
600,000
300,000
Chris Da Silva
525,000
70,000
Andy Wilson
80,000
260,000
Eliran Argelazi
0
0
Three Table Redraw After Otto and Ille Hit the Rail Posted Sunday 16th April, 2023 at 16:14(UTC+0) by Jason Glatzer
Level 16: 2,000/4,000 (4,000) Entries: 24/141
Both Ryan Otto and Darie Ille both lost their stacks and the action is down to just 24 players with 20 of them making at least a £1,780 min-cash.
There is a short pause in the action as the three table redraw takes place.
"Easy Game" for Da Silva to Eliminate Start of the Day Chip Leader Demetriou Posted Sunday 16th April, 2023 at 16:10(UTC+0) by Jason Glatzer
Level 16: 2,000/4,000 (4,000) Entries: 26/141
Chris Da Silva just eliminated the start-of-the-day chip leader George Demetriou.
Demetriou was down to just 51,000 when he squeezed over a bet and a call by Da Silva and Dost Ghrabie. Da Silva called with king-ten suited and was up against ace-jack after Ghrabie folded.
Da Silva shared a ten came on the flop and the turn and river didn't improve Demetriou to hit the rail.
"Easy game," Da Silva shared after being on a roll.
Keep in mind, earlier today Da Silva was below a starting stack and appeared to be slightly frustrated about losing a handful of flips. That has all changed as Da Silva extended his chip lead with just 26 players remaining with Danjel Petro also recently hitting the rail.
Player
Chips
Progress
Chris Da Silva
455,000
55,000
Danjel Petro
0
0
George Demetriou
0
0
Da Silva in the Lead to Start Level 16 Posted Sunday 16th April, 2023 at 16:04(UTC+0) by Jason Glatzer
Level 16: 2,000/4,000 (4,000) Entries: 28/141
PokerStars at the Hippodrome Ambassador Chris Da Silva held the chip lead with about 400,000 in chips to start Level 16. Here is a look at the top five chip stacks.
Player
Chips
Progress
Chris Da Silva
400,000
85,000
Andy Wilson
340,000
260,500
Tamer Ovutmen
305,000
5,000
Tommy Channell
300,000
173,500
Yuval Rosenberg
270,000
105,000
15:59 (UTC+0)
Start of Level 16 Blinds: 2,000/4,000 Ante: 4,000
Ji Loses His Short Stack Posted Sunday 16th April, 2023 at 15:56(UTC+0) by Jason Glatzer
Level 15: 1,500/3,000 (3,000) Entries: 28/141
Min Ji three-bet jammed for 19,000 and was called by Kully Sidhu who originally opened the action.
Min Ji: Kully Sidhu:
Ji got nowhere on a blank board for ace-six suited. Meanwhile, Sidhu improved to a set of deuces to eliminate his opponent and snag his short stack.
Player
Chips
Progress
Kully Sidhu
125,000
10,000
Min Ji
0
0
"I Run So Good!" (Part 3) Posted Sunday 16th April, 2023 at 15:48(UTC+0) by Jason Glatzer
Level 15: 1,500/3,000 (3,000) Entries: 29/141
Twenty-year-old cash game player Colin O'Rielly has been enjoying his time playing his first-ever live poker tournament. One can see why as he is running as good as he has been advertising.
In a recent hand, he jammed 27,000 into a pot of a bit more with the on the board and was snap-called by Andrew McKinney.
Colin O'Rielly: Andrew McKinney:
O'Rielly was in for a world of hurt. But he has been in this situation before and didn't get out of his chair like many players would do in this spot down to just two outs. His two outer came on the turn and now he had to sweat a two outer for McKinney to potentially get back ahead. The bricked the river for McKinney and O'Rielly doubled once again.
"I run so good!" O'Rielly said for at least the third time today after we caught two previous double-ups earlier today.
Player
Chips
Progress
Colin O'Reilly
100,000
18,000
Andrew McKinney
60,000
41,000
Ovutmen Wins Massive Flip Against Demetriou Posted Sunday 16th April, 2023 at 15:43(UTC+0) by Jason Glatzer
Level 15: 1,500/3,000 (3,000) Entries: 29/141
The start of the day chip leader George Demetriou is now low on chips. He just lost a massive pot to Tamer Ovutmen as follows.
Ovutmen checked the flop. Demetriou fired out for 25,000 and Ovutmen jammed over the top for 138,000. Demetriou tanked for a couple of minutes before he called.
Tamer Ovutmen: George Demetriou:
It was basically a coin-flip situation. However, that all changed after Ovutmen improved to two pair on the turn leaving Demetriou with only a flush draw with one card to come. The paired the board on the river for Ovutmen to double with a full house.
Player
Chips
Progress
Tamer Ovutmen
310,000
175,500
George Demetriou
65,000
185,000
Argelazi Delivers Bad Beat to Winstone Posted Sunday 16th April, 2023 at 15:35(UTC+0) by Jason Glatzer
Level 15: 1,500/3,000 (3,000) Entries: 29/141
Kully Sidhu opened for 6,500 from under the gun. Eliran Argelazi (pictured below) three-bet for a good portion of his stack before Tom Winstone four-bet jammed for about 150,000. Sidhu folded and Argelazi called.
Eliran Argelazi: Tom Winstone:
Both players snagged a piece of the flop with Winstone hitting top pair and Argelazi having tons of hope with both a flush draw and a gutshot Broadway draw.
"What an action flop!" a player at the table commented.
The turn improved Argelazi to a flush but Winstone could have still won the hand if the board paired with either a full house or quads. However, the blank fell on the river and Argelazi delivered a bad beat to Winstone to stay alive and double his stack.
Meanwhile, Joe Bold lost his stack at another table to leave just 29 players remaining.
Player
Chips
Progress
Kully Sidhu
115,000
63,000
Tom Winstone
105,000
21,000
Eliran Argelazi
100,000
77,000
Joe Bold
0
0
Brossoit Runs Into Cowboys; Schuman Gets His Aces Cracked Posted Sunday 16th April, 2023 at 15:22(UTC+0) by Jason Glatzer
Level 15: 1,500/3,000 (3,000) Entries: 30/141
Kenneth Brossoit three-bet jammed for less than 20 big blinds with ace-queen and was called by Iosef-Daniel Spulber with cowboys.
A king hit the flop and the rest was history for Brossoit. Shortly after, Jonathan Schuman joined Brossoit on the rail at a different table to leave just 30 players remaining in the Main Event field.
Schuman, who won the Mystery Bounty event earlier in this week for more than £7K and won the top mystery bounty of £7,500, the VIP package to the Malta Poker Festival in a little more than a week at Portomaso Casino from April 24 to May 1, and more bounties, shared that he was jammed upon on the turn by a player with queen-ten with both a queen and a ten on the board. No love came on the river and we will see Schuman in Malta.
Player
Chips
Progress
Iosef-Daniel Spulber
165,000
81,500
Jonathan Schuman
0
0
Kenneth Brossoit
0
0
Fives No Good for Eriksson Posted Sunday 16th April, 2023 at 15:16(UTC+0) by Jason Glatzer
Level 15: 1,500/3,000 (3,000) Entries: 32/141
Tommy Eriksson jammed for 50,000 from the button. Harry Lodge came in for a bit more from the small blind and the player in the big blind folded.
Tommy Eriksson: Harry Lodge:
Lodge improved to trips on the flop and never looked back with the turn and river completing the board to send Eriksson to the rail.
Meanwhile, Lodge began the day with less than a starting stack. Things have gone well, to say the least for the British poker beast as he had approximately 140,000 in chips after the hand.
Player
Chips
Progress
Harry Lodge
140,000
118,500
Tommy Eriksson
0
0
15:08 (UTC+0)
Start of Level 15 Blinds: 1,500/3,000 Ante: 3,000
Ladies Event Begins Posted Sunday 16th April, 2023 at 15:06(UTC+0) by Jason Glatzer
Ladies Event Level 1: 100/100 Entries: 15/15
The Ladies Event has kicked off with a field of 15 players. The field will continue to grow with late registration open for six 20-minute blind levels. Players can re-enter for a fresh stack of 20,000 up to two times.
There are leaderboard points on the line for the final tournament for the coveted Las Vegas package.
Friend of PokerStars at the Hippodrome Lydia Cugudda (pictured below), Karen Arthur, Mary Bone, Charlene Coleman, Sophie Jackson, Jodie Kerr, Cerna Nilda, Rosarie Roberts, and recently busted from the Main Event Anya Stevenson are among the early players.
First Break Posted Sunday 16th April, 2023 at 14:49(UTC+0) by Jason Glatzer
Players are on their first 20-minute break of Day 2. The blinds will increase to 1,500/3,000 with a 3,000 big blind ante when the action resumes.
No Multi-Tabling for Stevenson Posted Sunday 16th April, 2023 at 14:48(UTC+0) by Jason Glatzer
Level 14: 1,000/2,500 (2,500) Entries: 33/141
Anya Stevenson (pictured below) was nursing a short stack for the last 30 minutes or so but lost her stack and is now on the rail. This is a good news, bad news situation for Stevenson.
Before the start of the day, Stevenson shared with us that she planned to play both the Main Event and the Ladies Event that is about to start at the same time as she is deep in the Ladies Leaderboard for a Las Vegas package similar to what Dost Ghrabie won earlier today.
While it is unfortunate that there are no more ladies in the Main Event, at least she can play the Ladies Event stress-free.
Best of luck to Stevenson and all the women battling it out in the Ladies Event.
Player
Chips
Progress
Anya Stevenson
0
0
"The Wrath of Khan" Posted Sunday 16th April, 2023 at 14:44(UTC+0) by Jason Glatzer
Level 14: 1,000/2,500 (2,500) Entries: 34/141
It wasn't a great orbit, to say the least for Fazeel Khan. He came into the final day with one of the bigger stacks in play but that quickly blew up as follows:
First, he doubled up Chris Da Silva as follows.
According to Da Silva, stacks went in the middle on a ten-high board. Da Silva had ten-seven and had some kicker issues with Khan holding ace-ten. A miracle seven spiked the river for Da Silva to double his stack.
Shortly after, Khan jammed for about 50,000 over a raise by George Demetriou with the on the board after the turn. Demetriou called and the cards were turned over.
Fazeel Khan: George Demetriou:
Khan was unable to connect with his queen or with a spade with the river completing the action and was on the rail.
The next hand, the table laughed as Demetriou got a walk from the big blind and turned over his pocket sevens for the second hand in a row.
Player
Chips
Progress
Chris Da Silva
315,000
150,000
George Demetriou
250,000
100,000
Fazeel Khan
0
0
"I am Still Running Good" Posted Sunday 16th April, 2023 at 14:34(UTC+0) by Jason Glatzer
Level 14: 1,000/2,500 (2,500) Entries: 35/141
Colin O'Rielly (pictured below) opened for 5,000 from early position before Ken Chow three-bet to 12,000 from one seat over. O'Rielly called after the action folded around to him.
O'Rielly check-called bets by Chow of 5,000 on the flop and for 11,000 on the turn. Both players checked the river. O'Rielly turned over for the top pair and shipped the pot after Chow folded.
"I am still running good," O'Rielly said after the hand.
Player
Chips
Progress
Colin O'Reilly
82,000
18,000
Ken Chow
65,000
18,000
Petro Doubles With Snowmen Posted Sunday 16th April, 2023 at 14:32(UTC+0) by Jason Glatzer
Level 14: 1,000/2,500 (2,500) Entries: 35/141
Vegas package winner Dost Ghrabie opened for 6,500 from the hijack. George Demetriou three-bet to 16,000 from the cutoff before Danjel Petro four-bet jammed for 32,000 from the small blind.
The action paused on Ghrabie until he asked if it was his turn. Once that was determined, he quickly folded. Meanwhile, Demetriou didn't seem to want to call but was priced in.
"I only have queen-three," said Demetriou. "I was trying to steal your chips," he added to Ghrabie.
Demetriou called and indeed he did have queen-three.
Danjel Petro: George Demetriou:
Petro doubled with his snowmen after the safe ran out on the board.
Player
Chips
Progress
George Demetriou
150,000
45,000
Danjel Petro
80,000
25,000
Ladies Hold for Da Silva Posted Sunday 16th April, 2023 at 14:16(UTC+0) by Jason Glatzer
Level 14: 1,000/2,500 (2,500) Entries: 35/141
Chris Da Silva five-bet jammed for 74,000 and was called by George Demetriou.
Chris Da Silva: George Demetriou:
Demetriou didn't get a miracle on a dry board and Da Silva, who was down below a starting stack moments ago, now is among the bigger stacks in the room.
Meanwhile, Marius Varanavicius recently hit the rail to leave just 35 players remaining in the Main Event.
Player
Chips
Progress
George Demetriou
195,000
101,000
Chris Da Silva
165,000
102,000
Marius Varanavicius
0
0
14:03 (UTC+0)
Start of Level 14 Blinds: 1,000/2,500 Ante: 2,500
Dost Ghrabie Will Join Team Hippo With a Las Vegas Package Posted Sunday 16th April, 2023 at 14:03(UTC+0) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 36/141
Emre Anil didn't show up for Day 2 and his short stack was blinded off to leave just 36 hopefuls in the field. The clock was stopped and the roulette wheel was spun. It came up Number 26 and Dost Ghrabie (pictured below) stood up and began to celebrate his amazing fortune of joining Team Hippo in Vegas this summer compliments of an amazing Las Vegas package that includes multiple tournaments, a helicopter experience, and much more.
The entire poker room gave Ghrabie a round of applause and the clock was started again with just a couple of minutes remaining in Level 13.
Player
Chips
Progress
Emre Anil
0
0
Jacks Good for Da Silva Posted Sunday 16th April, 2023 at 13:54(UTC+0) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 37/141
Danjel Petro opened for 4,500 from early position. Chris Da Silva (pictured below) three-bet for most of the 29,000 in chips he had in his stack. Petro four-bet jammed but thought that Da Silva was already all-in and turned over his cards. Da Silva called the floor to get a ruling before he called.
Chris Da Silva: Danjel Petro:
"I haven't won a flip all day," said Da Silva before the board was dealt.
Da Silva managed to win the flip this time to double his stack with Petro bricking the runout.
After the hand, the floor gave Petro a warning about exposing his cards.
Player
Chips
Progress
Chris Da Silva
63,000
2,000
Danjel Petro
55,000
30,000
Buhlmann Loses a Flip and His Stack Posted Sunday 16th April, 2023 at 13:44(UTC+0) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 37/141
Jack Buhlmann jammed the button for 27,500. Danjel Petro called before Alan Stearn came in over the top for a jam of his own for more than 100,000. Petro would have had to call off his stack and folded after deliberating for more than a minute.
Jack Buhlmann: Alan Stearn:
Buhlmann was ahead after the flop and the turn. However, Stearn improved to a better two pair after the river completed the board and Buhlmann was on the rail short of the 'Spin to Win' promotion takes place.
Player
Chips
Progress
Alan Stearn
210,000
97,000
Danjel Petro
85,000
25,500
Jack Buhlmann
0
0
"I Run So Good!" Posted Sunday 16th April, 2023 at 13:37(UTC+0) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 38/141
Colin O'Rielly jammed for 29,500 from under the gun. The action paused on Andrew McKinney in middle decision before he decided to flat-call. The rest of the table folded and the cards were turned over.
"Oh, first time I've been called," said O'Rielly.
Colin O'Rielly: Andrew McKinney:
"Good luck," O'Rielly added after the cards were turned over.
O'Rielly was ahead after the flop but was down to just two outs after McKinney paired his king on the turn.
"Oh no," O'Rielly said.
However, the spiked the river to improve O'Rielly to a full house to double his stack instead of hitting the rail.
"I run so good!" shouted O'Rielly.
Players not only at his table laughed but at other tables as well.
"Usually you don't hear that," one player was heard saying at another table. "Normally people only complain about how bad they run."
Meanwhile, French poker legend Sylvain Loosli has hit the rail to bring the event down to just 38 hopefuls for the title.
Player
Chips
Progress
Andrew McKinney
101,000
6,500
Colin O'Reilly
64,000
31,000
Sylvain Loosli
0
0
Defending Champion Rosenberg Has "Got it" Posted Sunday 16th April, 2023 at 13:20(UTC+0) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 39/141
Defending Mega Series Main Event Champion Yuval Rosenberg (pictured below) bet 22,500 into a pot of more than double that with the on the board after the river. PokerStars at the Hippodrome Ambassador Chris Da Silva thought things over for close to a minute before he called.
"Got it," said Rosenberg as he turned over the for the nut flush.
Meanwhile, Adebayo Adeoshun and Ben Teague hit the rail around the same time at a different table to bring the field down to 39 players.
Player
Chips
Progress
Yuval Rosenberg
165,000
44,500
Chris Da Silva
65,000
38,000
Ben Teague
0
0
Adebayo Adeoshun
0
0
Palomino First on the Rail Posted Sunday 16th April, 2023 at 13:16(UTC+0) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 41/141
Jen-Yue Chiang opened for 5,000 from under the gun and was called by Joe Bold from the button. Jorge Palomino jammed for 59,500 from the big blind. Chiang paused before he folded while Bold found a call.
Jorge Palomino: Joe Bold:
Bold won the flip to eliminate Palomino after his opponent was unable to connect with the runout.
Player
Chips
Progress
Joe Bold
150,000
73,000
Jorge Palomino
0
0
Day 2 Begins After Reminder About Added Vegas Package Posted Sunday 16th April, 2023 at 13:06(UTC+0) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 42/141
Players have chosen a random number for the 'Spin to Win' promotion hosted by the Hippodrome. As a reminder, when there are just 36 players left, a wheel will be spun to determine who will join Team Hippo for a seven-night Las Vegas experience to remember. The package includes many tournaments, a helicopter experience, and much more. In other words, this is amazing value for all the players in the Main Event.
Cards were in the air shortly after some announcements by Kerryjane Craigie (pictured below).
Who Will Win the Mega Series Main Event on Sunday? Posted Sunday 16th April, 2023 at 11:17(UTC+0) by Jason Glatzer
Welcome back to the MainEventTravel.com coverage of the Mega Series £1,100 Main Event at the PokerStars at the Hippodrome.
After three starting flights, the action is down to just 42 hopefuls from the original field of 141 entries in the hunt to become the latest Mega Series Main Event champion that will be crowned by the end of today's action.
Today will feature a deeper structure of 50-minute blind levels and will have plenty of play with the players starting off the action with an average stack greater than 50 big blinds. Half of the field will reach the money with the top 20 players guaranteed at least a min-cash of £1,780. However, all players have their eyes on the lofty £32,825 top prize and the coveted Mega Series trophy on tap for the last player standing.
There will be quite the buzz before the bubble as the final 36 players. The Hippodrome added massive value to the Main Event prize pool thanks to a luxurious Hippodrome Las Vegas prize package to the final 36 players getting a chance 'Spin to Win' where one random player will win an experience to remember. Each of the final 36 players will receive a random number on a wheel. If their number is hit, the lucky player will ship the prize regardless of whether they finish in the money or not. The winner will join Team Hippo for an amazing eight-day experience including return flights to “Sin City”, accommodation at a strip hotel, tournament buy-ins, dinners, activities, an exciting helicopter ride, and an invite to the Hippodrome Vegas welcome party.
Day 1a chip leader George Demetriou will kick off the day ahead of the pack with 296,000 in chips. Also starting the day with more than 200,000 include Day 1b chip leader Sunil Mistri (255,000), Gary Bluston (215,000), and Sebastian Jung (207,500).
Other notable players still in contention include Kully Sidhu (178,000), PokerStars at the Hippodrome Ambassador Chris Da Silva (103,000), Andy Wilson (79,500) French poker legend Sylvain Loosli (65,000), and Harry Lodge (21,500).
Meanwhile, the £175 Ladies Event will also create a tremendous atmosphere when that kicks off at 3 p.m. We will update you later in the coverage about the tasty promotions and other information about this amazing event. In addition, today will boast the £225 Turbo Event at 6 p.m.
Main Event Payouts
Place
Prize
1
£32,825
2
£22,347
3
£14,771
4
£12,173
5
£9,779
6
£7,659
7
£5,744
8
£4,240
9
£3,282
10-11
£2,735
12-13
£2,395
14-15
£2,190
16-17
£1,985
18-20
£1,780
Stay tuned at MainEventTravel.com as we will bring you all the action from when cards are in the air at 1 p.m. until a winner is crowned.
Day 2 Seat Draw Posted Sunday 16th April, 2023 at 10:55(UTC+0) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Jorge Palomino
54,500
27
1
2
Jen-Yue Chiang
122,000
61
1
3
Tommy Eriksson
67,000
34
1
4
Ben Teague
72,000
36
1
5
Harry Lodge
21,500
11
1
6
Joe Bold
77,000
39
1
7
Luke Porter
65,500
33
2
1
Thomas Channell
126,500
63
2
2
Colin O'Rielly
33,000
17
2
3
Ken Chow
47,000
24
2
4
Andrew McKinney
107,500
54
2
5
Jonathan Schuman
65,000
33
2
6
Charles Whitehouse
116,000
58
2
7
Sylvain Loosli
65,000
33
3
1
Adebayo Adeoshun
42,000
21
3
2
Kully Sidhu
178,000
89
3
3
Eliran Argelazi
177,000
89
3
4
Iosif-Daniel Spulber
83,500
42
3
5
Min Ji
16,500
8
3
6
Marius Varanavicius
26,000
13
3
7
Kenneth Brossoit
61,000
31
4
1
Dost Ghrabie
72,000
36
4
2
George Demetriou
296,000
148
4
3
Jack Buhlmann
60,500
30
4
4
Danjel Petro
59,500
30
4
5
Alan Stearn
113,000
57
4
6
Emre Anil
18,000
9
4
7
Fazeel Khan
194,000
97
5
1
Gary Bluston
215,000
108
5
2
Christopher Yong
53,000
27
5
3
Darie Ilie
65,500
33
5
4
Anya Stevenson
60,000
30
5
5
Tamer Ovutmen
134,500
67
5
6
Sebastien Jung
207,500
104
5
7
Ryan Otto
170,500
85
6
1
Sunil Mistri
255,000
128
6
2
Gary Miller
139,500
70
6
3
Andy Wilson
79,500
40
6
4
Beihao Wang
39,500
20
6
5
Yuval Rosenberg
120,500
60
6
6
Thomas Winstone
126,000
63
6
7
Chris Da Silva
103,000
52
10:54 (UTC+0)
Day 2 of London MEGA Series Started Level: 13 Blinds: 1,000/2,000 Ante: 2,000
Your search results are valid for .
Go to checkoutMore 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.
board. However, with one of the board cards being a ten, Mistri improved to a better full house to win the tournament for £32,285.
rolled out on the board.
to get his stack up to 295,000.
but needed a miracle after Dost Ghrabie called with 
turn and 
flop.
turn. 
flop. Mistri called and both players checked the 
board to pull ahead. The PokerStars at the Hippodrome Ambassador won't go home empty-handed as he will collect the sixth place prize of £7,659.
for trips.
ran out on the board.
runout. Lodge's straight was better and Chow hit the rail in 14th place.
runout.
£ GBP
$ USD
€ EUR
