This query is marked as a draft This query has been published by Zdzislaw.

SQL

AخA
 
SELECT
    count(page_id) as num
FROM
                    page
                WHERE
                    page_namespace=100
LIMIT 7000;
SELECT
    page_title
FROM
                    page
                WHERE
                    page_namespace=100
                    AND 
                    page_is_new = 1
                    ORDER BY page_touched DESC
LIMIT 1;
SELECT
    page_title, page_id
FROM
                    page
                WHERE
                    page_namespace=100
                    ORDER BY page_id DESC
LIMIT 1;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...