Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Yethrosh
.
https://ur.wikipedia.org/wiki/%D9%88%DB%8C%DA%A9%DB%8C%D9%BE%DB%8C%DA%88%DB%8C%D8%A7:%D8%B1%D9%88%D8%AF%D8%A7%D8%AF%DB%81%D8%A7%D8%A6%DB%92_%DA%88%DB%8C%D9%B9%D8%A7%D8%A8%DB%8C%D8%B3/%D9%81%DB%81%D8%B1%D8%B3%D8%AA_%D8%A7%D8%A8%D9%88%D8%A7%D8%A8
Toggle Highlighting
SQL
USE urwiki_p; SELECT page_title, CAST(rev_timestamp AS date) AS date, case (datepart(month, rev_timestamp)) when 1 then N'Muḥarram' when 2 then N'Ṣafar' when 3 then N'Rabī‘ al-awwal' when 4 then N'Rabī‘ ath-thānī' when 5 then N'Jumādá al-ūlá' when 6 then N'Jumādá al-ākhirah' when 7 then N'Rajab' when 8 then N'Sha‘bān' when 9 then N'Ramaḍān' when 10 then N'Shawwāl' when 11 then N'Dhū al-Qa‘dah' when 12 then N'Dhū al-Ḥijjah' end FROM page JOIN revision ON rev_id = page_id WHERE page_namespace = 100 AND page_title NOT LIKE '%/%' AND page_is_redirect = 0
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
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...