0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0081 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/135/320/updates'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/135/320/updates', 1, '2024-11-23')

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

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

0.0282 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0065 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '320'
AND `published` = 1

0.0278 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0062 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '321'
AND `published` = 1

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

0.0279 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` = '324'
AND `published` = 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

Translate

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Eesti
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Nederlands
• Ελληνικά
• Русский

Olympic Park Casino Event #1: €250 No-Limit Hold'em Live Reporting - Day 2

Olympic Park Casino - Live Reporting

Event #1: €250 No-Limit Hold'em See other events

Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)

Olympic Park Casino - Live Reporting Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)

---

Current Level 34 Current Day 2

---

Blinds 100,000/200,000 Ante 200,000

Entries 788 Remaining 1

---

Prize Pool (EUR) €166,426 First Prize (EUR) €31,620

Chip Leaders Day 2

1

Eriks Krumins

15,760,000

Day 1A Day 1B Day 1C Day 1D Day 2

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Live Updates - Day 1A

16:15 (UTC+1)

Day 1A of Olympic Park Casino Ended
Level: 10     Blinds: 500/1,000     Ante: 1,000

Final Day 1a Chip Counts Posted Saturday 20th July, 2024 at 16:01(UTC+1) by Jason Glatzer

Day 1a kicked off the 2024 World Series of Poker Circuit Tallinn with a bang, with 174 entries getting into the mix during the first of four opening flights in the two-day Event #1: €250 No-Limit Hold'em.

France's Anthony Lesoismier-Geniaux led the 74 survivors after 10 blind levels of 30 minutes each. Check out the chip counts of all 74 entries that advanced from Day 1a into Sunday's Day 2 field.

Place	Name	Country	Chips	Big Blinds
1	Anthony Lesoismier-Geniaux	France	169,900	170
2	Josep Pastor De Ramon	Spain	157,600	158
3	Janek Hin	Estonia	104,500	105
4	Antonio Iborra	Spain	100,800	101
5	Tero Kilkanen	Finland	99,000	99
6	Magnus Pukk	Estonia	90,200	90
7	Mikko Kujansuu	Finland	88,300	88
8	Mark Metsla	Estonia	87,300	87
9	Liutauras Armanavicius	Lithuania	87,200	87
10	Taago Tamm	Estonia	86,000	86
11	Andrei Mjagkov	Estonia	78,700	79
12	Lauri Laast	Estonia	74,800	75
13	Martins Latiks	Latvia	73,400	73
14	Abel Marquez	Spain	71,900	72
15	Gumersindo Cabanillas	Spain	68,900	69
16	Artur Maeots	Estonia	66,700	67
17	Jerry Vuorimaki	Finland	63,900	64
18	Robert Kaggerud	Norway	63,000	63
19	Joonas Kulli	Estonia	61,500	62
20	Bahtijar Kulijev	Estonia	61,000	61
21	Mikko Pusa	Finland	59,600	60
22	Peteris Balodis	Latvia	59,000	59
23	Siim Suviste	Estonia	58,800	59
24	Konsta Puustinen	Finland	57,700	58
25	Jukka Papinkivi	Finland	57,400	57
26	Kaspar Laursoo	Estonia	56,300	56
27	Vasyl Tkachenko	Ukraine	56,100	56
28	Karl-Henri Lauri	Estonia	54,500	55
29	Leevi Laiho	Finland	54,100	54
30	Markus Huiskonen	Finland	50,300	50
31	Lars  Bentsen	Denmark	49,200	49
32	Eero Puustinen	Finland	48,600	49
33	Tom Teslon	Estonia	47,700	48
34	Albert Ostrovskij	Lithuania	47,300	47
35	Teeranan Chuennirun	Finland	45,900	46
36	Robin Pushparatnam	Switzerland	45,500	46
37	Tanel Evert	Estonia	44,900	45
38	Richard Randolph Jr	United States	42,600	43
39	Hendrik Uibo	Estonia	41,100	41
40	Marc Bayarri	Spain	41,000	41
41	Edvinas Tarasevicius	Lithuania	40,600	41
42	Roman Jezov	Estonia	38,000	38
43	Matthew Ledger	United Kingdom	37,500	38
44	Sergei Kuznetsov	Estonia	36,000	36
45	Kaidar Viikman	Estonia	36,000	36
46	Jarmo Salonen	Finland	34,900	35
47	Dzianis Dubina	Poland	33,900	34
48	Roman Petelytskyi	Ukraine	32,300	32
49	Maksim Petrov	Estonia	32,000	32
50	Rafael Gancedo	Spain	31,100	31
51	Rolandas Aglinskas	Lithuania	31,000	31
52	Espen Sandvik	Norway	31,000	31
53	Michael Chen	Norway	30,200	30
54	Maksim Paponov	Estonia	29,100	29
55	Enrique Martinez	Spain	26,700	27
56	Jeffrey Cormier	Canada	24,300	24
57	Rustam Havryliuk	Ukraine	23,800	24
58	Jonatan Fors	Finland	23,500	24
59	Miro Tuulijarvi	Finland	23,400	23
60	Vitali Rakov	Estonia	22,000	22
61	Allan Arjut	Estonia	21,300	21
62	Ramon Randma	Estonia	19,100	19
63	Janne Rusanen	Finland	18,600	19
64	Madis Ormisson	Estonia	18,000	18
65	Sondre Stormyr	Norway	17,500	18
66	Luca Sebastiani	Italy	15,400	15
67	Priit Valgma	Estonia	14,600	15
68	Pavel Solodovnikov	Estonia	14,200	14
69	Laurynas Ciuta	Lithuania	14,000	14
70	Damien Petitjean	France	13,700	14
71	Petteri Laiho	Finland	13,200	13
72	Ignotas Tamasauskas	Lithuania	11,500	12
73	Maksim Onutsin	Estonia	9,500	10
74	Enea Subashi	Greece	9,400	9

16:00 (UTC+1)

Day 1A of Olympic Park Casino Started
Level: 10     Blinds: 500/1,000     Ante: 1,000