Untitled query #83635

SQL

-- Select the page ID, title, length, and creation date
SELECT 
    p.page_id AS id,
    p.page_title AS name,
    p.page_len AS length,
    MIN(r.rev_timestamp) AS creation_date
FROM 
    page p
-- Join with the revision table to get the creation date
JOIN 
    revision r ON p.page_id = r.rev_page
-- Filter for pages in the main namespace
WHERE 
    p.page_namespace = 0
-- Group by page ID, title, and length to get the minimum timestamp (creation date)
GROUP BY 
    p.page_id, p.page_title, p.page_len
-- Order by creation date in descending order to get the latest pages
ORDER BY 
    creation_date DESC
-- Limit the result to the latest 10 pages
LIMIT 10;
SQL

Checking query status...
