WordPress database error: [Unknown column 'ymcu_postmeta.meta_value' in 'order clause']
SELECT SQL_CALC_FOUND_ROWS ymcu_posts.ID
FROM ymcu_posts LEFT JOIN ymcu_term_relationships ON (ymcu_posts.ID = ymcu_term_relationships.object_id) LEFT JOIN ymcu_wc_product_meta_lookup wc_product_meta_lookup ON ymcu_posts.ID = wc_product_meta_lookup.product_id
WHERE 1=1 AND (
ymcu_posts.ID NOT IN (
SELECT object_id
FROM ymcu_term_relationships
WHERE term_taxonomy_id IN (8)
)
AND
ymcu_term_relationships.term_taxonomy_id IN (140)
) AND ((ymcu_posts.post_type = 'product' AND (ymcu_posts.post_status = 'publish' OR ymcu_posts.post_status = 'wc-pickup' OR ymcu_posts.post_status = 'wc-anpost' OR ymcu_posts.post_status = 'wc-dpd' OR ymcu_posts.post_status = 'wc-waiting-order')))
GROUP BY ymcu_posts.ID
ORDER BY ymcu_postmeta.meta_value+0 DESC, ymcu_posts.post_date DESC
LIMIT 0, 9
