SELECT categories.id AS categories_id, categories.name_tr, CAST(SUBSTRING_INDEX(pages, '-', -1) AS UNSIGNED) as num1, articles.* FROM articles INNER JOIN categories ON categories.id = articles.category WHERE articles.deleted=0 AND journalid = 92 ORDER BY categories.order_num, num1 ASC Turkish Journal of Thoracic and Cardiovascular Surgery
ISSN : 1301-5680
e-ISSN : 2149-8156
TURKISH JOURNAL OF
THORACIC AND
CARDIOVASCULAR SURGERY
Turkish Journal of Thoracic and Cardiovascular Surgery     

Original Articles
DOI : 10.5606/tgkdc.dergisi.2014.7997

DOI : 10.5606/tgkdc.dergisi.2014.8215

DOI : 10.5606/tgkdc.dergisi.2014.8205

DOI : 10.5606/tgkdc.dergisi.2014.8551

DOI : 10.5606/tgkdc.dergisi.2014.8315

DOI : 10.5606/tgkdc.dergisi.2014.9014

DOI : 10.5606/tgkdc.dergisi.2014.8622

DOI : 10.5606/tgkdc.dergisi.2014.8866

DOI : 10.5606/tgkdc.dergisi.2014.8386





DOI : 10.5606/tgkdc.dergisi.2014.8494



DOI : 10.5606/tgkdc.dergisi.2014.7633


DOI : 10.5606/tgkdc.dergisi.2014.8700

DOI : 10.5606/tgkdc.dergisi.2014.8276


Case Report
DOI : 10.5606/tgkdc.dergisi.2014.7421

DOI : 10.5606/tgkdc.dergisi.2014.7711

DOI : 10.5606/tgkdc.dergisi.2014.7662

DOI : 10.5606/tgkdc.dergisi.2014.7595

DOI : 10.5606/tgkdc.dergisi.2014.7666

DOI : 10.5606/tgkdc.dergisi.2014.7800


DOI : 10.5606/tgkdc.dergisi.2014.8118

DOI : 10.5606/tgkdc.dergisi.2014.8194

DOI : 10.5606/tgkdc.dergisi.2014.8037


DOI : 10.5606/tgkdc.dergisi.2014.8046


DOI : 10.5606/tgkdc.dergisi.2014.5697


DOI : 10.5606/tgkdc.dergisi.2014.6157

DOI : 10.5606/tgkdc.dergisi.2014.6269

Interesting Image

How to do it?
DOI : 10.5606/tgkdc.dergisi.2014.8547

Review

Interesting Articles

Editorial

Experimental Study

Letters to Editor