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

Category: Social Listening Index of Articles only

";
id Rvw artid file title description art_title
115[rvw] [art:6] [campaigns/7416947_clarity-first-september-7-2018-108.html] Clarity First, September 7, 2018, #108 We all agree on Aretha. Social listening helps brands understand their customers as humans first and consumers second.
CONTENT