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

Category: Productivity Index of Articles only

";
id Rvw artid file title description art_title
228[rvw] [art:5] [campaigns/7886452_clarity-first-october-23-2020-218.html] Clarity First, October 23, 2020, #218 The future you are dreaming. Oops. It seems that the neutral colors that most of choose for our homes' walls don't make for great workspaces.
CONTENT
285[rvw] [art:6] [campaigns/7927084_love-work-november-12-2021-272.html] Love & Work, November 12, 2021, #272 Even a wounded world holds us. The design of our calendars is a reflection of how we aspire to live our lives.
CONTENT