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

Category: Solarpunk Index of Articles only

";
id Rvw artid file title description art_title
301[rvw] [art:2] [campaigns/8986757_love-work-march-4-2022-288.html] Love & Work, March 4, 2022, #288 The privilege of human beings What might the future look like if humanity could figure out how to solve our problems by making sustainability a primary criteria?
CONTENT
340[rvw] [art:1] [campaigns/9073865_love-work-december-2-2022-327.html] Love & Work, December 2, 2022, #327 Finding the courage to dream How the aesthetic, utopian yet pragmatic movement of Solarpunk reimagines a future without a climate catastrophe
CONTENT