GoBack

Oferte

Home
Nu sunt locuri de munca vacante pentru codul cor 263102
[SELECT a.cf,ifnull(a.agent,l.agent) as agent,a.judet,a.caen,a.regcom,a.forma,a.pf,a.localitate, Concat("Str.",ifnull(a.str,l.str),", nr.",ifnull(a.nr,ifnull(l.nr,"-")),", ap.",ifnull(a.ap,l.ap)) as aadresa,ifnull(a.tel,l.tel) as tel,a.fax,ifnull(a.nr_angajati,l.nr_angajati) as nr_angajati,a.reprezentant,ifnull(a.pcontact,l.pcontact) as pcontact,ifnull(a.pc_tel,l.pc_tel)as pc_tel,ifnull(a.pc_email,l.pc_email)as pc_email, l.idweb,l.nrcrt,l.ocupatia,l.idcor,l.nr_loc,l.loc_create,l.loc_creditate,l.loc_disponibilizare,l.val_ue,l.vechime,l.idstudii,l.alte_cond,l.profil,l.tip_norma,l.nat_ctrl,l.luni_per_det,l.ore_zi,l.cond_soc,l.sex,l.data_lim,l.mod_sol,l.idschimb,l.cond_munca,l.idjudet,l.localitate as loc,l.adresa,l.gr_tinta,l.idcalificare,l.timp as timpl FROM lmv_imp l left join agenti a on l.cf=a.cf WHERE l.idcor = 263102 and l.data_lim>'2014-10-22' and l.idjudet=06 and l.nr_loc>0 order by a.agent,l.data_lim]