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'
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on null in /var/www/clients/client1/web1/web/includes/fct_swql.php:47 Stack trace: #0 /var/www/clients/client1/web1/web/includes/fct_search.php(75): swql_fetch_assoc(' SELECT M.id, M...') #1 /var/www/clients/client1/web1/web/pages/search-city.php(82): find_pos_by_proximity(false, false) #2 /var/www/clients/client1/web1/web/index.php(24): require('/var/www/client...') #3 {main} thrown in /var/www/clients/client1/web1/web/includes/fct_swql.php on line 47