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

Category: Deception Index of Articles only

";
id Rvw artid file title description art_title
217[rvw] [art:4] [campaigns/7875816_clarity-first-august-7-2020-207.html] Clarity First, August 7, 2020, #207 This is no time for complacency or despair. Through deceptive designs known as “dark patterns,” online retailers try to nudge you toward purchases you wouldn’t otherwise make.
CONTENT