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

electrical elements building maintenance, renovation electrical wiring vehicle electrics servicing, repair maintenance Boiler Operation Boiler Operation Pump Maintenance cleaning and maintanence services Cemetery Operations road constuction, maintenance and management city operation electrical goods power grids electrical swithes electrical insulation materials electrical network building, fitting electrical goods, appliances electrical motors electrical goods retailers electrical fiting and maintenance materials Operation of elevators Maintenance of lifts Maintenance of fire alarm equipment Electrical controls Manufacture of electrical control Electricity Act Explosion-proof electric heater Electricity distributors Electricity distribution Coffee machines operation Air Conditioning Maintenance Maintenance of air conditioning cabinets electrical articles and electrical assembly strip maintenance elevator installation, maintenance Lift Maintenance Maintenance contract electrical installation electricity networks Elevator maintenance Operation of street lighting operation of vending machines Electrical equipment manufacturing Electrical measurements hálózatanalizáció Nursery operation And small electrical wholesale Electric Operation and Maintenance electrical trades textbooks reconstruction, electricity Car electricity Budapest Software Management Consultancy Digital Map Database maintenance Electric power generation Electrical door contacts CNC machine tool maintenance Computer Maintenance Low voltage operation of complex IT systems Weak maintenance of complex IT systems High voltage electrical equipment design Low voltage electrical equipment design Electric maintenance Monitoring System Maintenance Electrical Shop 11th Electrical Store district 11th Electrical Specialists district Maintenance of gas sensors Rainfall operating systems Legrand electrical fittings Safe operation of lifting Lifting operation Industrial Facilities Maintenance Electrical network and station training Electrical network assembly Electricity cost savings Electrical measurements Measuring the quality of electricity Electricity metering Coffee-machine operation Elevator maintenance Elevator maintenance Maintenance of roof insulations Maintenance and repair of injection molds TORO irrigation installation, maintenance and servicing Periodic review of fire fighting equipment and maintenance Maintenance of fire-water pools Electrical Insulating Gloves Fire extinguisher monitoring, maintenance Residential elevator maintenance Maintenance Lifts Elevator maintenance Residential elevator operation Lift Truck Maintenance



Közterületimédia

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 "Electric Operation and Maintenance" ) 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 = "26687" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150