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 '%SPECIAL KINDS OF PHOTOGRAPHY%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
15 1 20 That's Life Envision Primary Author mixed material 97887678988 Envision 2015 coverimg_10526.jpg Social photography : make all your smartphone photos on in a billion Bowker, Daniela Primary Author mixed material 9781781579817 East Sussex ILEX 2014 71GGlxHnFpL.jpg.jpg Pilgrimage Leibovitz, Annie Primary Author mixed material 9780375505089 New York Random House 2011 coverimg_8528.jpg Seni Fotografi Anak Rizaldi, Erwin Primary Author mixed material 9789792793833 Jakarta Elex Media Komputindo 2011 18846908_8678a270-234d-4e55-8580-3d43af42eebf_300_376.jpg.jpg 101 top digital photography tips Freeman's, Michael Primary Author mixed material 9789812457127 Singapore PageOne 2010 109822057762de1cdd1c50f6.69788709.jpg Beyond digital photographhy: transforming photos into fine art with photoshop and painter Pendarvis Primary Author Jolley, Donal Primary Author Threinen, Cher Primary Author mixed material 9780321410214 Berkeley Peachpit Press 2009 coverimg_1612.jpg Perfect digital photography : brilliant pixels from the digital darkroom Kinghorn, Jay Primary Author Dickman, Jay Primary Author mixed material 9780071601665 California McGrawHill 2009 coverimg_8402.jpg Advertising Photography; A Straighforward Guide To A Complex Industry Lesko, Lou Primary Author mixed material 9781598634068 Boston Thomson 2008 514qdpsaK7L._SY402_BO1%2C204%2C203%2C200_.jpg.jpg The complete photo guide to curtains and draperies pageone Primary Author mixed material 9789812454362 Singapore PageOne 2007 coverimg_10948.jpg The complete photo guide to slipcover pageone Primary Author mixed material 9812454373 Singapore PageOne 2007 coverimg_10949.jpg Digital photography Fbipp, Mike Hemsley Primary Author mixed material 9781405471121 bath Parragon 2006 coverimg_2705.jpg 500 more digital photography Andrews, Philip Primary Author mixed material 9789812452948 Singapore PageOne 2005 coverimg_245.jpg Digital photography problem solver Meehan, Les Primary Author mixed material 9789812452252 Singapore PageOne 2005 coverimg_2707.jpg Paparazzi; Memahami Fotografi Kewartawanan Sugiarto, Atok Primary Author mixed material 9789792217391 Jakarta GM 2005 xkcmdjcn.jpg.jpg Photo painting: the art of painting on photographs McKinnis, James A Primary Author mixed material 9780817455118 New York AMPHOTO BOOKS 2002 coverimg_8502.jpg