select t1.url, t1.url_domain, t1.referer, t1.referer_domain, t2.referer, t2.referer_domain, t2.last_spidered from table t1, table t2 where t1.referer_domain = t2.domain