Fork of
Articles without wikidata item
by ASammour
This query is marked as a draft
This query has been published
by Kasyap.
SQL
AخA
use tewiki_p;
select CONCAT ("#[[",page_title,"]]") from page where page_id not in (select pp_page from page_props where pp_propname = "wikibase_item" and pp_page = page_id) and page_namespace = 0 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.
All SQL code is licensed under CC0 License.