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 '%Turangan, Lily%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
12 1 20 Seni budaya & warisan Indonesia : 1-Sejarah awal Turangan, Lily Primary Author mixed material 9786027706408 Jakarta PT Aku Bisa 2014 coverimg_9786.jpg Seni budaya & warisan Indonesia : 10 - Seni Nasional Turangan, Lily Primary Author mixed material 9786027706491 Jakarta PT Aku Bisa 2014 coverimg_9787.jpg Seni budaya & warisan Indonesia : 11- Seni Pertunjukan Turangan, Lily Primary Author mixed material 9786027706507 Jakarta PT Aku Bisa 2014 coverimg_9788.jpg Seni budaya & warisan Indonesia : 12-Teknologi Turangan, Lily Primary Author mixed material 9786027706514 Jakarta PT Aku Bisa 2014 coverimg_9789.jpg Seni budaya & warisan Indonesia : 2-Sejarah Modern Turangan, Lily Primary Author mixed material 9786027706415 Jakarta PT Aku Bisa 2014 coverimg_9790.jpg Seni budaya & warisan Indonesia : 3-Flora Turangan, Lily Primary Author mixed material 9786027706422 Jakarta PT Aku Bisa 2014 coverimg_9791.jpg Seni budaya & warisan Indonesia : 4-Fauna Turangan, Lily Primary Author mixed material 9786027706439 Jakarta PT. Aku Bisa 2014 coverimg_9792.jpg Seni budaya & warisan Indonesia : 5-Olah raga & permainan Turangan, Lily Primary Author mixed material 9786027706446 Jakarta PT Aku Bisa 2014 coverimg_9793.jpg Seni budaya & warisan Indonesia : 6-agama & kepercayaan Turangan, Lily Primary Author mixed material 9786027706453 Jakarta PT Aku Bisa 2014 coverimg_9794.jpg Seni budaya & warisan Indonesia : 7-Manusia & Lingkungan Budaya Turangan, Lily Primary Author mixed material 9786027706460 Jakarta PT Aku Bisa 2014 coverimg_9795.jpg Seni budaya & warisan Indonesia : 8-Bahasa & Sastra Turangan, Lily Primary Author mixed material 9786027706477 Jakarta PT Aku Bisa 2014 coverimg_9796.jpg Seni budaya & warisan Indonesia : 9-Arsitektur Turangan, Lily Primary Author mixed material 9786027706484 Jakarta PT Aku Bisa 2014 coverimg_9797.jpg