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

Category: Brand Communications Index of Articles only

";
id Rvw artid file title description art_title
179[rvw] [art:5] [campaigns/7686807_clarity-first-november-15-2019-169.html] Clarity First, November 15, 2019 #169 Human community is an organization's most important asset.
CONTENT
197[rvw] [art:10] [campaigns/7728475_clarity-first-march-20-2020-187.html] Clarity First, March 20, 2020 #187 aEURoeKindness eases change.Love quiets fear. The latest moves brands are making to deal with the fallout of coronavirus.
CONTENT
374[rvw] [art:7] [campaigns/9158454_love-work-july-28-2023-361.html] Love & Work, July 28, 2023, #361 What you hope for How to sell a computer to people who wonder if they could ever use a computer.
CONTENT