0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0097 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-04-20'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/9/35/updates'
ORDER BY `views` DESC

0.0011 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/9/35/updates', 1, '2024-04-20')

0.0005 SECONDS: 
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '9'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0088 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1692'
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` = '1691'
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` = '1690'
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` = '1689'
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` = '1688'
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` = '1687'
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` = '1686'
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` = '1685'
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` = '1684'
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` = '1683'
ORDER BY `chip_change` DESC, `busted` ASC

0.0105 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.0223 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.0109 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.0098 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.0061 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.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` = '1698'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0098 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

    

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

Translate

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

Battle of Malta 2022 Main Event Live Reporting - Day FINALTABLE

Current Level 30 Current Day FINALTABLE

---

Blinds 60,000/120,000 Ante 120,000

Entries 208 Remaining 1

---

Prize Pool (EUR) €2,084,160 First Prize (EUR) €302,000

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

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