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

Category: Brand Messaging Index of Articles only

";
id Rvw artid file title description art_title
203[rvw] [art:5] [campaigns/7838384_clarity-first-may-1-2020-193.html] Clarity First, May 1, 2020 #193 The future is not some place we are going, but one we are creating.
CONTENT
388[rvw] [art:6] [campaigns/9191565_love-work-november-3-2023-375.html] Love & Work, November 3, 2023, #375 Melancholy and utopia The truth is a very powerful marketing tool.
CONTENT