Untitled query #83212

SQL

-- Count pages in the page table
SELECT 
    'page' AS table_name, COUNT(*) AS total_count
FROM 
    page
WHERE 
    EXISTS (
        SELECT 
            1 
        FROM 
            revision 
        WHERE 
            revision.rev_page = page.page_id 
            AND rev_timestamp <= 'YYYYMMDDHHMMSS'
    )

UNION ALL

-- Count entries in the category table (example of another relevant table)
SELECT 
    'category' AS table_name, COUNT(*) AS total_count
FROM 
    category
WHERE 
    EXISTS (
        SELECT 
            1 
        FROM 
            page 
        WHERE 
            page.page_id = category.cat_id 
            AND page.page_namespace IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
            AND EXISTS (
                SELECT 
                    1 
                FROM 
                    revision 
                WHERE 
                    revision.rev_page = page.page_id 
                    AND rev_timestamp <= 'YYYYMMDDHHMMSS'
            )
    )

UNION ALL

-- Count entries in other tables
SELECT 
    'templatelinks' AS table_name, COUNT(*) AS total_count
FROM 
    templatelinks
WHERE 
    EXISTS (
        SELECT 
            1 
        FROM 
            page 
        WHERE 
            page.page_id = templatelinks.tl_from 
            AND page.page_namespace IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
            AND EXISTS (
                SELECT 
                    1 
                FROM 
                    revision 
                WHERE 
                    revision.rev_page = page.page_id 
                    AND rev_timestamp <= 'YYYYMMDDHHMMSS'
            )
    );

-- Add similar SELECT statements for other relevant tables here

-- Example of combining results to get the total count
SELECT 
    SUM(total_count) AS total_pages
FROM (
    -- Your combined queries above
) AS combined_counts;
SQL

Checking query status...
