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

Category: Industry Index of Articles only

";
id Rvw artid file title description art_title
193[rvw] [art:6] [campaigns/7718363_clarity-first-february-21-2020-183.html] Clarity First, February 21, 2020 #183 My country is the whole world.aEUR Merging traditional Japanese craftwork with bicycle-making
CONTENT
359[rvw] [art:5] [campaigns/9121257_love-work-april-14-2023-346.html] Love & Work, April 14, 2023, #346 Choose to liberate the future. A library of materials that facilitate “an ecologically mindful approach to material choices”
CONTENT
374[rvw] [art:6] [campaigns/9158454_love-work-july-28-2023-361.html] Love & Work, July 28, 2023, #361 What you hope for How a 19th-century shoe-making technology was adapted to mass produce toothpicks
CONTENT