Asignar prioridad a una búsqueda

[quimfv]

Te falta sumar las prioridades no?

Código MySQL:

SELECT uDR.artTitulo, 
             uDR.artDescripcion, 
             uDR.palabrasArticulo  
from (
(select s1.artTitulo, s1.artDescripcion, s1.palabrasArticulo, 1 as priority from articulos s1 WHERE MATCH (artTitulo) AGAINST ('$frase'))
union
(select s2.artTitulo, s2.artDescripcion, s2.palabrasArticulo, 2 as priority from articulos s2 WHERE MATCH (artDescripcion) AGAINST ('$frase'))
union
(select s3.artTitulo, s3.artDescripcion, s3.palabrasArticulo, 3 as priority from articulos s3 WHERE MATCH (palabrasArticulo) AGAINST ('$frase'))) uDR
GROUP BY uDR.artTitulo, 
             uDR.artDescripcion, 
             uDR.palabrasArticulo  
order by SUM(uDR.priority) DESC;