select *, SUM(review_service + review_staff +review_value + review_atmosphere ) AS total_star ,( 6371 * acos( cos( radians('39.9625') ) * cos( radians( listing_latt ) ) * cos( radians( listing_long ) - radians('-83.0061') ) + sin( radians('39.9625') ) * sin( radians( listing_latt ) ) ) ) AS distance FROM tbl_listing l
LEFT JOIN tbl_limages li ON li.limage_listing_id = l.listing_id
LEFT JOIN tbl_potype pt ON pt.potype_id = l.listing_ptype
LEFT JOIN tbl_potype ptt ON find_in_set(ptt.potype_id,l.listing_good_for)
LEFT JOIN tbl_bookingoption bo ON bo.bookingoption_user = l.listing_customer_id
LEFT JOIN tbl_review re ON re.review_listing_id = l.listing_id
LEFT JOIN tbl_package p ON p.package_id = l.listing_package
WHERE 1=1 AND listing_status = '1' AND listing_approved = 'accept' AND (listing_for = 'therapiest' ) AND listing_display = 1 AND listing_deleted_at IS NULL AND listing_featured = '1' GROUP BY listing_id ORDER BY distance ASC , listing_last_updated DESC LIMIT 0, 2 select *, SUM(review_service + review_staff +review_value + review_atmosphere ) AS total_star ,( 6371 * acos( cos( radians('39.9625') ) * cos( radians( listing_latt ) ) * cos( radians( listing_long ) - radians('-83.0061') ) + sin( radians('39.9625') ) * sin( radians( listing_latt ) ) ) ) AS distance FROM tbl_listing l
LEFT JOIN tbl_limages li ON li.limage_listing_id = l.listing_id
LEFT JOIN tbl_potype pt ON pt.potype_id = l.listing_ptype
LEFT JOIN tbl_potype ptt ON find_in_set(ptt.potype_id,l.listing_good_for)
LEFT JOIN tbl_bookingoption bo ON bo.bookingoption_user = l.listing_customer_id
LEFT JOIN tbl_review re ON re.review_listing_id = l.listing_id
LEFT JOIN tbl_package p ON p.package_id = l.listing_package
WHERE 1=1 AND listing_status = '1' AND listing_approved = 'accept' AND (listing_for = 'therapiest' ) AND listing_display = 1 AND listing_deleted_at IS NULL AND listing_id NOT IN (2886,3775) GROUP BY listing_id ORDER BY distance ASC , listing_last_updated DESC LIMIT 0, 8 select COUNT( * ) AS total, potype_id, potype_title, potype_slug FROM tbl_listing l LEFT JOIN tbl_potype ptt ON find_in_set(ptt.potype_id,l.listing_good_for)
WHERE 1=1 AND listing_status = '1' AND listing_approved = 'accept' AND (listing_for = 'therapiest' ) AND listing_display = 1 AND listing_deleted_at IS NULL AND potype_title != '' GROUP BY potype_title ORDER BY total DESC, potype_title
Find a Qualified Therapist Near You | Search Therapists in Ireland - Therapists.ie
Therapists.ie connects you with verified professionals across Ireland. Search by issue, location,
and availability—or answer a few quick questions and we’ll guide you.
To provide some comfort when making a booking, after your first session, for whatever reason,
you'd like to re-schedule with another therapist, just let us know and we'll connect you at no extra charge.
Find a Qualified Therapist Near Your Location in Ireland
Looking for a trusted therapist near you? Therapists.ie helps you easily connect with licensed professionals across Ireland. Whether you need support with anxiety, relationships, trauma, or general mental wellness, our directory lets you search by location, specialty, and availability. Start your journey toward better mental health today by exploring therapists in your area.
Are you a therapist?
Join Ireland's growing directory. Showcase your expertise and manage bookings.