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 Permanent without treatment plant asphalt manufacture, asphalting carpentry car manufacture Tinker Production Elements Internal joinery larch furniture manufacturers Furniture furniture production, trade Crane production Food processing equipment manufacturing industrial woodworker, construction industry Wood interior door manufacturing Wood joinery Male children sweater manufacturing paint/emulsion-, glaze- and varnish manufacture 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 Gravel plant Boiler manufacture Boiler Operation Boiler Operation picture- and photo framing Combi sauna production Magnet production Balance Sheet Production instrument and apparatus manufacture billboard printing, manufacturing bottling plants 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 Cemetery Operations pasta making, trade aluminium oxide production road constuction, maintenance and management city operation steel- and iron foundry fuel plant machinery and fittings Operation of elevators Workware Production of special lenses Upholstered furniture Manufacture of electrical control Metal construction services Cosmetics Solar Production camshaft production Utility Service Firm Service Veszprém Service Firm Firm aptitude test Firm supply Tinware products and essay Production Tool tabs feed production Besence Street Plant Aszódi Plant Parts Production Production for hotels furniture needs of individual carpentry factory Manufacture of Custom Products Coffee machines operation concrete production Concrete production film hiring out of plant individual production buildings Production of mobile roof Medical device manufacturing Production of promotional materials Invitations Production Cleaning plant Manufacture of instruments covers preform manufacturing kupakgyártás Fuel Additives Operation of street lighting Custom Built lifts Manufacture of metal shutters műsorgyártás and video operation of vending machines Electrical equipment manufacturing Custom Built Lifts conveyor belt production conveyor belt installation bottling plant installed transmission manufacturing Nursery operation Fuel Charge Carpenter plant Joinery factory production Carpenter plant Szentendre Joinery products Compressor Installation gyorskapuk food plants High voltage switchgear and transformer installation Switchgear manufacture Switching equipment Electric Operation and Maintenance faforgácsoló production tools Manufacture of pneumatic tools Manufacture of assembly tools Manufacture of pneumatic components compressor parts manufacturing Printing Boiler plant operator without constant Production of gas-shielded Torches shrink production CD Production VHS production Videotape production Production of video cassettes factory hygiene products Software Management Consultancy Fuel System Cleaning 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 Plant organization Individual profiles Design and construction dust filter deposits Filter production Manufacture of fire-fighting signs Computer installation PCB production PCB production PSB production Mucus production sheets Production of PCBs pages Printed circuit board manufacturing Hole plated PCB Production Gas cooking tables Low voltage operation of complex IT systems MODELS Production Galvanic plant Cooler and equipment nec Industrial refrigeration equipment manufacturing Manufacture of medium Manufacture of workwear Computer mucus production Plastic bag manufacturing Production of reinforced concrete structures Sportswear Manufacture Footwear Production Manufacture of other outerwear Turkish-milling plant Flexible fuel piping system EDM equipment into service, EDM Equipment Manufacture Installation of generators, installation Plastic Film production Disposable, single-use products Carpentry Joinery Joinery Work Rainfall operating systems Petrol dispenser Intercom systems manufacturing Bottles, jars Production Electronic component manufacturing Custom-made products CE marked Welding certification Production of iron castings Border heating system of production EDM machines Safe operation of lifting Lifting operation Curved, shaped windows and doors manufacturing Custom manufacture of doors and windows Electrical network and station training Hybrid cooling system operator Hydrogen plant operator Distribution of production and renovation Production of mail boxes Manufacture of paper packaging materials Production of corrugated board Nursery Tables Educational tables Teachers' tables Operating table Coffee-machine operation 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 products Production of polyethylene bags, Sülysáp Production of retreaded truck tires Production of polyethylene plastic bags Metal components Manufacture of plastic injection molded parts Occupational physician Veszprém Design and manufacture of plastic injection molds Asphalt and concrete production, recycling Glass manufacturing Machine design, manufacturing 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 Pool table rental Elevator installation Welding Plant Certification Investigation of accidents at work and Glass bottle manufacturing No. 1 Plant Health Ltd Residential elevator operation Silicone products Installation of bicycle



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