0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0106 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/28/106/chips'
ORDER BY `views` DESC

0.1939 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/28/106/chips', 1, '2024-07-27')

0.0007 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` = '28'

0.0008 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '28'

0.2102 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0284 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '97'
AND `published` = 1

0.1770 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0042 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '106'
AND `published` = 1

0.1731 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0211 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '111'
AND `published` = 1

0.1069 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0140 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '112'
AND `published` = 1

0.2939 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.2911 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '113'
AND `published` = 1

0.4053 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0649 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '115'
AND `published` = 1

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

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

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

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

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

0.0556 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
Translate
WSOPC Tallinn Event #1: €555 No-Limit Hold'em Live Reporting - Day 3
WSOPC Tallinn - Live Reporting Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)
Current Level 30 Current Day 3
Blinds 75,000/150,000 Ante 150,000
Entries 382 Remaining 1
Prize Pool (EUR) €183,360 First Prize (EUR) €34,435
Day 1A Day 1B Day 1C Day 1D Day 2 Day 3
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Chip Counts - Day 1B
Place Player Chips Progress
1 Max Avela 184,000 154,000
2 Martin Lategui 133,500 103,500
3 Eriks Krumins 125,000 95,000
4 Georgios Skarparis 107,000 77,000
5 Aleksandr Gamonovits 105,000 75,000
6 Rasmus Lundstroem 93,000 63,000
7 Lukasz Fraczek 79,000 49,000
8 Robert Relander 71,000 41,000
9 Arthur Boatman 63,000 33,000
10 Martti Keel 62,000 32,000
11 Atte Franssila 55,500 25,500
12 Tonis Viik 50,500 20,500
13 Glen Gaines 49,500 19,500
14 Torbjorn Larsen 49,500 19,500
15 Roope Tarmi 45,000 15,000
16 Andres Leppik 42,000 12,000
17 Nikolay Ponomarev 35,500 5,500
18 Azamat Dyussembekov 30,500 500
19 Tapio Aaltonen 28,500 1,500
20 Julius Tiihonen 17,000 13,000
21 Mark Metsla 15,000 15,000
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.