#SELECT * FROM wiki WHERE is_closed=0 AND has_wikidata=1 AND family NOT IN ('wikipedia', 'wikibooks', 'wiktionary', 'wikisource', 'wikinews', 'wikivoyage', 'wikiquote', 'wikiversity') ORDER BY lang ASC;

SELECT * FROM wiki WHERE is_closed=0 AND has_wikidata=1 ORDER BY lang ASC;

​

#SELECT family, COUNT(1) FROM wiki WHERE is_closed=0 GROUP BY family;

#USE wikidatawiki_p;

#SELECT * FROM sites;

#SELECT * FROM wb_items_per_site LIMIT 10;