SELECT M.id, M.nom, M.gamme_prix, M.img, M.ville, M.cp, M.slug, M.score, M.nbr_avis, M.presentation_fr AS presentation, EX.actif AS expo, E.enseigne, E.slug AS eslug, M.vip, M.rdv_left, M.rdv_actif FROM ka_pos M LEFT JOIN ka_villes V ON V.id = M.ville_id LEFT JOIN ka_enseignes E ON M.enseigne_id = E.id LEFT JOIN ka_expos EX ON EX.pos_id = M.id AND EX.actif = 1 AND EX.visible = 1 WHERE M.actif = 1 AND M.visible = 1 GROUP BY M.id ORDER BY vip DESC, proximite ASC LIMIT 0, 20Unknown column 'proximite' in 'order clause'