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

Category: Sustainable Disruption Index of Articles only

";
id Rvw artid file title description art_title
153[rvw] [art:2] [campaigns/7629799_clarity-first-may-31-2019-145.html] Clarity First, May 31, 2019, #145 Great minds are concerned with the ordinary. We are at a crossroads. If we are to address climate change, let alone our broader sustainability challenges, we need significantly disruptive innovation across a wide number of sectors.
CONTENT