SELECT V.dateinscription, 2 as type, V.id, V.prix, V.modele, A.marque, E.energie, V.km, Cli.codePostal, photo1, DATE_FORMAT(V.datecirculation,'%d-%m-%Y') as datecirculation,V.puissance
FROM tblvehicule V
LEFT JOIN tblenergie E ON V.energie=E.id
LEFT JOIN tblclient Cli ON V.particulier=Cli.id,
tblmarque A,
tbltype Y
WHERE
V.marque = A.id
AND V.type=Y.id ORDER BY modele DESC LIMIT 0 , 20