SQL
AخA
USE arwiki_p;
SELECT distinct CONCAT('# [[:تصنيف:',page_title,']]') AS page_title, str_to_date(rev_timestamp, '%Y%m%d%H%i%s') AS rev_timestamp
FROM categorylinks#, page, revision
RIGHT JOIN page
ON cl_to = page_title
JOIN revision
ON rev_page = page_id
WHERE page_namespace = 14
#AND page_is_redirect = 0
AND rev_parent_id = 0
AND cl_to IS NULL
AND page_title LIKE '%منذ%'
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.