0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0099 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-19' AND `url` = 'https://www.maineventtravel.com/destination/articles/malta-guide/poker-malta' ORDER BY `views` DESC

0.0016 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/malta-guide/poker-malta', 1, '2024-04-19')

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.0007 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.0003 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.0117 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.0011 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.0005 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.0003 SECONDS:
SELECT destinations.*, uapi_airports.name as airport_name FROM `destinations` LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code` WHERE `url` = 'malta-guide'

0.0028 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` = 'poker-malta'

0.0003 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` = '516'

0.0079 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(35.91469885216256 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(35.91469885216256 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((14.49832554589841 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo FROM `venues` LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id` JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` WHERE `tour_stops`.`active` = '1' AND tour_stops.end_date > CURDATE() HAVING `distance` <= 10 ORDER BY `tour_stops`.`start_date` ASC

0.0005 SECONDS:
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title` FROM `news_article_destinations` JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id` WHERE `news_articles`.`active` = 1 AND `destination_id` = 3 ORDER BY `news_article_destinations`.`display_order`

Thursday 26th April, 2018

Poker in Malta

By Mad Harper

Live Events Travel Tips Main Event Travel News Blogs News

Malta is a near perfect destination for a poker holiday – for starters, there’s lots of poker but if you’re headed to the island with non-poker playing friends – or even if you just fancy a break from the tables yourself – there are also tons of other things to do. Whether it’s strolling around the gorgeous capital city of Valletta, clubbing all night in Paceville or chilling out at Golden Bay beach, Malta really does have something for everyone.

Malta’s phenomenal rise as one of the world’s premier iGaming hubs has encouraged some of the biggest names in the business to set up shop on the island and make Malta their new base. Among the companies with sizeable offices in Malta are industry leaders PokerStars, Unibet and Betsson. That means the island is already home to hundreds of poker players, and many hundreds more have moved there to play online, or enjoy live cash games and tournaments at the island’s casinos.

The three main casinos are all located in Paceville in St Julians, the heart of Malta's thriving nightlife scene. Surrounded by cafes, restaurants, bars and nightclubs, with tons of hotels also conveniently located in the area, this is the #1 destination for poker players.

Casino Malta
Casino Malta, which has lately taken over the award-winning Battle of Malta tournament, is fast becoming one of the island’s top poker venues. Located on the edge of St George’s Bay in San Giljan, the poker club is open daily from 6pm and features daily cash games and regular tournaments. Casino Malta claims to have the lowest rake on the island at 4%, capped at €10. This year, the Casino is hosting three of the biggest poker tournaments in Europe: the Unibet Open from May 16-20, the Unibet Deepstack Open from September 5-9 and the Battle of Malta in October.

Portomaso Casino
Portomaso Casino is in the heart of buzzing St Julian’s and claims to be the biggest and most popular poker room in Malta. The casino hosts tournaments every day with two on Saturday. Most of the tourneys have guarantees and buy-ins range from €35 to €110. There are also Special Poker events every month, along with a host of international events. As you’d expect, there are cash games running every day, at €1/€2+. The staff are friendly and there’s free wine and non-alcoholic drinks served during play.

Dragonara Casino
Dragonara Casino’s boast is that it’s the only poker room on the island with a sea view. Situated on the terrace of the majestic Dragonara Palace overlooking St. George’s Bay, the Poker Room at Dragonara Casino provides poker die-hards with a daily schedule of tournaments and all night cash games. The Dragonara also hosted the Redbet Live tour in January and March.

Oracle Casino
Oracle Casino is located towards the north of Malta in a spectacular setting at St Paul’s Bay. Cash Games run daily from 8pm onwards with minimum €100 buy-in. Blinds are at €1/€2 for NLHE and €2/€2 for Omaha unless otherwise requested. Like the other casinos, Oracle also runs daily tournaments with byy-ins ranging from €20 to €30.