SELECT 
  imp.impact_id, 
  pid.name 
FROM 
  cscart_positive_impacts AS imp 
  LEFT JOIN cscart_positive_impact_descriptions AS pid ON pid.impact_id = imp.impact_id 
  AND pid.lang_code = 'es' 
  LEFT JOIN cscart_company_positive_impacts AS cpi ON cpi.impact_id = imp.impact_id 
  LEFT JOIN cscart_products AS pro ON pro.company_id = cpi.company_id 
  LEFT JOIN cscart_products_categories AS pca ON pca.product_id = pro.product_id 
WHERE 
  1 
  AND imp.status = 'A' 
  AND imp.impact_id IN (
    SELECT 
      DISTINCT impact_id 
    FROM 
      cscart_company_positive_impacts
  ) 
GROUP BY 
  imp.impact_id