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 bt.biblio_id FROM biblio_topic AS bt LEFT JOIN mst_topic AS t ON bt.topic_id=t.topic_id WHERE topic LIKE '%FOLKLORE%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
8 1 20 Japanese legends and folklore : samurai tales, ghost stories, legends, fairy tales, myths and historical accounts Redesdale, Algernon Bertram Freeman-Mitford Primary Author Foster, Michael Dylan Primary Author mixed material 9784805315019 La Vergne Tuttle Publishing 2019 1715267829636a212bc93b21.84186194.jpg Robin Hood Gilbert, Henry Primary Author Williams, Garth Primary Author mixed material 9781788882187 London Arcturus 2018 135902291464366392b6ac39.54238648.jpg Tales of King Arthur Gilbert, Henry Primary Author mixed material 9781788882293 London Arcturus 2018 103499156664366f63e7e910.10149436.jpg Nusantara Bertutur : Dongeng Fabel Suharso, Yudi Primary Author Ari, Niken Primary Author mixed material 9789797099022 Jakarta Penerbit Buku Kompas 2015 Nusantara-Bertutur.jpg.jpg Bujang Permai Bunanta, Murti Primary Author mixed material 9789790817371 Jakarta Kompas Gramedia 2012 33829662.jpg.jpg Putri Keong Bunanta, Murti Primary Author mixed material 9789790817890 Jakarta Kompas Gramedia 2012 94500_f.jpg.jpg Si Kelingking Bunanta, Murti Primary Author mixed material 9789790817357 Jakarta Kompas Gramedia 2012 d.jpg.jpg Si Molek Bunanta, Murti Primary Author mixed material 9789790817340 Jakarta Kompas Gramedia 2012 simolek-200x280.jpg.jpg