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

Category: Ecological Thinking Index of Articles only

";
id Rvw artid file title description art_title
127[rvw] [art:1] [campaigns/7454867_clarity-first-november-30-2018-120.html] Clarity First, November 30, 2018, #120 The ultimate inspiration Awareness that humanity is on a path to self-imposed environmental and social collapse as a source of hope
CONTENT
133[rvw] [art:1] [campaigns/7562019_clarity-first-january-11-2019-126.html] Clarity First, January 11, 2019, #126 Wait a minute...we're smarter than this. This is freaky, right?
CONTENT