dewiki: Wikiprojekt_Österreich subpages with Wikidata item

Fork of dewiki: Artikelwerkstatt pages with Wikidata item by MisterSynergy

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

Topic:Vrmmvidefxwuwq2v

SQL

#USE dewiki_p; # <-- change wiki here!
#
#SELECT
#    p.page_title,
#    pp.pp_value
#FROM
#    page p JOIN page_props pp ON p.page_id=pp.pp_page
#WHERE
#    p.page_namespace=4
#    AND p.page_title LIKE 'WikiProjekt_Österreich/%'
#    AND pp.pp_propname='wikibase_item';
    
USE wikidatawiki_p;

SELECT actor_name, COUNT(rev_id)
FROM revision JOIN actor_revision ON rev_actor=actor_id
WHERE
	#rev_parent_id=0 AND
    rev_page IN (
      SELECT page_id FROM page WHERE page_namespace=0 AND page_title IN (
		'Q98096882', 'Q98096898', 'Q98096944', 'Q98096955', 'Q98096961', 'Q98096966', 'Q98096971', 'Q98096978', 'Q98096981', 'Q98096987', 'Q98097010', 'Q98097018', 'Q98097022', 'Q98097027', 'Q98097032', 'Q98097041', 'Q98097047', 'Q98097051', 'Q98097058', 'Q98097066', 'Q98097071', 'Q98097078', 'Q98097721', 'Q98097730', 'Q98097741', 'Q98097766', 'Q98097777', 'Q98097792', 'Q98097966', 'Q98097987', 'Q98098031', 'Q98098035', 'Q98098198', 'Q98098201', 'Q98098205', 'Q98098211', 'Q98098208', 'Q98098239', 'Q98098246', 'Q98098251', 'Q98098249', 'Q98098254', 'Q98098257', 'Q98101319', 'Q98101332', 'Q98101339', 'Q98101342', 'Q98101350', 'Q98101354', 'Q98101359', 'Q98101460', 'Q98101475', 'Q98101481', 'Q98101486', 'Q98101500', 'Q98101585', 'Q98101595', 'Q98101608', 'Q98101616', 'Q98101624', 'Q98101676', 'Q98102324', 'Q98102336', 'Q98102355', 'Q98103432', 'Q98103451', 'Q98103458', 'Q98103463', 'Q98103469', 'Q98103485', 'Q98103492', 'Q98103541', 'Q98103887', 'Q98103894', 'Q98104429', 'Q98104443', 'Q98104440', 'Q98104445', 'Q98104451', 'Q98104449', 'Q98104454', 'Q98104453', 'Q98104458', 'Q98104479', 'Q98104529', 'Q98104541', 'Q98104549', 'Q98104557', 'Q98104563', 'Q98104565', 'Q98104571', 'Q98104686', 'Q98104811', 'Q98104937', 'Q98105033', 'Q98105773', 'Q98083846', 'Q98083878', 'Q98083885', 'Q98083894', 'Q98083903', 'Q98083909', 'Q98083919', 'Q98083935', 'Q98084119', 'Q98084137', 'Q98084162', 'Q98084177', 'Q98084186', 'Q98084204', 'Q98084214', 'Q98084225', 'Q98084231', 'Q98084239', 'Q98084250', 'Q98084259', 'Q98084373', 'Q98084386', 'Q98084421', 'Q98084447', 'Q98084481', 'Q98084495', 'Q98084527', 'Q98084547', 'Q98084567', 'Q98084578', 'Q98084594', 'Q98084604', 'Q98084619', 'Q98084628', 'Q98085955', 'Q98085965', 'Q98085976', 'Q98086027', 'Q98086699', 'Q98086712', 'Q98086722', 'Q98086730', 'Q98086745', 'Q98086773', 'Q98086783', 'Q98086791', 'Q98086803', 'Q98086813', 'Q98086898', 'Q98086906', 'Q98086914', 'Q98086923', 'Q98086932', 'Q98086939', 'Q98086949', 'Q98086959', 'Q98086969', 'Q98086978', 'Q98087077', 'Q98087111', 'Q98087154', 'Q98087185', 'Q98087194', 'Q98087205', 'Q98090155', 'Q98090165', 'Q98090179', 'Q98090189', 'Q98090196', 'Q98090237', 'Q98090247', 'Q98090310', 'Q98090677', 'Q98090690', 'Q98090746', 'Q98090762', 'Q98090773', 'Q98090786', 'Q98090795', 'Q98090811', 'Q98090821', 'Q98090834', 'Q98090844', 'Q98090853', 'Q98090862', 'Q98090873', 'Q98090882', 'Q98090896', 'Q98090915', 'Q98091031', 'Q98091214', 'Q98091232', 'Q98091253', 'Q98091266', 'Q98091301', 'Q98091310', 'Q98091335', 'Q98091344', 'Q98091353', 'Q98091364', 'Q98123215', 'Q98123223', 'Q98123220', 'Q98123269', 'Q98123304', 'Q98127551', 'Q98127576', 'Q98127595', 'Q98127623', 'Q98127645', 'Q98127664', 'Q98127682', 'Q98127701', 'Q98127720', 'Q98127742', 'Q98127759', 'Q98127795', 'Q98127836', 'Q98127886', 'Q98129026', 'Q98129460', 'Q98129493', 'Q98129576', 'Q98129665', 'Q98129738', 'Q98129758', 'Q98129787', 'Q98129836', 'Q98129879', 'Q98129922', 'Q98129955', 'Q98129979', 'Q98130066', 'Q98130153', 'Q98130196', 'Q98130230', 'Q98130251', 'Q98130270', 'Q98130288', 'Q98130307', 'Q98130324', 'Q98130346', 'Q98130384', 'Q98130407', 'Q98130694', 'Q98132942', 'Q98132974', 'Q98132997', 'Q98133018', 'Q98133058', 'Q98133072', 'Q98133085', 'Q98133106', 'Q98133131', 'Q98133150', 'Q98133170', 'Q98133186', 'Q98133185', 'Q98133191', 'Q98133189', 'Q98133194', 'Q98133192', 'Q98133193', 'Q98133198', 'Q98133199', 'Q98133196', 'Q98133197', 'Q98137295', 'Q98137299', 'Q98137306', 'Q98137304', 'Q98137309', 'Q98137314', 'Q98137323', 'Q98137320', 'Q98137327', 'Q98137330', 'Q98137333', 'Q98137337', 'Q98137342', 'Q98137348', 'Q98137354', 'Q98137359', 'Q98137365', 'Q98137368', 'Q98137375', 'Q98137380', 'Q98137385', 'Q98138074', 'Q98138078', 'Q98138076', 'Q98138084', 'Q98138090', 'Q98138088', 'Q98138094', 'Q98138097', 'Q98138102', 'Q98138100', 'Q98138129', 'Q98138155', 'Q98105798', 'Q98105839', 'Q98105847', 'Q98105844', 'Q98105859', 'Q98105863', 'Q98105869', 'Q98105898', 'Q98106848', 'Q98106861', 'Q98106898', 'Q98106928', 'Q98106937', 'Q98106946', 'Q98106955', 'Q98106966', 'Q98107012', 'Q98107036', 'Q98107050', 'Q98107061', 'Q98107081', 'Q98107104', 'Q98107119', 'Q98107272', 'Q98107466', 'Q98107472', 'Q98107492', 'Q98107496', 'Q98107509', 'Q98107531', 'Q98107536', 'Q98107542', 'Q98107546', 'Q98107586', 'Q98107597', 'Q98107606', 'Q98107798', 'Q98107815', 'Q98107829', 'Q98107840', 'Q98107845', 'Q98107851', 'Q98107862', 'Q98107868', 'Q98107874', 'Q98107884', 'Q98107889', 'Q98107896', 'Q98107971', 'Q98108076', 'Q98108086', 'Q98108090', 'Q98108097', 'Q98108107', 'Q98108104', 'Q98108146', 'Q98108347', 'Q98108670', 'Q98108678', 'Q98108684', 'Q98108689', 'Q98108695', 'Q98108727', 'Q98108735', 'Q98108942', 'Q98108947', 'Q98108953', 'Q98108956', 'Q98108961', 'Q98108966', 'Q98108971', 'Q98108968', 'Q98108973', 'Q98108978', 'Q98108979', 'Q98108977', 'Q98108983', 'Q98108981', 'Q98108986', 'Q98108985', 'Q98108991', 'Q98108989', 'Q98108993', 'Q98108998', 'Q98108996', 'Q98109002', 'Q98109000', 'Q98109005', 'Q98109014', 'Q98109019', 'Q98109016', 'Q98109213', 'Q98109220', 'Q98109225', 'Q98109229', 'Q98109234', 'Q98109318', 'Q98112722', 'Q98112726', 'Q98112730', 'Q98148389', 'Q98148393', 'Q98148875', 'Q98148879', 'Q98148886', 'Q98148890', 'Q98148897', 'Q98148929', 'Q98148960', 'Q98148967', 'Q98148979', 'Q98148989', 'Q98149027', 'Q98149053', 'Q98149059', 'Q98149064', 'Q98149218', 'Q98149567', 'Q98149578', 'Q98149576', 'Q98149582', 'Q98149587', 'Q98149591', 'Q98149631', 'Q98149657', 'Q98149683', 'Q98149708', 'Q98149877', 'Q98149883', 'Q98149885', 'Q98149889', 'Q98149892', 'Q98149898', 'Q98149900', 'Q98149971', 'Q98149969', 'Q98149974', 'Q98149972', 'Q98149978', 'Q98149979', 'Q98149982', 'Q98149983', 'Q98149980', 'Q98149986', 'Q98149987', 'Q98149988', 'Q98150123', 'Q98150126', 'Q98150129', 'Q98150133', 'Q98150136', 'Q98150160', 'Q98150178', 'Q98150181', 'Q98150193', 'Q98150199', 'Q98150197', 'Q98150211', 'Q98150214', 'Q98150216', 'Q98150399', 'Q98150426', 'Q98150431', 'Q98150436', 'Q98150440', 'Q98091553', 'Q98091679', 'Q98091734', 'Q98091743', 'Q98091753', 'Q98091771', 'Q98091809', 'Q98091819', 'Q98091894', 'Q98092052', 'Q98092179', 'Q98092191', 'Q98092214', 'Q98092227', 'Q98092236', 'Q98092306', 'Q98092453', 'Q98092463', 'Q98092475', 'Q98092485', 'Q98092580', 'Q98092671', 'Q98092686', 'Q98092704', 'Q98092783', 'Q98092808', 'Q98092823', 'Q98092837', 'Q98092848', 'Q98092858', 'Q98092869', 'Q98092877', 'Q98092886', 'Q98093090', 'Q98093309', 'Q98093330', 'Q98093345', 'Q98093475', 'Q98093497', 'Q98093522', 'Q98093538', 'Q98093549', 'Q98093566', 'Q98093574', 'Q98093605', 'Q98093613', 'Q98093634', 'Q98093705', 'Q98093715', 'Q98094168', 'Q98094214', 'Q98094221', 'Q98094224', 'Q98094231', 'Q98094238', 'Q98094241', 'Q98094246', 'Q98094251', 'Q98094254', 'Q98094260', 'Q98094264', 'Q98094268', 'Q98094274', 'Q98094280', 'Q98094288', 'Q98094323', 'Q98094327', 'Q98094337', 'Q98094342', 'Q98094358', 'Q98094390', 'Q98094394', 'Q98094399', 'Q98094407', 'Q98094410', 'Q98094414', 'Q98094418', 'Q98094543', 'Q98094923', 'Q98094940', 'Q98094947', 'Q98094957', 'Q98094967', 'Q98094974', 'Q98094984', 'Q98095467', 'Q98095509', 'Q98095533', 'Q98095578', 'Q98095590', 'Q98095645', 'Q98095671', 'Q98095691', 'Q98095759', 'Q98095803', 'Q98096634', 'Q98096644', 'Q98096648', 'Q98096658', 'Q98096676', 'Q98138159', 'Q98138157', 'Q98138238', 'Q98138236', 'Q98138237', 'Q98138242', 'Q98138241', 'Q98138247', 'Q98138245', 'Q98138250', 'Q98138248', 'Q98138254', 'Q98138252', 'Q98138256', 'Q98138627', 'Q98138635', 'Q98138633', 'Q98138638', 'Q98138781', 'Q98138785', 'Q98138789', 'Q98138793', 'Q98138915', 'Q98138920', 'Q98138929', 'Q98139088', 'Q98139131', 'Q98139138', 'Q98139139', 'Q98139142', 'Q98139140', 'Q98139144', 'Q98139151', 'Q98139148', 'Q98139163', 'Q98139160', 'Q98139161', 'Q98139164', 'Q98139176', 'Q98139249', 'Q98139262', 'Q98139263', 'Q98139267', 'Q98139265', 'Q98139282', 'Q98139281', 'Q98139285', 'Q98141635', 'Q98141638', 'Q98142395', 'Q98142396', 'Q98142397', 'Q98142406', 'Q98142404', 'Q98142408', 'Q98142409', 'Q98142418', 'Q98142419', 'Q98142416', 'Q98142420', 'Q98142547', 'Q98142552', 'Q98142562', 'Q98142560', 'Q98142569', 'Q98142573', 'Q98144189', 'Q98144211', 'Q98144234', 'Q98144254', 'Q98144284', 'Q98144440', 'Q98144497', 'Q98144502', 'Q98144500', 'Q98144507', 'Q98144504', 'Q98144510', 'Q98144513', 'Q98144516', 'Q98148093', 'Q98148121', 'Q98148152', 'Q98148257', 'Q98148274', 'Q98148303', 'Q98148336', 'Q98148341', 'Q98148346', 'Q98148347', 'Q98148344', 'Q98148351', 'Q98148352', 'Q98148353', 'Q98148368', 'Q98148369', 'Q98148372', 'Q98148376', 'Q98148380', 'Q98148384'
      )
    )
GROUP BY actor_name;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...