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 '%Doyle, Sir Arthur Conan%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
12 1 20 Sherlock Holmes The Hound of the Baskervilles Doyle, Sir Arthur Conan Primary Author mixed material 9786025868641 Yogyakarta Immortal Publishing 2019 149590833964702b71c81fb4.11274321.JPG Sherlock Holmes: the sign of the four Doyle, Sir Arthur Conan Primary Author mixed material 9786025868627 Yogyakarta Immortal Publishing 2019 coverimg_1002248.jpg Sherlock Holmes: the valley of fear Doyle, Sir Arthur Conan Primary Author mixed material 9786025868658 Yogyakarta Immortal Publishing 2019 4378006364362c1b25f505.09774394.jpg Berlian Biru Seri Pertualangan Sherlock Holmes Doyle, Sir Arthur Conan Primary Author mixed material 9786025753183 Yogyakarta Cakrawala 2018 71897684063c77a6619f481.80367568.JPG Wisteria House Seri Petualangan Sherlock Holmes Doyle, Sir Arthur Conan Primary Author mixed material 9786025753213 Yogyakarta Cakrawala 2018 198432213063c7784a0ea579.60150491.JPG The Sherlock Holmes Mysteries Doyle, Sir Arthur Conan Primary Author mixed material 9780451467652 New York Penguin 2014 Holmes.jpg.jpg The first case of sherlock holmes : a study in scarlet Doyle, Sir Arthur Conan Primary Author mixed material 9790651783 Jakarta Visi Media 2013 63515_f.jpg.jpg Petualangan Sherlock Holmes Doyle, Sir Arthur Conan Primary Author mixed material 9789792279993 Jakarta PT Gramedia Pustaka Utama 2012 petualangan-sherlock.jpg.jpg Sherlock holmer : 13 kasus misterius terfavorit Doyle, Sir Arthur Conan Primary Author mixed material 9786021707616 Yogyakarta Indo Literasi 2012 1240647_478f00ae-b7ae-4e1f-b686-746330b8057b.jpg.jpg Sherlock Holmes : The Complete novels and Stories Vol. 1 Doyle, Sir Arthur Conan Primary Author mixed material 9780553212419 New York Bantam Dell 2003 holmes_3.jpg.jpg Sherlock Holmes : The Complete Novels and Stories Vol. 2 Doyle, Sir Arthur Conan Primary Author mixed material 9780553212426 New York Bantam Dell 2003 holmes_2.jpg.jpg Sherlock Holmes : the complete novels and stories, volume I Doyle, Sir Arthur Conan Primary Author mixed material 0553212419 New York Bantam Books 1986 %2B-%2B462597850_140.jpg.jpg