0.0005 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0102 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-04-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/8/20/updates'
ORDER BY `views` DESC
0.0006 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` = '8'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '8'
0.0324 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0056 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '20'
AND `published` = 1
0.0324 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0056 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '21'
AND `published` = 1
0.0347 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '22'
AND `published` = 1
0.0327 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '23'
AND `published` = 1
0.0323 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '24'
AND `published` = 1
0.0322 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '25'
AND `published` = 1
0.0100 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '20'
ORDER BY `busted` ASC, `current_chips` DESC
0.0070 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` = '20'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0089 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '912'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '917'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '913'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '915'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '908'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '905'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '907'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '906'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '902'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '904'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '903'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '901'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '900'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '899'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '896'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '897'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '895'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '894'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '893'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '892'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '891'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '889'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '888'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '885'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '884'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '883'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '880'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '877'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '876'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '875'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '873'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '872'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '871'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '870'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '867'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '868'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '866'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '865'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '864'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '863'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '862'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '861'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '860'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '859'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '858'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '857'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '856'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '855'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '854'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '853'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '851'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '852'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '850'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '849'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '846'
ORDER BY `chip_change` DESC, `busted` ASC
0.0100 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '20'
ORDER BY `busted` ASC, `current_chips` DESC
0.0062 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` = '20'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '912'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '917'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '913'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '915'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '909'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '908'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '905'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '907'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '906'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '902'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '904'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '903'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '901'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '900'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '899'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '896'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '897'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '895'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '894'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '893'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '892'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '891'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '889'
ORDER BY `chip_change` DESC, `busted` ASC
0.0089 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '888'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '885'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '884'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '883'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '880'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '877'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '876'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '875'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '873'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '872'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '871'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '870'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '867'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '868'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '866'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '865'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '864'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '863'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '862'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '861'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '860'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '859'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '858'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '857'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '856'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '855'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '854'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '853'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '851'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '852'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '850'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '849'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '846'
ORDER BY `chip_change` DESC, `busted` ASC
0.0099 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '20'
ORDER BY `busted` ASC, `current_chips` DESC
0.0099 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '21'
ORDER BY `busted` ASC, `current_chips` DESC
0.0101 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '22'
ORDER BY `busted` ASC, `current_chips` DESC
0.0098 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '25'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1655
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Battle of Malta 2022
Battle of Malta 2022 (April)
Live Reporting - Day 4
Current Level
38 Current Day
4 Blinds
400,000/800,000 Ante
800,000
Entries
2,592 Remaining
1 Prize Pool (EUR)
€1,244,160 First Prize (EUR)
€200,340
Day 1A of Battle of Malta 2022 Ended Level: 16 Blinds: 2,500/5,000 Ante: 5,000
Raoul Van Wersch Bags the Day 1a Chip Lead in the €500K GTD Battle of Malta Main Event Posted Friday 22nd April, 2022 at 04:15(UTC+2) by Jason Glatzer
The Battle of Malta Main Event kicked off in style at the InterContinental Conference Center and the Casino Malta by Olympic Casino with 324 entries getting in on the first of the five opening flights.
To put this into perspective, the last time the Battle of Malta Main Event was held in a live format, the event attracted just a few players more with 333 players entering the field. That event had a €1,000,000 guarantee and eventually attracted 4,657 entries to generate a €2,495,795 prize pool, whereas this year the guarantee was €500,000, and appears to be simply a placeholder with the guarantee almost certainly to be smashed.
The field was trimmed down to just 49 hopefuls, each already in the money to start Day 2 as each opening day plays down to just 15 percent of the field.
Thus far, Raoul Van Wersch (pictured above) is in the best spot after Day 1a after bagging a monstrous stack of 744,000 in chips. Van Wersch had a big stack throughout most of the day but it appeared that either Brian Calleja or Federico Petruzzelli would be the Day 1a chip leader before Van Wersch soared ahead near the end of the day.
Petruzzelli still managed to bag a top three stack with 321,000 in chips, only behind Van Wersch and Mariano D'aquilla, while Calleja dropped two pots near the end of the day to Van Wersch to finish at 210,000.
Other players finding a bag into Day 2 via Day 1a included Dominik French (317,500), Koen Meustege (245,500), Kevin Malone (199,000), Fang Shiyan (182,500), Mateusz Moolhuizen (148,000), The Chip Race co-host David Lappin (112,000), Nico Jaemstroem (91,000), and Tarmo Tammel (53,000).
Final Day 1a Chip Counts
Place
Name
Chip Counts
1
Raoul Van Wersch
744,000
2
Mariano D'aquila
335,000
3
Federico Petruzzelli
321,000
4
Dominik French
317,500
5
Giuseppe Grupposo
317,000
6
Dmitri Dan
290,500
7
Antonio Lucata
280,000
8
Massimo De Giorgi
277,000
9
Ben Meir
263,000
10
Domenico Gala
253,500
Day 1b will kick off at 1 p.m. CEST with blog coverage beginning as soon as cards are in the air. Stay tuned to see what happens next at the 2022 Battle of Malta Main Event.
Final Day 1a Chip Counts Posted Friday 22nd April, 2022 at 04:13(UTC+2) by Jason Glatzer
Name
Chip Counts
Raoul Van Wersch
744,000
Mariano D'aquila
335,000
Federico Petruzzelli
321,000
Dominik French
317,500
Giuseppe Grupposo
317,000
Dmitri Dan
290,500
Antonio Lucata
280,000
Massimo De Giorgi
277,000
Ben Meir
263,000
Domenico Gala
253,500
Koen Meutstege
245,500
Iraklis Manikaros
244,500
Mattia Festa
236,500
Brian Calleja
210,000
Federico Luciano
204,000
Kevin Malone
199,000
Danilo Zaccagnini
199,000
Fang Shiyan
182,500
Cwchowski Thierry
171,000
Tsvetelina Pavlova
156,000
Peter Kovacs
152,000
Madalin Andronesku
150,000
Mateusz Moolhuizen
148,000
Erik Nicotra
144,000
Koppany Balogh
142,000
Paul Jux-Holderness
140,000
Carmine Enchos
131,000
Manish Rawal
124,500
Dario Barone
114,500
Sebastian Mortensen
112,500
David Lappin
112,000
Jonatan Kula
103,000
Massimillano Piazza
102,000
Konrad Abelt
100,000
Leonardo Burdino
91,500
Nico Jaernstroem
91,000
Taavi Allsalu
86,500
Florian Dietrich
77,500
Feliciano Montalbetti
73,500
Robert Lim
70,000
Sven Lysebo
62,500
Kyle Pullicino
60,500
Clement Bonnant
58,000
Jonathan Seiler
57,500
Florian Morel
55,500
Cristian-Florin Vornicu
54,500
Tarmo Tammel
53,000
Soner Vanelderen
40,000
Christian Kempf
38,000
Raoul van Wersch is the Chipleader Posted Friday 22nd April, 2022 at 03:45(UTC+2) by Juhani Tyriseva
Raoul van Wersch.
Raoul was really succesful during the last hour. He won two big pots against Brian Calleja, and collected nice stack, 744.000.
Player
Chips
Progress
Raoul Van Wersch
740,000
610,000
03:45 (UTC+2)
Start of Level 16 Blinds: 2,500/5,000 Ante: 5,000
Manfred Sierke is the Bubble Boy at Day 1A Posted Friday 22nd April, 2022 at 03:23(UTC+2) by Juhani Tyriseva
The long day ended to a quite short bubble, which took about 15 minutes. Manfred Sierke decided to use an aggressive strategy and moved in with and the opponent called behind with
The board did not help Manfred, so he was the bubble boy.
"I come back tomorrow and collect a decent stack", decided Manfred.
Other players were happy after a long starting day and bagged their chips, knowing that they have earned some money of this years tournament already.
Player
Chips
Progress
Manfred Sierke
0
0
Blind Versus Blind is Sometimes Harsh Posted Friday 22nd April, 2022 at 02:28(UTC+2) by Juhani Tyriseva
Federico Petruzelli moved all in from the small blind with and Domenico Gala did not hesitate with and moved his chips to the middle as well.
The board did not help Petruzelli, and Gala doubled up.
Player
Chips
Progress
Domenico Gala
240,000
215,000
Who is Going to be Our Chipleader? Posted Friday 22nd April, 2022 at 01:55(UTC+2) by Juhani Tyriseva
Two stacks are right now a bit bigger than the others.
Federico Petruzelli, chipleader right now.
Player
Chips
Progress
Federico Petruzzelli
470,000
30,000
Brian Calleja
450,000
210,000
Petruzzelli Wins a Monster Pot to Felt Stellata Posted Friday 22nd April, 2022 at 01:43(UTC+2) by Jason Glatzer
Federico Petruzzelli bet 28,500 into a pot of approximately 50,000 with the on the board after the turn. Andrea Stellata jammed over the top and Petruzzelli asked for a count. The dealer confirmed it was for 216,000 and shortly after, Petruzzelli, who barely had his opponent covered, made the call.
Andrea Stellata:
Federico Petruzzelli:
"What did I do?" said Stellata in frustration.
Stellata still had some hope to get a miracle double but instead hit the felt after not hitting his two outer with the completing the board.
Fortunes were different for Petruzzelli, who spoke in Italian to his neighbor while piling up his 500,000 in chips to give him the chip lead late on Day 1a.
Brian Calleja, who has been on the uptick most of the tday, isn't too far behind with 489,000.
Player
Chips
Progress
Federico Petruzzelli
500,000
475,000
Brian Calleja
489,000
249,000
Andrea Stellata
0
0
Andrea Stellata
0
0
01:43 (UTC+2)
Start of Level 15 Blinds: 2,000/4,000 Ante: 4,000
Summer of 69? Posted Friday 22nd April, 2022 at 01:38(UTC+2) by Juhani Tyriseva
Three players saw a flop, which was Raoul Van Wersch bet 12000, and Massimo de Georgi and Carmelo Fangano both called. Turn brought and now everybody decided to check.
River was and now Massimo decided to bet 17000, Carmelo took his time and called, Raoul folded quickly.
Massimo showed which was enough to win the pot, when Carmelo was a bit shocked to see this legendary hand.
Player
Chips
Progress
Massimo di Georgi
140,000
115,000
Massimo di Georgi
25,000
0
Fang Shiyan was Reliable Posted Friday 22nd April, 2022 at 01:19(UTC+2) by Juhani Tyriseva
Feliciano Montalbetti opened from cutoff, Fang Shiyn reraised from the button, Feliciano called.
Flop was Fang made a continuation bet, Feliciano called.
Turn brought and Fang did not hesitate, she moved all her chips to the middle.
Feliciano pondered the situation some time, but decided to fold.
Player
Chips
Progress
Fang Shiyan
155,000
143,000
Feliciano Montalbetti
75,000
50,000
01:19 (UTC+2)
Start of Level 14 Blinds: 1,500/3,000 Ante: 3,000
Kings Gave Double Up for Burdino Posted Friday 22nd April, 2022 at 01:19(UTC+2) by Juhani Tyriseva
Leonardo Burdino and Jonathan Seiler moved all in preflop.
Leonardos were in the lead against Jonathans
Board was favorable for Leonardo, who doubled up.
Player
Chips
Progress
Leonardo Burdino
130,000
105,000
No Comeback for Phillip Huxley Posted Friday 22nd April, 2022 at 00:35(UTC+2) by Juhani Tyriseva
Phillip Huxley went all in from middle position with 8000, one opponent called behind.
Phillip Huxley:
Opponent:
The board ran out and Phillip hit the felt.
"See you tomorrow", said Phillip to us when he left.
Player
Chips
Progress
Phillip Huxley
0
0
Updated Chip Counts Posted Friday 22nd April, 2022 at 00:26(UTC+2) by Juhani Tyriseva
We are losing players very quickly now.
Here are some updated chip counts of bigger stacks.
Player
Chips
Progress
Brian Calleja
240,000
95,000
Andrea Stellata
230,000
35,000
Antonio Licata
165,000
140,000
Dan Dmitri
140,000
35,000
Tarmo Tammel
110,000
45,000
Nico Jarnstrom
101,000
76,000
Robert Lim
100,000
47,000
Fang Shian
100,000
20,000
David Lappin
85,000
29,000
Phillip Huxley
50,000
5,000
Tsvetelina Pavlova
45,000
17,000
Demos Demosthenous
35,000
13,000
00:21 (UTC+2)
Start of Level 13 Blinds: 1,000/2,500 Ante: 2,500
Fourth Break Posted Friday 22nd April, 2022 at 00:01(UTC+2) by Jason Glatzer
Players are on a quick 15-minute break. The black 100-dominated chips will be runoff during the break.
Gokcek "Had a Set, Unfortunately" Posted Thursday 21st April, 2022 at 23:59(UTC+2) by Juhani Tyriseva
We found Ant Gokcek leaving his table, he looked to be a bit sad. "I had a set, my opponent had a two pair, aces and sixes when we moved in on the turn. The river was an ace and he made a bigger full house", reported Ant.
We naturally wait for Ant to show up tomorrow to play day 1B.
Player
Chips
Progress
Ant Gokcek
0
0
Janauskas Doubles with Sevens Posted Thursday 21st April, 2022 at 23:44(UTC+2) by Jason Glatzer
Dominykas Janauskas jammed for 22,600 with and was called by Velin Velinov with .
The Lithuanian's sevens held with the running out on the board, while Velinov lost a small portion of his big stack.
Player
Chips
Progress
Velin Velinov
120,000
95,000
Dominykas Janauskas
50,000
20,000
23:23 (UTC+2)
Start of Level 12 Blinds: 1,000/2,000 Ante: 2,000
Lappin Dusts Off Bezdek Posted Thursday 21st April, 2022 at 23:21(UTC+2) by Jason Glatzer
Anne Bezdek was on the rail but in good spirits. She shared with us the action which was confirmed by David Lappin.
A player opened before Anne Bezdek jammed for about 10,000. David Lappin cold-called and the original opener came along for the ride to see the flop. Lappin bet 7,000 which was good enough to get the other player to fold.
Bezdek turned over and still had some hope against Lappin's . Blanks hit the turn and river and Bezdek's Day 1a was over.
Player
Chips
Progress
David Lappin
130,000
74,000
Anne Bezdek
0
0
Ladies Good for Said Posted Thursday 21st April, 2022 at 23:08(UTC+2) by Jason Glatzer
Mathis Bouledin open-jammed for about 20 big blinds from under the gun and was called by Oliver Said from the hijack.
Mathis Bouledin:
Oliver Said:
Said's queens held after the ran out on the board to effectively double his stack while sending his opponent packing.
Player
Chips
Progress
Oliver Said
75,000
50,000
Mathis Bouledin
0
0
Some Familiar Faces Found Posted Thursday 21st April, 2022 at 23:05(UTC+2) by Juhani Tyriseva
In big event you do not find all players at once. Here are couple of faces we should have found a bit earlier.
Anne Bezdek.
David Lappin.
Nico Jarnstrom.
Robert Lim.
Late Registration Closed - 49 Players Advance Posted Thursday 21st April, 2022 at 22:45(UTC+2) by Jason Glatzer
Late registration is closed with the start of Level 11. A total of 49 players will advance to Day 2 from the Day 1a field with at least a min-cash locked up. The amount of the min-cash will be revealed on Sunday after all the opening flights have been played.
Unfortunately, Jackie Cachia, also known as Poker Mama around Malta, was not one of those players. She shared that she busted just before the dinner break after running her nines against aces against what she perceived to be a very aggressive player.
Player
Chips
Progress
Jackie Cachia
0
0
22:37 (UTC+2)
Start of Level 11 Blinds: 800/2,000 Ante: 2,000
Straight for Jankauskas Posted Thursday 21st April, 2022 at 22:34(UTC+2) by Jason Glatzer
Dominykas Janauskas committed his stack with on the turn with the board holding both the nut straight and a flush draw and had his opponent in Alessandro Siena drawing dead with .
The inconsequential paired the board and Janauskas doubled his stack.
Player
Chips
Progress
Dominykas Janauskas
70,000
45,000
Alessandro Siena
55,000
30,000
Straight Flush After Dinner Break for Calleja Posted Thursday 21st April, 2022 at 22:16(UTC+2) by Jason Glatzer
Straight after the dinner break, Brian Calleja bet 3,800 into a pot of around 10,000 with the on the board and got a call.
Calleja turned over with a big smile on his face for a straight flush and is up to 145,000 in chips.
Player
Chips
Progress
Brian Calleja
145,000
45,000
22:16 (UTC+2)
Start of Level 10 Blinds: 600/1,200 Ante: 1,000
Dinner Break Posted Thursday 21st April, 2022 at 20:35(UTC+2) by Jason Glatzer
Players are on a 75-minute dinner break. We will update some of the bigger stacks around the room during the break.
Squuillaci's Ace Ten Gets There for a Double Posted Thursday 21st April, 2022 at 20:15(UTC+2) by Jason Glatzer
Francesco Squillaci jammed for 13,300 from under the gun. The action folded around to Thibault Letort on the button who asked for a count before coming in over the top for 16,500. The players in the blinds folded and players were asked to show their hands.
Francesco Squillaci:
Thibault Letort:
Squillaci was behind when the chips went in but that didn't last for long after his ten paired up on the flop. Neither the turn nor the river helped Letort get back into the hand and he was left on fumes while doubling his opponent.
Player
Chips
Progress
Francesco Squillaci
29,100
4,100
Thibault Letort
2,200
22,800
Fun Turbo Bounty Tournament Begins in Less Than an Hour Posted Thursday 21st April, 2022 at 20:07(UTC+2) by Jason Glatzer
Players on the rail have been chatting about an upcoming event in the €120 Bounty the Night event at 9 p.m.
The action begins with players starting with 15,000 in chips. The event is a turbo-charged affair with 15-minute blind levels. Among those already registered are Tony Bedford, Paolo Bucci, Robert Boon, and Robert Aigro.
20:03 (UTC+2)
Start of Level 9 Blinds: 500/1,000 Ante: 1,000
Big Slick for Van Wersch to Felt Lien Posted Thursday 21st April, 2022 at 20:02(UTC+2) by Jason Glatzer
Raoul Van Wersch four-bet from late position to 16,200. Lasse Lien five-bet jammed for 53,000 and Van Wersch asked for a count.
The dealer initially counted 46,600 before Lien said it was more. The dealer recounted twice more before the jam was confirmed to be 53,000. Van Wersch tanked for about another minute before he found a call.
Lasse Lien:
Raoul Van Wersch:
Lien said "nice hand" to his opponent after he bricked the board and at least for now ran out of chips.
Meanwhile, Van Wersch won a huge pot to catapult his stack into one of the biggest in the room.
Player
Chips
Progress
Raoul Van Wersch
130,000
105,000
Lasse Lien
0
0
19:43 (UTC+2)
Start of Level 8 Blinds: 400/800 Ante: 800
Assorted Chip Counts Posted Thursday 21st April, 2022 at 19:36(UTC+2) by Jason Glatzer
Player
Chips
Progress
Robert Lim
72,000
47,000
Tarmo Tammel
65,000
40,000
Nico Jaernstroem
61,000
36,000
David Lappin
56,000
16,000
Demos Demosthenous
55,000
30,000
Lasse Lien
47,000
47,000
Mateusz Moolhuizen
38,000
13,000
Mario Corso
30,000
5,000
Tsvetelina Pavlova
28,000
3,000
Ilkka Heikkila
25,000
0
Bart Boris Kuider
12,000
13,000
Fang Shiyan
12,000
13,000
No Broadway for Emmi Posted Thursday 21st April, 2022 at 19:30(UTC+2) by Juhani Tyriseva
Emmi Juutilainen is well known finnish poker blogger, who this time decided to try her luck at the tables. "My day was really difficult, I did not hit any flops, so I kept myself alive with couple of small bluffs. The structure is quite quick so good hands are also needed, but today was not my day. So decided to move all in from cutoff with my 7000 chips stack, when I got
My opponent in big blind woke up with and my 3-outer did not make any progress", reported Emmi.
Player
Chips
Progress
Emmi Juutilainen
0
0
"Would You Have Called a Small River Bet?" Posted Thursday 21st April, 2022 at 19:25(UTC+2) by Jason Glatzer
Phillip Huxley called a bet of 2,300 by Paul Amsellem with the on the board with 8,000 already in the pot.
Amsellem checked the river and Huxley tanked for about 30 seconds before checking back. Amsellem turned over which wasn't good enough to beat Huxley who held .
"Would you have called a small bet?" Huxley asked his opponent.
His opponent shared that he wasn't sure as the dealer began to deal the next hand.
Player
Chips
Progress
Phillip Huxley
45,000
18,000
Paul Amsellem
15,000
10,000
Rudau Stacking Up Posted Thursday 21st April, 2022 at 18:57(UTC+2) by Jason Glatzer
Three players checked theflop with 6,000 in the pot before Kfir Zohar checked theturn. Patrick Rudau, who already had a big stack in front of him, fired out for 3,600. Pinchas Yechezkel folded and Zohar called.
Thecompleted the board and Zohar check-called a bet of 4,500. We will likely never know whether Rudau's bet was for thin value or to scare away hands ahead of him as he showed. This was good enough to beat the ace-high hero called made by Zohar to win the hand.
Player
Chips
Progress
Patrick Rudau
90,000
65,000
Kfir Zohar
23,000
2,000
18:37 (UTC+2)
Start of Level 7 Blinds: 300/600 Ante: 600
Over 300 Entries Posted Thursday 21st April, 2022 at 18:34(UTC+2) by Jason Glatzer
The Day 1a field has already peaked above 300 entries. It is possible that this will be bigger than the record-breaking 2019 Battle of Malta Main Event when Day 1a attracted 333 entries.
Second Break Posted Thursday 21st April, 2022 at 18:18(UTC+2) by Jason Glatzer
Day 1a is on its second 15-minute break of the day.
Four Card Action Begins Posted Thursday 21st April, 2022 at 17:55(UTC+2) by Jason Glatzer
The €220 Pot-Limit Omaha side event has kicked off with 69 entries and counting.
17:44 (UTC+2)
Start of Level 6 Blinds: 200/500 Ante: 500
Unlucky Jacks for De Jong Posted Thursday 21st April, 2022 at 17:42(UTC+2) by Jason Glatzer
Dehlia De Jong three-bet jammed the button for 5,000 over an opener and a couple of callers. Brian Calleja cold-called from the small blind before Alfredo Pagliaro called off his stack of around 4,500. The rest of the table folded and the three players turned over their cards.
Alfredo Pagliaro:
Dehlia De Jong:
Brian Calleja:
Pagliaro had the least equity in the hand but that all changed after he spiked a set on the flop. De Jong fell behind in the side pot as well after the turn paired up Calleja's king. The river didn't save De Jong and she was one of the latest casualties on Day 1a.
Calleja shared with us after the hand that just before we got to the table he eliminated two players at once to become one of the bigger stacks in the room.
Player
Chips
Progress
Brian Calleja
100,000
55,000
Matuesz Moolhuizen
25,500
500
Alfredo Pagliaro
17,000
3,000
Dehlia De Jong
0
0
17:32 (UTC+2)
Start of Level 5 Blinds: 200/400 Ante: 400
More Familiar Faces Posted Thursday 21st April, 2022 at 17:12(UTC+2) by Juhani Tyriseva
224/268 players in tables right now. Here some more familiar faces.
Lasse Lien Kleive
Hilel Nimrod
Kyriakos Papadopoulos
Mario Corso
17:04 (UTC+2)
Start of Level 4 Blinds: 100/300 Ante: 300
Pagliaro Doubles Through Harmann Posted Thursday 21st April, 2022 at 17:03(UTC+2) by Jason Glatzer
Three players checked the flop with 8,000 in the pot. Brian Calleja checked the turn before Alfredo Pagliaro jammed for 6,000. Benjamin Harmann called and Calleja sighed before he folded.
Alfredo Pagliaro:
Benjamin Harmann:
Harmann had some outs to potentially bust his opponent with his open-ended straight draw. Pagliaro was able to hold and even improved to trip queens after the completed the board on the river.
Player
Chips
Progress
Benjamin Harmann
45,000
20,000
Brian Calleja
45,000
10,000
Alfredo Pagliaro
20,000
5,000
Some Familiar Faces Posted Thursday 21st April, 2022 at 16:22(UTC+2) by Juhani Tyriseva
The field continues to grow with late registration not closing until the end of Level 10. Here is a look at some of the familiar faces from around the room.
Philip Huxley
Dehlia de Jong
Emmi Juutilainen.
Rikard Andersson.
Ant Gökcek.
First Break Posted Thursday 21st April, 2022 at 16:03(UTC+2) by Jason Glatzer
The Main Event is on its first 15-minute break.
Play to Win Event Begins Shortly Posted Thursday 21st April, 2022 at 16:00(UTC+2) by Jason Glatzer
The €110 Play to Win Event will kick off in just a few minutes at 4 p.m. There were already 47 entries with many more to come before late registration closes.
Straight for Lappin Posted Thursday 21st April, 2022 at 15:50(UTC+2) by Jason Glatzer
Marius Morel and David Lappin both checked after the turn with the on the board. Morel led out for 5,000 into a pot of 13,000 after the river completed the board.
Morel turned over but his rockets were no good despite flopping the nut flush draw as Lappin rivered a straight with to take down the pot.
Player
Chips
Progress
David Lappin
40,000
15,000
Marius Morel
23,000
2,000
Passias Leaves LaMonica on Fumes Posted Thursday 21st April, 2022 at 15:39(UTC+2) by Jason Glatzer
Stavros Passias check-jammed the turn with the on the board for 13,100 and was called by Andrea LaMonica.
Stavros Passias:
Andrea LaMonica:
Passias was miles ahead and only had to sweat four outs that LaMonica could hit to improve to a full house. A blank completed the board on the river for Passias to double his stack while leaving LaMonica short on chips.
Player
Chips
Progress
Stavros Passias
40,000
15,000
Andrea LaMonica
3,000
22,000
15:25 (UTC+2)
Start of Level 3 Blinds: 100/200 Ante: 200
Calleja Felts McCormack Posted Thursday 21st April, 2022 at 15:22(UTC+2) by Jason Glatzer
Francis McCormack jammed into a bloated pot with the on the board and was called by Brian Calleja.
McCormack turned over for trip aces. This didn't get the job done and McCormack will have to re-enter for a shot at advancing to Day 2 after Calleja turned over for a straight.
Meanwhile, the field has grown to 207 entries with 200 players remaining near the end of Level 2.
Player
Chips
Progress
Brian Calleja
55,000
30,000
Francis McCormack
0
0
Three Early Eliminations Posted Thursday 21st April, 2022 at 15:11(UTC+2) by Jason Glatzer
Karl Groendal was the first player eliminated at the 2022 Battle of Malta Main Event. Paolo Bucci and Piotr Rekawiecki also hit the rail soon after. All three players have plenty of chances to get back into the mix with unlimited re-entries allowed during the first 10 blind levels during each of the five starting days.
Player
Chips
Progress
Piotr Rekawiecki
0
0
Paolo Bucci
0
0
Karl Groendal
0
0
181 Entries Posted Thursday 21st April, 2022 at 14:50(UTC+2) by Jason Glatzer
The field has already grown to 181 entries to start Level 2 with all players still in their seats.
14:50 (UTC+2)
Start of Level 2 Blinds: 100/100 Ante: 100
Early Jam by Tavoularis Posted Thursday 21st April, 2022 at 14:24(UTC+2) by Jason Glatzer
Three players checked with more than 6,000 in the pot after the came on the flop. Bayram Nabit also checked the turn before Georgios-Angelos Tavoularis fired out for 4,000. Aleksandar Stojadinovic folded and Nabit called.
Nabit checked the river. Tavoularis jammed and won an early pot after Nabit folded.
Player
Chips
Progress
Georgios-Angelos Tavoularis
35,000
10,000
Bayram Nabit
19,000
6,000
Check Out the Battle of Malta Trophies Posted Thursday 21st April, 2022 at 14:03(UTC+2) by Juhani Tyriseva
Here are the nice trophies of the Battle of Malta events. Maybe one of these is yours after this week?
The Action Begins! Posted Thursday 21st April, 2022 at 14:03(UTC+2) by Jason Glatzer
After a brilliant introduction, cards are in the air with a starting field of 102 entries for Day 1a of the Battle of Malta Main Event.
Here is a look at some of the players already in the field.
Player
Chips
Progress
Matuesz Moolhuizen
25,000
0
Gavin Roberts
25,000
0
Emmi Juutilainen
25,000
0
Kaidar Viikman
25,000
0
Cristian Vornicu
25,000
0
Massimiliano Piazza
25,000
0
Ant Gokcek
25,000
0
Michael Spang
25,000
0
Francis McCormack
25,000
0
Rasmus Parts
25,000
0
Jackie Cachia
25,000
0
Kevin Malone
25,000
0
Dehlia De Jong
25,000
0
Phillip Huxley
25,000
0
12:56 (UTC+2)
Start of Level 1 Blinds: 100/100 Ante: 0
Welcome to the €500K GTD Battle of Malta Main Event Posted Thursday 21st April, 2022 at 12:55(UTC+2) by Jason Glatzer
Welcome to the 2022 Battle of Malta at the Casino Malta by Olympic Casino and the InterContinental Hotel.
The festival features something for everyone with 25 action-packed events. Our coverage will focus on the highlight of the festival in the €500,000 guaranteed Battle of Malta €555 Main Event while sprinkling in updates about the side events.
The Main Event boasts five opening flights from April 21-24 with players kicking off the action with a healthy stack of 25,000 in chips. The first three flights feature 40-minute blind levels with the final two flights playing faster with 20-minute blind levels.
Players will have plenty of opportunities to build a monster stack with unlimited re-entries permitted during each of the five opening flights until the end of Level 10.
Each opening flight concludes when the field is trimmed down to 15 percent with all advancing players already in the money. Players can re-enter even if they bag a stack with the biggest stack moving forward.
Surviving opening flight players will then compete for three more days from April 24-26 until the 2022 winner is crowned.
The Main Event kicks off at 2 p.m. CEST. Stay tuned for updates, photos, and more throughout the 2022 Battle of Malta.
Brief History of the Battle of Malta
The festival has a long and storied tradition dating back to 2012 when Nicodemo Piccolo navigated through a field of 349 entries to win the first Battle of Malta Main Event title for €35,000.
The event grew each year until the COVID pandemic moved the event online at GGPoker in 2020 and 2021. Players are thrilled that the Battle of Malta has returned to its home to the majestic island of Malta for what promises to be another thrilling festival.
Year
Entries
Prize Pool
Winner
Prize
2012
349
€ 169,265
Nicodemo Piccolo
€ 35,000
2013
888
€ 430,680
Louis Cartarius
€ 68,000
2014
1,447
€ 701,795
Antoan Katsarov
€ 122,750
2015
1,804
€ 875,000
Nicolas Proust
€ 110,000
2016
1,813
€ 879,305
Robert Berglund
€ 160,000
2017
2,074
€ 1,005,890
Nadav Lipszyc
€ 200,000
2018
3,816
€ 1,850,760
Julien Stropoli
€ 168,500
2019
4,657
€ 2,258,645
Serghei Lisii
€ 247,167
2020
8,789
$4,592,252
Rodrigo "Eureka!!" Selouan
$636,478
2021
6,591
€ 3,443,797
"raggaz"
€ 378,285
2022 Battle of Malta Schedule
Player
Chips
Progress
Kevin Malone
25,000
0
Jackie Cachia
25,000
0
Rasmus Parts
25,000
0
Francis McCormack
25,000
0
Michael Spang
25,000
0
Ant Gokcek
25,000
0
Massimiliano Piazza
25,000
0
Cristian Vornicu
25,000
0
Kaidar Viikman
25,000
0
Emmi Juutilainen
25,000
0
Gavin Roberts
25,000
0
Phillip Huxley
25,000
0
11:14 (UTC+2)
Day 1A of Battle of Malta 2022 Started Level: ?1 Blinds: 0/0 Ante: 0
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
and the opponent called behind with 
did not help Manfred, so he was the bubble boy. 
and Domenico Gala did not hesitate with 
and moved his chips to the middle as well.
did not help Petruzelli, and Gala doubled up.
on the board after the turn. Andrea Stellata jammed over the top and Petruzzelli asked for a count. The dealer confirmed it was for 216,000 and shortly after, Petruzzelli, who barely had his opponent covered, made the call.
completing the board.
and now everybody decided to check.
and now Massimo decided to bet 17000, Carmelo took his time and called, Raoul folded quickly.
which was enough to win the pot, when Carmelo was a bit shocked to see this legendary hand.
Fang made a continuation bet, Feliciano called.
were in the lead against Jonathans 
.
running out on the board, while Velinov lost a small portion of his big stack.
flop. Lappin bet 7,000 which was good enough to get the other player to fold.
and still had some hope against Lappin's 
. Blanks hit the turn and river and Bezdek's Day 1a was over.
which wasn't good enough to beat Huxley who held 
