0.0008 |
SELECT * FROM (`marque`) ORDER BY `marque` ASC
|
0.0003 |
SELECT MIN(`prix`) AS prix FROM (`vehicule`) WHERE `prix` > 0
|
0.0003 |
SELECT MAX(`prix`) AS prix FROM (`vehicule`) WHERE `prix` > 0
|
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` = '4' 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` = '5' 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` = '6' 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` = '7' 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` = '3' 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` = '8' 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` = '9' GROUP BY `modele`.`id_modele` ORDER BY `marque`, `modele`
|
0.0009 |
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.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` = '33' GROUP BY `modele`.`id_modele` ORDER BY `marque`, `modele`
|
0.0009 |
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.0009 |
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.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` = '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.0009 |
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.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` = '13' GROUP BY `modele`.`id_modele` ORDER BY `marque`, `modele`
|
0.0009 |
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.0009 |
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.0009 |
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.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` = '16' 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` = '17' 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` = '18' 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` = '19' 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` = '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.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` = '21' GROUP BY `modele`.`id_modele` ORDER BY `marque`, `modele`
|
0.0082 |
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.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` = '22' GROUP BY `modele`.`id_modele` ORDER BY `marque`, `modele`
|
0.0026 |
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.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` = '23' 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` = '35' GROUP BY `modele`.`id_modele` ORDER BY `marque`, `modele`
|
0.0025 |
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.0021 |
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.0021 |
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.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` IS NULL
|
0.0003 |
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.0001 |
SELECT * FROM (`marque`) WHERE `id_marque` = '12'
|
0.0001 |
SELECT * FROM (`marque`) WHERE `id_marque` = '12'
|
0.0001 |
SELECT * FROM (`marque`) WHERE `id_marque` = '12'
|
0.0002 |
SELECT * FROM (`cms__page`) WHERE `id_page` = 6
|
0.0001 |
SELECT * FROM (`cms__page`) WHERE `id_page` = 7
|
0.0003 |
SELECT * FROM (`type`) WHERE `id_type` IS NULL
|
0.0075 |
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.0028 |
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`
|