SELECT DISTINCT i.id_item, i.id_type, d_reference.value AS reference, d_nb_portes.value AS nb_portes, d_annee.value AS annee, d_energie.value AS energie, d_nb_km.value AS nb_km, d_collection.value AS collection, d_selected.value AS selected, dt_intitule.value AS intitule, dt_presentation.value AS presentation, dt_couleur.value AS couleur
 FROM items AS i
INNER JOIN data AS d_reference ON i.id_item=d_reference.id_item
INNER JOIN data AS d_nb_portes ON i.id_item=d_nb_portes.id_item
INNER JOIN data AS d_annee ON i.id_item=d_annee.id_item
INNER JOIN data AS d_energie ON i.id_item=d_energie.id_item
INNER JOIN data AS d_nb_km ON i.id_item=d_nb_km.id_item
INNER JOIN data AS d_collection ON i.id_item=d_collection.id_item
INNER JOIN data AS d_selected ON i.id_item=d_selected.id_item
INNER JOIN data_translate AS dt_intitule ON i.id_item=dt_intitule.id_item
INNER JOIN data_translate AS dt_presentation ON i.id_item=dt_presentation.id_item
INNER JOIN data_translate AS dt_couleur ON i.id_item=dt_couleur.id_item
 WHERE d_reference.data='reference' AND d_nb_portes.data='nb_portes' AND d_annee.data='annee' AND d_energie.data='energie' AND d_nb_km.data='nb_km' AND d_collection.data='collection' AND d_selected.data='selected' AND dt_intitule.data='intitule' AND dt_presentation.data='presentation' AND dt_couleur.data='couleur' AND dt_intitule.lang='fr' AND dt_presentation.lang='fr' AND dt_couleur.lang='fr'


 AND () ORDER BY intitule