My referrers script was overriden with hits from spam bots, and so I made a few queries to knock out a few thousand superflous entries to the database. Here are my queries, and of course I have censored the naughty words that might offend the faint-hearted. 

<code>SELECT *
FROM 'ref'
WHERE refer LIKE '%viagra%'
OR refer LIKE '%pharmacy%'
OR refer LIKE '%cialis%'
OR refer LIKE '%pill%'
OR refer LIKE '%sysrem%'
OR refer LIKE '%ronnieazza%'
OR refer LIKE '%coitus%'
OR refer LIKE '%[male genitalia]%'  
[ Deleted # of entries: 156 ]</code>

<code>SELECT *
FROM 'ref'
WHERE agent LIKE '%bot%'
OR agent LIKE '%spider%' 
[ Deleted # of entries: 5053 ]
</code>

<code>SELECT *
FROM 'ref'
WHERE refer LIKE '%casio%'
OR refer LIKE '%levitra%'
OR refer LIKE '%Unkown%'
OR refer LIKE '%poker%'
OR refer LIKE '%online%'
OR refer LIKE '%texas%'
OR refer LIKE '%payday%'
OR refer LIKE '%loans%'
OR refer LIKE '%credit%'
OR refer LIKE '%xanax%'
OR refer LIKE '%roulette%'
OR refer LIKE '%craps%'
OR refer LIKE '%watches%'
OR refer LIKE '%valium%'  
[ Deleted # of entries: 4422 ]</code>

<code>SELECT *
FROM 'ref'
WHERE refer LIKE '%phentermine%'
OR refer LIKE '%casino%'
OR refer LIKE '%tramadol%'
OR refer LIKE '%mortgage%'
OR refer LIKE '%terashells%'
OR refer LIKE '%crescentarian%'
OR refer LIKE '%slot%'
OR refer LIKE '%auction%'
OR refer LIKE '%buy%'
OR refer LIKE '%future%'
OR refer LIKE '%yelucie%' 
OR refer LIKE '%reviews%'
OR refer LIKE '%black%' 
[ Deleted # of entries: 119+17 ]</code>

Anyways, eventually these entries will be deleted automatically with a script I will write. Since the main point if to see where people are coming from, and not stupid links to suspended pages. The current page displays results thousands of entries back , so it is east to see what a nusance this has been to me. I am not sure I like blog pinging quite as much anymore. 

I am off once again to read the Count of Monte Cristo. 

~Hark