0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0068 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-24'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/1/5/updates'
ORDER BY `views` DESC

0.0175 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/1/5/updates', 1, '2025-04-24')

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

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

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

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

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

0.0285 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0179 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '7'
AND `published` = 1

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

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

0.0561 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0108 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '11'
AND `published` = 1

0.0547 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0064 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '12'
AND `published` = 1

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

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

0.0112 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '276'
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` = '275'
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` = '274'
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` = '273'
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` = '272'
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` = '271'
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` = '270'
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` = '269'
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` = '268'
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` = '267'
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` = '266'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0171 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '256'
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` = '255'
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` = '254'
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` = '253'
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` = '251'
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` = '252'
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` = '250'
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` = '249'
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` = '247'
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` = '248'
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` = '246'
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` = '244'
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` = '245'
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` = '243'
ORDER BY `chip_change` DESC, `busted` ASC

0.0172 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '242'
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` = '241'
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` = '240'
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` = '239'
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` = '238'
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` = '237'
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` = '236'
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` = '235'
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` = '234'
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` = '233'
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` = '232'
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` = '231'
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` = '230'
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` = '229'
ORDER BY `chip_change` DESC, `busted` ASC

0.0170 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '228'
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` = '227'
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` = '226'
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` = '225'
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` = '224'
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` = '223'
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` = '222'
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` = '221'
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` = '220'
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` = '219'
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` = '218'
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` = '217'
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` = '216'
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` = '214'
ORDER BY `chip_change` DESC, `busted` ASC

0.0171 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '215'
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` = '213'
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` = '212'
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` = '211'
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` = '210'
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` = '209'
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` = '208'
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` = '206'
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` = '207'
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` = '203'
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` = '199'
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` = '198'
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` = '196'
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` = '194'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0089 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '191'
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` = '190'
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` = '192'
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` = '189'
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` = '188'
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` = '187'
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` = '186'
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` = '185'
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` = '184'
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` = '183'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '276'
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` = '275'
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` = '274'
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` = '273'
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` = '272'
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` = '271'
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` = '270'
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` = '269'
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` = '268'
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` = '267'
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` = '266'
ORDER BY `chip_change` DESC, `busted` ASC

0.0275 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '265'
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` = '264'
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` = '263'
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` = '262'
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` = '261'
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` = '260'
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` = '259'
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` = '258'
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` = '257'
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` = '256'
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` = '255'
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` = '254'
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` = '253'
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` = '251'
ORDER BY `chip_change` DESC, `busted` ASC

0.0170 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '252'
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` = '250'
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` = '249'
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` = '247'
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` = '248'
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` = '246'
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` = '244'
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` = '245'
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` = '243'
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` = '242'
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` = '241'
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` = '240'
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` = '239'
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` = '238'
ORDER BY `chip_change` DESC, `busted` ASC

0.0167 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '237'
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` = '236'
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` = '235'
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` = '234'
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` = '233'
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` = '232'
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` = '231'
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` = '230'
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` = '229'
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` = '228'
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` = '227'
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` = '226'
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` = '225'
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` = '224'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0082 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '220'
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` = '219'
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` = '218'
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` = '217'
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` = '216'
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` = '214'
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` = '215'
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` = '213'
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` = '212'
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` = '211'
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` = '210'
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` = '209'
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` = '208'
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` = '206'
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` = '207'
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` = '203'
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` = '199'
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` = '198'
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` = '196'
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` = '194'
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` = '195'
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` = '193'
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` = '191'
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` = '190'
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` = '192'
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` = '189'
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` = '188'
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` = '187'
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` = '186'
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` = '185'
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` = '184'
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` = '183'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

    

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

Translate

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

Battle of Malta 2019 Main Event Live Reporting - Day 4

Current Level 37 Current Day 4

---

Blinds 400,000/800,000 Ante 800,000

Entries 4,657 Remaining 1

---

Prize Pool (EUR) €2,258,645 First Prize (EUR) €306,205

Chip Leaders Day 4

1

Serghei Lisii

116,000,000

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

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Live Updates - Day 1C

13:06 (UTC+2)

Day 1C of Battle of Malta 2019 Ended
Level: 16     Blinds: 3000/6000     Ante: 6000

888poker Ambassador Lovgren Through to Battle of Malta Day 2; €1m Guarantee Broken Posted Saturday 19th October, 2019 at 11:11(UTC+2) by Chris Martin

SofiaJPG07997.jpg

With 333 entries on Day 1a, 585 entries on Day 1b, and 1,353 entries on Day 1c, this year's Battle of Malta Main Event is already up to a total of 2,271 entrants.

Today 203 players joined the 138 who advanced to Day 2 from Day 1a & 1b after a long day's play, securing themselves a place in the money. 

Danny Toffel, Colin Guthrie, Fraser MacIntyre, Jamie Nixon, Andy Hills, Daniel Samson and last year's champion Julien Stropoli all took part but were unable to progress. The current chip leader – and chip leader overall – is Italian Dario Marinelli on 608,000.

One of the players advancing is 888poker Ambassador Sofia Lovgren who jumped into the field midway through the day and ran up a stack of 80,000 from her 25,000 starting stack.

Joining the Swede for Day 2 are Jimmy Kebe (147,000), Chris Da Silva (117,000) and Steven van Zadelhoff (280,000) along with presumed chip leader Dario Marinelli (608,000) and fellow big stack Aidan Hynes (555,000).

Unfortunately, fan favourite John Hesp failed to make it through to Day 2. He was the penultimate bust out in the day and will have to try again to make it through to Day 2.

For players not advancing, they still have Days 1d, and the Turbo Day 1e flight to advance. Tomorrow sees Day 1d kick off at 1 pm with Day 1e Turbo starting at 9 pm with ten minute blind levels.

Be sure to stay tuned to the live updates as we bring you all the coverage from the Intercontinental Hotel and Casino Malta here at the Battle of Malta.

Savio Eliminated Short of the Money Posted Saturday 19th October, 2019 at 01:55(UTC+2) by Chris Martin

Damir Savio was all in for around 55,000 with but it wasn't looking good against the of Gabriele Re.

There was a king on the flop moving Re even further ahead. Savio was dead on the turn and the river sent them to the rail.

Player		Chips	Progress
Gabriele Re		445,000	45,000
Damir Savio		0	75,000

Brennan Doubles Through Hesp Posted Saturday 19th October, 2019 at 01:51(UTC+2) by Chris Martin

Keith Brennan was all in for 99,500 with against John Hesp who held

There was no help for Hesp who wanted to eliminate Brenan as the board came and Brennan doubled up.

Player		Chips	Progress
Mr Keith Brennan		200,000	175,000
John Graham Hesp		35,000	90,000

01:49 (UTC+2)

Start of Level 16
Blinds: 3000/6000     Ante: 6000

Hand-for-Hand Posted Saturday 19th October, 2019 at 01:40(UTC+2) by Chris Martin

The tournament clock shows 206 players remaining and the tournament is now hand-for-hand with 203 players making Day 2.

A reminder that you must make Day 2 to make the money.

Updated Chip Counts Posted Saturday 19th October, 2019 at 01:35(UTC+2) by Chris Martin

Player		Chips	Progress
Aidan Paul Hynes		580,000	20,000
Patrick Pahr Solberg		320,000	65,000
Steven van Zadelhoff		300,000	0
Chris Ayojide Da-Silva 26 Oduntan		210,000	185,000
Jimmy Boubou Kebe		165,000	140,000
John Graham Hesp		125,000	100,000
Sofia Lovgren		90,000	30,000

Hynes Crushing Posted Saturday 19th October, 2019 at 01:18(UTC+2) by Chris Martin

With the end of the night in sight, Aidan Hynes is sitting on close to 600,000 chips. The tournament clock shows 225 players remaining with just 203 players bagging up in the money ahead of Day 2.

Day 1a chip leader Shane Dempsey bagged 390,000 and yesterday's Day 1b chip leader Niko Pakalen bagged 571,000. Hynes is on course to exceed that if he continues the trend over the last few minutes.

Player		Chips	Progress
Aidan Paul Hynes		560,000	145,000

Solberg Loses Some After Amendola Double Posted Saturday 19th October, 2019 at 01:13(UTC+2) by Chris Martin

Patrick Solberg limped in the small blind and called a shove from Alfonso Amendola in the big blind for Amendola's last 35,000.

Patrick Solberg:
Alfonso Amendola:

The board ran out and fours held to allow Amendola to double through Solberg.

Player		Chips	Progress
Patrick Pahr Solberg		385,000	100,000
Alfonso Amendola		70,000	45,000

00:59 (UTC+2)

Start of Level 15
Blinds: 2500/5000     Ante: 5000

Dady 1c Recap Video Posted Saturday 19th October, 2019 at 00:49(UTC+2) by Chris Martin

We hit the €1 million guarantee early in the day and now up to 1,353 for Day 1c of the Battle of Malta Main Event. Day 1d at 1pm tomorrow (October 19,) with a Turbo 1e at 9pm

Aces No Good for D'Aparo Posted Saturday 19th October, 2019 at 00:47(UTC+2) by Chris Martin

Action was on a flop of . Shaun De Cesare and Enrico Grella checked out of the blinds and Filippo D'Aparo continued for 17,000.

De Cesare called and Grella check-raised to 50,000. D'Aparo then moved all in for 650,00.

De Cesare tanked and flat-called, but then snap-called a snapshove from Grella.

Both De Cesare and Grella had flopped the nut straight, devastating D'Aparo who held .

The board bricked and a visibly frustrated D'Aparo was eliminated.

Player		Chips	Progress
Shaun De Cesare		165,000	130,000
Enrico Grella		150,000	25,000
Filippo D'Aparo		0	0

Chips for Pahr After River Call Posted Saturday 19th October, 2019 at 00:44(UTC+2) by Chris Martin

On a flop Patrick Solberg bet 7,000 and Hysaj Eljano called. The turn was the and Solberg check-called 22,500 from Eljano.

The river was the . Solberg checked again and Eljano bet 42,500. Solberg tank-called.

Eljano showed for a missed straight draw, with Solberg winning the pot with

Player		Chips	Progress
Patrick Pahr Solberg		485,000	85,000
Hysaj Eljano		110,000	45,000

00:16 (UTC+2)

Start of Level 14
Blinds: 2000/4000     Ante: 4000

Hats Off to Coppola; Doubles to Stay Alive Posted Saturday 19th October, 2019 at 00:16(UTC+2) by Chris Martin

Serghei Lisii moved all in for 45,000 from middle position. Manuel Coppola was on the button and moved all in for 35,000. The blinds folded.

Coppola was behind with against Lisii's

The flop came and Coppola completed his gutshot on the turn to leave Lissi short as the river came the

Player		Chips	Progress
Manuel Coppola		70,000	45,000
Serghei Lisiii		10,000	15,000

Eichenberg Eliminated from BOM Main Event Posted Saturday 19th October, 2019 at 00:12(UTC+2) by Chris Martin

Knut Alexander Mo moved all in for around 50,000 from middle position. It folded around to Mario Eichenberg in the small blind who shoved all in for 30,000. The big blind folded and the cards were turned over.

Mario Eichenberg:
Knut Alexander Mo:

There was no help for Eichenberg on the board and he was sent to the rail.

Player		Chips	Progress
Knut Alexander Mo		85,000	60,000
Mario Eichenberg		0	0

Laura chats with Finnish poker legend Patrik Antonius Posted Saturday 19th October, 2019 at 00:04(UTC+2) by Chris Martin

Finnish poker legend Patrik Antonius, one of the biggest winners in online poker history, is here at Battle of Malta to host the Patrik Antonius Poker Challenge Pop-up Cup, sponsored by First Land of Poker (FLOP). Antonius, who has won nearly $12 million live and many more millions online, is Ambassador for FLOP, a special new social media app created exclusively for poker players.

Updated Chip Counts Posted Friday 18th October, 2019 at 23:59(UTC+2) by Chris Martin

Player		Chips	Progress
Stefan Petrov		450,000	200,000
Aidan Paul Hynes		415,000	175,000
Patrick Pahr Solberg		400,000	100,000
Abraham Benitez Faraj		370,000	205,000
Jonas Gunnar Broden		360,000	335,000
Namir Reda Dfaili		300,000	200,000
Matias Hautakangas		292,000	237,000
Borislav Tonev Shishkov		285,000	260,000
Daniel Mark Clifford		265,000	240,000
Michele Mercurio		235,000	210,000
David Kolaric		230,000	205,000
Tomi Kochev		210,000	185,000
Ronny Gresmo		210,000	135,000
Gazis Savvas		180,000	155,000
Alessandro De Michele		170,000	145,000

Plan for the Evening Posted Friday 18th October, 2019 at 23:50(UTC+2) by Chris Martin

With 1,353 players entering Day 1c of the Battle of Malta Main Event today, the tournament like other Day 1 flights is scheduled to play down to 15%

That means that the tournament will bag up when 203 players remain. The tournament clock shows 311 remaining, and judging by previous flights, the bubble is expect to burst at some point in Level 15.

23:41 (UTC+2)

Start of Level 13
Blinds: 1500/3000     Ante: 3000

Break Posted Friday 18th October, 2019 at 23:15(UTC+2) by Gia Carnestorm

The players are now on a 20-minute break. 

Download the Battle of Malta App Posted Friday 18th October, 2019 at 23:05(UTC+2) by Chris Martin

Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting the website below:

 bom.beezer.com 

Marinelli Survives Posted Friday 18th October, 2019 at 23:02(UTC+2) by Gia Carnestorm

Mansouri Amir Houssein raised to 6,500 from middle position, and Duarte Hugo Filipe Marques called from the next seat. The player on the button also called before Dario Marinelli raised to 42,500 from the big blind. 

Houssein folded, and Marques moved all in for 55,000. 

The button folded, and Marinelli put the rest of his stack in the middle and was at risk. 

Marques:

Marinelli:

Board:

Marinelli hit a four on the flop to take the lead and held to secure an unlikely double. 

Marinelli moved up to 120,000, and Marques was left with just 2,500. 

Player		Chips	Progress
Dario Marinelli		120,000	60,000
Hugo Filipe Marques Duarte		2,500	22,500

Card Protectors in the Battle of Malta Main Event Posted Friday 18th October, 2019 at 22:54(UTC+2) by Chris Martin

Dragos Wins Apple Airpods; iPhone 11 Still Up for Grabs Posted Friday 18th October, 2019 at 22:45(UTC+2) by Chris Martin

Romanian player Constantin Negrii Dragos has become the first lucky player to grab himself a special prize courtesy of the Battle of Malta. He won himself a pair of Apple Airpods after rivering a full hosue with pocket eights earlier this afternoon.

The main prize this year in 888poker's promotion is still up for grabs. All 888poker players are automatically eligible for a brand new iPhone 11.

All players have to do is to make a Royal Flush in Spades holding two spades in your hand!

We look forward to someone being the lucky winner later in the festival!

22:44 (UTC+2)

Start of Level 12
Blinds: 1000/2500     Ante: 2500

Gresmo Spikes a Jack to Double Posted Friday 18th October, 2019 at 22:43(UTC+2) by Gia Carnestorm

Ronny Gresmo was all in for 36,000, and Patrick Pahr Solberg called 

Gresmo:

Solberg:

Board:

Gresmo was dominated but found a jack on the flop to take the lead. The turn and river cards improved his holding to a full house, and he survived in unlikely circumstances. 

Player		Chips	Progress
Patrick Pahr Solberg		300,000	95,000
Ronny Gresmo		75,000	50,000

Lucky River for Raz Posted Friday 18th October, 2019 at 22:22(UTC+2) by Chris Martin

Action was on a board and Idan Raz was facing a shove from an opponent for 82,900. Raz took his time before calling with for a pair of tens. 

His opponent held for top pair. However, the river brought another improving Raz to trip tens and he sent his opponent to the rail.

Player		Chips	Progress
Idan Raz		280,000	70,000

Petrov into the Chip Lead Posted Friday 18th October, 2019 at 22:14(UTC+2) by Chris Martin

After eliminating Vladyslav Lidovskyi with pocket tens against ace-king, Stefan Petrov has now chipped up to 360,000 and appears to be the chip leader in the Battle of Malta Main Event.

Here are some other big stacks:

Player		Chips	Progress
Stefan Petrov		360,000	110,000
Salvatore Amitrano		240,000	120,000
Nicolas Bruno Courbin 1		220,000	105,000
Harry M Haan		205,000	180,000

22:11 (UTC+2)

Start of Level 11
Blinds: 1000/2000     Ante: 2000

Flush for Savio Posted Friday 18th October, 2019 at 22:05(UTC+2) by Gia Carnestorm

The flop fell , and with 14,000 in the middle, Dario Marinelli bet 4,700 from the button. 

The small blind player folded before Damir Savio called in the big blind, as did Kyriakos Papadopoulos from the hijack. 

All three players checked on the turn before the action checked through again on the river. 

Savio revealed for the flush and took down the pot, and both his opponents mucked. 

Player		Chips	Progress
Damir Savio		75,000	50,000
Dario Marinelli		60,000	0
Kyriakos Papadopoulos		27,000	0

Cangianielo Busts to Pino Posted Friday 18th October, 2019 at 21:53(UTC+2) by Chris Martin

Danilo Cangianiello open-shoved for around 30,000 with and Dominico Pino re-raised in late position with . The remaining players all folded.

The board ran out with Cangianiello sent to the rail shortly after play resumed.

Player		Chips	Progress
Domenico Pino		100,000	75,000
Danilo Cangianiello		0	0

Hautakangas Doubles Posted Friday 18th October, 2019 at 21:53(UTC+2) by Gia Carnestorm

Adrian Van Bruggen raised from middle position and called after Matias Hautakangas moved all in for 25,000. 

Van Bruggen:

Hautakangas:

Board:

Hautakangas hit top pair on the flop and held after the board completed to seal the double up. 

Player		Chips	Progress
Rick Adriaan Van Bruggen		11,000	14,000

Battle of Malta Day 1c Posted Friday 18th October, 2019 at 21:32(UTC+2) by Chris Martin

21:30 (UTC+2)

Start of Level 10
Blinds: 800/1600     Ante: 1600

Dinner Break Posted Friday 18th October, 2019 at 20:03(UTC+2) by Chris Martin

Players are going on their 75-minute dinner break with the tournament clock displaying 560 of 1,344 players remaining.

Registration and re-entry will remain open for one more level after players return at approximately 21:15 local time.

Sheils Take it on the Turn Posted Friday 18th October, 2019 at 20:01(UTC+2) by Gia Carnestorm

Brandon Sheils raised to 2,700 from middle position, and Gianluca Fichera, Marius Constantin, and Einar Johansen called. 

The flop fell , and both Constantin and Johansen called Sheils' 4,000 bet. 

The hit on the turn, and the action again checked to Sheils. The Brit continued for 14,000 and took down the pot after both opponents folded. 

Player		Chips	Progress
Jan Einar Johansen		92,000	67,000
Brandon Michael Sheils		75,000	50,000
Marius-Constantin Hutupasu		19,000	6,000

Checking in on the Big Stacks Posted Friday 18th October, 2019 at 19:59(UTC+2) by Chris Martin

Player		Chips	Progress
Aidan Paul Hynes		240,000	215,000
Idan Raz		210,000	65,000
Patrick Pahr Solberg		205,000	180,000
Marko Keskel		185,000	160,000
Adrian Strobel		175,000	25,000
Abraham Benitez Faraj		165,000	140,000
Luigi Percossi		155,000	130,000
Sofia Lovgren		120,000	74,000

De Cesare Shows King High Posted Friday 18th October, 2019 at 19:44(UTC+2) by Gia Carnestorm

Mats Elofsson bet 5,500 with the flop down , and Shaun De Cesare moved all in for 19,000. 

"I have a very good hand," said De Cesare to Elofsson as he contemplated his next move. 

Elofsson thought for a minute with De Cesare stood from his chair. 

A few more seconds passed, and Elofsson folded. 

De Cesare was reminded by his fellow players that he had promised to show his next hand and obliged by flipping over . 

Player		Chips	Progress
Mats Elofsson		60,000	35,000
Shaun De Cesare		35,000	0

19:27 (UTC+2)

Start of Level 9
Blinds: 600/1200     Ante: 1200

Runner-Runner Flush for Petrov Eliminates Calabro Posted Friday 18th October, 2019 at 19:27(UTC+2) by Gia Carnestorm

The flop fell , and with 25,000 in the middle, Stefan Petrov shoved for 200,000 from middle position. 

Francesco Coppola folded, and Antonino Calabro went into the tank from the button.

Calabro thought for nearly two minutes with 22,000 behind but called. 

Petrov flipped over for a gutshot straight draw, and Calabro was ahead with . 

The turn gave Petrov the flush draw, and when the appeared on the river, a shocked Calabro was eliminated. 

Player		Chips	Progress
Stefan Petrov		250,000	225,000
Antonino Calabro'		0	25,000

Change to Schedule Posted Friday 18th October, 2019 at 19:20(UTC+2) by Chris Martin

Due to capacity issues, tomorrow's Event 21 - €2225 Short Deck 6-Max has been cancelled (6pm, Friday 19th October).

Meanwhile, alternates for tonight's Event 16 - €220 Bounty for the Night are being seated from Registration Desk 6.

Ludo In and Out Posted Friday 18th October, 2019 at 19:14(UTC+2) by Gia Carnestorm

Ludovic Geilich has had an event Day 1c so far. The Scotsman joined the action midday way through the early levels, but after surviving just 90 minutes on his first bullet. 

After a brief appearance on the feature table, Geilich is back in the Battle of Malta Main Event on Day 1c in a bid to make the money spots and a place in Day 2. 

It’s Kings of Tallinn time in Malta! Posted Friday 18th October, 2019 at 19:09(UTC+2) by Gia Carnestorm

It’s Kings of Tallinn time in Malta!

Kings of Tallinn, dubbed “the largest poker festival in the North”, is running a great promotion at Battle of Malta to win a €2,000 package to next February’s festival. Visit the Kings of Tallinn stand in the Eden Arena and just fill out the flyer to enter the draw: the main raffle prize includes €1,100 Main Event ticket, €350 for travel expenses, and four nights’ accommodation for two at the luxury Hilton Tallinn Park Hotel! 

 Kings of Tallinn is also running some fun challenges and games at Battle of Malta, offering players the chance to win a €330 side event ticket!  Today – guess how many Battle of Malta Main Event entries we’ll have; tomorrow - pick a winner in classic flips of AK vs. QQ; Sunday - Estonian Twist. 

 Kings of Tallinn takes places in the fabulous Olympic Park Casino at the Hilton Tallinn Park Hotel from 17-23 February 2020. Italian Raffaele Cecere won Wednesday’s €200 Road to Kings of Tallinn tournament, snagging a €1,650 package along with this €5,850 cash prize. The winner for the €2k package will be drawn after Battle of Malta ends and announced via email and social media.

18:39 (UTC+2)

Start of Level 8
Blinds: 500/1000     Ante: 1000

Download the Battle of Malta App Posted Friday 18th October, 2019 at 18:39(UTC+2) by Chris Martin

Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting bom.beezer.com 

Gilboa Eliminated from Day 1c Posted Friday 18th October, 2019 at 18:36(UTC+2) by Chris Martin

"You would not believe the luck," said a smiling Uri Gilboa as he exited the tournament area. Gilboa fired twice without success today but said that he will be back tomorrow.

Tomorrow offers players their last two chances to book places in Day 2. Day 1d starts at 1p.m. with the special Turbo Day 1e getting underway at 9 p.m.

Player		Chips	Progress
Uri Gilboa		0	0

Strobel Wins Three-Way All In Posted Friday 18th October, 2019 at 18:32(UTC+2) by Gia Carnestorm

Matos Gonzalez, Marius Morel, and Adrian Strobel were all in preflop with Strobel covering both opponents. 

Gonzalez:

Morel:

Strobel:

Board:

Strobel held his lead on the flop, although Morel's outs improved with the nut flush draw. 

However, the turn and river cards brought no surprises, and Strobel scored a double elimination. 

Player		Chips	Progress
Adrian Strobel		200,000	110,000

Spadola vs. Clark Posted Friday 18th October, 2019 at 18:19(UTC+2) by Gia Carnestorm

Alex Clark bet from middle position after the flop fell , and Salvatore Spadola called from the cutoff.

Clark continued for 5,300 on the turn, and Spadola called to see the river card. 

Clark slowed down and checked, which signaled a 13,000 bet from Spadola. 

Clark instantly folded, and Spadola moved up to 85,000. 

Player		Chips	Progress
Salvatore Spadola		85,000	60,000
Alex Clark		15,000	10,000

Updated Big Stacks Posted Friday 18th October, 2019 at 18:18(UTC+2) by Chris Martin

Player		Chips	Progress
Ilan Norhian		158,000	133,000
Ronan John Sweeney		155,000	130,000
Idan Raz		145,000	5,000
Nandor Laszlo Fejes		140,000	115,000
Krzysztof Jacyk		130,000	105,000
Martin Ivanov Georgiev		127,000	102,000
Salvatore Amitrano		120,000	95,000
Johan Christer Raamot		117,000	92,000
Nicolas Bruno Courbin 1		115,000	90,000
Michele Fatini		115,000	90,000

Presenting the PAPC Pop-Up Cup Posted Friday 18th October, 2019 at 17:57(UTC+2) by Gia Carnestorm

Patrik Antonius in the house – hosting PAPC Pop-Up Cup Finnish poker legend Antonius, one of the biggest winners in online poker history, is hosting this afternoon’s €300 buy-in Patrik Antonius Poker Challenge Pop-up Cup, sponsored by First Land of Poker (FLOP).  

Antonius, who has won nearly $12 million live and many more millions online, is Ambassador for FLOP, a unique new social media app created exclusively for poker players.  

FLOP, which is free and available on both IOS and Android, launched in March and already has thousands of members. Players can engage and share their passion for the game as well as get real-time information on poker rooms, cash games, and events.

The PAPC tournament in Malta follows the highly successful debut for the Patrick Antonius Poker Challenge in Tallinn in April, which broke Estonian records for cash games and tournaments.

17:52 (UTC+2)

Start of Level 7
Blinds: 400/800     Ante: 800

Break Posted Friday 18th October, 2019 at 17:45(UTC+2) by Chris Martin

Players are going on their second 20-minute break of the day. When they return they will play three more levels before a 75-minute dinner break.

Gravlien Doubles Posted Friday 18th October, 2019 at 17:44(UTC+2) by Gia Carnestorm

Ruben Gravlien was all in with , and Lappas Charalampos had called with . 

The board was already down , and Gravlien secured the double up. 

Player		Chips	Progress
Bjoern Ruben Gravlien		39,000	14,000
Charalampos Lappas		20,000	5,000

Raz Among Chip Leaders Posted Friday 18th October, 2019 at 17:23(UTC+2) by Chris Martin

Idan Raz is sitting pretty on a stack of 150,000 in Level 6 of Day 1c in the 2019 Battle of Malta Main Event.

Raz has three live cashes, two of which have come on the island of Malta, and will be hoping to use the momentum and the big stack he's built up so far to make it into the money later today.

Player		Chips	Progress
Idan Raz		150,000	0

Flopped House vs. Trips Posted Friday 18th October, 2019 at 17:17(UTC+2) by Gia Carnestorm

The flop fell , and Angelo Basile bet 2,100 from early position. 

Nikolaos Karfakis called from the hijack before Olivieri Achille raised to 6,200. 

Baile thought for a minute before he folded, and Karfakis moved all in, which Achille called. 

Karfakis revealed for a full house and Achille held for trips. 

The turn and river were no help to Achille, and Karfakis doubled. 

Player		Chips	Progress
Achille Jacopo Olivieri		61,000	1,000
Nikolaos Karfakis		40,000	15,000
Angelo Basile		19,000	6,000

17:03 (UTC+2)

Start of Level 6
Blinds: 300/600     Ante: 600

Aces Help Alberski Double Posted Friday 18th October, 2019 at 16:49(UTC+2) by Gia Carnestorm

Prezemuslaw Alberski got all his chips into the middle preflop against Valery Yantsevich and saw he was ahead. 

Alberski:

Yantsevich:

Board:

Top set for Alberski improved his lead, and his double-up was confirmed after the turn card fell. 

Player		Chips	Progress
Prezemuslaw Alberski		55,000	60,000
Valery Yantsevich		45,000	20,000

Perez Busts to Korhonen Posted Friday 18th October, 2019 at 16:42(UTC+2) by Chris Martin

Hector Correa Perez opened and Niko Korhonen three-bet to 5,500 from the big blind. Perez called.

Korhonen bet 6,000 on the flop and Perez called. Korhonen continued on the turn for 10,000 and Perez called again.

The river was the and Korhonen bet enough to put Perez all in. The Spaniard tanked before calling, and was shown from his opponent.

Perez mucked but was forced to show and he was eliminated.

Player		Chips	Progress
Niko Korhonen		95,000	70,000
Hector Correa Perez		0	0

Pink October Malta Posted Friday 18th October, 2019 at 16:37(UTC+2) by Gia Carnestorm

A whole bunch of top-flight female poker players are here in the Eden Arena competing on Battle of Malta Day 1c.

Betsson Poker Ambassador Daiva Byrne is sporting a pink t-shirt to mark Pink October Day today. Daiva is the founder of Fantastic Ladies in Poker, one of the biggest and fastest-growing online communities for women poker players. She launched the initiative three years ago, and it already has over 3,000 members.

888poker Ambassador Sofia Lovgren is also playing today along with well-known Jamila von Perger, currently the top three female live tournament players in Germany.

Battle of Malta is aiming to raise thousands for Pink October Malta with an amazing raffle during the event. Some incredible prizes are up for grabs, including two BOM 2020 seats and packages for Grosvenor’s Goliath 2020, 888Live London, the MPN Poker Tour, the World Casino Championships, the V-Poker Challenge or the Kings of Tallinn. Raffle tickets are on sale throughout the event.

Anastasakis Misses His Draw to Bust Posted Friday 18th October, 2019 at 16:33(UTC+2) by Chris Martin

On a board, Dimitrios Anastasakis checked to Carlos Martinez Casero who bet 2,500 into a pot of around 6,000.

Anastasakis then check-raised all in for 11,800 and after a tank, Casero called.

Dimitrios Anastasakis:
Carlos Martinez Casero:

It was a straight draw against top pair, and Anastasakis needed to improve. The turn and river wasn't what he needed and the Greek player was eliminated.

Player		Chips	Progress
Carlos Martinez Casero		65,000	40,000
Dimitrios Anastasakis		0	0

House for Bitman Posted Friday 18th October, 2019 at 16:31(UTC+2) by Gia Carnestorm

The flop fell , and with 10k in the middle, three players checked. 

The peeled off on the turn, and Vik Tore bet 6,000. One player folded, and Din Bitman called. 

Bitman checked on the river and Tore bet 10,000. 

Bitman raised to 35,000, and Tore put the last of his stack into the middle. Bitman revealed for a full house. 

Tore mucked for a straight and departed from the table. 

Player		Chips	Progress
Din Bitman		75,000	50,000
Vik Tore		0	0

16:30 (UTC+2)

Start of Level 5
Blinds: 200/500     Ante: 500

Big Stacks Emerging Posted Friday 18th October, 2019 at 16:10(UTC+2) by Chris Martin

Player		Chips	Progress
Mario Eichenberg		105,000	80,000
Giacomo Nunziati		95,000	70,000
Adrian Strobel		90,000	65,000
Orhan Manashirov		85,000	60,000
Alan Ross Gilmore		80,000	55,000

Laura Cornelius Chats to John Hesp at BOM Posted Friday 18th October, 2019 at 16:02(UTC+2) by Gia Carnestorm

 

Kings Hold for Quintero Posted Friday 18th October, 2019 at 16:00(UTC+2) by Chris Martin

Oscar Quintero was all in holding against the of Dani Abi Rashed.

Quintero was in control and he avoided a banana skin on the runout to double to almost double starting stack, with Rashed slipping to 15,000. 

Player		Chips	Progress
Oscar Chica Quintero		46,000	21,000
Dani Abi Rashed		15,000	10,000

Mirakov Doubles Posted Friday 18th October, 2019 at 15:59(UTC+2) by Gia Carnestorm

The flop fell , and Ronen Mirakov's all in for 11,000 was called by Vasileos Kaparakis. 

Mirakov held and was behind against . 

The on the turn gave Kaparakis two pair, but also Mirakov the flush draw. 

When the appeared on the river, Mirakov improved to his much-needed flush and won the pot to survive. 

Player		Chips	Progress
Ronen Mirakov		30,000	5,000

Download the Battle of Malta App! Posted Friday 18th October, 2019 at 15:41(UTC+2) by Chris Martin

Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting bom.beezer.com 

15:40 (UTC+2)

Start of Level 4
Blinds: 200/400     Ante: 400

Break Posted Friday 18th October, 2019 at 15:24(UTC+2) by Gia Carnestorm

The players are on a 20-minute break. 

Arizon Gets it in Bad Posted Friday 18th October, 2019 at 15:23(UTC+2) by Chris Martin

On a board, Assi Levi checked and Christopher Pierpoint bet 3,700. Din Arizon called before Levi check-raised all in for around 20,000.

Levi folded and Pierpoint tank-called for his last 17,000.

Assi Levi:
Din Arizon:

Player		Chips	Progress
Mr Assi Levi		55,000	30,000
Christopher Pierpoint		15,000	10,000
Din Arizon		0	25,000

Hills Climbs Posted Friday 18th October, 2019 at 15:21(UTC+2) by Gia Carnestorm

Prezemuslaw Alberski raised from the button, and Andy Hills defended his big blind. The flop fell and both players checked before the appeared on the turn. 

Hills check-called a 1,100 bet from Alberski, then check-called a 2,500 bet on the river. 

Alberski immediately mucked, and Hills won the pot without a showdown. 

Player		Chips	Progress
Andrew Christopher Hills		45,000	20,000
Prezemuslaw Alberski		10,000	15,000

888poker Ambassador Lovgren Joins Posted Friday 18th October, 2019 at 15:07(UTC+2) by Gia Carnestorm

The board was down , and Pasquale Ruggiero bet 1,800 from the cutoff. 

One player folded before Morten Mathiesen called, and 888poker ambassador Sofia Lovgren also folded. 

Mathiesen bet 2,500 on the river, and Ruggiero folded. 

Player		Chips	Progress
Sofia Lovgren		46,000	0
Morten Mathiesen		35,000	0
Pasquale Ruggiero		30,000	0

Double Knockout for Van Wesemael Posted Friday 18th October, 2019 at 15:02(UTC+2) by Chris Martin

Zoran Stojanovic opened to 800 and Sander van Wesemael three-bet to 2,200 on the button. Vittorio Di Troia called in the big blind and Stojanovic re-raised all in for around 8,000.

Wesemael shipped his 19,000 stack and Di Troia made it three all-ins for his last 14,000.

Zoran Stojanovic:
Sander van Wesemael:
Vittorio Di Troia:

The board was and Van Wesemael's hand held to send both players to the rail.

Player		Chips	Progress
Sander Floris Van Van Wesemael		35,000	10,000
Zoran Stojanovic		0	0
Vittorio Di Troia		0	0

Lucky River for Watkins Posted Friday 18th October, 2019 at 14:57(UTC+2) by Chris Martin

A player under the gun opened to 700 and got four calls including Antonio Scalzi on the button and Adam Watkins in the big blind.

The flop was and it checked to the preflop aggressor who continued for 1,300. Scalzi and Watkins called and the turn was the . Both Scalzi and Watkins called 1,900 again.

The river was the and the trio checked. Watkins showed for a missed straight draw but rivered pair of queens. The first player mucked, with Scalzi mucking and Watkins took down the pot.

Player		Chips	Progress
Adam Watkins		35,000	10,000
Antonio Scalzi		30,000	5,000

Maimon vs. Russo Posted Friday 18th October, 2019 at 14:42(UTC+2) by Gia Carnestorm

The flop fell , and Giovanni Russo checked. 

Amir Maimon bet 6,000 into the 11,000 pot, and Russo went into the tank. 

Russo thought for close to three minutes before the clock was called on him by another player. 

The TD informed Russo he had 30 seconds left to act, and ten seconds later, he passed his cards into the muck. 

Player		Chips	Progress
Amir Maimon		30,000	5,000
Giovanni Russo		20,000	5,000

14:39 (UTC+2)

Start of Level 3
Blinds: 100/300     Ante: 300

Hirsch Runs Queens into Aces Posted Friday 18th October, 2019 at 14:23(UTC+2) by Gia Carnestorm

The completed board was down , and Kent Staahle was all in for 11,000. 

Hirsch called and revealed , but it wasn't enough against , and Hirsch hit the rail early on in Day 2. 

Player		Chips	Progress
Kent Staahle		45,000	0
Dolev Hirsch		0	0

Queens for Lisovskyi Posted Friday 18th October, 2019 at 14:07(UTC+2) by Gia Carnestorm

Maurizio Fiscaro bet 800 with the board down , and Sanjay Patel and Vladyslav Lisovskyi called before the final player involved folded. 

The appeared on the river, and Lisovskyi bet 1,400 after the action checked to him. 

Both Fiscaro and Patel called, and Lisovskyi revealed , which was enough to win the pot. 

Player		Chips	Progress
Vladyslav Lisovskyi		28,000	3,000
Maurizio Fisicaro		22,000	3,000
Sanjay Hasmukh Patel		22,000	3,000

Vella Wins House Over House Posted Friday 18th October, 2019 at 14:07(UTC+2) by Chris Martin

On a board Matthew Vella bet 1,500 and got two calls.

The river was the and it checked to Vella who bet 7,000. One player folded before the other check-raised all in for around 40,000. Vella called.

The all-in player showed for a flopped set and rivered full house, but Vella had rivered a full house of his own with to send his opponent to the rail.

Player		Chips	Progress
Matthew Vella		55,000	30,000

14:05 (UTC+2)

Start of Level 2
Blinds: 100/200     Ante: 200

Brodd Checks Back River Posted Friday 18th October, 2019 at 14:01(UTC+2) by Chris Martin

On a board Giacomo Nunziati check-called 3,500 from Sven Brodd.

The river was the and Nunziati checked. Brodd took about a minute before checking behind.

Nunziati shrugged, tabling for a missed flush draw and Brodd won the pot with for trip nines.

Player		Chips	Progress
Sven Karl Filip Brodd		31,000	6,000
Giacomo Nunziati		15,000	10,000

First Entries Posted Friday 18th October, 2019 at 13:44(UTC+2) by Gia Carnestorm

Among the masses of players to take their seats in Day 1c is Daiva Byrne, Danny Toffel, Jay Harwood, Andy Hills, Jon Kyte, Chritos Xanthopoulos, Jamie Nixon, Sandro Pitzanti, Mantas Urbonas, Sander Van Wesemael, and Daniel Wilson. 

€1,000,000 Guarantee Met! Posted Friday 18th October, 2019 at 13:44(UTC+2) by Chris Martin

With over 800 players registered on Day 1c, the tournament guarantee of €1,000,000 has been met.

That brings the total so far to 1,796 with late registration in Day 1c still open for ten more levels, and both Day 1d and 1e to come tomorrow!

Can the figure of 3,816 from 2018 be beaten?

Player		Chips	Progress
Matthew Vella		55,000	30,000

Download the Battle of Malta App Posted Friday 18th October, 2019 at 13:41(UTC+2) by Chris Martin

Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting bom.beezer.com

Shuffle Up and Deal Posted Friday 18th October, 2019 at 13:26(UTC+2) by Gia Carnestorm

The Day 1c action is underway at Casino Malta. 

Battle of Malta Ready for Day 1c Posted Friday 18th October, 2019 at 13:20(UTC+2) by Chris Martin

Live Updates by Will Shillibier and Aaron McBride

The 2019 Battle of Malta continues today with the third of five starting flights, with this year's €555 buy-in Main Event expected to be the biggest in Battle of Malta history.

Yesterday's Day 1b saw 585 entrants compete, and with the action in level 14, the money bubble burst, leaving 88 players remaining to progress to Day 2 on Sunday, October 20.

Last year a whopping 3,816 players smashed the €1m guarantee, and this year, thousands of players will be competing in Malta’s biggest poker tournament, including hundreds of qualifiers from MPNPT, 888poker and Italian site You win.

Year	Entrants	Name	Country	Payout
2018	3,816	Julien Stropoli	France	€168,500*
2017	2,074	Nadav Lipszyc	Israel	€200,000
2016	1,813	Robert Berglund	Sweden	€160,000
2015	1,804	Nicolas Proust	France	€110,000*
2014	1,447	Antoan Katsarov	Bulgaria	€122,750
2013	888	Louis Cartarius	Germany	€68,000
2012	349	Nicodemus Small	Italy	€35,000

*denotes deal

The award-winning Battle of Malta is being hosted by Casino Malta at the luxurious InterContinental Hotel in St Julian’s from October 15-22.

Malta-based French player Julien Stropoli won last year's Main Event for €168,500, the best cash of his live poker career. The star-studded final table included previous MPN Poker Tour finalist Mantas Urbonas, two-time Unibet Open champion Mateusz Moolhuizen and Grosvenor Ambassador Andy Hills.

Main Event Structure

With unlimited re-entries until the end of level 10, there will be five start flights in total – with many flights expected to sell out. Players will kick off with a 25,000 starting stack and 40-minute blind levels. In the final Day 1e start flight, players will get a 10,000 starting stack and 10-minute levels. Each Day 1 will play down to 15% of the field – with all survivors making the money.

Bowling Competition

On Saturday (October 19), Battle of Malta is hosting a Bowling Competition at the Eden SuperBowl opposite the tournament venue. Four seats for Battle of Malta 2020 are up for grabs for each member of the four-person winning team . Teams of four should register in advance at the Eden Super Bowl, which is right across the road from the Intercontinental.

Players Party

The main Battle of Malta Players Party is taking place at exclusive Paranga Beach, the Intercontinental Hotel’s private beach club, from 8 pm on Sunday (October 20). Hit Maltese band Red Electrick is on the bill, ensuring this will be a night to remember for all Battle of Malta players.

New App

Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting bom.beezer.com 

Stay tuned to all the live updates throughout the Battle of Malta festival right here!

12:58 (UTC+2)

Day 1C of Battle of Malta 2019 Started
Level: 1     Blinds: 100/100     Ante: 100