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 ba.biblio_id FROM biblio_author AS ba LEFT JOIN mst_author AS a ON ba.author_id=a.author_id WHERE author_name LIKE '%Jodidio, Philip%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
10 1 20 Contemporary Japanese architecture Jodidio, Philip Primary Author mixed material 9783836575102 Koln Taschen GmbH 2021 124843640964d45e7fc37076.30033767.jpg West kowloon station : andrew bromberg at aedas Jodidio, Philip Primary Author mixed material 9780847863525 New York Rizzoli Electa 2019 9780847863525.gif.gif Jean-Michel Wilmotte : Leading Architects Jodidio, Philip Primary Author Wilmotte, Jean-Michel Primary Author mixed material 9781864707489 Mulgrave, Vic. Images Publishing Group 2018 9781864707489.jpg.jpg Richard Meier & Partners : white is the light Jodidio, Philip Primary Author mixed material 9783836542647 Köln ; [Paris] Taschen 2017 dfdgg.gif.gif Calatrava : Santiago Calatrava, complete works 1979-today Jodidio, Philip Primary Author mixed material 9783836549646 Köln ; [Paris] Taschen 2015 %2B-%2B832747274_140.gif.gif Shigeru Ban : complete works, 1985-2015 Jodidio, Philip Primary Author mixed material 9783836532204 Köln ; [Paris] Taschen 2015 %2B-%2B300430364_140.gif.gif Ando : Complete Works 1975-Today Jodidio, Philip Primary Author mixed material 9783836553940 Köln ; [Paris] Taschen 2014 %2B-%2B253782104_140.gif.gif Piano : Renzo Piano Building Workshop : 1966 to today Jodidio, Philip Primary Author mixed material 9783836542821 Köln ; [Paris] Taschen 2014 %2B-%2B162645343_140_%281%29.gif.gif Hadid : Zaha Hadid, complete works 1979-today Jodidio, Philip Primary Author mixed material 9783836542838 Köln ; [Paris] Taschen 2013 %2B-%2B025745514_140.gif.gif I.M. Pei : complete works Jodidio, Philip Primary Author Strong, Janet Adams Primary Author mixed material 9780847831456 New York Rizzoli international publ. 2008 9780847831456.gif.gif