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