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

SELECT DISTINCT page.page_title, imagelinks.il_to AS image_link
FROM page
INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from
INNER JOIN imagelinks ON page.page_id = imagelinks.il_from
WHERE page.page_namespace = 0
AND page.page_is_redirect = 0
AND categorylinks.cl_to = 'Critically_endangered_plants'
AND imagelinks.il_from_namespace = 0
AND (
    NOT EXISTS (
        SELECT 1
        FROM templatelinks
        WHERE templatelinks.tl_from = page.page_id
    )
    NOT EXISTS (
        SELECT 1
        FROM templatelinks
        INNER JOIN imagelinks AS template_imagelinks ON templatelinks.tl_from = template_imagelinks.il_from
        WHERE page.page_id = templatelinks.tl_from
    )
);

SQL

Checking query status...