Featured/good articles in cswiki vs WD

SQL

use cswiki_p;

# Featured articles in cswiki but not in WD
SELECT page_title FROM categorylinks JOIN page ON cl_from=page_id
WHERE cl_to="Wikipedie:Nejlepší_články"
AND page_namespace=0
AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname="wikibase-badge-Q17437796");

# Featured articles in WD but not in cswiki
SELECT page_title FROM page_props JOIN page ON pp_page=page_id WHERE pp_propname="wikibase-badge-Q17437796"
AND pp_page NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to="Wikipedie:Nejlepší_články");

SQL

Checking query status...