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

Category: Architecture Index of Articles only

";
id Rvw artid file title description art_title
163[rvw] [art:2] [campaigns/7653343_clarity-first-august-9-2019-155.html] Clarity First, August 9, 2019 #155 In reality, the world needs servants, not leaders. 'There are not two sides defined by a wall. This is one landscape, divided.”
CONTENT
183[rvw] [art:4] [campaigns/7697839_clarity-first-december-13-2019-173.html] Clarity First, December 13, 2019 #173 The person more qualified to lead... Exploring the ways in which a more equitable society is achieved through thoughtful–and intentional–design.
CONTENT
285[rvw] [art:4] [campaigns/7927084_love-work-november-12-2021-272.html] Love & Work, November 12, 2021, #272 Even a wounded world holds us. Four examples of the ability for architecture to spark joy.
CONTENT
438[rvw] [art:5] [campaigns/10330589_love-work-august-16-2024-424.html] Love & Work, August 16, 2024, #424 Imagining what can be found Embracing emotion as function, and two other ways to shatter the 'architectural blandemic'
CONTENT