TEST - Quarry

SQL

USE arwiki_p;
SELECT CONCAT("# [[",page_title,"]]"), CONCAT("[[:d:",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
    INNER JOIN categorylinks ON page_id = cl_from AND cl_to = 'بوابة_أعلام/مقالات_متعلقة'
INNER JOIN revision ON page_id = rev_page 
INNER JOIN actor ON actor_id = rev_actor AND actor_name like ucase ("JarBot") collate utf8_general_ci
WHERE pp_value is not NULL
AND ll_title IS NULL
AND page_namespace = 0
ORDER BY page_title
LIMIT 10
;
SQL

Checking query status...
