0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0117 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-12' AND `url` = 'https://www.maineventtravel.com/live-reporting/battleofmalta-2022' ORDER BY `views` DESC

0.0200 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-12' AND `url` = 'https://www.maineventtravel.com/live-reporting/battleofmalta-2022'

0.0004 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.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

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

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

0.0005 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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

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

0.0005 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.0003 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0005 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 `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0010 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.0004 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.0119 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.0008 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` = 'battleofmalta-2022'

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

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

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

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

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

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

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

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

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

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

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

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

0.0005 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '9' AND `name` = 'FINALTABLE'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

English
Battle of Malta 2022 Main Event Live Reporting - Day FINALTABLE
Current Level 30 Current Day FINALTABLE
Blinds 60,000/120,000 Ante 120000
Entries 208 Remaining 1
Prize Pool (EUR) €2,084,160 First Prize (EUR) €302,000
1 New Update - Click to refresh
Live Updates - Day FINALTABLE
13:08 (UTC+1)
Day FINALTABLE of Battle of Malta 2022 Ended
Level: 30     Blinds: 60,000/120,000     Ante: 120,000
Dimitrios is BoM Main Event Champion - Winning €285,900 Posted Thursday 13th October, 2022 at 05:33(UTC+1) by Lina Olofsson

Our day is complete and we have a new Champion!

As you may have surmised -  Dimitrios Anastakis took the gold - deservedly so in many ways.

The final hand saw him get a tad fortunate, raise-callingvs the shove with the superior of Rinne.

A board of saw Dimitrios bury his head in his hands in joy -  a lucky result on this hand, but a deserved one in many ways, given the high-calibre manner in which he'd conducted himself over the whole tournament.

He'd carved out a deal earlier - Toivo Rinne (the runner-up) received €165,900 for 2nd - his thoughtful, aggressive play carrying him from a short stack coming into the final to 2nd in the results - 2nd place for  €165,900 a deseved result given how he played.

Dimitrios Anastasakis though is the 2022 BoM Champion and he utterly deserves it. He's put barely a foot wrong and made a number of high quality decisions coming into the day,

We saw Anastasakis play numerous hands throughout the tournament and whilst you can get lucky or not with those hands, we saw him play them with skill and panache.

Every player we spoke to, who had played with Anastasakis commented on what a fun guy he was to play with. The "fun" was not some slight on his skill level either - all acknowledged he could play cards, but his charisma and amiable character made him a fun guy to share the felt with.

We watched time and again as players busted to him - ready to fistbump their vanquisher - an excellent indication of someone conducting themselves well at the table.

Overall he deserved a deep run. Lucky, yes in many ways, Skillful though? Undoubtedly. It's been a week all of us can look back on with affection. There's been drama, passion and unbelievable prizes. Players have spilt their voices,  souls and bankrolls in a bit to get here and well they might.

Great tournament, great result and great champion.

Thanks for following - we've appreciated the support and we can't wait to meet you at the next one. A quick shout out to the tournament staff who've been as close to flawless as you can get.  There have been hundreds of thousands of hands dealt and the dealers and floor staff should get a special mention for their tireless work, making our lives easier and ensuring the players have had a trouble-free tournament. You guys rock.

So, sadly, that is it from us. Malta's been a wonderful trip and the Battle of Malta week-long festival has been a blast. Thank you for having us, well done to our winner and take care one and all till next time.

Jarman's Brave Fight Ends 3rd - €125,200 Posted Thursday 13th October, 2022 at 05:02(UTC+1) by Lina Olofsson

Will Jarman has proved a sticky, durable character at this final table and throughout the tournament. His decision making has been precise, considered and generally very accurate. A pure example of how young player should conduct themselves at the table.

We've watched him take time in breaks to assess the levels, chip stacks and general tournament milieu to ensure all the information was available to him before making a decision. This precision level of detail has served him well and his elimination was a function of bad luck rather than a misdecision,  as his lost out to - something beyond his control.

Jarman though, despite having relatively few notable scores on his hendon mob, has shown he is a tough, capable NLHE player and on another day he could easily have taken down this tournament.

Today though, the above beat meant he finishes in 3rd place for a "mere" €125,200. It's an incredible score, amd Will should be proud but his demeanour suggests he will be around for a long time. This is just the beginning...

Houssais busted in 4th - Harsh But €72,540 Reward Posted Wednesday 12th October, 2022 at 23:16(UTC+1) by Lina Olofsson

S

Sometimes, there's no avoiding the fates laid out to you. With stack sizes dwindling relative to the blinds Emmanuel Houssais and Anastasakis Dimitrios went to a flop of with  for Houssais -  a strong hand on this board....but crucially for Dimitrios for the stone cold nuts.

The pair went to war, understandably, but Houssais came out the worse for wear and left with just a few big blinds, he succumbed shortly afterward, collecting the impressive score of €72,540 for his performance. Houssais has proved a durable, competent and engaging character during this tournament. His rail have cheered him with great gusto - always a sign this is a charismatic player - and we've enjoyed his performance immensely.

Congratulations Emmanuel - we continue three-handed for the trophy...

Zambonelli in Massive Cooler - Busted 5th €52,420 Posted Wednesday 12th October, 2022 at 21:09(UTC+1) by Lina Olofsson

Carnage in the blinds as Zambonelli is dealt in the small blind as simultaneously Rinne has in the big blind.

"This is going all-in" the perspicacious David Lappin astutely observes and so it proves, Zambonelli raising, Rinne shoving and the Italian making the call.

All very fair and defensible poker - just an absolute cooler for Rinne.

It looked like the Finn was heading to the cash desk but then, the poker gods intervened, running the board out to give Rinne a winning flush and a massive stack - he's now the chip leader with 35M!

He embraced his friend on the rail with such gusto it looked like  they might crush each other to death. Meanwhile a more mellow and sombre Zambonelli was down to just 4.7M.

"What a pot for RInner to take down....fantastic stuff," Lappin observes while his co-commentator sums up the crowd's emotions with the succinct phrase, "absolute scenes."

Zombonelli lasted a few more hands with his few big blinds before running a race with 99 v the J-Q of Demetrios and that was his day done. THe Italian's been a fun feature of the final table - can take pleasure in his performance & indeed the €52,420 that he gets for his 5th place finish. Well played!

Re Crippled Then Straight KO - 6th €40260 Posted Wednesday 12th October, 2022 at 20:35(UTC+1) by Lina Olofsson

Gabriele Re just saw his attempts to become the Battle of Malta champion turn to dust in just a few hands.

The first saw him make a move on Dimitros, who popped it up to 1.7M on the button. Re with 12.6M thought this raise was suspicious and his was good enough to re-steal with. He raised to 8M committing himself but back to Dimitros - he had an easy decision, holding - allin.

Re called his last 4.6M only to discover he was in pretty bad shape.

Still - any ace, three clubs and the pot could be his...

The flop didn't play nice though brought him no succour and he was down to just a few big blinds. These went in shortly afterward and Re had found a very strong hand in pocket Queens!

His jam was only called by Zambonelli in the BB with . He was set for a double but then the board fell

Incredibly Zambonelli cracked his queens and after a long, quiet passage of play with few eliminations, Re is first to fall in 6th place for €40,200.

Congratulations Gabriele, you played a blinding tournament, made very few mistakes and can be proud of your efforts here in Malta.

Zombonelli Holds Slim Advantage Posted Wednesday 12th October, 2022 at 18:24(UTC+1) by Lina Olofsson

Zambonelli now holds a slight lead - but the stacks are so evenly matched that this could change in just a moment.

Name Big Blinds Chip Stack
C Zambonelli 42BB 21M
A Dimitrios 39BB 20M
W Jarman 37BB 19M
T Rinne 34BB 17M
G Re 33BB 17M
E Houssais 29BB 15M
Barone out in 7th - €33,220 Posted Wednesday 12th October, 2022 at 17:03(UTC+1) by Lina Olofsson

Barone's been a joy to cover - funny, amiable and inventive but he is out in 7th as his A-Q fails to beat DImitros pocket tens.

Congratulations on the €33,220 - we continur 6-handed with Dimitros now holding a sizable lead...

How are they doing? Posted Wednesday 12th October, 2022 at 16:32(UTC+1) by Lina Olofsson

Here's the chips as we move close to the first break of the day.

Barone is the short stack but it's testament to the structure that he still has some room for manoeuvre with an 18BB stack. Dimitrios with a healthy lead over Will Jarman in 2nd.

Name Big Blinds Chip Stack
A Dimitrios 88BB 26M
W Jarman 67BB 20M
G Re 57B 17M
C Zambonelli 51BB 15M
E Houssais 47BB 14M
T Rinne 30BB 9.1M
C Barone 18BB 5.5M
Azulay Downed in 8th place - €28,200 Posted Wednesday 12th October, 2022 at 16:14(UTC+1) by Lina Olofsson

Azulay's stack was in danger of utterly disappearing into the blinds so with 3BB he jammed form the cutoff with a pretty decent hand - .

E Houssais realised his was likely in pretty good shape so made a small re-raise to 1.3M to isolate - Jarman folded and the pair were heads up for the pot.

Bad flop for Azulay as it comes (huge cheer from Houssais boisterous rail) and the on the turn just made matters worse, leaving Azulay just one nine in then deck to hit. The was not it and we lose the Israeli in 8th position for €28,200.

Congratulations!

Have Some Chips Posted Wednesday 12th October, 2022 at 15:52(UTC+1) by Lina Olofsson

Here's how they stand - Dimitrios Anastasakis cruising into the lead while Azulay is well in the danger zone with 6BB. He recently played out a hand with pocket fours versus Will Jarman's pocket queens - Jarman drawing the max from the hand when Azulay decided to make a slightly strange 1M bet on the river.

That hand leaves the player standings as below:

Name Big Blinds Chip Stack
A Dimitrios 111BB 28M
W Jarman 90BB 23M
G Re 58BB 15M
E Houssais 44BB 11M
C Zambonelli 44BB 11M
C Barone 38BB 9.6M
T Rinne 33BB 8.5M
C Azulay 6BB 1.7M
All-in Moment War of the Ladies Posted Wednesday 12th October, 2022 at 15:34(UTC+1) by Lina Olofsson

There's been a relatively quiet period since Nanos was KO'd.

Finally though a huge hand brews. From the player perspective, it's exciting as Anastakis raises to 600k, Barone (pictured) 3-bets and Anastakis shoves, Barone calls his stack off!

The excitement quickly died down - Barone laughing as both players showed pocket queens. No four flush and the two of them chop the pot. As you were!

Nanos Out 9th - €25,120 Posted Wednesday 12th October, 2022 at 15:15(UTC+1) by Lina Olofsson

We've lost the first player of the day and it's Konstantinos Nanos who is the player to go. Unfortunately our stream cut out just prior to the elimination so we don't have details of the hand!

We'll get this info and update this shortly but for now Nanos is off to the cash desk to collect his  €25,120 - congratulations on making the final and a decent score.

The rest of the players continue 8-handed and have a little more room at the table...

Winner Winner Rinne Dinner Posted Wednesday 12th October, 2022 at 15:02(UTC+1) by Lina Olofsson

Toivo Rinne just made the first significant move of the day - Christian Zambonelli raising to 600 from the hijack, only for Rinne to "stick it in his eye" - to use some slightly dated poker parlance - and jam for 3.2M.

Tough decision for Zambonelli with but he emerged from a short tank with a call - and it was a good one as Rinne tabled the nominally-behind but live .

The board was intriguing - falling to gove Zambonelli top pair but Rinne a flush draw and the completed Rinne's flush - much to his delight. The on the river was irrelevant and Rinne takes a big step forward, doubling to 7.1M while Zambonelli is down to 12M...

Battle of Malta - Final Table - The Fight For Glory! Posted Wednesday 12th October, 2022 at 14:01(UTC+1) by Lina Olofsson

Welcome to the Final table of the €1,000,000 Gtd Battle of Malta!

The guarantee is now a vestige of the past as the 4,000+ runners & rebuys ensured we smashed that to smithereens long ago. The total prize pool in fact has reached €2,084,160 which has left the remaining 9 players fighting it out for a very attractive top prize of €302,000.

Here are the players who'll be duking it out for the title today, WIll Jarman holding a slender lead over Dimitrios Anastasakis - those two well clear of the field, though if they take anything for granted, they will find the poker gods can be fickle masters!

We're about to start and the players wil line up as below:

Position Country Name Chip Count Table Seat
#1 Malta Will Jarman 21,975,000

1

5
#2 Greece Dimitrios Anastasakis  21,650,000

1

8
#3 Italy Cristiano Zambonelli   14,925,000

1

6
#4 Malta Emmanuel Houssais 13,600,000

1

3
#5 Italy  GABRIELE RE 12,725,000

1

9
#6 Italy  Claudio Barone 10,875,000

1

2
#7 Israel Omer Azulay  7,250,000

1

1
#8 Finland Toivo Rinne  3,225,000

1

7
#9 Germany KONSTANTINOS NANOS  2,000,000

1

4

Here are the payouts the players can expect: We're moments from the start. Remember you can catch all the action from the stream which you can find by clicking here. Thomas Kremser has just introduced the players, cards are in the air. Shuffle Up & Deal!

# 1 302,000.00 14.49%
# 2 181,000.00 8.69%
# 3 94,000.00 4.51%
# 4 72,540.00 3.48%
# 5 52,420.00 2.52%
# 6 40,260.00 1.93%
# 7 33,220.00 1.59%
# 8 28,200.00 1.35%
# 9 25,120.00 1.21%
13:53 (UTC+1)
Day FINALTABLE of Battle of Malta 2022 Started
Level: 30     Blinds: 60,000/120,000     Ante: 120,000

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.