SELECT SQL_CALC_FOUND_ROWS wp8i_posts.*
FROM wp8i_posts INNER JOIN wp8i_postmeta ON ( wp8i_posts.ID = wp8i_postmeta.post_id ) INNER JOIN wp8i_postmeta AS mt1 ON ( wp8i_posts.ID = mt1.post_id ) INNER JOIN wp8i_postmeta AS mt2 ON ( wp8i_posts.ID = mt2.post_id ) INNER JOIN wp8i_postmeta AS mt3 ON ( wp8i_posts.ID = mt3.post_id ) INNER JOIN wp8i_postmeta AS mt4 ON ( wp8i_posts.ID = mt4.post_id )
WHERE 1=1 AND (
(
wp8i_postmeta.meta_key = 'mes'
AND
mt1.meta_key = 'anio'
)
AND
(
(
( mt2.meta_key = 'mes' AND CAST(mt2.meta_value AS SIGNED) >= '05' )
AND
( mt3.meta_key = 'anio' AND CAST(mt3.meta_value AS SIGNED) = '2025' )
)
OR
( mt4.meta_key = 'anio' AND CAST(mt4.meta_value AS SIGNED) > '2025' )
)
) AND ((wp8i_posts.post_type = 'agenda' AND (wp8i_posts.post_status = 'publish' OR wp8i_posts.post_status = 'acf-disabled')))
GROUP BY wp8i_posts.ID
ORDER BY CAST(mt1.meta_value AS CHAR) ASC, CAST(wp8i_postmeta.meta_value AS CHAR) ASC
LIMIT 0, 4