Investigação Científica
CENTROS FCT
CENTROS FCT PARTILHADOS
POLOS NA UMa DE CENTROS FCT
OUTROS CENTROS
SELECT wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) INNER JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) INNER JOIN wp_postmeta AS mt5 ON ( wp_posts.ID = mt5.post_id )
WHERE 1=1 AND wp_posts.ID NOT IN (1656,1714,1726,1770,1771,1772,1773,1774,1775,2061,2062,2064,2065,2066,2067,2307,10680,18638,20814,24290,24547,26735) AND (
wp_postmeta.meta_key = 'noticia_ordem'
AND
(
( mt1.meta_key = 'noticia_tipo' AND mt1.meta_value LIKE '{301ea3e570dba8095cbf7206b4970654f2ace9d1749f6cab742941958715686e}:\"noticia\";{301ea3e570dba8095cbf7206b4970654f2ace9d1749f6cab742941958715686e}' )
AND
( mt2.meta_key = 'noticia_localizacao_navegacao' AND mt2.meta_value LIKE '{301ea3e570dba8095cbf7206b4970654f2ace9d1749f6cab742941958715686e}:\"investigacao\";{301ea3e570dba8095cbf7206b4970654f2ace9d1749f6cab742941958715686e}' )
AND
mt3.meta_key = 'noticia_ordem'
AND
mt4.meta_key = 'noticia_data_publicacao'
AND
( mt5.meta_key = 'noticia_data_publicacao' AND mt5.meta_value <= '20260908' )
)
) AND ((wp_posts.post_type = 'noticia' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
GROUP BY wp_posts.ID
ORDER BY CAST(mt3.meta_value AS CHAR) DESC, CAST(mt4.meta_value AS CHAR) DESC
LIMIT 0, 3