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

Category: Place Index of Articles only

";
id Rvw artid file title description art_title
125[rvw] [art:4] [campaigns/7445323_clarity-first-november-16-2018-118.html] Clarity First, November 16, 2018, #118 Learning from Aretha and the Metropolitan Opera I love you California
CONTENT
127[rvw] [art:4] [campaigns/7454867_clarity-first-november-30-2018-120.html] Clarity First, November 30, 2018, #120 The ultimate inspiration
CONTENT
271[rvw] [art:1] [campaigns/7918360_clarity-first-august-6-2021-258.html] Clarity First, August 6, 2021, #258 Nature is party to all our deals and decisions. A lover of place pushes against the unraveling of America.
CONTENT
477[art:7] [campaigns/10338821_love-work-may-30-2025-462.html] Love & Work, May 30, 2025, #462 Knowledge needs to keep moving The historical landscape ecology of New York City
CONTENT