Hi Guys,

My scenario: An user that gets an access denied error on index page. The line of error do a GetPage call. So, it's probably right access. The page is result of subscribed list.

1. I'd like to get the subscribed pages (By SQL) to confirm if my user has some stoped/unpublished page.

2. Here you are the method that returns the list, but I want to get the SQL to confirm this information.

//Clear user query from cache
StandardPageEntityQuery query = new StandardPageEntityQuery();
UserCriterion userCriteria = new UserCriterion();
userCriteria.ID = new IntegerCriterion();
userCriteria.ID.Value = user.ID;query["Subscribers"] = userCriteria;StandardPageEntityCollection collection = QueryHandler.GetQueryResult(query);return collection;

If I have the page id that I'm getting an error, I can understand what's going on.