0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0065 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/55/161/updates'
ORDER BY `views` DESC
0.0006 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` = '55'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '55'
0.1754 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0165 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '156'
AND `published` = 1
0.0872 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0095 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '159'
AND `published` = 1
0.0767 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0073 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '161'
AND `published` = 1
0.0262 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0577 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '163'
AND `published` = 1
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '161'
ORDER BY `busted` ASC, `current_chips` DESC
0.0051 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` = '161'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0152 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6973'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6970'
ORDER BY `chip_change` DESC, `busted` ASC
0.0892 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6969'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6961'
ORDER BY `chip_change` DESC, `busted` ASC
0.1626 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6960'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6959'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6958'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6957'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6956'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6955'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6954'
ORDER BY `chip_change` DESC, `busted` ASC
0.0110 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0582 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6952'
ORDER BY `chip_change` DESC, `busted` ASC
0.0127 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6950'
ORDER BY `chip_change` DESC, `busted` ASC
0.0636 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6949'
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` = '6948'
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` = '6947'
ORDER BY `chip_change` DESC, `busted` ASC
0.0125 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '161'
ORDER BY `busted` ASC, `current_chips` DESC
0.0060 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` = '161'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0900 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0172 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6973'
ORDER BY `chip_change` DESC, `busted` ASC
0.2772 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6970'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6969'
ORDER BY `chip_change` DESC, `busted` ASC
0.0754 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6961'
ORDER BY `chip_change` DESC, `busted` ASC
0.0127 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6960'
ORDER BY `chip_change` DESC, `busted` ASC
0.0119 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6959'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6958'
ORDER BY `chip_change` DESC, `busted` ASC
0.1816 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6957'
ORDER BY `chip_change` DESC, `busted` ASC
0.0114 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6956'
ORDER BY `chip_change` DESC, `busted` ASC
0.0101 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6955'
ORDER BY `chip_change` DESC, `busted` ASC
0.0782 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6954'
ORDER BY `chip_change` DESC, `busted` ASC
0.0210 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6952'
ORDER BY `chip_change` DESC, `busted` ASC
0.1596 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0168 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6950'
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` = '6949'
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` = '6948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6947'
ORDER BY `chip_change` DESC, `busted` ASC
0.0594 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '163'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2250
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
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Queens of Tallinn
2023 Queens of Tallinn
Live Reporting - Day 4
Current Level
0 Current Day
4 Blinds
- Ante
0
Entries
65 Remaining
1 Prize Pool (EUR)
€17,766 First Prize (EUR)
€6,167
Final Table Seat Draw Posted Saturday 2nd December, 2023 at 23:05(UTC+0) by Lina Olofsson
Here's tomorrow's seat draw for the 2023 Queens of Tallinn Main Event. Make sure to watch the live stream from 1.30 pm.
Good night from Hilton Park and Olympic Casino
Seat
Name
Country
Chips
1
Justina Andriukeviciute
Lithuania
197,000
2
Indre Martoviciute
Lithuania
270,000
3
Giedre Valgemae
Lithuania
83,000
4
Marta Porter
Lithuania
965,000
5
Hanna Heinlo
Estonia
226,000
6
Evely Pihela
Estonia
62,000
7
Catlin Muur
Estonia
62,000
8
Michelle Bricknell
UK
85,000
From left: Michelle Bricknell, Giedre Valgemae, Indre Martoviciute, Evely Pihela, Catlin Muur, Hanna Heinlo, Justina Andriukeviciute and Marta Porter
Marta Porter goes into the Final Table with a Monster Stack Posted Saturday 2nd December, 2023 at 22:25(UTC+0) by Lina Olofsson
The last two hours of today's play the Poker Gods were certainly with the always-so-happy and smiling Marta Porter. Already with two tables left, she had begun to build up her stack, and down to the last ten there just wasn't anything that didn't go her way.
When the nine players in the Main Event gathered on the very last table to play for the eight final table seats she already had a huge advantage with more than 200,000 to the second best in chips. And it didn't stop there. After eliminating Marianna Bastamow-Sinkko on the bubble she almost reached one million in chips. That's more than three times more than Indre Martoviciute and she has 50 percent of the chips in play before the final starts at 1 pm tomorrow. It will all be live-streamed on Olybet.tv so make sure you tune in and follow the action from the start (with a 30-minute delay).
The eight finalists in the Main Event
Player
Chips
Progress
Marta Porter
965,000
0
Indre Martoviciute
270,000
91,000
Hanna Heinlo
226,000
61,000
Justina Andriukeviciute
197,000
71,000
Michelle Bricknell
85,000
11,000
Giedre Valgemae
83,000
52,000
Evely Pihela
62,000
63,000
Catlin Muur
62,000
71,000
Interview Finalists Between Posted Saturday 2nd December, 2023 at 22:10(UTC+0) by Lina Olofsson
Going into tomorrow's final table Giedre is one of four Lithuanian players Giedre Valgemae. Yesterday one of her opponents in the final, our tv-host Evely Pihela, had a little talk with her.
Marianna Bastamow-Sinkko Eliminated in 9th Place Posted Saturday 2nd December, 2023 at 21:47(UTC+0) by Lina Olofsson
It was before the flop our chip leader Marta Porter min-raised to 12,000 in cutoff and was called by Marianna Bastamow-Sinkko from the button. The blinds folded.
On the flop both players checks. Turn is the and Marta bets 30,000 and Marianna pushes all-in for almost 200,000 and gets a call.
Marianna Bastamow-Sinkko: Marta Porter:
River didn't change anything and the kings held up for Marta who's now increased her lead until tomorrow's final even further and almost has a million in chips.
Marianna Bastamow-Sinkko bubbles the final table but gets a consolation prize with a ticket to the Irish Open.
Player
Chips
Progress
Marta Porter
965,000
475,000
Marianna Bastamow-Sinkko
0
0
Marianna Bastamow-Sinkko Duobles through Hanna Heinlo Posted Saturday 2nd December, 2023 at 19:41(UTC+0) by Lina Olofsson
There are eight prizes in this tournament but as I earlier mentioned in the report the Irish Open gives away a bubble prize to the one who final table bubbles here in the Main Event so all nine actually won't leave this tournament empty handed and one of them will be on her way to Ireland in March to compete there.
We just had our first all-in since they got down to nine and it was Marianna Bastamow-Sinkko who was the player at risk as her Ace-King was all-in against her fellow countrymen (woman) Hanna Heinlo with Ace-Queen. The best hand held up for Marianna and the play continues.
Player
Chips
Progress
Marianna Bastamow-Sinkko
200,000
90,000
Hanna Heinlo
165,000
101,000
Kairit Leibold Eliminated in 10th Place Posted Saturday 2nd December, 2023 at 19:13(UTC+0) by Lina Olofsson
Finding herself with only 37,000 left in her stack on these high blinds Kairit Leibold needed a double up and pushed her chips into the middle with King-Three and was called by our chip leader Marta Porter who made the call with Ace-Four.
An ace on the flop didn't give our sunshine Kairit much hope and no help on the turn or the river sent her out in tenth place here in the Main Event and we are down to the very last table where just one more to go before we have our final eight.
Kairit Leibold
Player
Chips
Progress
Marta Porter
490,000
40,000
Karit Leibold
0
0
Evely Pihela Finally Gets Her Double-Up Posted Saturday 2nd December, 2023 at 19:06(UTC+0) by Lina Olofsson
During the last break, Evely Pihela came over to the bloggers HQ (well it's just me here reporting but anyway) saying "Please, please just give me some hands and a double up, please". I wished her luck as she returned to her seat and a few hands into the level she looked down on Ace-King on the big blind after Marianna Bastamow Sinkko raised under the gun.
Evely pushed her stack over the line and got called by Ace-Queen. "Please, please no queen," Evely prayed to the dealer, and after the river came she performed a little celebration dance as she avoided any of her opponent's outs and got that well-needed double up.
Player
Chips
Progress
Evely Pihela
125,000
61,000
Marianna Bastamow-Sinkko
110,000
60,000
Marta Porter has 450,000 Reasons to Smile Posted Saturday 2nd December, 2023 at 18:51(UTC+0) by Lina Olofsson
We are so, so close to the final table now in the Main Event you can almost feel the excitement in the air here in the grand ballroom at Hilton Park and Olympic Casino.
As the players had another break we took all of their chip counts and there's a new queen on top. The always smiling and laughing Marta Porter has 450,000 reasons to have a big smile on her face now.
Marta Porter
Player
Chips
Progress
Marta Porter
450,000
320,000
Indre Martoviciute
361,000
109,000
Justina Andriukeviciute
268,000
111,000
Hanna Heinlo
266,000
164,900
Marianna Bastamow-Sinkko
170,000
13,000
Giedre Valgemae
135,000
49,500
Catlin Muur
133,000
53,000
Michelle Bricknell
74,000
80,500
Evely Pihela
64,000
101,000
Karit Leibold
60,000
9,000
Bonus on the Bubble Posted Saturday 2nd December, 2023 at 18:14(UTC+0) by Lina Olofsson
We are down to the last ten players in the Main Event here in Queens of Tallinn and only two more to go before we reach the money. But the player who gets herself eliminated on the final table bubble won't bust empty-handed. The Irish Open was so thrilled about something like this being created that they brought their ambassadors Karen Muir and Jennifer Steele who will give a ticket to the Irish Open in March 2024 for our ninth-place finisher.
Karen Muir
Jennifer Steele
It's Railing Men - Hallelujah! Posted Saturday 2nd December, 2023 at 17:55(UTC+0) by Lina Olofsson
"It's so hard just standing here on the rail, I get so nervous," one man said as he was railing his wife in the tournament earlier and we've had quite a few men here during these days on the rail watching their girlfriends or wives compete in this historical poker festival.
But don't be too sorry all of you men here in Tallinn because later tonight we have a tournament where everyone can join with a buy-in of €60. This Ladies and Gentlemen's tournament starts in an hour local time (9 pm) up here in the grand ballroom and of course, the blog will have a sneak peek of it even if we focus mainly on the Main Event right now as they are down to the very last 11 players in the field and closing in on the final table bubble.
Igor Pihela Jr railing his wife Evely Pihela who's still in the Main Event
A few others who seemed to have fun the other night were these two gentlemen:
Lithuanian Indre Martoviciute leads with 14 players left Posted Saturday 2nd December, 2023 at 17:42(UTC+0) by Lina Olofsson
Players just returned from their break and while they took a well-deserved legstretcher we counted some chips the queen on the fort at this time is Indre Martoviciute from Lithuania who was also the only player above 200,000 in chips.
The average stack is exactly 150,000.
Indre Martoviciute
Player
Chips
Progress
Indre Martoviciute
252,000
151,200
Catlin Muur
186,000
111,200
Marianna Bastamow-Sinkko
183,000
131,900
Evely Pihela
165,000
127,000
Justina Andriukeviciute
157,000
37,000
Michelle Bricknell
154,500
70,700
Marta Porter
130,000
71,400
Liisi Voltri
105,000
58,200
Jennifer Steele
86,500
56,500
Giedre Valgemae
85,500
55,000
Hannele Soile Lerviks
60,000
30,400
Karit Leibold
51,000
10,000
Yulia Taran
32,000
5,500
Last two tables Posted Saturday 2nd December, 2023 at 16:54(UTC+0) by Lina Olofsson
And just like that we are down the the final two tables in the Main Event and just had another re-draw. Only eight more players until we reach our final table in this historical tournament where the winner will walk away with €6,167 in prize money and the beautiful Queens of Tallinn 2023 golden necklace.
Minna Peltonen never played poker before, now plays the Main Event Posted Saturday 2nd December, 2023 at 16:02(UTC+0) by Lina Olofsson
Finnish Minna Peltonen and her friends created a network called Sisters and together they travel all around doing different things. Yesterday they were invited by the organization to have a little poker school here in the tournament room. Tournament Director Teresa Nousiainen sat down with them and taught them how to play this amazing game for half an hour. After learning the basics all 27 of them jumped into the freeroll satellite to the Main Event here last night and Minna was one of the three lucky who took a seat in the tournament and started here on day two.
Minna Peltonen
Down to Three Tables Posted Saturday 2nd December, 2023 at 15:53(UTC+0) by Lina Olofsson
As we just lost Miss Finland Sara Chafak from the tournament we are down to the last 24 players and just made a re-draw for the last three tables. As earlier mentioned we are playing down to the final eight players and if you go over to the payouts page you will find all the prizes in the Main Event here in Tallinn.
In the Gallery you'll find all the pictures from today but here's some of the queens who played here on day two.
Kairit Leibold
Teele Viira
Viita Veidemane
Yulia Andriukeviciute
Anna-Mari Hursti
Evely Pihela matched her outfit with the branding in the tournament area today
Anne Bezdek
Emmi Juutilainen
Helena Karutoom
Piret Uibu
€6,167 to the Main Event Winner Posted Saturday 2nd December, 2023 at 15:43(UTC+0) by Lina Olofsson
As the Main Event now officially closed the registration the final number of entrants was 65 players creating a prize pool of €19,247. The final eight players will take a piece each of this cake and the eventual winner won't only get the beautiful gold Queens of Tallinn 2023 Necklace but also €6,167 in first prize.
As they just started on the 12th level of the tournament 25 players remain and the plan for today is to play down to the final table which will be live-streamed tomorrow with a 30-minute delay.
Miss Finland Sara Chafak is still in the tournament but needs a double-up to stay alive.
Last Chance to Join the Action Posted Saturday 2nd December, 2023 at 14:35(UTC+0) by Lina Olofsson
The tournament clock just stopped here on day two and all the tables will play the last three hands before they go on a 20-minute break when they come back the registration closes and we will have the final numbers in the Main Event.
We started the day with 59 players and so far another six has entered or made an re-entry.
Maydia Rantala Got The Last Free Ticket Posted Saturday 2nd December, 2023 at 14:17(UTC+0) by Lina Olofsson
Due to the fact there weren't enough players to even start the scheduled day 1C the organization decided to instead set up a freeroll for the five players who were here and Finn Maydia Rantala was the very last who won her seat into the €350 Queens of Tallinn Main Event and didn't pay a single dime for it.
She now sitting over at table six alongside Catlin Muur, and Gerli Ruuberg amongst others.
The Queens Are Back for Day Two Posted Saturday 2nd December, 2023 at 13:39(UTC+0) by Lina Olofsson
59 players made it into day two here in Queens of Tallinn but whoever still wants to join the action will have until the first break of the day to do so. And if you are unlucky enough to bust out this is also a tournament where you can re-enter if you'd like to.
That's exactly what our amazing Anne Bezdek did after losing with kings to Justina Andriukeviciute with Ace-Jack when all of Anne's chips went into the middle but her opponent didn't only hit one, but two aces on the board sending Anne to the rail. Or maybe I should say the cashier desk as she took up another €350 to fire another bullet in this amazing tournament.
"Black is my happy color," Anne said right before the hand when she was eliminated sitting next to Evely Pihela all dressed in a stylish purple jacket and pink top which matched the whole interior design here in the grand ballroom.
Player
Chips
Progress
Justina Andriukeviciute
120,000
30,100
Anne Bezdek
0
0
13:29 (UTC+0)
Day 3 of Queens of Tallinn Started Level:Blinds: 0/0 Ante: 0
Your search results are valid for .
Go to checkoutMore 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.
both players checks. Turn is the 
and Marta bets 30,000 and Marianna pushes all-in for almost 200,000 and gets a call.
didn't change anything and the kings held up for Marta who's now increased her lead until tomorrow's final even further and almost has a million in chips. 
