MySQL查询失败，因为列表中的列名

Question

我有一个MySQL查询，可以完美地工作，没有具有子句，但是当我使用该子句时，我会遇到错误，我认为这与我使用该子句进行比较有关用我在选择中声明的列名称。

查询：

SELECT
  DISTINCT p.ID,
  p.post_title,
  practice_latitude.meta_value as locLat,
  practice_longitude.meta_value as locLong,
  (
    '3959' * acos(
      cos(radians('39.40517956963392')) * cos(radians(practice_latitude.meta_value)) * cos(
        radians(practice_longitude.meta_value) - radians('-118.99713149999997')
      ) + sin(radians('39.40517956963392')) * sin(radians(practice_latitude.meta_value))
    )
  ) AS distance
FROM
  wp_posts p
  INNER JOIN wp_postmeta practice_latitude ON p.ID = practice_latitude.post_id
  INNER JOIN wp_postmeta practice_longitude ON p.ID = practice_longitude.post_id
WHERE
  p.post_type = 'awpcp_listing'
  AND p.post_status = 'publish'
  AND practice_latitude.meta_key = '_awpcp_extra_field[36]'
  AND practice_longitude.meta_key = '_awpcp_extra_field[37]'
HAVING
  distance < 500
group by
  practice_latitude.meta_value,
  practice_longitude.meta_value;

似乎在选择中声明的“距离”列是问题。我该如何纠正以应用适当的有子句 e，由于查询否则可以很好地工作？