WordPress database error: [Unknown column 'wpm_postmeta.meta_value' in 'order clause']
SELECT DISTINCT wpm_posts.*
FROM wpm_posts INNER JOIN wpm_postmeta AS wlt1 ON ( wpm_posts.ID = wlt1.post_id ) INNER JOIN wpm_postmeta AS wlt2 ON ( wpm_posts.ID = wlt2.post_id )
WHERE 1=1 AND wpm_posts.post_name IN ('search') AND (
0 = 1
) AND wpm_posts.post_type = 'wp_template' AND ((wpm_posts.post_status = 'publish'))AND ( ( wlt1.meta_key = 'map-lat' AND wlt1.meta_value BETWEEN 53.6352 AND 55.0809 ) AND ( wlt2.meta_key = 'map-log' AND wlt2.meta_value BETWEEN -4.1664 AND -1.6776 ) OR ( wlt2.meta_key = 'map-zip' AND wlt2.meta_value = 'LA23 3HA'
OR wlt2.meta_key = 'map-zip' AND wlt2.meta_value = 'LA2 3 3 HA' ) AND ( ( wlt2.post_id IS NULL OR wlt2.meta_key = 'map-zip' ) ) )
GROUP BY wpm_posts.ID
ORDER BY wpm_postmeta.meta_value desc
WordPress database error: [Unknown column 'wpm_postmeta.meta_value' in 'order clause']
SELECT DISTINCT wpm_posts.*
FROM wpm_posts INNER JOIN wpm_postmeta AS wlt1 ON ( wpm_posts.ID = wlt1.post_id ) INNER JOIN wpm_postmeta AS wlt2 ON ( wpm_posts.ID = wlt2.post_id )
WHERE 1=1 AND wpm_posts.post_name IN ('search') AND (
0 = 1
) AND wpm_posts.post_type = 'wp_template' AND ((wpm_posts.post_status = 'publish'))AND ( ( wlt1.meta_key = 'map-lat' AND wlt1.meta_value BETWEEN 53.6352 AND 55.0809 ) AND ( wlt2.meta_key = 'map-log' AND wlt2.meta_value BETWEEN -4.1664 AND -1.6776 ) OR ( wlt2.meta_key = 'map-zip' AND wlt2.meta_value = 'LA23 3HA'
OR wlt2.meta_key = 'map-zip' AND wlt2.meta_value = 'LA2 3 3 HA' ) AND ( ( wlt2.post_id IS NULL OR wlt2.meta_key = 'map-zip' ) ) )
GROUP BY wpm_posts.ID
ORDER BY wpm_postmeta.meta_value desc