SELECT g.ville as nom_ville,a.*,b.*,c.*,d.*,e.*,g.*,h.*,f.*,emp.* from
offre a,prm_type_poste b,prm_experience c,prm_niv_formation d,prm_fonctions e,prm_villes g,prm_salaires h,prm_sectors f,
employeurs emp
where a.id_tpost = b.id_tpost and a.id_expe = c.id_expe and a.id_nfor = d.id_nfor
and a.id_fonc = e.id_fonc and a.id_localisation = g.id_vill and a.id_salr = h.id_salr and f.id_sect = a.id_sect
and emp.id_emp = a.id_entreprise and a.status like '2'
order by date_insertion desc LIMIT 0,5