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