Untitled query #83212

SQL

-- Count pages in the page table
SELECT 
    COUNT(*) AS total_pages
FROM 
    page
WHERE 
    page_id <= (
        SELECT 
            MAX(rev_page) 
        FROM 
            revision 
        WHERE 
            rev_timestamp <= 'YYYYMMDDHHMMSS'
    );

-- Count links in the categorylinks table
SELECT 
    COUNT(*) AS total_category_links
FROM 
    categorylinks
WHERE 
    cl_from <= (
        SELECT 
            MAX(rev_page) 
        FROM 
            revision 
        WHERE 
            rev_timestamp <= 'YYYYMMDDHHMMSS'
    );

-- Count links in the imagelinks table
SELECT 
    COUNT(*) AS total_image_links
FROM 
    imagelinks
WHERE 
    il_from <= (
        SELECT 
            MAX(rev_page) 
        FROM 
            revision 
        WHERE 
            rev_timestamp <= 'YYYYMMDDHHMMSS'
    );
SQL

Checking query status...
