0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0119 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-21' AND `url` = 'https://www.maineventtravel.com/news/article/Debut-UKIPT-Malaga-set-to-attract-huge-numbers' ORDER BY `views` DESC

0.0135 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-21' AND `url` = 'https://www.maineventtravel.com/news/article/Debut-UKIPT-Malaga-set-to-attract-huge-numbers'

0.0004 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.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.0038 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.0054 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0100 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0007 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.0005 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.0073 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0011 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.0007 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.0051 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0010 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.0007 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.0044 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0006 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.0102 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0009 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.0005 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.0060 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0009 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.0007 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.0059 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0010 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.0007 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.0058 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0009 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.0007 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.0045 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0008 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.0007 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.0117 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0009 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.0007 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.0050 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0009 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.0007 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.0020 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 `url_name` = 'Debut-UKIPT-Malaga-set-to-attract-huge-numbers'

0.0011 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 `date` <= '2024-11-21' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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

0.0005 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.0002 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '1009'

0.0002 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Thursday 16th May, 2024

Debut UKIPT Malaga set to attract huge numbers

By Mad Harper

A real treat is in store for sun-lovers next month with the debut of PokerStars’ UKIPT Malaga event. It’s an exciting new addition to the UKIPT schedule and follows in the footsteps of the highly successful UKIPT Marbella as well as the Estrellas Poker Tour (ESPT) which has been visiting Malaga since 2010.

UKIPT Malaga, which is being held in conjunction with the ESPT,  offers seven days of non-stop action from June 10-16 at Casino Torrequebrada in Benalmadena, a popular Costa del Sol resort just 20 minutes from Malaga airport and 40 minutes from the city centre. With sun, sea, beautiful beaches and historic Malaga nearby, we’re expecting UKIPT Malaga to attract big numbers. Among the highlights on the schedule are the €2k ESPT/UKIPT High Roller from June 11-12, the €1,100 ESPT/UKIPT Main Event starting on June 12 and the €330 ESPT/UKIPT Cup kicking off on June 15.

MainEventTravel has plentiful accommodation options near the Benalmadena venue and a ton of budget flights from airports all over the UK are available via the MainEventTravel website.

At last year’s Estrellas Poker Tour Malaga stop in September, the Main Event attracted 485 entries – creating a giant €465,400 prize pool – with Jose Gonzalez from Tenerife winning €91,960.  The following month Gonzalez came third at EPT Cyprus for a monster cash of €465,425 and now has well over $1 million in live tournament winnings.

Booking flights

Malaga is ideally placed for a quick getaway with cheap direct flights from airports all over the UK including London, Liverpool, Bristol, Birmingham, Manchester, Glasgow and Edinburgh. Airlines include Easy Jet, BA and Jet 2. Just head to the UKIPT Malaga event page and choose the dates you want and departure airport. 

Come Early, Stay Later!!!

We strongly recommend players turn their trip to UKIPT Malaga into a real poker holiday. Malaga is an amazing city and you also want to give yourself time to chill out on one of the fabulous Costa del Sol beaches near Benalmadena – or enjoy a round or two on one of the Costa del Sol’s superb golf courses.  Check out our hotels for UKIPT Malaga and change the default dates in the search area to give yourself a longer holiday. 

About Benalmadena

As well as a great casino, gorgeous harbour, vibrant old town and a ton of lovely beaches, Benalmadena also has a number of well-known tourist attractions including Europe’s largest Butterfly Park – home to over 1,500 exotic butterflies – and the Benalmadena 15-minute cable car which takes you high above the town to the top of the Calamorro Mountain. Benalmadena’s Paloma Park is also a lovely place to get your head in gear before taking to the tables with more than 200,000m2 of green space in the centre of the town including an impressive Cactus Garden with more than 450 species.

Benalmadena is well-known for its lively nightlife scene. It’s buzzing! Especially around the resort’s famous Plaza Solymar where bars and clubs are open pretty much 24 hours a day. (Popular clubs including the disco pub Molly Malone’s (pictured below) and Discoteca Mango.) Benalmadena Marina is also a great spot for hanging out with numerous bars in a lovely setting overlooking the luxury yachts.

Golfer’s Paradise

The Costa del Sol is also a haven for golfers with a total of 22 courses near Benalmadena ranging from nine-hole Pitch and Putt courses to top courses like Torrequebrada, La Cala, Santana, Mijas, Calanova and Lauro Golf.

Further Afield – Visiting Malaga

Malaga was founded in the 8th century by the Phoenicians and is one of the oldest port cities in the world. With its cobbled Old Town and palm-fringed plazas, it has all the charm of a southern European city with numerous attractions including a Roman amphitheatre, amazing baroque cathedral and Moorish Alcazaba castle (pictured below). The city is also home to over 30 museums dedicated to everything from decorative glass to the automobile.

Chief amongst these is the Picasso Museum. Picasso was born in Malaga and the museum, which is housed in the 16th-century Buenavista Palace, gives a solid overview of the artist’s life with over 200 works in the collection. Highlights include a painting of Picasso’s sister Lola undertaken when the artist was only 13 along with sculptures, sketches and paintings galore.

Another great tourist attraction is Málaga’s Alcazaba – a stunning 11th-century Moorish palace-fortress (pictured below) set in gorgeous gardens. Also on our list – if you have time – are Malaga’s celebrated Botanical Gardens, created just outside the city by a noble family of railway builders and bankers and now containing the largest collection of subtropical plants in Europe. 

No visit to Malaga is complete without dropping into the city’s magnificent Cathedral. Started in the 16th century, it boasts a fabulous 40m domed ceiling along with a vast collonaded nave and 15 distinct chapels along the aisles. The guided tour takes you up to the roof which affords panoramic views of the city.

Hotels

As you might expect from a Costa del Sol resort, you are spoiled for choice when it comes to hotels and several are within walking distance of Casino Torrequebrada.

3* Casinomar

They don’t get much closer than Casinomar which is just 200 metres from the beach and five minutes’ walk from Casino Torrequebrada. Decorated simply and with wooden furnishings, the Casinomar apartments each have their own private balcony and even a parking space. Facilities include a dining area with TV, kitchenette, fridge and washing machine. Casinomar has a bar on site, an outdoor swimming pool, garden and terrace. Although there is no onsite restaurant, there are plenty nearby. 

 

3* Flatotel Internacional

The Flatotel Internacional is just 14 minutes’ walk from Torrequebrada Casino and 20 metres from Benalmádena's Yucas Beach. It features an outdoor pool with a bar, a buffet snack bar and a gym. All the rooms have air-conditioning, and the apartments and studios also have private balconies with sea views. Free WiFi is available and there is also a games room, gym and on-site restaurant. It’s also bang next door to the local golf course! 

 

3* MedPlaya Hotel Alba Beach

This pleasant hotel is situated just a stone's throw from Benalmádena's Torrequebrada Beach. There are two outdoor pools, bars and a restaurant and it’s close to lots of little shops, cafés, bars and restaurants. The Torrequebrada Golf Course is right next door and the Casino is just a short walk away.

3* Sahara Sunset By Diamond Resorts

Just seven minutes by cab from the Casino Torrequebrada, the Sahara Sunset punches above its weight when it comes to comfort and amenities. Designed to emulate Moorish architecture, this 3* hotel has both an outdoor pool – set in landscaped surroundings – and an indoor pool. Rooms are spacious and welcoming and each has its own private balcony or terrace. Dining – and cocktails – are at the hotel’s Casbah Café and the hotel also offers massage services.

4* Las Arenas Affiliated by Melia

Featuring an outdoor pool and offering a beachfront location opposite the 1920s-built  Bil Bil Castle, Hotel Las Arenas is a great option for your UKIPT Malaga stay. Every room has air-conditioning, TV and minibar along with its own balcony. Some rooms also have a sea view and the hotel offers a spacious sun terrace. Facilities include an outdoor swimming pool, restaurant, bar and lounge plus free wifi. It’s a six-minute drive to the casino (or 25-minute walk).

4* Moon Dreams Torremolinos

Further afield, there are some great properties in the neighbouring resort of Torremolinos. The Moon Dreams Torremolinos is 60m from La Carihuela Beach and has its own outdoor pool. Each air-conditioned room comes with a flat-screen satellite TV, private bathroom and hairdryer. As well as onsite restaurant, the hotel offers a spa and massage services. A 24-hour reception is also available and there is free high-speed WiFi. It’s a 20-minute cab journey to UKIPT Malaga venue.

4* Ilunion Fuengirola

Lying to the south of Benalmadena is another well-known Costa del Sol resort called Fuengirola. The 4* Ilunion Fuengirola is located on the seafront with amazing views over Boliches Beach. The hotel boasts a splendid terrace, an outdoor pool, and children's recreation area. There’s free Wi-Fi. The Ilunion Fuengirola Hotel is also just 300 metres from Los Boliches train station which has a direct train to/from the airport. All the air-conditioned rooms have satellite TV and a minibar and many have their own balcony. There’s an on-site restaurant as well as a poolside snack bar with sea views.

 

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.