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

Category: Work Index of Articles only

";
id Rvw artid file title description art_title
257[rvw] [art:6] [campaigns/7907919_clarity-first-april-30-2021-244.html] Clarity First, April 30, 2021, #244 How the world changes How manners will change when working life returns
CONTENT
328[rvw] [art:5] [campaigns/9049381_love-work-september-9-2022-315.html] Love & Work, September 9, 2022, #315 The passport to the future Reinventing the hotel room in Tokyo
CONTENT