SELECT * FROM cms_1_sidebar WHERE CONTENTID="122" ORDER BY POSITION ASC
SELECT * FROM cms_1_contents_hu WHERE ACTIVE="1" AND SUB="122" ORDER BY MAIN,NO DESC
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='128' AND MAIN='1' AND CONTENTTYPE='1'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='127' AND MAIN='1' AND CONTENTTYPE='1'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='126' AND MAIN='1' AND CONTENTTYPE='1'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='125' AND MAIN='1' AND CONTENTTYPE='1'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='123' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='122' AND CONTENTTYPE='1' AND MAIN!='1' AND ICON!='1'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='122' AND MAIN='1' AND CONTENTTYPE='1'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='122' AND MAIN='1' AND CONTENTTYPE='1'
Termékeink - LimesVet
SELECT * FROM cms_1_news_hu WHERE ACTIVE='1' AND CATEG='1' ORDER BY PUBDATE DESC LIMIT 2
SELECT PICTURE,CONTENTID FROM cms_1_pictures WHERE MAIN='1' AND CONTENTTYPE='7'
SELECT ANCHOR,NAME,TEXT,ID FROM cms_1_templates_hu WHERE EXTRA="0"
SELECT NAME,SUBTEXT,TECHNICALID,TEXT FROM cms_1_contents_hu
EN
EN

Termékeink

PERSIC

Sebészi guide-rendszer gerincműtétekhez

RADISEC 55

Sebészi guide-rendszer alkar korrekciós műtéthez

TROCA 56

Térdkalácsárok protézis rendszer

TROCA 55

Térdkalácsárok protézis rendszer

TROCA 50

Térdkalácsárok protézis rendszer

  Új eset   Konzultáció
DEVELOPER BAR