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

Front door manufacturing Door manufacturing asphalt manufacture, asphalting car manufacture Automobile repair equipment car washes car alarms Tinker Production Elements Internal joinery larch Furniture furniture production, trade Crane production electronic goods and spares, servicing Food processing equipment manufacturing construction machinery power plants Wood interior door manufacturing Wood joinery milking machines and apparatus Male children sweater manufacturing paint/emulsion-, glaze- and varnish manufacture painting/dyeing appliances film and video production and distribution hairdressers' supplies plywood production heating appliances bathroom accessories electroplating instruments and appliances garages and garage fittings machinery manufacture mechanical devices, tools engineering industry, mechanical engineering car and commercial vehicle washes Steam and infrared products Pharmaceutical manufacturing Pharmaceutical packaging materials Welding Review Welding products Welding trade Welding production Hygiene equipment fridges Import welding Manufacture of infrared signal systems switch mechanisms swithboards Production of gates Boiler manufacture Boiler room equipment picture- and photo framing gardening tools, appliances air conditioning Combi sauna production skips, skip transport Kitchen Equipment kitchen appliances and furniture analogue switches air conditioning Magnet production Balance Sheet Production gauging instruments projectors and movie theatre services instrument and apparatus manufacture museum, exhibition furniture billboard printing, manufacturing Medical instruments, apparatuses classification systems parking meters porcelain manufacture and distribution manufacturing of advertising instruments alarms explosion-proof appliances Their own production of welding equipment Sporting goods manufacturing baking- and confectionery machinery, appliances conveyor belts, machinery hotel furnishings, textiles Manufacture of saunas ventilators Lens manufacture Tool production tool manufacture pumps and pump systems Filtering cleaning appliances, machinery brick manufacture and distribution television- and radio manufacture, distribution shaft coupling pasta making, trade aluminium oxide production cleaning appliances, machinery fire safety equipment Fire-fighting equipment steel- and iron foundry chemical industry apparatus catering appliances electrical goods electrical swithes water industry appliances plant machinery and fittings irrigation systems appliances Workware Maintenance of fire alarm equipment Production of special lenses Upholstered furniture Office equipment Manufacture of electrical control Metal construction services Cosmetics gate devices Solar Production camshaft production SAIA PCD equipment Microswitch plasma installations Safety equipment Tinware products and essay Production Tool tabs feed production Parts Production Production for hotels furniture needs of individual carpentry factory Manufacture of Custom Products concrete production Concrete production film equipment valuations computer equipment valuations contactors Domestic water supply equipment Air Conditioning Cleaning Air Conditioning Maintenance Air-conditioning filter replacement Air Conditioning Duct Cleaning Rendering equipment assembly of electronic and precision equipment individual production buildings Production of mobile roof LKE conveyor equipment Medical device manufacturing X-ray Human X-ray Veterinary X-ray Packaging machinery and equipment Production of promotional materials Invitations Production hydraulic equipment lifts Picture and sound equipment installation Picture and sound equipment Hotel facilities Manufacture of instruments covers preform manufacturing kupakgyártás electronic signature verification services unsolicited electronic ads related to official control Custom Built lifts Scotch tape breaking equipment Manufacture of metal shutters műsorgyártás and video Electrical equipment manufacturing Custom Built Lifts conveyor belt production transmission manufacturing Foot Switches Crane switches Industry microswitches Joinery factory production aeration equipment áramláskeltő equipment pumping trademark administration designs shop High voltage switchgear and transformer design High voltage switchgear and transformer installation High voltage switchgear and transformer installation Switchgear manufacture Switching equipment Irrigation equipment faforgácsoló production tools Manufacture of pneumatic tools Manufacture of assembly tools Manufacture of pneumatic components compressor parts manufacturing Lincoln Electric welding equipment Production of gas-shielded Torches shrink production CD Production VHS production Videotape production Production of video cassettes Waste management facilities Industrial switches Gyógyháttámasz Production Dust filter equipment Ventilation equipment Scrubbers Pneumatic conveyors Mobile oil separation equipment Klaus parking PCB production PCB production One-sided printed circuit board manufacturing Double-sided printed circuit board manufacturing Production strings Strings of production and distribution String plucked strings production Violin strings production Viola strings production Cello strings production Double bass strings production Classical guitar making Electric guitar making Acoustic guitar making Medical Equipment Catalog Couplings Industrial couplings Individual profiles Design and construction dust filter deposits Filter production Limit Switches Manufacture of fire-fighting signs PCB production PCB production PSB production Mucus production sheets Production of PCBs pages Printed circuit board manufacturing Hole plated PCB Production Power-protect switch meters High voltage electrical equipment design Low voltage electrical equipment design Repair video MODELS Production Filling equipment Bystronic laser cutting systems Bystronic water jet cutting systems Relationships Mediation Cooler and equipment nec Industrial refrigeration equipment manufacturing Gas welding equipment repair Flame welding equipment, safety review Manufacture of medium Manufacture of workwear Calibration equipment Computer mucus production Plastic bag manufacturing Switching solutions Switching and control Production of reinforced concrete structures Sportswear Manufacture Footwear Production Manufacture of other outerwear Chemical equipment Relationship Washing Equipment Pumping stations Water recovery equipment EDM equipment into service, EDM Equipment Manufacture EDM Equipment Development EDM Equipment Distribution EDM equipment warranty MP modular EDM Equipment ZNC EDM equipment for bulk CNC EDM equipment for bulk CNC wire EDM Equipment EDM Equipment Construction Equipment Plastic Film production Disposable, single-use products Asphalt and concrete mixing equipment Vehicle washing equipment Intercom systems manufacturing Legrand switches PRODAX switches Bottles, jars Production Hotels, restaurants, furniture Electronic component manufacturing Custom-made products CE marked Production of iron castings Border heating system of production EDM machines Curved, shaped windows and doors manufacturing Custom manufacture of doors and windows Automatic power factor correction equipment Distribution of production and renovation HEKA static equipments Production of mail boxes Manufacture of paper packaging materials Production of corrugated board Switchable shelving racks Material handling equipment, paternoster Kitchen Equipment Operating room equipment Laser design, construction, integration Manufacture of individual packaging Insulating glass production Design of fire protection equipment Firefighting equipment Sprinkler systems Water mist extinguishing systems Irradiation equipment Profile rolling production Narrow strip, cut Contacts with foreign partners Ribbon Manufacturing Compensator springs, dampers Production Ljungström refurbishment, heat exchanger elements of production Plastic products Production of polyethylene bags, Sülysáp Production of retreaded truck tires 0.4 kV switch Production of polyethylene plastic bags Metal components Manufacture of plastic injection molded parts Design and manufacture of plastic injection molds Asphalt and concrete production, recycling Glass manufacturing Hydraulic equipment refurbishment and repair Machine design, manufacturing TORO irrigation installation, maintenance and servicing Credit issues notarial activities Pressure Switch Pressure Switch budapest Pressure Switches Powder dosing equipment Filtering and circulation devices Sand filters Equipment Beam filter Water heating equipment Chemical Equipment Steel constructions Elevator manufacturing Passenger car production Production of car hoist Manufacture of office and living containers Manufacture of lift shafts Elevator manufacturing Chimney liner production Production of aluminum fröccsszerszám Metal injection molding tool production Manufacture of blow molding Production of cold crimping tool Manufacture of cutting tools, drawing Manufacture of plastic tool förccsöntő 3D mold Manufacture of production runs Furniture production front Privacy planning, preparation, Telephone Calling Elevators, escalators and stage equipment Identification Equipment DC-controlled antenna switch Workshop equipment Storage Devices Data protection equipment Glass bottle manufacturing Switch Wires Locker Room Equipment Swimming pools, water treatment equipment Silicone products Zila wholesale clothing contact



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