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

Category: Socially Conscious Companies Index of Articles only

";
id Rvw artid file title description art_title
95[rvw] [art:3] [campaigns/7355483_clarity-first-april-20-2018-88.html] Clarity First, April 20, 2018, #88 You're not as alone as you thought. “Now there is choice. Change can happen.”
CONTENT
104[rvw] [art:1] [campaigns/7384823_clarity-first-june-22-2018-97.html] Clarity First, June 22, 2018, #97 We all need your voice about now. Major companies who are taking a stand against an atrocity
CONTENT
104[rvw] [art:2] [campaigns/7384823_clarity-first-june-22-2018-97.html] Clarity First, June 22, 2018, #97 We all need your voice about now. Major companies who are taking a stand against an atrocity
CONTENT
105[rvw] [art:4] [campaigns/7390051_clarity-first-june-29-2018-98.html] Clarity First, June 29, 2018, #98 I want to be a force for real good. Why climate change is a board-relevant issue, when climate change should fall within their mandate, and how they can oversee climate-related risks and opportunities.
CONTENT