0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0072 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event6/1E/chips'
ORDER BY `views` DESC

0.0044 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event6/1E/chips', 1, '2024-09-01')

0.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0001 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.0001 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'

0.0001 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'

0.0001 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.0005 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.0065 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_event6'

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

0.0267 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '345'
AND `published` = 1

0.0673 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '353'
AND `published` = 1

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

0.0700 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` = '355'
AND `published` = 1

0.0758 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` = '356'
AND `published` = 1

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

0.0697 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '358'
AND `published` = 1

0.0288 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` = '364'
AND `published` = 1

0.0680 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` = '372'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '142'
AND `name` = '1E'

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '356'
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` = '345'
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` = '353'
ORDER BY `busted` ASC, `current_chips` DESC

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

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

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

0.0058 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` = '15192'
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` = '357'
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` = '358'
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` = '364'
ORDER BY `busted` ASC, `current_chips` DESC

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
English
Olympic Park Casino Event #6: €1M GTD €1,500 NLH Main Event Live Reporting - Day 4
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 38 Current Day 4
Blinds 300,000/600,000 Ante 600000
Entries 812 Remaining 1
Prize Pool (EUR) €1,052,352 First Prize (EUR) €167,900
Day 1A Day 1B Day 1C Day 1D Day 1E Day 1F Day 2 Day 3 Day 4
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Chip Counts - Day 1E
Place Player Chips Progress
1 Aleksei Vandyshev 430,500 380,500
2 Martin Piik 316,500 266,500
3 Vitalii Zimkovskyi 314,000 264,000
4 Robert Rudolf Rohr 253,000 203,000
5 Ricardas Lukauskas 251,500 201,500
6 Klaudijus Garjonis 231,000 181,000
7 Liutauras Armanavicius 200,500 150,500
8 Jani Tuovinen 199,000 149,000
9 Aurimas Stanevicius 189,500 139,500
10 Igor Pihela Sr 187,500 137,500
11 Marita MŠgi 183,500 133,500
12 Juuso Koskela 183,000 133,000
13 Tapio Aaltonen 176,500 126,500
14 Ermo Kosk 176,500 126,500
15 Mateusz Sikora 175,500 125,500
16 Nils Veipans 174,000 124,000
17 Henri Tanskanen 172,000 122,000
18 Juuso Oksanen 170,000 120,000
19 Baard Dahl 168,000 118,000
20 Vasyl Tkachenko 168,000 118,000
21 Antti Perttula 166,500 116,500
22 Julia Kuusijarvi 166,000 116,000
23 Tim Vanari 166,000 116,000
24 Priamo Carta 164,000 114,000
25 Kasparas Klezys 162,500 112,500
26 Jon Kyte 160,500 110,500
27 Romans Moskalovs 160,000 110,000
28 Mihails Nikitins 158,000 108,000
29 Andrei Mjagkov 151,000 101,000
30 Matte Karjalainen 149,500 99,500
31 Audrius Laimelis 149,000 99,000
32 Aleksandr Geller 147,000 97,000
33 Samuli Hietala 143,500 93,500
34 Jarkko Strom 143,000 93,000
35 Ranel Kasi 139,000 89,000
36 Frederico Alves Dos Santos 135,000 85,000
37 Janis Leja 133,000 83,000
38 Mihn Thang Ngo 130,000 80,000
39 Sergei Kuznetsov 126,500 76,500
40 Enea Subashi 126,500 76,500
41 Jarkko Suokas 126,000 76,000
42 Jari Pekka Hurri 122,000 72,000
43 Boris Smolianskii 121,500 71,500
44 Eero Rantala 120,500 70,500
45 Per Engstrom 120,000 70,000
46 Raphael Godard 117,000 67,000
47 Artur Kulanurk 117,000 67,000
48 Jussi Mattila 114,000 64,000
49 Max Lampenius 111,000 61,000
50 Matias Arosuo 105,500 55,500
51 Vidar Assersen 104,500 54,500
52 Hannu Ollila 102,000 52,000
53 Timmo Kaha 99,500 49,500
54 Morten Sikveland 98,000 48,000
55 Arduini Lorenzo 97,000 47,000
56 Mikko Ylamaki 97,000 47,000
57 Tauno Pajula 96,500 46,500
58 Yanis Mehdi Sahli 95,500 45,500
59 Roope Tarmi 95,500 45,500
60 Sondre Lunde 95,000 45,000
61 Joona-Markus Linna 95,000 45,000
62 Pekka Ikonen 95,000 45,000
63 Anne Koskinen 91,500 41,500
64 Krisjanis Stankevics 90,500 40,500
65 Jukka Moisio 89,000 39,000
66 Jari-Pekka Juhola 86,000 36,000
67 Indre Martoviciute 86,000 36,000
68 Tarjei Forus 84,500 34,500
69 Alf Onnestam 82,500 32,500
70 Quang Thanh Doan 81,500 31,500
71 Santtu Leinonen 81,500 31,500
72 Karl Persson 79,500 29,500
73 Sandis Blums 77,500 27,500
74 Mika Marttila 77,500 27,500
75 Martin Keskkula 76,500 26,500
76 Ben Slack 76,000 26,000
77 Joshua Stewart 75,000 25,000
78 Romans Krasins 74,500 24,500
79 Marius Hakonsen 74,000 24,000
80 Joel Salmirinne 74,000 24,000
81 Akseli Paalanen 73,000 23,000
82 Kristiana Stauere 73,000 23,000
83 Luigi Tasca 71,500 21,500
84 Mindaugas Kriauciunas 71,000 21,000
85 Johan Creutz 69,000 19,000
86 Hanna Heinlo 68,000 18,000
87 Kasper Mellanen 67,500 17,500
88 Roberts Rumba 67,000 17,000
89 Tanel Merida 66,000 16,000
90 Antti Ahlsten 65,500 15,500
91 Johan Alen 64,500 14,500
92 Henri Wagner 64,500 14,500
93 Aurimas Buivydas 64,000 14,000
94 Sebastian Sorensson 63,500 13,500
95 John Trast 63,000 13,000
96 Andrejs Volkovs 62,500 12,500
97 Maksym Klopotok 59,500 9,500
98 Ilvars Gudrimovics 57,500 7,500
99 Ari Soini 56,500 6,500
100 Pavel Solodovnikov 56,500 6,500
101 Henri Katila 51,000 1,000
102 Jorn Hval 51,000 1,000
103 Jianing Zhang 50,500 500
104 Daiva Byrne 49,500 500
105 Harijs Erglis 49,500 500
106 Kaspars Butans 48,500 1,500
107 Tanel Evert 48,500 1,500
108 Seppo Parkkinen 48,000 2,000
109 Erno Suominen 47,000 3,000
110 Tero Laurila 46,400 3,600
111 Konstantin Farber 46,000 4,000
112 Sergei Krementsukov 44,000 6,000
113 Vytenis Salickas 44,000 6,000
114 Ingus Arajs 43,500 6,500
115 Oleksii Natoptanyi 43,000 7,000
116 Josep Pastor De Ramon 43,000 7,000
117 Christian Steinbo 42,500 7,500
118 Magnus Pukk 42,500 7,500
119 Daniel Clifford 41,500 8,500
120 Gilles Lamy 39,500 10,500
121 Ville-Tappio Mesiranta 38,500 11,500
122 Thomas Nass 38,500 11,500
123 Peter Kvisthammar 36,000 14,000
124 Steven Seller 33,500 16,500
125 Rasmus Sepping 33,500 16,500
126 Rolands Norietis 31,500 18,500
127 Enrique Martinez 31,500 18,500
128 Trond Aanestad 31,500 18,500
129 Kaspars Mamons 28,500 21,500
130 Meelis Ahman 26,000 24,000
131 Gintas Dirse 25,500 24,500
132 Hanno Kerem 24,500 25,500
133 Kaido Mikk 22,000 28,000
134 Janne Tiitto 15,000 35,000

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.