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 Component renewal asphalt manufacture, asphalting car manufacture Tinker Production Elements Internal joinery larch Furniture renovation Furniture furniture production, trade Crane production Food processing equipment manufacturing building maintenance, renovation Wood interior door manufacturing Wood joinery Male children sweater manufacturing paint/emulsion-, glaze- and varnish manufacture ink-cartridge refreshment film and video production and distribution 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 home decorating Magnet production Balance Sheet Production 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 brick manufacture and distribution television- and radio manufacture, distribution pasta making, trade aluminium oxide production steel- and iron foundry Furniture renovation Workware Production of special lenses Upholstered furniture Manufacture of electrical control Metal construction services Cosmetics Felületvédelmi renovation work Solar Production camshaft production starter renovation Compressor condenser unit renovation Tinware products and essay Production Tool tabs feed production Parts Production Production for hotels furniture needs of individual carpentry factory Manufacture of Custom Products Fireplaces renovation Coffee automatic renewal Skis renovation concrete production Concrete production film individual production buildings Production of mobile roof Medical device manufacturing Renovation of coffee machines Production of promotional materials Invitations Production Brake component refurbishment Compressor block renewal of a guarantee Manufacture of instruments covers preform manufacturing kupakgyártás Lift refurbishment Cylinder refurbishment Generator, renovation Custom Built lifts Manufacture of metal shutters műsorgyártás and video Electrical equipment manufacturing Custom Built Lifts conveyor belt production transmission manufacturing Joinery factory production Switchgear manufacture Switching equipment 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 Individual profiles Design and construction dust filter deposits Filter production Manufacture of fire-fighting signs CNC machine tool refurbishment Building renovation Facade renovation PCB production PCB production PSB production Mucus production sheets Production of PCBs pages Printed circuit board manufacturing Hole plated PCB Production MODELS Production Cooler and equipment nec Industrial refrigeration equipment manufacturing Refrigerated dryers, renovation Manufacture of medium Manufacture of workwear Renovation of water meters Computer mucus production Tile roof restoration Plastic bag manufacturing Production of reinforced concrete structures Sportswear Manufacture Footwear Production Manufacture of other outerwear Chimney Renovation Woodworking Machinery Renewal EDM Equipment Manufacture Facade renovation Plastic Film production Disposable, single-use products Intercom systems manufacturing Historic building renovation Bottles, jars Production Electronic component manufacturing Renovation of pearls Custom-made products CE marked Production of iron castings CANON Renovation Books Border heating system of production EDM machines Curved, shaped windows and doors manufacturing Custom manufacture of doors and windows Bridge renovation Church renovation Distribution of production and renovation Fixef improve power factor correction, reconstruction Production of mail boxes Manufacture of paper packaging materials Production of corrugated board Reconstruction tool Battery refurbishment Manufacture of individual packaging Insulating glass production Profile rolling production Narrow strip, cut Sidewalk renewal Sports field renovations Technical Drawing Boiler heat exchangers for acid treatment Renovation of boiler room Ribbon Manufacturing Industrial fan, container Compensator springs, dampers Production Technology pipeline installation Aluminum coolers to improve Ljungström refurbishment, heat exchanger elements of production Plastic products Production of polyethylene bags, Sülysáp Concrete Renovation Renovation of flat roof waterproofing Renovation of roof insulations light protection Production of retreaded truck tires 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 Presses, repairing and renewing Hydraulic equipment refurbishment and repair Machine design, manufacturing PVC insulation renovation Flat roof renovation Antique furniture renovation Steel constructions Elevator manufacturing Passenger car production Production of car hoist Manufacture of office and living containers Manufacture of lift shafts Elevator Design Elevator manufacturing Building works Safety glass Steel security door Security Door Installation Security doors Security Door trade Chimney liner production Renovation of chimneys 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 Renovation of old insulation Thermal insulation and insulation renovation Glass bottle manufacturing Silicone products



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 "Ljungström refurbishment, heat exchanger elements of production" ) 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 = "33738" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150