SELECT 
`propriete`.`propriete`
, `cout`.`prix` 
, `cout`.`coeff` , (`cout`.`prix` * `cout`.`coeff`) AS total
, cout.type as cout_type
, societe_composant_desordre.id_societe_composant 
, societe_composant_desordre.niveau 	
, societe_composant_desordre.pourcent
, societe_composant_desordre.travaux
, `propriete`.`desordre` 
FROM 
cout
INNER JOIN propriete ON propriete.id_propriete = cout.id_propriete
INNER JOIN societe_composant ON (cout.`id_societe` = societe_composant.`id_societe` AND propriete.id_composant=societe_composant.id_composant)
LEFT JOIN societe_composant_desordre ON societe_composant_desordre.`id_societe_composant` = societe_composant.`id_societe_composant`
WHERE cout.`id_societe` =3516