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

Category: Promotion Index of Articles only

";
id Rvw artid file title description art_title
245[rvw] [art:4] [campaigns/7900048_clarity-first-february-5-2021-233.html] Clarity First, February 5, 2021, #233 Heaven is under our feet. In order to support French potato farmers who can no longer sell their produce due to restaurant closures across France, Burger King is giving away bags of potatoes with every visit to a drive-thru.
CONTENT