SELECT cadena,sub_categoria, MATCH(cadena) AGAINST('') as rank FROM busquedas WHERE website = 'C' AND cadena!='' AND repeticiones > 15 AND sub_categoria = 170 AND top != 1 AND resultados > 1 GROUP BY cadena ORDER BY repeticiones desc,rank desc LIMIT 0,50