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

Category: Brand Extension Index of Articles only

";
id Rvw artid file title description art_title
228[rvw] [art:7] [campaigns/7886452_clarity-first-october-23-2020-218.html] Clarity First, October 23, 2020, #218 The future you are dreaming. Some of corporate America’s biggest ‘what were they thinking?’ moments
CONTENT
232[rvw] [art:7] [campaigns/7890036_clarity-first-november-20-2020-222.html] Clarity First, November 20, 2020, #222 To invent what we desire Pizza is a comfort food. Then of course it should be a weighted blanket, too.
CONTENT