2025.10.29 Wednesday Nárcisz
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

Aktual Aluplast Internal joinery larch concrete impregnating Dimex Custom windows and doors demolition Wood and plastic exterior doors Wood doors Wooden doors Wood joinery Wood Aluminum Wood doors Fenstherm KBE Kömmerling Doors and windows Doors and windows installation Replacement of doors and windows Doors and distribution Doors and seals gap fillers Doors and exchanges Doors and outdoor and indoor Optimal Plastmo Old money antiques, fine art Rehau Schindler Thyssen Tryba Veka Wymar Installation of doors and windows breakdown after cleaning Regenerating Cream construction and demolition debris transport REHAU windows and doors REHAU plastic doors and windows fat break-down Archeology breakfast flakes Solvent reclamation Monument-like doors and windows Doors and windows Szentendre Demolition work Building demolition work Novels Auction of old silver Cutting steel construction, demolition Fat burning New fat burning product Regression Without breakdown of insulation Without breakdown Waterproofing Regranuált hose Old artificial stones to improve Buying antiques Cassa Ltd. 5-chamber plastic windows 7-chamber plastic windows Acoustic Glazing Insulating glazing Glass clamp profiles Doors Corner Discharge Gereb got angry because of the attachment Curved, shaped windows and doors manufacturing Custom manufacture of doors and windows Doors and windows on-site survey Old windows and doors broken down Residual fuel oil, gasoline breakdown Ultrasonic fat break-down Cavitation fat break-down Renovation of old insulation Alufa windows



Home > Detailed search > Old windows and doors broken down

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 "Old windows and doors broken down" ) 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 = "32438" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150