0.0005 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

0.0015 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.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '1'

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

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

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

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

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

0.0295 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` = '10'
AND `published` = 1

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

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

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

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

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` = '182'
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` = '181'
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` = '180'
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` = '179'
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` = '177'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0202 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '175'
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` = '174'
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` = '173'
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` = '172'
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` = '171'
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` = '169'
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` = '168'
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` = '167'
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` = '166'
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` = '165'
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` = '164'
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` = '163'
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` = '162'
ORDER BY `chip_change` DESC, `busted` ASC

0.0169 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '161'
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` = '160'
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` = '158'
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` = '159'
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` = '157'
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` = '156'
ORDER BY `chip_change` DESC, `busted` ASC

0.0078 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '155'
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` = '153'
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` = '154'
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` = '152'
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` = '151'
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` = '150'
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` = '149'
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` = '148'
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` = '147'
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` = '146'
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` = '144'
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` = '145'
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` = '143'
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` = '142'
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` = '141'
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` = '140'
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` = '139'
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` = '137'
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` = '138'
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` = '134'
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` = '136'
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` = '133'
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` = '135'
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` = '132'
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` = '130'
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` = '131'
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` = '129'
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` = '128'
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` = '127'
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` = '126'
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` = '125'
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` = '124'
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` = '123'
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` = '122'
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` = '121'
ORDER BY `chip_change` DESC, `busted` ASC

0.0169 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '120'
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` = '119'
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` = '118'
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` = '117'
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` = '116'
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` = '115'
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` = '113'
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` = '111'
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` = '110'
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` = '109'
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` = '108'
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` = '107'
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` = '106'
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` = '105'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '182'
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` = '181'
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` = '180'
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` = '179'
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` = '177'
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` = '176'
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` = '175'
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` = '174'
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` = '173'
ORDER BY `chip_change` DESC, `busted` ASC

0.0169 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '172'
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` = '171'
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` = '169'
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` = '168'
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` = '167'
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` = '166'
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` = '165'
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` = '164'
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` = '163'
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` = '162'
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` = '161'
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` = '160'
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` = '158'
ORDER BY `chip_change` DESC, `busted` ASC

0.0164 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '159'
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` = '157'
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` = '156'
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` = '155'
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` = '153'
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` = '154'
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` = '152'
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` = '151'
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` = '150'
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` = '149'
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` = '148'
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` = '147'
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` = '146'
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` = '144'
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` = '145'
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` = '143'
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` = '142'
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` = '141'
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` = '140'
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` = '139'
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` = '137'
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` = '138'
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` = '134'
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` = '136'
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` = '133'
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` = '135'
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` = '132'
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` = '130'
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` = '131'
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` = '129'
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` = '128'
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` = '127'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0081 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '125'
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` = '124'
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` = '123'
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` = '122'
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` = '121'
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` = '120'
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` = '119'
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` = '118'
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` = '117'
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` = '116'
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` = '115'
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` = '113'
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` = '111'
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` = '110'
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` = '109'
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` = '108'
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` = '107'
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` = '106'
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` = '105'
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` = '104'
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` = '102'
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` = '101'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

    

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 1B

12:56 (UTC+2)

Day 1B of Battle of Malta 2019 Ended
Level: 15     Blinds: 2500/5000     Ante: 5000

Niko Pakalen Takes the Day 1b Lead; 88 Progress Posted Friday 18th October, 2019 at 02:21(UTC+2) by Gia Carnestorm

Niko Pakalen (571,000) has claimed the Day 1b chip lead with Simon Forster (477,000), Marc Jan Mijnheer (446,00), Ola Stene-Johansen (431,000), Patrick Clarke (400,000), Ovidiu Dorin Barna (383,000), and Leo Worthington-Leese (372,000) (pictured above) following behind.

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

Today 88 players joined the 55 from yesterday in making it through to Day 2 after a long day's play, guaranteeing themselves a place in the money.

Among those to progress included Dara O'Kearney, Ian Simpson, and Daragh Davey.

Several players from Day 1a were back in action, along with new players such as last year's winner Julien Stropoli and 2018 runner-up Maxime Canevet along with Uri Gilboa, David Lappin, John Hesp (pictured below), Sander van Wesemael and Fraser MacIntyre.

Canevet hit the rail during hand-for-hand after running pocket jacks into Clarke's pocket queens, before Stefano Stefanacci bubbled the money spots having flopped a flush with six-four of spades, but saw Salvatore Motta held ten-eight of spades for the higher flush. 

For players not advancing, they still have Days 1c, 1d, and the Turbo Day 1e flight to punch their ticket to Day 2.

Tomorrow sees Day 1c kick off at 1 p.m., and if last year is anything to go by, it is expected to be a massive field, dwarfing the two flights that have taken place so far.

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.

Player		Chips	Progress
Salvatore Motta		240,000	215,000

Stefanacci Money Bubbles Posted Friday 18th October, 2019 at 01:52(UTC+2) by Gia Carnestorm

The flop was down , and Stefano Stefanacci checked.

Salvatore Motta bet 11,000, and Stefanacci shoved for 83,000 from the big blind. 

Motta went into the tank with 120,000 behind, but after a minute passed, he called. 

Stefanacci flipped over for a flush, but saw the bad news that Motta held for the higher flopped flush. 

The and fell to complete the board, and Stefanacci was eliminated in 89th place. 

The final 88 are now in the money and will bag their chips for Day 2. 

A recap of the day's action and full end-of-day chip counts will follow. 

Player		Chips	Progress
Salvatore Motta		240,000	215,000

2018 BOM Main Event Runner-Up Canevet Eliminated Posted Friday 18th October, 2019 at 01:44(UTC+2) by Gia Carnestorm

The action opened from early position with a raise to 11,000, and Maxime Canevet moved all in for 62,000 from the hijack. 

Patrick Clarke called from the cutoff, and the initial raiser folded. 

Canevet:

Clarke:

Board:

Clarke extended his lead on the flop with a set, and by the river had improved to a full house to seal the pot. 

2018 BOM Main Event runner-up 2018 BOM Canevet departed in 90th place and just missed out on the money spots. 

Player		Chips	Progress
Patrick Ignatius Clarke		360,000	80,000
Maxime Thien-Duc Canevet		0	0

00:52 (UTC+2)

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

O'Hare Can't Connect Posted Friday 18th October, 2019 at 00:51(UTC+2) by Gia Carnestorm

Barna Ovidiu-Dorin moved all in from the cutoff and Chris O'Hare put the last of his chips into the middle from the small blind. 

Ovidiu-Dorin:

O'Hare:

Board:

O'Hare was in a flip for his tournament life but was unable to connect with the board. 

Ovidiu-Dorin took down the pot and moved up to 190,000. 

Player		Chips	Progress
Ovidiu-Dorin Barna		190,000	235,000
Chris Ohare		0	0

00:26 (UTC+2)

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

Toffel Eliminated by Gaetano Posted Friday 18th October, 2019 at 00:09(UTC+2) by Gia Carnestorm

Three players called, and Ricciardi Gaetano moved all in for 56,000. 

Two players folded, and Danny Toffel put his final 15,000 into the middle. 

Gaetano:

Toffel:

Board:

There was no joy for Toffel, and he hit the rail as Gaetano moved up to 80,000. 

Player		Chips	Progress
Gaetano Ricciardi		80,000	55,000
Toffel Danny		0	0

Worthington-Leese Over 400,000 Posted Friday 18th October, 2019 at 00:01(UTC+2) by Chris Martin

Yesterday's chip leader was Shane Dempsey with 490,000, however Leo Worthington-Leese is already in a good position with 435,000 midway through Level 13.

Just 117 players remain from the 585 that started Day 1b, with 88 advancing to Day 2.

McCloskey Doubles Posted Thursday 17th October, 2019 at 23:55(UTC+2) by Gia Carnestorm

Mick McCloskey is all in on the flop, and Mario Ripepi called. 

McCloskey revealed for the up-and-down straight draw, and Ripepi was ahead with . 

However, the on the turn gave McCloskey the straight, and he held on the river to double. 

Player		Chips	Progress
Mick Mccloskey		85,000	60,000
Mario Ripepi		80,000	55,000

Clarke Joins the Chip Leaders Posted Thursday 17th October, 2019 at 23:45(UTC+2) by Chris Martin

Kapatsoris Stylianos moved all in for 58,000 from the button. Patrick Clarke called in the small blind and the big blind folded.

Kapatsoris Stylianos:
Patrick Clarke:

The flop came . "That'll be difficult," said Clarke on the turn leaving Stylianos drawing dead.

The river was the and Clarke moved up to around 280,000.

Player		Chips	Progress
Pekka Aulis Kristian Virtanen		350,000	220,000
Patrick Ignatius Clarke		280,000	255,000
Stene-Johansen Ola		270,000	245,000
Kapatsoris Stylianos		0	0

23:38 (UTC+2)

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

Break Posted Thursday 17th October, 2019 at 23:19(UTC+2) by Gia Carnestorm

The players are on a 20-minute break.

Ace-Nine is Fine Posted Thursday 17th October, 2019 at 23:19(UTC+2) by Gia Carnestorm

The board was down , and a bet of 9,200 came in from one player. 

Three players called, and the appeared on the river. 

All four players checked, and the first player showed for top pair. The second player showed before the third player folded. 

The final player revealed , and the three players chopped the pot while sharing laughter at the situation. 

Kings No Good for Lakerveld Posted Thursday 17th October, 2019 at 23:18(UTC+2) by Chris Martin

Action was on a river of and Daniel Lakerveld bet 32,000 into a pot approaching 80,000. Ovidiu-Dorin Barna was his opponent, and he instantly flicked in a chip to call.

Lakerveld showed but was no good against the of Barna.

"Good river for you," said Barna who chipped up to over 200,000 in chips.

Player		Chips	Progress
Ovidiu-Dorin Barna		225,000	200,000
Daniel Lakerveld		150,000	30,000

Crawley-Boevey Shoves Posted Thursday 17th October, 2019 at 22:56(UTC+2) by Gia Carnestorm

The board was down , and Fabio Frusca bet 49,500 from under the gun. 

James Crawley-Boevey moved all in for 98,000, and Frusca went into the tank. 

Frusca was unsure about what to do and repeatedly checked his holding with 50,000 behind. After close to two minutes, Frusca mucked for two pair, and Crawley-Boevey took a massive pot. 

Player		Chips	Progress
James Ian Crawley-Boevey		200,000	147,000
Fabio Frusca		50,000	25,000

Hesp Eliminated by Ruggeri Posted Thursday 17th October, 2019 at 22:54(UTC+2) by Chris Martin

Shortly after doubling, John Hesp shoved for 20,000 from under the gun and was called by Umberto Ruggeri.

John Hesp:
Umberto Ruggeri:

There was no help for Hesp on the runout and he was eliminated.

"I was just card dead," said Hesp. "I got off to a really good start on feature, you know how it is, when you get all your cards at once!"

Player		Chips	Progress
Umberto Ruggeri		75,000	25,000
John Hesp		0	0

22:39 (UTC+2)

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

Playing Down to 88 Players on Day 1b Posted Thursday 17th October, 2019 at 22:35(UTC+2) by Chris Martin

Tournament officials have confirmed that after 585 players jumped into Day 1b of the Battle of Malta Main Event, the tournament will play down to 88 players before bagging up for Day 2.

That brings the tournament to 918 total entrants with three flights left. There are currently 164 players remaining in Day 1b.

Player		Chips	Progress
Alan Ronald Keith Vinnicombe		85,000	60,000

Fracas Triples Up Posted Thursday 17th October, 2019 at 22:33(UTC+2) by Gia Carnestorm

Hayashi Tatsuya raised from the cutoff, and Mugurel Fracas moved all in for 28,000 from the button.

Pavlos Xanthopoulos called in the small blind, and Pablo Amor moved all in from the big blind. 

Xanthopoulos called after Tatsuya folded, and the three players turned over their cards. 

Xanthopoulos:

Fracas:

Amor:

Board:

Fracas hit a set on the flop, and Amor caught an ace on the turn. 

Fracas triples up to 90,000, Amor was left with 10,000, and Xanthopoulos moved down to 65,000. 

Player		Chips	Progress
Mugurel Fracas		90,000	65,000
Pavlos Xanthopoulos		65,000	40,000
Pablo Amor Bolado		10,000	15,000

Vinnicombe Goes from 3k to 80k Posted Thursday 17th October, 2019 at 22:17(UTC+2) by Chris Martin

According to Alan Vinnicombe, he has single-handedly brought himself back from the dead after being down to just 3,000 shortly after the dinner break.

"It was a miracle," Vinnicombe told us. "Four straight double ups! It might have been four. Or was it five?"

"I thought I was out. I had ace king against queens and I thought that was it."

Vinnicombe told us that he limp re-raised with aces to get a chunk back, and after further pots he now sits on 83,000. Will he continue ever upwards and be a contender for the end-of-day chip lead? Only time will tell!

Player		Chips	Progress
Alan Ronald Keith Vinnicombe		85,000	60,000

Benguigui Eliminated Posted Thursday 17th October, 2019 at 21:59(UTC+2) by Gia Carnestorm

The completed board was down , and Elisha Benguigui checked from the big blind. 

Anthony Forster bet 10,000 from the button, and Benguigui moved all in for 41,600. 

Forster asked for the count and went into the tank. After ninety seconds, Forster called and revealed for two pair. Benguigui mucked for the lower two pair and hit the rail.

Player		Chips	Progress
Simon Anthony Forster		160,000	7,000

21:56 (UTC+2)

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

Marinelli Departs Posted Thursday 17th October, 2019 at 21:44(UTC+2) by Gia Carnestorm

Morten Mathiesen raised to 3,500, and the player in the cutoff called before Dario Marinelli moved all in for 7,600 from the small blind. 

Giorgio Marletta called in the big blind and did the other two players. 

The flop fell , and Mathiesen bet 15,000. The other two players folded, and Mathiesen and Marinelli flipped over their hands. 

Marinelli revealed but was behind to . 

The turn and river were no use to Marinelli, and he departed. 

Player		Chips	Progress
Morten Mathiesen		120,000	15,000
Dario Marinelli		0	0

Big Stacks After Dinner Posted Thursday 17th October, 2019 at 21:31(UTC+2) by Chris Martin

Player		Chips	Progress
Pasquale Braco		268,000	17,000
Mateusz Wozniak		240,000	20,000
Gulas Josef		180,000	10,000
Mehmet Sirin Ongorur		175,000	143,000
Robert Cabral Lim		170,000	10,000
Simon Anthony Forster		167,000	142,000
Hossein Bagheri Semnani		165,000	140,000
Antonello Ferraiuolo		160,000	135,000
Konstantin Faerber		153,000	128,000
Massimo Segatto		145,000	120,000
Giorgio Marletta		130,000	105,000
Pekka Aulis Kristian Virtanen		130,000	105,000
Odd Inge Hurlen		125,000	100,000
Dorian Lionel Quentin Mouton		27,000	0

21:18 (UTC+2)

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

Dinner Break Posted Thursday 17th October, 2019 at 20:07(UTC+2) by Chris Martin

Players in the Battle of Malta Main Event are heading on a 75-minute dinner break. The tournament clock shows 228 of 580 players remaining.

MacIntyre Runs Queens into Kings Posted Thursday 17th October, 2019 at 20:06(UTC+2) by Gia Carnestorm

Fraser MacIntyre three-bet to 6,800 from the button after his opponent in the cutoff opened to 2,600. 

The cutoff player four-bet to 15,000 and MacIntyre's shove was snap-called. 

MacIntyre held and was up against . 

The board fell , and despite MacIntyre hitting a full house on the river, it was not enough to survive. 

Updated Chip Counts Posted Thursday 17th October, 2019 at 19:50(UTC+2) by Gia Carnestorm

Player		Chips	Progress
Mateusz Wozniak		220,000	35,000
Gulas Josef		190,000	165,000
Robert Cabral Lim		180,000	42,000
Ulysse Arnaud Maurice Harry		170,000	145,000
Virginijus Lapenas		140,000	115,000
Claudio Leonardo Pagano		130,000	105,000
Anthony Derek Gardner		120,000	95,000
Rickard Dery Esbeoglu		110,000	85,000
Ian Simpson		70,000	44,000
Dara Ruairi O`Kearney		60,000	5,000

Battle of Malta Pink October Charity Raffle Posted Thursday 17th October, 2019 at 19:49(UTC+2) by Chris Martin

Battle of Malta is aiming to raise thousands of euros at this year’s event with a special charity raffle for Pink October Malta. Prizes include BOM 2020 seats and packages for 888Live London, the MPN Poker Tour, the World Casino Championships, the V-Poker Challenge and the Kings of Tallinn.

Braco Climbs into the Chip Lead Posted Thursday 17th October, 2019 at 19:47(UTC+2) by Chris Martin

A player opened and Pasquale Braco three-bet. Michele Manzi and the original raiser called and the trio saw a flop of

It checked to Braco who continued for 16,000. Manzi min-raised and the original raiser folded. Braco shoved and Manzi called it off for his last 80,000 or so chips.

Pasquale Braco:
Michele Manzi:

The turn meant Manzi was drawing dead and the river sent him to the rail with Braco moving up to within touching distance of 300,000 in chips.

Player		Chips	Progress
Pasquale Braco		285,000	260,000
Michele Manzi		0	0

19:30 (UTC+2)

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

Wozniak Cracks Kings to Soar Up the Counts Posted Thursday 17th October, 2019 at 18:55(UTC+2) by Chris Martin

There was a loud thump of a fist hitting a table and we saw Francesco Aprigliano mumbling something in not-too-friendly sounding Italian.

Aprigliano held and was all in for in excess of 50,000 against the of Mateusz Wozniak.

The board had come giving Wozniak a rivered set and eliminating Aprigliano.

Player		Chips	Progress
Mateusz Wozniak		185,000	85,000
Francesco Aprigliano		0	0

Kings Best for Lim Posted Thursday 17th October, 2019 at 18:53(UTC+2) by Gia Carnestorm

Robert Cabral Lim called an all in from Alessandro Giordano, and the latter needed help. 

Lim held , and it was for Giordano. 

The board brought no help for Giordano and the Italian hit the rail as Lim moved up to 120,000. 

Player		Chips	Progress
Robert Cabral Lim		120,000	102,000
Alessandro Giordano		0	0

Battle of Malta Day 1b Intro Posted Thursday 17th October, 2019 at 18:41(UTC+2) by Chris Martin

Ace-Jack Holds for Carlsson Posted Thursday 17th October, 2019 at 18:37(UTC+2) by Gia Carnestorm

Daniel Carlsson raised from the button and called after the player in the small blind shoved for 12,000. 

Carlsson was ahead with against , and when the board fell there was no shocks. 

Carlsson picked up the pot as his opponent departed and moved up to 40,000. 

Player		Chips	Progress
Daniel Carlsson		41,000	1,000

18:36 (UTC+2)

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

O'Hare Doubles Through Marinelli Posted Thursday 17th October, 2019 at 18:35(UTC+2) by Chris Martin

Chris O'Hare was all in holding against the of Dario Marinelli for O'Hare's last 21,000.

There was an ace on the flop of and Marinelli couldn't hit on the runout and he fell below starting stack.

Player		Chips	Progress
Chris Ohare		45,000	20,000
Dario Marinelli		21,000	51,000

Big Stacks Begin to Emerge Posted Thursday 17th October, 2019 at 18:28(UTC+2) by Chris Martin

With 323 of 569 players remaining in the Battle of Malta Main Event, the big stacks are beginning to emerge with anyone over 100,000 in chips well-placed.

The largest that we've noticed is Czech player Dominik Martan who sits with over 140,000 midway through Level 7.

Player		Chips	Progress
Dominik Martan		140,000	115,000
Antonello Ferraiuolo		135,000	110,000
Mark Attard		130,000	105,000
Philip Andrew Young		125,000	100,000
Stene-Johansen Ola		120,000	95,000
Milos Babovic		115,000	90,000
Simon Anthony Forster		110,000	85,000
Jamie Colin Munro		85,000	60,000
Raymond Forsland		85,000	60,000

Jaksland Eliminated by Kovacs Posted Thursday 17th October, 2019 at 18:24(UTC+2) by Gia Carnestorm

Csaba Kovacs bet 4,000 and the flop fell and then called a 12,000 all in from Peter Jaksland. 

Jaksland held for middle pair, and Kovacs had . 

Jaksland kept his lead after the fell on the turn, but the river gave Kovacs the nut flush to steal the pot and eliminate Jaksland. 

Player		Chips	Progress
Csaba Kovacs		65,000	40,000
Peter Jaksland		0	0

18:11 (UTC+2)

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

Break Posted Thursday 17th October, 2019 at 17:37(UTC+2) by Chris Martin

Players are going on their second 20-minute break of the day with the tournament clock showing 348 of 561 players remaining.

Top Set for Simpson Posted Thursday 17th October, 2019 at 17:35(UTC+2) by Gia Carnestorm

Jelmer Schuurmans raised from the button before Ian Simpson moved all in for 12,500. Joubert Pierreyves thought for a minute in the big blind before he called, and Schuurmans folded. 

Simpson:

Pierreyves:

Board:

Simpson hit top set on the river to confirm his double up and moved up to 26,000. 

Player		Chips	Progress
Ian Simpson		26,000	0
Joubert Pierreyves Jean Franci		9,000	16,000

Lehtonen Runs into Aces Posted Thursday 17th October, 2019 at 17:33(UTC+2) by Chris Martin

A player opened to 1,500 and got a number of calls including Seppo Lehtonen before Renato Messina three-bet to around 18,000 leaving himself 1,000 around.

It folded back to Lehtonen who moved all in for 15,000 and the remaining players all folded.

Seppo Lehtonen:
Renato Messina:

There was no help for Lehtonen on the and he was eliminated.

Player		Chips	Progress
Renato Messina		40,000	40,000
Seppo Ilmari Lehtonen		0	0

Top Top for Marinelli Posted Thursday 17th October, 2019 at 17:24(UTC+2) by Gia Carnestorm

The pot was 9,500 with the flop down , and Kristofer Skolem check-called a 3,000 bet from Dario Marinelli. 

Both players checked on the turn, and Skolem passed the action across for the third time after the appeared on the river. Marinelli then saw his 5,000 bet called, and for top pair top kicker was enough to win the pot for Marinelli. 

Player		Chips	Progress
Dario Marinelli		72,000	47,000
Kristoffer Skolem		12,000	13,000

Get to Know BOM Masseuse Dana Perianu Posted Thursday 17th October, 2019 at 17:21(UTC+2) by Chris Martin

Battle of Malta host Laura Cornelius interviews Dana Perianu, one of the best-known masseuses on the European poker circuit, as she competes in the Battle of Malta Main Event

Download the Battle of Malta App! Posted Thursday 17th October, 2019 at 17:16(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

2018 BOM Runner-Up Canevet in the Field Posted Thursday 17th October, 2019 at 17:16(UTC+2) by Chris Martin

Last year Maxime Canevet fell just short of taking down the biggest Battle of Malta Main Event, finishing in second place behind Julien Stropoli.

However, he did walk away with the largest payday after a five-handed deal. He won €192,000 and is back in the field today looking to lock up another cash and start his journey to back-to-back deep runs.

Player		Chips	Progress
Maxime Thien-Duc Canevet		25,000	0

Red Electrick Set to Play Battle of Malta Players Party Posted Thursday 17th October, 2019 at 17:08(UTC+2) by Chris Martin

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.

Colomba Runs into Trouble Posted Thursday 17th October, 2019 at 17:00(UTC+2) by Chris Martin

On a flop Morten Mathiesen check-called 2,200 from pre-flop raiser Danilo Colomba.

The turn was the and Mathiesen checked. Colomba continued for 5,400 and Mathiesen check-raised all in, with Colomba snap-calling for his last 24,000.

Morten Mathiesen:
Danilo Colomba:

Colomba had flopped two pair with the turn giving Mathiesen a better two pair. The river gave both players a full house with the Danish player's hand better sending the Italian to the rail..

Player		Chips	Progress
Morten Mathiesen		65,000	40,000
Danilo Colomba		0	0

16:57 (UTC+2)

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

Krcova River Raise Posted Thursday 17th October, 2019 at 16:50(UTC+2) by Gia Carnestorm

Michele Manzi called for 500 before Jana Krcova raised to 1,800 in the next seat. 

Manzi called after the other players folded, and the flop fell . Both players checked, and Manzi bet 2,400 on the turn. 

Krcova called and the appeared on the river. Manzi bet 4,000 and Krcova raised to 8,000. 

Manzi quickly folded to the pressure from Krcova but was still left to play a 65,000 stack. 

Player		Chips	Progress
Michele Manzi		65,000	40,000
Jana Krcova		37,000	12,000

Gilboa Misses to Depart Posted Thursday 17th October, 2019 at 16:29(UTC+2) by Gia Carnestorm

The flop was down , and James Crawley-Boevey called Uri Gilboa's all in. 

Gilboa held for the open-ended straight draw, but Crawley-Boevey was ahead with . 

The turn and river were no use to Gilboa, and he departed from the table. 

Player		Chips	Progress
James Ian Crawley-Boevey		39,000	14,000
Uri Gilboa		0	25,000

Updated Notable Stacks Posted Thursday 17th October, 2019 at 16:25(UTC+2) by Chris Martin

Player		Chips	Progress
Dara Ruairi O`Kearney		65,000	40,000
Sander Floris Van Van Wesemael		57,000	32,000
Leo Dominic Worthington-Leese		49,000	24,000
John Hesp		30,000	12,000
Florence Yvette Suzanne Mazet		27,000	2,000
Fraser Macintyre		22,000	3,000

16:20 (UTC+2)

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

Win for Hesp Posted Thursday 17th October, 2019 at 16:14(UTC+2) by Gia Carnestorm

Marius Cristea Valentin raised to 1,100 from under the gun, and four players called. 

The flop fell , and Valentin continued for 3,700 after two players checked. Another folded before John Hesp min-raised to 7,500, and the action folded back to Valentin. 

Valentin thought for 30 seconds before he took a final look at his cards and folded.

Player		Chips	Progress
John Hesp		42,000	17,000
Valentin-Marius Cristea		32,000	7,000

Download the Battle of Malta App Posted Thursday 17th October, 2019 at 16:01(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 

Swede Victory for Olsson Against Brandt Posted Thursday 17th October, 2019 at 16:00(UTC+2) by Chris Martin

Lars Olsson was all in for around 6,000 against fellow Swede Carl Brandt.

Lars Olsson:
Carl Brandt:

There was no help for Brandt on the as Olsson doubled up, bringing both to around half starting stack.

Player		Chips	Progress
Lars Olsson		15,000	10,000
Carl Nicklas Brandt		12,000	13,000

Jacks Hold for Grech Posted Thursday 17th October, 2019 at 15:54(UTC+2) by Gia Carnestorm

The completed board was down and in front of Andre Grech was . 

Grech was all in and Sirin Ongorur had called at some point only to reveal . 

Grech collected the 37,000 pot, and Orgorur was reduced to 32,000. 

Player		Chips	Progress
Andre' Grech		37,000	12,000
Mehmet Sirin Ongorur		32,000	7,000

Epic Recovery From Hills Posted Thursday 17th October, 2019 at 15:43(UTC+2) by Chris Martin

Andy Hills has enjoyed a stellar period of time, spinning up a stack of just 1,300 to 29,000.

After calling a shove for around 40,000 with ace-queen and failing to hold, he managed to - in his words - "save €500" by chipping back up.

His reward for such efforts? A seat on the feature table after the break.

Player		Chips	Progress
Andy Hills		29,000	12,500

15:39 (UTC+2)

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

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

The players are now on their first 20-minute break. 

Aces No Good for Andren Posted Thursday 17th October, 2019 at 15:23(UTC+2) by Gia Carnestorm

The flop fell and Marko Pejic checked from the big blind before Anders Andren bet from the cutoff. 

Pejic raised to 2,200 and Andren called. The hit on the turn, and Andren called a 2,500 bet. 

Pejic continued for 6,100 on the river and Andren called after a few moments in the tank. 

Pejic showed for two pair, and Andren open-mucked . 

Player		Chips	Progress
Marko Pejic		45,000	20,000
Filip Theodor Anders Andren		18,000	7,000

Hills Doubles Posted Thursday 17th October, 2019 at 15:02(UTC+2) by Gia Carnestorm

Dmitry Pavlov raised from early position and Andy Hills three-bet all in for 7,300 from the cutoff. 

The action folded back to Pavlov, and he called after ten seconds of thought. 

Pavlov:

Hills:

Board:

Hills, who took sixth place in the 2018 BOM Main Event, held to double and remained in contention in his bid to make back-to-back final tables. 

Player		Chips	Progress
Dmitry Pavlov		50,000	25,000
Andy Hills		16,500	8,500

Scary Runout Slows Down Hynes Posted Thursday 17th October, 2019 at 14:51(UTC+2) by Chris Martin

On a flop, Aidan Hynes checked blind on blind to Robert Lim who bet 700. Hynes check-raised to 2,800 and Lim called.

The pair checked both the turn and river. Hynes turned over for two pair and Lim mucked.

Player		Chips	Progress
Aidan Paul Hynes		30,000	5,000
Robert Cabral Lim		18,000	7,000

14:37 (UTC+2)

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

Chica Flops the Nuts Posted Thursday 17th October, 2019 at 14:35(UTC+2) by Gia Carnestorm

The cards were down , and there were 3,000 in the middle. 

Both players checked, and the river card was the . 

Oscar Quintero Chica bet 1,300 from the big blind, and Quintin Mouton called from the button. 

Chica showed for the flopped straight, and Mouton mucked. 

Player		Chips	Progress
Oscar Chica Quintero		29,000	4,000
Dorian Lionel Quentin Mouton		27,000	2,000

Barclay Folds to Garaialde Posted Thursday 17th October, 2019 at 14:26(UTC+2)

Action was on a board and with 20,000 chips in the middle, Christopher Barclay checked to Jon Garaialde who bet 15,000.

Barclay eyed his opponent steadily.

"You need to button up the collar for the next bluff you try," said Barclay, pointing at his opponent's neck.

Eventually the clock was called on him and as the seconds ticked down his hand was declared dead.

"You didn't want me to call there," he said, with his opponent sliding his hand into the muck.

Player		Chips	Progress
Jon Martinez de Antonana Garaialde		45,000	20,000
Christopher Donald Barclay		20,000	5,000

Davey Cracks Kings Posted Thursday 17th October, 2019 at 14:23(UTC+2)

The completed board was down and Oyvind Wroldsen bet on the river. 

Daragh Davey raised, and the Irishman called after Wroldsen shoved. 

Wroldsen showed for top set, but Davey revealed for a  straight to survive and win the pot. 

Player		Chips	Progress
Oyvind Wroldsen		37,000	12,000
Daragh Davey		29,000	4,000

Mielczarek Wins With Tens Posted Thursday 17th October, 2019 at 14:13(UTC+2)

Stian Danielsen raised to 400 from the cutoff and called a raise to 1,200 from Bartosz Mielczarek in the big blind. 

Both players checked on the flop and Mielczarek bet 1,500 on the turn. 

Danielsen called and the players checked to a showdown on the river. 

Mielczarek revealed and Danielsen mucked .

Player		Chips	Progress
Bartosz Mielczarek		27,000	2,000
Stian Werum Danielsen		22,000	3,000

13:55 (UTC+2)

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

Trips for Konstantinos Posted Thursday 17th October, 2019 at 13:55(UTC+2)

The flop fell , and Souliotis Konstantinos bet 800 from middle position. Two players folded before Kapatsoris Stylianos called in the small blind, as did Sally Jane Stephens in the big bind. 

Konstantinos bet 2,700 on the turn, and only Stephens called. She checked again on the river, and Konstantinos checked behind. 

Stephens held , but Konstantinos took the pot with for trips. 

Player		Chips	Progress
Konstantinos Souliotis		32,000	7,000
Sally Jane Stephens		18,000	7,000

Day 1b Field Closing in on 400 Players Posted Thursday 17th October, 2019 at 13:46(UTC+2)

Yesterday's figure of 333 has already been surpassed today on Day 1b of the Battle of Malta Main Event.

Organisers are hopeful that the addition of yesterday's extra flight - compared to last year - will mean a bumper field size for the 2019 edition.

First Notables in the Field Posted Thursday 17th October, 2019 at 13:32(UTC+2)

Among the notable names in the field so far is Dara O'Kearney (pictured), Mohamed Mehdi, Christos Xanthopoulous, Patrick Clarke, Daragh Davey, Anthony Gardner, John Hesp, Andy Hills, John McDonnell, Csaba Kovacs, David Lappin, Fraser MacIntyre, Paul Romain, Ian Simpson, and last night's money bubble player Vygerdas Jonikas. 

Shuffle Up and Deal Posted Thursday 17th October, 2019 at 13:17(UTC+2)

The Day 1b action is underway at the Casino Malta. 

Day 1b Gets Underway at 1 PM Posted Thursday 17th October, 2019 at 13:08(UTC+2)

Live Updates by Will Shillibier and Aaron McBride

The 2019 Battle of Malta continues today with the second 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 1a saw 333 entrants compete, and with the action in level 14, the money bubble burst, leaving 50 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 Vincitu.

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	Nicodemo Piccolo	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 or using the QR code below.

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

13:06 (UTC+2)

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