0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0078 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-18'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/218/459/structure'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/218/459/structure', 1, '2024-11-18')

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` = '218'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '218'

0.0280 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0058 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '459'
AND `published` = 1

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

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

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

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

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2596
Translate
Kings of Tallinn Autumn Edition 2024 Event #52: €3,000 NLH (Finnish) Live Reporting - Day 2
Kings of Tallinn Autumn Edition 2024 - Live Reporting Event #20 €555 NLH Kings of Tallinn Championship Event #27 €5,000 NLH Progressive Bounty Event #31: Kings of Tallinn €1,100 Main Event Event #52: €3,000 NLH Event #20 €555 NLH Kings of Tallinn Championship (Finnish) Event #31: Kings of Tallinn €1,100 Main Event (Finnish) Event #52: €3,000 NLH (Finnish)
Current Level 24 Current Day 2
Blinds 25,000/50,000 Ante 50,000
Entries 53 Remaining 4
Prize Pool (EUR) €140,980 First Prize (EUR) €47,930
Day 1 Day 2
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Tournament Structure
# Small Blind Big Blind Ante Duration (M)
1 100 300 300 30
2 200 400 400 30
3 200 500 500 30
4 300 600 600 30
5 400 800 800 30
6 500 1,000 1,000 30
7 600 1,200 1,200 30
8 1,000 1,500 1,500 30
9 1,000 2,000 2,000 30
10 1,000 2,000 2,000 30
11 1,000 2,500 2,500 30
12 1,500 3,000 3,000 30
13 2,000 4,000 4,000 30
14 2,000 5,000 5,000 30
15 3,000 6,000 6,000 30
16 4,000 8,000 8,000 30
17 5,000 10,000 10,000 30
18 6,000 12,000 12,000 30
19 10,000 15,000 15,000 30
20 10,000 20,000 20,000 30
21 10,000 25,000 25,000 30
22 15,000 30,000 30,000 30
23 20,000 40,000 40,000 30
24 25,000 50,000 50,000 30
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.