Worst things first things

Worst.sql

SELECT m.path,
       Sum(h.count) AS hit_count
FROM   mappings m
       INNER JOIN sites s
               ON m.site_id = s.id
       LEFT JOIN hits h
              ON h.mapping_id = m.id
WHERE  s.id = 50
GROUP  BY m.path_hash
ORDER  BY hit_count DESC