Categories - Quarry

Fork of Categories in arwiki not link to wikidata by Mr. Ibrahem

This query is marked as a draft This query has been published by Mr. Ibrahem.

* Articles : http://quarry.wmflabs.org/query/8092
-----------------------------------------------------------------------
Resultset (21832 rows)

SQL

USE arwiki_p;
SELECT DISTINCT CONCAT("تصنيف:",page_title), pp_value
	FROM page
	LEFT JOIN langlinks
    	ON ll_from = page_id
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
WHERE ll_title IS NULL
and page_namespace = 14
and pp_value IS NOT NULL
and page_id  in (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 and tl_title="تحويل_تصنيف")
#AND page_title not like "ص.م/%"
#AND page_title like "قرى_مديرية%"
#AND page_namespace = 14
ORDER BY page_title;
 #BY page_title;
#limit 100;

SQL

Checking query status...