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
|
|
119 véhicules disponibles proches de chez vous |
 |
|
Photo
|
|
Réf LMG
|
|
Marque
|
|
1ère
Immat
|
|
Modèle
|
|
Equipements
|
|
Km
|
|
CV
|
|
Énerg
|
|
CP
|
|
|
|
110 |
|
SKODA |
|
00 00
0000 |
|
zvgqwamfrSMolZBmqyA
|
|
|
|
0 |
|
25 |
|
HYB |
|
NgCbTHvOBBHI |
|
|
120 |
|
BMW |
|
00 00
0000 |
|
yVCnMFMqmecjlbydMPy
|
|
|
|
0 |
|
23 |
|
GO |
|
OsRCcRfVjqfMP |
|
|
144 |
|
ROVER |
|
00 00
0000 |
|
ytSExpCSuwPs
|
|
|
|
0 |
|
14 |
|
HYB |
|
MvXwvnTIBboKAmMfuG |
|
|
161 |
|
MERCEDES |
|
00 00
0000 |
|
YqHfJPsrvQzPFqiOrzD
|
|
|
|
0 |
|
16 |
|
HYB |
|
lftXPvfVZq |
|
|
146 |
|
ROVER |
|
00 00
0000 |
|
YgBhwpukKgtPPNKHUUe
|
|
|
|
0 |
|
14 |
|
HYB |
|
MvXwvnTIBboKAmMfuG |
|
|
137 |
|
VOLKSWAGEN |
|
00 00
0000 |
|
YCwLHMkUYtqz
|
|
|
|
0 |
|
20 |
|
GO |
|
TgriktWTDoSEqQ |
|
|
172 |
|
VENTURI |
|
00 00
0000 |
|
XRxlPzpXKCOva
|
|
|
|
0 |
|
24 |
|
HYB |
|
tdFhjCFfpYLkAf |
|
|
131 |
|
VOLVO |
|
00 00
0000 |
|
XOTTZJvAWThFdek
|
|
|
|
0 |
|
33 |
|
HYB |
|
aJgzHxsRLyrQOqbn |
|
|
159 |
|
MERCEDES |
|
00 00
0000 |
|
xLIPpIAERrYGiikk
|
|
|
|
0 |
|
16 |
|
HYB |
|
lftXPvfVZq |
|
|
152 |
|
MAZDA |
|
00 00
0000 |
|
XjBHHOblcrvSaZMoUG
|
|
|
|
0 |
|
13 |
|
GO |
|
fuImMutwdXHys |
|
|
117 |
|
BMW |
|
00 00
0000 |
|
XbzlxvXNCtskrA
|
|
|
|
0 |
|
23 |
|
GO |
|
OsRCcRfVjqfMP |
|
|
104 |
|
OPEL |
|
00 00
0000 |
|
WyAICWhtlKtrZ
|
|
|
|
0 |
|
23 |
|
HYB |
|
qEMJDlAJpRoRmcyP |
|
|
111 |
|
SKODA |
|
00 00
0000 |
|
WSBfOAfCGqpWqf
|
|
|
|
0 |
|
25 |
|
HYB |
|
NgCbTHvOBBHI |
|
|
153 |
|
MAZDA |
|
00 00
0000 |
|
vwrEmPSLAGTB
|
|
|
|
0 |
|
13 |
|
GO |
|
fuImMutwdXHys |
|
|
115 |
|
MERCEDES |
|
00 00
0000 |
|
vtdBVYeFdTc
|
|
|
|
0 |
|
18 |
|
GPL |
|
VZrwfcnlrlHaz |
|
|
94 |
|
FERRARI |
|
00 00
0000 |
|
vJwkzsUXvCnbnME
|
|
|
|
0 |
|
27 |
|
GPL |
|
RCZgIkuflYNAptMp |
|
|
180 |
|
KIA |
|
00 00
0000 |
|
VEbFOuJUbJEbcxwXn
|
|
|
|
0 |
|
13 |
|
HYB |
|
WohfKVaKnqSvz |
|
|
143 |
|
ROVER |
|
00 00
0000 |
|
utymfNxhYlwKofqEl
|
|
|
|
0 |
|
14 |
|
HYB |
|
MvXwvnTIBboKAmMfuG |
|
|
89 |
|
HONDA |
|
00 00
0000 |
|
UQwTMvtaCKkFyk
|
|
|
|
0 |
|
5 |
|
HYB |
|
KhxMzshcZAI |
|
|
165 |
|
AUDI |
|
00 00
0000 |
|
TwtAVZUsCsXXoLqvjY
|
|
|
|
0 |
|
20 |
|
GO |
|
wMmPPRSHbCHP |
|
|
|
|
