[BROKEN] nlwiki_p featured-hotlist fr

SQL

SELECT *
FROM frwiki_p.page_props
WHERE EXISTS (SELECT * FROM frwiki_p.page_props WHERE pp_propname='wikibase-badge-Q17437796' AND pp_value=1)
LIMIT 10

/*
SELECT pp_value, page_namespace, page_title
FROM frwiki_p.categorylinks, frwiki_p.page_props, frwiki_p.page
WHERE
	cl_to='Article_de_qualité' AND
	cl_from=pp_page AND
	pp_propname='wikibase_item' AND
	page_id=pp_page AND
	NOT EXISTS (
		SELECT *
		FROM nlwiki_p.page_props
		WHERE 
			nlwiki_p.page_props.pp_propname='wikibase_item' AND
			nlwiki_p.page_props.pp_value=frwiki_p.page_props.pp_value
    )
*/

SQL

Checking query status...