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 = 114 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     
Pages : 029-034 -
DOI : 10.5606/tgkdc.dergisi.2014.8315
Pages : 056-062 -
DOI : 10.5606/tgkdc.dergisi.2014.8386
Pages : 013-018 -
DOI : 10.5606/tgkdc.dergisi.2014.8205
Pages : 459-462 -
DOI : 10.5606/tgkdc.dergisi.2013.5124
Pages : 1061-1063 -
DOI : 10.5606/tgkdc.dergisi.2013.6663