text: SELECT causes.name,  words.* 
  FROM (
  	SELECT com.causes_id, com.community 
  	FROM giving.nonprofits_communities_by_description as com 
  		JOIN giving.nonprofits as non on com.nonprofits_id = non.nonprofits_id
  	WHERE non.ein = 'XX-XXXXXXX'  
  ) as my_table
  
  JOIN giving.nonprofits_communities_by_description_words as words
  	on my_table.causes_id = words.causes_id and my_table.community = words.community 
  LEFT JOIN  giving.causes as causes 	on causes.causes_id = my_table.causes_id