[Grooverider]

Because it was an example.

For those that care, the correct answer was:

select distinct a.keywordid, k.keyword from adata a join keyword k using (keywordid) join company c using(companyid) where c.companyurl like '%variable%'