First Articles

SQL

select page_title,
CASE
    WHEN page_namespace=0 THEN "main"
    WHEN page_namespace=1 THEN "talk"
    WHEN page_namespace=2 THEN "user"
    WHEN page_namespace=3 THEN "user talk"
    WHEN page_namespace=4 THEN "wikipedia"
    WHEN page_namespace=5 THEN "wikipedia talk"
    WHEN page_namespace=6 THEN "file"
    WHEN page_namespace=7 THEN "file talk"
    WHEN page_namespace=8 THEN "mediawiki"
    WHEN page_namespace=9 THEN "mediawiki talk"
    WHEN page_namespace=10 THEN "template"
    WHEN page_namespace=11 THEN "template talk"
    WHEN page_namespace=12 THEN "help"
    WHEN page_namespace=13 THEN "help talk"
    WHEN page_namespace=14 THEN "category"
    WHEN page_namespace=15 THEN "category talk"
    WHEN page_namespace=828 THEN "module"
    WHEN page_namespace=819 THEN "module talk"
    WHEN page_namespace=100 THEN "vedika"
    WHEN page_namespace=101 THEN "vedika talk"
    ELSE "other"
    end as page_namespace from page
    where page_namespace <>8
order by page_id
Limit 100
SQL

Checking query status...
