Home | Research & Innovation | Scientific Programmes | Structural Biology Programme | Biomolecular Design and Structural Nanom Group

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

Up

CNIO
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.