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

energetics architects and building contractors building maintenance, renovation industrial woodworker, construction industry demolition rendering building observation systems construction engineering industrial pre-moulds, panels building insulation building design electrical wiring Building closures light building structures Building energy Winwatt interface Building within the Pest Control Outside the building insect control Building energy construction of farm buildings Plumbing fittings Building regulations Historic buildings tartószerkezetének Design épületdiagnosztikai tests individual production buildings modular building complex building design Building and automotive products HVAC systems design, construction building management systems Building tinning building design Building demolition work building inspections energy planning Energy survey Energy reconstruction Hafele Building External surface cleaning of buildings Building renovation Building inscriptions Foam letters buildings Bio energetic Bioenergetic therapy Building painting Building Enhancements Energy consulting Subsequent building insulation Building, glazing Bioenergetics Building supervision Indoor spraying Outside the building spray Building cleaning HVAC Trade Tinker architectural Historic building renovation Buildings, structures for the static design and design review Bethesda lab building Building physics expert Renewable energy, energetic course Building Control Building Automation Building and room sound systems HVAC Wholesaler Building protection and recovery system LLumar architectural Energy Certificate Building ceramic Products for buildings Building works Energy certification of buildings Organic produce energy



Home > Detailed search > Building energy
Horn Magyarország

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