SELECT 
  category 
FROM 
  category_descriptions cd 
  LEFT JOIN categories c ON c.category_id = cd.category_id 
WHERE 
  id_path LIKE "%/6790/%" 
  OR id_path LIKE "6790/%"