0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0073 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-23'
AND `url` = 'https://www.maineventtravel.com/destination/guide/dublin-destination-guide'
ORDER BY `views` DESC

0.0101 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-23'
AND `url` = 'https://www.maineventtravel.com/destination/guide/dublin-destination-guide'

0.0005 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.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.0003 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.0060 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 `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.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` = 'dublin-destination-guide'

0.0050 SECONDS: 
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(53.3498053 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(53.3498053 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-6.2603097 - 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.0002 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` = 6
ORDER BY `news_article_destinations`.`display_order`

0.0002 SECONDS: 
SELECT `uapi_airports`.*, `uapi_cities`.`name` as `city`, `uapi_countries`.`name` as `country`
FROM `uapi_airports`
JOIN `uapi_countries` ON `uapi_countries`.`country_code` = `uapi_airports`.`country_code`
JOIN `uapi_cities` ON `uapi_cities`.`city_code` = `uapi_airports`.`reference_city`
WHERE `airport_code` = 'DUB'
English
  1. Home
  2. Destination Guide - Dublin
Destination Guide Dublin

From castles and cathedrals to gourmet restaurants and lively bars, Dublin has it all. Pin your holiday round one of the major tournaments taking place in Dublin every year and you’ve got everything you need for a perfect holiday.

Poker in Dublin

Dublin always provides a feast of year-round poker action – from world-class tournaments to clubs around the city, all contributing to a thriving poker scene and making Dublin the perfect destination for a poker holiday. Thanks to the Irish Poker Open, Dublin has been a magnet for players from all over the globe for more than 40 years. American poker legends such as Doyle Brunson, Amarillo Slim and Stu Ungar have all competed in Dublin and, more recently, Steve O’Dwyer settled in the city – and then went on to win the Irish Open in 2022.

Events in 2024 include the Dublin Poker Festival from February 29 to March 10, the Irish Poker Tour’s St Patrick's Weekend Festival from March 15-17, the Irish Poker Open at the Royal Dublin Society from March 25 to April 1, the Irish Poker Tour’s The Monster in May and the International Poker Open in October. Local clubs that run tournaments and cash games include the new JP Poker club in Tallaght and the D1 Club Casino.

What's Hot in Dublin

Events

Travel Search

Your trip starts here...
Search anywhere using the form below, click here to search for events, or have a look at the calendar to see what's on!
Flights
From
To
Cabin Class & Travellers
1 Adult, Economy
Hotels
Staying near
Rooms
Guests
1 Adult


Rates
Dates of Travel
Dates of Travel Close
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.