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

Category: Resources Index of Articles only

";
id Rvw artid file title description art_title
173[rvw] [art:7] [campaigns/7673623_clarity-first-october-4-2019-163.html] Clarity First, October 4, 2019 #163 There's a bit of magic in everything... This gives “stock” photography a whole new meaning.
CONTENT
187[rvw] [art:5] [campaigns/7704347_clarity-first-january-10-2020-177.html] Clarity First, January 10, 2020 #177 Ignorance is the root of all evil. A list of Jeff Brooks' favorite fundraising blogs
CONTENT
187[rvw] [art:6] [campaigns/7704347_clarity-first-january-10-2020-177.html] Clarity First, January 10, 2020 #177 Ignorance is the root of all evil. A list of Jeff Brooks' favorite fundraising blogs
CONTENT
386[rvw] [art:4] [campaigns/9183529_love-work-october-20-2023-373.html] Love & Work, October 20, 2023, #373 Finding the courage to dream Finally, the Whole Earth Catalog and its descendants - over 130 publications - are now available online.
CONTENT