0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0060 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-28' AND `url` = 'https://www.maineventtravel.com/live-reporting/bom-main-event/1B/updates' ORDER BY `views` DESC

0.0082 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-28' AND `url` = 'https://www.maineventtravel.com/live-reporting/bom-main-event/1B/updates'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

0.0003 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0005 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0063 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

0.0005 SECONDS:
SELECT tour_stop_blogs.*, 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.logo as tour_stop_logo, 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 `friendly_url` = 'bom-main-event'

0.0002 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '1'

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

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

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

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

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

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

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

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

0.0118 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '1' AND `name` = '1B'

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

0.0042 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '4' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.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` = '107' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0062 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '4' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

English
Battle of Malta 2019 Main Event Live Reporting - Day 4
Current Level 37 Current Day 4
Blinds 400,000/800,000 Ante 800000
Entries 4,657 Remaining 1
Prize Pool (EUR) €2,258,645 First Prize (EUR) €306,205
1 New Update - Click to refresh
Live Updates - Day 1B
12:56 (UTC+2)
Day 1B of Battle of Malta 2019 Ended
Level: 15     Blinds: 2500/5000     Ante: 5000
Niko Pakalen Takes the Day 1b Lead; 88 Progress Posted Friday 18th October, 2019 at 02:21(UTC+2) by Gia Carnestorm

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

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

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

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

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

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

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

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

Be sure to stay tuned to the live updates as we bring you all the coverage from the Intercontinental Hotel and Casino Malta here at the Battle of Malta.

Player Chips Progress
Salvatore Motta 240,000 215,000
Stefanacci Money Bubbles Posted Friday 18th October, 2019 at 01:52(UTC+2) by Gia Carnestorm

The flop was down , and Stefano Stefanacci checked.

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

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

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

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

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

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

Player Chips Progress
Salvatore Motta 240,000 215,000
2018 BOM Main Event Runner-Up Canevet Eliminated Posted Friday 18th October, 2019 at 01:44(UTC+2) by Gia Carnestorm

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

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

Canevet:

Clarke:

Board:

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

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

Player Chips Progress
Patrick Ignatius Clarke 360,000 80,000
Maxime Thien-Duc Canevet 0 0
00:52 (UTC+2)
Start of Level 15
Blinds: 2500/5000     Ante: 5000
O'Hare Can't Connect Posted Friday 18th October, 2019 at 00:51(UTC+2) by Gia Carnestorm

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

Ovidiu-Dorin:

O'Hare:

Board:

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

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

Player Chips Progress
Ovidiu-Dorin Barna 190,000 235,000
Chris Ohare 0 0
00:26 (UTC+2)
Start of Level 14
Blinds: 2000/4000     Ante: 4000
Toffel Eliminated by Gaetano Posted Friday 18th October, 2019 at 00:09(UTC+2) by Gia Carnestorm

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

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

Gaetano:

Toffel:

Board:

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

Player Chips Progress
Gaetano Ricciardi 80,000 55,000
Toffel Danny 0 0
Worthington-Leese Over 400,000 Posted Friday 18th October, 2019 at 00:01(UTC+2) by Chris Martin

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

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

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

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

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

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

Player Chips Progress
Mick Mccloskey 85,000 60,000
Mario Ripepi 80,000 55,000
Clarke Joins the Chip Leaders Posted Thursday 17th October, 2019 at 23:45(UTC+2) by Chris Martin

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

Kapatsoris Stylianos:
Patrick Clarke:

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

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

Player Chips Progress
Pekka Aulis Kristian Virtanen 350,000 220,000
Patrick Ignatius Clarke 280,000 255,000
Stene-Johansen Ola 270,000 245,000
Kapatsoris Stylianos 0 0
23:38 (UTC+2)
Start of Level 13
Blinds: 1500/3000     Ante: 3000
Break Posted Thursday 17th October, 2019 at 23:19(UTC+2) by Gia Carnestorm

The players are on a 20-minute break.

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

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

Three players called, and the appeared on the river. 

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

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

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

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

Lakerveld showed but was no good against the of Barna.

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

Player Chips Progress
Ovidiu-Dorin Barna 225,000 200,000
Daniel Lakerveld 150,000 30,000
Crawley-Boevey Shoves Posted Thursday 17th October, 2019 at 22:56(UTC+2) by Gia Carnestorm

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

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

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

Player Chips Progress
James Ian Crawley-Boevey 200,000 147,000
Fabio Frusca 50,000 25,000
Hesp Eliminated by Ruggeri Posted Thursday 17th October, 2019 at 22:54(UTC+2) by Chris Martin

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

John Hesp:
Umberto Ruggeri:

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

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

Player Chips Progress
Umberto Ruggeri 75,000 25,000
John Hesp 0 0
22:39 (UTC+2)
Start of Level 12
Blinds: 1000/2500     Ante: 2500
Playing Down to 88 Players on Day 1b Posted Thursday 17th October, 2019 at 22:35(UTC+2) by Chris Martin

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

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

Player Chips Progress
Alan Ronald Keith Vinnicombe 85,000 60,000
Fracas Triples Up Posted Thursday 17th October, 2019 at 22:33(UTC+2) by Gia Carnestorm

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

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

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

Xanthopoulos:

Fracas:

Amor:

Board:

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

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

Player Chips Progress
Mugurel Fracas 90,000 65,000
Pavlos Xanthopoulos 65,000 40,000
Pablo Amor Bolado 10,000 15,000
Vinnicombe Goes from 3k to 80k Posted Thursday 17th October, 2019 at 22:17(UTC+2) by Chris Martin

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

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

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

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

Player Chips Progress
Alan Ronald Keith Vinnicombe 85,000 60,000
Benguigui Eliminated Posted Thursday 17th October, 2019 at 21:59(UTC+2) by Gia Carnestorm

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

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

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

Player Chips Progress
Simon Anthony Forster 160,000 7,000
21:56 (UTC+2)
Start of Level 11
Blinds: 1000/2000     Ante: 2000
Marinelli Departs Posted Thursday 17th October, 2019 at 21:44(UTC+2) by Gia Carnestorm

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

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

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

Marinelli revealed but was behind to

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

Player Chips Progress
Morten Mathiesen 120,000 15,000
Dario Marinelli 0 0
Big Stacks After Dinner Posted Thursday 17th October, 2019 at 21:31(UTC+2) by Chris Martin
Player Chips Progress
Pasquale Braco 268,000 17,000
Mateusz Wozniak 240,000 20,000
Gulas Josef 180,000 10,000
Mehmet Sirin Ongorur 175,000 143,000
Robert Cabral Lim 170,000 10,000
Simon Anthony Forster 167,000 142,000
Hossein Bagheri Semnani 165,000 140,000
Antonello Ferraiuolo 160,000 135,000
Konstantin Faerber 153,000 128,000
Massimo Segatto 145,000 120,000
Giorgio Marletta 130,000 105,000
Pekka Aulis Kristian Virtanen 130,000 105,000
Odd Inge Hurlen 125,000 100,000
Dorian Lionel Quentin Mouton 27,000 0
21:18 (UTC+2)
Start of Level 10
Blinds: 800/1600     Ante: 1600
Dinner Break Posted Thursday 17th October, 2019 at 20:07(UTC+2) by Chris Martin

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

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

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

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

MacIntyre held and was up against

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

Updated Chip Counts Posted Thursday 17th October, 2019 at 19:50(UTC+2) by Gia Carnestorm
Player Chips Progress
Mateusz Wozniak 220,000 35,000
Gulas Josef 190,000 165,000
Robert Cabral Lim 180,000 42,000
Ulysse Arnaud Maurice Harry 170,000 145,000
Virginijus Lapenas 140,000 115,000
Claudio Leonardo Pagano 130,000 105,000
Anthony Derek Gardner 120,000 95,000
Rickard Dery Esbeoglu 110,000 85,000
Ian Simpson 70,000 44,000
Dara Ruairi O`Kearney 60,000 5,000
Battle of Malta Pink October Charity Raffle Posted Thursday 17th October, 2019 at 19:49(UTC+2) by Chris Martin

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

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

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

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

Pasquale Braco:
Michele Manzi:

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

Player Chips Progress
Pasquale Braco 285,000 260,000
Michele Manzi 0 0
19:30 (UTC+2)
Start of Level 9
Blinds: 600/1200     Ante: 1200
Wozniak Cracks Kings to Soar Up the Counts Posted Thursday 17th October, 2019 at 18:55(UTC+2) by Chris Martin

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

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

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

Player Chips Progress
Mateusz Wozniak 185,000 85,000
Francesco Aprigliano 0 0
Kings Best for Lim Posted Thursday 17th October, 2019 at 18:53(UTC+2) by Gia Carnestorm

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

Lim held , and it was for Giordano. 

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

Player Chips Progress
Robert Cabral Lim 120,000 102,000
Alessandro Giordano 0 0
Battle of Malta Day 1b Intro Posted Thursday 17th October, 2019 at 18:41(UTC+2) by Chris Martin

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

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

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

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

Player Chips Progress
Daniel Carlsson 41,000 1,000
18:36 (UTC+2)
Start of Level 8
Blinds: 500/1000     Ante: 1000
O'Hare Doubles Through Marinelli Posted Thursday 17th October, 2019 at 18:35(UTC+2) by Chris Martin

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

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

Player Chips Progress
Chris Ohare 45,000 20,000
Dario Marinelli 21,000 51,000
Big Stacks Begin to Emerge Posted Thursday 17th October, 2019 at 18:28(UTC+2) by Chris Martin

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

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

Player Chips Progress
Dominik Martan 140,000 115,000
Antonello Ferraiuolo 135,000 110,000
Mark Attard 130,000 105,000
Philip Andrew Young 125,000 100,000
Stene-Johansen Ola 120,000 95,000
Milos Babovic 115,000 90,000
Simon Anthony Forster 110,000 85,000
Jamie Colin Munro 85,000 60,000
Raymond Forsland 85,000 60,000
Jaksland Eliminated by Kovacs Posted Thursday 17th October, 2019 at 18:24(UTC+2) by Gia Carnestorm

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

Jaksland held for middle pair, and Kovacs had

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

Player Chips Progress
Csaba Kovacs 65,000 40,000
Peter Jaksland 0 0
18:11 (UTC+2)
Start of Level 7
Blinds: 400/800     Ante: 800
Break Posted Thursday 17th October, 2019 at 17:37(UTC+2) by Chris Martin

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

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

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

Simpson:

Pierreyves:

Board:

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

Player Chips Progress
Ian Simpson 26,000 0
Joubert Pierreyves Jean Franci 9,000 16,000
Lehtonen Runs into Aces Posted Thursday 17th October, 2019 at 17:33(UTC+2) by Chris Martin

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

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

Seppo Lehtonen:
Renato Messina:

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

Player Chips Progress
Renato Messina 40,000 40,000
Seppo Ilmari Lehtonen 0 0
Top Top for Marinelli Posted Thursday 17th October, 2019 at 17:24(UTC+2) by Gia Carnestorm

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

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

Player Chips Progress
Dario Marinelli 72,000 47,000
Kristoffer Skolem 12,000 13,000
Get to Know BOM Masseuse Dana Perianu Posted Thursday 17th October, 2019 at 17:21(UTC+2) by Chris Martin

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

Download the Battle of Malta App! Posted Thursday 17th October, 2019 at 17:16(UTC+2) by Chris Martin

Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year.

Players can download the app anytime by visiting bom.beezer.com

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

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

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

Player Chips Progress
Maxime Thien-Duc Canevet 25,000 0
Red Electrick Set to Play Battle of Malta Players Party Posted Thursday 17th October, 2019 at 17:08(UTC+2) by Chris Martin

Image result for red electrick battle of malta

The main Battle of Malta Players Party is taking place at exclusive Paranga Beach, the Intercontinental Hotel’s private beach club, from 8 pm on Sunday (October 20). Hit Maltese band Red Electrick is on the bill, ensuring this will be a night to remember for all Battle of Malta players.

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

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

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

Morten Mathiesen:
Danilo Colomba:

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

Player Chips Progress
Morten Mathiesen 65,000 40,000
Danilo Colomba 0 0
16:57 (UTC+2)
Start of Level 6
Blinds: 300/600     Ante: 600
Krcova River Raise Posted Thursday 17th October, 2019 at 16:50(UTC+2) by Gia Carnestorm

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

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

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

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

Player Chips Progress
Michele Manzi 65,000 40,000
Jana Krcova 37,000 12,000
Gilboa Misses to Depart Posted Thursday 17th October, 2019 at 16:29(UTC+2) by Gia Carnestorm

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

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

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

Player Chips Progress
James Ian Crawley-Boevey 39,000 14,000
Uri Gilboa 0 25,000
Updated Notable Stacks Posted Thursday 17th October, 2019 at 16:25(UTC+2) by Chris Martin
Player Chips Progress
Dara Ruairi O`Kearney 65,000 40,000
Sander Floris Van Van Wesemael 57,000 32,000
Leo Dominic Worthington-Leese 49,000 24,000
John Hesp 30,000 12,000
Florence Yvette Suzanne Mazet 27,000 2,000
Fraser Macintyre 22,000 3,000
16:20 (UTC+2)
Start of Level 5
Blinds: 200/500     Ante: 500
Win for Hesp Posted Thursday 17th October, 2019 at 16:14(UTC+2) by Gia Carnestorm

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

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

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

Player Chips Progress
John Hesp 42,000 17,000
Valentin-Marius Cristea 32,000 7,000
Download the Battle of Malta App Posted Thursday 17th October, 2019 at 16:01(UTC+2) by Chris Martin

Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting bom.beezer.com 

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

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

Lars Olsson:
Carl Brandt:

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

Player Chips Progress
Lars Olsson 15,000 10,000
Carl Nicklas Brandt 12,000 13,000
Jacks Hold for Grech Posted Thursday 17th October, 2019 at 15:54(UTC+2) by Gia Carnestorm

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

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

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

Player Chips Progress
Andre' Grech 37,000 12,000
Mehmet Sirin Ongorur 32,000 7,000
Epic Recovery From Hills Posted Thursday 17th October, 2019 at 15:43(UTC+2) by Chris Martin

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

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

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

Player Chips Progress
Andy Hills 29,000 12,500
15:39 (UTC+2)
Start of Level 4
Blinds: 200/400     Ante: 400
Break Posted Thursday 17th October, 2019 at 15:24(UTC+2) by Gia Carnestorm

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

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

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

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

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

Pejic showed for two pair, and Andren open-mucked

Player Chips Progress
Marko Pejic 45,000 20,000
Filip Theodor Anders Andren 18,000 7,000
Hills Doubles Posted Thursday 17th October, 2019 at 15:02(UTC+2) by Gia Carnestorm

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

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

Pavlov:

Hills:

Board:

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

Player Chips Progress
Dmitry Pavlov 50,000 25,000
Andy Hills 16,500 8,500
Scary Runout Slows Down Hynes Posted Thursday 17th October, 2019 at 14:51(UTC+2) by Chris Martin

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

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

Player Chips Progress
Aidan Paul Hynes 30,000 5,000
Robert Cabral Lim 18,000 7,000
14:37 (UTC+2)
Start of Level 3
Blinds: 100/300     Ante: 300
Chica Flops the Nuts Posted Thursday 17th October, 2019 at 14:35(UTC+2) by Gia Carnestorm

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

Both players checked, and the river card was the

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

Chica showed for the flopped straight, and Mouton mucked. 

Player Chips Progress
Oscar Chica Quintero 29,000 4,000
Dorian Lionel Quentin Mouton 27,000 2,000
Barclay Folds to Garaialde Posted Thursday 17th October, 2019 at 14:26(UTC+2)

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

Barclay eyed his opponent steadily.

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

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

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

Player Chips Progress
Jon Martinez de Antonana Garaialde 45,000 20,000
Christopher Donald Barclay 20,000 5,000
Davey Cracks Kings Posted Thursday 17th October, 2019 at 14:23(UTC+2)

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

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

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

Player Chips Progress
Oyvind Wroldsen 37,000 12,000
Daragh Davey 29,000 4,000
Mielczarek Wins With Tens Posted Thursday 17th October, 2019 at 14:13(UTC+2)

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

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

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

Mielczarek revealed and Danielsen mucked .

Player Chips Progress
Bartosz Mielczarek 27,000 2,000
Stian Werum Danielsen 22,000 3,000
13:55 (UTC+2)
Start of Level 2
Blinds: 100/200     Ante: 200
Trips for Konstantinos Posted Thursday 17th October, 2019 at 13:55(UTC+2)

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

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

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

Player Chips Progress
Konstantinos Souliotis 32,000 7,000
Sally Jane Stephens 18,000 7,000
Day 1b Field Closing in on 400 Players Posted Thursday 17th October, 2019 at 13:46(UTC+2)

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

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

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

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

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

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

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

Live Updates by Will Shillibier and Aaron McBride

The 2019 Battle of Malta continues today with the second of five starting flights, with this year's €555 buy-in Main Event expected to be the biggest in Battle of Malta history.

Yesterday's Day 1a saw 333 entrants compete, and with the action in level 14, the money bubble burst, leaving 50 players remaining to progress to Day 2 on Sunday, October 20.

Last year a whopping 3,816 players smashed the €1m guarantee, and this year, thousands of players will be competing in Malta’s biggest poker tournament, including hundreds of qualifiers from MPNPT, 888poker and Italian site Vincitu.

Year Entrants
Name Country Payout
2018 3,816 Julien Stropoli France €168,500*
2017 2,074 Nadav Lipszyc Israel €200,000
2016 1,813 Robert Berglund Sweden €160,000
2015 1,804 Nicolas Proust France €110,000*
2014 1,447 Antoan Katsarov  Bulgaria €122,750
2013 888 Louis Cartarius Germany €68,000
2012 349 Nicodemo Piccolo Italy €35,000

*denotes deal

The award-winning Battle of Malta is being hosted by Casino Malta at the luxurious InterContinental Hotel in St Julian’s from October 15-22

Malta-based French player Julien Stropoli won last year's Main Event for €168,500, the best cash of his live poker career. The star-studded final table included previous MPN Poker Tour finalist Mantas Urbonas, two-time Unibet Open champion Mateusz Moolhuizen and Grosvenor Ambassador Andy Hills.

Main Event Structure

With unlimited re-entries until the end of level 10, there will be five start flights in total – with many flights expected to sell out. Players will kick off with a 25,000 starting stack and 40-minute blind levels. In the final Day 1e start flight, players will get a 10,000 starting stack and 10-minute levels. Each Day 1 will play down to 15% of the field – with all survivors making the money.

Bowling Competition

On Saturday (October 19), Battle of Malta is hosting a Bowling Competition at the Eden SuperBowl opposite the tournament venue. Four seats for Battle of Malta 2020 are up for grabs for each member of the four-person winning team . Teams of four should register in advance at the Eden Super Bowl, which is right across the road from the Intercontinental.

Players Party

The main Battle of Malta Players Party is taking place at exclusive Paranga Beach, the Intercontinental Hotel’s private beach club, from 8 pm on Sunday (October 20). Hit Maltese band Red Electrick is on the bill, ensuring this will be a night to remember for all Battle of Malta players.

New App

Battle of Malta has created a new app – available for both iOS and Android. The app has a host of features including instant notifications, the latest BOM news, the BOM twitter feed, 2020 tournament schedule, and the chance to win a seat for the 2020 edition of the event next year. Players can download the app anytime by visiting bom.beezer.com or using the QR code below.

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

13:06 (UTC+2)
Day 1B of Battle of Malta 2019 Started
Level: 1     Blinds: 100/100     Ante: 100

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.