bugfix: site needed to be joined into the query