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

Wine museum Cremation Piety Piety Funeral service Reverence museum, exhibition furniture museums Funeral Tomb Tomb preparation Memorials Latina making Tombstone headstones Burial Funeral Funeral service funerals Funeral Funeral agencies Funeral service Cemetery Cemetery Cemeteries Cemetery Operations Urn Urn placement Urns Funeral Budapest Budapest Cemeteries Cemeteries in Budapest Funeral savings Urn cemeteries Funeral services Funeral Museum Csömöri graveyard Kerepesi Cemetery New cemetery Farkasrét cemetery Óbuda cemetery Rákospalotai cemetery Megyeri cemetery Pestszenterzsebet cemetery Pestszentlőrinci cemetery Kispest cemetery Cinkotai cemetery Csepel cemetery Budafok cemetery Angeli travel urn cemetery Thomas Street urn cemetery Funeral Békéscsaba Tomb making Békéscsaba Burial Aszód Funeral Aszód funeral service Aszód Funeral preparations Funeral service Burial Gyömrő Funeral Products Funeral Gyömrő Funeral service Gyömrő Burial organization Burial Pest county Funeral service Pest county Design Museum Funeral service orders Funeral ceremony Funeral Supplies Ashes Danube deviation Broadcast funeral Repatriations International repatriations dead domestic Ad hoc grave decoration Permanent grave care Temporary grave care Szentendre Funeral Bureau Pomázi Funeral Bureau Budakalászi Funeral Bureau Funeral Iklad Funeral Domony Funeral Gyöngyöspata Burial Iklad Burial Domony Burial Gyöngyöspata Hungarian National Museum Project Plexiglas museum storage Museum Storage Museum Storage Parish 11.kerületi parish Budapest, Szent Gellért Kelenföld parish Undertaker Funeral Service Funeral items



Céginformáció

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 "Funeral Museum" ) 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 = "20409" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150