articole despre oameni fără infocasete

SQL

use rowiki_p;
#(wdpl.pl_title = 'P106' AND wdpl.pl_namespace = 120)
SELECT CONCAT("# [[",p.page_title,"]]"), p.page_len/*, 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 = 'Q5' 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...
