SELECT *,sum(weight) as score FROM search WHERE keyword like 'gutra%' and 1=1 group by mediaid order by score desc, numpurchases desc, mediaid desc limit 500