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 = 1002 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 : 298-302 -

Pages : 126-130 -

Pages : 183-189 -

Pages : 133-138 -

Pages : 550-553 -

Pages : 274-283 -

Pages : 164-168 -

Pages : 671-681 -
DOI : 10.5606/tgkdc.dergisi.2011.112
Pages : 316-321 -