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

Category: Audience Segmentation Index of Articles only

";
id Rvw artid file title description art_title
111[rvw] [art:6] [campaigns/7406019_clarity-first-august-10-2018-104.html] Clarity First, August 10, 2018, #104 Perfect is boring. Imperfect is honest. Advertising demos ‘are not a good indicator of what people like to watch’.
CONTENT
220[rvw] [art:5] [campaigns/7878828_clarity-first-august-28-2020-210.html] Clarity First, August 28, 2020, #210 Chance favors the connected mind. How to identify what makes a great client so fulfilling to work with.
CONTENT