Pages with possible copyivio sorted by category link date

SQL

SELECT
  CASE
    WHEN page.page_namespace = 0 THEN page.page_title
    WHEN page.page_namespace = 2 THEN CONCAT('User:', page.page_title)
    WHEN page.page_namespace = 3 THEN CONCAT('User talk:', page.page_title)
    WHEN page.page_namespace = 14 THEN CONCAT('Category:', page.page_title)

    ELSE CONCAT('NS', page.page_namespace, ':', page.page_title)
  END AS Page,
  cl.cl_timestamp AS CategoryAddedAt
FROM
  categorylinks AS cl
JOIN
  page ON cl.cl_from = page.page_id
WHERE
  cl.cl_to = 'Вікіпедія:Можливе_порушення_авторських_прав'
ORDER BY
  cl.cl_timestamp DESC;

SQL

Checking query status...