Registration date and first edit date

SQL

-- Step 1: Get the list of all articles in the category
SELECT DISTINCT a.page_title
FROM categorylinks a
WHERE a.cl_to = 'Critically_endangered_plants'
AND a.cl_type = 'page'
AND a.cl_sortkey = ''
AND a.page_id IN (
    -- Step 2: Check for the images used in those articles
    SELECT DISTINCT il_from
    FROM imagelinks
    WHERE il_from_namespace = 0
    AND il_from = a.page_id
)
AND a.page_id NOT IN (
    -- Step 5: Remove articles where the images match those used in the templates
    SELECT DISTINCT tl_from
    FROM templatelinks t
    JOIN imagelinks i ON t.tl_from = i.il_from
    WHERE t.tl_namespace = 10
    AND i.il_from_namespace = 10
);

-- Step 3: Get the templates used in the category
SELECT DISTINCT tl_from
FROM templatelinks
WHERE tl_namespace = 10
AND tl_from IN (
    -- Step 4: Check for the images used in those templates
    SELECT DISTINCT il_from
    FROM imagelinks
    WHERE il_from_namespace = 10
    AND il_from = tl_from
);
SQL

Checking query status...
