ro footybio w/o infobox

SQL

/**/use rowiki_p;
#(wdpl.pl_title = 'P106' AND wdpl.pl_namespace = 120)
SELECT p.page_title/*, cl.cl_to*/
FROM page p, page_props, categorylinks cl, wikidatawiki_p.page wdp
JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id 
AND (wdpl.pl_title = 'Q937857' 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 wdpl.pl_title

/*
select p.page_title, lfr.ll_title
from plwiki_p.page p 
join plwiki_p.langlinks lfr on p.page_id=lfr.ll_from and p.page_namespace=0 and lfr.ll_lang="ro"
join plwiki_p.categorylinks cfr on cfr.cl_from=p.page_id and cfr.cl_to = "Planetoidy_pasa_głównego"
*/
SQL

Checking query status...
