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
Siaahmed
.
Toggle Highlighting
SQL
use arywiki_p; select concat('"تصنيف:',p.page_title , '":' ) , concat('"Category:',ll_title , '",' ) from page p inner join page p3 on p3.page_title = p.page_title inner join langlinks on ll_from = p3.page_id where p.page_namespace = 14 and p.page_is_redirect = 0 and p.page_title not like "%/%" and p.page_id not in (select ll_from from langlinks where ll_from = p.page_id and ll_lang = "en") and p.page_title in (select p2.page_title from page p2 where p2.page_namespace = 0 and p2.page_is_redirect = 0 and p2.page_title = p.page_title) and (select count(p2.page_id) from page p2 inner join langlinks on ll_from = p2.page_id where p2.page_namespace = 0 and p2.page_is_redirect = 0 and p2.page_title = p.page_title and ll_lang = "en" and replace(ll_title," ","_") in (select enwiki_p.page.page_title from enwiki_p.page where enwiki_p.page.page_namespace = 14 and enwiki_p.page.page_is_redirect = 0 and enwiki_p.page.page_title = replace(ll_title," ","_")) > 0) and p.page_id not in (select cl_from from categorylinks where cl_to = 'تحويلات_تصنيفات_ويكيبيديا') and p3.page_namespace = 0 and p3.page_is_redirect = 0 and ll_lang = "en";
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...