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

Category: Advertising Practice Index of Articles only

";
id Rvw artid file title description art_title
151[rvw] [art:7] [campaigns/7624775_clarity-first-may-17-2019-143.html] Clarity First, May 17, 2019, #143 Let's do it right. This is for the ages. As brands become more purpose-driven, espousing values around equality and social justice in their advertising, shouldn’t their media spend be equally ethical?
CONTENT