0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0090 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-05-14'
AND `url` = 'https://www.maineventtravel.com/live-reporting/aspersspringfest2023/1/chips'
ORDER BY `views` DESC

0.0012 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/aspersspringfest2023/1/chips', 1, '2024-05-14')

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.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.0005 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.0002 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.0063 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` = 'aspersspringfest2023'

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '19'

0.0211 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0039 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '71'
AND `published` = 1

0.0215 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0044 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '72'
AND `published` = 1

0.0242 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0042 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '73'
AND `published` = 1

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

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

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

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

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

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

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

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

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

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2012
English
Aspers Spring Festival Main Event Live Reporting - Day 3
Current Level 28 Current Day 3
Blinds 25,000/50,000 Ante 50000
Entries 313 Remaining 1
Prize Pool (GBP) £163,950 First Prize (GBP) £30,500
Day 1 Day 2 Day 3
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Chip Counts - Day 1
Place Player Chips Progress
1 Nicholas Trattou 256,400 226,400
2 Raafat Sharawi 247,500 217,500
3 Alexandre Gomes De Souza Luz 237,000 207,000
4 Jimmy Kebe 227,300 197,300
5 Gary Miller 227,000 197,000
6 Mark Mclachlan 208,800 178,800
7 Jonathan Weekes 205,200 175,200
8 Adrian Cazacu 198,500 168,500
9 Eric Mc Geough 193,000 163,000
10 Ramakrishnan Iyer 192,100 162,100
11 Rory Liffey 182,000 152,000
12 Kevin Allen 178,000 148,000
13 Umberto De Padua 176,300 146,300
14 Jen Chiang 166,300 136,300
15 Ong Pin Quan 160,400 130,400
16 Niall Mullally 159,100 129,100
17 James Marshall 154,200 124,200
18 Hamid Rowshanaei 152,900 122,900
19 Sang Nguyen 148,300 118,300
20 Anthony Panayi 147,700 117,700
21 Alessandro Acampora 145,400 115,400
22 Simon Green 143,100 113,100
23 Ravi Sharda 139,400 109,400
24 James O'Rourke 137,200 107,200
25 Stephane Nadot 131,400 101,400
26 Brian Riley 130,800 100,800
27 Raheel Bhatti 126,600 96,600
28 Ernestas Latoza 125,600 95,600
29 Raunaq Latif 122,400 92,400
30 Wesley Forrester 122,300 92,300
31 Sean Mallia 119,100 89,100
32 Hongting Xu 112,700 82,700
33 Tajveer Koonjul 111,200 81,200
34 Wayne Leung 109,600 79,600
35 Daniel Hanchard 108,100 78,100
36 Alexandre Richardson 106,100 76,100
37 Angel Popov 101,300 71,300
38 Valentin Florin Lupastean 99,000 69,000
39 George Achillea 97,200 67,200
40 Iulian-Adrian Iorga 89,900 59,900
41 Maximilian Sanders 89,400 59,400
42 Timothy Chung 88,000 58,000
43 Boris Velev 87,900 57,900
44 Neophytos Neophytou 87,200 57,200
45 Xuan Nguyen 85,400 55,400
46 Ciprian Teaca 81,000 51,000
47 Ahrash Dianat 80,600 50,600
48 Stephen Smith 79,800 49,800
49 Mauro Suriano 79,400 49,400
50 Dillan Patel 79,400 49,400
51 Stefan-Alexandru Nastasache 79,400 49,400
52 Christopher Yong 78,800 48,800
53 Dost Ghrabie 78,000 48,000
54 Michael Moore 76,500 46,500
55 Calvin Miller 69,400 39,400
56 Eliran Argelazi 66,800 36,800
57 Jorge Palomino 64,800 34,800
58 Vladimir Marchevici 63,800 33,800
59 Lorenc Boci 63,700 33,700
60 Hang Xu 62,100 32,100
61 Haitao Wu 61,800 31,800
62 Sebastien Jung 59,000 29,000
63 Mantas Paleckas 57,800 27,800
64 Peter Hall 57,300 27,300
65 Ion Anghel 55,300 25,300
66 Jonathan Schuman 53,200 23,200
67 Rongjun Tong 53,100 23,100
68 Nicolai Cravciuc 50,800 20,800
69 Jean Chan Pang Cheong 45,400 15,400
70 Jitin Dhawan 45,000 15,000
71 Ali Abdulzahra 44,900 14,900
72 Aurel Iacob 44,400 14,400
73 Keith Hoang 44,200 14,200
74 Thi Pham 43,000 13,000
75 Nikola Panayotov 41,800 11,800
76 Sukhdev Singh 40,800 10,800
77 Ch Fazeel M Khan 39,200 9,200
78 Abe Richards 32,000 2,000
79 Vinod Fernandez 31,800 1,800
80 James Williams 30,000 0
81 Danh Tran 30,000 0
82 Mohammed Sheikh 30,000 0
83 Artan Dedusha 30,000 0
84 Stefan Bratanov 30,000 0
85 Antony Friel 28,800 1,200
86 Neil Barron 28,800 1,200
87 Lee Mulligan 26,600 3,400
88 Edwin U 25,900 4,100
89 David Mcconachie 25,100 4,900
90 Denis Vasilachi 23,900 6,100
91 Paul Maguire 23,400 6,600
92 Nicky Levent 23,300 6,700
93 Mikhail Drozdov 22,800 7,200
94 Adil Miyanji 19,400 10,600
95 Leandro Assis 16,000 14,000
96 Shing Hei Hugo Lee 10,200 19,800

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.