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 '%Anthony, Robert N%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
7 1 20 Essentials of accounting. Eleventh Edition Anthony, Robert N Primary Author Breitner, Leslie K Primary Author mixed material 9780273771463 Harlow Pearson Education 2012 9780273771463.gif.gif Accounting : text and cases. Thirteenth Edition Anthony, Robert Newton Primary Author mixed material 9780071289092 Singapore McGrawHill 2011 Accounting_Case_studies.jpg.jpg Accounting text and cases. Twelfth International Edition Anthony, Robert Newton Primary Author Merchant, Kenneth A Primary Author Hawkins, David F Primary Author mixed material 9780071254090 Boston McGraw-Hill/Irwin 2007 acc_text_cases.jpg.jpg Management Control Systems. Twelfth Edition Anthony, Robert N Primary Author Govindarajan, Vijay Primary Author mixed material 9780073100890 Boston Mc Graw Hill 2007 9780073100890.jpg.jpg Management control systems. Twelfth International Edition Anthony, Robert Newton Primary Author Govindarajan, Vijay Primary Author mixed material 9780071254106 New York McGrawHill 2007 9780071254106-us.jpg.jpg Essentials of Accounting. Ninth Edition Anthony, Robert N Primary Author Breitner, Leslie K Primary Author mixed material 9780132233538 Singapore Pearson 2006 coverimg_2963.jpg Core concepts of accounting. Eighth edition Anthony, Robert N Primary Author Breitner, Leslie K Primary Author mixed material 0130406716 New Jersey Prentice Hall 2003 %2B-%2B897838814_140.gif.gif