{"0":[{"relation":"OR","0":{"key":"_candidate_show_profile","value":"hide","compare":"!="},"1":{"key":"_candidate_show_profile","compare":"NOT EXISTS"}}],"cv_exists":{"key":"_densoft_cv_order","compare":"EXISTS","type":"NUMERIC"},"dispo":{"key":"_densoft_dispo_order","compare":"EXISTS","type":"NUMERIC"}} SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id AND mt1.meta_key = '_candidate_show_profile' ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) WHERE 1=1 AND ( ( ( ( wp_postmeta.meta_key = '_candidate_show_profile' AND wp_postmeta.meta_value != 'hide' ) OR mt1.post_id IS NULL ) ) AND mt2.meta_key = '_densoft_cv_order' AND mt3.meta_key = '_densoft_dispo_order' ) AND wp_posts.post_type = 'candidate' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY CAST(mt2.meta_value AS SIGNED) ASC, CAST(mt3.meta_value AS SIGNED) ASC, wp_posts.post_date DESC LIMIT 738, 9
Résultats 739 – 747 sur 861