SELECT left( referrer, 20 ) refl, count( 1 )
FROM `wikini_referrers`
GROUP BY refl
ORDER BY `count( 1 )` DESC
LIMIT 0 , 200

delete FROM `wikini_referrers` where referrer like '%sex%' or referrer like '%pass%' or referrer like '%titsbig%'

---