AGENDA

SELECT SQL_CALC_FOUND_ROWS  wp8i_posts.ID 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) >= '04' ) 
      AND 
      ( mt3.meta_key = 'anio' AND CAST(mt3.meta_value AS SIGNED) = '2020' )
    ) 
    OR 
    ( mt4.meta_key = 'anio' AND CAST(mt4.meta_value AS SIGNED) > '2020' )
  )
) AND wp8i_posts.post_type = 'agenda' AND (wp8i_posts.post_status = 'publish') 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

Simulación en Soporte Vital Avanzado

Calle 57 N° 1228, La Plata

La jornada de RCP avanzada se basa en las habilidades del soporte vital básico para profesionales de la salud, con especial énfasis en la importanci...