[PD-868] Made only visible jobs viewable on product listing

I also changed a query, which should be more efficient in cases where a site exists in more than one site package.