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

Steel industry Front door manufacturing Door manufacturing asphalt manufacture, asphalting car manufacture Tinker Production Elements poultry industry Internal joinery larch Organic Bakery Products Bio-grain products leather industry Furniture furniture production, trade furniture manufacturing industry shoe indutry, shoe accessories Packaging sugar industry Crane production tobacco industry confectionery industry, confectionery products food industry Food machine food industry machinery Food processing equipment manufacturing Food refrigeration building material suppliers construction industry infrastructural investments building contractors, services construction machinery building contractors, services construction design and management industrial woodworker, construction industry Wood interior door manufacturing Wood joinery timber industry timber industry machinery metal mass consumables industry Male children sweater manufacturing paint/emulsion-, glaze- and varnish manufacture paint/dye industry film and video production and distribution precision industrial ceramics spinning/plaiting industry chip- and plywood production plywood production heating services, domestic and industrial milling industry garages and garage fittings gas production industry, gas products, gas supply Geodetic and construction equipment machinery manufacture engineering industry, mechanical engineering Steam and infrared products rubber industry Pharmaceutical manufacturing pharmaceutical industry Pharmaceutical packaging materials Pharmaceutical Machinery Welding products Welding production meat industry meat industry machinery fridges cooling industry Manufacture of infrared industial goods industrial mechanisation industrial construction Industrial paint Industrial paint, industrial paints Industry risks industrial firms industrial parks industrial cleaning technology Intellectual property applied arts motor industry trade unions Production of gates Boiler manufacture picture- and photo framing applied arts cottage industry Combi sauna production ready-made-clothes trade knitting industry Magnet production milling industry Frozen bakery products Balance Sheet Production Plastics, plastics machinery technical items, goods instrument and apparatus manufacture engineering industry billboard printing, manufacturing printing industry printers' materials Printing material Printing Products plant oil industry oil industry paper industry porcelain manufacture and distribution manufacturing of advertising instruments (fashion) clothing industry Their own production of welding equipment Sporting goods manufacturing baking- and confectionery machinery, appliances bakery industry Bakery equipment technical services Manufacture of saunas Lens manufacture Tool production tool manufacture leisure complexes, entertainment industry fur industry weaving trade beer industry, breweries food processing industry brick manufacture and distribution dairy industry television- and radio manufacture, distribution pasta making, trade the textile industry aluminium oxide production steel- and iron foundry steel- and metal industry miscallenous goods chemical industry chemical industry apparatus catering industry catering appliances electrical goods, appliances Workware Industrial Property advice Production of special lenses Upholstered furniture Food processors Manufacture of electrical control Metal construction services Glass designer designer Cosmetics Industrial flooring Solar Production camshaft production Printing services Examination of oil products Analytical studies of petroleum industry products instrument drive for industrial use Industrial gases Tinware products and essay Use chemical pump Production Tool tabs feed production industrial grain powder Industry silvering Used construction equipment Parts Production Production for hotels furniture needs of individual carpentry factory Food additives Manufacture of Custom Products Construction activity Food thermometers Pharmaceutical thermometers Food industry equipment concrete production Concrete production Commercial Real Estate film IT Industry Industrial pumps acid proof industrial floors Mechanical Engineering szimering individual production buildings Production of mobile roof industrial halls Wood works Medical device manufacturing Building and automotive products Industrial Chargers Production of promotional materials Invitations Production Industrial Plastic Working Industrial Lasers Industrial Paint Szeged Industrial coatings Szeged commercial real estate leasing Tinware Steeplejack Manufacture of instruments covers preform manufacturing kupakgyártás distribution of industrial seals Industrial Generators Industrial cleaning Food industry cleaning industrial olajszivattyúk Custom Built lifts Manufacture of metal shutters műsorgyártás and video Electrical equipment manufacturing Industrial soda machine placement Custom Built Lifts conveyor belt production transmission manufacturing siding Pályatervezési Industry microswitches Industrial floor design Industrial refrigeration Catering Construction Lasers Joinery factory production Catering equipment hire industrial wastewater Construction machinery leasing Professional work gyorskapuk food plants gyorskapuk special chemical environment environment of rapid industrial doors Industrial products Switchgear manufacture Switching equipment faforgácsoló production tools Manufacture of pneumatic tools Manufacture of assembly tools Manufacture of pneumatic components compressor parts manufacturing Multiparking Production of gas-shielded Torches shrink production Precision turning buttons CD Production VHS production Videotape production Production of video cassettes Industrial flooring Industrial sockets Industrial switches Gyógyháttámasz Production Industrial Waste Receiving Industrial PVC curtains Industrial PVC curtains Industrial PVC curtains Industrial PVC curtains Industrial thermal insulation curtain Thermal insulation of industrial curtains PVC Industrial Strip PVC industrial strip Pharmaceutical Training 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 Industrial dust separation Industrial couplings Industrial Brakes Individual profiles Design and construction dust filter deposits Industrial liquid Industrial filter Filter production 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 Light industrial space bar Industrial sealing Industrial insulation MODELS Production Industrial floor Cooler and equipment nec Industrial refrigeration equipment manufacturing Refrigerated dryers, renovation Plastic machinery cooling Gas welding equipment repair Pressure to improve medical Flame welding equipment, safety review Manufacture of medium Manufacture of workwear Computer mucus production Catering School Foundation School Catering Tourism professional training Industrial plastic recycling Plastic bag manufacturing Food hose Industrial hose Industrial mixing Confectionery Production of reinforced concrete structures Industrial Vacuum Cleaners Industrial sewing machine needles Food industry workwear Development and commercial real estate Industrial Plastics Industrial scales Sportswear Manufacture Footwear Production Manufacture of other outerwear Textile stamping foils Textile stamping foils Locksmith Industrial fans Bakery products Wholesale Bakery Products Chemical equipment Woodworking machines to improve Woodworking Machinery Trade Woodworking machines for sale Used woodworking machinery Woodworking machinery repair service Woodworking Machinery Renewal Material Industry EDM Equipment Manufacture Construction Tools Construction Equipment Construction machines Industrial glasses Plastic Film production Disposable, single-use products Industrial property services and advice Intercom systems manufacturing Food technical school Construction machinery leasing and rental Household chemical jars Bottles, jars Production Electronic component manufacturing Custom-made products CE marked Production of iron castings Automotive Castings Border heating system of production EDM machines Curved, shaped windows and doors manufacturing Custom manufacture of doors and windows Industry alpine jobs Industrial Facilities Maintenance Planers and saw industrial adjustment and sharpening Three-phase industrial motors Industrial ethernet switch Distribution of production and renovation Production of mail boxes Manufacture of paper packaging materials Production of corrugated board Tradables Shop Leica Construction Lasers Admixtures industrial flooring Construction of industrial floor Repair industry and construction Industrial piping Poured industrial floor coatings Industrial facilities Earthworks Industrial plants, factories security fence construction Industrial and domestic sewing machines Industrial Sewing Machine Shoe Machine darner Industrial halls, air-conditioning Manufacture of individual packaging Skilled mechanic gypsum Industrial bonding Insulating glass production Profile rolling production Narrow strip, cut Construction machinery trade Construction bérgépek TEREX-FUCHS Industrial boom lifts Industrial boilers to improve Ribbon Manufacturing Industrial fan, container Compensator springs, dampers Production Ljungström refurbishment, heat exchanger elements of production Plastic products Production of polyethylene bags, Sülysáp Preparation of resin flooring industry Production of retreaded truck tires Industrial oils Production of polyethylene plastic bags Metal components Manufacture of plastic injection molded parts Industrial Estates Design and manufacture of plastic injection molds Asphalt and concrete production, recycling Glass manufacturing Machine design, manufacturing Lacquer furniture industry Industrial park Viacolorozás, outdoor enclosures, parking lot construction Beauty industry insurance Cognex DVT machine vision Tente wheels and industrial rollers Industrial yarn Steel constructions Elevator manufacturing Passenger car production Production of car hoist Manufacture of office and living containers Manufacture of lift shafts Elevator manufacturing Industrial gate 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 Injection molding for the automotive industry Manufacture of production runs Furniture production front Materials for the furniture industry Fittings for furniture Construction Racks Construction Quality Control Construction inspection Industrial rope access technical protection devices Industrial Hoses Glass bottle manufacturing Industrial Water Treatment Silicone products Construction Transport Industrial Property Litigation Industrial adhesives Acid-resistant industrial floors Glass Industry Raw materials for glass industry Glass thermocouple accessories



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