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 = 'Public Space') and (art.category = 'Public Space') and (c.id = cat.emailid) and (c.id = art.emailid) GROUP BY c.id, artid

Category: Public Space Index of Articles only

";
id Rvw artid file title description art_title
129[rvw] [art:4] [campaigns/7470543_clarity-first-december-14-2018-122.html] Clarity First, December 14, 2018, #122 Economic development and social justice There’s an emerging body of research that shows that our surroundings have a profound influence on our well-being and performance.
CONTENT
344[rvw] [art:6] [campaigns/9083565_love-work-december-30-2022-331.html] Love & Work, December 30, 2022, #331 The horizon leans forward Turning the focus from the buildings that house the shopping to the people who do the shopping
CONTENT