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

Category: Philanthropic Effectiveness Index of Articles only

";
id Rvw artid file title description art_title
132[rvw] [art:6] [campaigns/7559831_clarity-first-january-4-2019-125.html] Clarity First, January 4, 2019, #125 Defeating the enemy of creativity Foundations need to be more open to grant requests that aim to improve organizational health and capacity building at nonprofits.
CONTENT
147[rvw] [art:7] [campaigns/7613783_clarity-first-april-19-2019-139.html] Clarity First, April 19, 2019, #139 Great minds are concerned with the ordinary. Funding practices continue to stymie innovation, and three other things nonprofit leaders wish more people knew
CONTENT