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

Category: Email Marketing Index of Articles only

";
id Rvw artid file title description art_title
187[rvw] [art:5] [campaigns/7704347_clarity-first-january-10-2020-177.html] Clarity First, January 10, 2020 #177 Ignorance is the root of all evil. Boost opens and conversion rates with content and elements users want to see.
CONTENT
191[rvw] [art:7] [campaigns/7713527_clarity-first-february-7-2020-181.html] Clarity First, February 7, 2020 #181 Flee from hate, mischief and jealousy. Learning from the masters
CONTENT