Hi! Use this as a startingpoint:
AqlQuery q = WAFContext.Session.CreateQuery();
AqlAliasArticleBase aliasArticle = new AqlAliasArticleBase();
aliasArticle.IncludeUnpublished = true;
aliasArticle.IncludeDeletedNodes = true;
aliasArticle.IncludeHiddenNodes = true;
q.From(aliasArticle);
q.Select(aliasArticle);
AqlResultSet rs = q.Execute();
while (rs.Read()) {
//do your thing!
}