0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0100 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-04-28'
AND `url` = 'https://www.maineventtravel.com/live-reporting/aspersspringfest2023/1/updates'
ORDER BY `views` DESC

0.0126 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-28'
AND `url` = 'https://www.maineventtravel.com/live-reporting/aspersspringfest2023/1/updates'

0.0002 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.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.0006 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.0004 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 `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.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.0004 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.0184 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0040 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '71'
AND `published` = 1

0.0185 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` = '72'
AND `published` = 1

0.0181 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0038 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.0045 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` = '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.0045 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.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` = '3350'
ORDER BY `chip_change` DESC, `busted` ASC

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` = '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` = '71'
ORDER BY `busted` ASC, `current_chips` DESC

0.0035 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.0041 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
Live Updates - Day 1
15:42 (UTC+0)
Day 1 of Aspers Spring Festival Ended
Level: 12     Blinds: 800/1,600     Ante: 1,600
Chip Counts From Day 1a to Day 1d Posted Saturday 6th May, 2023 at 14:30(UTC+0) by Jason Glatzer

Here is a look at the 96 players that bagged chips into Day 2. This group will be joined by a handful of others that will enter or re-enter before the start of the day.

Player  Chips  Big Blinds
Nicholas Trattou       256,400 160
Raafat Sharawi       247,500 155
Alexandre Gomes De Souza Luz       237,000 148
Jimmy Kebe       227,300 142
Gary Miller       227,000 142
Mark Mclachlan       208,800 131
Jonathan Weekes       205,200 128
Adrian Cazacu       198,500 124
Eric Mc Geough       193,000 121
Ramakrishnan Iyer       192,100 120
Rory Liffey       182,000 114
Kevin Allen       178,000 111
Umberto De Padua       176,300 110
Jen Chiang       166,300 104
Ong Pin Quan       160,400 100
Niall Mullally       159,100 99
James Marshall       154,200 96
Hamid Rowshanaei       152,900 96
Sang Nguyen       148,300 93
Anthony Panayi       147,700 92
Alessandro Acampora       145,400 91
Simon Green       143,100 89
Ravi Sharda       139,400 87
James O'Rourke       137,200 86
Stephane Nadot       131,400 82
Brian Riley       130,800 82
Raheel Bhatti       126,600 79
Ernestas Latoza       125,600 79
Raunaq Latif       122,400 77
Wesley Forrester       122,300 76
Sean Mallia       119,100 74
Hongting Xu       112,700 70
Tajveer Koonjul       111,200 70
Wayne Leung       109,600 69
Daniel Hanchard       108,100 68
Alexandre Richardson       106,100 66
Angel Popov       101,300 63
Valentin Florin Lupastean         99,000 62
George Achillea         97,200 61
Iulian-Adrian Iorga         89,900 56
Maximilian Sanders         89,400 56
Timothy Chung         88,000 55
Boris Velev         87,900 55
Neophytos Neophytou         87,200 55
Xuan Nguyen         85,400 53
Ciprian Teaca         81,000 51
Ahrash Dianat         80,600 50
Stephen Smith         79,800 50
Stefan-Alexandru Nastasache         79,400 50
Dillan Patel         79,400 50
Mauro Suriano         79,400 50
Christopher Yong         78,800 49
Dost Ghrabie         78,000 49
Michael Moore         76,500 48
Calvin Miller         69,400 43
Eliran Argelazi         66,800 42
Jorge Palomino         64,800 41
Vladimir Marchevici         63,800 40
Lorenc Boci         63,700 40
Hang Xu         62,100 39
Haitao Wu         61,800 39
Sebastien Jung         59,000 37
Mantas Paleckas         57,800 36
Peter Hall         57,300 36
Ion Anghel         55,300 35
Jonathan Schuman         53,200 33
Rongjun Tong         53,100 33
Nicolai Cravciuc         50,800 32
Jean Chan Pang Cheong         45,400 28
Jitin Dhawan         45,000 28
Ali Abdulzahra         44,900 28
Aurel Iacob         44,400 28
Keith Hoang         44,200 28
Thi Pham         43,000 27
Nikola Panayotov         41,800 26
Sukhdev Singh         40,800 26
Ch Fazeel M Khan         39,200 25
Abe Richards         32,000 20
Vinod Fernandez         31,800 20
Stefan Bratanov         30,000 19
Artan Dedusha         30,000 19
Mohammed Sheikh         30,000 19
Danh Tran         30,000 19
James Williams         30,000 19
Neil Barron         28,800 18
Antony Friel         28,800 18
Lee Mulligan         26,600 17
Edwin U         25,900 16
David Mcconachie         25,100 16
Denis Vasilachi         23,900 15
Paul Maguire         23,400 15
Nicky Levent         23,300 15
Mikhail Drozdov         22,800 14
Adil Miyanji         19,400 12
Leandro Assis         16,000 10
Shing Hei Hugo Lee         10,200 6
Welcome to the Spring Poker Fest Main Event at Aspers Casino Posted Saturday 6th May, 2023 at 14:21(UTC+0) by Jason Glatzer

Welcome to the £150,000 guaranteed Spring Poker Fest £600 Main Event at the spacious Aspers Casino Westfield Stratford City. 

The event kicked off on Thursday with the first of four opening flights with players starting with 30,000 in chips. Each opening flight boasted 40-minute levels except for the final Day 1d opening flight which is faster paced at 20-minute blind levels. 

There are already around 300 entries with late registration not only still open for the ongoing Day 1d but also before the start of Day 2. This means that the £150,000 guarantee has already been smashed.

Players that bag chips during any of the opening flights will join others that enter or re-enter before the start of Day 2 and will battle it out for two more days until a winner is crowned. Day 2 will kick off at 4 p.m. or about 90 minutes after Day 1d ends. 

The plan for Day 2 is to play eight blind levels of one hour each. However, as is the case for most multi-day poker events, the schedule for the penultimate day may change based on the pace of play.

Our coverage at Main Event will begin with the start of Day 2 at 4 p.m. and will continue through Day 3 on Sunday starting at 3 p.m. until the Spring Poker Fest trophy is claimed. Best of luck to all of the players!
14:14 (UTC+0)
Day 1 of Aspers Spring Festival Started
Level: 12     Blinds: 800/1,600     Ante: 1,600

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.