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 Tinker Production Elements Internal joinery larch Furniture furniture production, trade Crane production Food processing equipment manufacturing Wood interior door manufacturing Wood and plastic exterior doors Wood joinery Male children sweater manufacturing paint/emulsion-, glaze- and varnish manufacture film and video production and distribution die-casting plywood production machinery manufacture engineering industry, mechanical engineering Steam and infrared products Pharmaceutical manufacturing Pharmaceutical packaging materials Welding products Welding production Manufacture of infrared Production of gates Boiler manufacture picture- and photo framing Combi sauna production Magnet production Balance Sheet Production Plastic cards Plastic shutter plastic processing laminating Plastics, plastics machinery plactic cards plastics, plastic goods plastic works instrument and apparatus manufacture billboard printing, manufacturing porcelain manufacture and distribution manufacturing of advertising instruments Their own production of welding equipment Sporting goods manufacturing Manufacture of saunas Lens manufacture Tool production tool manufacture -Sintered plastic filter brick manufacture and distribution television- and radio manufacture, distribution pasta making, trade aluminium oxide production steel- and iron foundry Workware Plastic roller Production of special lenses Upholstered furniture Manufacture of electrical control Metal construction services Cosmetics Solar Production camshaft production Plastic Case Tinware products and essay műanyagcsipesz plastic tweezers 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 Plastic Components individual production buildings Production of mobile roof plastic shutters Medical device manufacturing Production of promotional materials Invitations Production Industrial Plastic Working Plastic Working Plastic Boxes REHAU plastic doors and windows Manufacture of instruments covers preform manufacturing kupakgyártás Custom Built lifts Plastic bonded magnets Manufacture of metal shutters műsorgyártás and video plastic trays Electrical equipment manufacturing Plastic pots Custom Built Lifts conveyor belt production transmission manufacturing Plastic Joinery factory production Switchgear manufacture Switching equipment aftermarket plastic body components faforgácsoló production tools Manufacture of pneumatic tools Manufacture of assembly tools Manufacture of pneumatic components compressor parts manufacturing Production of gas-shielded Torches shrink production CD Production VHS production Videotape production Production of video cassettes Gyógyháttámasz Production 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 Plastic bags Non-slip plastic bags Fast-setting plastic Plastic closing Individual profiles Design and construction dust filter deposits 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 Sponge washer Plastic kitchen products Plastic storage boxes Plastic bathroom products MODELS Production Cooler and equipment nec Industrial refrigeration equipment manufacturing Plastic machinery cooling Manufacture of medium Manufacture of workwear Computer mucus production Plastic bags Plastic bag making Industrial plastic recycling Plastic bag manufacturing Production of reinforced concrete structures Industrial Plastics Sportswear Manufacture Footwear Production Manufacture of other outerwear Plastic garden furniture EDM Equipment Manufacture Plastic shop cart Plastic Injection molding Compressed air distribution Film production Disposable, single-use products Intercom systems manufacturing Plastic waste recycling Cosmetic cream Household chemical jars Cosmetic bottles Bottles, jars Production Electronic component manufacturing Custom-made products CE marked 5-chamber plastic windows 7-chamber plastic windows Production of iron castings Border heating system of production EDM machines Curved, shaped windows and doors manufacturing Custom manufacture of doors and windows Distribution of production and renovation Production of mail boxes Manufacture of paper packaging materials Production of corrugated board Plastic Fans Plastic chairs Manufacture of individual packaging Insulating glass production Profile rolling production Narrow strip, cut Ribbon Manufacturing Compensator springs, dampers Production Ljungström refurbishment, heat exchanger elements of production Plastic processing Plastic products PE plastic bag PE plastic bag PE plastic bag Production of polyethylene bags, Sülysáp Plastic injection molding parts Coating of plastic parts Coating of plastic parts Plastic parts tamponing Plastic containers Production of retreaded truck tires Metal and plastic accessories Polyethylene plastic bag Pest County Production of polyethylene plastic bags Felony bag Polyethylene film Metal components Manufacture of plastic injection molded parts Design and manufacture of plastic injection molds Asphalt and concrete production, recycling Glass manufacturing Machine design, manufacturing Plastic, and production tools fémfröccs 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 Plastic barrels Plastic Bags Glass bottle manufacturing Dynasol products CCP masterbatch Cleaning agents Thermoplastic elaszttomerek Self-adhesive sticker Disposable plastic products Silicone products Plastic coating Plastic bag warmers



Babaindex

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