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 Bamboo mosaic pavements Coating coverings (hot, cold) Framing Covering coverings, -tools, -machinery furniture manufacturers CNC Sheet CNC machining Wainscot Wood covers timber processing Wooden floors White Clothes metal sheet work metalwork earth moving equipment Cold-work and floor coating Coldcover cold foods cold processing Detail Cold event Cold Good Hamme cold order Good cold Kitchen worksheet Special cold locksmiths Paneling metal sheet processing marble, polished marble Gay Flooring Floor coating 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 Parquet Parquet wooden and suspended floors Order cold Swedish floor Swedish flooring Terrace housing Terrace coverings Workware Health working Security service working Crane works Climbing works Detail Order 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 needlework framing profiles hidegburkolatokhoz Kitchen worktops Fisheries vocational training Wood works Work chairs Security and protection work waterjet cut plate hidegvágás 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 hot and cold drink vending machines Workplace training working storage Workwear collection box workwear for hotels Flooring materials Bateco track protective jacket Indoor sports jacket Refrigerated bench Lifts Machine Demolition work Building demolition work Civil engineering work Professional work Advertise organization of work Decoration works Binding works Terrace parquet Cold jacket FOREST worksheets Glass Geodetic work Transport Worker Organization of work Work and protective scaffolding Alpin technical jobs Tinning and roofing works OSH Shop Cold Products Harnesses work belt Working against rain Special working Special work clothes Cold preparation of products Cold production Manufacture of workwear Cold-water meters 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 Ice-blue training Ophthalmic screening at the workplace The detection of workpieces Fiberglass jobs Cold gild foil 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 Bridge elevation 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 Plates for cold forming 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 Cold and hot rolled sheets Building works Structural locksmithery General locksmith work Production of cold crimping tool 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 Cold buffet Glass forming supplies



Home > Detailed search > Cold-work and floor coating

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 "Cold-work and floor coating" ) 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 = "12520" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150