select *, -- producatori.producator as producer, categorii.categorie as category, -- if(oferte.categorie=138,categorii.categorie,categorii2.categorie) as category, categorii.categorie_seo, oferte.id as pid , foto.nume_foto fnume, foto.foto_id fid, oferte.rating/(if (oferte.votari>0,oferte.votari,1) ) as stele, oferte.titlu_pagina as subtitlu from oferte -- join producatori -- on oferte.producator=producatori.producator_id join categorii on oferte.categorie=categorii.categorie_id left join foto on oferte.id=foto.id -- left join (select * from asocieri_produse where categ_id is not null and categ_id >0 and categ_secundara=1) categsec -- on oferte.id=categsec.oferta_id -- left join categorii categorii2 -- on categsec.categ_id=categorii2.categorie_id where (oferte.categorie=138) -- and pret_brut>0 and oferte.inactiv=0 group by oferte.id order by oferte.id desc, pret_brut limit 0,10select *, -- producatori.producator as producer, categorii.categorie as category, -- if(oferte.categorie=138,categorii.categorie,categorii2.categorie) as category, categorii.categorie_seo, oferte.id as pid , foto.nume_foto fnume, foto.foto_id fid, oferte.rating/(if (oferte.votari>0,oferte.votari,1) ) as stele, oferte.titlu_pagina as subtitlu from oferte -- join producatori -- on oferte.producator=producatori.producator_id join categorii on oferte.categorie=categorii.categorie_id left join foto on oferte.id=foto.id -- left join (select * from asocieri_produse where categ_id is not null and categ_id >0 and categ_secundara=1) categsec -- on oferte.id=categsec.oferta_id -- left join categorii categorii2 -- on categsec.categ_id=categorii2.categorie_id where (oferte.categorie=138) -- and pret_brut>0 and oferte.inactiv=1 group by oferte.id order by oferte.id desc, pret_brut limit 0,10 Tarus Media
home   about us
   events   medical publications   CME   PR   cariera   online marketing   contact

What is new? Over 150 specialists from 7 countries at the 6th edition of the Danubian Transplant Symposium Vienna 2009
11 December 2009, Vienna
  Extraordinary feedback from top transplant related specialists in Romania, Austria, Germany, Czech Republic, Hungary, Serbia, and Bulgaria. The 6th edition of the Danubian Transplant Symposium 2009 is organized together with the Clinical Institute of Urology and Renal Transplant, Cluj-Napoca, Romtransplant, Clinical Institute Fundeni and The Centre of General Surgery and Liver Transplant. Over 150 professors, doctors and nurses attend the event is organized by Tarus Media in Vienna on the 11th of December 2009.

Over 150 participants, top Romanian and international specialists, opinion leaders in the field of clinical transplantation, ATI specialists from the most important hospitals in Romania discussed latest advances in organ transplantation.
  PAST EVENTS


The launch of MEDICA ACADEMICA
under the Auspices of The Romanian Scientists Academy
7 October 2009, Pallace of Parliament, Bucharest
  Tarus media has launched the newest medical publication MEDICA ACADEMICA under the Auspices of The Romanian Scientists Academy. The monthly publication is dedicated to the medical elite and it sustains the romanian excelency in the medical research field.
PHOTO GALLERY

The complete National Surgery Compendium
Coordinated by Prof. Irinel Popescu
16th October, The Romanian Academy
  PHOTO GALLERY

Dr. Nizar Ajjan
Charles Merieux
A visionary of healthcare
25th September 2009, The Romanian Academy
  PHOTO GALLERY

Prof. Irinel Popescu
Romanian Medical Excellence
200 Liver Transplants performed at General Surgery and Liver Transplantation Center Fundeni
18 September 2009, Bucharest
  PHOTO GALLERY

Chronic Disease and Health Management 2009
Redesigning Health Systems for the 21st Century
7-8 October 2009, Pallace of Parliament, Bucharest
  PHOTO GALLERY

London Business Medical Round Table
Long Term Partnership in Financial Crisis Time
16 March 2009, London
  PHOTO GALLERY

26-27 May 2009, Bucharest
  PHOTO GALLERY






User
Password
newsletter
Name
E-mail
©Tarus media 2009             terms and conditions