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

Category: Collective Action Index of Articles only

";
id Rvw artid file title description art_title
231[rvw] [art:1] [campaigns/7889064_clarity-first-november-13-2020-221.html] Clarity First, November 13, 2020, #221 It's going OK. (The Hope Issue) John Lewis tells a story from his childhood to describe his vision of how we can face profound challenges and make a better world.
CONTENT