SELECT biblio.biblio_id, biblio.title, biblio.image, biblio.isbn_issn, biblio.publish_year, pbl.publisher_name AS `publisher`, pplc.place_name AS `publish_place`, biblio.labels, biblio.input_date FROM biblio LEFT JOIN mst_publisher AS pbl ON biblio.publisher_id=pbl.publisher_id LEFT JOIN mst_place AS pplc ON biblio.publish_place_id=pplc.place_id WHERE opac_hide=0 AND (biblio.biblio_id IN (SELECT bt.biblio_id FROM biblio_topic AS bt LEFT JOIN mst_topic AS t ON bt.topic_id=t.topic_id WHERE topic LIKE '%HUMAN ANATOMY%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
9 1 20 Anatomy : a complete guide to the human body, for artists & students Joseph, Christopher Primary Author mixed material 9781782401278 Lewes Ivy 2017 anatomy.gif.gif Anatomy drawing school : human and animal Szunyoghy, Andras Primary Author mixed material 9783848010080 Germany h. f. ullmann publishing GmbH 2016 coverimg_1000367.jpg Seeley's Anatomy & Physiology. Ninth Edition Seeley, Rod Primary Author VanPutte, Cinnamon Primary Author mixed material 9780077350031 New York McGrawHill 2011 27512056962bd554343ed25.30275431.jpg Grays Anatomy For Student (Second Edition) Drake, Richard L Primary Author Vogl A Wayne Primary Author mixed material 9780443069529 Canada Churchill Livingstone 2010 2596428662bd20ef1b8274.60592856.jpg The Classic 1860 Edition Gray's Anatomy: with original Illustrations by Henry Carter Gray, Henry Primary Author mixed material 9781841939582 London Arcturus 2009 classic_grays_anatomy.jpg.jpg Grays Anatomy For Student Gray, Henry Additional Author Drake, Richard L. Primary Author Vogl, Wayne Additional Author Mitchell, Adam W. M. Additional Author mixed material 9780443066122 Philadelphia Elsever 2005 coverimg_3393.jpg Greys Anatomy for students Drake, Richard L Primary Author mixed material 9780443066122 Philadelphia Elsevier 2005 grays_anatomy.jpg.jpg Gray's anatomy Gray, Henry, Primary Author Williams, Peter L Primary Author Warwick, Roger Primary Author mixed material 9781782124269 London C. Livingstone 1989 9781782124269.jpg.jpg The Unabridged Running Press Edition of the American Classic : Gray's Anatomy Gray, Henry Primary Author mixed material 9780914294085 United States of America Running Press 1974 coverimg_10851.jpg