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

Category: Social Progress Index of Articles only


";
id Rvw artid file title description art_title
115[rvw] [art:1] [campaigns/7416947_clarity-first-september-7-2018-108.html] Clarity First, September 7, 2018, #108 We all agree on Aretha. How to enable cross-sector partnerships to help address our most important societal challenges.
CONTENT
119[rvw] [art:3] [campaigns/7429479_clarity-first-october-5-2018-112.html] Clarity First, October 5, 2018, #112 How to make a better future. “Advertising should not only be used to sell a product, influence a choice, or build loyalty to a brand. It can and should also be a force for good.”
CONTENT
120[rvw] [art:6] [campaigns/7432539_clarity-first-october-12-2018-113.html] Clarity First, October 12, 2018, #113 Why our heads are round How families are the unit of change and the source of leadership that our country needs
CONTENT
122[rvw] [art:1] [campaigns/7438699_clarity-first-october-26-2018-115.html] Clarity First, October 26, 2018, #115 Maybe we're thinking too hard. Let's play instead. For the best public decision making, harness the best in collective intelligence tools.
CONTENT
133[rvw] [art:2] [campaigns/7562019_clarity-first-january-11-2019-126.html] Clarity First, January 11, 2019, #126 Wait a minute...we're smarter than this. “As we now face a global dearth of alternative political ideas, perhaps it’s no wonder we are turning again to the Mahatma for inspiration.”
CONTENT
143[rvw] [art:6] [campaigns/7597623_clarity-first-march-22-2019-135.html] Clarity First, March 22, 2019, #135 Conflicting loyalties are deep in our nature In just a few decades, GLBT+ rights moved from the margins to the mainstream. Here's why.
CONTENT