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 '%Wild, John J%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
5 1 20 Financial Statement Analysis. Eleventh Edition Subramanyam, KR Primary Author Wild, John J Primary Author mixed material 9780071086387 Boston McGraw Hill 2014 9780071086837.jpg.jpg Financial accounting fundamentals : media integrated. Fourth Edition Wild, John J. Primary Author mixed material 9780078025594 New York McGraw-Hill/Irwin 2013 asdsfdfdgfw.gif.gif Financial accounting : information for decisions. Fourth Edition Wild, John J. Primary Author mixed material 9780071101196 New York McGraw-Hill 2008 coverimg_3141.jpg Financial Statement Analysis. Ninth Edition Wild, John J. Primary Author Subramanyam, K. R. Additional Author Halsey, Robert F. Additional Author mixed material 9780071254410 New York McGraw Hill International 2007 coverimg_3134.jpg Fundamental Accounting Principles. Nineteenth Edition Wild, John J Primary Author Larson, Kermit D Primary Author Chiappetta, Barbara Primary Author mixed material 9780073379548 Boston McGraw-Hill 2007 coverimg_3217.jpg