SELECT CONCAT_WS('/', 'nota', id_noticia, slug) AS link FROM noticias WHERE id_noticia = 6048