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
  a.page_title AS article_title,
  GROUP_CONCAT(i.il_to SEPARATOR ', ') AS image_links,
  u.user_name AS added_by_user
FROM
  page a
JOIN
  imagelinks i ON a.page_id = i.il_from
JOIN
  categorylinks c ON a.page_id = c.cl_from
LEFT JOIN
  templatelinks t ON i.il_to = t.tl_from
LEFT JOIN
  imagelinks ti ON t.tl_from = ti.il_from
LEFT JOIN
  revision rev ON a.page_id = rev.rev_page
LEFT JOIN
  user u ON rev.rev_user = u.user_id
WHERE
  a.page_namespace = 0
  AND c.cl_to = 'Critically_endangered_plants'
  AND ti.il_to IS NULL
GROUP BY
  a.page_title, u.user_name;

SQL

Checking query status...