select
sql : select c.* from (( select count(*) as ntags, iw4_noticias.* from iw4_noticias where (titulo_es REGEXP '^.*([:space:]|[:punct:])?Adidas([:space:]|[:punct:])?.*$') and (iw4fechapublicacion<20141127 or (iw4fechapublicacion=20141127 and hora<='02:23')) and publicar=1 and visible_es=1 group by iw4id ) UNION ( select count(n.iw4id) as ntags, n.* from iw4_noticias n, (select nt.id2 as iw4id from iw4_noticias_nn_tags nt where nt.id1='16191') t, iw4_noticias_nn_tags nnt where t.iw4id=nnt.id2 and n.iw4id=nnt.id1 and n.iw4id!='16191' and (n.iw4fechapublicacion<20141127 or (n.iw4fechapublicacion=20141127 and n.hora<='02:23')) and n.publicar=1 and n.visible_es=1 group by n.iw4id )) c where c.iw4id!=16191 order by c.ntags desc, c.iw4fechapublicacion desc limit 5

ERROR DE SELECT
Table '' is marked as crashed and should be repaired