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

Category: Communications Strategy Index of Articles only

";
id Rvw artid file title description art_title
117[rvw] [art:1] [campaigns/7417335_clarity-first-september-21-2018-110.html] Clarity First, September 21, 2018, #110 We need to learn as fast as the world changes. Sustainability is the new black.
CONTENT
132[rvw] [art:4] [campaigns/7559831_clarity-first-january-4-2019-125.html] Clarity First, January 4, 2019, #125 Defeating the enemy of creativity Nearly two-thirds of consumers want businesses to take a stand on cultural, environmental or political issues. And taking a stance on a social issue is risky. But comedians have been doing it forever.
CONTENT
161[rvw] [art:7] [campaigns/7647295_clarity-first-july-26-2019-153.html] Clarity First, July 26, 2019 #153 A permission slip to be lazy Nonprofits must achieve better engagement or the causes they care about will be at risk.
CONTENT