SELECT a.id, a.premier_jour AS price, a.published, a.reservation_instantanee, a.rabais, a.disponibilite_precision,a.premier_jour,  a.ville,a.image1, a.date_circulation, a.reduction_un, a.reduction_deux, a.reduction_trois, a.reduction_quatre, a.model, m.marque,  ( SELECT count(id) FROM #__autos_location WHERE a.id=id_auto AND status=1 AND published=1) AS nb_locations  FROM `#__autos` as a  LEFT JOIN `#__autos_marque` as m  ON a.marque=m.id  WHERE a.published IN(0,1)  AND a.marque IN (31)  AND (  a.model LIKE "%carnival%" OR a.model LIKE "%carnival%" ) ORDER BY a.published DESC, nb_locations DESC 

Location Kia Carnival
entre particuliers

Assuré par