@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 |
+------------------+------------+-----------------------------------------------------------------+-------+
2k 34
Hemos deshabilitado la autenticación con Facebook. Si entras a Mediatize con una cuenta de Facebook, lee esto.
En los periodos que propones,
MariaDB [mnm]> select max(a.votes_tot) from infoportada a where a.date_pub > '2011-01-01' and a.date_pub < '2011-12-31' ;
+------------------+
| max(a.votes_tot) |
+------------------+
| 9207 |
+------------------+
1 row in set (0,045 sec)
MariaDB [mnm]> select max(a.votes_tot) from infoportada a where a.date_pub > '2024-01-01' and a.date_pub < '2025-03-31' ;
+------------------+
| max(a.votes_tot) |
+------------------+
| 1684 |
+------------------+
La noticia que más votos tiene en meneame es esta:
MariaDB [mnm]> select max(a.votes_tot), a.user, b.title, a.date_pub from infoportada a , portada_contenido b where a.id =
b.id ;
+------------------+------+---------------------------+------------+
| max(a.votes_tot) | user | title | date_pub |
+------------------+------+---------------------------+------------+
| 11559 | maty | ¡Muera la Constitución! | 2005-12-10 |
+------------------+------+---------------------------+------------+