Inicio | Investigación e innovación | Programas Científicos | Programa de Biología Estructural | Grupo de Genómica Digital

Marcos Díaz
Marcos Díaz Jefe de Grupo
T +34 (+34) 917 328 000 (Ext )
mdiazg@cnio.es

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 '{dbff5a6f0407f58a009f580f77a5c9286ba81528cef83ff98e4f497481ada289}50012663{dbff5a6f0407f58a009f580f77a5c9286ba81528cef83ff98e4f497481ada289}' ) 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

Subir