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 '%TELEPHOTOGRAPHY%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
7 1 20 Photography. Twelfth Edition London, Barbara Primary Author Upton, John Primary Author Stone, Jim Primary Author mixed material 9780134482026 Boston Pearson 2017 0134482026.jpg.jpg Photography. Ninth Edition London, Barbara Primary Author mixed material 9780132061179 New Jersey Pearson 2009 9780132061179.jpg.jpg Mastering digital photography Freeman, Michael Primary Author mixed material 9781907579004 Singapore PageOne 2008 coverimg_5314.jpg Mastering digital photography ; The serious photographer's guide to high-quality digital photography Busch, David d Primary Author mixed material 9781435458321 Boston thomson course technology 2006 515HX5GP03L._SX402_BO1%2C204%2C203%2C200_.jpg.jpg The essential wildlife photography manual Weston, Chris Primary Author mixed material 2880468086 Switzerland Rotovision 2005 %2B-%2B36346851_140.gif.gif The digital photographer's handbook nature Davies, Adrian Primary Author mixed material 2880467802 Switzerland Rotovision 2004 51PZ1E5HXVL._AC_UY218_.jpg.jpg Digital photography : A step-by-Step Guide to creating and manipulating great images Ang, Tom Primary Author mixed material 184533017x London Mitchell Beazley 1999 digi_photo.jpg.jpg