WordPress database error: [Unknown column 'geo_distance' in 'having clause']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts inner join wp_postmeta as metalat on wp_posts.ID = metalat.post_id and metalat.meta_key = 'dokan_geo_latitude' inner join wp_postmeta as metalong on wp_posts.ID = metalong.post_id and metalong.meta_key = 'dokan_geo_longitude' inner join wp_postmeta as metaaddr on wp_posts.ID = metaaddr.post_id and metaaddr.meta_key = 'dokan_geo_address'
WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (7)
)
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'wc-partial')))
GROUP BY wp_posts.ID having geo_distance < 100
ORDER BY wp_posts.post_date DESC, wp_posts.ID DESC
LIMIT 0, 12