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

Category: Collective Vision Index of Articles only

";
id Rvw artid file title description art_title
241[rvw] [art:4] [campaigns/7899336_clarity-first-test.html] Clarity First, test It's time to do what is right. Imagining a better future, whether it includes gigantic house parties or just more hugs, helps humans cope with difficult times.
CONTENT
242[rvw] [art:4] [campaigns/7899420_clarity-first-january-22-2021-231-test-.html] Clarity First, January 22, 2021, #231 (test) It's time to do what is right. Imagining a better future, whether it includes gigantic house parties or just more hugs, helps humans cope with difficult times.
CONTENT
243[rvw] [art:4] [campaigns/7899236_clarity-first-january-22-2021-231.html] Clarity First, January 22, 2021, #231 It's time to do what is right. Imagining a better future whether it includes gigantic house parties or just more hugs, helps humans cope with difficult times.
CONTENT