How can I find the difference between queries that return multiple rows?
Try to use the following:

select * from website a where not exists (select null from page where site_id=a.id and deleted=0)


Probably this is what you're asking for