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 works Carpentry Carpentry carpentry Tinwork casual work furniture manufacturers CNC Sheet CNC machining student jobs timber processing White Clothes metal sheet work metalwork earth moving equipment Cold-work and floor coating cold processing handicrafts, -accessories Kitchen worksheet locksmiths metal sheet processing marble, polished marble human resources agencies, management, advice human resources selection work machinery Workwear Wash work clothes Cleaning Workwear Workwear protective/work uniforms hostels Workers' hostel work protection Safety shoes Safety equipment Workplace safety gloves OSH publication Safety Signs jobcentres Printing jobs Printing jobs overall design Workware Health working Security service working Crane works Climbing works Handicrafts Cultivators plant Alpin technical work Felsőzsolca sewerage works Felületvédelmi renovation work earth hand TIG cables work Workplace Veszprém Health at Work Veszprém Health advice Veszprém health advice Preventing occupational Hygiene work Construction plumbers Laser Sheet needlework framing Kitchen worktops Fisheries vocational training Wood works Work chairs Security and protection work waterjet cut plate Aluminum machining Materials Wood Working Metallic materials processing Industrial Plastic Working Laser machining of aluminum Plastic Working Structural steel Stainless steel material machining 3D machining Micro machining Work rolls Labor Contracts tinwork working Labeling embroidery workwear safety shoes Sheets cut Cutting Sheets Labor tasks Glazing Machine Labor tasks Workplace training working storage Workwear collection box workwear for hotels Refrigerated bench Lifts Machine Demolition work Building demolition work Civil engineering work Professional work Advertise organization of work Decoration works Binding works FOREST worksheets Glass Geodetic work Transport Worker Organization of work Work and protective scaffolding Alpin technical jobs Tinning and roofing works OSH Shop Thesis binding Thesis binding Thesis Binding Harnesses work belt Working against rain Special working Special work clothes Installation of earth-moving tires Manufacture of workwear Ventura hostel Goliath hostel Labor protection ESD clothes Food industry workwear Workwear services Working clothes washing Cleaning working clothes Clean room clothes Clean room clothing Workers' Ministry of Labour and Social Affairs Healthy Workplace Human resources and labor law Upholstery Ophthalmic screening at the workplace The detection of workpieces Fiberglass jobs Work safety goggles Danger discharge works Limestone Working Backup Machine Metal-Sajóörs Carpentry Joinery Joinery Work Diving Alpine Jobs Mining jobs Social Work - Child Protection Working clothes shop Working clothes shop Acid-base sheet Occupational safety expert Crane Work Industry alpine jobs Administrative student Trained student Light physical Student Each student is cooperative Student telephone Trained students to work Promotional work, student work Earth-moving machine operator Worksheet program Nederman extraction work OSH services OSH services OSH services WPA Monitor pre-production work for glasses Stainless steel machining Workstations Industrial facilities Earthworks Landscaping work Amelioration works Crane work Laser micromachining Laser Processing Advanced Materials Employment law advice Preparation of employment contracts Cleavage Wage Earth-moving trade MECALAC Machines Required for employment in foreign correspondence Shop work and fire safety Health and safety signs Working garments OSH stores OSH store Occupational Safety signs OSH sticker Health and safety boots Worker Glove Work table Labour records Workwear materials Building works Structural locksmithery General locksmith work Sheet metal machining Sintering parts Recruitment for security guards Timesheet Working time records Work positioner waist belts Work Belts Safety Education Investigation of accidents at work and Safety Risk Assessment Preparation work and fire protection regulations Health Services Safety clogs Safety Shoes Glass forming supplies



Céginformáció

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 "Trained students to work" ) 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 = "32598" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150