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 '%PAINTING-TECHNIQUE%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
11 1 20 Fantasy creatures : The ultimate guide to mastering digital painting techniques Howlett, Claire Primary Author mixed material 9781843406020 London Collins and Brown 2011 %2B-%2B756542373_140.gif.gif How to draw and paint fantasy architecture Alexander, Rob Primary Author mixed material 9780764145353 New York Barrons 2011 51QQ51aUhLL._SX385_BO1%2C204%2C203%2C200_.jpg.jpg How To Draw Animals Step By Step Guinot, Sergio Primary Author mixed material 9789460650284 Belgium BooQs 2010 %2B-%2B196491850_140.gif.gif Drawing Step By Step Box, Richard Primary Author mixed material 9789812459169 Singapore PageOne 2009 drawing_step_by_step_1474984674_c4eee4d9.jpg.jpg Fantasy genesis: A creativity game for fantasy artist Lukacs, Chuck Primary Author mixed material 9781600613371 Canada Impact 2009 61YnNw%2BbkcL._SX378_BO1%2C204%2C203%2C200_.jpg.jpg 100 Ways to create fantasy figures Tsai, Francis Primary Author mixed material 9781600611193 Ohio Impact 2008 515bxwW2Y6L._SX373_BO1%2C204%2C203%2C200_.jpg.jpg Dragonart fantasy characters: How to draw fantastic beings and incredible creatures Peffer Primary Author mixed material 9781581808520 Ohio Impact 2007 9781581808520.jpg.jpg Traditional oil painting Elliott, Virgil Primary Author mixed material 9780823030668 New York Watson Guptill 2007 %2B-%2B38947592_140.gif.gif Drawing & Painting : Fantasy Landscapes & Cityscapes Alexander, Rob Primary Author mixed material 9780764132605 New York PageOne 2006 51B09V4ETFL._SX377_BO1%2C204%2C203%2C200_.jpg.jpg Drawing & Painting : Fantasy Beasts Walker, Kevin Primary Author mixed material 9780764130908 Singapore PageOne 2005 content_%281%29.jpeg.jpeg Digital Texturing & Painting Demers, Owen Primary Author mixed material 9780735709188 Indianapolis New Riders 2002 51RcYdifYgL._SX400_BO1%2C204%2C203%2C200_.jpg.jpg