1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SELECT
DT.ID,
DT.Titre,
DT.Prix,
DT.Contact,
DT.Description,
DT.Region,
DT.Ville,
DT.CodePostal,
k.valeur AS `Kilométrage`,
c.valeur AS `Carburant`,
b.valeur AS `Boîte_Vitesse`,
a.valeur AS `Annee_modele`
FROM
annonces DT
INNER JOIN details k ON DT.ID = k.ID_Annonce AND k.rubrique = 'Kilométrage'
INNER JOIN details c ON DT.ID = c.ID_Annonce AND c.rubrique = 'Carburant'
INNER JOIN details b ON DT.ID = b.ID_Annonce AND b.rubrique = 'Boîte de vitesse'
INNER JOIN details a ON DT.ID = a.ID_Annonce AND a.rubrique = 'Année-modèle'
WHERE
DT.Categorie LIKE '%voiture%'
AND (DT.`Export` = '0')
AND (DT.`Contact` <> '')
AND (char_length(DT.`Contact`) = 10) |