select `activity`.`id` as `activity_id`, `name`, `type`, `city`, `state`, `price`, `openings`, (CASE WHEN activity_status LIKE '%opening%' or activity_status LIKE '%available%' THEN 'Openings' WHEN activity_status LIKE '%closed%' THEN 'Closed' ELSE activity_status END) as activity_status, truncate(ifnull((3959 * ACOS(SIN(RADIANS(31.83688)) * SIN(RADIANS(activity.latitude)) + COS(RADIANS(31.83688)) * COS(RADIANS(activity.latitude)) * COS(RADIANS(activity.longitude) - RADIANS(-102.0103767)))),0),2) as distance, `address`, `latitude`, `longitude`, `activity`.`id` from `activity` inner join `activity_availability` on `activity`.`id` = `activity_availability`.`activity_id` where `name` is not null and `activity_status` != 'CLOSED' and `is_visible` = 'Y' and `is_approved` = 'Y' and (`activity_availability`.`end_date` >= '2026-11-08' or `activity_availability`.`end_date` is null) and (`activity_availability`.`end_date` >= '2026-11-08' or `activity_availability`.`end_date` is null) and ((`geohash` > '9tw' and `geohash` < '9ty') or (`geohash` > '9v8' and `geohash` < '9vb') or (`geohash` > '9ty' and `geohash` < '9t~') or (`geohash` > '9vb' and `geohash` < '9vd')) and `activity`.`type` in (select `type_name` from `activity_types` where `enable_for` in ('F', 'A')) group by `activity`.`id` having `distance` <= 50 order by FIELD(activity_status, 'full'), distance, COALESCE(MIN(activity_availability.start_date), '2099-12-31') ASC limit 51 - Column 'price' in field list is ambiguous
Fun Events & Activities for All Ages (Kids, Adults 18+ & Seniors 55+) near Dublin
Showing 0 Events
Quick Filters:
All Ages
🍷 Adults 18+
🌟 Seniors 55+
⚡ Teens 13–17
🧸 Kids & Family
📅 This Weekend
✨ Free Events
dublin
Clear All
🔍
No matching events found for those exact filters
Try broadening your age group, clearing the city filter, or exploring one of our popular categories below.