Publish sites based in terms. Query is not returning all the expected sites.

The changes to make lighter the job trying to retrieve only the list of ID's where using the siteService.getSiteIds. Seems that this call is not returning all the expected site Id:

1) The "admin" user must be enrolled in the site for it to be picked up because of this code in DbSiteService:

if ((type == SelectionType.ACCESS) || (type == SelectionType.UPDATE) || (type == SelectionType.MEMBER) || (type == SelectionType.DELETED) || (type == SelectionType.PUBVIEW) || (type == SelectionType.INACTIVE_ONLY))

{ // join with the SITE_USER table join = siteServiceSql.getSitesJoin1Sql(); }

2) The query only asks for sites that have PUBVIEW=1 ....

It is needed to search for a way to retrieve all the expected sites.

I will work on that.