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

Cremation Piety Piety Funeral service Reverence 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 service Burial Gyömrő Funeral Gyömrő Funeral service Gyömrő Burial organization Burial Pest county Funeral service Pest county 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 Periodic review of medical devices Parish 11.kerületi parish Budapest, Szent Gellért Kelenföld parish Periodic review of fire fighting equipment and maintenance Undertaker Funeral Service Lift periodic testing



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 "Temporary grave care" ) 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 = "28764" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150