0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0114 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-29' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/9/28/updates' ORDER BY `views` DESC

0.0019 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/9/28/updates', 1, '2024-03-29')

0.0008 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` = '9'

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '9'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Translate
Battle of Malta 2022 Main Event Live Reporting - Day FINALTABLE
Current Level 30 Current Day FINALTABLE
Blinds 60,000/120,000 Ante 120,000
Entries 208 Remaining 1
Prize Pool (EUR) €2,084,160 First Prize (EUR) €302,000
1 New Update - Click to refresh
Live Updates - Day 1C
04:14 (UTC+1)
Day 1C of Battle of Malta 2022 Ended
Level: 16     Blinds: 2,500/5,000     Ante: 5,000
Joubert Pierre-Yves Rises Through Battle of Malta Day 1C Carnage to Head Chipcounts Posted Saturday 8th October, 2022 at 03:51(UTC+1) by Lina Olofsson

Day 1C has played to a finish and it was Joubert Pierre-Yves who managed some hectic conditions to find himself skyrocketed up into first place on the leaderboard with a gargantuan 820,000 in chips at the close. 

Here's how we reached this point...

The Battle of Malta 2022 resumed today in the Intercontinental's sizeable internal chambers and once the fanfare, medieval knights and dizzying technicolour spotlight show had set the scene - cards were shuffled up and dealt and we were off for Day 1C.

The numbers of entrants for the €1 Million Gtd Battle of Malta had been steadily growing through the first two days, but the Friday Day 1 was always guaranteed to be the largest so far and so it proved with 1,014 entries in total once the rebuy period ended at level 10.

Matheusz Moolhuizen was one of the more recognisable names in the midst, following his breakout score at the WSOP this year (2nd in the WSOP $1,500 Monster Stack for $597,362) and he described the action as "a bloodbath" - an apt summary of the frenzy of chip movement we witnessed throughout the day. Moolhuizen would finish agonisingly short of passage to day 2 in 157th though even this pain was eclipsed by others during one of the craziest bubble periods we've ever witnessed.

With the landmark of 152 remaining players being the safety zone players needed to reach Day 2 (and therefore cash), we went hand for hand with 153 remaining and incredibly, on this precarious bubble inflection point, we had no less than FIVE all-ins on the same hand.

The watching rail, filled with friends and enthused onlookers, were sent into a late night frenzy as this critical set of hands played out - the tournament staff sweeping the area clean to ensure this vital juncture played out smoothly.

Ultimately three players at risk in these hands bubbled - Reigo Maar, Marco Fenaroli and Antonio Alba all missing out on a cash prize - while the remaining 150 players could breathe a sigh of great relief, knowing their 12 hour marathon poker stint would be rewarded come Sunday's Day 2.

A savage, but exciting day's poker and tomorrow should have plenty up its sleeve as well, with two further Day 1's, beginning with Day 1D at 13:00 along with a second (turbo-formatted) Day 1E, kicking off at 20:00. As well as these two events, players can also jump into the third of the "Mystery Siege of Malta" Day 1's at 17:00 - a mystery bounty event as well as a €170+30 NLHE event at 18:00 and the 888 "Made to Play" NLHE €180+20 Event that starts at 21:00.

We'll be returning to bring you news of how these pan out but for now, we're off for a few winks of R&R - much needed after such a dramatic day's play. Join us tomorrow as the race to win the Battle of Malta continues. See you then! 

Triple Bubble Shocker! Posted Saturday 8th October, 2022 at 02:35(UTC+1) by Lina Olofsson

In a shocking development, with one place from the money, no less than FIVE tables had an all-in on the same hand!

Crazy stuff, and it threw the rail into delerium, straining to see what was going on. We were collateral damage, ejected from the tournament area as the tournament staff engaged their "riot control" techniques of booting everyone not in a suit or at a table out of the tournament area (don't worry we escaped with only our pride wounded!) This made it tricky to ascertain the hands BUT we aren't so easily dismissed and we battled back in to watch THREE of those all-ins bubbling. Frothy times...

In normal circumstances this would mean all three chopped two prizes but the rules here at the Battle of Malta are that you have to bag chips for Day 2 to cash, so all three get nothing back. Harsh...

The three unlucky souls were Maar Reigo (whose AT lost out to 67 over a 9-2-2-5-7 board - cruel river), Marco Fenaroli, particularly unlucky to lose with KK v 99 to Giorgio Soceanu as the board ran out 8-3-3-7-9 (the pain!) and Alba Antonio, whose A-5 couldn't find a bullet vs QQ.

Bad luck to those three above but well done to the remaining 150 players who all make Day 2 and a cash! We'll have a wrap with news of the final chip leader& some full chip counts coming up but for now thanks for following and we'll be back for Day 1D tomorrow at 13:00.

Let's Do It Again Posted Saturday 8th October, 2022 at 01:32(UTC+1) by Gia Carnestorm

Level 16 of the day... 18 off the finish... 152 is the cut off, where all players will make day 2 and the money.... 

01:31 (UTC+1)
Start of Level 16
Blinds: 2,500/5,000     Ante: 5,000
Them's the Breaks Posted Saturday 8th October, 2022 at 01:24(UTC+1) by Lina Olofsson

Level 15 has just finished - with 170 players still hoping their stacks, skill and luck will prove the winning recipe to take them through to the final 152 players, Day 2 and the cash spots.

They'll be off for a 15 minute period to cool their jets & come back with robust strategies to make it past the last few obstacles between them and remuneration. See you shortly...

Event #16 - Bounty My Day - Zacharia Asrag Wins €1,630 Posted Saturday 8th October, 2022 at 01:15(UTC+1) by Lina Olofsson

The Bounty My Day tournament has finished with Zacharia Asrag the proud winner of €1,630 plus bounties. Congratulations - you've already got a great story to bring back from your trip to Malta.

Here are the full payouts from the event.

# 1 1,630.00 17.86% Asyag Ziv Zacharia
# 2 1,430.00 15.67% Coppens Serge 
# 3 1,415.00 15.50% Ritrovato Salvatore
# 4 1,170.00 12.82% Yemini Carmel
# 5 680 7.45% Sayeh Samir 
# 6 530 5.81% Varney Chistopher
# 7 410 4.49% Scarlino Pasquale 
# 8 310 3.40% De Leus Michael 
# 9 230 2.52% Barnett Matthew 
# 10 190 2.08% WARD CHRISTOPHER
# 11 190 2.08% CALLOW KIM
# 12 160 1.75% Heredi Daniel
# 13 160 1.75% Herbrecht Gregory Frederic Germain
# 14 160 1.75% Clausi Massimo
# 15 160 1.75% Peri Paolo
# 16 150 1.64% Siinmaa Sten 
# 17 150 1.64% Beretta Luca
More Depart Posted Saturday 8th October, 2022 at 00:59(UTC+1) by Gia Carnestorm

More exits from the room as we get closer to the 152 needed to make day 2...

Metsla Mark 
Ganev Iliya 
Karakousis Georgios 
Berberovic Bojan 
Saieva Maurizio 
Moses Sid Oliver John 
Van Leeuwen Bianca 
Russo Antonio 
Pichierri Alessandro 
Zinic Luka 
Mccann Paul 
Al-Labani Hael 
Nughes Davide 
Flamma Gerardo 
Agica Marius 
Claudi Cristiano 
MEIGHAN Avid
Mr Gianluca Modenese 
Douna Robert 
Van Ravenswoud Carlo Stefano 
Vella Mark Anthony

Chip Counts Posted Saturday 8th October, 2022 at 00:47(UTC+1) by Gia Carnestorm

Gabriele Re......(Below).... 280k

Constantin Negura.... 310k

Simon Lindell......290k

Luca Quilichini.....325k

Gheorghe-Adrian David......330k

Alejandro Gambin.....275k

Boulevard of Broken Dreams Posted Saturday 8th October, 2022 at 00:39(UTC+1) by Lina Olofsson

No one wants to walk down a street of broken dreams. It's a sad, lonely walk & a lot of those shattered dreams have sharp edges. Ouch!

Well that's the path that leads to this band of unfortunate players - their tournament coming to a close within tantalising distance of the finishing line, or at least the cashing line.

Poker tests your mettle and these players have just had a test of theirs. Bad luck all! That leaves just 199 remaining as the blinds rise...

#200 Lee Grech Jordan
#201 Marras Pietro
#202 Amendola Francesco
#203 Motta Salvatore 
#204 Piller Leino
#205 Somma Sergio
#206 Salinardi Nicky 
#207 Fangano Carmelo
#208 RIBEIRO RENATO
#209 WILLIAMS ROBERT
#210 Leuver Jeroen 
#211 Caggia Giovanni
#212 Caushaj Rei
#213 Gouguet Florian Adrien
#214 Torgeman Elhanan Lior
#215 Pietrosanto Andrea
#216 Vieira Cyril Antonine Mathieu
#217 Rosenwasser Jonathan
#218 Tortomasi Domenico
#219 BRUNS BJOERN
#220 Parcetic Aleksandar 
#221 Boi Paolo 
#222 Balestra David
#223 Mitson James Edward
#224 Matrai Andras 
#225 Montalbetti Feliciano
#226 Ben Azuz Nawfal
#227 Del Buono Vittorio
#228 Magg Raphael
#229 Parmiggiani Leonardo 
#230 Elvis-Nikolaos Chatzi
#231 Valenta Ales 
#232 Rosa Giuseppe
#233 Saraniero Riccardo 
00:37 (UTC+1)
Start of Level 15
Blinds: 2,000/4,000     Ante: 4,000
Eliminiations... Posted Saturday 8th October, 2022 at 00:27(UTC+1) by Gia Carnestorm

Exits from the room, meaning it's a re-entry tomorrow if they want to be part of the huge prize pool that is building up nicely...

Vieira Cyril Antonine Mathieu 
Rosenwasser Jonathan 
Tortomasi Domenico 
BRUNS BJOERN 
Parcetic Aleksandar 
Boi Paolo 
Balestra David 
Mitson James Edward 
Matrai Andras 
Montalbetti Feliciano 
Ben Azuz Nawfal 
Del Buono Vittorio 
Magg Raphael 
Parmiggiani Leonardo  
Elvis-Nikolaos Chatzi 
Valenta Ales 
Rosa Giuseppe 
Saraniero Riccardo 

The Final Furlong - Valentinos Looking Strong Posted Saturday 8th October, 2022 at 00:12(UTC+1) by Lina Olofsson

That pivotal number of 152 is drawing ever closer with 234 players remaining.  Although there are enough players left to make it tricky to ascertain the chip leader, Diola Valentinos is certainly in the reckoning - his 390,000 head and shoulders above most as we home in on the last few levels.

Remember yesterday Domenico Gala was the man who topped the counts with 506,000. It's likely that will be toppled over the next few hours as blind pressure causes some seismic confrontations with players battling tooth and nail to win those vital chips in the middle...

Player Chips Progress
Diola Valentinos 390,000 365,000
Go Hayley.. Posted Saturday 8th October, 2022 at 00:10(UTC+1) by Gia Carnestorm

Hayley Goss is having a great day so far... Just north of 200k and 70 players to be eliminated to make day 2... Hayley from the UK is going along nicely as she's near double average atm...  Let's hope it continues..

23:55 (UTC+1)
Start of Level 14
Blinds: 1,500/3,000     Ante: 3,000
A Few More Posted Friday 7th October, 2022 at 23:39(UTC+1) by Gia Carnestorm

Exits from the last hour .....

PIGNATELLI GIUSEPPE 
Campan Cristian 
Hougaard Kresten 
Penev Zlatin Nedyalkov 
Tammel Tarmo 
Bastow Frank  
KASI RANEL 
Autiero Giuseppe 
VICIDOMINI GIUSEPPE 
Emmi Lara Alexa 
Karakannas Giannakis 
Ragauskas Jurgis 
Zehetleitner Paul 
Ioannis Chorianopoulos 
Pekka Ikone
Maimon Amir 
Crupi Paolo 
Voto Itaco

Chip Monsters at Break - End of Level 12 Posted Friday 7th October, 2022 at 23:12(UTC+1) by Lina Olofsson

The end of level 12 means the players are taking a breather to plan their attack on the latter levels. There's much to play for, that 152 mark is their goal (283 currently remaining), which will mean they have made it through to Sunday evening's Day 2 - one step closer to the Battle of Malta trophy. Glory and riches await across that significant threshold.

Here are the players in pole position at the moment, holding large stacks that captained well could see them home.

Name Chip Count
Bodea Rares-Aurelian 340,000
Konstantin Smakov 320,000
Andrei Negura 270,000
Paolo Boi 246,000
David Ghoerghe-Adrian 245,000
Hayley Goss 230,000
Aubakirov Daniyar 220,000
Feliciano Rosario  200,000
Stephen Spiteri 200,000
Paul Thiemer 170,000
Giuseppe Imperato 134,000

So, a 15 minute break for the players and we'll be back for level 13 shortly.

Exits.... Posted Friday 7th October, 2022 at 22:36(UTC+1) by Gia Carnestorm

More exits from the room as the only way to be in the BoM is to try again tomorrow!!

SINATRA SEBASTIANO 
Thiemer Frederik Paul Caspar 
Chillemi Salvatore 
LO CARBO FABRIZIO 
Meusburger Reinhard 
Haverkamp Ronald 
Goose Steven 
Nocerino Pasquale 
VOIDOC FRANCISC 
Pancani Massimo 
Degennaro Daniele 
Negura Vlad Gabriel 
Rawal Manish Anilkumar 
Ruggero Domenico 
Linker Alan John 
Bracchi Nicola 
Field Joseph James 
SUOKAS JARKKO 
Spozio Matteo 
Yichuam Ye

Chip Counts! Posted Friday 7th October, 2022 at 22:31(UTC+1) by Gia Carnestorm

One of the big stacks in the room is Gheorghe Adrian David. Who is sat with around 260k.. (Below)

Other decent stacks around the room are....

Romano Ravailoli... 125k

Michelle Pelligrino... 195k

Mario Virtuoso...145k

Giovani le Rosa.......115k

Nicholas Osthus..... 140k

Simon Lindell....150k

Nikoli Barjaktarevic.....120k

Jovan Kenjic.....145k

22:18 (UTC+1)
Start of Level 12
Blinds: 1,000/2,000     Ante: 2,000
The Magic Number is 152 - End of Day 1C Threshold Posted Friday 7th October, 2022 at 22:16(UTC+1) by Lina Olofsson

There's just 376/1,014 players remaining in contention now. It looks like that 1,014 will be our final entries for the day given rebuys are now over but we'll confirm this officially shortly.

If so, that means we'll play until there's 152 left - at which point the day will end and all survivors will have made it to Day 2 (and cashed.)

Edit: Thomas Kremser has just announced this as the official number. 152 is our magic number. Expect things to tighten & tense up considerably as we get close to this number.  The big stacks can have a party though!

Here are a few chip counts from around the arena :-

Ioanes Polentas 160000
Adam Shriki 155000
Maurizio Migliorini  150000
Daniele Grasso 55000
Robert Douna 53000
More Eliminations! Posted Friday 7th October, 2022 at 22:05(UTC+1) by Gia Carnestorm

More eliminations from around the room....

Campbell Leon  
CEZARY KUPREWICZ 
GIAMMARIA VITO 
Kirby Stewart Anthony 
LUKOVIC NEMANJA 
Danesi Matteo
Evert Erki 
GOUTARD ANTOINE 
Pellegrino Vincenzo 
Manic Petar 
Agus Roberto 
VOIDOC FRANCISC 
D'amico Marco
Klatt Andreas 
Meusburger Reinhard 
PIOTR MALINOWSKI 
Canavesi Marco 
PAGLIARO GIANLUCA
STROFFEK STEFAN 
Mavromoustakis Andreas 
DOGGE MARTINUS 
Paillot Sylvere Felix 
Schifano Vincenzo 
Amato Ricardo
Johnson David

Near chip leader Posted Friday 7th October, 2022 at 21:54(UTC+1) by Gia Carnestorm

One of the contenders for chip leader in the room is Georgiou Georgios. He is sat with a nice stack of 270k, witht he average at 60k!!! 

Pretty decent stack as we head to the end of the buy in period..

More Exits Posted Friday 7th October, 2022 at 21:47(UTC+1) by Gia Carnestorm

More players heading to the re-entry tent!!

Hernandez Miguel 
Jakabfi Andras 
Spadaro Antonino 
Bivona Marco 
Hassankashani Arian 
La Polla Antonio 
Lisovskii Vitalii 
Lim Robert Jr Cabral 
Sammarco Francesco Paolo 
Heikkila Ilkka Elias 
Studer Daniel Otto 
Abela Konrad 
Impollonia Giovanni 
Ielpo Egidio 

21:39 (UTC+1)
Start of Level 11
Blinds: 800/1,600     Ante: 1,600
Lost One! Posted Friday 7th October, 2022 at 21:37(UTC+1) by Gia Carnestorm

We get to the table to see a board of

Sergi Ogansjan is thinking about caling the all in shove from Tiovo Ojasoo...

The dwell isn't too long as he calls his final 32k, which is just shy of the shove by Tiovo..

Sergi shows but is behind to the of Tiovo..

The river is the which means we lose Sergi from the Comp.. And takes a souvenir with him!!! 

Barran Times for Olly Posted Friday 7th October, 2022 at 21:19(UTC+1) by Lina Olofsson

Oliver Barrandon just shot a final bullet - jamming over what looked like an UTG raise from Lee Mulligan (though we missed the preflop action) for around 30,000 with pocket sevens.

Bad timing as Mulligan had the aces and made the call, which proved good over the board.

Barrandon headed quickly to the rail and Mulligan showed little emotion as he gathered the chips and re-organised his 85k ish stack - newly garnished with Barrandon's chips...

Last Exits! Posted Friday 7th October, 2022 at 21:02(UTC+1) by Gia Carnestorm

The last exits of level 9, just before the break, were:-


Maggi Silvio 
Fater Noam 
Sanchioni Eugenio 
Serbu Ionel 
Shimizu Takao 
RAVAIOLI Romano
Schifano Pietro 
Cannizzo Massimo
Pitre Salvatore
Negura Constantin 
Pogiatzeas Charalambos
Spata Alessandro 

Level 10 Posted Friday 7th October, 2022 at 20:58(UTC+1) by Gia Carnestorm

This is the last level to buy in for day 1C... Over 1000 have so far.. How many will the final figure be in 40 minutes time?  ]

20:55 (UTC+1)
Start of Level 10
Blinds: 600/1,200     Ante: 1,000
Dinner Break Posted Friday 7th October, 2022 at 19:33(UTC+1) by Lina Olofsson

Here are some of the leading chip counts as the players break at the end of level 9:

Georgios Georgiou 200,000
Hans Peter Meier 170,000
Kenjic Jovan 150,000
Van Leeuwen Bianca 130,000
Cheng Ngo Hin

130,000

There will be a 75 minute break for players to fill their bellies and we'll be back shortly afterward to catch the resumption and last level of rebuys - level 10. See you then!

Hats Off! Posted Friday 7th October, 2022 at 19:22(UTC+1) by Gia Carnestorm

The best Titfa in the room.. By a long chalk...And table 46 has plenty of chips on it too..  

Said Moses (Below) has around 110k. With the average around the 45k mark.

Michelle Pelligrino... 155k

Auturas Saulis...120k

Dave Harris... 90k

The Vanquished Posted Friday 7th October, 2022 at 19:07(UTC+1) by Lina Olofsson

As the blinds take another rise into level 9 - it's getting tough to avoid scrapping it out for your stack. Just 545 players remain from the 985 entries we've seen so far...

These players are recent fallers who now have a difficult decision to make. Buy in again? You'll have to, either today or in the next two days if you still have designs on winning this trophy...

#546 GOUTARD ANTOINE
#547 Mercieca James
#548 Santini Vincenzo 
#549 Alessi Mauro
#550 LANGGAARD REIMUND
#551 Soreau Jeremy Tony Julien
#552 HUBER MICHAEL
#553 Grigoris Kyriazi
#554 Martire Potito
#555 SINERVO TEIJO
#556 Costanzo Agatino Franchesco 
#557 Mulsow Martin
#558 Patti Salvatore
#559 Perra Marco
#560 Matrai Andras 
#561 MARCEL SITTNER
#562 FREZZA LUCIANO
#563 Zhang Honglei
#564 SCANU GIAMPAOLO
#565 Chalkoutsakis Charalampos
#566 TATJANA SMAKOVA
#567 VOIDOC FRANCISC
#568 SUOKAS JARKKO
#569 Ioannou Georgios 
#570 Patti Giuseppe
#571 Shellum Jason Shane
#572 Van Wersch Raoul Sebastiaan
#573 Kavouras Michail
#574 KERPER JENS
#575 Tringale Richard Moreno
#576 Stikelis Mantas 
#577 HAMILTON SIMON
#578 Padovani Sonia Tara
#579 Rodoplu Tayfun
#580 AMENTA EMANUELE
#581 Giordano Federico Galati
#582 Micallef Matthew
#583 Canavesi Marco 
#584 Dray Samuel
#585 PRITS MARKO
#586 Bucci Paolo
#587 Dunevein Benjamin Simon
#588 Lombardi Rolando
#589 James Davis
#590 VALLETTA CATALDO
#591 Sorvillo Francesco 
#592 Cartarius Loius
#593 Hemmert Udo Adrian
#594 Adamou Christodoulos
#595 Hoim Alar
#596 DANIEL SMITH
#597 Pukk Otto 
#598 MCKECHNIE SEAN
#599 Arjut Allan
#600 KERPER JENS
18:59 (UTC+1)
Start of Level 9
Blinds: 500/1,000     Ante: 1,000
Tatajana Gets Smakova'd Posted Friday 7th October, 2022 at 18:56(UTC+1) by Lina Olofsson

Marco Scalia just won a decent-sized pot, calling Tatjana Smakova's brave re-jam bluff on the river of a board with K-J for the nut straight. Only a flush would scupper him and when she showed down king-high - he was the beneficiary of most of her stack.

He moves to 45k and Tatjana was down to dust - 4k or so.

We passed her table shortly afterward and she had been replaced suggesting the rest of her chips had been gobbled up. Bad luck. Always time for another bullet - or one of the incoming side events. Or what about a mojito in a nearby bar to let off some steam?

Choices, choices...

Live Stream Posted Friday 7th October, 2022 at 18:51(UTC+1) by Lina Olofsson

All this week, the Battle of Malta will be showcasing a streamed feature table where you can watch the action and play along with the players, with the useful additional info of knowing their poker cards.

There's no commentary until the final but in some ways that allows you to make some predictions, without influence from commentary analysis.

Enjoy all the action by clicking here!

More Bust Outs Posted Friday 7th October, 2022 at 18:44(UTC+1) by Gia Carnestorm

Still time to re-enter for the players below..

RE Gabriele
Oliva Giuseppe
VICIDOMINI Giuseppe
Salvino Salvatore 
Coughlan Paul 
Pipitone Alessio 
Nania Cristian 
Kamatakis Iliodoros 
Chalakov Toshko  
Bucar Blaz
Joshua Edward Beackon 
Romanyuk Andrei 
Salamov Adam 
Biondo Antonio 
Georgios Phiniotis
Zhang Honglei 
Campan Chistian 
Santelli Pierluigi 
Senes Salvatore 

Brits on Tour! Posted Friday 7th October, 2022 at 18:30(UTC+1) by Gia Carnestorm

A few of the UK players and chip counts as we hit level 8..

Andrew Morse.....34k

Maria Kastourides...30k

David Johnson.... 28k

Jason Shellum.... 21k

Hayley Goss... 40k

Ray Church....32k

Dan Smith.... 10k

Steven Smart... 30k (below)


Moolhuizen and De Jong Climbing Posted Friday 7th October, 2022 at 18:29(UTC+1) by Lina Olofsson

Mateusz Moolhuizen and partner Dehlia De Jong are both navigating the first half of the day with panache. Moolhuizen holds the bragging rights at the moment - his stack around the 80k mark, but De Jong could yet vault him as she's not too far behind with around 60k.

18:20 (UTC+1)
Start of Level 8
Blinds: 400/800     Ante: 800
Chip Leaders Posted Friday 7th October, 2022 at 17:57(UTC+1) by Gia Carnestorm

Chip leaders from around the room as we start level 7.

Bianca Van Leeuwen....160k (Below)

Christos Econimides....110k

Georgiou Georgios.....95k

Antonio Borzi.... 94k

Davide Bellomonte....85k

Christopher Ekvall.....82k

Radek Castka.... 77k


17:47 (UTC+1)
Start of Level 7
Blinds: 300/600     Ante: 600
Break Time Posted Friday 7th October, 2022 at 17:27(UTC+1) by Gia Carnestorm

15 minute break for the players to talk about bad beats....

Back Soon...

Bust Outs Posted Friday 7th October, 2022 at 17:15(UTC+1) by Gia Carnestorm

More re-entry possibilities..

Zuczkowski Xavier
De Riddere Bryan 
Delpiano Dario 
Liberia Pinkecivius Tomas
Peluso Fabio 
Dunevein Simon Andrew 
Anselmo Paolo 
Padovani Sonia Tara 
Enache Ionut 
Karmiris Georgios 
Pardini David 
Praks Hannes
Ndoj Elmir
Farcas Mugurel 
Studer Daniel Otto 
Donnini Danilo

Secci Stuns Vecchi Posted Friday 7th October, 2022 at 16:58(UTC+1) by Lina Olofsson

Alessandro Vecchi just saw his Day 1C end barring a rebuy - running a bluff with a missed straight draw on a rivered ace - Andrea Secci made the call, having spiked the ace Vecchi was trying to represent...oops.

Vecchi out but Secci is doing very nicely thanks with 65,000 to his name. He had the look of a man who felt all those chips and perhaps more, totally belonged to him. For now at least, they do!

Player Chips Progress
Secci Andrea 65,000 40,000
Vecchi Alessandro 0 0
Leonardo Romeo Wins the Olybet €300 Live Poker Special for €5,700 Posted Friday 7th October, 2022 at 16:49(UTC+1) by Lina Olofsson

While we're on the subject of pocket eights, by chance, this was the hand that secured 1st prize for Italian Leonardo Romeo (pictured) in the OlyBet €300 NLHE event.

As well as the juicy €5.7K top prize - Mr Romeo also received €2.9K in additional prizes such as tournament tickets and other gifts, courtesy of  OlyBet. What a result. Congratulations Mr Romeo - Juliet will be over the moon with that.

16:44 (UTC+1)
Start of Level 6
Blinds: 200/500     Ante: 500
Brits Abroad! Posted Friday 7th October, 2022 at 16:43(UTC+1) by Gia Carnestorm

Paul Coughlan treat himself to a trip to the Battle of Malta, after chopping the Senoirs event in the UK at the massive Goliath Tournament.. He did a 5 way deal for €5300 and decided this event was worthy of a venture... 

Steady start for Paul who is hovvering at starting stack..

Snowmen Help Maimon Avoid Being Iced Posted Friday 7th October, 2022 at 16:29(UTC+1) by Lina Olofsson

Amir Maimon found himself in dire trouble with just about 6k or so and jammed preflop when he looked down at a pair of snowmen - pocket 8's.

He was called by two players with A-J and A-7, who were still active in the hand, so we didn't see these holdings until showdown.

Actually a pretty strong spot - Maimon was the favourite and held over the board, improving to a set on the river and sweeping up the chips.

"Lucky river," a tablemate commented, though the player with A-J was quick to point out (correctly) "It didn't matter, he was ahead even without it."

Maimon was hardly out of the woods with just 19,000 or so but he looked nonetheless happy at this, rubbing his hands together gleefully...

Player Chips Progress
Maimon Amir 19,000 6,000
More Exits! Posted Friday 7th October, 2022 at 16:29(UTC+1) by Gia Carnestorm

More potential re-entry players... Maybe! 

Klezeys Kasparas 
Pascaglini Cecilia 
Vinnicombe Alan 
NIANG MAME MACOUMBA 
Rinken Mart
Chillemi Salvatore 
Piccione Giuseppe 
Karmiris Georgios 
Kalac Sasa 
Dijkkamp Lennart A 
HUYST DAVY 
Andersson Lars Jakob 
Siligato Giuseppe 
Segatto Massimo 

De Silva In Da House! Posted Friday 7th October, 2022 at 16:20(UTC+1) by Gia Carnestorm

Chris De Silva who won 2019 High Roller here at the Battle of Malta for €73,000 is back in the building for the main event.. Chris is a regular on the UK circuit and plays all around the world.. After a quick chat, he's in the mood for another decent showing, this time in the Main.

16:13 (UTC+1)
Start of Level 5
Blinds: 200/400     Ante: 400
Moolhuizen Surviving The Bloodbath Posted Friday 7th October, 2022 at 15:56(UTC+1) by Lina Olofsson

The field has swelled to 750 players, though there's a surprising scarcity of star names in the mix.

One player who is on a stellar trajectory however is Mateusz Moolhuizen - who's been carving out a name for himself as a tough, seasoned tournament pro in recent years, regularly finding himself at final tables around the world.

Most recently he picked up his biggest score - a runner-up berth at the 2022 WSOP $1,500 NLHE Monster stack. He finished just shy of the bracelet but the $597,362 score represented his biggest tournament result and pushed his overall winnings into the six-figure mark.

It's been a fast start over the first few levels - "a bloodbath" is how he described the action! He's seems pretty sanguine about it all though - relaxed and joking with his stack around the 65,000 mark. He'll definitely be a man to watch should he run deep...

Player Chips Progress
Moolhuizen Mateusz 65,000 40,000
Eliminations! Posted Friday 7th October, 2022 at 15:52(UTC+1) by Gia Carnestorm

More swift exits from the room...

De Riddere Bryan 
Georgios Phiniotis 
Losi Francesco 
Montanelli Mario 
Efe Levent 
Stagi Nicola 
Peri Paolo 
Dean Lee 
Ben Azuz Nawfal 
Cutajar Andrew 
Hemmert Udo Adrian 
Pascaglini Cecilia 
Ascari Fabrizio
Matrai Andras 
FEU GONZALEZ VICTOR 
PARNAT RISTO 

Chip Leaders! Posted Friday 7th October, 2022 at 15:37(UTC+1) by Gia Carnestorm

Chip leaders from around the room as we start level 4 of the day...

Marco Bartolini....78k
Stavros Markovis-Tsakas......77k
Kostadin Mihaylov....72k
Quentin Reaubourg...70k
Andrea Cardinali.....68k
Massimiliano Mauceri....65k
Dimitris Tsouvalis....63k

15:36 (UTC+1)
Start of Level 4
Blinds: 100/300     Ante: 300
Break Time! Posted Friday 7th October, 2022 at 15:11(UTC+1) by Lina Olofsson

The poker room is bustling with activity - that background hiss of chip riffling filling the Intercontinental's large conference room. Much of that activity will halt for the first break of the day as we've reached the end of the first three levels.

The numbers continue to grow impressively - 680 entries now registered. Spectacular! We'll be back in 15 minutes to pick up from level 4. See you shortly.

Early Exits! Posted Friday 7th October, 2022 at 14:55(UTC+1) by Gia Carnestorm

Some or most will re-enter but here are a list of exits in the first session of the day...

Aprile Fabio 
Giannakopoulous Stefanos 
Affatato Valter 
Schneider Christian 
Serbu Ionel 
Tsarouchis Vasileios 
FILIP STOJANOWSKI 
Innella Paolo 
Kavouras Michail 
STANKOWSKI Filip
Evert Tanel
Stampe Michael Krogh 
Mavromoustakis Andreas 
Rinchiuso Antonio 
Ioakeim Pantelis 
David Ghoerghe-Adrian 
Tsaknis Vasileios 
Angelousis Konstantinos 
Farrell John 
Karakousis Georgios 

Early Action! Posted Friday 7th October, 2022 at 14:42(UTC+1) by Gia Carnestorm

As we scour the room for notables, I see the cards on their backs and an empty seat!! 

Charalampos Chalkoutsakis is scooping in the pot and a quick double.. Both hitting trip Jacks on the flop.. All the chips end up in the middle.. But the Ace played for Charalampos and scoops a nice one..

Pick Your Side Posted Friday 7th October, 2022 at 14:38(UTC+1) by Lina Olofsson

The third of the €1 Mill Gtd BoM Day 1's is proving very popular but suppose you prefer a different type of poker or the €500+50 buy-in is a little steep for you...

Well, there's a feast of other options on the table for you to nibble at.

Bounty tournaments are all the rage at the moment and there's the:

  • €80+100+20 "Bounty Your Day" starting at 15:00 as well as the
  • "Mystery Siege of Malta" Day 1B (€210+200+40) starting at 19:00

There's also two standard NLHE Side Events:

  • The €180+20 NLH Side at 18:00 &
  • The €130+20 NLH Side at 21:00

Lots of options as you can see and if you would like to take a shot at a Main Event seat for the budget price of €55+15, jump in the 22:00 satellite accumulator and with a bit of patience, skill and luck, you could make that happen.

And if this smorgasbord of poker nibbles doesn't take your fancy, Malta's chock full of heaving bars, nightclubs and restaurants where you can relax with a cocktail or two.

14:33 (UTC+1)
Start of Level 3
Blinds: 100/200     Ante: 200
The Brits are Here!! Posted Friday 7th October, 2022 at 14:33(UTC+1) by Gia Carnestorm

There has definately been an influx of Brits making the journey over to Malta. A steady stream over the first few days, but now seems to be the day where they make Malta their own!! So many regular faces on so many tables... 

We'll keep an eye out during the day as we wish them well.. 532 so far in the mix.. A huge turn out for 1C!! Arian Hakkankashani and Toni Poulengeris are sat side by side, after travelling all this way! 

Early Fallers - Numbers Still Growing Posted Friday 7th October, 2022 at 14:17(UTC+1) by Lina Olofsson

25k seems like an ample stack to feel your way in & take your time to adjust but you run kings into aces or set into set and it's still possible to lose all those chips. The following players have all seen their first shot at the Battle of Malta fall on stony ground:

Torgeman Elhanan Lior
Church Matthew 
Arezzo Oscar
Negucioiu Marius
Fater Noam
VOIDOC FRANCISC
Mr Maurizio Saieva 
Karakausis Georgios
Donnini Danilo
Tsouvalis Dimitrios

Bad luck for them but they have until the end of level 10 to sneak in another rebuy or two.

Meanwhile the number of entries continues to soar - now at a whopping 552!

14:11 (UTC+1)
Start of Level 2
Blinds: 100/100     Ante: 100
Day 1C Numbers Soar Posted Friday 7th October, 2022 at 13:39(UTC+1) by Lina Olofsson

Today should prove an exciting day of poker. There's already 460 players registered, meaning the numbers will smash those of Day 1A & B - especially since we'll see rebuys up until the end of level 10, as usual.

The players will be chasing the coattails of Day 1B's chipleader Domenico Gala - who reached 506,000 at the close of play yesterday. It's a handy total but we won't be surprised if that is smashed come the end of the day with so many players coming out to do battle. There are chips everywhere!

Shuffle Up and Deal! Posted Friday 7th October, 2022 at 13:11(UTC+1) by Gia Carnestorm

Play has just started on Day 1C.... 359 sat for the first hand.

12:57 (UTC+1)
Day 1C of Battle of Malta 2022 Started
Level: 1     Blinds: 100/100     Ante: 0
Your search results are valid for . More 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.