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

SQL

AخA
 
/**
 Executed in 1098.01 seconds as of Mon, 26 Aug 2024 06:43:15 UTC: 952 rows, replication lag 18 minutes
 Executed in 713.02 seconds as of Mon, 26 Aug 2024 08:28:02 UTC: 916 rows, replication lag 11 minutes
 xecuted in 1163.87 seconds as of Mon, 26 Aug 2024 11:46:33 UTC: 879 rows, replication lag 19 minutes
**/
SELECT
  concat('Category:', REPLACE(page_title, '_', ' '), '') as category_name,
  length(page_title) as len_name,
  left(page_touched, 12) as date_last,
  page_len as text_size,
  page_is_new as is_new,
  page_id
FROM
  `page`
  LEFT JOIN `categorylinks` ON cl_from = page_id
WHERE
  cl_from IS NULL
  AND page_namespace = 14
  AND page_is_redirect = 0
ORDER by
  page_id DESC
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...