Categories

Error en:

SELECT DISTINCT cn.categoriaEN, cn.nombrepaginaEN, count(idCategoria) as cuantos FROM noticias_cat cn INNER JOIN noticias n ON cn.id=n.idCategoria WHERE n.fecha<='2023-05-31' AND n.activo=1 AND cn.activo=1 GROUP BY n.idCategoria ORDER BY cn.prioridad, cn.categoriaEN


Expression #1 of ORDER BY clause is not in SELECT list, references column 'qvk152.cn.prioridad' which is not in SELECT list; this is incompatible with DISTINCT