mysql - WordPress 数据库 : Include a custom field in mysql query

Question

SELECT DISTINCT    
            city_latitude.post_id,
            city_latitude.meta_value as charity_latitude,
            city_longitude.meta_value as charity_longitude,
            ((ACOS(SIN(%f * PI() / 180) * SIN(city_latitude.meta_value * PI() / 180) + COS(%f * PI() / 180) * COS(city_latitude.meta_value * PI() / 180) * COS((%f - city_longitude.meta_value) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance,
            FxFfekP0_posts.post_title
            FROM 
            FxFfekP0_postmeta AS city_latitude
            LEFT JOIN FxFfekP0_postmeta as city_longitude ON city_latitude.post_id = city_longitude.post_id
            INNER JOIN FxFfekP0_posts ON FxFfekP0_posts.ID = city_latitude.post_id
            WHERE city_latitude.meta_key = 'latitude' AND city_longitude.meta_key = 'longitude'
            HAVING distance < %d
            ORDER BY distance ASC

如何添加到此查询并将 charity_name 自定义字段包含为列？我在这个问题上遇到了困难...

注意:我确实将其发布在 wordpress.stackoverflow.com 上，但有人建议我将其发布到此处，因为它更多的是 MySQL 问题。

Answer 1

未经测试，但应该是正确的 - 搜索此网站是否有任何不立即有意义的部分......

SELECT lat.post_id
     , lat.meta_value charity_latitude
     , lon.meta_value charity_longitude
     , name.meta_value charity_name
     , geo_distance_km(user_lat,user_lon,lat.meta_value,lon.meta_value) distance
     , p.post_title
  FROM FxFfekP0_postmeta lat
  LEFT 
  JOIN FxFfekP0_postmeta lon 
    ON lon.post_id = lat .post_id
   AND lon.meta_key = 'longitude'
  LEFT
  JOIN FxFfekP0_posts p
    ON p.ID = lat.post_id
  LEFT
  JOIN FxFfekP0_postmeta name
    ON name.post_id = lat.post_id
   AND name.meta_key = 'charity_name'
 WHERE lat.meta_key = 'latitude' 
AND geo_distance_km(user_lat,user_lon,lat.meta_value,lon.meta_value) < %d
        ORDER BY distance ASC