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 '%Mechanical drawing%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
5 1 20 Manual of engineering drawing : technical product specification and documentation to British and international standards. Fifth Edition Simmons, C. H. Primary Author Maguire, D. E. Primary Author Phelps, Neil, Primary Author mixed material 9780128184820 Oxford Butterworth-Heinemann 2020 427427551623156b1ed9653.08532299.jpg Drawing the Line Technical Hand Drafting for Film and Television McHenry, David Primary Author mixed material 9781138290334 New York Routledge 2018 zzxszdf.jpg.jpg Technical drawing with engineering graphics. Fifteenth Edition Giesecke, Frederick E. Primary Author Mitchell, Alva Primary Author Spencer, Henry Primary Author Hill, Ivan Primary Author Dygdon, John Primary Author mixed material 9780134306414 Boston Prentice Hall 2016 dfdgfhhnvbcv.gif.gif Technical drawing engineering graphics. Fourteenth Edition Giesecke, Frederick E. Primary Author Hill, Ivan Leroy Additional Author Spencer, Henry C. Additional Author Mitchell, Alva E. Additional Author Dygdon, John Thomas Additional Author Novak, James E. Additional Author Goodman, Marla Additional Author mixed material 9781292026183 Harlow, Essex PEARSON International 2014 %2B-%2B412371103_140.jpg.jpg Geometric and engineering drawing. Third Edition Morling, Ken Primary Author mixed material 9780415536196 London Elsevier 2010 51%2B399OwwkL._SX331_BO1%2C204%2C203%2C200_.jpg.jpg