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

Category: Long Term Thinking Index of Articles only

";
id Rvw artid file title description art_title
252[rvw] [art:1] [campaigns/7906343_clarity-first-march-26-2021-234.html] Clarity First, March 26, 2021, #234 You have to find the important. An open call to creatives to solve our planet’s problem with waste
CONTENT
252[rvw] [art:3] [campaigns/7906343_clarity-first-march-26-2021-234.html] Clarity First, March 26, 2021, #234 You have to find the important. An open call to creatives to solve our planet’s problem with waste
CONTENT