SQL
AخA
SELECT q.pp_value, page_namespace, page_title
FROM (
SELECT pp_page
FROM frwiki_p.page_props
WHERE
pp_propname='wikibase-badge-Q17437796' AND
pp_value=1
) b, frwiki_p.page_props q, frwiki_p.page
WHERE
b.pp_page=q.pp_page AND
q.pp_propname='wikibase_item' AND
page_id=q.pp_page AND
NOT EXISTS (
SELECT *
FROM nlwiki_p.page_props t
WHERE
t.pp_propname='wikibase_item' AND
t.pp_value=q.pp_value
)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.