SELECT id_article, tipus FROM articles WHERE tipus IN ('noticia', 'entrevista') AND estat = 'actiu' AND UNIX_TIMESTAMP(data) < 1749991200 AND UNIX_TIMESTAMP( data ) > 1749904808 ORDER BY lectures DESC LIMIT 4SELECT id_article, tipus FROM articles WHERE tipus IN ('noticia', 'entrevista') AND estat = 'actiu' AND UNIX_TIMESTAMP( data ) < 1749991200 ORDER BY data DESC LIMIT 4SELECT DISTINCT id_article FROM comentaris WHERE lloc = 'article' AND estat = 'actiu' ORDER BY data DESC LIMIT 5SELECT id_article FROM articles WHERE tipus = 'entrevista' AND estat = 'actiu' AND UNIX_TIMESTAMP( data ) < 1749991200 ORDER BY data DESC LIMIT 1SELECT COUNT(*) AS etiquetes FROM etiquetes WHERE etiquetes.data > FROM_UNIXTIME( '1741351209' ) AND etiquetes.data < FROM_UNIXTIME(1749991200) GROUP BY etiqueta ORDER BY etiquetes DESC LIMIT 1SELECT etiqueta, COUNT(*) as count FROM etiquetes WHERE etiquetes.data > FROM_UNIXTIME( '1741351209' ) AND etiquetes.data < FROM_UNIXTIME(1749991200) GROUP BY etiqueta ORDER BY count DESC LIMIT 25SELECT id_article, id_auxiliar, tipus FROM articles WHERE estat = 'actiu' AND tipus IN ('opinio', 'editorial') AND data < NOW() ORDER BY data DESC LIMIT 25SELECT id_galeria_imatge FROM galeries_imatges a, galeries b WHERE a.portada = 'si' AND a.id_galeria = b.id_galeria AND b.estat = 'actiu' AND a.estat = 'actiu' GROUP BY a.id_galeria ORDER BY b.data DESC LIMIT 2SELECT id_video FROM videos WHERE llistat = 'si' AND estat = 'actiu' AND UNIX_TIMESTAMP( data ) < 1749991200 ORDER BY ordre DESC LIMIT 2SELECT id_article, titol, titol_portada, titol_twitter, id_auxiliar, auxiliar, uri, contingut, lloc, multimedia, UNIX_TIMESTAMP( data ) AS data, UNIX_TIMESTAMP( data_modificacio ) AS data_modificacio, id_pare, id_usuari, lectures, ordre, estat FROM articles WHERE id_article = 1662872SELECT titol, uri FROM categories WHERE portada = 'true' AND estat = 'actiu' ORDER BY ordre DESCSELECT titol, uri FROM municipis ORDER BY titol ASCArticle no trobat - El Gerió Digital
