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

Category: Data Display Index of Articles only

";
id Rvw artid file title description art_title
180[rvw] [art:1] [campaigns/7689291_clarity-first-november-22-2019-170.html] Clarity First, November 22, 2019 #170 We are all dreamers creating the next world. 'Amazing things are happening in the world, thanks to human ingenuity, endeavor and collaboration.'
CONTENT
180[rvw] [art:4] [campaigns/7689291_clarity-first-november-22-2019-170.html] Clarity First, November 22, 2019 #170 We are all dreamers creating the next world. 'Amazing things are happening in the world, thanks to human ingenuity, endeavor and collaboration.'
CONTENT