Everybody knows that thanks to a little acorn we will be able to have over the years a majestic and age-old Oak tree.
People assume climate change. Also have knowledge about the detrimental effects of hundreds of chemical compounds around us. So, where is all this leading?
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-03-20' AND n.activo=1 AND cn.activo=1 GROUP BY n.idCategoria ORDER BY cn.prioridad, cn.categoriaEN