mysql> EXPLAIN SELECT  `ModeleVehicule`.`IdModel` ,  `LanguageDescriptions`.`Description`
    -> FROM  `ModeleVehicule` ,  `LanguageDescriptions` ,  `TypeVehicule` ,  `ProduitVehicule` ,  `Produits`
    -> WHERE  `ModeleVehicule`.`ManufacturerID` =121
    -> AND  `ModeleVehicule`.`CodeDesignation` =  `LanguageDescriptions`.`CodeDesignation`
    -> AND  `ModeleVehicule`.`IdModel` =  `TypeVehicule`.`VehicleModelId`
    -> AND  `ProduitVehicule`.`IdVehicle` =  `TypeVehicule`.`IdVehicle`
    -> AND  `Produits`.`CategorieId` =13
    -> AND  `Produits`.`ProduitId` =  `ProduitVehicule`.`ProduitId`
    -> GROUP BY  `ModeleVehicule`.`IdModel`
    -> ;


+----+-------------+----------------------+------+------------------------------------------------+-----------------+---------+------------------------------------------+------+----------------------------------------------+
| id | select_type | TABLE                | TYPE | possible_keys                                  | KEY             | key_len | REF                                      | ROWS | Extra                                        |
+----+-------------+----------------------+------+------------------------------------------------+-----------------+---------+------------------------------------------+------+----------------------------------------------+
|  1 | SIMPLE      | ModeleVehicule       | REF  | PRIMARY,IdModel,ManufacturerID,CodeDesignation | ManufacturerID  | 4       | const                                    |   93 | USING WHERE; USING TEMPORARY; USING filesort |
|  1 | SIMPLE      | LanguageDescriptions | REF  | PRIMARY,CodeDesignation                        | CodeDesignation | 4       | totalshop.ModeleVehicule.CodeDesignation |    1 |                                              |
|  1 | SIMPLE      | TypeVehicule         | REF  | PRIMARY,VehicleModelId,IdVehicle               | VehicleModelId  | 4       | totalshop.ModeleVehicule.IdModel         |    6 |                                              |
|  1 | SIMPLE      | ProduitVehicule      | REF  | PRIMARY,IdVehicle,ProduitId                    | IdVehicle       | 4       | totalshop.TypeVehicule.IdVehicle         |  545 |                                              |
|  1 | SIMPLE      | Produits             | REF  | PRIMARY,ProduitId,CategorieId                  | ProduitId       | 68      | totalshop.ProduitVehicule.ProduitId      |    1 | USING WHERE                                  |
+----+-------------+----------------------+------+------------------------------------------------+-----------------+---------+------------------------------------------+------+----------------------------------------------+
5 ROWS IN SET (0.00 sec)