@omoloc
select max(a.votes_tot), a.date_pub, b.title, a.user from infoportada a, portada_contenido b where a.date_pub > '2024-01-01' and a.date_pub < '2025-03-31' and a.id = b.id ;
+------------------+------------+----------------------------------------------------------+------------+
| max(a.votes_tot) | date_pub | title | user |
+------------------+------------+----------------------------------------------------------+------------+
| 1684 | 2024-01-02 | Carlos Taibo, ¿qué es ser anarquista y libertario hoy? | --365186-- |
+------------------+------------+----------------------------------------------------------+------------+

select max(a.votes_tot), a.date_pub, b.title, a.user from infoportada a, portada_contenido b where a.date_pub > '2011-01-01' and a.date_pub < '2011-12-31' and a.id = b.id ;
+------------------+------------+-----------------------------------------------------------------+-------+
| max(a.votes_tot) | date_pub | title | user |
+------------------+------------+-----------------------------------------------------------------+-------+
| 9207 | 2011-01-02 | Balleneros japoneses se enfrentan a activistas en la Antártida | Ripio |
+------------------+------------+-----------------------------------------------------------------+-------+