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
Saeidpourbabak
.
Toggle Highlighting
SQL
USE fawiki_p; SELECT DISTINCT concat ('# [[',page_title,']]'), il_to FROM page JOIN imagelinks ON page_id = il_from LEFT JOIN page_props ON pp_page = page_id WHERE page_namespace = 0 AND pp_propname = 'disambiguation' AND il_to <> "Disambig_gray_RTL.svg" # {{ابهامزدایی}} AND il_to <> "Earthmap1000x500compac.jpg" # {{Location map-line|lon=؟؟؟}} AND il_to <> "Commons-logo.svg" # {{انبار-رده|؟؟؟}} AND il_to <> "WPanthroponymy.svg" # {{نام خانوادگی}} or {{نام کوچک}} AND il_to <> "Question_book-new.svg" # {{منبع}} AND il_to <> "Wiktionary-logo-en.svg" # {{ویکیواژه|؟؟؟}} AND il_to <> "Wikiquote-logo.svg" # {{ویکیگفتاورد|؟؟؟}} AND il_to <> "Edit-clear.svg" # {{تمیزکاری|؟؟؟}} AND il_to <> "Flag_of_" # {{پرچم|؟؟؟}} AND il_to <> "Question_book.svg" # {{بهبود منبع}} AND il_to <> "Wikiquote-logo.svg" # {{ویکیگفتاورد|؟؟؟}} AND il_to <> "Wikiquote-logo.svg" # {{ویکیگفتاورد|؟؟؟}} AND ( EXISTS( SELECT null FROM image WHERE img_name = il_to )OR EXISTS( SELECT null FROM commonswiki_p.page WHERE page_title = il_to AND page_namespace = 6 ) ) ORDER BY page_title;
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...