| 0.0062 |
SELECT *
FROM (`marque`)
ORDER BY `marque` ASC
|
| 0.0004 |
SELECT MIN(`prix`) AS prix
FROM (`vehicule`)
WHERE `prix` > 0
|
| 0.0002 |
SELECT MAX(`prix`) AS prix
FROM (`vehicule`)
WHERE `prix` > 0
|
| 0.0014 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '4'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0015 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '5'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0014 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '6'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0011 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '7'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0019 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '3'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0017 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '8'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0012 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '9'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0012 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '10'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0014 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '33'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0011 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '30'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0014 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '11'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0020 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '12'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0011 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '32'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0012 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '28'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0013 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '13'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0010 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '14'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0014 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '15'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0011 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '34'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0010 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '29'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0012 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '31'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0013 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '16'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0011 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '17'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0016 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '18'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0012 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '19'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0012 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '20'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0016 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '1'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0013 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '21'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0057 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '2'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0018 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '22'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0011 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '27'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0011 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '23'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0013 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '35'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0014 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '24'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0012 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '25'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0017 |
SELECT `modele`.*, `modele`.`id_modele` as id_modele, `marque`.`marque` as libelle_marque, `carrosserie`.`carrosserie` as libelle_carrosserie, `genre`.`genre` as libelle_genre, MIN(vehicule.prix) as prix_min, MIN(vehicule.prix_marchand) as prix_marchand_min, COUNT(vehicule.id_vehicule) as nb_vehi
FROM (`modele`)
LEFT OUTER JOIN `marque` ON `modele`.`rid_marque` = `marque`.`id_marque`
LEFT OUTER JOIN `carrosserie` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
LEFT OUTER JOIN `genre` ON `modele`.`code_genre` = `genre`.`code_genre`
JOIN `vehicule` ON `modele`.`id_modele` = `vehicule`.`rid_modele`
WHERE `prix` <> 0
AND `vehicule`.`km` < 200
AND `vehicule`.`immat` !=""
AND `modele`.`rid_marque` = '26'
GROUP BY `modele`.`id_modele`
ORDER BY `marque`, `modele`
|
| 0.0004 |
SELECT concession.*
FROM (`concession`)
WHERE `active` = 1
ORDER BY `ordre`
|
| 0.0003 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` IS NULL
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `slug` IS NULL
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '8'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '2'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '12'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '12'
|
| 0.0002 |
SELECT *
FROM (`marque`)
WHERE `id_marque` = '12'
|
| 0.0003 |
SELECT *
FROM (`cms__page`)
WHERE `id_page` = 6
|
| 0.0002 |
SELECT *
FROM (`cms__page`)
WHERE `id_page` = 7
|
| 0.0001 |
SELECT *
FROM (`type`)
WHERE `id_type` IS NULL
|
| 0.0059 |
SELECT *
FROM (`carrosserie`)
JOIN `modele` ON `modele`.`rid_carrosserie` = `carrosserie`.`id_carrosserie`
JOIN `vehicule` ON `vehicule`.`rid_modele` = `modele`.`id_modele`
WHERE `vehicule`.`km` <= 200
AND `prix` <> 0
AND `afficher` = 1
GROUP BY `carrosserie`.`id_carrosserie`
ORDER BY `carrosserie`
|
| 0.0025 |
SELECT *
FROM (`marque`)
JOIN `vehicule` ON `vehicule`.`rid_marque` = `marque`.`id_marque`
WHERE `vehicule`.`km` <= 200
AND `prix` <> 0
GROUP BY `marque`.`id_marque`
ORDER BY `ordre`
|
