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 '%Fantasy fiction%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
7 1 20 Harry Potter and the philosopher's stone : gryffindor Rowling, J.K Primary Author mixed material 9781408883730 London Bloomsbury 2017 9781408883730.jpeg.jpeg Harry Potter and the philosopher's stone : hufflepuff Rowling, J.K Primary Author mixed material 9781408883792 London Bloomsbury 2017 9781408883792.jpg.jpg Harry Potter and the philosopher's stone : ravenclaw Rowling, J.K Primary Author mixed material 9781408883778 London Bloomsbury 2017 5183269-l.jpg.jpg Alice in Wonderland Collection Carroll, Lewis Primary Author mixed material 9781530917563 Los Angeles Enhanced Media 2016 coverimg_20184.jpg Alice Through the Looking-Glass Carroll, Lewis Primary Author Tenniel, John Primary Author mixed material 9781783701841 Barnes, London Palazzo Editions LTD 2016 1905018470643661c212a863.61371283.jpg The art of the lord of the rings Hammond G, Wayne Primary Author Scull, Christina Primary Author mixed material 9780544636347 London HarperCollins Publishers 2015 coverimg_14931.jpg Alice's adventures in wonderland & other stories Tenniel, John Primary Author D'Andrade, Hugh Primary Author mixed material 9781607109334 San Diego Canterbury Classics 2013 10426530266311ba7c348ef0.13030828.jpg