0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0104 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-29' AND `url` = 'https://www.maineventtravel.com/tour/estrellas-poker-tour' ORDER BY `views` DESC

0.0011 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour/estrellas-poker-tour', 1, '2024-03-29')

0.0006 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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0006 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' 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 * 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.0115 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.0007 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.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` = 'page'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'estrellas-poker-tour'

0.0004 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'estrellas-poker-tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = '134'

0.0021 SECONDS:
SELECT tour_stops.*, 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_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '134' ORDER BY `tour_stops`.`start_date` ASC

0.0169 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC

0.0014 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` = 'news'

0.0008 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

Estrellas Poker Tour


Estrellas Poker Tour (ESPT) is returning to Spain’s iconic locations in 2023.

Upcoming Tour Stops

Monday 10th - Sunday 16th June, 2024

ESPT Malaga

Casino Torrequebrada, Av. del Sol, s/n, 29639 Benalmádena, Málaga, Spain

Málaga.

One of Spain’s most stunning coastal cities. Perfect for sun, sea, sand, nightlife…and the thrill of live poker.

That’s right. The Estrellas Poker Tour (ESPT) hits Málaga once again this summer for seven days of non-stop action under the Mediterranean sun. Join us there for some classic ESPT action, epic off-the-felt activities and some of the hottest nightlife Europe has to offer.

ESPT Cup: Dates TBC - €330

ESPT Main Event:  Dates TBC - €1,100

ESPT High Roller: Dates TBC - €2,200

#FinalTableFreeroll Eligible Event - Win Back 100% of Your Tournament Travel Costs

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Monday 26th August - Sunday 8th September, 2024

ESPT Barcelona

Casino de Barcelona, Calle Marina, 19-21, 08005 Barcelona, Spain

Spain’s biggest poker returns to Barcelona after a record-breaking 2023.

Prepare for two weeks of red-hot poker action under the Catalonian sun as the Estrellas Poker Tour (ESPT) returns for one of its most well-loved stops. Held at the iconic Casino Barcelona, and with a range of events to suit every hand, there’s something for everyone at ESPT Barcelona – both on and off the tables.

So join ESPT – a fortnight of exhilarating live poker, epic off-the-felt activities and lively nightlife awaits.  

Key Dates 

ESPT Main Event: August 26- September 1 - €1,100

ESPT Cup: Dates TBC - €550

ESPT High Roller: Dates TBC - 2200

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  
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.