0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/1A/chips'
ORDER BY `views` DESC

0.0097 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/1A/chips', 1, '2024-11-25')

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.0002 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.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.0034 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` = 'summer_showdown_main_2023'

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'

0.0277 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` = '75'
AND `published` = 1

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

0.0285 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` = '85'
AND `published` = 1

0.0380 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` = '86'
AND `published` = 1

0.0278 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` = '90'
AND `published` = 1

0.0531 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0088 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '92'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
AND `name` = '1A'

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

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

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

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

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

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

0.0007 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
English
Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €1,100 Main Event Live Reporting - Day 4
Kings of Tallinn Summer Showdown 2023 - Live Reporting 2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event
Current Level 33 Current Day 4
Blinds 100,000/200,000 Ante 200000
Entries 564 Remaining 1
Prize Pool (EUR) €530,160 First Prize (EUR) €108,260
Day 1A Day 1B Day 1C Day 2 Day 3 Day 4
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Chip Counts - Day 1A
Place Player Chips Progress
1 Feras Abid 221,000 191,000
2 Jargo Alavali 213,000 183,000
3 Tapio Aaltonen 212,600 182,600
4 Karolis Kutkauskas 191,100 161,100
5 Magnus Pukk 171,400 141,400
6 Sebastian Van Wonterghem 168,800 138,800
7 Juan Carlos Vecino Duenas 163,800 133,800
8 Anna-Mari Hursti 151,700 121,700
9 Nils Linden 134,900 104,900
10 Tomi Tapani Arponen 117,100 87,100
11 Jan-Mikael Kesanen 106,700 76,700
12 Mark Metsla 105,500 75,500
13 Ermo Kosk 105,200 75,200
14 Henri Schalin 103,600 73,600
15 Adria Comas I Roura 103,300 73,300
16 Kai Lehto 101,300 71,300
17 Ivar RŸhka 94,800 64,800
18 Henri Wagner 93,500 63,500
19 Georgi Abuladze 92,700 62,700
20 Tero Laurila 91,500 61,500
21 Maksim Rusinov 90,100 60,100
22 Jani Tuovinen 87,500 57,500
23 Jari Mahonen 84,000 54,000
24 Enea Subashi 82,400 52,400
25 Igor Pihela 79,200 49,200
26 Henning Gunnar AndreÊ 79,000 49,000
27 Claudio Cecchi 76,300 46,300
28 Stephane Cordeille 75,600 45,600
29 Urmo Velvelt 75,300 45,300
30 Siim Suviste 74,000 44,000
31 Casimir Seire 73,900 43,900
32 Hendrik Diegenant 73,000 43,000
33 Grantas Naujokas 70,400 40,400
34 Aleksi Naski 67,400 37,400
35 Janne Nevalainen 67,400 37,400
36 Akseli Paalanen 67,000 37,000
37 Ignacio Garrido 66,500 36,500
38 Martin Piik 65,300 35,300
39 Jari-Pekka Juhola 64,400 34,400
40 Vladislav Senkevic 64,200 34,200
41 Kristian Larsson 62,100 32,100
42 Totti Arosuo 60,800 30,800
43 Jyrki Lampinen 59,200 29,200
44 Ivar Vendelin 58,100 28,100
45 Karlo Kivi 56,800 26,800
46 Niki Nurmisto 55,900 25,900
47 Vadims Milovs 50,200 20,200
48 Inigo Robles 49,300 19,300
49 Elias Vaaraniemi 45,700 15,700
50 Edgars Beizaks 45,500 15,500
51 Andres Aro 43,500 13,500
52 Matias KesanenÊ 41,100 11,100
53 Touko Berndtson 40,100 10,100
54 Stefan Bittger 38,700 8,700
55 Kaspars Butans 37,500 7,500
56 Kaido Mikk 36,800 6,800
57 Tonis Viik 34,600 4,600
58 Eetu Porkka 32,000 2,000
59 Patrick Schratz 30,000 0
60 Oskar Ojaveer 29,300 700
61 Stanislav Smeljov 28,900 1,100
62 Lars Nydegger 27,500 2,500
63 Julius Tiihonen 27,500 2,500
64 Silver Simulask 25,200 4,800
65 James Noonan 24,500 5,500
66 Alberto Gonzalez 24,000 6,000
67 Andrey Koks 21,200 8,800
68 Kalle Lindholm 21,000 9,000
69 Patrick Pfeiffer 21,000 9,000
70 Elias Suhonen 20,000 10,000
71 Yanis Sahli 18,300 11,700
72 Jose Koistinen 18,200 11,800
73 Artjoms Hromovs 16,400 13,600
74 Sergei Aleksejev 11,300 18,700
75 Eeti Loyttyniemi 8,300 21,700

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.