0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0074 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2025-04-24'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/1/11/updates'
ORDER BY `views` DESC
0.0116 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-04-24'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/1/11/updates'
0.0005 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '1'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '1'
0.0285 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` = '1'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '4'
AND `published` = 1
0.0280 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '5'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '7'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '9'
AND `published` = 1
0.0285 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '10'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '11'
AND `published` = 1
0.0284 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '12'
AND `published` = 1
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '11'
ORDER BY `busted` ASC, `current_chips` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '11'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '551'
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` = '550'
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` = '549'
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` = '548'
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` = '543'
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` = '546'
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` = '544'
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` = '541'
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` = '542'
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` = '538'
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` = '537'
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` = '540'
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` = '539'
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` = '536'
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` = '535'
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` = '531'
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` = '533'
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` = '528'
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` = '530'
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` = '524'
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` = '527'
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` = '526'
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` = '525'
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` = '522'
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` = '523'
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` = '519'
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` = '521'
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` = '518'
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` = '520'
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` = '517'
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` = '516'
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` = '515'
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` = '514'
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` = '513'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '512'
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` = '511'
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` = '498'
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` = '502'
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` = '503'
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` = '497'
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` = '496'
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` = '488'
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` = '487'
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` = '494'
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` = '489'
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` = '484'
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` = '485'
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` = '486'
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` = '481'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '480'
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` = '483'
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` = '482'
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` = '478'
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` = '479'
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` = '475'
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` = '473'
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` = '472'
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` = '476'
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` = '477'
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` = '474'
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` = '469'
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` = '470'
ORDER BY `chip_change` DESC, `busted` ASC
0.0114 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '468'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '467'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '466'
ORDER BY `chip_change` DESC, `busted` ASC
0.0116 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '465'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '463'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '464'
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` = '462'
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` = '460'
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` = '459'
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` = '458'
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` = '457'
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` = '456'
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` = '455'
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` = '454'
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` = '453'
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` = '452'
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` = '451'
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` = '450'
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` = '449'
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` = '448'
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` = '447'
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` = '446'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '445'
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` = '444'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '11'
ORDER BY `busted` ASC, `current_chips` DESC
0.0095 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` = '11'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0114 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '545'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '550'
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` = '549'
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` = '548'
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` = '543'
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` = '547'
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` = '546'
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` = '544'
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` = '541'
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` = '542'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '538'
ORDER BY `chip_change` DESC, `busted` ASC
0.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '537'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '540'
ORDER BY `chip_change` DESC, `busted` ASC
0.0132 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '539'
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` = '536'
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` = '535'
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` = '531'
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` = '533'
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` = '528'
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` = '530'
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` = '524'
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` = '527'
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` = '526'
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` = '525'
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` = '522'
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` = '523'
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` = '519'
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` = '521'
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` = '518'
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` = '520'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '517'
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` = '516'
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` = '515'
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` = '514'
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` = '513'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '511'
ORDER BY `chip_change` DESC, `busted` ASC
0.0112 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '498'
ORDER BY `chip_change` DESC, `busted` ASC
0.0112 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '502'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '503'
ORDER BY `chip_change` DESC, `busted` ASC
0.0102 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '497'
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` = '496'
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` = '488'
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` = '487'
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` = '495'
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` = '494'
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` = '489'
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` = '484'
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` = '485'
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` = '486'
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` = '481'
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` = '480'
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` = '483'
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` = '482'
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` = '478'
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` = '479'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '475'
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` = '473'
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` = '472'
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` = '476'
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` = '477'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '474'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '469'
ORDER BY `chip_change` DESC, `busted` ASC
0.0131 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '470'
ORDER BY `chip_change` DESC, `busted` ASC
0.0094 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '471'
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` = '468'
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` = '467'
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` = '466'
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` = '465'
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` = '463'
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` = '464'
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` = '462'
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` = '460'
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` = '459'
ORDER BY `chip_change` DESC, `busted` ASC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '458'
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` = '457'
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` = '456'
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` = '455'
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` = '454'
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` = '453'
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` = '452'
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` = '451'
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` = '450'
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` = '449'
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` = '448'
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` = '447'
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` = '446'
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` = '445'
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` = '444'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '12'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1231
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Battle of Malta 2019
Main Event
Live Reporting - Day 4
Current Level
37 Current Day
4 Blinds
400,000/800,000 Ante
800,000
Entries
4,657 Remaining
1 Prize Pool (EUR)
€2,258,645 First Prize (EUR)
€306,205
Van Zadelhoff Second in Chips with 11 Left in Battle of Malta Main Event Posted Tuesday 22nd October, 2019 at 01:52(UTC+2) by Chris Martin
After ten levels on a marathon Day 3 just 12 players remain in the Battle of Malta Main Event ahead of the final day tomorrow (Tuesday).
The remaining players are all guaranteed €20,100 from a total prize pool of over €2.2m, but will all be chasing the €306,205 that awaits the winner.
Place
Payout (EUR)
1
€ 306,205
2
€ 158,130
3
€ 102,050
4
€ 74,540
5
€ 56,470
6
€ 42,910
7
€ 33,880
8
€ 27,100
9
€ 24,620
10-11
€ 22,360
12
€ 20,100
Leading the remaining players is a familiar name in Josef Gulas who bounced back from seeing his chip lead taken by several players to bag 25,500,000 at the end of the night. Behind him comes Steven van Zadelhoff, who eliminated Byungwook Ahn in one of the last hands of the night to move over 22 million in chips.
With 88 players at the beginning of Day 3, a long day was in store from the start and it wasn't long until players started to slip out of the tournament area and towards payouts.
Josef Gulas was in the lead, but he was usurped by Cedric Schwaederle early on. Notable Ludovic Geilich had a spell on the feature table but was eliminated after flopping a straight only for his opponent to river a flush.
Dehlia De Jong ran queens into aces to see her Main Event run come to an end, as Van Zadelhoff moved into the lead.
That was until a stunning run from Serghei Lisiii saw him run up a stack and become the first player over the ten million chip mark.
Lisii continued to dominate as the winners of MPN's €1,5000 Last Longer were decided. MPN's Platinum Partners were handed a lanyard and the final three still in possession of both their identifying neckwear and chips in the Main Event are now heading to Madrid!
Congratulations to Johan Goslings, Babis Lappas and Colum Higgins - who made it through to Day 4 - who have already locked up their next trip on the MPNPT.
With the blinds increasing all the time, the swings were massive and despite the last-minute elimination of Ahn by Van Zadelhoff, Gulas had done enough to retain his chip lead into the final day.
By the end of the night, the average had reached 10.5m in chips with blinds set to be 200,000/400,000 when play resumes on the final day's play.
Stay tuned to our live updates as we bring you all the action as we crown a winner here in the largest Battle of Malta Main Event of all time.
End-of-Day Chip Counts Posted Tuesday 22nd October, 2019 at 01:48(UTC+2) by Gia Carnestorm
Player
Chips
Progress
Josef Gulas
25,500,000
3,500,000
Steven Van Zadelhoff
21,600,000
400,000
Serghei Lisiii
16,750,000
16,750,000
Leo Dominic Worthington-Leese
9,750,000
750,000
Massimo Bruno
8,925,000
8,225,000
Shaun De Cesare
8,250,000
3,350,000
Valerii Firstenko
8,050,000
6,050,000
Flavio Laudani
5,825,000
1,175,000
Vincenzo Pinna
5,225,000
2,775,000
Rune Moerk
4,200,000
2,700,000
Colum Higgins
2,650,000
1,050,000
Van Zadelhoff into the Chip Lead After Ahn Elimination Posted Tuesday 22nd October, 2019 at 01:34(UTC+2) by Chris Martin
Byungwook Ahn open-shoved from the cutoff for around four million chips. Van Zadelhoff reached forwards to grab the all in triangle and place it in front of him, moving all in over the top from the button.
The blinds folded and the cards were turned over.
Byungwook Ahn: Steven van Zadelhoff:
There was no help for Ahn on the board and he was eliminated.
Player
Chips
Progress
Steven Van Zadelhoff
22,000,000
0
Byungwook Ahn
0
0
Kings Hold for Van Zadelhoff Posted Tuesday 22nd October, 2019 at 01:28(UTC+2) by Gia Carnestorm
Steven Van Zadelhoff raised from the cutoff, and Valerii Firstenko shoved for 10m from the button. The action folded back to Van Zadelhoff, and he snap-called.
Van Zadelhoff:
Firstenko:
Board:
Van Zadelhoff held to win the massive pot, and Firstenko was reduced to 2m.
Player
Chips
Progress
Steven Van Zadelhoff
17,000,000
8,400,000
Valerii Firstenko
2,000,000
11,000,000
Day 3 Recap Posted Tuesday 22nd October, 2019 at 01:25(UTC+2) by Chris Martin
Alba Eliminated by Worthington-Leese Posted Tuesday 22nd October, 2019 at 01:15(UTC+2) by Gia Carnestorm
Antonio Alba moved all in for 2.6m from middle position, and Leo Worthington-Leese called from the small blind.
Alba:
Worthington-Leese:
Board:
The board fell in Worthington-Leese's favor, and Alba was eliminated in 13th place.
Player
Chips
Progress
Leo Dominic Worthington-Leese
9,000,000
0
Antonio Alba
0
0
Gulas Sends Brenseth Straight to the Rail Posted Tuesday 22nd October, 2019 at 01:13(UTC+2) by Chris Martin
After doubling up Leo Worthington-Leese, Terje Brenseth moved all in for 400,000 from middle position. Flavio Laudani called on the button as did Josef Gulas in the big blind.
The pair checked down a board and Brenseth showed . However, Gulas had rivered a straight with and Brenseth was eliminated.
Player
Chips
Progress
Josef Gulas
20,000,000
0
Terje Humio Brenseth
0
0
Cipriano Bows Out at the Hands of Chip Leader Lisiii Posted Tuesday 22nd October, 2019 at 01:12(UTC+2) by Chris Martin
Christian Cipriano got his last chips in with against the of chip leader Serghei Lisiii.
Lisiii flopped a set ont he flop, with Cipriano picking up a flush draw. The turn was the and the river the sending Cipriano to the rail.
Player
Chips
Progress
Serghei Lisiii
21,500,000
6,500,000
Christian Cipriano
0
0
Worthington-Leese Doubles; Larsson Out Posted Tuesday 22nd October, 2019 at 01:11(UTC+2) by Chris Martin
Terje Brenseth shoved from the small blind and Leo Worthington-Leese called in the big blind. Brenseth just covered his opponent and was ahead with against the of the Brit.
The board ran out and Worthington-Leese doubled, leaving Brenseth short.
Meanwhile, on the other table, Vincenzo Pinna shoved from the small blind and Greger Larsson called all in from the big blind.
Vincenzo Pinna: Greger Larsson:
Pinna flopped a pair on the flop and held on the runout to eliminate Larsson.
Player
Chips
Progress
Vincenzo Pinna
8,000,000
1,100,000
Leo Dominic Worthington-Leese
5,500,000
120,000
Terje Humio Brenseth
500,000
2,900,000
Greger Larsson
0
0
Redraw; Down to 16 Players Posted Tuesday 22nd October, 2019 at 01:05(UTC+2) by Chris Martin
Serghei Lisiii opened from the hijack and called a shove from Gabriele Re in the cutoff for 1,100,000.
Serghei Lisiii: Gabriele Re:
The board came with no help for Re who was eliminated. The final 16 players are all guaranteed €15,580 and are now redrawing around two tables.
Player
Chips
Progress
Serghei Lisiii
21,000,000
6,000,000
Re Gabriele
0
0
Worthington-Leese and Firstenko Tussle Once More Posted Tuesday 22nd October, 2019 at 00:53(UTC+2) by Chris Martin
Shaun De Cesare limped in the cutoff. Valerii Firstenko raised to 800,000 on the button, with Leo Worthington-Leese calling and De Cesare folding.
On a flop, Worthington-Leese check-called 750,000 before both players checked the turn.
Worthington-Leese bet 1,500,000 on the river and Firstenko called. Worthington-Leese showed for a missed straight draw, and Firstenko won the pot with for two pair.
Player
Chips
Progress
Valerii Firstenko
13,000,000
600,000
Leo Dominic Worthington-Leese
2,500,000
3,120,000
00:41 (UTC+2)
Start of Level 33 Blinds: 150000/300000 Ante: 300000
Chip Counts from Feature Posted Tuesday 22nd October, 2019 at 00:36(UTC+2) by Chris Martin
Player
Chips
Progress
Josef Gulas
18,000,000
5,900,000
Steven Van Zadelhoff
8,600,000
3,400,000
Byungwook Ahn
5,700,000
1,100,000
Greger Larsson
3,800,000
2,800,000
Christian Cipriano
3,000,000
900,000
Massimo Doubles Through Re Posted Tuesday 22nd October, 2019 at 00:13(UTC+2) by Chris Martin
Bruno Massimo held and would need to win a crucial flip against Gabriele Re who held
Massimo was all in for around 1,500,000 and did in fact hold on the run out, chipping up to around 3,000,000 leaving Re with around five big blinds.
Player
Chips
Progress
Massimo Bruno
3,200,000
2,500,000
Re Gabriele
1,300,000
4,300,000
Faraj Eliminated by Van Zadelhoff Posted Tuesday 22nd October, 2019 at 00:11(UTC+2) by Chris Martin
Steven van Zadelhoff opened to 575,000 and called a shove from Abraham Faraj for 2,200,000.
Steven van Zadelhoff: Abraham Faraj:
The board ran out with Van Zadelhoff flopping a straight draw but rivering a pair of tens which was enough for him to send Faraj to the rail. Just 17 players remain in the Battle of Malta Main Event.
Player
Chips
Progress
Steven Van Zadelhoff
12,000,000
2,500,000
Abraham Benitez Faraj
0
0
Chip Counts at the Break Posted Tuesday 22nd October, 2019 at 00:10(UTC+2) by Chris Martin
Player
Chips
Progress
Serghei Lisiii
15,000,000
3,025,000
Shaun De Cesare
12,400,000
2,400,000
Valerii Firstenko
12,400,000
2,200,000
Josef Gulas
12,100,000
6,700,000
Steven Van Zadelhoff
9,500,000
400,000
Vincenzo Pinna
8,600,000
1,700,000
Flavio Laudani
7,000,000
3,875,000
Greger Larsson
6,600,000
4,400,000
Leo Dominic Worthington-Leese
5,700,000
80,000
Re Gabriele
5,600,000
2,100,000
Byungwook Ahn
4,600,000
650,000
Colum Higgins
4,200,000
500,000
Christian Cipriano
3,900,000
1,040,000
Terje Humio Brenseth
3,400,000
950,000
Massimo Bruno
2,700,000
2,000,000
Antonio Alba
2,600,000
100,000
Rune Moerk
2,600,000
3,100,000
Abraham Benitez Faraj
2,200,000
500,000
00:07 (UTC+2)
Start of Level 32 Blinds: 100000/250000 Ante: 250000
Updated Chip Counts Posted Monday 21st October, 2019 at 23:59(UTC+2) by Gia Carnestorm
Player
Chips
Progress
Serghei Lisiii
15,000,000
0
Valerii Firstenko
12,400,000
0
Shaun De Cesare
9,200,000
800,000
Vincenzo Pinna
8,600,000
1,700,000
Flavio Laudani
7,000,000
0
Leo Dominic Worthington-Leese
5,700,000
80,000
Re Gabriele
5,600,000
0
Colum Higgins
4,200,000
500,000
Terje Humio Brenseth
3,400,000
0
Massimo Bruno
2,700,000
2,000,000
Antonio Alba
2,600,000
100,000
Rune Moerk
2,600,000
3,100,000
Messina Eliminated Before the Break Posted Monday 21st October, 2019 at 23:34(UTC+2) by Chris Martin
Steven van Zadelhoff raised from under the gun. Renato Messina three-bet all in from the big blind for 2,100,000 and Van Zadelhoff called.
Steven van Zadelhoff: Renato Messina:
The board came with Van Zadelhoff avoiding counterfeit outs to send his opponent to the rail.
Player
Chips
Progress
Steven Van Zadelhoff
9,100,000
1,200,000
Messina Renato
0
0
Alba Doubles Through Re Posted Monday 21st October, 2019 at 23:19(UTC+2) by Chris Martin
Gabriele Re opened to 425,000 and called a shove from Antonio Alba for 1,280,000.
Gabriele Re: Antonio Alba:
Alba's big slick held on the and Re handed over chips to his opponent.
Player
Chips
Progress
Serghei Lisiii
11,975,000
1,025,000
Massimo Bruno
4,700,000
2,300,000
Byungwook Ahn
3,950,000
750,000
Re Gabriele
3,500,000
800,000
Flavio Laudani
3,125,000
2,675,000
Antonio Alba
2,700,000
200,000
Vincenzo Pinna
1,030,000
3,870,000
Break Posted Monday 21st October, 2019 at 23:18(UTC+2) by Chris Martin
Players are going on a 20-minute break, with the final 18 players returning with the blinds increasing to 100,000/250,000.
Szwed Eliminated; Down to 19 Players Posted Monday 21st October, 2019 at 23:17(UTC+2) by Chris Martin
Oskar Szwed was all in for around 2,500,000 with against the of Greger Larsson.
The board however, gave Larsson a flush and sent Szwed to the rail.
Player
Chips
Progress
Greger Larsson
11,000,000
0
Messina Renato
0
0
Oskar Szwed
0
0
Szwed Eliminated by Van Zadelhoff Posted Monday 21st October, 2019 at 23:00(UTC+2) by Gia Carnestorm
The action folded around to Oskar Szwed in the small blind, and he shoved for 1.9m, which Steven Van Zadelhoff called in the big blind.
Szwed:
Van Zadelhoff:
Board:
Szwed was behind before the community cards fell and received no help when they appeared after Van Zadelhoff improved to two pair.
Player
Chips
Progress
Steven Van Zadelhoff
7,900,000
2,300,000
Oskar Szwed
0
0
Laudani Hits Trips to Double Posted Monday 21st October, 2019 at 22:42(UTC+2) by Gia Carnestorm
Serghei Lisiii raised from middle position then called a 2.8m shove from Flavio Laudani on the button.
Lisiii:
Laudani:
Board:
Laudani was far behind but was propelled into the lead when he hit trips on the flop. The Italian's unlikely double up was confirmed on the turn, and Laudani moved up to 5.8m.
Player
Chips
Progress
Serghei Lisiii
13,000,000
4,600,000
Flavio Laudani
5,800,000
4,550,000
22:16 (UTC+2)
Start of Level 31 Blinds: 100000/200000 Ante: 200000
Gosling Next to Go Posted Monday 21st October, 2019 at 22:08(UTC+2) by Chris Martin
Johan Goslings was all in for around 2,700,000 with against Valerii Firstenko's
There was no help for Goslings on the board and Firstenko moved up to around ten million in chips.
Player
Chips
Progress
Valerii Firstenko
10,000,000
5,500,000
Johan Goslings
0
0
Firstenko Cracks Aces to Doubles Posted Monday 21st October, 2019 at 22:06(UTC+2) by Chris Martin
Joining the action on a turn, Valerii Firstenko bet 1,150,000 and Leo Worthington-Leese called.
The river was the and Firstenko thought before shoving for 3,285,000.
Worthington-Leese double-checked his cards before calling. Firstenko showed for a full house and Worthington-Leese flung face-up on the table as his opponent doubled up.
Player
Chips
Progress
Valerii Firstenko
10,200,000
0
Leo Dominic Worthington-Leese
4,275,000
3,725,000
De Cesare vs. Goslings Posted Monday 21st October, 2019 at 22:06(UTC+2) by Gia Carnestorm
Johan Goslings opened the action with a raise from under the gun and Shaun De Cesare three-bet from the hijack, which Goslings called.
With close to 2m in the middle, the flop fell , and Goslings check-called a 690,000 bet.
The hit on the turn, and Goslings checked.
De Cesare moved all in for 5m, and Goslings folded, with 2.7m behind, after over 90 seconds in the tank.
Player
Chips
Progress
Shaun De Cesare
8,600,000
1,400,000
Valerii Firstenko
7,100,000
2,600,000
Terje Humio Brenseth
4,000,000
1,550,000
Colum Higgins
3,800,000
900,000
Leo Dominic Worthington-Leese
3,500,000
1,110,000
Johan Goslings
2,700,000
1,300,000
Fabio Frusca
1,650,000
1,295,000
Frusca Eliminated by Worthington-Leese Posted Monday 21st October, 2019 at 21:59(UTC+2) by Gia Carnestorm
Fabio Frusca bet 500,000 from the small blind on a flop, against Leo Worthington-Leese called from the big blind.
Frusca checked on the turn, and Worthington-Leese moved all in for 6m.
Frusca had 2.1m behind and went deep into thought for nearly two minutes before he called.
Worthington-Leese tabled for bottom pair, and Frusca was ahead with top pair holding .
However, the river card fell the , and Worthington-Leese hit two pair.
"No!" exclaimed Frusca as he jumped up from the table after being eliminated on the river.
Worthington-Leese moved up to 9m, and a disappointed Frusca made his way to the payout desk in 20th place.
Player
Chips
Progress
Leo Dominic Worthington-Leese
9,000,000
1,000,000
Fabio Frusca
0
0
Moerk Doubles Through Lisiii Posted Monday 21st October, 2019 at 21:35(UTC+2) by Chris Martin
According to tournament officials, Rune Moerk and chip leader Serghei Lisii got it in on a with Moerk holding for a set against the open-ended straight draw of Lisii.
The turn improved Moerk to a full house and left Lisiii drawing dead. The river was the and Moerk doubled up.
Player
Chips
Progress
Serghei Lisiii
14,000,000
3,600,000
Vincenzo Pinna
10,200,000
5,300,000
Re Gabriele
5,800,000
3,100,000
Byungwook Ahn
4,950,000
1,750,000
Rune Moerk
4,700,000
1,000,000
Flavio Laudani
4,350,000
3,100,000
Massimo Bruno
3,700,000
1,300,000
Antonio Alba
2,100,000
400,000
Chip Counts from Feature Posted Monday 21st October, 2019 at 21:31(UTC+2) by Chris Martin
Player
Chips
Progress
Josef Gulas
10,100,000
4,700,000
Messina Renato
6,100,000
500,000
Greger Larsson
5,925,000
3,715,000
Oskar Szwed
3,650,000
2,800,000
Christian Cipriano
3,200,000
1,740,000
Steven Van Zadelhoff
2,950,000
2,650,000
Abraham Benitez Faraj
2,100,000
400,000
Gal Halevi
675,000
725,000
MPN Last Longer Posted Monday 21st October, 2019 at 21:30(UTC+2) by Gia Carnestorm
Players who qualified with MPN's Platinum Partners were handed a swanky lanyard bearing the legend "€1,500 LAST LONGER" when they picked up their player bags, and those still in possession of both their identifying neckwear and chips in the main event are now heading to Madrid!
Why hand out just one prize when the field is so gargantuan? While the title of Longest Lasting is strictly still up for grabs (Colum Higgins and Johan Goslings are still in the running on the last four tables), they, together with Babis Lappas (pictured; 35th for €7,230) have already locked up their next trip on the MPNPT.
Congratulations!
21:27 (UTC+2)
Start of Level 30 Blinds: 80000/160000 Ante: 160000
Dinner Break Posted Monday 21st October, 2019 at 20:07(UTC+2) by Chris Martin
The final 23 players are going on a 75-minute dinner break.
When they return the blinds will be 80,000/160,000. The current average is just over five million chips.
Prozan Departs Posted Monday 21st October, 2019 at 20:07(UTC+2) by Gia Carnestorm
Melech Prozan moved all in from middle position, and Johan Goslings called in the big blind.
Prozan:
Goslings:
Board:
Prozan had run into a dominating hand and found no way back on the board.
Grella Gone Posted Monday 21st October, 2019 at 19:36(UTC+2) by Gia Carnestorm
The board was down , and all the chips went into the middle between Renato Messina, in the cutoff, and Enrico Grella in the big blind.
Messina held for trips, but Grella had found a flush with .
With both players playing very similar stacks, it was all on the line with one card to come, and when the appeared, Messina improved to a full house to steal the pot.
Grella was left with just 200,000 and departed in the very next hand when he ran ace-nine into ace-jack.
Player
Chips
Progress
Messina Renato
6,600,000
2,900,000
Enrico Grella
0
0
Larsson Doubles With Aces vs. Kings Posted Monday 21st October, 2019 at 19:35(UTC+2) by Gia Carnestorm
Johan Goslings raised from the cutoff, and Greger Larsson moved all in for 2.6m from the big blind, which Goslings snap-called.
Goslings:
Larsson:
Board:
The perfect scenario for Larsson got even better on the flop when he hit top set.
Larsson held on the river and doubled to 5.5m.
Player
Chips
Progress
Lars Greger Larsson
5,500,000
2,840,000
Johan Goslings
3,100,000
1,600,000
Lisiii Continues to Dominate Posted Monday 21st October, 2019 at 19:19(UTC+2) by Chris Martin
A short while ago, Serghei Lisiii added yet more chips to his stack after eliminating Marc Schembri. Lisiii held against the of Schembri. The money went in pre-flop with Lisiii spiking another nine on the turn to improve toa set.
Serghei Lisiii then defended his big blind after a Johan Goslings open to 300,000.
The flop came and Lisiii check-called 250,000. The pair checked the turn and Goslings folded to a bet of 600,000 from Lisii who chipped up to over 17,500,000.
Player
Chips
Progress
Serghei Lisiii
17,600,000
3,600,000
Greger Larsson
6,800,000
4,140,000
Steven Van Zadelhoff
5,600,000
400,000
Byungwook Ahn
3,200,000
2,350,000
Colum Higgins
2,900,000
1,750,000
Johan Goslings
2,900,000
1,800,000
Gal Halevi
1,400,000
1,000,000
Schembri Marc
0
0
Chip Counts from Day 3 Posted Monday 21st October, 2019 at 19:19(UTC+2) by Chris Martin
Player
Chips
Progress
Shaun De Cesare
7,200,000
250,000
Vincenzo Pinna
4,900,000
10,000
Valerii Firstenko
4,500,000
700,000
Messina Renato
3,700,000
1,200,000
Enrico Grella
3,525,000
375,000
Abraham Benitez Faraj
1,700,000
200,000
Cedric Brice Eric Schwaederle
1,125,000
575,000
18:58 (UTC+2)
Start of Level 29 Blinds: 60000/120000 Ante: 120000
Laura Interviews BOM Player Party rock band Red Electrick Posted Monday 21st October, 2019 at 18:51(UTC+2) by Chris Martin
Laura chats to BOM Player Party rock band Red Electrick about life on tour, their new album and poker. Red Electrick have supplied all the music being used in our BOM 2019 videos!
Updated Chip Counts Posted Monday 21st October, 2019 at 18:36(UTC+2) by Gia Carnestorm
Player
Chips
Progress
Serghei Lisiii
14,000,000
11,650,000
Shaun De Cesare
6,950,000
275,000
Oskar Szwed
6,450,000
3,250,000
Steven Van Zadelhoff
6,000,000
575,000
Rune Moerk
5,700,000
300,000
Josef Gulas
5,400,000
850,000
Valerii Firstenko
5,200,000
250,000
Leo Dominic Worthington-Leese
4,960,000
1,660,000
Christian Cipriano
4,940,000
815,000
Terje Humio Brenseth
4,850,000
1,550,000
Johan Goslings
4,700,000
2,275,000
Colum Higgins
4,650,000
1,069,500
Byungwook Ahn
4,650,000
1,050,000
Enrico Grella
3,150,000
1,200,000
Re Gabriele
2,700,000
170,000
Lars Greger Larsson
2,660,000
1,090,000
Messina Renato
2,500,000
250,000
Massimo Bruno
2,400,000
1,450,000
Gal Halevi
2,400,000
1,450,000
Giovanni Russo
2,350,000
50,000
Vincenzo Pinna
2,210,000
290,000
Schembri Marc
2,000,000
1,600,000
Antonio Alba
1,550,000
200,000
Abraham Benitez Faraj
1,500,000
300,000
Massimo Scioscia
1,450,000
150,000
Melech Prozan
1,400,000
400,000
Marcello Bona
1,280,000
30,000
Dwayne Jeremy Sluis
1,250,000
1,150,000
Flavio Laudani
1,250,000
2,050,000
Dimitrios Anastasakis
1,100,000
530,000
Fabio Frusca
355,000
745,000
Ongurur Busts After Mistimed Shove Posted Monday 21st October, 2019 at 18:36(UTC+2) by Chris Martin
Leo Worthington-Leese opened to 210,000 from under the gun. Antonio Alba called before Massimo Scioscia raised all in for 255,000.
Worthington-Leese and Alba both called and checked down a board.
Scioscia showed and that held against the of Worthington-Leese and the of Alba.
Player
Chips
Progress
Leo Dominic Worthington-Leese
2,950,000
350,000
Antonio Alba
2,800,000
1,450,000
Antonio Alba
850,000
500,000
Grella Holds to Double Posted Monday 21st October, 2019 at 18:33(UTC+2) by Gia Carnestorm
Valeri Firstenko raised to 200,000 from under the gun, and Abraham Faraj called on the button before Enrico Grella moved all in for 950,000 from the small blind.
Firstenko asked for a count, then called, and Faraj folded.
Firstenko:
Grella:
Board:
Grella had his tournament life on the line but held in a tense finish to double up to 2m.
Player
Chips
Progress
Valerii Firstenko
3,000,000
2,450,000
Enrico Grella
2,000,000
2,350,000
High Roller Attracts 322 Entries Posted Monday 21st October, 2019 at 18:33(UTC+2) by Chris Martin
There was just one level of late registration at the start of Day 2 of the Battle of Malta High Roller, with just 74 players remaining.
The prizepool and payouts have been confirmed with the top 47 places paid and a min-cash of €2,135. The winner will take home €73,070.
Overnight chip leader Jon Kyte is still in, with the likes of Fraser Macintyre, Ian Simpson, Mateusz Moolhuizen, Fabrice Soulier and Georgios Zisimopoulos all still in contention.
Battle of Malta - Intro to Day 3 Posted Monday 21st October, 2019 at 18:21(UTC+2) by Chris Martin
Ongurur Busts After Mistimed Shove Posted Monday 21st October, 2019 at 18:12(UTC+2) by Chris Martin
Byungwook Ahn opened too 170,000 and Mehmet Ongurur defended his big blind.
The flop was and Ongurur check-called 155,000. The turn was the and Ongurur checked again. Ahn bet 225,000 and Ongurur check-raised to 775,000.
Ahn called and the river was the . Ongurur moved all in for 775,000 and Ahn called.
Ongurur showed for ace-high with Ahn having turned a flush with to send Ongurur to the rail.
Player
Chips
Progress
Byungwook Ahn
4,500,000
900,000
Mehmet Sirin Ongorur
0
0
Pinna Secures Another Double Posted Monday 21st October, 2019 at 18:12(UTC+2) by Gia Carnestorm
Cedric Schwaederle opened from middle position then called a 2.6m shove from Vincenzo Pinna from the button.
Schwaederle:
Pinna:
Board:
Pinna took the lead on the flop with top pair and held as the board completed to seal yet another double up, while former chip leader Schwaederle is reduced to 1.7m.
Player
Chips
Progress
Vincenzo Pinna
5,200,000
2,700,000
Cedric Brice Eric Schwaederle
1,700,000
3,750,000
Pinna Doubles Through De Cesare Posted Monday 21st October, 2019 at 17:47(UTC+2) by Gia Carnestorm
Vincenzo Pinna, on the button, and Shaun De Cesare, in the big blind, got all their chips into the middle pre-flop with Pinna, the player at risk.
Pinna:
De Cesare:
Board:
Pinna held to win the flip and doubled his stack to 2.3m.
Player
Chips
Progress
Shaun De Cesare
6,500,000
500,000
Vincenzo Pinna
2,300,000
100,000
Faraj Big Loser at Table Three Posted Monday 21st October, 2019 at 17:46(UTC+2) by Chris Martin
Player
Chips
Progress
Shaun De Cesare
6,175,000
175,000
Valerii Firstenko
5,450,000
950,000
Enrico Grella
4,350,000
2,650,000
Vincenzo Pinna
2,400,000
200,000
Messina Renato
2,250,000
800,000
Marcello Bona
1,250,000
435,000
Abraham Benitez Faraj
1,200,000
4,150,000
17:45 (UTC+2)
Start of Level 28 Blinds: 50000/100000 Ante: 100000
Break Posted Monday 21st October, 2019 at 17:18(UTC+2) by Chris Martin
Players are going on their second 20-minute break of the day. The tournament clock shows 33 players remaining.
A reminder, the schedule for today is to play down to a final table of nine.
The blinds when they return 50,000/100,000 and the average stack is just over 3,500,000.
More Day 3 Pictures Posted Monday 21st October, 2019 at 17:17(UTC+2) by Chris Martin
De Cesare vs. Faraj Posted Monday 21st October, 2019 at 17:00(UTC+2) by Gia Carnestorm
Shaun De Cesare raised from the hijack and Abraham Faraj three-bet to 360,000 from the cutoff.
De Cesare four-bet to 1,150,000 and Faraj called.
The flop fell and Faraj called a 625,000 bet.
When the appeared on the turn, De Cesare moved all in for 3.6m.
Faraj had 3m behind and went into the tank.
"You have ace-king?" said De Cesare as he stood from his chair.
Faraj remained silent, and De Cesare called the clock after two minutes passed.
"You're not going to call," said De Cesare.
"You have nothing; you would have called already."
Faraj sat thinking while the clock ran down, and when the TD announced five seconds, he let the time pass before his hand was declared dead.
De Cesare won a big pot and moved up to 7.7m.
Player
Chips
Progress
Shaun De Cesare
7,700,000
1,700,000
Abraham Benitez Faraj
3,000,000
2,350,000
Recent Departures Posted Monday 21st October, 2019 at 16:57(UTC+2) by Gia Carnestorm
Player
Chips
Progress
Hassan Aku Robert Sey
0
0
Sebastian Tomasz Lohunko
0
0
Csaba Kovacs
0
0
Vytenis Salickas
0
0
Virgo Tamm
0
0
Alexandra Niculae
0
0
Salvatore Montagna
0
0
Efthymios Mammides
0
0
Rafael Zuzic
0
0
Ichiyo Niwa
0
0
Francesco Gasparr
0
0
Yohann Thierry Gerard Maurice Soldan
0
0
Karl Fredrik Ellingsson
0
0
Mega High Stack Champion Sey Eliminated Posted Monday 21st October, 2019 at 16:52(UTC+2) by Chris Martin
Earlier int he week, Hassan Sey took down the €5,000 Mega High Stack tournament and subsequently made a deep run in the Main Event. However, that run is now over.
He three-bet all in from the small blind for 1,500,000 after Shaun De Cesare opened from the cutoff. De Cesare called with and was up against the of Sey.
The board ran out and Sey was eliminated.
Player
Chips
Progress
Shaun De Cesare
6,000,000
4,250,000
Hassan Aku Robert Sey
0
0
Zadelhoff Moved from Feature Posted Monday 21st October, 2019 at 16:48(UTC+2) by Chris Martin
Steven van Zadelhoff has chipped up considerably while on the feature table, and must now surely be a contender for overall chip leader.
Player
Chips
Progress
Steven Van Zadelhoff
6,575,000
1,625,000
Rune Moerk
6,000,000
1,000,000
Cedric Brice Eric Schwaederle
5,450,000
50,000
Christian Cipriano
4,125,000
25,000
Leo Dominic Worthington-Leese
3,300,000
550,000
Gal Halevi
950,000
450,000
Hagai Ben Yair
550,000
650,000
Ahn Flops the Nut Straight Posted Monday 21st October, 2019 at 16:39(UTC+2) by Chris Martin
Byungwook Ahn defended his big blind after Mehmet Ongorur opened to 150,000.
The flop came and both players checked. The turn was the and Ahn bet 190,000. Ongorur called.
The river was the and Ahn bet 430,000. Ongorur tank-called at the feature table before calling with for two pair but Ahn had flopped a straight with and took down the pot.
Player
Chips
Progress
Byungwook Ahn
3,600,000
1,600,000
Mehmet Sirin Ongorur
1,400,000
500,000
Laudani Shoves on Szwed Posted Monday 21st October, 2019 at 16:39(UTC+2) by Gia Carnestorm
The completed board showed , and with around 1.7m in the middle, Flavio Laudani was all in for 1.5m from the cutoff.
Oskar Szwed was the player with the decision to make playing from middle position and was in the tank with 3.2m behind.
"Nice hand," said Szwed after he decided to fold, and Laudani picked up the pot.
Player
Chips
Progress
Flavio Laudani
3,300,000
1,900,000
Oskar Szwed
3,200,000
1,100,000
16:21 (UTC+2)
Start of Level 27 Blinds: 40000/80000 Ante: 80000
Full Chip Counts Posted Monday 21st October, 2019 at 16:04(UTC+2) by Chris Martin
Here are the chip counts for the remaining players in the Battle of Malta Main Event.
Player
Chips
Progress
Cedric Brice Eric Schwaederle
5,500,000
800,000
Abraham Benitez Faraj
5,350,000
4,170,000
Rune Moerk
5,000,000
1,645,000
Steven Van Zadelhoff
4,950,000
2,650,000
Josef Gulas
4,550,000
250,000
Valerii Firstenko
4,500,000
1,945,000
Oskar Szwed
4,300,000
100,000
Christian Cipriano
4,100,000
1,100,000
Schembri Marc
3,600,000
1,400,000
Terje Humio Brenseth
3,300,000
1,210,000
Messina Renato
3,050,000
1,340,000
Leo Dominic Worthington-Leese
2,750,000
1,200,000
Babbas Lappas
2,550,000
50,000
Re Gabriele
2,530,000
1,305,000
Lars Greger Larsson
2,450,000
750,000
Johan Goslings
2,425,000
585,000
Dwayne Jeremy Sluis
2,400,000
600,000
Serghei Lisiii
2,350,000
350,000
Giovanni Russo
2,300,000
1,335,000
Vincenzo Pinna
2,200,000
1,060,000
Byungwook Ahn
2,000,000
560,000
Niko Pakalen
2,000,000
180,000
Boris Chertin
1,950,000
300,000
Mehmet Sirin Ongorur
1,900,000
200,000
Colum Higgins
1,800,000
25,000
Shaun De Cesare
1,750,000
750,000
Enrico Grella
1,700,000
225,000
Efthymios Mammides
1,700,000
235,000
Dimitrios Anastasakis
1,630,000
1,100,000
Alexandra Niculae
1,600,000
1,100,000
Csaba Kovacs
1,550,000
600,000
Flavio Laudani
1,400,000
430,000
Gal Halevi
1,400,000
285,000
Tiziano Di Romualdo
1,350,000
150,000
Antonio Alba
1,350,000
150,000
Ichiyo Niwa
1,350,000
1,090,000
Massimo Scioscia
1,300,000
435,000
Francesco Gasparr
1,300,000
250,000
Salvatore Montagna
1,300,000
550,000
Rafael Zuzic
1,250,000
200,000
Yohann Thierry Gerard Maurice Soldan
1,250,000
150,000
Hagai Ben Yair
1,200,000
760,000
Vytenis Salickas
1,180,000
700,000
Fabio Frusca
1,100,000
280,000
Melech Prozan
1,000,000
500,000
Hassan Aku Robert Sey
975,000
855,000
Massimo Bruno
950,000
100,000
Dehlia Diana De Jong
900,000
170,000
Mike Georges Alonso
850,000
700,000
Marcello Bona
815,000
300,000
Marek Poldroos
520,000
900,000
Virgo Tamm
500,000
1,100,000
Sebastian Tomasz Lohunko
400,000
220,000
Pasquale Braco
345,000
305,000
Higgins Doubles Through Pakalen Posted Monday 21st October, 2019 at 16:04(UTC+2) by Gia Carnestorm
The completed board was down and in front of Colum Higgins was for a straight.
Niko Pakalen held and his stack was being counted after the two players had got all their chips into the middle at some point.
Pakalen was confirmed to have just 5,000 more than Higgins, so despite losing nearly all his stack, he had a 'chip and a chair'.
In the very next hand, Pakalen picked up ace-jack and split the pot with Dehlia De Jong who held ace-deuce to move up to 40,000.
Player
Chips
Progress
Colum Higgins
3,555,500
1,780,500
Niko Pakalen
40,000
2,140,000
De Jong Runs Queens into Aces Posted Monday 21st October, 2019 at 16:04(UTC+2) by Chris Martin
Dehlia De Jong opened to 120,000 and Lars Larsson three-bet to 425,000. De Jong then four-bet all in for 1,160,000. Larsson snap-called with and De Jong turned over
The board ran out and De Jong was eliminated, with Larsson moving up to around three million in chips.
Player
Chips
Progress
Lars Greger Larsson
3,000,000
1,300,000
Dehlia Diana De Jong
0
0
Alonso Eliminated by Chertin Posted Monday 21st October, 2019 at 15:41(UTC+2) by Gia Carnestorm
Boris Chertin raised to 120,000 from the hijack, and Mike Georges Alonso moved all in for 850,000 from the cutoff.
The decision folded back around to Chertin, and he pondered for 20 seconds before he called.
Chertin:
Alonso:
Board:
Alonso found no way back with Chertin hitting trips.
Alonso exits in 54th place.
Player
Chips
Progress
Boris Chertin
2,800,000
1,150,000
Mike Georges Alonso
0
0
Update to Live Updates Posted Monday 21st October, 2019 at 15:32(UTC+2) by Chris Martin
With just 54 players remaining in the Battle of Malta Main Event, the live updates will now pause for 30 minutes to catch up with the official live stream so as to not spoil anything during the latter stages.
15:28 (UTC+2)
Start of Level 26 Blinds: 30000/60000 Ante: 60000
Break Posted Monday 21st October, 2019 at 15:06(UTC+2) by Gia Carnestorm
The players are on a 20-minute break.
Geilich Eliminated Posted Monday 21st October, 2019 at 15:05(UTC+2) by Chris Martin
Ludovic Geilich was down to around 11 big blinds on the stream and was all in with against the of an opponent.
The flop gave Geilich a pair but his opponent both straight and flush draws. The turn was the but the river completed their flush and sent Geilich to the rail.
Player
Chips
Progress
Mr Ludovic Alexander Geilich
0
0
Guichard Eliminated by Ongorur Posted Monday 21st October, 2019 at 15:04(UTC+2) by Gia Carnestorm
The cards were down , and short-stacked Paul Guichard was all in.
Mehmet Ongorur called after two players folded and flipped over for top pair.
Guichard held and departed after the appeared on the river.
Player
Chips
Progress
Mehmet Sirin Ongorur
1,700,000
145,000
Paul Andre Guichard
0
0
Merfeldas Eliminated by Van Zadelhoff Posted Monday 21st October, 2019 at 14:59(UTC+2) by Gia Carnestorm
Gabriele Re raised from early position, and Steven van Zadelhoff called before Arvydas Merfeldas moved all in for 450,000.
Re folded, and Van Zadelhoff called.
Merfeldas:
Van Zadelhoff:
Board:
Van Zadelhoff found himself with two overs and hit a pair on the flop to take the lead.
The Dutchman held his lead after the board completed, and Merfeldas departed.
Player
Chips
Progress
Steven Van Zadelhoff
6,000,000
3,700,000
Arvydas Merfeldas
0
0
Flashback to 2018 Battle of Malta Final Day Posted Monday 21st October, 2019 at 14:53(UTC+2) by Chris Martin
Last year Julien Stropoli topped a 3,816 player field to win the Battle of Malta. Check out these highlights from the final day of the 2018 Main Event!
Recent Eliminations; Down to 56 Players Posted Monday 21st October, 2019 at 14:46(UTC+2) by Chris Martin
Player
Chips
Progress
Petros Theodosiou
0
0
Mohammed Sohel
0
0
Giuseppe Grimaldi
0
0
Valentin-Marius Cristea
0
0
David Hudson
0
0
Leo Jean Jaques Adrien Lombardozzi
0
0
Updated Chip Counts Posted Monday 21st October, 2019 at 14:40(UTC+2) by Chris Martin
Player
Chips
Progress
Josef Gulas
4,800,000
1,100,000
Cedric Brice Eric Schwaederle
4,700,000
500,000
Serghei Lisiii
2,700,000
300,000
Schembri Marc
2,200,000
940,000
Boris Chertin
1,650,000
375,000
Karl Fredrik Ellingsson
1,600,000
95,000
Mike Georges Alonso
1,550,000
150,000
Antonio Alba
1,500,000
800,000
Enrico Grella
1,475,000
25,000
Tiziano Di Romualdo
1,200,000
20,000
Yohann Thierry Gerard Maurice Soldan
1,100,000
550,000
Francesco Gasparr
1,050,000
520,000
Massimo Bruno
1,050,000
395,000
Shaun De Cesare
1,000,000
350,000
Pasquale Braco
650,000
180,000
Scalia Eliminated by Szwed Posted Monday 21st October, 2019 at 14:31(UTC+2) by Gia Carnestorm
Oskar Szwed raised to 125,000 from under the gun, and Marco Scalia moved all in for 370,000 from the hijack.
The action folded back to Szwed, and he called after receiving confirmation of the all-in amount.
Szwed:
Scalia:
Board:
Scalia lost the vital flip and hit the rail as Szwed moved up to 4.4m.
Player
Chips
Progress
Oskar Szwed
4,400,000
1,190,000
Marco Paolo Scalia
0
0
To The Rail Posted Monday 21st October, 2019 at 14:20(UTC+2) by Gia Carnestorm
Player
Chips
Progress
Ugo Giuseppe Gasparini
0
0
Ultvedt Christoffer
0
0
Nebojsa Bulatovic
0
0
Pedro Ivars Domenech
0
0
Ovidiu-Dorin Barna
0
0
Nitsan Perets
0
0
Miroslav Prasil
0
0
Andrew James Middleton
0
0
Mirco Ferrini
0
0
Mirco Arico
0
0
Louis Karam
0
0
Pictures from the Feature Table Posted Monday 21st October, 2019 at 14:11(UTC+2) by Chris Martin
14:07 (UTC+2)
Start of Level 25 Blinds: 25000/50000 Ante: 50000
Hynes Eliminated in Cooler; Schwaederle Leads Posted Monday 21st October, 2019 at 14:06(UTC+2) by Gia Carnestorm
The cards fell , and Aidan Hynes bet 800,000 from the big blind.
Schwaederle moved all in, and Hynes called.
Hynes held for a set, but in a cooler, Schwaederle revealed for the higher set.
The on the river provided to be no miracle card for Hynes, and he departed from the Main Event despite starting the day as one of the chip leaders.
Player
Chips
Progress
Cedric Brice Eric Schwaederle
4,200,000
1,435,000
Aidan Paul Hynes
0
0
Early Exits Posted Monday 21st October, 2019 at 13:57(UTC+2) by Gia Carnestorm
Player
Chips
Progress
Victor Feu Gonzalez
515,000
0
Evgenii Margolin
500,000
0
Giorgio Colombo
460,000
0
Paolo Infantino
0
0
Maksims Azarjancs
0
0
Neoklis Konstantinou
0
0
Sander Klomp
0
0
John Cahilll
0
0
Mats Gustav Villern Karlsson
0
0
Andre Scerri
0
0
Casero Eliminated by Theodosiou Posted Monday 21st October, 2019 at 13:34(UTC+2) by Chris Martin
Carlos Martinez Casero opened to 110,000 and Petros Theodosiou three-bet to 285,000 from the next position.
Casero tanked and then shoved for 820,000. Theodosiou called.
Carlos Martinez Casero: Petros Theodosiou:
The jacks held on the with Theodosiou clapping his hands together in celebration as he moved up to around two million in chips.
Player
Chips
Progress
Petros Theodosiou
2,000,000
775,000
Carlos Martinez Casero
0
0
Seven-Deuce Never Lose Posted Monday 21st October, 2019 at 13:32(UTC+2) by Chris Martin
Action was on an board and Dwayne Sluis had bet 350,000 or about the size of the pot with Andre Scerri tanking.
Scerri tank-called with but Sluis had turned a straight with much to Scerri's dismay.
Player
Chips
Progress
Dwayne Jeremy Sluis
3,000,000
645,000
Andre Scerri
800,000
195,000
Updated Chip Counts Posted Monday 21st October, 2019 at 13:29(UTC+2) by Chris Martin
Player
Chips
Progress
Serghei Lisiii
3,000,000
270,000
Mike Georges Alonso
1,700,000
300,000
Enrico Grella
1,500,000
70,000
Nitsan Perets
950,000
140,000
Antonio Alba
700,000
315,000
Leo Jean Jaques Adrien Lombardozzi
600,000
230,000
Pasquale Braco
470,000
30,000
Mirco Arico
400,000
140,000
Zuzic Shoves on Larsson Posted Monday 21st October, 2019 at 13:26(UTC+2) by Gia Carnestorm
The action folded around to Rafael Zuzic in the smal blind, and he called.
Lars Larsson raised to 190,000, and Zuzic went into the tank for a minute before he shoved for 865,000.
Larsson also needed time to think, but with 1.7m, behind, he opted to fold.
"I should have checked," joked Larsson, and Zuzic crossed a million.
Player
Chips
Progress
Lars Greger Larsson
1,700,000
800,000
Rafael Zuzic
1,050,000
205,000
Cahill Two-Outed from the Main Event by Hynes Posted Monday 21st October, 2019 at 13:15(UTC+2) by Chris Martin
John Cahill was all in pre-flop for around 850,000 against Aidan Hynes who was the big stack with 950,000.
John Cahill: Aidan Hynes:
The flop gave Cahill the lead with top pair, and the turn improved him to trips.
However, the river saw Hynes hit his two-outer to send Cahill to the rail.
Player
Chips
Progress
Aidan Paul Hynes
1,800,000
805,000
John Cahilll
0
0
Shuffle Up and Deal Posted Monday 21st October, 2019 at 13:05(UTC+2) by Chris Martin
Cards are in the air with 88 players remaining in the 2019 Battle of Malta Main Event.
They are all guaranteed €2,480. Good luck to everyone still in!
Gulas Leads 88 Players into Day 3 Posted Monday 21st October, 2019 at 12:07(UTC+2) by Gia Carnestorm
At 1 PM local time, Day 3 of the 2019 Battle of Malta €550 Main Event will begin with 88 players, all looking to seal a spot at the final table of nine.
Josef Gulas has the chip lead after he bagged an impressive 3.7m, with Rune Moerk (3.3m), and Oskar Szwed (3.2m) completing the top three counts.
The well-known names of Steven Van Zadelhoff (2.3m), Leo Worthington-Leese (1.5m), Ludovic Geilich (1.1m), and Dehlia De Jong (1m), will also return.
The play will start in level 24 with blinds at 20,000-40,000-40,000 on a 60-minute clock, and the action will conclude once the final nine is reached.
Stay tuned right here for all the live updates throughout the day!
12:05 (UTC+2)
Day 3 of Battle of Malta 2019 Started Level: 24 Blinds: 20000/40000 Ante: 40000
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 and he was eliminated.
. However, Gulas had rivered a straight with 
and Brenseth was eliminated.
of chip leader Serghei Lisiii.
and Worthington-Leese doubled, leaving Brenseth short.
with no help for Re who was eliminated. The final 16 players are all guaranteed €15,580 and are now redrawing around two tables.
for a missed straight draw, and Firstenko won the pot with 
run out, chipping up to around 3,000,000 leaving Re with around five big blinds.
with Van Zadelhoff avoiding counterfeit outs to send his opponent to the rail.
of Lisii.
, and all the chips went into the middle between Renato Messina, in the cutoff, and Enrico Grella in the big blind. 
appeared, Messina improved to a full house to steal the pot. 
, and Aidan Hynes bet 800,000 from the big blind. 
on the river provided to be no miracle card for Hynes, and he departed from the Main Event despite starting the day as one of the chip leaders. 
