Untitled query #86089

SQL

SELECT
  CASE
    WHEN page.page_namespace = 0 THEN page.page_title
    WHEN page.page_namespace = 1 THEN CONCAT('Talk:', 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 = 4 THEN CONCAT('Wikipedia:', page.page_title)
    WHEN page.page_namespace = 5 THEN CONCAT('Wikipedia talk:', page.page_title)
    WHEN page.page_namespace = 6 THEN CONCAT('File:', page.page_title)
    WHEN page.page_namespace = 7 THEN CONCAT('File talk:', page.page_title)
    WHEN page.page_namespace = 10 THEN CONCAT('Template:', page.page_title)
    WHEN page.page_namespace = 11 THEN CONCAT('Template talk:', page.page_title)
    WHEN page.page_namespace = 14 THEN CONCAT('Category:', page.page_title)
    WHEN page.page_namespace = 15 THEN CONCAT('Category talk:', page.page_title)
    WHEN page.page_namespace = 100 THEN CONCAT('Portal:', page.page_title)
    WHEN page.page_namespace = 101 THEN CONCAT('Portal talk:', page.page_title)
    WHEN page.page_namespace = 118 THEN CONCAT('Draft:', page.page_title)
    WHEN page.page_namespace = 119 THEN CONCAT('Draft talk:', page.page_title)
    WHEN page.page_namespace = 828 THEN CONCAT('Module:', page.page_title)
    ELSE CONCAT('NS', page.page_namespace, ':', page.page_title)
  END AS PageWithNamespace,
  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...
