PLN2021 ilman wikidata-kohdetta olevat sivut

Fork of PLN2021 ilman wikidata-kohdetta olevat sivut by Zache

This query is marked as a draft This query has been published by Zache.

SQL

SELECT 
page_title,
page_is_redirect,
pl1.pl_title,
page_len,
pp_value,
pl2.pl_from
FROM
pagelinks as pl1,
revision_compat,
page
LEFT JOIN page_props ON pp_page=page_id AND pp_propname="wikibase_item"
LEFT JOIN pagelinks as pl2 ON pl2.pl_title=page_title AND pl2.pl_namespace=0
WHERE
pl1.pl_from=1629817
AND pl1.pl_namespace=2
AND rev_user_text=pl1.pl_title
AND rev_id>19671091
AND rev_page=page_id
AND page_namespace=0
AND page_is_redirect=0
AND page_len>50
GROUP BY page_title, page_is_redirect, page_len, pp_value

SQL

Checking query status...