0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0148 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-23' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/9/34/updates' LIMIT 1

0.0022 SECONDS:
INSERT INTO `page_views` (`url`, `date`, `views`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/9/34/updates', '2024-02-23', 1)

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

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

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

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

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

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

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

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

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

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

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

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

0.0094 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.0055 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.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` = '1682' 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` = '1681' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0070 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0070 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0069 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0107 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0128 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0071 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1674' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0096 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.0163 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.0091 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.0089 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.0047 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.0073 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '1682' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

Translate
Battle of Malta 2022 Main Event Live Reporting - Day FINALTABLE
Current Level 30 Current Day FINALTABLE
Blinds 60,000/120,000 Ante 120,000
Entries 208 Remaining 1
Prize Pool (EUR) €2,084,160 First Prize (EUR) €302,000
1 New Update - Click to refresh
Live Updates - Day 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
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.