0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0010 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/135/323/updates', 1, '2024-12-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.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '135'

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

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

0.0284 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.0291 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` = '324'
AND `published` = 1

0.0301 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` = '326'
AND `published` = 1

0.0060 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.0067 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` = '323'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

0.0071 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` = '14158'
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.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.0059 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.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` = '323'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

0.0059 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.0059 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 1C

23:56 (UTC+1)

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

Day 1c Largest Yet Posted Saturday 20th July, 2024 at 22:51(UTC+1) by Jason Glatzer

Estonia's Igor Aleksandrov bagged the Day 1c chip lead on Sunday afternoon and will advance to Sunday's Day 2 with a healthy stack of 164,700 chips.

The Day 1c field was the largest one thus far in Event #1: €250 No-Limit Hold'em with 185 entries and 71 survivors. Check out the full chip counts below from the third of four opening flights in the opening WSOP Circuit Tallinn ring event.

Place	Player	Country	Chips	Big Blinds
1	Igor Aleksandrov	Estonia	164,700	165
2	Ivar Simmer	Estonia	136,400	136
3	Addy Bassan	United States	117,900	118
4	Kyosti Isberg	Finland	114,500	115
5	Mairo Tori	Estonia	105,200	105
6	Tomi Arponen	Finland	102,700	103
7	Dimitri Domerazki	Germany	97,500	98
8	Erwan Pirotais	France	89,000	89
9	Mikus Marenis	Latvia	87,900	88
10	Xi Tran	Norway	84,900	85
11	Henri Niinimaki	Finland	80,200	80
12	Jani Saranen	Finland	77,800	78
13	Kestutis Jungevicius	Lithuania	67,700	68
14	Dalius Ulevicius	Lithuania	64,800	65
15	Sami Vahakuopus	Finland	63,100	63
16	Tanel Tammela	Estonia	61,300	61
17	Timo Malo	Finland	60,900	61
18	Nidal Dawoud	Denmark	57,500	58
19	Marten Oks	Estonia	55,500	56
20	Janne Kotiranta	Finland	55,300	55
21	Vilde Fagerbakke	Norway	55,200	55
22	Vilius Zabarauskas	Lithuania	54,200	54
23	Victor Garcia	Spain	53,800	54
24	Andre Magi	Estonia	53,800	54
25	Mauri Dorbek	Estonia	53,300	53
26	Urmo Velvelt	Estonia	52,500	53
27	Ian Kalla	Estonia	52,300	52
28	Jussi Mattila	Finland	49,000	49
29	Harri Karenius	Finland	48,500	49
30	Roberts Jukss	Latvia	47,200	47
31	Kim Granneman	Norway	46,700	47
32	Tarmo Tammel	Estonia	46,300	46
33	Niko Kantola	Finland	45,800	46
34	Robert Schmidt	Estonia	45,200	45
35	Markus Papinkivi	Finland	43,500	44
36	Kim-Erik Pihl	Finland	42,900	43
37	Garijs Rozkalns	Latvia	42,900	43
38	Boris Smolianskii	Israel	42,900	43
39	Tony Alava	Finland	42,600	43
40	Mart Rinken	Estonia	42,200	42
41	Glen Kolmer	Estonia	41,900	42
42	Jakub Matusiak	Latvia	41,200	41
43	Sakari Setala	Finland	41,200	41
44	Marius Morel	Estonia	41,100	41
45	Joonas Laamanen	Finland	39,900	40
46	Jari Koistinen	Finland	39,600	40
47	Frederic Konowitz	France	39,200	39
48	Lauri Merikallio	Finland	38,300	38
49	Jussi-Pekka Saarinen	Finland	38,000	38
50	Gatis Grinbergs	Latvia	37,500	38
51	Joshua Stewart	Ireland	34,500	35
52	Kaspars Terauds	Latvia	31,700	32
53	Jon Jurado	Spain	30,500	31
54	Artur Kulanurk	Estonia	29,600	30
55	Aleksandr Gamonovits	Estonia	29,100	29
56	Rain Kandla	Estonia	27,300	27
57	Morten Bremseth	Norway	27,200	27
58	Aleksandar Nanchev	Bulgaria	27,200	27
59	Roope Tarmi	Finland	27,200	27
60	Jan-Mikael Kesanen	Finland	27,000	27
61	Maureen Bloechlinger	Switzerland	26,800	27
62	Ulf Jonsson	Sweden	25,500	26
63	Dmitri Dudakov	Estonia	25,200	25
64	Jussi Knuutila	Finland	24,500	25
65	Mika Lax	Finland	22,200	22
66	Anu Lilja	Finland	22,100	22
67	Miguel Fernandez	Spain	20,000	20
68	Michal Goral	Poland	19,900	20
69	Andrius Mazeika	Lithuania	18,800	19
70	Dan Tolppanen	Finland	17,000	17
71	Atso Lindell	Finland	16,000	16
72	Yurii Zabrodotskyi	Ukraine	15,000	15
73	Radoslaw Hordynski	Poland	13,800	14
74	Niels Pedersen	Denmark	12,000	12
75	Tarmo Anton	Estonia	8,600	9
76	Hok Lai	United Kingdom	4,800	5

22:50 (UTC+1)

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