SELECT c.idp, c.id, c.nom, c.prenom, c.address, c.cp, c.ville, c.tel,c.telpro, c.mobile, c.fax, c.email, c.url, c.poste as postedet, c.poste_desc, c.region as regiondet, c.fk_duree as dureeid, c.cduree, c.dureetp, c.secteur, unix_timestamp(c.datea) as dateac, c.divers, c.anon, c.active, c.moderech, c.salaire, c.sfuser, c.savannah_username, c.gna_username, c.reponsenet, c.advogato_username, c.site, c.ohloh , c_pays.libelle as pays, c.fk_pays as paysid , c_contrat.libelle as contratc, c.fk_contrat as contratid , c_duree.libelle as dureec, c.fk_duree as dureeid , m.libelle as modecontact, m.id as mid FROM candidat as c, c_pays, c_contrat, c_modecontact as m, c_duree WHERE c.idp=323 AND c.fk_contrat=c_contrat.id AND c.fk_pays=c_pays.id AND c.fk_duree=c_duree.id AND c.fk_modecontact = m.id