0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0069 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/1/10/updates'
ORDER BY `views` DESC
0.0005 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '1'
0.0065 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '1'
0.0262 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` = '1'
AND `published` = 1
0.0261 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0053 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '4'
AND `published` = 1
0.0267 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '5'
AND `published` = 1
0.0666 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '7'
AND `published` = 1
0.0261 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '9'
AND `published` = 1
0.0663 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '10'
AND `published` = 1
0.0259 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0040 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '11'
AND `published` = 1
0.0680 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` = '12'
AND `published` = 1
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '10'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '10'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '443'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '442'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '441'
ORDER BY `chip_change` DESC, `busted` ASC
0.0464 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '440'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '439'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '438'
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` = '436'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '434'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '435'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '433'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '432'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '431'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '430'
ORDER BY `chip_change` DESC, `busted` ASC
0.0467 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '429'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '428'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '427'
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` = '426'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '425'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '423'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '424'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '421'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '419'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '418'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '417'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '416'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '415'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '414'
ORDER BY `chip_change` DESC, `busted` ASC
0.0156 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '413'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '412'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '411'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '410'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '409'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '408'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '407'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '406'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '405'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '403'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '402'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '401'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '400'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '399'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '398'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '397'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '396'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '395'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '394'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '393'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '392'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '391'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '390'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '389'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '388'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '387'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '386'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '385'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '384'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '383'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '382'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '380'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '381'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '379'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '378'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '377'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '376'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '375'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '373'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '10'
ORDER BY `busted` ASC, `current_chips` DESC
0.0050 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` = '10'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '443'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '442'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '441'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '440'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '439'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '438'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '437'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '436'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '434'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '435'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '433'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '432'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '431'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '430'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '429'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '428'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '427'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '426'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '425'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '423'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '424'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '421'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '419'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '418'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '417'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '416'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '415'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '414'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '413'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '412'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '411'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '410'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '409'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '408'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '407'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '406'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '405'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '403'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '402'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '401'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '400'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '399'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '398'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '397'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '396'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '395'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '394'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '393'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '392'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '391'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '390'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '389'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '388'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '387'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '386'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '385'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '384'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '383'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '382'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '380'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '381'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '379'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '378'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '377'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '376'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '375'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '373'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '12'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1231
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Battle of Malta 2019
Main Event
Live Reporting - Day 4
Current Level
37 Current Day
4 Blinds
400,000/800,000 Ante
800,000
Entries
4,657 Remaining
1 Prize Pool (EUR)
€2,258,645 First Prize (EUR)
€306,205
Day 2 of Battle of Malta 2019 Ended Level: 23 Blinds: 15000/30000 Ante: 30000
88 Players Advance to Battle of Malta Main Event Day 3 Posted Monday 21st October, 2019 at 01:19(UTC+2) by Chris Martin
Day 2 in the largest Battle of Malta Main Event in history is officially in the books with just 88 players remaining.
688 players started the day, all guaranteed €1,100 and the remaining players have all locked up €2,260. Day 3 (Monday) is scheduled to play down to a final table, with a whopping €306,205 awaiting the winner - not bad for a €500 tournament!
Notable players through to Day 3 include Ludovic Geilich (pictured above), Dehlia de Jong, Steven van Zadelhoff, Leo Worthington-Leese and Daragh Davey.
Place
Payout (EUR)
1
€ 306,205
2
€ 158,130
3
€ 102,050
4
€ 74,540
5
€ 56,470
6
€ 42,910
7
€ 33,880
8
€ 27,100
9
€ 24,620
Several notable players bust on Day 2 including the early eliminations of Dara O'Kearney (666th - €1,100) who lost out with ace-king against ace-jack.
Other notables to bust in the money include Ana Marquez (649th - €1,100), former Premier League footballer Jimmy Kebe (533rd - €1260), Fraser MacIntyre (494th - €1,330), Jon Kyte (477th - €1,330), Ian Simpson (466th - €1,330), David Lappin (402nd - €1,470), Andy Hills (335th - €1,540), Daiva Byrne (308th - €1,630), Mateusz Moolhuizen (287th - €1,720) and start-of-day chip leader Dario Marinelli (268th - €1,720).
The surviving players will return tomorrow (Monday) at 1 p.m. to play down to a final table. Stay tuned to the official Battle of Malta live updates right here to keep across all of the action.
Final Three Hands Posted Monday 21st October, 2019 at 01:04(UTC+2) by Gia Carnestorm
With the Day 2 action nearing its conclusion, the draw has been made that three more hands will be played.
River Delight for Halevi Posted Monday 21st October, 2019 at 01:01(UTC+2) by Gia Carnestorm
The flop fell , and Gal Halevi was all in from the big blind for 450,000 after check-raising.
Mehmet Ongorur thought for a minute, then called and was ahead.
Halevi:
Ongorur:
The turn kept Ongorur in the lead, but the river gave Halevi top pair.
Halevi moved up to 1m despite being on the brink of elimination, and Ongorur was reduced to 1.2m.
Player
Chips
Progress
Mehmet Sirin Ongorur
1,200,000
100,000
Gal Halevi
1,000,000
916,000
Braco Escapes on the River Posted Monday 21st October, 2019 at 00:40(UTC+2) by Gia Carnestorm
Pasquale Braco was all in, and Marc Mijnheer called.
Braco:
Mijnheer:
Board:
Mijnheer was all set to eliminate Braco when the flop and turn cards fell, but the river saw Braco win with the higher kicker alongside two pair.
Player
Chips
Progress
Pasquale Braco
750,000
584,000
Marc Jan Mijnheer
600,000
850,000
Laura chats to Malta-based Dutch pro Steven van Zadelhoff Posted Monday 21st October, 2019 at 00:37(UTC+2) by Chris Martin
00:15 (UTC+2)
Start of Level 23 Blinds: 15000/30000 Ante: 30000
Break Posted Sunday 20th October, 2019 at 23:39(UTC+2) by Chris Martin
Players are going on their final 20 minute break of the night.
When they return the blinds will be 15,000/30,000 and players will be just 60 mintues
Shishkov Eliminated by Ichiyo Posted Sunday 20th October, 2019 at 23:37(UTC+2) by Gia Carnestorm
Borislav Shishkov was all in, and Niwa Ichiyo called.
Shishkov:
Ichiyo:
Board:
Ichiyo was way ahead with pocket tens and held to score the knockout ahead of the final break of Day 2.
Player
Chips
Progress
Ichiyo Niwa
1,300,000
915,000
Borislav Tonev Shishkov
0
0
Table 10 Has the Chips! Posted Sunday 20th October, 2019 at 23:19(UTC+2) by Gia Carnestorm
Cedric Schwaederle and Pedro Domenech are rising on Table 10.
Schwaederle is sitting on 2.3m, while Domenech is on 2.4m in level 22.
Player
Chips
Progress
Cedric Brice Eric Schwaederle
2,300,000
700,000
Pedro Ivars Domenech
0
1,600,000
Updated Chip Counts Posted Sunday 20th October, 2019 at 23:16(UTC+2) by Chris Martin
Player
Chips
Progress
David Lund
1,100,000
0
Karl Fredrik Ellingsson
1,100,000
300,000
Ricardo Manuel Freire Mateus
1,100,000
10,000,000
Sebastian Whal
1,080,000
0
Mr Karim Aouam
1,060,000
0
Mirco Ferrini
1,030,000
20,000
Alberto Cigliano
1,000,000
0
Valerii Firstenko
1,000,000
0
Ignazio D'Angelo
1,000,000
0
Salvatore Montagna
1,000,000
0
Ludovic Geilich
990,000
0
Jacob Dideriksen-Nielsen
980,000
0
Lars Greger Larsson
950,000
0
Antonio Alba
940,000
0
Valentin-Marius Cristea
900,000
0
Alberto Santoro
900,000
0
Niko Pakalen
845,000
155,000
Catalin Geangos
800,000
0
Francesco Gasparr
750,000
0
Alexandra Niculae
700,000
0
Re Gabriele
100,000
466,000
Calderone Departs Posted Sunday 20th October, 2019 at 23:04(UTC+2) by Gia Carnestorm
Giovanni Calderone was all in, and Paolo Infantino called.
Calderone:
Infantino:
Board:
There was no way back for Calderone, and he departed during level 22.
Player
Chips
Progress
Paolo Infantino
700,000
0
Giovanni Calderone
0
0
Kyte Leads After High Roller Day 1 Posted Sunday 20th October, 2019 at 22:38(UTC+2) by Chris Martin
Day 1 of the Battle of Malta High Roller has concluded with 103 of 266 players remaining. John Kyte bagged the chip lead with 206,100 from a 25,000 starting stack.
He is clear of Mateusz Sebastian Wozniak (186,000) in second place before a whole host of players including Itay Ben Mergy (147,700), Yazan Mdanat (144,100) and Hysaj Eljano (143,600).
Other notables through to Day 2 include Andrew Christoforou (131,000), Fraser MacIntyre (92,500), Sandro Pitzanti (86,000), Ian Simpson (79,000), Martin Jacobson (63,900), Mateusz Moolhuizen (54,300), Fabrice Soulier (43,400), Andy Hills (25,000), Dara O'Kearney (24,100), Jimmy Kebe (24,000) and Sofia Lovgren (17,700).
Eliminations on Day 1 included Ana Marquez, Jonathan Therme, Alex Dreyfus, David Lappin, Georgios Zisimopoulos, Fraser Macintyre and Jamila von Perger.
Late registration is open for ten levels, so players will have one more level tomorrow to jump into the High Roller.
22:32 (UTC+2)
Start of Level 22 Blinds: 10000/25000 Ante: 25000
Download the Battle of Malta App Posted Sunday 20th October, 2019 at 22:28(UTC+2) by Chris Martin
Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting the website below:
Updated Big Stacks Posted Sunday 20th October, 2019 at 22:25(UTC+2) by Chris Martin
Player
Chips
Progress
Ricardo Manuel Freire Mateus
11,100,000
10,943,500
Andre Scerri
1,900,000
550,000
Leo Jean Jaques Adrien Lombardozzi
1,850,000
800,000
Gulas Josef
1,680,000
20,000
Hassan Aku Robert Sey
1,610,000
460,000
Hagai Ben Yair
1,600,000
1,220,000
Cedric Brice Eric Schwaederle
1,600,000
650,000
Marc Jan Mijnheer
1,450,000
400,000
Steven Van Zadelhoff
1,430,000
630,000
Mats Gustav Villern Karlsson
1,400,000
350,000
Csaba Kovacs
1,400,000
350,000
Andrew James Middleton
1,340,000
10,000
Enrico Grella
1,330,000
345,000
Giuseppe Grimaldi
1,300,000
1,173,500
Mario Ripepi
1,300,000
350,000
Louis Karam
1,300,000
200,000
Dwayne Jeremy Sluis
1,300,000
150,000
Charalampos Lappas
1,200,000
1,121,000
Vytenis Salickas
1,200,000
500,000
Mr Walter Lustenberger
1,200,000
200,000
Tiziano Di Romualdo
1,200,000
100,000
Maksims Azarjancs
1,100,000
250,000
Gulas Keeps Going Posted Sunday 20th October, 2019 at 22:24(UTC+2) by Gia Carnestorm
The flop was down , and Josef Gulas checked from middle position.
Amit Cohen bet 125,000 from the cutoff, and Gulas moved all in.
Cohen was covered but made the call after a minute in the tank.
Gulas revealed for two pair, and Cohen showed .
The turn and river saw Cohen eliminated, and Gulas moved up to 2.4m.
Player
Chips
Progress
Gulas Josef
2,400,000
700,000
Amit Cohen
0
0
Papotto Unhappy at Bust; De Cesare More Than Doubles Posted Sunday 20th October, 2019 at 22:17(UTC+2) by Chris Martin
Shaun De Cesare opened to 65000 and Emiliano Papotto three-bet all in for 380,000. Vytenis Salickas then four-bet all in and De Cesare tanked for four minutes before calling.
Shaun De Cesare: Emiliano Papotto: Vytenis Salickas:
The runout caused a swearing Papotto to be eliminated, receiving a warning from the tournament officials on his way to be paid.
Player
Chips
Progress
Shaun De Cesare
1,400,000
1,279,000
Vytenis Salickas
700,000
298,000
Emiliano Papotto
0
0
Gonzalez in the Lead Posted Sunday 20th October, 2019 at 22:15(UTC+2) by Chris Martin
As players retake their seats after dinner it is Victor Gonzalez who appears to be in the chip lead with 173 players remaining.
He sits with 2,400,000 in chips and the RedStar qualifier looks to be in a strong position with just three levels remaining in the day.
Player
Chips
Progress
Victor Feu Gonzalez
2,400,000
1,200,000
22:13 (UTC+2)
Start of Level 21 Blinds: 10000/20000 Ante: 20000
Dinner Break Posted Sunday 20th October, 2019 at 20:28(UTC+2) by Chris Martin
With 174 players remaining on Day 2 of the Battle of Malta Main Event players are heading off on a 75-minute dinner break.
When they return there will be three more levels before players bag up ahead of Day 3.
Gulas Rises High Posted Sunday 20th October, 2019 at 20:28(UTC+2) by Gia Carnestorm
Ludovic Geilich raised to 32,000 from under the gun, and Alessandro Barone called from middle position.
Josef Gulas raised to 150,000 from the big blind, and Geilich folded.
With 200,000 behind, Barone went into the tank for over 90 seconds but opted to fold.
Gulas added to his big stack and moved up to 1.7m.
Player
Chips
Progress
Gulas Josef
1,700,000
850,000
Ludovic Geilich
520,000
363,000
Alessandro Barone
200,000
79,000
Check out Laura's interview with Betsson Ambassador Daiva Byrne Posted Sunday 20th October, 2019 at 20:15(UTC+2) by Chris Martin
Faraj Hits Runner-Runner Straight to Survive Posted Sunday 20th October, 2019 at 20:00(UTC+2) by Gia Carnestorm
Abraham Faraj, playing from the hijack, and Geb Nell, in the small blind, got all their chips into the middle pre-flop with Faraj, the player at risk.
Faraj:
Nell:
Board:
Nell clenched his fist in celebration when he saw his holding improved to top set on the flop.
Another player pointed at the jack on the turn to signal Faraj's outs to the straight, and when the queen hit on the river, Faraj had sealed a shock comeback to double.
Player
Chips
Progress
Abraham Benitez Faraj
740,000
358,000
Geb. Mushold Nell
190,000
129,000
Huge thanks to Copag Posted Sunday 20th October, 2019 at 19:57(UTC+2) by Chris Martin
Battle of Malta would like to say a huge thanks to Copag, Official Card Provider of both the 2018 and 2019 events. Copag, which is also the official supplier for the World Series of Poker, supplied 1,000 decks to BOM this year.
Cristina Pietricola (pictured above), dealer inspector for Casino Malta, loves Copag cards calling them “absolutely perfect” for both big events and player home games.
High Roller Update Posted Sunday 20th October, 2019 at 19:52(UTC+2) by Chris Martin
The Battle of Malta High Roller is midway through Level 7 with 135 of 253 players remaining.
With an average stack of around 45,000, both Jon Kyte (100,000) and Andrew Christoforou (110,000) are in strong positions. Ian Simpson (55,000) is also sitting on double starting stack.
Ana Marquez sits on around starting stack, with David Lappin (pictured), Dara O'Kearney, Fraser Macintyre and Alex Dreyfus all sitting on shorter stacks.
A reminder that late registration and re-entry is open for ten levels.
Catalfamo Eliminated by Ellingsson Posted Sunday 20th October, 2019 at 19:43(UTC+2) by Gia Carnestorm
Short stack Giovanni Catalfamo was all in, and Karl Ellingsson had called.
The board was down and in front of Ellingsson was for two pair.
Catalfamo held for ace-high and hit the rail.
Player
Chips
Progress
Karl Fredrik Ellingsson
1,400,000
670,000
Giovanni Catalfamo
0
0
19:29 (UTC+2)
Start of Level 20 Blinds: 8000/16000 Ante: 16000
Da-Silva Forced to Move with One Single Chip Posted Sunday 20th October, 2019 at 19:24(UTC+2) by Gia Carnestorm
Chris Da-Silva was on the move and had a chip rack with just a single 1,000 chip.
On his way to the new table, Da-Silva retold the story of his demise.
Da-Silva's opponent opened to 27,000 from the hijack and the Brit three-bet to 85,000.
There was then an all-in for close to 700,000, and Da-Silva called with pocket queens.
His opponent held , and when the ace hit on the turn, Da-Silva was left with just 1,000 to play with.
Will he be able to spin it back up? That remains to be seen.
Player
Chips
Progress
Chris Da-Silva
1,000
599,000
Pino Gets Rid of Brenseth Posted Sunday 20th October, 2019 at 19:14(UTC+2) by Chris Martin
Terje Humio Brenseth opened to 31,000 and Domenico Pino defended his big blind.
Pino checked the flop to his opponent who continued for 31,000. Pino check-raised to 77,000 and Brenseth called.
The turn was the . Pino bet 109,000 and after a short tank, Brenseth folded. Both players sit on around average stack which sits at just over 500,000 in chips.
Player
Chips
Progress
Domenico Pino
550,000
410,000
Terje Humio Brenseth
480,000
453,700
Gardner, Patel, Dempsey, Sammut, Byrne Bust Posted Sunday 20th October, 2019 at 18:50(UTC+2) by Gia Carnestorm
Former England footballer Anthony Gardner has recently hit the rail alongside Priti Patel, Shame Dempsey, Clint Sammut, and Daiva Byrne (pictured).
Player
Chips
Progress
Shane Dempsey
0
0
Patel Priti
0
0
Clint Sammut 1
0
0
Anthony Derek Gardner
0
0
Daiva Byrne
0
0
Sengun Survives and Laudani Doubles Posted Sunday 20th October, 2019 at 18:40(UTC+2) by Gia Carnestorm
Cuneyt Sengun was all in for just 15,000 from under the gun, and Flavio Laudani reshoved for 140,000 from middle position, and Daniele Degennaro called from the small blind.
Sengun:
Laudani:
Degennaro:
Board:
Sengun hit a pair on the flop to win the pot and survive, while Laudani won his flip to double.
Player
Chips
Progress
Daniele Degennaro
470,000
180,000
Flavio Laudani
300,000
88,000
Mr Cuneyt Laurent Sengun
50,000
51,500
2018 Final Tablist Moolhuizen & Start-of-Day Chip Leader Marinelli Eliminated Posted Sunday 20th October, 2019 at 18:39(UTC+2) by Chris Martin
Last year Mateusz Moolhuizen finished eighth in the Battle of Malta Main Event for €30,000, and had already guaranteed himself a cash after making it through to Day 2.
However, shortly before the last break he was eliminated, taking home €1,720.
Another elimination is start-of-day chip leader Dario Marinelli who also takes home €1,720.
Player
Chips
Progress
Mateusz Moolhuizen
0
0
Dario Marinelli
0
0
Big Stacks After the Break Posted Sunday 20th October, 2019 at 18:35(UTC+2) by Chris Martin
Player
Chips
Progress
Andrew James Middleton
1,350,000
1,142,000
Andre Scerri
1,350,000
845,500
Tiziano Di Romualdo
1,300,000
970,000
Victor Feu Gonzalez
1,200,000
725,000
Patrick Clarke
1,175,000
125,000
Dwayne Jeremy Sluis
1,150,000
882,000
Hassan Aku Robert Sey
1,150,000
475,000
Mehmet Sirin Ongorur
1,100,000
832,000
Tonio Marek Roeder
1,075,000
858,000
Csaba Kovacs
1,050,000
863,000
Leo Jean Jaques Adrien Lombardozzi
1,050,000
685,500
Mirco Ferrini
1,050,000
550,000
Marc Jan Mijnheer
1,050,000
333,000
Mats Gustav Villern Karlsson
1,050,000
275,000
Mr Walter Lustenberger
1,000,000
672,500
Niko Pakalen
1,000,000
230,000
Enrico Grella
985,000
692,000
Cedric Brice Eric Schwaederle
950,000
792,000
Mario Ripepi
950,000
50,000
Dimitrios Anastasakis
920,000
678,000
Michael Albert Schwartz
900,000
674,000
Daragh Davey
900,000
599,000
Sirile Puustusmaa
850,000
659,000
Gulas Josef
850,000
507,500
Maksims Azarjancs
850,000
130,000
Luca Bufarini
830,000
582,000
John Cahilll
800,000
576,000
Serghei Lisiii
800,000
542,500
Pedro Ivars Domenech
800,000
464,500
Michele Tocci
800,000
400,000
Jonathan Therme
720,000
350,000
Jeffrey Bar-Esh
525,000
409,500
18:26 (UTC+2)
Start of Level 19 Blinds: 6000/12000 Ante: 12000
Break Posted Sunday 20th October, 2019 at 18:09(UTC+2) by Gia Carnestorm
The players are now on break.
Battle of Malta - Intro to Day 2 Posted Sunday 20th October, 2019 at 18:06(UTC+2) by Chris Martin
Update from the High Roller Posted Sunday 20th October, 2019 at 17:41(UTC+2) by Chris Martin
There are currently 193 entries in the €1,300 Battle of Malta High Roller. Among those who are competing in after busting the Main Event are MainEventTravel CEO and EPT Madrid runner-up Fraser MacIntyre along with French pro Fabrice Soulier and award-winning podcasters Dara O’Kearney and David Lappin.
Malta-based blockchain entrepreneur and HendonMob Owner Alex Dreyfus (pictured below) is also competing, along with Italian Poker Tour champion Georgios Zisimopoulos, one of Greece’s all time top players.
Also playing are Crazy 888 champ Kevin Houghton, Andrew Christoforou, Peter Jaksland, Jimmy Kebe, 2018 WSOP finalist Antoine Labat, and Jamila von Perger (pictured above).
Player
Chips
Progress
Daniele Degennaro
470,000
180,000
Flavio Laudani
300,000
88,000
Mr Cuneyt Laurent Sengun
50,000
51,500
Spiteri Hits Quad Aces Posted Sunday 20th October, 2019 at 17:26(UTC+2) by Gia Carnestorm
Stephen Spiteri, in the big blind, and Jason Roberts, from middle position, were all in preflop for a pot worth 450,000.
Spiteri:
Roberts:
Board:
Spiteri had Roberts dominated and improved to top set on the flop.
Spiteri found quad aces on the turn to seal his double up, and Roberts was reduced to 160,000.
Player
Chips
Progress
Stephen Spiteri
450,000
395,000
Jason Roberts
160,000
119,000
Hills Eliminated by Tiurin Posted Sunday 20th October, 2019 at 17:23(UTC+2) by Chris Martin
Earler Andy Hills lost a chunk of his chips to Mario Ripepi and he now found himself all in with against the of Petr Tiurin.
The board was giving no help to Hills who was eliminated.
Player
Chips
Progress
Petr Tiurin
725,000
150,000
Andrew Christopher Hills
0
0
Grech Flops a Boat to Eliminate Samson Posted Sunday 20th October, 2019 at 17:21(UTC+2) by Chris Martin
Neville Grech opened from early position and called a shove from Daniel Samson for 93,000.
Neville Grech: Daniel Samson:
The flop gave Grech a full house and there was no miracle comeback on the runout and Samson was eliminated.
Player
Chips
Progress
Neville Grech
500,000
273,000
Daniel Samson
0
0
17:11 (UTC+2)
Start of Level 18 Blinds: 5000/10000 Ante: 10000
Versace Eliminated Posted Sunday 20th October, 2019 at 17:06(UTC+2) by Gia Carnestorm
Vladas Burneikis, from the hijack, and Domenico Versace, in the big blind, got all their chips into the middle, with Burneikis, the player at risk.
Burneikis:
Versace:
Board:
Burneikis found a way to hit the nut flush on the turn to survive, and Versace was left with 10,000.
Just moments later, Versace hit the rail.
Player
Chips
Progress
Vladas Burneikis
210,000
65,000
Domenico Versace
0
0
Clarke Over a Million Posted Sunday 20th October, 2019 at 16:51(UTC+2) by Chris Martin
Action was on a river and Jonathan Therme bet 110,000. Patrick Clarke was in the seat directly to his left and snap-called.
Therme confidently turned over for two pair, with Clarke showed for a better two pair having hit his ace on the river.
Player
Chips
Progress
Patrick Ignatius Clarke
1,050,000
130,000
Jonathan Therme
370,000
150,000
Ripepi Doubles Through Hills; Savio Eliminated Posted Sunday 20th October, 2019 at 16:49(UTC+2) by Chris Martin
Mario Ripepi was having a double up counted out with Damir Savio getting to his feet having been eliminated.
Savio held 40,000 with and was way behind the of Andy Hills and the of Ripepi.
The board read and aces held to double to over 700,000 in chips.
Player
Chips
Progress
Mario Ripepi
750,000
701,000
Andrew Christopher Hills
235,000
80,000
Damir Savio
0
0
Lappin, Gjersvold, & Bennacer Hit the Rail Posted Sunday 20th October, 2019 at 16:47(UTC+2) by Gia Carnestorm
Among the recent players to depart are David Lappin (pictured), Lars Gjersvold, and Nassim Bennacer.
Player
Chips
Progress
Nassim Bennacer
0
0
Lars Niklas Gjersvold
0
0
David Lappin
0
0
Ruiu Takes a Knock Posted Sunday 20th October, 2019 at 16:47(UTC+2) by Chris Martin
Cristian Ruiu opened to 18,000 and Emiliano Papotto defended his big blind.
The flop came and both players checked. Papotto bet on the turn and Ruiu called.
Papotto bet 34,000 on the river and Ruiu tank-called. Ruiu showed for trip sixes and Ruiu mucked.
Player
Chips
Progress
Cristiano Ruiu
725,000
25,000
Emiliano Papotto
200,000
7,000
Download the Battle of Malta App Posted Sunday 20th October, 2019 at 16:33(UTC+2) by Chris Martin
Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting the website below:
Versace Splits to Survive Posted Sunday 20th October, 2019 at 16:30(UTC+2) by Gia Carnestorm
A raise to 18,000 came in from Antonio Alba in early position, and Vladas Burneikis called from the next seat. Domenico Versace moved all in for 67,000 after the action folded around, and Alba went into the tank.
After a minute passed, he folded, and Burneikis called quoting, "Let's have a gamble."
Burneikis:
Versace:
Board:
The gamble looked to have paid off for Burneikis on the flop when he paired his nine, but when the jack on the river gave both players a straight, Versace lived to fight on.
Player
Chips
Progress
Vladas Burneikis
145,000
135,000
Domenico Versace
80,000
56,000
Big Stacks at the Break Posted Sunday 20th October, 2019 at 16:19(UTC+2) by Chris Martin
Player
Chips
Progress
Patrick Ignatius Clarke
920,000
520,000
Sebastian Whal
835,000
545,000
Mats Gustav Villern Karlsson
775,000
549,000
Niko Pakalen
770,000
199,000
Louis Karam
760,000
372,000
Karl Fredrik Ellingsson
730,000
419,500
Maksims Azarjancs
720,000
368,000
Marc Jan Mijnheer
717,000
271,000
Edward James Overall
700,000
599,000
Alberto Cigliano
700,000
380,000
Melech Prozan
700,000
360,000
Cristiano Ruiu
700,000
293,000
Hassan Aku Robert Sey
675,000
100,000
Flaviano Cammisuli
650,000
95,000
Andres Fernandez Vinxxas
630,000
337,500
Dario Marinelli
630,000
22,000
David Dotan Balestra
600,000
360,000
Boris Chertin
590,000
206,000
Alan John Linker
580,000
455,000
Jonas Gunnar Broden
570,000
128,000
Vikrum Mehta
560,000
477,000
Marco Bartolini
560,000
358,000
Terence Lee Etim
550,000
192,500
Yotam Bar-Yosef
550,000
77,000
Yordy R Bakker
525,000
278,000
Jonathan Therme
520,000
168,000
Mirco Ferrini
500,000
213,000
Tindaro Candido
500,000
82,000
Johan Goslings
450,000
5,000
Mr Pedro Santos Borba
440,000
78,000
Craig Young
430,000
282,000
Antonello Ferraiuolo
420,000
205,000
Michele Tocci
400,000
267,000
Georgios Kapalas
395,000
2,000
Ichiyo Niwa
385,000
106,000
Hagai Ben Yair
380,000
110,500
Steven Van Zadelhoff
185,000
15,000
Keimo Suominen
160,000
8,000
Simpson, Kyte, Urbonas, & Newport Exit Posted Sunday 20th October, 2019 at 16:09(UTC+2) by Gia Carnestorm
Among the recent departures is Ian Simpson. Jon Kyte, Mantas Urbontas, and Nicholas Newport.
Player
Chips
Progress
Nicholas Newport
237,000
0
Nicholas Newport
0
0
Mantas Urbonas
0
0
Jon Kyte
0
0
Ian Simpson
0
0
16:04 (UTC+2)
Start of Level 17 Blinds: 4000/8000 Ante: 8000
Break Posted Sunday 20th October, 2019 at 15:43(UTC+2) by Gia Carnestorm
The players are on a 25-minute break.
MacIntyre Eliminated; Jumps into High Roller Posted Sunday 20th October, 2019 at 15:42(UTC+2) by Chris Martin
Fraser MacIntyrewas short with ten big blinds and picked up from middle position and shoved. The button woke up with and according to MacIntyre"the rest was history."
The flop came giving both players a pair, but there was no extra help as MacIntyrewas eliminated.
"I'm going to jump into the High Roller now," said MacIntyre.
Player
Chips
Progress
Fraser MacIntyre
0
0
BOM High Roller Underway Posted Sunday 20th October, 2019 at 15:34(UTC+2) by Chris Martin
There are currently 77 entries in the €1,300 Battle of Malta High Roller including Andrew Christoforou, Peter Jaksland, Jimmy Kebe, Antoine Labat, and Jamila von Perger.
Last year’s High Roller was won by two-time Italian Poker Open champion Simone 'Spera91' Speranza for €60,000. The high-speed final also featured Estonian poker legend Henri Kasper. There were a total of 240 entries creating a €279,360 prize pool.
One year earlier, Serbian player Miroslav Opojevlic snagged a career-best live cash when he won the Battle of Malta High Roller in 2017 for €47,000. Holland’s Kework Besiktasliyan defeated a 103-strong field to win the event in 2016 for €37,370 while Serbia’s Mladen Kratovic won in 2015 for €28,900 after he bested a field of 80 entries.
The first ever High Roller at Battle of Malta was held in 2014, the event’s third year. It cost €3,800 to enter and was won by Latvia’s Arsens Sakanjans for €15,300.
Late registration in this year's event is open for ten levels.
200 Eliminations So Far on Day 2 Posted Sunday 20th October, 2019 at 15:27(UTC+2) by Chris Martin
The tournament clock shows 485 players remaining meaning that we've lost over 200 players since the start of Day 2.
We're approaching the first break of the day. When players return from that break, the blinds will be 4,000/8,000. The average currently stands at 235,000.
Players Party @ 8 PM Posted Sunday 20th October, 2019 at 15:25(UTC+2) by Gia Carnestorm
The main Battle of Malta Players Party is taking place at exclusiveParanga 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.
Notable Bustouts Posted Sunday 20th October, 2019 at 15:24(UTC+2) by Chris Martin
Player
Chips
Progress
Nicolas Bruno Courbin 1
0
0
Domenico Avagliano
0
0
Mikko Pennanen
0
0
Jimmy Boubou Kebe
0
0
Peter Jaksland
0
0
Robert Cabral Lim
0
0
Brandon Michael Sheils
0
0
Infantino Finds a Double Posted Sunday 20th October, 2019 at 15:24(UTC+2) by Gia Carnestorm
Paolo Infantino was all in for 47,000 from middle position, and Nassim Bennacer called from the big blind.
Infantino:
Bennacer:
Board:
The ace-jack held strong for Infantino, and he secured the double.
Player
Chips
Progress
Nassim Bennacer
100,000
118,500
Paolo Infantino
95,000
95,000
O'Kearney Among Early Eliminations Posted Sunday 20th October, 2019 at 15:17(UTC+2) by Chris Martin
Dara O'Kearney came into the day with around 80,000 and was in need of a spin with the average sitting around 160,000.
However, after losing with against the of an opponent, he's been eliminated.
Player
Chips
Progress
Dara Ruairi O`Kearney
0
0
Payout Information Posted Sunday 20th October, 2019 at 15:14(UTC+2) by Gia Carnestorm
Place
Payout (EUR)
Place
Payout (EUR)
1
€ 306,205
2
€ 158,130
3
€ 102,050
4
€ 74,540
5
€ 56,470
45-53
€ 4,070
6
€ 42,910
54-62
€ 3,160
7
€ 33,880
63-80
€ 2,710
8
€ 27,100
81-98
€ 2,480
9
€ 24,620
99-125
€ 2,260
10-11
€ 22,360
126-152
€ 2,150
12-13
€ 20,100
324-368
€ 1,540
14-15
€ 17,840
369-413
€ 1,470
16-17
€ 15,580
414-458
€ 1,400
18-20
€ 13,330
459-503
€ 1,330
21-23
€ 11,070
504-548
€ 1,260
24-26
€ 8,810
549-593
€ 1,220
27-35
€ 7,230
594-647
€ 1,170
36-44
€ 5,650
648-688
€ 1,100
14:59 (UTC+2)
Start of Level 16 Blinds: 3000/6000 Ante: 6000
Meilczarek Doubles Posted Sunday 20th October, 2019 at 14:54(UTC+2) by Gia Carnestorm
Bartosz Meilczarek was all in preflop for 85,000, and Steven Van Zadelhoff called.
Meilczarek:
Van Zadelhoff:
Board:
Meilczarek had the lead pre-flop and held to double up.
Player
Chips
Progress
Steven Van Zadelhoff
240,000
40,000
Bartosz Mielczarek
180,000
110,000
Level Update Posted Sunday 20th October, 2019 at 14:44(UTC+2) by Gia Carnestorm
The action started half-way through level 15, the earliest point one of the Day 1 starting flights, begun.
The first break will come at the end of level 16.
Download the Battle of Malta App Posted Sunday 20th October, 2019 at 14:42(UTC+2) by Chris Martin
Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting the website below:
Players Return for Battle of Malta Day 2 Posted Sunday 20th October, 2019 at 14:21(UTC+2) by Chris Martin
Just 688 players return for Day 2 of the 2019 Battle of Malta Main Event from a record-breaking field of 4,657.
All players are in the money, with prize pool and payouts set to be confirmed early on Day 2.
The schedule for Day 2 is to play eight 60-minute levels once cards get in the air at 2 p.m. local time.
Leading the way is Italian Dario Marinelli who is the only player over 600,000 in chips. He has $177,403 total live cashes with his biggest coming earlier this year when he finished 132nd in the WSOP Main Event for $59,295.
Behind comes Petr Tiurin (575,000), €5,000 Mega High Stack champion Hassan Sey (575,000), Niko Pakalen (571,0000), Gabriele Re (566,000) and Flaviano Cammisuli (555,000).
Notables in the Day 2 field include Patrick Clarke (400,000), Andy Hills (315,000), Steven van Zadelhoff (280,000), Mateusz Moolhuizen (239,000), David Lappin (120,000), Dara O'Kearney (85,000), Ian Simpson (69,000) and Ana Marquez (61,000).
Stay tuned to the Battle of Malta Main Event as the field grows even smaller ahead of Day 3.
Shuffle Up and Deal Posted Sunday 20th October, 2019 at 14:20(UTC+2) by Gia Carnestorm
The Day 2 action is underway at Casino Malta.
14:10 (UTC+2)
Start of Level 15 Blinds: 2500/5000 Ante: 5000
13:24 (UTC+2)
Day 2 of Battle of Malta 2019 Started Level: 14 Blinds: 2000/4000 Ante: 4000
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.