I just consulted with my colleagues from the developers team and as I told you in my previous post, SitefinitySiteMapDataSource should return pages with checked ShowInNavigation. However, it seems that there were some serious Multilingual problems with the 4.2 version, so this might cause the SitefinitySiteMapDataSource to return incorrect pages. We advice you to upgrade to Sitefinity 4.3 or higher version, where these problems have been resolved.
As for your question about Multilingual pages: When you have synchronized translations of a page, those pages represent one page node and this is why in the database you will see one record for them, When you unsynced them, however, they will split into separate records, depending on the number of translations. For example, if you have 2 translations, in the sf_ Page_Node table you should see 2 records with status 2 (Live). In the sf_drafts table you will see the records with status codes 0 and 1, where 0 is master (the masters should be 2 as well) and Temp with code 1, if the page is opened for editing.
the Telerik team
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking
system and vote to affect the priority of the items