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

Category: Values Index of Articles only


";
id Rvw artid file title description art_title
126[rvw] [art:1] [campaigns/7452751_clarity-first-november-23-2018-119.html] Clarity First, November 23, 2018, #119 I want to be a hero to Fred Rogers. We need Mr. Rogers now, more than ever. The good news is that NPR has some tape.
CONTENT
143[rvw] [art:1] [campaigns/7597623_clarity-first-march-22-2019-135.html] Clarity First, March 22, 2019, #135 Conflicting loyalties are deep in our nature
CONTENT
151[rvw] [art:3] [campaigns/7624775_clarity-first-may-17-2019-143.html] Clarity First, May 17, 2019, #143 Let's do it right. This is for the ages. The importance of a clear, socially useful mission.
CONTENT
159[rvw] [art:4] [campaigns/7644811_clarity-first-july-12-2019-151.html] Clarity First, July 12, 2019 #151 Remix. Innovation combines old things to make new. Company purpose that matters.
CONTENT
173[rvw] [art:4] [campaigns/7673623_clarity-first-october-4-2019-163.html] Clarity First, October 4, 2019 #163 There's a bit of magic in everything... To truly benefit from innovation, humanitarian organizations need to regard innovation as a set of values that runs through all of their practices.
CONTENT