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 Tinwork furniture manufacturers CNC Sheet CNC machining construction design and management Wedding timber processing White Clothes metal sheet work metalwork earth moving equipment Cold-work and floor coating cold processing advertising advertising publications, ad agency trade management Exhibition - fair presentation and organization Conference Organization conference management 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 education, education management Education organization promotion, advertising marketing design, management, campaigns party and reception organisation, hosting Event management organisational advice Workware Health working Security service working Crane works Climbing works Professional event organizing Conferences Organization of press conferences Cultivators plant Alpin technical work Felsőzsolca sewerage works Felületvédelmi renovation work 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 Hunting organization needlework framing Kitchen worktops Fisheries vocational training Wood works Work chairs Organization of press conference Program fell by the organization Betting 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 e ad unsolicited electronic ads related to official control Labor tasks Organizational culture Glazing Machine organization of presentations organization of gala dinners organizing garden parties Weddings organization Organization of corporate presentations clinical research studies 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 Burial organization Advertise organization of work Decoration works Binding works Corporate events organization Book organization Seminars Organization of cultural events Exhibition organizers FOREST worksheets Glass Geodetic work Transport Worker Organization of work Plant organization Work and protective scaffolding Alpin technical jobs Tinning and roofing works OSH Shop Harnesses work belt Working against rain Special working Special work clothes Manufacture of workwear Ventura hostel Goliath hostel Labor protection Facebook Ad 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 Ophthalmic screening at the workplace The detection of workpieces Fiberglass jobs Environmental training courses Work safety goggles Danger discharge works Limestone Working Backup Machine Carpentry 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 Trained students to work Promotional work, student work 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 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



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 "Advertise organization of 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 = "26836" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150