Registration date and first edit date

Fork of Malayalam Wikipedia Articles without images by Gnoeee

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

SQL

-- Get articles from the category
SELECT DISTINCT a.page_title, i.il_to AS image_link
FROM page a
INNER JOIN categorylinks c ON a.page_id = c.cl_from
LEFT JOIN (
    -- Get images used in each article
    SELECT DISTINCT il_from, il_to
    FROM imagelinks
    WHERE il_from_namespace = 0
      AND il_to_namespace = 6
) i ON a.page_id = i.il_from
WHERE a.page_namespace = 0
  AND a.page_is_redirect = 0
  AND c.cl_to = 'Critically_endangered_plants'
  AND i.il_from IS NOT NULL
  AND NOT EXISTS (
    -- Filter out images used indirectly through templates
    SELECT 1
    FROM templatelinks t
    WHERE t.tl_from = a.page_id
);

SQL

Checking query status...