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

Category: Brand Promise Index of Articles only

";
id Rvw artid file title description art_title
179[rvw] [art:4] [campaigns/7686807_clarity-first-november-15-2019-169.html] Clarity First, November 15, 2019 #169 Human community is an organization's most important asset. Sephora CMO Deborah Yeh on how the beauty retailer is walking the walk when it comes to diversity
CONTENT
190[rvw] [art:4] [campaigns/7711163_clarity-first-january-31-2020-180.html] Clarity First, January 31, 2020 #180 The passport to the future Big box, big responsibility
CONTENT