MySQL query for selecting records that originated at a non-paid referer

SELECT websource, referer_host, referer_keywords, my_referer
FROM orders
WHERE referer_host <> ''
AND websource IS NULL

Use this to exclude people searching for you specifically

SELECT websource, referer_host, referer_keywords, my_referer
FROM orders
WHERE referer_host <> ''
AND websource IS NULL
AND referer_keywords NOT LIKE '%[domain]%'