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 '%Brown, D%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
10 1 20 Origin Brown, Dan Primary Author mixed material 9781400079162 New York Random House 2018 %2B-%2B3118302756_70.gif.gif Origin A Novel Brown, Dan Primary Author mixed material 9786022914426 Yogyakarta Bentang 2018 coverimg_20459.jpg 501 must-visit natural wonders Brown, D Primary Author Barran, Miranda Primary Author Brown, Jackum Primary Author Findlay, A. Primary Author mixed material 9780753729847 London Bounty Books 2016 1066314709643662831fb5e6.36308213.jpg Deception Point Brown, Dan Primary Author mixed material 9786022910886 Yogyakarta Bentang 2015 Inferno Brown, Dan Primary Author mixed material 9786027888555 Jakarta Gramedia 2014 68258_f.jpg.jpg Inferno : a novel Brown, Dan Primary Author mixed material 9780385537858 New York Doubleday 2013 %2B-%2B344098973_140.jpg.jpg An Experiential Approach To Organization Development. Eighth Edition Brown, Donald R Primary Author mixed material 9780136106890 New Jersey Prentice Hall 2011 coverimg_830.jpg An Experiential Approach To Organizational Development. Eighth International Edition Brown, Donald R Primary Author mixed material 9780132546140 New Jersey Pearson 2011 coverimg_831.jpg Deception point Brown, Dan Primary Author mixed material 9789791112509 Jakarta Serambi 2006 deception_muslihat.jpg.jpg The Davinci Code Brown, Dan Primary Author mixed material 9793335807 Jakarta Serambi ilmu semesta 2003