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 '%Cities%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
11 1 20 Temporary and tactical urbanism : (Re)assembling urban space Stevens, Quentin Primary Author mixed material 9781032256535 New York Routledge 2023 115166427465c046a54861a4.23147289.jpg Emergent Tokyo : designing the spontaneous city Almazán, Jorge Primary Author mixed material 9781951541323 California ORO Editions 2022 135523278765c0aca225c913.09684924.jpg The 99% invisible city : a field guide to the hidden world of everyday design Mars, Roman Primary Author Kohlstedt, Kurt Primary Author mixed material 9781529355277 London Hodder et Stoughton 2020 528767304627b6137514fc1.81641347.jpg Public spaces and urbanity : how to design humane cities Pålsson, Karsten Primary Author mixed material 9783869226149 Berlin DOM Publishers 2018 9783869226149.gif.gif The syntax of city space : American urban grids Major, Mark Primary Author mixed material 9781138301573 London Routledge 2018 125681001461ef6c55d56c41.11892915.jpg How to read towns & cities : a crash course in urban architecture Glancey, jonathan Primary Author mixed material 9781474219266 London Bloomsbury Visual Arts 2016 how_to_read_towns.gif.gif Urban theory and the urban experience : encountering the city Parker, Simon Primary Author mixed material 9780415520706 London Routledge 2015 %2B-%2B807789634_140.gif.gif The morphology of the times : European cities and their historical growth Hinse, Ton Primary Author mixed material 9783869223094 Berlin DOM Publishers 2014 9783869223094.gif.gif Urban sketching : the complete guide to techniques Thorspecken, Thomas Primary Author mixed material 9781438003412 Hauppauge, NY Barron's 2014 120379423466824c3c8b38f3.35929774.jpg The city shaped : urban patterns and meanings through history Kostof, Spiro Primary Author Tobias, Richard Primary Author mixed material 9780500280997 London Thames & Hudson 2009 9780500280997.gif.gif Ekistics; an Introduction to the Science of Human Settlements Doxiadēs Primary Author mixed material 9780090803002 New York Oxford University Press 1968 61E2L0WHz2L._SX258_BO1%2C204%2C203%2C200_.jpg.jpg