0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0077 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-18'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event1/1C/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 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.0004 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.0035 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.0005 SECONDS: SELECT tour_stop_blogs.*, 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.logo as tour_stop_logo, 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 `friendly_url` = '2024_wsop_tallinn_event1'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '135'
0.0885 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0156 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '320'
AND `published` = 1
0.0653 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` = '321'
AND `published` = 1
0.0826 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0145 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '323'
AND `published` = 1
0.0304 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.0492 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0070 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '326'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '135'
AND `name` = '1C'
0.0064 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.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` = '323'
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` = '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.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` = '14158'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 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.0061 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.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.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_id` = '323'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0275 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.0065 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.0062 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.0063 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.0064 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.0078 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
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.
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
Your search results are valid for .
Go to checkoutMore 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.
£ GBP
$ USD
€ EUR
