Publicaciones
SELECT dxsjj_posts.* FROM dxsjj_posts LEFT JOIN dxsjj_postmeta ON ( dxsjj_posts.ID = dxsjj_postmeta.post_id ) LEFT JOIN dxsjj_postmeta AS mt1 ON ( dxsjj_posts.ID = mt1.post_id AND mt1.meta_key = 'factor_impacto' ) LEFT JOIN dxsjj_postmeta AS mt2 ON ( dxsjj_posts.ID = mt2.post_id ) LEFT JOIN dxsjj_postmeta AS mt3 ON ( dxsjj_posts.ID = mt3.post_id ) LEFT JOIN dxsjj_postmeta AS mt4 ON ( dxsjj_posts.ID = mt4.post_id ) WHERE 1=1 AND ( ( dxsjj_postmeta.meta_key = 'factor_impacto' OR mt1.post_id IS NULL ) AND mt2.meta_key = 'autores' AND ( mt3.meta_key = 'id_grupos' AND mt3.meta_value LIKE '{3462be932f9ae1484ae01aa3bc1f3f089a4afb4c3d2c360e1fe2a4108a1a692f}50012513{3462be932f9ae1484ae01aa3bc1f3f089a4afb4c3d2c360e1fe2a4108a1a692f}' ) AND ( mt4.meta_key = 'anyo' AND CAST(mt4.meta_value AS SIGNED) >= '2019' ) ) AND dxsjj_posts.post_type = 'cnio_publication' AND ((dxsjj_posts.post_status = 'publish')) GROUP BY dxsjj_posts.ID ORDER BY CAST(mt4.meta_value AS SIGNED) DESC, CAST(dxsjj_postmeta.meta_value AS SIGNED) DESC, CAST(mt2.meta_value AS CHAR) ASC
