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 '%Landscape architecture%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
6 1 20 Architectural diagrams 2: construction and design manual Pyo, Mi Young Primary Author mixed material 9783869226736 Berlin DOM Publishers 2019 9783869226736.gif.gif River, space, design : planning strategies, methods and projects for urban rivers Prominski, Martin Primary Author Stokman, Antje Primary Author Stimberg, Daniel Primary Author mixed material 9783035611861 Switzerland Birkhäuser Basel 2017 170379704363118dd4ce4c09.95342587.jpg Waterfront promenade design : urban revival strategies Andersson, Thorbjörn Primary Author mixed material 9781864707441 Mulgrave, Victoria Images Publishing 2017 14775566406450b5d2559c81.00659190.jpg Landscape architecture documentation standards : principles, guidelines, and best practices Design Workshop Primary Author Ware, Chuck Primary Author mixed material 9780470402177 Hoboken John Wiley & Sons, Inc 2016 fghfgfhgjhjghfgf.gif.gif Architectural diagrams : 1 Pyo, Mi Young Primary Author mixed material 9783869224176 Berlin DOM Publishers 2015 qwwrr.gif.gif Discovering the vernacular landscape Jackson, John Brinckerhoff Primary Author mixed material 9780300035810 London Yale University Press 1984 410vI%2BGrRcL._SX326_BO1%2C204%2C203%2C200_.jpg.jpg