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

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 babysitting light building structures Building energy Winwatt interface Lift remote control 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 Remote control systems Building and automotive products HVAC systems design, construction building management systems Building tinning surveillance activities supervision of clinical research building design Building demolition work building inspections Computer data acquisition, monitoring systems and Power Saving Hafele Building External surface cleaning of buildings Building renovation Building inscriptions Foam letters buildings Remote intrusion Building painting Building Enhancements Street / Supervision Debrecen Subsequent building insulation Building, glazing Reservation of remote control Surveillance System 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 Engineering project supervision Bethesda lab building Building physics expert Building Control Building Automation Building and room sound systems HVAC Wholesaler Building protection and recovery system LLumar architectural Building ceramic Products for buildings Building works Buda remote Buda Central Station Alarm Monitoring Energy certification of buildings GSM remote monitoring system Vehicle Monitoring Station Wireless remote monitoring and alarm Wireless and remote behetolásjelző 24-hour monitoring service Backup monitoring Automotive Services Wireless remote control Vehicle Monitoring Station Fire Monitoring Station Socialization remote



Home > Detailed search > Building supervision

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