2025.08.14 Thursday Marcell
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

Of components purchasing of materials Breakdown Abroad Timber Purchase Pharmaceuticals medicines and therapeutic products, serums Pharmacist Pharmaceutical care public procurement Language courses abroad Moving abroad Pharmacy Assistant Training car purchase car purchase Rent a Car Abroad rent a car abroad foreign transportation transport abroad transport of goods abroad Travel Medicines Breakdown-rescue trucks from abroad Purchases Documents Spray equipment Spray equipment Szeged Vehicle procurement Parts Purchase Electrical materials to obtain Vilanyszerelési materials to obtain To obtain the title deed Foreign purchases of medicines Purchase of medicines from Austria Purchase of medicines in Germany Medicines from abroad Medicines procurement Foreign passengers A public call for verification Medicine glass Foreign bond Foreign Tourism Breakdown abroad Weddings abroad Breakdown in the country and abroad Foreign authorities for administration Administration of pensions institutions abroad Foreign insurance companies in administration Sales and purchasing administration Contacts with foreign partners Required for employment in foreign correspondence Towbars supply, installation Domestic and foreign small - high-value properties Foreign property Received expired medicines Foreign supply of fish



Home > Detailed search > Foreign purchases of medicines

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 "Foreign purchases of medicines" ) 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 = "27498" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150