0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-07-09' AND `url` = 'https://www.maineventtravel.com/tour/queens-of-tallinn' ORDER BY `views` DESC

0.0093 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-07-09' AND `url` = 'https://www.maineventtravel.com/tour/queens-of-tallinn'

0.0004 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0041 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

0.0003 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'queens-of-tallinn'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'queens-of-tallinn'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '173'

0.0012 SECONDS:
SELECT tour_stops.*, 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_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '173' ORDER BY `tour_stops`.`start_date` ASC

0.0102 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC

0.0008 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

Queens of Tallinn


Welcome to the First Ever Ladies Only Poker Festival Premiere in Europe!

Ladies, mark your calendars for 30th of November to 3rd of December because something special is happening at the luxurious Olympic Park Casino and Hilton Hotel. We are hosting a groundbreaking Queens of Tallinn poker festival. The highlight is the €350 Queens of Tallinn Main Event, where a new queen will be crowned.

This four-day event is all about women in poker and offers a range of exciting events and 24-hour cash games. It’s not just about playing cards and stacking chips – it’s a celebration of women in the poker world. Don’t miss out on this opportunity to be part of an unforgettable poker experience!

Welcome to Queens of Tallinn, Estonia!

Upcoming Tour Stops

Thursday 21st - Sunday 24th August, 2025

Queens of Tallinn 2025

Olympic Park Casino, FR. R. KREUTZWALDI 23, TALLINN, 10147, ESTONIA

Europe’s 1st ladies-only poker festival returns

From the 21st to the 24th of August, Hilton Tallinn Park & Olympic Park Casino welcome the Queens of Tallinn festival back to the Estonian capital for its third consecutive year!

This four day celebration of women in poker promises an exciting lineup of 10 tournaments, with buy-ins ranging from Free Entry to €350, along with non-stop 24/7 cash game action. The centrepiece of the festival is the €350 Queens of Tallinn Main Event, where the next poker queen will be crowned. 

    Find Hotels, Flights & More       View Complete Schedule  
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.