0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0060 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/55/156/updates'
ORDER BY `views` DESC

0.0773 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/55/156/updates', 1, '2024-07-27')

0.0048 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.0030 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '55'

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

0.0800 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0085 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '159'
AND `published` = 1

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

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

0.0580 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '156'
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` = '156'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

0.0057 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` = '6831'
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` = '6808'
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` = '6807'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0059 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.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2250
Translate
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
Day 1 Day 2 Day 3 Day 4
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Live Updates - Day 1
Riitta Sahala won Event #1 and €1,434 Posted Friday 1st December, 2023 at 14:32(UTC+0) by Lina Olofsson

Yesterday we wrote history here in Tallinn as the first ever women's only poker festival kicked off at Hilton Park and Olympic Casino. No one has ever tried this before, but the long-experienced tournament guru and Swedish Poker Hall of Famer Christer Larsson said after this was announced during WSOP in September that it was time for something like this to give back to all the amazing women out there and create something extraordinary just for them. And he surely succeeded together with his weapon bearer Teresa Nousiainen and her world-class staff.  

Christer Larsson

Teresa and poker professional Davia Byrne

The evening started with a meet and greet for the ladies, or should I say queens, with some champagne and mingling down at the casino before the opening tournament started at 7 pm. That was a €100 No Limit Hold’em Deep Stack.  

We didn’t really know what to expect but I don’t think anyone would have thought the turnout of this event would land on an astonishing 61 entries in total. After the first break, Christer and Teresa gave them all a warm welcome and also showed the fabulous necklaces every winner of each event would receive. It was then followed by a big round of applause by the players.  

Amanda Harkim and her friends is here to compete in Queens of Tallinn

I didn’t really know what I expected the tournament to be, but I must say that this is the friendliest and funniest tournament I ever covered in my entire career, and I've been doing this for almost 20 years now. I’ve never seen so many laughs and smiling faces in a tournament ever before so my expectations for the rest of this festival are huge.  

The 61 entries created a prize pool of €4,874 to play for with the top seven getting paid. The field surely was dominated by Finns and home soil players here from Estonia and so they were when it was time for the final table.  

Around three in the morning, the final nine players gathered to play for the big bucks and obviously, the wonderful silver necklace specially made for the winners here.  

Going into the final table Finland's Katrin Rajasalu had the largest stack but with this being a deep stack tournament there was still anyone's game. Even for Leone Kala who started the final table with one big blind. And she managed to double up a couple of times but eventually bubbled in eighth place leaving the remaining seven in the money.  

As soon as the bubble burst our favorite entertainer in the tournament Anne Bezdek asked if they shouldn’t just split the prize money, but the others didn’t seem to be up for it and the play resumed for another two hours before it was all over. With three players left, all from Finland, Anne, Riitta Sahala, and Katrin Rajasalu agreed to make a deal giving each player €1,000 and €434 to play for. And then it went pretty quickly until Riitta Sahala took down the tournament after beating Katrin Rajasalu heads-up.  

A huge congratulations to Riita for the victory and all seven players who made the money in this first event.  

Queens of Tallinn Event #1 - €100 NLHE Deepstack results: 

Place Name Country Prize
1 Riita Sahala Finland €1,434
2 Katrin Rajasalu Finland €1,000
3 Anne Bezdek Finland €1,000
4 Kristi Kirs Estonia €500
5 Emmi Juutilainen Finland €380
6 Hannele Lerviks Soile Finland €310
7 Vita Veidemane Latvia €250

Final Table in the €100 Opening Event Posted Friday 1st December, 2023 at 01:44(UTC+0) by Lina Olofsson

The opening event of the historical festival for women only here in Queens of Tallinn had an astonishing 61 entries in total creating a prize pool of €4,874 in total. They just reached the final table in the tournament as the clock passed three in the morning. A total of seven players get paid. 

Among the players who entered the field we had notable names such as Lithuanian poker professional Daiva Byrne and the always very sweet and funny former miss Finland Sara Chafak.

The final table seat draw: 

Seat Name Chips Country
1 Anne Bezdek 120,000 Finland
2 Emmi Juutilainen 225,000 Finland
3 Leone Kala 100,000 Estonia
4 Kristi Kirs  10,000 Estonia
5 Ekaterina Kovaleva 160,000 Estonia
6 Hannele Lerviks Soile 215,000 Finland
7 Katrin Rajasalu 410,000 Finland
8 Liisa Sahala 240,000 Finland
9 Vita Veidemane 302,000 Latvia

Event #1 NLH Deep Stack Opening Event - Prize pool: 

Place Name Country Prize
1 €1,664
2 €1,060
3 €710
4 €500
5 €380
6 €310
7 €250
The Queens are coming to Tallinn! Posted Thursday 30th November, 2023 at 12:53(UTC+0) by Lina Olofsson

I've been in this industry for 20 years and have been waiting for something like this and I can tell by the hype this poker festival has created I’m certainly not the only one either.

Today a new era of poker is written into the history books as Queens of Tallinn is about to start. A festival dedicated to women in poker and you will be able to read all about it here in the blog from start to finish. We will give you chip counts, results, pictures, and some great stories from this fabulous festival that will take place at the Olympic Casino and Hilton Park with the game starting on December 1st but first everyone is invited to a meet and greet with the organization behind this fantastic festival. 

One of the queens coming to Tallinn and playing in this festival is Sara Chafak who made herself a big name on the European Poker Tour and Shark Cage where she pulled off one of the best bluffs in poker history and gave us a show. We know Sara and she will most likely give us that over this weekend too as the fantastic ambassador she is for the game of poker. another highly notable name is Lithuanian player Daiva Byrne who has been crushing the game for years and has an astonishing $228,651 in tournament winnings. 
12:46 (UTC+0)
Day 1 of Queens of Tallinn Started
Level:      Blinds: 0/0     Ante: 0
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.