Как вывести значения сколько новостей и в какие категории публиковал пользователь в его профиле?

SELECT category_id, autor, COUNT(*) as news_count FROM (

SELECT 

id,

autor,

SUBSTRING_INDEX(SUBSTRING_INDEX(t.category, ',', n.n), ',', -1) category_id

  FROM dle_post t CROSS JOIN 
  (
   SELECT a.N + b.N * 10 + 1 n
     FROM 
    (
    SELECT 0 AS N 
	UNION ALL SELECT 1 
	UNION ALL SELECT 2 
	UNION ALL SELECT 3 
	UNION ALL SELECT 4 
	UNION ALL SELECT 5 
	UNION ALL SELECT 6 
	UNION ALL SELECT 7 
	UNION ALL SELECT 8 
	UNION ALL SELECT 9
	) a,
    (
    SELECT 0 AS N 
	UNION ALL SELECT 1 
	UNION ALL SELECT 2 
	UNION ALL SELECT 3 
	UNION ALL SELECT 4 
	UNION ALL SELECT 5 
	UNION ALL SELECT 6 
	UNION ALL SELECT 7 
	UNION ALL SELECT 8 
	UNION ALL SELECT 9
	) b
    ORDER BY n 
   ) n

 WHERE n.n <= 1 + (LENGTH(t.category) - LENGTH(REPLACE(t.category, ',', ''))) AND  autor = 'admin'

 ORDER BY id, category_id

) post_autor_cats

GROUP BY category_id