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 poultry industry Organic Bakery Products Bio-grain products leather industry furniture manufacturing industry shoe indutry, shoe accessories Packaging sugar industry 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 timber industry timber industry machinery metal mass consumables industry paint/dye industry precision industrial ceramics spinning/plaiting industry chip- and plywood production heating services, domestic and industrial earth moving equipment milling industry garages and garage fittings gas production industry, gas products, gas supply Geodetic and construction equipment engineering industry, mechanical engineering rubber industry pharmaceutical industry Pharmaceutical packaging materials Pharmaceutical Machinery meat industry meat industry machinery cooling industry 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 applied arts cottage industry ready-made-clothes trade knitting industry milling industry Frozen bakery products Plastics, plastics machinery technical items, goods engineering industry printing industry printers' materials Printing material Printing Products plant oil industry oil industry paper industry (fashion) clothing industry Sports facilities baking- and confectionery machinery, appliances bakery industry Bakery equipment technical services leisure complexes, entertainment industry fur industry weaving trade beer industry, breweries food processing industry dairy industry the textile industry steel- and metal industry miscallenous goods chemical industry chemical industry apparatus catering industry catering appliances electrical goods, appliances Industrial Property advice Food processors Glass designer designer Industrial flooring Printing services Examination of oil products Analytical studies of petroleum industry products instrument drive for industrial use earth hand Industrial gases Tinware products and essay Use chemical pump industrial grain powder Industry silvering Used construction equipment Woody plants Woody plants construction Food additives Construction activity Food thermometers Pharmaceutical thermometers Food industry equipment Commercial Real Estate IT Industry Industrial pumps acid proof industrial floors Mechanical Engineering szimering industrial halls Wood works Building and automotive products Industrial Chargers Industrial Plastic Working Industrial Lasers Industrial Paint Szeged Industrial coatings Szeged commercial real estate leasing Tinware Steeplejack distribution of industrial seals Industrial Generators Industrial cleaning Food industry cleaning industrial olajszivattyúk Industrial soda machine placement siding Pályatervezési Industry microswitches Industrial floor design Industrial refrigeration Catering Construction Lasers Catering equipment hire industrial wastewater Construction machinery leasing Professional work Examination Facilities gyorskapuk food plants gyorskapuk special chemical environment environment of rapid industrial doors Industrial products Multiparking Precision turning buttons Industrial flooring Industrial sockets Industrial switches Industrial Waste Receiving Water treatment plant's design 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 Industrial dust separation Industrial couplings Industrial Brakes Industrial liquid Industrial filter Light industrial space bar Industrial sealing Industrial insulation Industrial floor Installation of earth-moving tires Industrial refrigeration equipment manufacturing Plastic machinery cooling Catering School Foundation School Catering Tourism professional training Industrial plastic recycling Food hose Industrial hose Industrial mixing Confectionery Industrial Vacuum Cleaners Industrial sewing machine needles Food industry workwear Development and commercial real estate Industrial Plastics Industrial scales 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 Construction Tools Construction Equipment Construction machines Industrial glasses Industrial property services and advice Food technical school Construction machinery leasing and rental Household chemical jars Automotive Castings Industry alpine jobs Industrial Facilities Maintenance Earth-moving machine operator Planers and saw industrial adjustment and sharpening Three-phase industrial motors Industrial ethernet switch 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 Pipeline construction Landscaping work Amelioration works Compressor station construction Crane work Agricultural service Industrial plants, factories security fence construction Industrial and domestic sewing machines Industrial Sewing Machine Shoe Machine darner Industrial halls, air-conditioning Skilled mechanic gypsum Industrial bonding Earth-moving trade Construction machinery trade Construction bérgépek TEREX-FUCHS Industrial boom lifts Industrial boilers to improve Industrial fan, container Preparation of resin flooring industry Industrial oils Industrial Estates Sports and leisure facilities 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 Industrial gate Injection molding for the automotive industry Materials for the furniture industry Fittings for furniture Construction Racks Construction Quality Control Construction inspection Industrial rope access technical protection devices Industrial Hoses Industrial Water Treatment Construction Transport Industrial Property Litigation Industrial adhesives Acid-resistant industrial floors Glass Industry Raw materials for glass industry Glass thermocouple accessories



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