SELECT 
b.num, 
b.vignette, 
b.type_bien, 
b.departement, 
b.agent, 
b.origine, 
b.surface_batiment, 
b.surface_terrain, 
b.lieu 
FROM bien b 
WHERE b.num = 

SELECT 
d.num, 
d.code, 
d.nom, 
d.location, 
d.vente 
FROM departement d 
WHERE d.num = 

SELECT 
t.langue, 
t.bien, 
t.resume, 
t.description 
FROM trad_bien t 
WHERE t.langue = 1 
AND   t.bien = 

SELECT 
t.langue, 
t.vignette, 
t.nom, 
t.chemin 
FROM trad_vignette t 
WHERE t.langue = 1 
AND   t.vignette =