single-uri - Quarry

SQL

use rowiki_p;
SELECT CONCAT("# [[",p.page_title,"]]"), p.page_len/*, cl.cl_to*/
FROM page p, page_props, /*categorylinks cl, */wikidatawiki_p.page wdp
join langlinks on page_id = ll_from and ll_lang="en"
JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id 
AND wdpl.pl_title in ('Q134556', 'Q208569', 'Q7366') AND wdpl.pl_namespace = 0
WHERE p.page_namespace = 0
AND pp_page = p.page_id AND pp_propname = 'wikibase_item'
AND wdp.page_title = pp_value AND wdp.page_namespace = 0
#	AND cl.cl_from=p.page_id
and p.page_id not in (SELECT tl_from
						FROM templatelinks
						WHERE tl_namespace = 10 and tl_from_namespace=0
						and tl_title like "Infobox_%" or tl_title like "Infocaseta_%"
  					)
#                    and cl.cl_to like "Fotba%"
GROUP BY p.page_id
order by p.page_len desc;
SQL

Checking query status...
