0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/battleofmalta-2022/4/updates', 1, '2024-04-30')

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.0002 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.0065 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.0004 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.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '9'

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

0.0188 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0036 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '27'
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` = '28'
AND `published` = 1

0.0185 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` = '29'
AND `published` = 1

0.0239 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` = '30'
AND `published` = 1

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

0.0188 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` = '32'
AND `published` = 1

0.0184 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` = '33'
AND `published` = 1

0.0183 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` = '34'
AND `published` = 1

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

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '9'
AND `name` = '4'

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

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

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` = '1682'
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` = '1681'
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` = '1680'
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` = '1679'
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` = '1678'
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` = '1677'
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` = '1676'
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` = '1675'
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` = '1674'
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` = '1673'
ORDER BY `chip_change` DESC, `busted` ASC

0.0144 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1672'
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` = '1671'
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` = '1670'
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` = '1669'
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` = '1668'
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` = '1667'
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` = '1666'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0050 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.0046 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.0046 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '34'
ORDER BY `busted` ASC, `current_chips` DESC

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

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1682'
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` = '1681'
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` = '1680'
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` = '1679'
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` = '1678'
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` = '1677'
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` = '1676'
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` = '1675'
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` = '1674'
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` = '1673'
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` = '1672'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1670'
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` = '1669'
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` = '1668'
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` = '1667'
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` = '1666'
ORDER BY `chip_change` DESC, `busted` ASC

0.0047 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.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1735

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(3)
  • 888poker UK Poker League(3)
  • APAT(9)
  • APPT(2)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(2)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(1)
  • British Poker Series(9)
  • BSOP(4)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(11)
  • EAPT(2)
  • EPT(4)
  • Estrellas Poker Tour(2)
  • Eureka Poker Tour(3)
  • France Poker Series(3)
  • Gift Voucher(1)
  • Golden Nugget Grand Poker Series(1)
  • Grosvenor Casino Coventry(4)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/25(1)
  • Grosvenor Poker 25/50(34)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's Summer Fest(0)
  • GUKPT Grosvenor(6)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(0)
  • Irish Poker Tour(12)
  • Kings of Tallinn(0)
  • LAPT(3)
  • London Poker Festival(1)
  • Malta Poker Festival(1)
  • Master Classics of Poker(0)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(10)
  • North American Poker Tour(0)
  • Olympic Park Casino(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • RDS (Royal Dublin Society)(0)
  • Sky Poker Tour(2)
  • The Casino at Portomaso(3)
  • The Festival(3)
  • The Poker Room(1)
  • Triton Super High Roller Series(1)
  • UK Poker Championships(1)
  • UKIPT(3)
  • Unibet DeepStack Open(5)
  • Unibet Open(0)
  • Venetian Deepstack Extravaganza(2)
  • WPT(7)
  • WPT Alpha 8(3)
  • WPT Prime(6)
  • WPT Special Events(2)
  • WPT500(1)
  • WSOP(1)
  • WSOP Circuit Events(3)
  • WSOP International Circuit(3)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Flight FAQs
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll
  • IPT Portugal Adventure X Giveaway

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

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

Chip Leaders Day FINALTABLE

1

Anastasakis Dimitrios

107,500,000

Day 1A Day 1B Day 1C Day 1D Day 1E Day 1F Day 2 Day 3 Day 4 Day FINALTABLE

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 4

Battle of Malta Final Table Set - Jarman Leads Posted Tuesday 11th October, 2022 at 23:14(UTC+1) by Lina Olofsson

It took next to no time after dinner for the remaining players to fall and leave us with our final tablists with Will Jarman atop the chip counts with nine players remaining.

Panayiotis Patsalides fell in 13th, winning €19,750 before Paul Zehetleitner took his chances with A-J and around 1.5M. He was called in two spots and couldn't overcome both AT and QQ - his bid ending in 12th place for €19,750.

Fabian Egger ran into the human chip juggernaut that has been Will Jarman today. We're not sure exactly where the chips went in but we know at showdown Jarman's had overtaken Egger's pocket Queens - 11th place his reward for €21,860.

The Final elimination saw Marcelo Da Silva go for a blind steal with - only for Claudio Barone to make the call with and put him at risk of elimination on the cusp of the final table. Da Silva was behind in equity terms, but picked up a straight draw and then a flush draw to raise his hopes - only to dash them, Da Silva letting out a sigh of disappointment at the brick that ended his Battle of Malta participation in 10th for €21,860.

And that left us with our nine final tablists!

They wil line-up as follows:

#1	Will Jarman	21,975,000	26	5
#2	Dimitrios Anastasakis	21,650,000	26	8
#3	Cristiano Zambonelli	14,925,000	26	6
#4	Emmanuel  Houssais	13,600,000	26	3
#5	Gabriele Re	12,725,000	26	9
#6	Claudio Barone	10,875,000	26	2
#7	Omer Azulay	7,250,000	26	1
#8	Toivo Rinne	3,225,000	26	7
#9	Konstantinos Nanos	2,000,000	26	4

It's been an incredible journey to reach this stage and all these players will go to bed knowing they could be the next Battle of Malta champion. There's all the kudos and attention winning this tournament will entail but the prize money is nothing to sneeze at either. Here are the prizes that lie in store for them...

# 1	€302,000.00
# 2	€181,000.00
# 3	€94,000.00
# 4	€72,540.00
# 5	€52,420.00
# 6	€40,260.00
# 7	€33,220.00
# 8	€28,200.00
# 9	€25,120.00

Play will start at 14:00 and be streamed on twitch here so make sure you don't miss the final moments as we crown a new Battle of Malta champion. We can't wait to see how this incredible tournament pans out. See you tomorrow!

Huge Pot - Double Elimination - Brackley & Diola Down Posted Tuesday 11th October, 2022 at 21:32(UTC+1) by Lina Olofsson

Dimitrios Anastakis just dealt a double fatality at his table in an incredible hand that will give him every chance of reaching the final table in chip lead position.

Peter Brackley & Valentinos Diola(pictured) were his 2 victims. Brackley opened the hand, pushing all-in for around 5M from early position and Diola attempted to isolate, jamming for his 6M chips.

WIth this much action, it was a shock to see Anastakis reach for chips himself - and ALSO move all-in!

Incredible stuff & cards on their backs, Anastakis could hardly have been in a stronger position, holding v and in the hands of the two other players. Diola let out a groan once he saw the trouble he was in.

The flop of briefly threatened an upset but it failed to materialise and the two disappointed players fistbumped with Anastakis - who has a massive chip lead now - up to around 24.5 Million.

Meanwhile Brackley and Diola win €17,640 each for their 14th and 15th place finishes.

Re Leads FInal 16 at Dinner Break Posted Tuesday 11th October, 2022 at 19:56(UTC+1) by Lina Olofsson

The last 16 players left in the Battle of Malta Main Event have reached the end of the level, meaning it's time for the dinner break. It's been fast and furtious action all day, the chips have been moving about briskly, with hardly a shrinking violet in the field.

These are the chip leaders as we head into this 75 minute break, during which the players can plan their strategy to attack the run in to the final table.

Position	Name	Chip Count
1	Gabriele Re	17,300,000
2	William Jarman	14,000,000
3	Dimitrios Anastakis	14,350,000

Meanwhile, here are the guys who have just missed out by a fraction from final tabling the Battle of Malta. Frustrating but at least they had a decent cash to show for their work over the last few days...

# 16	15,580.00	0.75%	Zegal Stanislav
# 17	15,580.00	0.75%	Izvira Emilio
# 18	13,330.00	0.64%	Iannou Georgios
# 19	13,330.00	0.64%	Polyzos Potelis
# 20	13,330.00	0.64%	Cutajar Andrew

19:11 (UTC+1)

Start of Level 32
Blinds: 0/0     Ante: 0

Lay of the Land at the Break Posted Tuesday 11th October, 2022 at 19:06(UTC+1) by Lina Olofsson

Chip Counts at the break are as follows, William Jarman preserving a slender chip lead we think over Gabriele Re, though it's tight at the top! Peter Brackley (pictured) is also well in the reckoning...

Position	Name	Chip Count
1	William Jarman	12,500,000
2	Gabriele Re	12,400,000
3	Anastasakis Dimitrios	10,600,000
4	Peter Brackley	10,500,000
5	Fabian Egger	10,500,000
6	Claudio Barone	6,500,000
7	Cristiano Zambonelli	5,000,000
8	Valentinos Diola	4,400,000
9	Marcelo Da Silva	4,400,000
10	Emmanuel Houssais	3,400,000
11	Omer Azulay	3,000,000
12	Panayiotis Patsalides	3,000,000
13	Stanislav Zegal	2,915,000
14	Potelis Polyzos	2,700,000
15	Toivo Rinne	2,600,000
16	Konstantinos Nanos	2,525,000
17	Georgios Ioannou	2,500,000
18	Andrew Cutajar	2,200,000
19	Emilio Izvira	1,255,000

Head In The Claudio's Posted Tuesday 11th October, 2022 at 19:02(UTC+1) by Lina Olofsson

Claudio Barone just boosted his already booming stack a little further. Holding pocket fours, he raised to 270,000 - and was jammed on by either Gaetano Castagnolo or Francisco Moreno. Apologies we aren't sure which it was due to a slight mix-up (ok we split coffee on our notepad - don't mocha us.)

Anyway, the jam was for 1.2M, quick count from Barone and he called. for Moreno/ Castagnolo (or M/C as this unknown hybrid player shall now be known) and we were in a race. And it was a heck of a run-out.

- a flopped set for Barone but a flopped flush draw for M/C and on the - the flush came in!

M/C had eyes only for his flush and fist-pumped, turning away from the table with a celebratory yell. His attention was drawn back though as the hit the river, filling Barone up with a full house. Barone's congratulatory yell took over - a surprised M/C spinning round to see the bad news, the joy in his eyes melting away to disappointment.

That's the nature of poker for you! Fortunes are won and lost on the turn of a card and Barone's stack is now over the 8 million mark.

Meanwhile BOTH Moreno & Castagnolo have been eliminated. Here are the latest men to hit the sidelines.

Name	Payout	Position
Panarello Mario	11,070.00	# 21
Cenciarini Alessandro	11,070.00	# 22
Castagnolo Gaetano Montagno	11,070.00	# 23
Moreno Francisco Javier Gordillo	8,810.00	# 24
Jeremy Joseph Perici Calascione	8,810.00	# 25
Menelaou Theodosios	8,810.00	# 26
Iannaco Davide	8,810.00	# 27
Demos Demosthenous	7,100.00	# 28
Fossati Andrea	7,100.00	# 29
Angelousis Konstantinos	7,100.00	# 30
Martire Potito	7,100.00	# 31
D'alterio Luigi	5,800.00	# 32

Player		Chips	Progress
Claudio Barone		8,200,000	980,000
Moreno Francisco Javier Gordillo		0	0
Castagnolo Gaetano Montagno		0	0

Delicious Chips Posted Tuesday 11th October, 2022 at 17:03(UTC+1) by Lina Olofsson

The ebb and flow of tournament poker has seen some new faces bobbing to the surface - Will Jarman the latest name to find himself King of the Chip Throne.

He seems in great, relaxed spirits as well he might, chatting amiably with some friends on the rail - his dreams of winning the Battle of Malta gaining more credence with every moment.

Here are the rest of the counts as we stand:

Name	Chip Count
William Jarman	10,500,000
Peter Brackley	10,300,000
Valentinos Diola	10,000,000
Claudio Barone	7,000,000
Andrew Cutajar	4,900,000
Omer Azulay	3,800,000
Theodosios Menelaou	3,600,000
Potelis Polyzos	3,200,000
Cristiano Zambonelli	3,000,000
Alessandro Cenciarini	3,000,000
Georgios Ioannou	2,700,000
Panayiotis Patsalides	2,200,000
Mario Panarello	1,700,000
Emmanuel Houssais	1,700,000
Emilio Izvira	1,600,000
Gaetano Castagnolo	1,300,000
Francisco Moreno	1,250,000
Joseph Jeremy	560,000

Brackley the Stack G Posted Tuesday 11th October, 2022 at 16:07(UTC+1) by Lina Olofsson

Peter Brackley has turned his 2.3M starting stack into a 10.4M mega-stack over the course of the first two levels. Incredible.

We've seen him making some deft, aggressive moves and he's just taken out Andrea Fossati. We saw him tabling on a board versus Fossati's .

We didn't see where the chips went in but the flop is a strong candidate given the hands. Either way at showdown, ace-high was good and Brackley's stack gets ever more imposing...

Fossati exits in 29th for €7,100.

That brings us to the end of level 29 - and the players get their first 15 minute break of the day.  We're already down to 26 players - today is going to be extremely frenetic. Hold tight!

We'll be back in 15...

Player		Chips	Progress
BRACKLEY PETER		10,400,000	8,100,000
Fossati Andrea		0	0

Dreams Turning to Dust Posted Tuesday 11th October, 2022 at 15:29(UTC+1) by Lina Olofsson

33 players remain in the Main Event but these are the players to see their hopes of BoM glory crumble to dust. No one's immune as former big stacks Sas Gusti and Domenico Gala have discovered.

They can console themselves with a nice cash from their initial entry & there's plenty of side events happening if they fancy taking a shot at another BoM tournament win. It's also a beautiful sunny day in Malta if the beach and a Hugo burger appeal.

Incidentally, if you come to Malta and you like burgers, try the Hugo burger. It's superb.

Name	Payout	Position
Siciliano Marco	€5,800	# 34
Sas Gusti	€5,800	# 35
HARRIS DAVID	€4,900	# 36
Gala Domenico	€4,900	# 37
Kerrien Clement	€4,900	# 38
Delpiano Dario	€4,900	# 39
Atzeni Luca	€4,000	# 40
Nania Cristian	€4,000	# 41
SAHLY TARIQ	€4,000	# 42
Castiglione Stefano	€4,000	# 43
Keskel Marko	€4,000	# 44
Connor Stephen David	€4,000	# 45

Superb Call Sends Anastasakis Flying Posted Tuesday 11th October, 2022 at 14:48(UTC+1) by Lina Olofsson

We just saw a tense hand play out between Marco Siciliano and Dimitrios Anastasakis.

Joining the hand on the turn of a board - Siciliano fired out 500,000 in position on the button - Anastasakis, seated two to his right, check-called.

The on the river was quickly checked by Anastasakis, leading Siciliano to fire out a whopping 1M bet in two big stacks of white 25k chips.

A long tank period followed - a very tough decision clearly for Dimitrios and eventually the clock was called. As the time elapsed and Thomas Kremser counted down 3...2....1, Anastasakis made the call at the last moment, picking up chips and putting them over the line.

Siciliano tapped the table in defeat instantly - showing for a failed bluff. Anastasakis though tabled pocket sevens for a really strong, tough call. Well played! He apologised to his table for taking so long but they were in forgiving mood - it was a big moment.

Siciliano looked a little shocked - down to 1.2M while Anastasakis rises to 3.7M!

Meanwhile tablemate William Jarman has had a flying start also - up to 6.6M.

Player		Chips	Progress
Jarman William Joseph Raymond		6,600,000	3,390,000
Anastasakis Dimitrios		3,700,000	1,535,000
Siciliano Marco		1,200,000	1,775,000

Battle of Malta Day 4 - Barone Leads Last 45 Posted Tuesday 11th October, 2022 at 14:03(UTC+1) by Lina Olofsson

Exciting times! It's Day 4 of the €1M Gtd Battle of Malta Main Event and there are just 45 players still in contention for the title. Leading the charge is Claudio Barone, who has a whopper of a stack - 7,220,000. No wonder he gave us a thumbs up!

Valentinos Diola (5,600,000) & Andrea Fossati (4,200,000) are lurking just behind though and a fair wind could see them catch Barone. With €302,000 the attractive first place prize, these players have every incentive to roll their sleeves up and go for the jugular.

The players will be playing down to the final table, which will take place tomorrow at 14:00pm.

It will be live streamed - and today you can also follow the action here in Malta via this link. https://www.twitch.tv/battleofmalta

Apart from the Main Event, the €1k High Roller Dark Knight of Domusbet is playing out - and previous 2019 champion Chris Da Silva is chipped up and looking to add another High Roller title to his impressive poker resumé.

The stakes are high today and we look forward to watching every captivating decision. Reputations will be forged, as the poker gods determine whose hopes will be dashed and who will write their name into Battle of Malta history.

Shuffle up and deal - day 4 is underway!

13:58 (UTC+1)

Day 4 of Battle of Malta 2022 Started
Level: 26     Blinds: 25,000/50,000     Ante: 50,000

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter