Categorías

Error en:

SELECT DISTINCT cn.categoriaES, cn.nombrepaginaES, count(idCategoria) as cuantos FROM noticias_cat cn INNER JOIN noticias n ON cn.id=n.idCategoria WHERE n.fecha<='2024-10-10' AND n.activo=1 AND cn.activo=1 GROUP BY n.idCategoria ORDER BY cn.prioridad, cn.categoriaES


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