0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0097 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-04-26'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/1/1/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.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '1'
0.0195 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0042 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '1'
AND `published` = 1
0.0196 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0036 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '4'
AND `published` = 1
0.0294 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0040 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '5'
AND `published` = 1
0.0197 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0039 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '7'
AND `published` = 1
0.0192 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.0239 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0036 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '10'
AND `published` = 1
0.0195 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` = '11'
AND `published` = 1
0.0225 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '12'
AND `published` = 1
0.0094 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '1'
ORDER BY `busted` ASC, `current_chips` DESC
0.0075 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` = '1'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '100'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '99'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '98'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '97'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '96'
ORDER BY `chip_change` DESC, `busted` ASC
0.0195 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '95'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '94'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '93'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '92'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '91'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '90'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '89'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '88'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '87'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '86'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '85'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '84'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '83'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '81'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '82'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '80'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '79'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '78'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '77'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '76'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '75'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '74'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '73'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '69'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '68'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '67'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '66'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '65'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '64'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '63'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '61'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '60'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '58'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '57'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '56'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '55'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '53'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '47'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '46'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '45'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '40'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '39'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '38'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '37'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '36'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '35'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '34'
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` = '33'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '32'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '31'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '28'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '30'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '29'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '27'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '26'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '25'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '24'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '23'
ORDER BY `chip_change` DESC, `busted` ASC
0.0142 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '21'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '20'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '8'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '1'
ORDER BY `busted` ASC, `current_chips` DESC
0.0040 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` = '1'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '100'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '99'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '98'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '97'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '96'
ORDER BY `chip_change` DESC, `busted` ASC
0.0180 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '95'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '94'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '93'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '92'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '91'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '90'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '89'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '88'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '87'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '86'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '85'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '84'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '83'
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` = '81'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '82'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '80'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '79'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '78'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '77'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '76'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '75'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '74'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '73'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '69'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '68'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '67'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '66'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '65'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '64'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '63'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '61'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '60'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '58'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '57'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '56'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '55'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '53'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '47'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '46'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '45'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '40'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '39'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '38'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '37'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '36'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '35'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '34'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '33'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '32'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '31'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '28'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '30'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '29'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '27'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '26'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '25'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '24'
ORDER BY `chip_change` DESC, `busted` ASC
0.0230 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '23'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '21'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '20'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '12'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '8'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 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.0003 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 1A of Battle of Malta 2019 Ended Level: 14 Blinds: 2000/4000 Ante: 4000
First 2019 Battle of Malta Flight in the Books; 50 Advance to Day 2 Posted Thursday 17th October, 2019 at 01:22(UTC+2)
A total of 333 players entered the Battle of Malta Main Event on Day 1a with just 50 making it through to Day 2.
The survivors are all in the money after just over 14 levels of play in the first of five starting flights.
Play got underway at 1 p.m. and it wasn't long until the big names joined the field, including last year's eighth-place finisher Mateusz Moolhuizen and his girlfriend Dehlia de Jong, along with Dara O'Kearney, Ian Simpson, Daragh Davey, Erwann Pecheux, Leo Worthington-Leese, and Ana Marquez.
Of these, just Moolhuizen (239,000) and Marquez (61,000) would advance from a Day 1a field.
"I'm having such a good time here in Malta," said Marquez who finished second in the Ladies Event and 23rd in the High Roller at the 2018 Battle of Malta.
"I was here for last year's Battle of Malta, but this time I came earlier to visit a lot of places on the island. There are so many gems all over the country."
The field of 50 advancing to Day 2, which begins at 2 p.m. on Saturday 19th October, is topped by Irishman Shane Dempsey (490,000), Stefan Vernacki (426,000) and Vytenis Salickas (402,000) who are the only players over 400,000 in chips.
Boris Chertin (384,000), Jonathan Therme (352,000) and Ibrahim Caner Yurtsever (300,000) are the only players over the 300,000 chip mark, all of which will be well-placed ahead of Day 2.
The €5,000 Mega High Stack is still ongoing here at the Battle of Malta, with just 10 players remaining from a starting field of 20. We'll bring you news when a winner is crowned tomorrow.
Meanwhile, the €200 buy-in Kings of Tallinn has reached a final table from a field of 153 entrants. With 23 paid there is still a first prize of €5,850 up for grabs.
Finally just 60 remain in the €120 Survive Your Day and Battle event from a field of 120.
Tomorrow promises to be another exciting day's play here at 2019 Battle of Malta with 175 players including John Hesp, David Lappin, and Andy Hills all expected to join the field here at the luxurious Intercontinental Hotel, hosted by Casino Malta.
Vygerdas Bubbles the Money Spots Posted Thursday 17th October, 2019 at 01:20(UTC+2)
The flop fell , and four players checked.
The hit on the turn, and Jonikas Vygerdas moved all in for 9,500.
Vitenis Salickas called, another player folded, and Cristian-Mugurel Tamas also came along.
Salickas moved all in on the river, and Tamas folded.
Salickas revealed for a full house, and Vygerdas mucked .
Vygerdas was eliminated in 51st place, and the remaining 50 are in the money spots.
The play has now ended for the day, and a recap of the day's action along with the final end of day counts will be posted shortly.
Player
Chips
Progress
Vytenis Salickas
400,000
375,000
Vygerdas Jonikas
0
25,000
Holdhus Latest Elimination Posted Thursday 17th October, 2019 at 00:57(UTC+2)
Egon Holdhus moved almost all in and after Konstantin Zerdev re-raised, Holdhus called for his last 40,000 chips.
Egon Holdhus: Konstantin Zerdev:
The board ran out with Zerdev rivering a flush to eliminate Holdhus.
The tournament is now down to 53 players with just 50 making it through to Day 2. The tournament is now hand-for-hand.
Player
Chips
Progress
Konstantin Nikolaev Zerdev
125,000
10,000
Egon Holdhus
0
0
Patel Loses Flip to Exit Posted Thursday 17th October, 2019 at 00:42(UTC+2)
Priti Patel moved all in and Paolo Infantino called.
Patel:
Infantino:
Board:
Patel was in a flip for her tournament life but couldn't connect with the board.
Infantino picked up and the pot and Patel departed.
Player
Chips
Progress
Paolo Infantino
190,000
0
Patel Priti
0
100,000
Harmens Tries to Bluff Middleton Posted Thursday 17th October, 2019 at 00:36(UTC+2)
Andrew Middleton and Sjors Harmens checked a flop and turn before the came on the river.
Middleton bet 10,000 and Harmens raised to 33,000. Middleton took his time to think before calling.
"Queen-high," said Harmens showing and Middleton won the pot with for pocket queens.
Player
Chips
Progress
Andrew James Middleton
230,000
205,000
Sjors Harmens
90,000
0
00:18 (UTC+2)
Start of Level 14 Blinds: 2000/4000 Ante: 4000
Holdhus Hits Two Pair Posted Thursday 17th October, 2019 at 00:18(UTC+2)
The flop was down and Eduard Tugov bet 6,000 from the button.
Egon Holdhus was in the tank from the big blind and called after close to a minute's thought.
Holdhus checked in the dark and Toguv checked behind on the turn before the fell on the river.
The players checked to a showdown and Toguv saw his was no good against Holdhus' .
Player
Chips
Progress
Eduard Tugov
120,000
87,000
Egon Holdhus
50,000
25,000
Two Pair For Therme Posted Wednesday 16th October, 2019 at 23:48(UTC+2)
The flop was down and Nico Florian Guimond check-called a 6,000 bet from Jonathan Therme.
The hit on the turn and Guimond checked again from the big blind.
Therme continued for 30,000 from the button and Guimond called.
After both players checked to a showdown on the river Guimond revealed , but it wasn't enough to beat Therme's for two pair.
Player
Chips
Progress
Florin Nico Guimond
270,000
85,000
Jonathan Therme
140,000
0
Linker Eliminates Romain Posted Wednesday 16th October, 2019 at 23:32(UTC+2)
Alan Linker opened to 9,500 and Paul Romain three-bet all in for his last 13 big blinds or 39,500. Linker called.
Alan Linker: Paul Romain:
There was not much help for Romain on the flop and the runout sealed his elimination.
Player
Chips
Progress
Alan John Linker
145,000
25,000
Paul Romain
0
0
Moolhuizen Making Moves Posted Wednesday 16th October, 2019 at 23:32(UTC+2)
Not long after hitting a straight on the river to move up to 180,000, Mateusz Moolhuizen is now sitting with a 250,000 stack.
Earlier this year, the Dutchman UCOP Passport Leaderboard and back in 2018 was claimed the Greatest Poker Player in the Universe during the UCOP promotion.
Player
Chips
Progress
Mateusz Moolhuizen
250,000
70,000
23:24 (UTC+2)
Start of Level 13 Blinds: 1500/3000 Ante: 3000
Break Posted Wednesday 16th October, 2019 at 23:02(UTC+2)
With fewer than 80 players remaining, the tournament is going on another 20-minute break.
A reminder that we will play down to 50 players before bagging up at the end of Day 1a.
O'Kearney Cracks Aces to Triple Up Posted Wednesday 16th October, 2019 at 22:56(UTC+2)
Dara O'Kearney moved all in for 24,900 and David Hareuveni called. It folded to Sjors Harmen in the small blind who moved all in, with Hareuveni folding.
Dara O'Kearney: Sjors Harmen:
O'Kearney had run into it and picked up a pair on the flop. The turn improved him to a flush draw and the river completed his flush and he tripled up.
Player
Chips
Progress
Sjors Harmens
90,000
65,000
David Hareuveni
90,000
0
Dara O'Kearney
80,000
45,000
Norozi Closing in on 300k Posted Wednesday 16th October, 2019 at 22:43(UTC+2)
On a board, Sirus Norozi checked and Gunnar Stangeby moved all in, betting 61,500 into a pot of around 50,000.
Opponent Sirus Norozi gave it a lot of thought before calling.
Sirus Norozi: Gunnar Stangeby:
The river was the and Stangeby was eliminated.
"I said it's a hand I had to could not fold," said Norozi. "I was hoping ace-king."
Player
Chips
Progress
Sirius Norozi
295,000
135,000
Gunnar Arne Stangeby
0
0
Dideriksen-Neilsen vs. Hareuveni Posted Wednesday 16th October, 2019 at 22:42(UTC+2)
Jacob Dideriksen-Neilsen raised to 5,000 from the cutoff and David Hareuveni called in the big blind.
Both players checked after the flop fell and Dideriksen-Neilsen called a 6,000 bet from Hareuveni on the turn.
"Careful" said Hareuveni after the appeared on the river.
But Dideriksen-Neilsen had no fear and bet 11,000, which was enough to make Hareuveni fold.
Player
Chips
Progress
Jacob Dideriksen-Nielsen
100,000
19,000
David Hareuveni
90,000
65,000
Dzeletovic Eliminated After Leipart Hits His Ace Posted Wednesday 16th October, 2019 at 22:32(UTC+2)
One player opened to 2,000 and got two calls before Felix Leipart three-bet all in for 26,000. Nikola Dzeletovic was in the next position and shoved for around 20,000. The three other players folded and the cards were turned over.
Nikola Dzeletovic: Felix Leipart:
The board ran out with Leipart spiking an ace to send Dzeletovic to the rail.
Player
Chips
Progress
Felix Hans Leipart
60,000
35,000
Nikola Dzeletovic
0
25,000
22:25 (UTC+2)
Start of Level 12 Blinds: 1000/2500 Ante: 2500
Margolin Forces Out Guimond Posted Wednesday 16th October, 2019 at 22:08(UTC+2)
Florin Guimond check-called 4,500 from the small blind from Evgenii Margolin on the flop.
The turnwas checked by both players bringing the on the river. Guimond bet 8,500 and Margolin thought before raising to 24,000.
Guimond tanked and eventually a player called the clock. The floor staff counted down and eventually his hand was timed out and it was sent into the muck.
Player
Chips
Progress
Florin Nico Guimond
185,000
25,000
Evgenii Margolin
135,000
20,000
Moolhuizen Hits a Straight Posted Wednesday 16th October, 2019 at 22:08(UTC+2)
The board was down and Mateusz Moolhuizen checked from the small blind.
The player in the cutoff bet 16,000 into the 45,000 pot and Moolhuizen moved all in for close to 85,000.
Moolhuizen's opponent snap-called and flipped over .
Moolhuizen flipped over for the straight flush draw and when the appeared on the river, the Dutchman stole the pot and scored an elimination.
Player
Chips
Progress
Mateusz Moolhuizen
180,000
86,000
Checking in on the Big Stacks Posted Wednesday 16th October, 2019 at 21:47(UTC+2)
Player
Chips
Progress
Florin Nico Guimond
210,000
5,000
Maceo Victor Fryda
195,000
46,000
Sirius Norozi
160,000
50,000
Alf Adam Mortinsson
155,000
10,000
Daniel Andre Hoyesveen
150,000
52,000
Serdar Demircan
145,000
25,000
Raphael Toledo
140,000
115,000
Alan John Linker
120,000
95,000
21:43 (UTC+2)
Start of Level 11 Blinds: 1000/2000 Ante: 2000
O'Kearney Moves All In Posted Wednesday 16th October, 2019 at 21:42(UTC+2)
The action folded around to Dara O'Kearney on the button, and he moved all in for 32,000.
The Irishman, who had been up to 80,000 in the early levels, saw his opponents in the blinds fold, and he picked up the pot.
Player
Chips
Progress
Dara O'Kearney
35,000
45,000
Updated Chip Counts Posted Wednesday 16th October, 2019 at 21:32(UTC+2)
Updated Chip Counts
Player
Chips
Progress
Maceo Victor Fryda
241,000
1,000
Stefan Vernacki
230,000
90,000
Florin Nico Guimond
205,000
105,000
Serdar Demircan
170,000
145,000
Alf Adam Mortinsson
145,000
120,000
Eychenne Thomas Pierre Jean Br
138,000
113,000
J James Field
127,000
102,000
Alvaro Jesus Del Hoyo Navarro
120,000
95,000
Evgenii Margolin
115,000
45,000
Konstantin Nikolaev Zerdev
115,000
15,000
Sirius Norozi
110,000
85,000
Emmanuel Yamm Hubert Houssais
106,000
81,000
Rimantas Petras Boguzas
102,000
62,000
Patel Priti
100,000
75,000
Daniel Andre Hoyesveen
98,000
73,000
James Paul Golder
96,000
71,000
Mateusz Moolhuizen
94,000
14,000
Paolo Infantino
90,000
65,000
Benyamin Glot
85,000
25,000
Jacob Dideriksen-Nielsen
81,000
56,000
Raul Carrillo Perez
79,000
54,000
Jose Miquel Delgado
70,000
45,000
Tugov Finds Aces to Double Posted Wednesday 16th October, 2019 at 21:23(UTC+2)
Luca Moschitta raised to 3,200 from the hijack and Eduard Tugov moved all in for 15,000 from the cutoff.
The action folded back to Moschitta and he called.
Moschitta:
Tugov:
Board:
Tugov saw his aces improve to a full house and sealed the double up.
Player
Chips
Progress
Luca Moschitta
41,000
16,000
Eduard Tugov
33,000
0
Francesco Saverio Eliminated by Dempsey Posted Wednesday 16th October, 2019 at 21:16(UTC+2)
Farro Francesco Saverio moved all in for 9,600 and Samuel Dray called in late position. Shane Dempsey then three-bet all in for around 50,000. Dray tank-folded and the cards were turned over.
Farro Francesco Saverio: Shane Dempsey:
Dray fist-pumped in celebration of seemingly getting the call right as the board ran out and Francescosaverio tapped the table and was eliminated.
Player
Chips
Progress
Shane Dempsey
75,000
10,000
Samuel Dray
50,000
0
Francescosaverio Farro
0
25,000
Last Level for Late Registration and Re-Entry Posted Wednesday 16th October, 2019 at 21:08(UTC+2)
129 players have returned from dinner and have retaken their seats. There are forty minutes left for players to enter and re-enter the tournament before it closes for Day 1a.
21:07 (UTC+2)
Start of Level 10 Blinds: 800/1600 Ante: 1600
Dinner Break Posted Wednesday 16th October, 2019 at 19:50(UTC+2)
Players are now going on a 75-minute dinner break with 133 of 335 players remaining. A reminder that today sees the tournament play down to 15% with the whole field in the money.
Cards in the Air for €5,000 Mega High Stack at 9pm Posted Wednesday 16th October, 2019 at 19:49(UTC+2)
Later tonight sees the Battle of Malta's first €5,000 buy-in tournament with the start of the Mega High Stack.
Players will receive 30,000 starting chips and play ten levels on Day 1 with 15-minute breaks every three levels.
Sedini Eliminated Posted Wednesday 16th October, 2019 at 19:48(UTC+2)
Simone Sedini was all in for 15,000 from middle position and Joel Holmberg called from the hijack.
Tommy Elvestad moved all in for 36,000 from the big blind and Holmberg folded.
Elvestad:
Sedini:
The cards fell and Sedini hit the rail.
Player
Chips
Progress
Tommy Elvestad
65,000
5,000
Joel Holmberg
55,000
30,000
Simone Sedini
0
0
Welcome to Battle of Malta Day 1a Posted Wednesday 16th October, 2019 at 19:07(UTC+2)
19:07 (UTC+2)
Start of Level 9 Blinds: 600/1200 Ante: 1200
Marquez Cracks Aces Posted Wednesday 16th October, 2019 at 19:03(UTC+2)
The board was down and the dealer was passing Ana Marquez in the big blind a pile of chips.
Marquez's opponent Roberts Rumba held and was unfortunate to lose as Marquez held for a set.
Marquez moved up to 90,000 and Rumba was left on 14,000.
Player
Chips
Progress
Ana Marquez
90,000
0
Roberts Rumba
39,000
0
Setting Up Battle of Malta 2019 Posted Wednesday 16th October, 2019 at 19:03(UTC+2)
O'Kearney Shows a House Posted Wednesday 16th October, 2019 at 18:47(UTC+2)
Rares Bodea raised to1,700 and both Dara O'Kearney and Pierre Azzopardi called.
O'Kearney bet 2,500 from middle position after the flop fell and Bodea called after Azzopardi folded.
The hit on the turn and both players checked before the appeared on the river.
Bodea bet 3,500 and O'Kearney raised to 9,000. Bodea thought for 30 seconds then folded, and O'Kearney kindly showed for a full house.
Player
Chips
Progress
Dara O'Kearney
80,000
15,000
Van Zadelhoff Determined Ahead of Battle of Malta's €5,000 Tournament Posted Wednesday 16th October, 2019 at 18:39(UTC+2)
The Battle of Malta Mega High Stack gets underway at 9pm later tonight, with one player determined to take down the trophy.
"I'm mad keen to win a trophy here in Malta," said Van Zadelhoff. "I've lived here for ten years - I deserve a trophy! And I have a gut feeling it's going to be in Battle of Malta's first €5k tourney!"
Van Zadelhoff is currently ranked eighth in Netherlands all-time money list, with $2.2m in live earnings and at least $9m winnings online.
The Malta resident tells us his gym is just outside the Intercontinental and his flat is four minutes away. No doubt he'll be sneaking in a quick gym sesh before the cards get in the air.
18:30 (UTC+2)
Start of Level 8 Blinds: 500/1000 Ante: 1000
Glot Scores a KO Posted Wednesday 16th October, 2019 at 18:26(UTC+2)
A player was all in for 11,000 and Benyamin Glot called.
Glot:
Opponent:
Board:
Glot held to win the pot and scored the knockout.
Player
Chips
Progress
Benyamin Glot
60,000
35,000
Choulis Doubles Through Font Posted Wednesday 16th October, 2019 at 18:22(UTC+2)
Dimitrios Choulis was all in with for around starting stack and was in a good position against theof Guillaume Font.
The board was with Aces holding and Choulis doubling up.
Player
Chips
Progress
Dimitrios Choulis
50,000
25,000
Guillaume Florent Benjamin Fon
15,000
10,000
Boguzas Gets Rid of Norrstrom Posted Wednesday 16th October, 2019 at 18:19(UTC+2)
Rimantas Boguzas bet 1,500 on a board and Jonas Norrstrom check-called.
Norrstrom then bet 1,500 on the turn and Boguzas called. Norrstrom bet 3,000 on theriver but after Boguzas moved all in, Norrstrom quickly folded.
Player
Chips
Progress
Rimantas Petras Boguzas
40,000
15,000
Jonas Norrstrom
20,000
5,000
Updated Chip Counts Posted Wednesday 16th October, 2019 at 18:08(UTC+2)
Updated Chip Counts
Player
Chips
Progress
Stefan Vernacki
140,000
115,000
Florin Nico Guimond
100,000
75,000
Konstantin Nikolaev Zerdev
100,000
75,000
Shane Dempsey
85,000
60,000
Evgenii Margolin
70,000
45,000
Tommy Elvestad
70,000
45,000
17:59 (UTC+2)
Start of Level 7 Blinds: 400/800 Ante: 800
Break Posted Wednesday 16th October, 2019 at 17:59(UTC+2)
Players are going on their second 20-minute break of the day with 207 of 328 players remaining.
When they return there will be three more levels before they have a 75-minute dinner break.
Marquez Joins the Field Posted Wednesday 16th October, 2019 at 17:58(UTC+2)
Ana Marquez is one of the latest players to jump into the Battle of Malta Main Event along with a whole host of well-known players.
Player
Chips
Progress
Mateusz Moolhuizen
80,000
11,000
Dara O'Kearney
65,000
41,700
Andreas Klatt
40,000
15,000
Ana Marquez
25,000
0
Erwann Michel Pecheux
15,000
10,000
Vinnicombe Shoves Posted Wednesday 16th October, 2019 at 17:39(UTC+2)
Cristian-Mugurel Tamas raised to 600 from under the gun and Felix Leipart called from middle position. Alan Vinnicombe three-bet to 3,000.
Agatino Napoli called from the small blind as did Marcus Larsson in the big blind.
Tamas called before Leipart folded and the flop fell
Vinnicombe moved all in for 15,000 after the action checked around and the Brit saw all his opponents fold.
Player
Chips
Progress
Alan Vinnicombe
28,000
3,000
Karlsson Doubles Posted Wednesday 16th October, 2019 at 17:12(UTC+2)
The board was down and Mario Lacitgnola bet 3,200 from middle position.
Mats Karlsson called from the small blind and the appeared on the river.
Karlsson moved all in for 14,000 and Lacitgnola called.
Karlsson held for top two pair and Lacitgnola mucked .
Player
Chips
Progress
Mats Gustav Villern Karlsson
50,000
25,000
16:50 (UTC+2)
Start of Level 6 Blinds: 300/600 Ante: 600
BOM Charity Raffle Posted Wednesday 16th October, 2019 at 16:50(UTC+2)
Battle of Malta is aiming to raise thousands of euros with a special charity raffle for Pink October Malta at this year’s festival.
Raffle tickets will be on sale throughout this year’s Battle of Malta. With such amazing prizes on offer, players are being encouraged to buy as many tickets as possible. Tickets cost €5 each, and there will be two prize draws: at 7 pm on Saturday, October 19 and 7 pm, Sunday, October 20 – both in the tournament area.
Last year Battle of Malta’s charity tournament and raffle raised a total of €20,000 for Pink October Malta thanks to generous player donations, a ton of ticket sales, and a substantial contribution from Casino Malta.
Pink October Malta is a Marigold Foundation initiative that aims to spread awareness about breast cancer and encourage women to undergo regular check-ups. Battle of Malta would like to thank all its sponsors who have generously provided such wonderful prizes for the raffle.
Download the Battle of Malta App Posted Wednesday 16th October, 2019 at 16:45(UTC+2)
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 visitingbom.beezer.com.
Bad Timing From Gokcek Sees Coone Double Up Posted Wednesday 16th October, 2019 at 16:44(UTC+2)
Ant Gokcek opened to 1,500 from the button and Brendan Coone three-bet to 4,300 on the button.
Gokcek called and then bet 10,000 on the flop. Coone then raised all in for 13,500 and Gokcek shrugged before calling.
Brendan Coone: Ant Gokcek:
The turn and changed nothing and Coone doubled to over starting stack.
Player
Chips
Progress
Levinues Coone Brendan
35,000
10,000
Ant Gokcek
24,000
1,000
Simpson Eliminated Posted Wednesday 16th October, 2019 at 16:41(UTC+2)
Ian Simpson was all in for 11,500 from the small blind and Robert Jones is also all in for 26,000 from the cutoff.
Maria Katsourides was the final player with a decision to make, but after some thought she folded.
Simpson revealed but was behind against .
The board ran out and Simpson was eliminated.
Jones moved up to 36,000 and Simpson confirmed he would try again in tomorrow's Day 1b.
Player
Chips
Progress
Robert Edwin Jones
37,000
12,000
Ian Simpson
0
0
16:17 (UTC+2)
Start of Level 5 Blinds: 200/500 Ante: 500
O'Kearney at the Feature Table Posted Wednesday 16th October, 2019 at 16:17(UTC+2)
The start of level four has seen a new bunch of players take their seats at the feature table and one of them is the well-known name of Dara O'Kearney.
The Poker Satellite Strategy author and award-winning podcast host has over $1.1m in live tournament cashes and will be looking to add to that amount here at Casino Malta over the next seven days.
Player
Chips
Progress
Dara O'Kearney
23,300
1,700
Perianu Takes Her Seat Posted Wednesday 16th October, 2019 at 16:07(UTC+2)
Dana Perianu is a familiar face in the poker scene and known by many as one of the most experienced masseuses on the European circuit, having worked in the industry for 11 years.
However, today sees her take up a different role at Battle of Malta as a player.
Perianu, who has $23,593 in recorded live cashes, won her seat in last night's satellite, and has already been in the action today navigating her 25,000 starting stack up to 31,000.
Player
Chips
Progress
Dana Perianu
31,000
6,000
Klit Flops a Full House Posted Wednesday 16th October, 2019 at 15:51(UTC+2)
On a board Jacob Karlsen Klit bet 3,200 and Ioannis Ioannou called.
The river was theand Klit continued for 10,0000. Ioannou called but mucked when Klit showed for a flopped full house
Player
Chips
Progress
Jacob Karlsen Klit
75,000
0
Ioannis Ioannou
35,000
0
Early Big Stacks Posted Wednesday 16th October, 2019 at 15:46(UTC+2)
Following the first break of the day, several players have more than doubled their starting stack of 25,000 including Konstantin Zerdev who is up to around 80,000 in chips.
Player
Chips
Progress
Konstantin Nikolaev Zerdev
80,000
55,000
Milos Babovic
70,000
45,000
Petteri Sivula
60,000
35,000
Nicholas Osthus
58,000
33,000
Aces For Kratovic Posted Wednesday 16th October, 2019 at 15:46(UTC+2)
Leo Worthington-Leese checked from the small blind after the flop fell and Mladen Kratovic bet 1,500 from the big blind.
Worthington-Leese called and both players checked on the turn.
Worthington-Leese bet 1,300 on the river, and Kratovic called.
Worthington-Leese showed , but was behind to Kratovic's .
Player
Chips
Progress
Mladen Kratovic
32,000
0
Leo Worthington-Leese
30,000
0
15:28 (UTC+2)
Start of Level 4 Blinds: 200/400 Ante: 400
Break Posted Wednesday 16th October, 2019 at 15:10(UTC+2)
The players are now on their first 20-minute break.
Cecere Misses His Flush to be Eliminated Posted Wednesday 16th October, 2019 at 15:03(UTC+2)
Raffaele Cecere and Daniel Danklemann checked to Haim Fraid on a flop. Fraid bet 2,000 and Cecere check-raised all in for 2,800. Danklemann and Fraid called.
The remaining two players checked the runout and all three turned their cards over.
Danklemann held with Cecere holdingfor a missed flush draw. Fraid showed for two pair, eights and sevens and sent Cecere to the rail.
Margolin Hits Trips Posted Wednesday 16th October, 2019 at 14:56(UTC+2)
The flop fell , and Evgenii Margolin bet 1,300 from the hijack.
Kresten Hougaard called from the cutoff before the player in the big blind checked, and the peeled off on the turn.
Hougaard called a 2,300 bet from Margolin, and they checked to showdown on the river.
Margolin flipped over for trips, and Hougaard mucked.
Player
Chips
Progress
Evgenii Margolin
35,000
0
Big Slick No Good for Linker Posted Wednesday 16th October, 2019 at 14:38(UTC+2)
Alan Linker was all in with and had Rudy Fonseca at risk for the Frenchman's last 11,500. However, Fonseca held and was in a good position for a double up.
The board cameand he doubled to just under starting stack.
Player
Chips
Progress
Rudy Fonseca
23,000
2,000
Alan John Linker
18,000
7,000
14:35 (UTC+2)
Start of Level 3 Blinds: 100/300 Ante: 300
A Win For Hin Posted Wednesday 16th October, 2019 at 14:34(UTC+2)
The flop fell , and both Jean-Pierre Fonseca and Janek Hin checked. The hit on the turn and Hin check-called a 1,200 bet from Fonseca.
They checked to a showdown on the river and won the pot after he revealed .
Player
Chips
Progress
Janek Hin
32,000
0
Ace-High No Good for Golder Posted Wednesday 16th October, 2019 at 14:22(UTC+2)
A player opened to 600 and Tom Deschuytter called on the button. Daniel Golder three-bet to 2,200 from the big blind. The initial raiser folded and Deschuytter called.
The flop came and Golder bet 2,200. Deschuytter called and the turn was the
Golder continued for 4,500 and Deschuytter called. The river was the and both players checked.
"Ace-high," said Golder.
"You have to show your hand," replied Deschuytter and he watched his opponent table
Deschuytter showedfor top pair and took down the pot.
Tom Deschuytter - 35,000 Daniel Golder - 18,500
Dray Fires on the River Posted Wednesday 16th October, 2019 at 14:18(UTC+2)
Priti Patel bet 600 after the flop fell , and Samuel Dray called on the button.
Erik Bengsten raised to 2,200 from the big blind, and Dray called after Patel folded.
Bengsten checked on the flop and then called a 2,000 bet from Dray.
The appeared on the river, and Bengsten again checked before Dray fired for 5,000.
Bengsten contemplated his decision for 30 seconds but ultimately folded, and allowed Dray to pick up the pot.
Player
Chips
Progress
Samuel Dray
29,000
0
Download the Battle of Malta App! Posted Wednesday 16th October, 2019 at 13:58(UTC+2)
Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule and the chance to win a seat for the 2020 edition of the event next year.
Players can download the app anytime by visiting bom.beezer.com.
13:50 (UTC+2)
Start of Level 2 Blinds: 100/200 Ante: 200
Early Win For Schou Posted Wednesday 16th October, 2019 at 13:42(UTC+2)
Tobias Bernersjoe raised to 300 from middle position and Anders Schou three-bet to 1,200 from the cutoff.
Bernersjoe made the call and checked on the flop.
Schou continued for 1,400 and won the pot after Bernersjoe gave up.
Player
Chips
Progress
Anders Schou
27,000
0
Two Pair Good for Elvestad to Start Day 1a Posted Wednesday 16th October, 2019 at 13:30(UTC+2)
Tommy Elvestad, Philippus van Beek and Carlos Abinante all put chips in the pot on a board and both Elvestad and Van Beek checked to Abinante on the turn.
Abinante bet 1,200 and Elvestad check-called out of the small blind. The river was the and both players checked. Elvestad showed for two pair and Abinante mucked.
Carlos Abinante - 23,000 Philippus van Beek - 24,000 Tommy Elvestad - 28,000
Notable Names So Far Posted Wednesday 16th October, 2019 at 13:23(UTC+2)
Among those in their seats from the off are David Lappin, Ian Simpson, Paul Romain, Thomas Lind, and Daragh Davey.
2018 Final Tablist Moolhuizen in the FIeld Posted Wednesday 16th October, 2019 at 13:15(UTC+2)
Player
Chips
Progress
Mateusz Moolhuizen
25,000
0
Last year Mateusz Moolhuizen made it all the way to the final table of the largest Battle of Malta Main Event in history.
Moolhuizen eventually finished eighth for €30,000, and the Dutchman will be looking for another deep run this year having jumped into the Day 1a field.
He's currently sat directly to the right of his girlfriend Dehlia de Jong in a peculiar quirk of the seating draw here in Level 1.
Shuffle Up and Deal Posted Wednesday 16th October, 2019 at 13:15(UTC+2)
The 2019 Battle of Malta Main Event is underway at Casino Malta!
Late registration is open until the end of level 10. The play will finish when 15% of the field remains.
13:11 (UTC+2)
Start of Level 1 Blinds: 100/100 Ante: 100
Welcome to Battle of Malta 2019 Posted Wednesday 16th October, 2019 at 11:32(UTC+2)
Live reporting by Will Shillibier and Aaron McBride
The 2019 Battle of Malta gets underway today with the first of five starting flights, with this year's €555 buy-in Main Event expected to be the biggest in Battle of Malta history.
Last year a whopping 3,816 players smashed the €1m guarantee, and this year, thousands of players will be competing in Malta’s biggest poker tournament, including hundreds of qualifiers from MPNPT, 888poker and Italian site Vincitu.
Year
Entrants
Name
Country
Payout
2018
3,816
Julien Stropoli
France
€168,500*
2017
2,074
Nadav Lipszyc
Israel
€200,000
2016
1,813
Robert Berglund
Sweden
€160,000
2015
1,804
Nicolas Proust
France
€110,000*
2014
1,447
Antoan Katsarov
Bulgaria
€122,750
2013
888
Louis Cartarius
Germany
€68,000
2012
349
Nicodemo Piccolo
Italy
€35,000
*denotes deal
The award-winning Battle of Malta is being hosted by Casino Malta at the luxurious InterContinental Hotel in St Julian’s from October 15-22. The first tournament on the schedule was last night's €50 + €10 super satellite, which has already attracted 437 entries with 39 players winning seats into Day 1a of the Main Event.
Malta-based French player Julien Stropoli won last year's Main Event for €168,500, the best cash of his live poker career. The star-studded final table included previous MPN Poker Tour finalist Mantas Urbonas, two-time Unibet Open champion Mateusz Moolhuizen and Grosvenor Ambassador Andy Hills.
Main Event Structure
With unlimited re-entries until the end of level 10, there will be five start flights in total – with many flights expected to sell out. Players will kick off with a 25,000 starting stack and 40-minute blind levels. In the final Day 1e start flight, players will get a 10,000 starting stack and 10-minute levels. Each Day 1 will play down to 15% of the field – with all survivors making the money.
Welcome Drinks
Battle of Malta also has some fabulous events lined up for players at this year’s event. The Battle of Malta Aperol Spritz Welcome Drinks is at Casino Malta tonight (Wednesday, October 16) from 8 pm-11 pm. On Saturday (October 19), Battle of Malta is hosting a Bowling Competition at the Eden SuperBowl opposite the tournament venue. Four seats for Battle of Malta 2020 are up for grabs for each member of the four-person winning team . Teams of four should register in advance at the Eden Super Bowl, which is right across the road from the Intercontinental.
Players Party
The main Battle of Malta Players Party is taking place at exclusive Paranga Beach, the Intercontinental Hotel’s private beach club, from 8 pm on Sunday (October 20). Hit Maltese band Red Electrick is on the bill, ensuring this will be a night to remember for all Battle of Malta players.
New App
Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting bom.beezer.com or using the QR code below.
Stay tuned to all the live updates throughout the Battle of Malta festival right here!
11:11 (UTC+2)
Day 1A of Battle of Malta 2019 Started Level:Blinds: / Ante:
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 four players checked. 
hit on the turn, and Jonikas Vygerdas moved all in for 9,500. 
river, and Tamas folded. 
for a full house, and Vygerdas mucked 
. 
and turn 
and Middleton won the pot with 
and Eduard Tugov bet 6,000 from the button. 
turn before the 
fell on the river. 
was no good against Holdhus' 
. 
, but it wasn't enough to beat Therme's 
for two pair. 
runout sealed his elimination.
and Stangeby was eliminated.
and Dideriksen-Neilsen called a 6,000 bet from Hareuveni on the 
appeared on the river. 
and Sedini hit the rail. 
