formate neconectate in wikidata

SQL

USE rowiki_p;
SELECT page_title#CONCAT("Format:",page_title)
	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 page_namespace = 10 AND page_is_redirect = 0 and page_title not like "%/doc"/*
AND ll_title IS NULL
AND pp_value is NULL*/
AND pp_value is not NULL and
ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
#ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
and page_title in (select page_title
from enwiki_p.page where page_namespace = 10 AND page_is_redirect = 0  )
/*
and page_title in
(select enp.page_title from enwiki_p.page enp
 JOIN langlinks enl
    	ON enl.ll_from = enp.page_id
WHERE enp.page_namespace = 10 AND enp.page_is_redirect = 0 and enp.page_title not like "%/doc"
                        and enl.ll_lang!="ro")
/**/
group BY page_title
ORDER BY page_title;
SQL

Checking query status...
