select SQL_CALC_FOUND_ROWS cms_articulos.id_articulo, cms_articulos.titulo, entradilla, cms_articulos.id_categoria, cms_articulos.friendly_url_categoria, cms_articulos.friendly_url, (select nombre from cms_portadas_edicionv2 where id_portada_edicion = cms_articulos.id_categoria) as edicion, (select nombre from cms_portadas_edicionv2 where id_portada_edicion = cms_articulos.id_categoria_2) as categoria_2, (select nombre from cms_blogs where id_blog = cms_articulos.firma_como_ai) as autor, (select nombre from cms_blogs where id_blog = cms_articulos.firma_como_ai_2) as autor_2, cms_articulos.supervisado from cms_articulos where supervisado=1 and (
cms_articulos.autor = 'ignacio-perez-de-herrasti-de-goyeneche'
or cms_articulos.autor_2 = 'ignacio-perez-de-herrasti-de-goyeneche'
or cms_articulos.firma_como_ai = (SELECT id_blog FROM `cms_blogs` where cms_blogs.friendly_url='ignacio-perez-de-herrasti-de-goyeneche')
) order by cms_articulos.fecha_ultima desc LIMIT 0, 50 - Subquery returns more than 1 row