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 '%Pictorial Works%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
15 1 20 Harry potter film vault. Volume 2, diagon alley, the hogwarts express, and the ministry Revenson, Jody Primary Author mixed material 9781683837473 California Wizarding World 2019 HARRY_POTTER_FILMS_--_PICTORIAL_WORKS.jpg.jpg The art of Borderlands 3 Allcock, Chris Primary Author Kester, Scott Primary Author mixed material 9781789090819 London Titan books 2019 9781789090819.gif.gif First Time Cake Decorating Autumn Carpenter Primary Author mixed material 9781589239616 New York Creative Publishing International 2018 52940526762bd3c913781a3.02503138.jpg The art of Solo : a Star Wars story Szostak, Phil Primary Author mixed material 9781419727450 New York Abrams 2018 aasesfsf.jpeg.jpeg Art of the book of life Gutierrez, Jorge R Primary Author mixed material 9781616555337 Oregon Dark Horse Comics 2014 9781616555337.jpg.jpg Greetings From Jakarta : Postcards of A Capital 1900 - 1950 Merrillees, Scott Primary Author mixed material 9789793780887 Jakarta Equinox Publishing 2014 coverimg_15889.jpg Images of Indonesia von Holzen, Heinz Primary Author mixed material 9789814516082 Singapore Marshall Cavendish International 2014 51c6kWNO%2BXL._SY490_BO1%2C204%2C203%2C200_.jpg.jpg The art of Alien isolation Mcvittie, Andy Primary Author mixed material 9781781169315 London Titan books 2014 2682248_b32e8704-4563-11e3-b162-27423384bbc6.jpg.jpg The art of Destiny Bungie Primary Author mixed material 9781608874200 California Insight Editions 2014 71WpzvhVhrL._AC_UY218_.jpg.jpg The art of Naughty Dog Wright, Brendan Editor mixed material 9781616554774 Milwaukee Dark Horse Books 2014 %2B-%2B872550323_140.jpg.jpg The Hobbit, the battle of the five armies : chronicles Falconer, Daniel Primary Author mixed material 9780062265715 New York HarperCollins Publishers 2014 %2B-%2B649143523_140.jpg.jpg Bookshops long-established and the most fashionable Braun, Markus Sebastian Primary Author Roth, Manuela Editor Bretz, Antje Editor Templin, Stefanie Editor mixed material 9783037681220 Salenstein Braun 2012 20085004326673fbf6a6b111.33285940.jpg Alexander McQueen : Savage Beauty Bolton, Andrew Primary Author Sundsbø, Sølve Primary Author McQueen, Alexander Primary Author mixed material 9780300169782 New Heaven Yale University Press 2011 9780300169782.jpg.jpg DOFUS 2.0 artbook Dofus Team Primary Author mixed material 9782359100730 Roubaix Ankama 2010 265593479668503a501aa08.02411889.PNG Britannica Illustrated Science Library: Technology Levy, Michael Primary Author mixed material 9781593393984 China Encyclopedia Britannica 2008 technology.jpeg.jpeg