Creating special pages

[Scafloc]

Is it possible to create extra special pages on the wiki and if so how?

Current list of special pages for instance has a special page that shows Wanted pages pages that don't exist but are linked to. By checking this page we can see the pages we need to create.

What I would like to see as another special pages is a list with pages that are about geography (cities, fortresses, rivers and sees) and don't have a map attached to it. So that this link can function as a to do list. This is content information and as the software uses SQL it would probably need a custom made sql query to retrieve it. I have some knowledge about SQL and I had a look at the data model that is used by the wikimedia software. I think the query would be something like:

select page_title,

from page

where exists (select 1

from categorylinks

where cl_from = page_id

and cl_to = 'PLACES'

)

and not exists (select 1

from imagelinks

where il_from = page_id

)

Another list I would be interested in is a list for pages that don't have a link to the French or Russian wiki.

[Evrach]

Another list I would be interested in is a list for pages that don't have a link to the French or Russian wiki.

This one exists : http://awoiaf.westeros.org/index.php/Special:WithoutInterwiki

But it doesn't list wich page has only french link, only russian link, or both.