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

Category: Transitions Index of Articles only

";
id Rvw artid file title description art_title
207[rvw] [art:1] [campaigns/7845768_clarity-first-may-29-2020-197.html] Clarity First, May 29, 2020 #197 Imagine not a calamity, but a great awakening. 'As always, we have a world to build.'
CONTENT
216[rvw] [art:1] [campaigns/7875140_clarity-first-july-31-2020-206.html] Clarity First, July 31, 2020, #206 Unleashing our intelligence, ingenuity and solidarity Joanna Macy on the transition to a life-sustaining society
CONTENT
219[rvw] [art:1] [campaigns/7877904_clarity-first-august-21-2020-209.html] Clarity First, August 21, 2020, #209 It's time for a new dream. Only 9% of Britts long for a 'return to normal'.
CONTENT