Find AA Meetings Near Fifty Lakes, Minnesota

SELECT DISTINCT terms.term_id, terms.name, terms.slug, IFNULL(parent.name, '') AS parent_name, ( 3959 * acos( cos( radians( '46.760422' ) ) * cos( radians( lat.meta_value ) ) * cos( radians( lng.meta_value ) - radians( '-94.088149' ) ) + sin( radians( '46.760422' ) ) * sin( radians( lat.meta_value ) ) ) ) AS dist FROM wp_term_taxonomy tax INNER JOIN wp_terms terms ON tax.term_id = terms.term_id INNER JOIN wp_termmeta lat ON tax.term_taxonomy_id = lat.term_id AND lat.meta_key = 'lat' INNER JOIN wp_termmeta lng ON tax.term_taxonomy_id = lng.term_id AND lng.meta_key = 'lng' LEFT JOIN wp_term_taxonomy parent_tax ON tax.parent = parent_tax.term_taxonomy_id LEFT JOIN wp_terms parent ON parent_tax.term_id = parent.term_id WHERE 1 = 1 AND tax.taxonomy = 'aa-meeting-location' AND terms.term_id != 11055 HAVING dist < 12.000000 ORDER BY dist ASC