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

Category: Self Promotion Index of Articles only

";
id Rvw artid file title description art_title
237[rvw] [art:3] [campaigns/7896092_clarity-first-december-25-227.html] Clarity First, December 25, #227 No work today A F*ck You for a Cause
CONTENT
261[rvw] [art:6] [campaigns/7907935_clarity-first-may-28-2021-248.html] Clarity First, May 28, 2021, #248 Treasure your exceptions. How a self-taught designer uses his own insight and honesty to attract followers and clients
CONTENT
261[rvw] [art:7] [campaigns/7907935_clarity-first-may-28-2021-248.html] Clarity First, May 28, 2021, #248 Treasure your exceptions. How a self-taught designer uses his own insight and honesty to attract followers and clients
CONTENT
304[rvw] [art:7] [campaigns/8995389_love-work-march-25-2022-291.html] Love & Work, March 25, 2022, #291 Respect takes individual effort. The FBI created a document to help it translate and monitor slang on the internet. Pentagram New York turned it into an annual holiday gift.
CONTENT
353[rvw] [art:7] [campaigns/9103565_love-work-march-3-2023-340.html] Love & Work, March 3, 2023, #340 We are all crew. An unlikely collaboration between a Fortune 500 company and a Pulitzer Prize-winning poet makes a terrific holiday greeting.
CONTENT