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 ba.biblio_id FROM biblio_author AS ba LEFT JOIN mst_author AS a ON ba.author_id=a.author_id WHERE author_name LIKE '%Hill, Ivan%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
2
1
20
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