I do see the pages in code when I do a PagesFacade query = App.WorkWith().Pages().Take(_count_);
However as this seems to query Page_Nodes, this isn't very illuminating.
To give a little more insight into the issue, I have an instance of a page. Let's call it Home. There are 8 page_nodes with url_name_ = 'home'.
- 3 of these are published. 2 of these published nodes are identical except for voa_version, ids, and create date. The third is a spanish localized version of this page.
- the remaining 5 have null id2's, null approval_work_state_'s (no 'published' state, for any language). 2 of these have a spanish url (url_name_es), and 1 has a french url (url_name_fr)
I'm pretty sure this mess came about from localization, when I changed the Multilingual URLs mode from "different domains" to "directories. But right now I'm just concerned about cleaning everything up and potential pitfalls of simply removing the offending entries from the database.