0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0068 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-21'
AND `url` = 'https://www.maineventtravel.com/live-reporting/battleofmalta-2002/3/updates'
ORDER BY `views` DESC

0.0096 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-21'
AND `url` = 'https://www.maineventtravel.com/live-reporting/battleofmalta-2002/3/updates'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0283 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0068 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '22'
AND `published` = 1

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

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

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '8'
AND `name` = '3'

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

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

0.0067 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1208'
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` = '1207'
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` = '1206'
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` = '1205'
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` = '1204'
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` = '1203'
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` = '1202'
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` = '1201'
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` = '1200'
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` = '1199'
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` = '1198'
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` = '1197'
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` = '1196'
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` = '1195'
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` = '1193'
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` = '1192'
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` = '1194'
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` = '1191'
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` = '1190'
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` = '1189'
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` = '1188'
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` = '1187'
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` = '1186'
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` = '1185'
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` = '1184'
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` = '1183'
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` = '1182'
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` = '1181'
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` = '1180'
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` = '1179'
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` = '1177'
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` = '1178'
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` = '1176'
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` = '1175'
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` = '1174'
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` = '1173'
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` = '1172'
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` = '1171'
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` = '1170'
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` = '1169'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1168'
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` = '1167'
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` = '1166'
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` = '1165'
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` = '1164'
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` = '1163'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

0.0077 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1143'
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` = '1141'
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` = '1142'
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` = '1140'
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` = '1139'
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` = '1138'
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` = '1137'
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` = '1136'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0117 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1202'
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` = '1201'
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` = '1200'
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` = '1199'
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` = '1198'
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` = '1197'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1189'
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` = '1188'
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` = '1187'
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` = '1186'
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` = '1185'
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` = '1184'
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` = '1183'
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` = '1182'
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` = '1181'
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` = '1180'
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` = '1179'
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` = '1177'
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` = '1178'
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` = '1176'
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` = '1175'
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` = '1174'
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` = '1173'
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` = '1172'
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` = '1171'
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` = '1170'
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` = '1169'
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` = '1168'
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` = '1167'
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` = '1166'
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` = '1165'
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` = '1164'
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` = '1163'
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` = '1162'
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` = '1159'
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` = '1161'
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` = '1160'
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` = '1158'
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` = '1157'
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` = '1156'
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` = '1155'
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` = '1154'
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` = '1153'
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` = '1152'
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` = '1151'
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` = '1150'
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` = '1149'
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` = '1148'
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` = '1147'
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` = '1146'
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` = '1145'
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` = '1144'
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` = '1143'
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` = '1141'
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` = '1142'
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` = '1140'
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` = '1139'
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` = '1138'
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` = '1137'
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` = '1136'
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` = '1135'
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` = '1134'
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` = '1133'
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` = '1132'
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` = '1131'
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` = '1130'
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` = '1129'
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` = '1128'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

    

Open Modal

Hi,

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

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

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

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

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

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(3)
  • 888poker UK Poker League(6)
  • APAT(1)
  • APPT(0)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(5)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(11)
  • BSOP(0)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(2)
  • EPT(2)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(70)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(0)
  • GUKPT Grosvenor(9)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • Kings of Tallinn(1)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(11)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Open(5)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(0)
  • The Caribbean Poker Series(0)
  • The Festival(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(2)
  • Women's Winter Festival(0)
  • WPT(2)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(13)
  • WSOP International Circuit(5)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

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

English

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

• £   GBP
• $   USD
• €   EUR

Battle of Malta 2022 Battle of Malta 2022 (April) Live Reporting - Day 4

Current Level 38 Current Day 4

---

Blinds 400,000/800,000 Ante 800000

Entries 2,592 Remaining 1

---

Prize Pool (EUR) €1,244,160 First Prize (EUR) €200,340

Chip Leaders Day 4

1

Giuseppe Rosa

15,000,000

Day 1A Day 1B Day 1C Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 3

Giuseppe Rosa Leads the Final 9 of the 2022 Battle of Malta Main Event Posted Tuesday 26th April, 2022 at 02:21(UTC+2) by Jason Glatzer

Italy's Giuseppe Rosa leads the final nine players in the 2022 Battle of Malta Main Event at Casino Malta by Olympic Casino with his eyes on the coveted trophy and the €200,340 top prize.

Rosa, who bagged a massive stack of 15,875,000 in chips, had three huge hands near the end of the day to grow his below-average stack into the chip lead. The first of the trio of hands sent Michael Koren to the rail in 12th place with his ace-queen proving to be good against king-jack.

The next hand featured the biggest pot of the day. Rosa jammed the river with ace-seven for two pair and doubled through Jeremy Roseau who eventually called with a pair of kings holding king-six to win a pot north of 13 million in chips.

Finally, Rosa could have maybe won even more in a pot against Peep Kivistik. Rosa flopped a set with queens and somehow the stacks never got in the middle with Kivistik displaying some pot control on the final table bubble with short stacks on the other table.

Rosa with $133,135 in live tournament earnings according to The Hendon Mob, is no stranger to a big final table stage as in 2019 he finished in fourth place in the EPT Madrid Open for his biggest lifetime cash €62,550. Coincidentally, he only needs a fourth-place performance at tomorrow's final table for a new personal best.

While Rosa has a big lead, a few other players are only a double-up away from being the table captain including Jeremy Soreuo (9,675,000), Peep Kivistik (7,825,000), Noam Garama (7,450,000), and Federico Petruzzelli (7,325,000). Also still in contention are Stan van Dijk (5,800,000), who had a massive rail of dozens of Dutch players in Malta, Yossef Cohen (4,375,000), Valter Marchi (3,900,000), and Karol Szyszko (2,650,000).

2022 Battle of Malta Final Table Seat Draw

Seat	Player	Country	Chips	Big Blinds
1	Jeremy Soreau	France	9,675,000	48
2	Karol Szyszko	Poland	2,650,000	13
3	Stan van Dijk	Netherlands	5,800,000	29
4	Peep Kivistik	Estonia	7,825,000	39
5	Noam Garama	Israel	7,450,000	37
6	Yossef Cohen	Israel	4,375,000	22
7	Valter Marchi	Italy	3,900,000	20
8	Giuseppe Rosa	Italy	15,875,000	79
9	Federico Petruzzelli	Italy	7,325,000	37

The 2022 Battle of Malta attracted 2,592 entries to generate a €1,244,160 prize pool to more than double the €500,000 guarantee.

Action of the Day

Day 3 began with 65 players all with hopes of advancing to the final table and beyond. The day featured one-hour blind levels and moved at a fast and furious pace until there was only a couple of dozen players remaining.

Among the notable players advancing to the penultimate day but unable to find a bag to the final table included Josef Gulas Sr. (19th - €3,730), Kevin Malone (21st - €3,730), 2019 Battle of Malta runner-up Steven van Zadelhoff (39th - €2,670), and Dehlia De Jong (59th - €2,240). Alessandra Cuntro was the last female player standing after she bowed out in 48th place for €2,360.

The final table bubble was one to remember as the marathon affair took 27 hands. Eventually, the day was in the books after Francesco Cuoccio was unable to get there with eight-six against Yossef Cohen's ace-queen.

Final Table Payouts

All nine returning players are each guaranteed at least a five-figure haul of €10,580 with the eventual winner slated to be rewarded a whopping €200,340. Blinds will start with eight minutes remaining in Level 32 with blinds at 100,000/200,000 before increasing to 100,000/250,000.

Place	Prize
1	€200,340
2	€140,000
3	€100,000
4	€72,000
5	€54,120
6	€41,680
7	€29,240
8	€18,040
9	€10,580

Jason Glatzer, who has been blogging all week alongside Juhani Tyriseva, will be commentating on the live stream at a variety of social media channels on Tuesday starting at 2:30 p.m. CEST. But also, stay tuned to the blog as Tyriseva will be updating the blog all day long with posts, photos, and videos.

Final Table Seat Draw Posted Tuesday 26th April, 2022 at 01:18(UTC+2) by Jason Glatzer

Seat	Player	Chips	Big Blinds
1	Jeremy Soreau	9,675,000	48
2	Karol Szyszko	2,650,000	13
3	Stan van Dijk	5,800,000	29
4	Peep Kivistik	7,825,000	39
5	Noam Garama	7,450,000	37
6	Yossef Cohen	4,375,000	22
7	Valter Marchi	3,900,000	20
8	Giuseppe Rosa	15,875,000	79
9	Federico Petruzzelli	7,325,000	37

Player		Chips	Progress
Giuseppe Rosa		15,875,000	125,000
Jeremy Soreau		9,675,000	1,175,000
Peep Kivistik		7,825,000	1,825,000
Noam Garama		7,450,000	1,050,000
Federico Petruzzelli		7,325,000	1,450,000
Stan van Dijk		5,800,000	1,200,000
Yossef Cohen		4,375,000	0
Valter Marchi		3,900,000	400,000
Karol Szyszko		2,650,000	2,350,000

Francesco Cuoccio is the Final Table Bubble Boy Posted Tuesday 26th April, 2022 at 01:10(UTC+2) by Juhani Tyriseva

The final table was really fierce. All 10 players really wanted to sit down to the Final Table tomorrow. Plenty of time was used to almost every situation, which is understandable when pay jumps are growing.

Francesco Cuoccio got his short stack crippled against Valter Marchi, and he had only 1,000,000 left when he moved all in and got an instant call from Yossef Cohen.

Cohen

Cuoccio

The board ran and so Cuoccio's hopes for final table seat were smashed.

Cuoccio collected €7,780.

Player		Chips	Progress
Yossef Cohen		4,375,000	575,000

Scary Board, Can I Call? Posted Tuesday 26th April, 2022 at 00:45(UTC+2) by Juhani Tyriseva

Hand 19 in the Final table bubble: Valter Marchi opened to 400,000 from the small blind, Francesco Cuoccio defended his big blind.

Players saw a flop now Cuoccio decided to bet 500,000, Marchi called The turn brought and Marchi moved all in 1,700,000. Cuoccio took his time and folded.

Player		Chips	Progress
Valter Marchi		3,500,000	380,000
Francesco Cuoccio		1,600,000	300,000

Another Big Pot for Rosa Posted Tuesday 26th April, 2022 at 00:18(UTC+2) by Jason Glatzer

On the 11th hand of hand-for-hand play on the bubble, Giuseppe Rosa opened for 450,000 from the cutoff and was called by Peep Kivistik from the small blind.

Kivistik check-called for 375,000 on the flop before both players checked the turn. The river completed the board and Kivistik led out for 1,000,000. Rosa jacked it up to 3,600,000 and Kivistik went into the tank for about five minutes.

Eventually Kivistik made the call only to get the bad news with Rosa holding for a full house to crack Kivistik's to take down the pot.

Player		Chips	Progress
Giuseppe Rosa		16,000,000	2,800,000
Peep Kivistik		6,000,000	300,000

Celebration Heard Around the Room After Rosa Doubles Through Soreau Posted Monday 25th April, 2022 at 23:47(UTC+2) by Jason Glatzer

On the fourth hand of hand-for-hand play on the final table bubble, Guiseppe Rosa opened for 800,000 from the small blind and was called by Giuseppe Rosa from the big blind.

Rosa fired out for 600,000 on the flop and for 1,500,000 on the turn and was called both times. The completed the board on the river and Rosa jammed for 3,575,000. Soreau went into tank for about three minutes before he made the called.

Rosa slammed down the for two pair and screamed in celebration and ran over to his rail shouting after he saw he beat the held by Soreau.

Player		Chips	Progress
Giuseppe Rosa		13,200,000	7,600,000
Jeremy Soreau		8,500,000	2,500,000

Michele Biggi Eliminated Posted Monday 25th April, 2022 at 23:24(UTC+2) by Juhani Tyriseva

Michele Biggi and Noam Garama went all in preflop. The board ran to Noam's favor and we are down to 10 players.

Player		Chips	Progress
Noam Garama		8,500,000	2,900,000
Michele Biggi		0	0

Michael Koran Eliminated Posted Monday 25th April, 2022 at 23:20(UTC+2) by Juhani Tyriseva

Michael Koran and Giuseppe Rosa went all-in preflop. The board ran 3and Michael was eliminated.

Player		Chips	Progress
Giuseppe Rosa		5,600,000	2,200,000
Michael Koran		0	0

Break Time Posted Monday 25th April, 2022 at 23:17(UTC+2) by Jason Glatzer

Players are on what is likely their last 15-minute break.

Another Double for Szyszko Posted Monday 25th April, 2022 at 23:09(UTC+2) by Jason Glatzer

Karol Szyszko was down to just a handful of big blinds not too long ago but is now back in business as he just doubled up again as follows.

Szyszko jammed for 2,350,000 and was called by Francesco Cuoccio.

Karol Szyszko:

Francesco Cuoccio:

It was a bit of a sweat for Szyszko with Cuoccio flopping a flush draw on the flop. The blank turn didn't change anything in the hand. Szyszko stood up and celebrated after the river completed the board and he doubled his stack with a set of sevens.

Player		Chips	Progress
Karol Szyszko		5,000,000	3,300,000
Francesco Cuoccio		1,900,000	1,505,000

King-Nine Good Against King-Eight for Szyszko Posted Monday 25th April, 2022 at 22:56(UTC+2) by Jason Glatzer

Karol Szyszko (picture above) jammed for 775,000 from the small blind. Yossef Cohen appeared to be deep in thought for about 40 seconds before he found the call.

Karol Szyszko:

Yossef Cohen:

Szyszko was ahead of Cohen the entire way with the dealt out on the board to double his stack.

Player		Chips	Progress
Yossef Cohen		3,800,000	1,700,000
Karol Szyszko		1,700,000	1,100,000

Marco Cosic Eliminated Posted Monday 25th April, 2022 at 22:48(UTC+2) by Juhani Tyriseva

Marco Cosic and Peep Kivistik went all-in preflop. The board kept Peep's snowmen in the lead all the way and Marco was eliminated.

Player		Chips	Progress
Peep Kivistik		6,300,000	2,100,000
Marco Cosic		0	0

Edoardo Mancinelli Eliminated Posted Monday 25th April, 2022 at 22:41(UTC+2) by Juhani Tyriseva

Stan van Dijk moved all in from the small blind and Edoardo Mancinelli called all-in.The board crashed Edoardo's hopes of the final table seat.

Player		Chips	Progress
Stan Van Dijk		7,000,000	1,600,000
Edoardo Mancinelli		0	0

Danel Vaitzman Eliminated Posted Monday 25th April, 2022 at 22:37(UTC+2) by Juhani Tyriseva

Danel Vaitzman and Stan van Dijk called. The board did not help Danel, and he went to the cashier to collect his winnings.

Player		Chips	Progress
Stan Van Dijk		5,400,000	1,600,000
Danel Vaitzman		0	0

Black Widows Keep Dream Alive Posted Monday 25th April, 2022 at 22:29(UTC+2) by Juhani Tyriseva

Karol Szyszko and Michele Biggi went all in preflop. The board was favorable for Michele, who doubled up.

Player		Chips	Progress
Michele Biggi		3,500,000	1,400,000
Karol Szyszko		600,000	1,400,000

Scary Board, Big Bet, What to do? Posted Monday 25th April, 2022 at 22:29(UTC+2) by Juhani Tyriseva

Michele Biggi opened, Noam Garama defended his big blind. The flop was checked. The brought Michele fired 380,000, Noam called. The river was scary Michele bet 825,000, Noam tanked for a while and called. Michele tapped the table and folded. Noam showed and collected a nice pot.

Player		Chips	Progress
Noam Garama		5,600,000	2,000,000
Michele Biggi		2,100,000	750,000

22:29 (UTC+2)

Start of Level 31
Blinds: 80,000/160,000     Ante: 160,000

Two Table Redraw Posted Monday 25th April, 2022 at 22:07(UTC+2) by Jason Glatzer

Seat	Table 17	Table 18
1	Giuseppe Rosa	Valter Marchi
2	Michele Biggi	Daniel Vaitman
3	Marco Cosic	Stan van Dijk
4	Jeremy Soreau	Edoardo Maninelli
5	Peep Kivistik
6	Noam Garama	Yossef Cohen
7	Michael Koran	Federico Petruzzelli
8	Karol Szyszko	Francesco Cuoccio

Full House for Soreau to Oust Valerio Posted Monday 25th April, 2022 at 22:05(UTC+2) by Jason Glatzer

The clock was stopped waiting for the redraw but before that happened a hand that took more than 10 minutes.

Both players checked with more than 2 million in the pot and the on the board. Jeremy Soreau tanked for several minutes before he jammed. 

Valerio Mascolo tanked for about five minutes before Soreau called for time. With less than five seconds left on the clock, Mascolo called off for about 2 million.

Soreau turned over for a full house. Mascolo slammed his hand down in frustration and nearly left before he was given his payout slip after showing his losing hand of .

Player		Chips	Progress
Jeremy Soreau		11,000,000	4,350,000
Valerio Mascolo		0	0

Alexandros Dranovitsas Eliminated Posted Monday 25th April, 2022 at 21:55(UTC+2) by Juhani Tyriseva

Alexandros Dranovitsas and Noam Garama went all-in preflop. The board did not help Alexandros.

We are down to 16 players. Total redraw is made, new seating order follows.

Player		Chips	Progress
Noam Garama		3,600,000	400,000
Alexandros Dranovitsas		0	0

Ugo Gasparini Eliminated Posted Monday 25th April, 2022 at 21:45(UTC+2) by Juhani Tyriseva

Ugo Gasparini and Stan van Dijk went all-in preflop. The board was not favorable for Ugo, and went to the cashier to collect his winnings.

Player		Chips	Progress
Stan Van Dijk		3,800,000	900,000
Ugo Gasparini		0	0

Cohen Doubles Through Szyszko Posted Monday 25th April, 2022 at 21:38(UTC+2) by Jason Glatzer

Yossef Cohen jammed for 2.7 million from the small blind and was called by Karol Szyszko from the big blind.

Yossef Cohen:

Karol Szyszko:

Cohen whiffed the flop and the turn. But he celebrated after improving to a better two pair than Szyszko after the river completed the board.

Player		Chips	Progress
Yossef Cohen		5,500,000	3,835,000
Karol Szyszko		2,000,000	160,000

Soreau Eliminates Gulas Posted Monday 25th April, 2022 at 21:20(UTC+2) by Jason Glatzer

Josef Gulas opened for 275,000 from early position and Jeremy Soreau defended his big blind. Soreau check-raised the flop from 200,000 to 600,000. The floor was called by Gulas who thought there was a string bet. The floor ruled it was a legal raise and Gulas called.

Soreau bet 1,100,000 on the turn and Gulas called. A jam came by Soreau on the river. Gulas went into the tank before calling off for about 2,600,000.

Soreau turned over for a straight and Gulas was out of the tournament in 18th place after showing .

Mancinelli Doubles Through van Dijk Posted Monday 25th April, 2022 at 21:16(UTC+2) by Jason Glatzer

Edoardo Mancinelli jammed for 1.2 million from the hijack. Stan van Dijk looked him up from the cutoff and the cards were turned over.

Edoardo Mancinelli:

Stan van Dijk:

Van Dijk shooked his head in frustration after the board as his opponent improved to trips to double his stack.

Player		Chips	Progress
Stan Van Dijk		4,700,000	1,300,000
Edoardo Mancinelli		2,700,000	945,000

Alexandros is Grinding Posted Monday 25th April, 2022 at 21:11(UTC+2) by Juhani Tyriseva

Alexandros Dranovitsas pushed his last 550,000 to the middle from small blind, Giuseppe Rosa called from the big blind. The board 8gave Alexandros a straight and a double up.

Player		Chips	Progress
Giuseppe Rosa		3,400,000	600,000
Alexandros Dranovitsas		1,200,000	700,000

Van Dijk Ousts Desmond Posted Monday 25th April, 2022 at 21:03(UTC+2) by Jason Glatzer

On the first hand after the break, Cory Desmond jammed for 2,495,000 from the button and was called by Stan van Dijk from the big blind.

Cory Desmond:

Stan van Dijk:

Desmond was ahead on the flip after both the flop and the turn. However, van Dijk's rail erupted after his nine paired on the river to oust Desmond in 20th place.

Player		Chips	Progress
Stan Van Dijk		6,000,000	2,450,000
Cory Desmond		0	0

Full Tummies and Back to Action Posted Monday 25th April, 2022 at 20:55(UTC+2) by Jason Glatzer

Players are back in their seats from the dinner break and ready for action. Just nine of the 20 players will survive the day and advance to tomorrow's final table. 

20:55 (UTC+2)

Start of Level 30
Blinds: 60,000/120,000     Ante: 120,000

Petruzzelli Leads Final 20 at Dinner Break Posted Monday 25th April, 2022 at 20:31(UTC+2) by Jason Glatzer

Federico Petruzzelli (pictured below) leads the way at the dinner break. Here is a look at all of the stacks of the final 20 players.

Player		Chips	Progress
Federico Petruzzelli		8,775,000	2,775,000
Jeremy Soreau		6,650,000	2,050,000
Josef Gulas		4,900,000	400,000
Marco Cosic		4,900,000	200,000
Peep Kivistik		4,200,000	1,500,000
Giuseppe Rosa		4,000,000	500,000
Stan Van Dijk		3,550,000	1,200,000
Francesco Cuoccio		3,405,000	405,000
Noam Garama		3,200,000	1,100,000
Michael Koran		3,200,000	300,000
Valter Marchi		3,120,000	2,170,000
Valerio Mascolo		3,065,000	1,035,000
Michele Biggi		2,850,000	90,000
Cory Desmond		2,495,000	345,000
Karol Szyszko		1,840,000	340,000
Edoardo Mancinelli		1,755,000	405,000
Danel Vaitzman		1,700,000	750,000
Yossef Cohen		1,665,000	1,135,000
Ugo Gasparini		1,150,000	150,000
Alexandros Dranovitsas		500,000	100,000

Dinner Break Posted Monday 25th April, 2022 at 19:56(UTC+2) by Jason Glatzer

Players are now on a 75-minute dinner break.

Kevin Malone Eliminated Posted Monday 25th April, 2022 at 19:51(UTC+2) by Juhani Tyriseva

Kevin Malone went all-in with his remaining 815,000. Valerio Mascolo sat next to him and called after a small hesitation.

The board ran so Kevin's returned hopes were smashed at the river.

Player		Chips	Progress
Valerio Mascolo		4,100,000	1,300,000
Kevin Malone		0	0

Gulas Eliminates Natasi Posted Monday 25th April, 2022 at 19:50(UTC+2) by Jason Glatzer

Eros Nastasi jammed for 1,200,000 from the hijack and was snap-called by Josef Gulas from the big blind.

Eros Nastasi:

Josef Gulas:

Nastasi failed to snag a piece of the board to hit the rail in 21st place.

Player		Chips	Progress
Josef Gulas		4,500,000	850,000
Eros Nastasi		0	0

Secret Winner Posted Monday 25th April, 2022 at 19:38(UTC+2) by Juhani Tyriseva

Peep Kivistik and Noam Garama have taken a couple of blind vs blind matches during the last hour. Now Peep limped, Noam raised to 325,000, Peep called. The flop was and both players checked. The turn brought Noam bet 175,000 and Peep called. The river was Noam fired 475,000, Peep took his time and decided to call. Noam folded quickly, now Peep wanted a confirmation from the dealer: "Do I have to show my hand", was the question. "No", replied the dealer, and Peep collected a nice pot, without showing his hand.

Player		Chips	Progress
Peep Kivistik		2,700,000	950,000
Noam Garama		2,100,000	300,000

Nine Was the Card Posted Monday 25th April, 2022 at 19:19(UTC+2) by Juhani Tyriseva

Ugo Gasparini and Karol Szyszko went all-in preflop. The board ran and Ugo's tournament life was saved by the bell, he doubled up.

Player		Chips	Progress
Karol Szyszko		1,500,000	1,200,000
Ugo Gasparini		1,300,000	900,000

Full House for Mancinelli Posted Monday 25th April, 2022 at 19:12(UTC+2) by Jason Glatzer

Edoardo Mancinelli jammed for six big blinds from the cutoff and was called by Ugo Gasparini from the big blind.

Edoardo Mancinelli:

Ugo Gasparini:

Gasparini bricked the board. Meanwhile, Mancinelli, who didn't need to improve, had a full house at the end to double his short stack.

Player		Chips	Progress
Edoardo Mancinelli		1,350,000	850,000
Ugo Gasparini		400,000	900,000

Francesco's Two Pair Give Him a Double Up Posted Monday 25th April, 2022 at 19:06(UTC+2) by Juhani Tyriseva

The board at the turn was and now Francesco Cuoccio and Kevin Malone the river did not help Kevin, so Francesco's two pairs were good, and he doubled up.

Player		Chips	Progress
Francesco Cuoccio		3,000,000	2,000,000
Kevin Malone		2,000,000	1,000,000

Samuel Biland Eliminated Posted Monday 25th April, 2022 at 19:01(UTC+2) by Juhani Tyriseva

Samuel and Giuseppe Rosa went all-in preflop. The board did not help Samuel, and he was eliminated.

Player		Chips	Progress
Giuseppe Rosa		3,500,000	2,100,000
Samuel Biland		0	0

Petruzzelli Rakes in Massive Pot Against Mancinelli Posted Monday 25th April, 2022 at 18:56(UTC+2) by Jason Glatzer

Edoardo Mancinelli checked the flop with about 700,000 in the pot. Federico Petruzzelli bet 125,000 and a few moments later Mancinelli raised to 600,000. Petruzzelli went into the tank for a couple of minutes before he jammed for 2,825,000. Mancinelli had his opponent covered and wasted no time in making the call.

Federico Petruzzelli:

Edoardo Mancinelli:

Petruzzelli had the better flush draw than that of his opponent and was ahead with king high. Mancinelli still had outs with any non-heart four, five, or six.

The turn took away most of Mancinelli's outs as it gave Petruzzelli the top pair. The blank completed the board on the river and the dealer awarded Petruzzelli a huge pot.

Player		Chips	Progress
Federico Petruzzelli		6,000,000	4,300,000
Edoardo Mancinelli		500,000	2,130,000

18:47 (UTC+2)

Start of Level 29
Blinds: 50,000/100,000     Ante: 100,000

Ugo Gasparini Doubles Up Posted Monday 25th April, 2022 at 18:47(UTC+2) by Juhani Tyriseva

Ugo Casparini and Federico Petruzelli went all-in preflop. The board made Ugo a straight, so he doubled up.

Player		Chips	Progress
Federico Petruzzelli		1,700,000	350,000
Ugo Gasparini		1,300,000	420,000

Vincenzo Pellegrino Eliminated Posted Monday 25th April, 2022 at 18:44(UTC+2) by Juhani Tyriseva

Vincenzo and Giuseppe Rosa went all-in preflop. The board did not help Vincenzo, so we are down to 23 players.

Player		Chips	Progress
Giuseppe Rosa		1,400,000	715,000
Vincenzo Pellegrino		0	0

Three Table Redraw Posted Monday 25th April, 2022 at 18:31(UTC+2) by Jason Glatzer

The action was down to 24 players after Emanuele Cassibba hit the rail. Here is a look at the final three table redraw.

Seat	Table 18	Table 19	Table 20
1	Samuel Biland	Yossef Cohen	Michele Biggi
2	Peep Kivistik	Karol Szyszko	Francesco Cuoccio
3	Noam Garam	Ugo Gasparini	Eros Nastasi
4	Danel Vaitzman	Cory Desmond	Valter Marchi
5	Marco Cosic	Edoardo Mancinelli	Jeremy Soreau
6	Vincenzo Pellegrin	Stan Van Dijk	Kevin Malone
7	Giuseppe Rosa	Alexandros Dranovisas	Valerio Mascolo
8	Michael Koran	Federico Petruzzelli	Josef Gulas Sr.

Player		Chips	Progress
Emanuele Cassibba		0	0

Koran Made a Nice Call Posted Monday 25th April, 2022 at 18:24(UTC+2) by Juhani Tyriseva

Kevin Malone opened from the middle position, Michael Koran 3-bet from the button, Kevin called. The flop was and both players checked. The turn brought and the players checked again. came to the river and now Kevin decided to bet 500,000. Michael seemingly did not like a bet, but started to think about this hand, which really had a dangerous board. Finally, he decided to call.

"You got me", confessed Kevin and showed Michael showed and raked a nice pot.

Player		Chips	Progress
Michael Koran		3,500,000	550,000
Kevin Malone		3,000,000	750,000

Vaitzman Doubles with a Flush Posted Monday 25th April, 2022 at 18:03(UTC+2) by Jason Glatzer

Danel Vaitzman jammed for 1,145,000 from under the gun. The action folded around to Alexandros Dranovitsas in the big blind who snap-called.

Danel Vaitzman:

Alexandros Dranovitsas:

Dranovitsas was ahead and remained that way after the came on the flop. The turn opened up both a flush draw and a gutshot straight draw in addition to winning the hand if a king came on the river. The flush draw was completed after the came raining down on the river and Vaitzman breathed a huge sigh of relief.

Player		Chips	Progress
Danel Vaitzman		2,450,000	1,200,000
Alexandros Dranovitsas		400,000	1,030,000

Chipcount at the Break Posted Monday 25th April, 2022 at 18:00(UTC+2) by Juhani Tyriseva

Here is the full chip count at the break.

Player		Chips	Progress
Marco Cosic		4,700,000	1,750,000
Jeremy Sereau		4,600,000	1,730,000
Kevin Malone		3,750,000	1,300,000
Josef Gulas		3,650,000	1,450,000
Eros Nastasi		3,450,000	100,000
Michael Koran		2,950,000	150,000
Yossef Cohen		2,800,000	800,000
Valerio Mascolo		2,800,000	800,000
Michele Biggi		2,760,000	1,315,000
Karol Szyszko		2,700,000	2,250,000
Edoardo Mancinelli		2,630,000	1,130,000
Samuel Biland		2,450,000	685,000
Noam Garama		2,400,000	0
Stan Van Dijk		2,350,000	550,000
Cory Desmond		2,150,000	345,000
Federico Petruzzelli		2,050,000	300,000
Peep Kivistik		1,750,000	550,000
Elhanan Torgeman		1,650,000	660,000
Alexandros Dranovitsas		1,430,000	720,000
Danel Vaitzman		1,250,000	325,000
Emanuele Cassibba		1,200,000	630,000
Vincenzo Pellegrino		1,050,000	550,000
Francesco Cuoccio		1,000,000	20,000
Valter Marchi		950,000	55,000
Ugo Gasparini		880,000	115,000

Suominen and Pinna Eliminated by Garama Posted Monday 25th April, 2022 at 17:49(UTC+2) by Juhani Tyriseva

"It was a bit weird hand", reported Finland's Keimo Suominen about his bustout. "Roberto Pinna opened 125,000, Noam Garama called behind, and I decided to call as well with my The flop came now I checked, Pinna lead 225,000, Garama called and moved all in 680,000. Pinna moved all in 1,600,000, Garama made some calculations and called as well. Pinna showed and Garama had Turn and made Garama a straight and sent me and Roberto to the rail", said Keimo.

Player		Chips	Progress
Roberto Pinna		0	0
Keimo Suominen		0	0

17:34 (UTC+2)

Start of Level 28
Blinds: 40,000/80,000     Ante: 80,000

Players are on a Short Break Posted Monday 25th April, 2022 at 17:30(UTC+2) by Jason Glatzer

Players are on a short break.

Player		Chips	Progress
Kevin Malone		3,700,000	1,250,000

Antonio Russo Eliminated Posted Monday 25th April, 2022 at 17:28(UTC+2) by Juhani Tyriseva

Antonio and Michael Koran went all-in preflop. The board did not help Antonio so he was eliminated from the tournament.

Player		Chips	Progress
Michael Koran		3,100,000	630,000
Antonio Russo		0	0

Mohamed Bouzgarrou Eliminated Posted Monday 25th April, 2022 at 17:24(UTC+2) by Juhani Tyriseva

Mohammed and Stan van Dijk went all-in preflop. The board did not help Mohammed, and he was eliminated.

Player		Chips	Progress
Stan Van Dijk		2,900,000	720,000
Mohamed Bouzgarrou		0	0

High Roller Near the Money Posted Monday 25th April, 2022 at 17:11(UTC+2) by Jason Glatzer

The two-day €1,100 High Roller DOMUS Bet Final attracted 154 entries. There are just 30 players remaining with just 27 players walking away with at least a min-cash of €1,500. 

The eventual winner is slated to receive a whopping €31,640.

Pawel Wakuluk, Martin von Zweigbergk, Christian Rysgaard, Jamie Nixon, Jonathan Therme, and Daniel Samson are among the players still competing for the title.

All Faces Shown Posted Monday 25th April, 2022 at 17:03(UTC+2) by Juhani Tyriseva

Here are the last missing players of today's photo session. Let us know if somebody who is still in has not gotten his face to the blog.

Marco Cosic

Michael Koran

Some More Faces Posted Monday 25th April, 2022 at 16:48(UTC+2) by Juhani Tyriseva

Antonio Russo

Dario Comitini

Jeremy Sereau

Yossef Cohen

End of the Road for The Viking Posted Monday 25th April, 2022 at 16:41(UTC+2) by Jason Glatzer

Steven van Zadelhoff finished runner-up in the Battle of Malta Main Event the last time it was held in 2019.

It was looking possible that "The Viking" could have made back-to-back final tables but he ran out of gas.

He lost a good amount of his stack when his didn't hold against . Shortly after, he jammed unsuccessfully from the small blind with the big blind waking up with .

Van Zadelhoff will have to wait until the autumn when the Battle of Malta returns to Casino Malta on Oct. 4-12 for his chance to win a Battle of Malta Main Event trophy this year.

Player		Chips	Progress
Steven van Zadelhoff		0	0

Some More Faces Posted Monday 25th April, 2022 at 16:19(UTC+2) by Juhani Tyriseva

Giuseppe Rosa

Michele Biggi

Mohamed Bouzgarrou

16:12 (UTC+2)

Start of Level 27
Blinds: 30,000/60,000     Ante: 60,000

Are These Big Pairs Any Good Against Big Slick? Posted Monday 25th April, 2022 at 16:11(UTC+2) by Juhani Tyriseva

Edoardo Mancinelli and Michele Biggi went all-in preflop. The board was good for Edoardo, who doubled up.

Player		Chips	Progress
Edoardo Mancinelli		3,200,000	1,700,000
Michele Biggi		700,000	745,000

Stephane Roux Eliminated Posted Monday 25th April, 2022 at 16:03(UTC+2) by Juhani Tyriseva

"I moved all-in and Valerio Mascolo called me with and he actually beat me twice, first he made a straight and finally a nut flush", reported Stephane.

Player		Chips	Progress
Valerio Mascolo		2,000,000	1,615,000
Stephane Roux		0	0

More Faces Posted Monday 25th April, 2022 at 15:45(UTC+2) by Juhani Tyriseva

Cory Desmond

Danel Vaitzman

Diego Grisiglione

Noam Garama

Valerio Mascolo

Biggi's Stack Gets Bigger After Eliminating Gardner Posted Monday 25th April, 2022 at 15:44(UTC+2) by Jason Glatzer

Former footballer Anthony Gardner went deep in the Main Event but recently headed to the cashier to collect the 42nd place prize of €2,670.

His final hand went as follows. Gardner opened from the cutoff for 105,000. Noam Garama defended the big blind to go heads-up to see the flop.

Garama checked before Gardner bet 125,000. Garama jammed and Gardner called off his stack of around 600,000.

Anthony Gardner:

Noam Garama:

Garama's top pair was good enough to eliminate Gardner after blanks hit the turn and river.

Player		Chips	Progress
Noam Garama		2,400,000	100,000
Anthony Gardner		0	0

Biggest Stacks Posted Monday 25th April, 2022 at 15:28(UTC+2) by Juhani Tyriseva

Here are the biggest stacks at the break.

Player		Chips	Progress
Eros Nastasi		3,550,000	700,000
Marco Cosic		2,950,000	740,000
Jeremy Sereau		2,870,000	2,295,000
Diego Grisiglione		2,590,000	760,000
Michael Koran		2,470,000	70,000
Kevin Malone		2,450,000	300,000
Federico Petruzzelli		2,350,000	195,000
Peep Kivistik		2,300,000	770,000
Josef Gulas		2,200,000	950,000
Stan Van Dijk		2,180,000	295,000
Antonio Russo		2,000,000	1,220,000

No More Ladies Remaining After Cuntro Hits the Rail Posted Monday 25th April, 2022 at 15:18(UTC+2) by Jason Glatzer

There are no more ladies remaining after Alessandra Cuntro hit the rail. Her husband, Gianluca Crimaldi shared with us about how her final hand went down.

Cuntro jammed with queen-jack suited from the small blind and was called by the player in the big blind with ace-eight. Both players bricked the board and the player in the big blind won the hand with ace-high to eliminate Cuntro.

Player		Chips	Progress
Alessandra Cuntro		0	0

15:14 (UTC+2)

Start of Level 26
Blinds: 25,000/50,000     Ante: 50,000

And More Faces Posted Monday 25th April, 2022 at 15:10(UTC+2) by Juhani Tyriseva

We do our best to provide a photo of all still remaining players.

Federico Petruzelli

Antonio Merone

Edoardo Mancinelli

Stephane Roux

Mariano D'aquila

First Break Posted Monday 25th April, 2022 at 15:02(UTC+2) by Jason Glatzer

Day 3 is on its first break of the day.

More Faces Posted Monday 25th April, 2022 at 15:02(UTC+2) by Juhani Tyriseva

Samuel Biland

Stan van Dijk

Pawel Fraczek

Karol Szyszko

Big Slick for Anello Posted Monday 25th April, 2022 at 14:59(UTC+2) by Jason Glatzer

Giovanni Anello jammed his short stack of 70,000 and was called by Paolo Pinazzo from the cutoff. Jeremy Sereau three-bet to 350,000 and Pinazzo went into the tank for about three minutes before he folded.

Giovanni Anello:

Paolo Pinazzo:

Anello's big slick held on the runout to more than quadruple up.

Player		Chips	Progress
Giovanni Anello		290,000	145,000

More Faces Posted Monday 25th April, 2022 at 14:26(UTC+2) by Juhani Tyriseva

Lior Torgeman

Peep Kivistik

Dylan Cechowski

Alessandro Cuntro Last Lady Standing Posted Monday 25th April, 2022 at 14:13(UTC+2) by Jason Glatzer

Alessandro Cuntro is the last lady standing in the event. While she doesn't have one of the biggest stacks in the room with 700,000 in chips, it would take just one double-up to put her ahead of the average stack of 1.3 million.

Player		Chips	Progress
Alessandra Cuntro		700,000	75,000

Quick Chipcount Posted Monday 25th April, 2022 at 14:09(UTC+2) by Juhani Tyriseva

We found 7 players, who have more than 2 million.

Player		Chips	Progress
Diego Grisiglione		3,350,000	255,000
Peep Kivistik		3,070,000	1,875,000
Eros Nastasi		2,850,000	565,000
Kevin Malone		2,750,000	1,960,000
Michael Koran		2,400,000	960,000
Noam Garama		2,300,000	100,000
Marco Cosic		2,210,000	790,000

14:02 (UTC+2)

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

Mancinelli Triples with Queens Posted Monday 25th April, 2022 at 14:01(UTC+2) by Jason Glatzer

Edoardo Mancinelli already had all his stack committed in a pot north of 1.5 million and was up against Angelo Patane and Mariano D'aquila.

Patane jammed for 525,000 on the flop. D'aquila went into the tank for a couple of minutes before he opted to fold.

Edoardo Mancinelli:

Angelo Patane:

Patane was unable to get there after the turn and river completed the board and Mancinelli earned a triple up. A short while later, Patane lost the rest of his stack as did Massimo De Giorgi, Kristaps Zarans, and Flaviano Cammisuli.

Player		Chips	Progress
Edoardo Mancinelli		2,400,000	1,705,000
Mariano D'aquila		600,000	355,000
Angelo Patane'		0	0
Flaviano Cammisuli		0	0
Kristaps Zarans		0	0
Giorgi De Massimo		0	0

And More Faces Posted Monday 25th April, 2022 at 13:55(UTC+2) by Juhani Tyriseva

Christian Pedersen

Valter Marchi

Vincenzo Pellegrino

Francesco Cuoccio

Emanuele Cassibba

Melis Loses His Short Stack Posted Monday 25th April, 2022 at 13:45(UTC+2) by Jason Glatzer

Liam Melis got the last of his 90,000 chips in and was up against Anthony Gardner and Noam Garama.

Gardner and Garama both checked the flop and did the same on the turn. Gardner checked again on the river before Garama bet 65,000. Gardner quickly folded and the cards were turned over.

Melis with was good until the river after the flop paired his queen. However, he was still out of chips with Garama improving to a better pair with for a rivered top pair. 

Also heading to the rail recently were Flaviano Cammisuli, Alsseandro Cannizzaro, Federico Luciano, Poor Yzhak, Dehlia De Jong, and Giuseppe Comitini.

Player		Chips	Progress
Noam Garama		2,400,000	400,000
Anthony Gardner		1,800,000	200,000
Giuseppe Comitini		290,000	0
Liam Melis		0	0
Flaviano Cammisuli		0	0
Alessandro Cannizzaro		0	0
Federico Luciano		0	0
Poor Yzhak		0	0
Dehlia De Jong		0	0
Giuseppe Comitini		0	0

More Faces Posted Monday 25th April, 2022 at 13:36(UTC+2) by Juhani Tyriseva

Ugo Gasparini

Steven van Zadelhoff

Keimo Suominen

Gabriele Cappiello.

First Faces Posted Monday 25th April, 2022 at 13:22(UTC+2) by Juhani Tyriseva

Stefano Titola

Josef Gulas

Eros Nastasi

Alexandros Dranovitsas

Gasparini Ousts Glansberg Posted Monday 25th April, 2022 at 13:19(UTC+2) by Jason Glatzer

Ugo Gasparini opened for 75,000 from the cutoff. Michael Glansberg three-bet jammed his short stack from the small blind and Gasparini called.

Michael Glansberg:

Ugo Gasparini:

Gasparini was ahead and things got worse for Glansberg after the flop gave his opponent a set. Glansberg hit the rail after the turn and river completed the board.

A few other players hit the rail in the opening moments of Day 3 including Giovanni Grella, Ben Aluf, Demosthenous Demos, and Liad Himelfarb.

Player		Chips	Progress
Giovanni Grella		0	0
Demos Demosthenous		0	0
Liad Himelfarb		0	0
Ben Aluf		0	0
Giovanni Grella		0	0

The Action Begins! Posted Monday 25th April, 2022 at 13:09(UTC+2) by Jason Glatzer

The Day 3 players have unbagged their chips and are ready for action.

Day 3 Seat Draw Posted Monday 25th April, 2022 at 11:51(UTC+2) by Jason Glatzer

Table	Seat	Player	Chips	Big Blinds
1	1	Flaviano  Cammisuli	1,475,000	49
1	2	Demos Demosthenous	495,000	17
1	3	Kevin Malone	790,000	26
1	4	Paolo  Pinazzo	730,000	24
1	5	Michele  Biggi	1,445,000	48
1	6	Kristaps  Zarans	465,000	16
1	7	Antonio  Merone	665,000	22
1	8	Karol  Szyszko	450,000	15
1	9	Francesco  Cuoccio	1,020,000	34
2	1	Gagliolo Salva'	950,000	32
2	2	Roberto Pinna	1,405,000	47
2	3	Vincenzo  Maffei	950,000	32
2	5	Poor Yzhak	360,000	12
2	6	Antonio  Russo	780,000	26
2	7	Luka Sorainen	1,075,000	36
2	8	Yossef  Cohen	2,000,000	67
2	9	Jeremy Sereau	575,000	19
3	1	Danel  Vaitzman	925,000	31
3	2	Noam Garama	2,000,000	67
3	3	Felicano Montalbetti	470,000	16
3	4	Liam  Melis	620,000	21
3	5	Giuseppe  Rosa	685,000	23
3	6	Mohamed Bouzgarrou	695,000	23
3	8	Anthony Gardner	2,000,000	67
3	9	Marco Cosic	3,000,000	100
4	1	Dehlia De Jong	220,000	7
4	2	Valerio Mascolo	385,000	13
4	3	Ben  Aluf	660,000	22
4	4	Giovanni  Anello	435,000	15
4	5	Dario  Comitini	965,000	32
4	6	Stephane Roux	375,000	13
4	8	Stan Van Dijk	1,885,000	63
4	9	Alessandra Cuntro	625,000	21
5	2	Federico Petruzzelli	2,545,000	85
5	3	Jan Johansen	250,000	8
5	4	Mancinelli Edoardo	695,000	23
5	5	Angelo  Patane'	1,105,000	37
5	6	Mariano  D'aquila	955,000	32
5	7	Alessandro Cannizzaro	380,000	13
5	8	Michael  Koran	1,440,000	48
5	9	Diego  Grisiglione	3,095,000	103
6	1	Thierry Cwchowsi	915,000	31
6	2	Elhanan Torgeman	990,000	33
6	3	Peep Kivistik	1,195,000	40
6	4	Giovanni Grella	205,000	7
6	5	Samuel Biland	1,765,000	59
6	6	Giuseppe Comitini	290,000	10
6	7	Pawel Fraczek	1,450,000	48
6	9	Cory Desmond	2,495,000	83
7	1	Steven van Zadelhoff	1,100,000	37
7	2	Emanuele  Cassibba	570,000	19
7	3	Liad  Himelfarb	485,000	16
7	4	Vincenzo  Pellegrino	500,000	17
7	6	Valter Marchi	1,005,000	34
7	7	Christian Pedersen	1,000,000	33
7	8	Federico Luciano	480,000	16
7	9	Giorgi De Massimo	350,000	12
8	1	Michel Glansberg	90,000	3
8	2	Josef Gulas	1,250,000	42
8	3	Eros Nastasi	2,285,000	76
8	5	Stefano  Titola	860,000	29
8	6	Alexandros  Dranovitsas	710,000	24
8	7	Keimo Suominen	480,000	16
8	8	Ugo Gasparini	765,000	26
8	9	Candido Cappiello	1,640,000	55

11:50 (UTC+2)

Day 3 of Battle of Malta 2022 Started
Level: 24     Blinds: 15,000/30,000     Ante: 30,000

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

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter