Research Scientists
- Pablo San Segundo
Post-Doctoral Fellows
- Laura Pérez-Chirinos
Publications
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 '{4c5b847a38c0f20e8a6262e1a24dc96ce86634fb6812cbdc7329a3897170f621}50012773{4c5b847a38c0f20e8a6262e1a24dc96ce86634fb6812cbdc7329a3897170f621}' ) AND ( mt4.meta_key = 'anyo' AND CAST(mt4.meta_value AS SIGNED) >= '2020' ) ) 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