2024.11.24 Sunday Emma
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

infrastructural investments Child protection Recorder Population Document office Mayor's Office mayoral offices Crisis management in government and EU institutions Municipality municipal governments Mayor Vámosgyörk Recorder Vámosgyörk Pest County Government Pest county municipalities Mayor Estate security administration Birth registration Election Referendum Staff functions Offense Defense management Guardianship Social assistance Military nursing Local Government Investment Construction of administrative tasks Assembly Bodajk Municipality Bodajk Recorder Bodajk Mayor Bodajk Administration Bodajk Population register Local Government Investment Bodajk Financial group Bodajk Treasurer Bodajk Taxation Bodajk Municipality Jászapáti Recorder Jászapáti Mayor Jászapáti Estate administration, security Jászapáti Guardianship Jászapáti Child protection Jászapáti Social assistance Jászapáti Construction management tasks Jászapáti Electronic local government Ferencvaros Ministry of Local Government Engineering project supervision Dunakeszi Municipality Dunakeszi Mayor's office Maglód



Babaindex

Detailed search


Got error 28 from storage engine
select c.eredeti_id ceg_id, c.cegnev, c.irsz, c.utca, c.email,c.web, c.tel_korzet, c.tel_szam, c.tel2_korzet, c.tel2_szam, c.fax_korzet, c.fax_szam, c.mobil_korzet, c.mobil_szam, c.fax2_korzet, c.fax2_szam, c.mobil2_korzet, c.mobil2_szam, c.webaruhaz, c.blog, c.kiemelt, c.kulcsszo, c.ajanlatURL, c.web2, c.email2, c.skype, c.logo, v.megnev varos_nev, c.egyk k_id , c.eredeti_id vi_id , p.pozicio from ceg c left join varos v on c.varos_id = v.varos_id left join megye m on v.megye_id = m.megye_id left join k_ceg_cimszo k on c.eredeti_id = k.ceg_id left join cimszo sz on sz.eredeti_id = k.cimszo_id left join pozicio p on p.partner=c.eredeti_id and (0 or p.fogalom like "Local Government Investment Bodajk" ) and now()>=p.tol and now()<=ig where k.cimszo_id=sz.eredeti_id and c.eredeti_id=k.ceg_id and ( sz.eredeti_id = "25440" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150