2025.04.03 Thursday Buda,Richárd
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

Window handles Door handles Boots tyres, tyre repair, retreading Contact lens Contact lens care Contact lens fluid Contact lens fitting Tick-clearing Glasses lens Lens manufacture gambling Contact lens specialist Production of special lenses Non-destructive material testing machine Tick-clearing Recruit HQ dioptric lens cilinderes lens Cellulite treatment Combat boots Optical lenses gerincsérv management NCS Light darkening glasses lens Contact lens ophthalmic testing NDT Training benzincsap Alpha the buildings Spinal hernia gymnastics Quick knit chains Gebo clamps Joints Destruction-free material testing Heat-resistant boots Electrician boots Metallurgical boots Waterproof boots Flat lenses convector ZnSe meniscus lens Tire condition monitoring Installation of earth-moving tires Drótpántos tire assembly Acélpántos tire assembly Tires fleet management ESSILOR lens Antistess ESSILOR Varilux multifocal lens COOPER VISION contact lenses Disposable contact lenses Discount Contact Lenses Bates boots Distribution of lens Lens Distribution Treatment of strabismus Slim Lens Lightweight lenses Protective boots Waste tire collection Utilization of waste tires Airwear lenses Impact-resistant lenses Secure glasses Terminological vocabulary building UV filtering sunglasses lens control Winter tires Diagnostic lenses Lens meter IOL intraocular Concrete tile Health and safety boots Retreaded truck tires Truck health check Tire repair and installation Production of retreaded truck tires NORMA pipe and shackles Tyre Crushers Contact lenses test Geo textiles, drainage Wheel Clamp Hiking boots Vaccination against ticks Tick ​​Bracelet Tick ​​Alert Destructive Pipe



Home > Detailed search > NCS

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