0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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

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

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

0.0773 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0051 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '161'
AND `published` = 1

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

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

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

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

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

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

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

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

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

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

0.1130 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` = '6917'
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` = '6901'
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` = '6900'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0103 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.0067 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 2
FinEst Queens takes the lead in the Team Challenge Posted Saturday 2nd December, 2023 at 04:52(UTC+0) by Lina Olofsson

As a little bonus here during the Queens of Tallinn the organization also decided to have a team competition where all team has three individual players and collect points in each tournament they play. 

Ten teams are registered for this and so far Team FinEst Queens is in the lead with 10 points in total. Team FinEst Queens are Christel Haller, Catlin Muur and Anne Bezdek is not only an amazing team on the paper but also the ones in the lead. Lucky Ladies are the ones right behind with their eight points. That team includes the Opening Event winners Riitta Sahala, Anette Jaaskelainen, and Helena Reintila. 

Catlin Muur

These two teams have a strong lead toward the rest of the field for sure but there is still several more tournaments to collect points in so its surely ain't over until the queen has taken the crown and sat down on the spectacular throne that's one thing we know for sure. 

Here's the standing before the Main Event day 2 is about to begin and the rest of the tournaments to roll out: 

Team Player Player Player Points
FinEst Queens Christel Haller Catlin Muur Anne Bezdek 10
Lucky Ladies Riita Sahala AnettebJaaskelainen Helena Reinla 8
Chip Chicks Helena Karutoom Kristi Lipp Annika Anni 3
FLIP Daiva Byrne Marta Porter Michelle Bricknell 3
Guns 'n Poses Giedre Valgemae Karit Leibold Teele Viira 3
Volmas Leek Kelly Limonova Monika Leek Kristiina Sultangarejev-Tuder 3
Drama Queens Anna-Mari Hursti Johanna Puuska Melissa Rantala 2
Misukat Marianne Romppanen Maria Haapasalmi Johanna Jenkonen 2
Queens of Balder Elin Holm Jasmine Zhan Lina Olosson 2
YODA Karen Muir Jennifer Steele XX 2
Chipcount after day 1B Posted Saturday 2nd December, 2023 at 00:44(UTC+0) by Lina Olofsson

The second flight here at Hilton Park today in the Queens of Tallinn had 31 entries and after their eight levels, 19 players remain Indre Martoviciute was the queen who walked away with the most chips bagging 100,800. This puts her second in chips after the first two flights but we'll see what happens after tomorrow's turbo flight if anyone can catch up with her and our overall chip leader from day 1A Hanna Heinlo with 101,100. 

Annemar Neiland

Below you find all the chips from the players who made it to day two in this flight: 

Place Name Country Chips
1 Indre Martoviciute Lithuania 100,800
2 Hannele Soile Lerviks Finland 90,400
3 Justina Andriukeviciute Lithuania 89,900
4 Michelle Bricknell UK 83,800
5 Vita Veidemane Latvia 79,200
6 Karit Leibold Estonia 61,000
7 Marta Porter Lithuania 58,600
8 Helena Karutoom Estonia 48,000
9 Marjatta Virpi Ojanen Finland 40,400
10 Annemar Neiland Estonia 40,300
11 Evely Pihela Estonia 38,000
12 Katrin Rajasalu Estonia 30,800
13 Natalia Manuyko Estonia 30,700
14 Gerli Ruuberg Estonia 29,400
15 Heini Puuska Finland 28,800
16 Anne Bezdek Finland 25,800
17 Maria Niina Lampimaki Finland 23,300
18 Sara Chafak Finland 23,300
19 Johanna Katri Jehkonen Finland 14,500

Former Miss Finland Sara Chafak is another player who made it through day 2 and Evely Pihela got an interview with her earlier. 
Chipcount after day 1A Posted Saturday 2nd December, 2023 at 00:33(UTC+0) by Lina Olofsson

After the eight levels of the first starting flight of Main Event, day 1A Hanna Heinlo from Estonia is the queen who holds the fort with just over 100,000 in chips. 

Of the 21 players who entered this flight 11 survived and will continue onto day two tomorrow at 3 pm together with day 1B and tomorrow morning's day 1C turbo flight. 

Below you find the chip count after day 1A: 

Place Name Country Chips
1 Hanna Heinlo Estonia 101,100
2 Catlin Muur Estonia 74,800
3 Annika Haaviste Estonia 73,000
4 Anna-Mari Hursti Finland 65,000
5 Riitta Sahala Finland 56,300
6 Annette Jaaskelainen Finland 52,300
7 Marianna Bastamow-Sinkko Estonia 51,100
8 Liisi Voltri Estonia 46,800
9 Piret Uibu Estonia 41,500
10 Yulia Taran Ukraine 37,500
11 Giedre Valgemae Lithuania 30,500

Pictures from Day 1B Posted Friday 1st December, 2023 at 18:02(UTC+0) by Lina Olofsson

Day 1A which started at lunch is now over and ended with 13 players of the 21 entries made into that flight. Day 1B is already beyond that with only two levels played and is now up to 31 entries so far. 

Here are some pictures from day 1B.  

Helena Karutoom

Ellionoora Brotkin

Daiva Byrne

Christel Haller

Famous Finnish DJ Amanda Harkimo

Justina Andriukeviciute

Annemar Neiland

Natalia Manuyko

Finnish influencer Niina-Maria Lavonen

You will find even more pictures of all of our queens in the gallery so please check it out. 
Time for Day 1B Posted Friday 1st December, 2023 at 16:21(UTC+0) by Lina Olofsson

As I earlier mentioned we have two flights out of the three starting days here in the Queens of Tallinn Main Event and the second flight, day 1B, just started a few minutes ago. 

Day 1A only had 21 entries of which 13 remain. But this flight is predicted to be way bigger and we've already spotted a few notable names in the field as Sara Chafak, Anne Bezdek, Daiva Byrne, and Michelle Bricknell. 

I'm going to grab my camera and see if I can get some shots of them. Stay tuned. Until then make sure to check out Olybet.tv for results, lists of players entered into each field, and of course a ton of pictures of the queens here.
Welcome to Queens of Tallinn Main Event! Posted Friday 1st December, 2023 at 15:40(UTC+0) by Lina Olofsson

Today the Main Event kicks off with three starting days. The first one starts at noon, the second flight is later tonight and the third and last flight takes off in the morning and will be played as a turbo. 

Check out the gallery to see some pictures from yesterday and today's field!

So far we have 21 entries in today's field but we expect tonight's field to be way beyond that. 

Christel Haller
15:38 (UTC+0)
Day 2 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.