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 : 126-130 -

Pages : 135-137 -

Pages : 008-012 -

Pages : 008-010 -

Pages : 30-34 -

Pages : 550-553 -

Pages : 56-62 -

Pages : 59-62 -

Pages : 192-196 -

Pages : 108-111 -