WordPress database error: [Unknown column 'wp_posts.date' in 'ORDER BY']SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta AS dme_availability_meta
ON (
wp_posts.ID = dme_availability_meta.post_id
AND dme_availability_meta.meta_key = '_dme_model_availability_status'
)
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (113)
) AND wp_posts.post_type = 'fw-model' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY CASE
WHEN dme_availability_meta.meta_value = 'away'
THEN 3
WHEN dme_availability_meta.meta_value = 'travel_only'
THEN 2
ELSE 1
END ASC,
wp_posts.menu_order ASC,
wp_posts.date DESC
LIMIT 0, 12