AGENDA

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