SQL=SELECT DISTINCT c.id, artid, file, title, description, cat.art_title FROM campaigns as c, catbyid as cat, artbyid as art WHERE (cat.category = 'Urbanism') and (art.category = 'Urbanism') and (c.id = cat.emailid) and (c.id = art.emailid) GROUP BY c.id, artid

Category: Urbanism Index of Articles only


";
id Rvw artid file title description art_title
252[rvw] [art:2] [campaigns/7906343_clarity-first-march-26-2021-234.html] Clarity First, March 26, 2021, #234 You have to find the important. Imagine that public space put the ideas of the artist at its center.
CONTENT
256[rvw] [art:3] [campaigns/7907911_clarity-first-april-23-2021-243.html] Clarity First, April 23, 2021, #243 How to move a mountain Visualizations for turning famous urban areas eco-friendly
CONTENT
267[rvw] [art:1] [campaigns/7907956_clarity-first-july-9-2021-254.html] Clarity First, July 9, 2021, #254 The miraculous is not extraordinary, but the common ... The lost cities of the ancient tropics have a lot to teach us about how to live alongside nature.
CONTENT
301[rvw] [art:3] [campaigns/8986757_love-work-march-4-2022-288.html] Love & Work, March 4, 2022, #288 The privilege of human beings There is often more biodiversity in cities than in nature reserves and the protected areas outside them.
CONTENT
319[rvw] [art:1] [campaigns/9032313_love-work-july-8-2022-306.html] Love & Work, July 8, 2022, #306 It is art and life that feed us until we die. The lost cities of the ancient tropics have a lot to teach us about how to live alongside nature.
CONTENT
324[rvw] [art:4] [campaigns/9041889_love-work-august-12-2022-311.html] Love & Work, August 12, 2022, #311 The wonders and realities of the universe. 'Urban density was once seen as a sign of unhealthiness and poverty. But today it is necessary to make cities sustainable.'
CONTENT
325[rvw] [art:5] [campaigns/9043037_love-work-august-19-2022-312.html] Love & Work, August 19, 2022, #312 A chance to begin again Green, friendly and clean: how we could reimagine urban life after the pandemic.
CONTENT
336[rvw] [art:3] [campaigns/9065585_love-work-november-4-2022-323.html] Love & Work, November 4, 2022, #323 Change is made of choices. The city of tomorrow is a remodel, not a rebuild. It is something we will evolve toward, sometimes in small and incremental steps.
CONTENT