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 (
		'Q72298953', 'Q96197420', 'Q96194654', 'Q91464535', 'Q96197023', 'Q96197021', 'Q91248471', 'Q87900294', 'Q87145449', 'Q91351866', 'Q91461782', 'Q91460676', 'Q96194656', 'Q91454859', 'Q96197864', 'Q87902939', 'Q67307062', 'Q91468942', 'Q91335943', 'Q66777759', 'Q67307635', 'Q91336057', 'Q87903769', 'Q91338563', 'Q91341113', 'Q91341058', 'Q91469091', 'Q91338544', 'Q66776918', 'Q66776910', 'Q91336096', 'Q91468227', 'Q96194163', 'Q91464926', 'Q91259520', 'Q91457173', 'Q96196515', 'Q67308084', 'Q91464739', 'Q96196656', 'Q91338419', 'Q91357638', 'Q67310550', 'Q96194789', 'Q96197455', 'Q96194648', 'Q91245889', 'Q91338540', 'Q67299049', 'Q96197007', 'Q67311116', 'Q87903121', 'Q67311392', 'Q91453208', 'Q91360459', 'Q91464532', 'Q96196971', 'Q96196590', 'Q91360149', 'Q87903775', 'Q91455598', 'Q87903305', 'Q91450451', 'Q96192039', 'Q67311396', 'Q66776865', 'Q96194151', 'Q96197544', 'Q96198012', 'Q91456615', 'Q91351861', 'Q91351856', 'Q96197025', 'Q67311401', 'Q96197027', 'Q96194300', 'Q91455440', 'Q91454407', 'Q91361352', 'Q91248593', 'Q96197619', 'Q96196508', 'Q67299331', 'Q91361249', 'Q96196529', 'Q91358181', 'Q96194881', 'Q96196650', 'Q91352161', 'Q96197076', 'Q96194706', 'Q91359006', 'Q91449800', 'Q91457400', 'Q66775427', 'Q91483594', 'Q91360016', 'Q96197414', 'Q96194635', 'Q96194752', 'Q67299553', 'Q91259222', 'Q96196504', 'Q91464529', 'Q96196621', 'Q91455126', 'Q91358019', 'Q91338551', 'Q91468845', 'Q91352021', 'Q87901920', 'Q91461788', 'Q91449064', 'Q96194680', 'Q87901066', 'Q96192347', 'Q96197101', 'Q96197389', 'Q96197912', 'Q91338537', 'Q96196608', 'Q96197579', 'Q96197483', 'Q96197403', 'Q96196513', 'Q67311407', 'Q91361819', 'Q96194929', 'Q67299748', 'Q96197037', 'Q96197398', 'Q91351869', 'Q72293314', 'Q72296166', 'Q91259128', 'Q91258999', 'Q96194263', 'Q96194358', 'Q91453324', 'Q67311412', 'Q87902926', 'Q72298519', 'Q96192287', 'Q67206816', 'Q67206819', 'Q91246360', 'Q91454756', 'Q87902952', 'Q91468706', 'Q91335933', 'Q67311413', 'Q91335956', 'Q91258375', 'Q87903778', 'Q91338548', 'Q91341404', 'Q67300031', 'Q91360913', 'Q91341003', 'Q96194832', 'Q91468222', 'Q67300277', 'Q91457058', 'Q96192473', 'Q91357120', 'Q66775148', 'Q91258304', 'Q91259593', 'Q87901157', 'Q91357522', 'Q91243937', 'Q96197522', 'Q66774971', 'Q91243160', 'Q91466263', 'Q91452012', 'Q91451909', 'Q91468476', 'Q91451791', 'Q67300473', 'Q91356724', 'Q91454611', 'Q91259381', 'Q67300756', 'Q91456245', 'Q96197924', 'Q96197915', 'Q96197003', 'Q91351851', 'Q87902422', 'Q96194138', 'Q96192045', 'Q96192043', 'Q72296546', 'Q72298698', 'Q96192476', 'Q67311415', 'Q91361113', 'Q96197856', 'Q67301035', 'Q91452990', 'Q96196834', 'Q91468283', 'Q67301293', 'Q84082185', 'Q84082238', 'Q84081709', 'Q84082412', 'Q84082207', 'Q84083182', 'Q84082462', 'Q84082854', 'Q84083289', 'Q84083486', 'Q84082398', 'Q84083894', 'Q84083901', 'Q84082862', 'Q84083192', 'Q84082418', 'Q84083906', 'Q84082403', 'Q84082213', 'Q84083237', 'Q84082433', 'Q84083387', 'Q84083911', 'Q84082200', 'Q84082425', 'Q84083199', 'Q84082439', 'Q84082391', 'Q84083918', 'Q84083155', 'Q84082472', 'Q84083082', 'Q84082193', 'Q84082228', 'Q84083929', 'Q84083164', 'Q84082936', 'Q84082966', 'Q84082408', 'Q84083172', 'Q84083003', 'Q66983104', 'Q69996231', 'Q84054534', 'Q84054540', 'Q94957087', 'Q84081365', 'Q94954072', 'Q66987444', 'Q94957132', 'Q84081407', 'Q84081185', 'Q84081210', 'Q84081462', 'Q84049173', 'Q84054550', 'Q84081382', 'Q66993971', 'Q94956772', 'Q84048069', 'Q66994024', 'Q84080844', 'Q84048088', 'Q84080949', 'Q67016081', 'Q84047917', 'Q84048033', 'Q84047481', 'Q84048801', 'Q84081375', 'Q84047394', 'Q84081034', 'Q84049023', 'Q94957246', 'Q84047411', 'Q84080904', 'Q94957766', 'Q84047598', 'Q84080936', 'Q84080956', 'Q84048823', 'Q84080853', 'Q84081006', 'Q84054516', 'Q84080993', 'Q84080942', 'Q84048044', 'Q84081412', 'Q84081358', 'Q84048077', 'Q84080626', 'Q84081424', 'Q84080860', 'Q84080911', 'Q66987293', 'Q84048855', 'Q84048053', 'Q67004686', 'Q84080549', 'Q84081449', 'Q84047115', 'Q84054506', 'Q94954883', 'Q94957249', 'Q67004738', 'Q67004783', 'Q94957221', 'Q84080894', 'Q76191730', 'Q94955115', 'Q84049243', 'Q84081435', 'Q84047365', 'Q94956880', 'Q84080553', 'Q84049086', 'Q94957329', 'Q84081104', 'Q84047437', 'Q94957428', 'Q76195206', 'Q76195316', 'Q94957018', 'Q84081331', 'Q76195379', 'Q67013263', 'Q84081180', 'Q84081197', 'Q84047416', 'Q76195444', 'Q84049473', 'Q84081065', 'Q67016111', 'Q84054526', 'Q94957860', 'Q84048813', 'Q94956433', 'Q67013365', 'Q94957240', 'Q94956268', 'Q94956352', 'Q94957598', 'Q84048864', 'Q84081466', 'Q67013418', 'Q67013826', 'Q84081094', 'Q84048060', 'Q84080659', 'Q76195517', 'Q94955294', 'Q66729629', 'Q84048014', 'Q84081154', 'Q94954957', 'Q94956526', 'Q84080928', 'Q67014726', 'Q76195591', 'Q84048115', 'Q84081012', 'Q84047405', 'Q84047442', 'Q94955013', 'Q84047379', 'Q76195730', 'Q84081391', 'Q76195811', 'Q84047352', 'Q66987349', 'Q84081440', 'Q84080636', 'Q67014794', 'Q84081340', 'Q84048095', 'Q84081348', 'Q84047387', 'Q76195954', 'Q84081477', 'Q76195886', 'Q76196024', 'Q67014826', 'Q84081169', 'Q84047450', 'Q84081088', 'Q84080919', 'Q84081174', 'Q84081191', 'Q84081455', 'Q67014864', 'Q94957649', 'Q84047459', 'Q67014937', 'Q84081400', 'Q76196094', 'Q84048107', 'Q84047467', 'Q84081162', 'Q98002990', 'Q98002994', 'Q98003280', 'Q98003650', 'Q98003666', 'Q98003688', 'Q98003738', 'Q98004338', 'Q98004384', 'Q98004962', 'Q98004969', 'Q98005043', 'Q98019332', 'Q98019357', 'Q98019376', 'Q98020618', 'Q98020640', 'Q98020677', 'Q98020694', 'Q98020760', 'Q98020802', 'Q98021032', 'Q98021132', 'Q98021260', 'Q98021306', 'Q98021429', 'Q98021443', 'Q98022790', 'Q98022793', 'Q98022844', 'Q98022879', 'Q98023051', 'Q98023168', 'Q98023216', 'Q98038902', 'Q98038978', 'Q98039081', 'Q98039123', 'Q98039214', 'Q98039262', 'Q98039469', 'Q98039553', 'Q98039595', 'Q98039634', 'Q98039710', 'Q98039920', 'Q98039957', 'Q98040726', 'Q98045145', 'Q98047018', 'Q98047045', 'Q98047475', 'Q98047500', 'Q98047516', 'Q98047532', 'Q98047604', 'Q98047666', 'Q98047714', 'Q98047737', 'Q98047764', 'Q98047791', 'Q98047821', 'Q98048395', 'Q98048425', 'Q98048465', 'Q98048561', 'Q98048804', 'Q98049011', 'Q98049040', 'Q98049065', 'Q98049646', 'Q98049674', 'Q98049792', 'Q98049902', 'Q98049928', 'Q98051878', 'Q98054864', 'Q98054928', 'Q98054993', 'Q98055020', 'Q98055049', 'Q98055072', 'Q98055099', 'Q98055141', 'Q98055173', 'Q98055201', 'Q98055236', 'Q98055536', 'Q98055559', 'Q98055586', 'Q98055613', 'Q98055641', 'Q98055663', 'Q98055681', 'Q98055708', 'Q98055727', 'Q98055745', 'Q98055764', 'Q98055965', 'Q98056336', 'Q98057607', 'Q98057610', 'Q98057611', 'Q98057609', 'Q98057613', 'Q98057618', 'Q98057625', 'Q98057629', 'Q98057633', 'Q98057638', 'Q98057639', 'Q98057859', 'Q98057857', 'Q98057863', 'Q3338800', 'Q16899449', 'Q67575948', 'Q67590058', 'Q96776807', 'Q97984713', 'Q97984882', 'Q97984960', 'Q97985350', 'Q97985521', 'Q97985966', 'Q97985977', 'Q97987932', 'Q97988077', 'Q97988113', 'Q97988182', 'Q97988236', 'Q97990607', 'Q97990673', 'Q97990703', 'Q97990802', 'Q97990819', 'Q97993956', 'Q97993984', 'Q97994019', 'Q97994067', 'Q97994118', 'Q97994616', 'Q97994749', 'Q97994775', 'Q97996933', 'Q97997158', 'Q97997248', 'Q97997285', 'Q97997434', 'Q97997549', 'Q97997666', 'Q97998264', 'Q97998306', 'Q97998387', 'Q97998409', 'Q97998438', 'Q97998601', 'Q97998637', 'Q97998690', 'Q97998731', 'Q97998748', 'Q97998782', 'Q98000166', 'Q98000167', 'Q98000165', 'Q98000168', 'Q98000175', 'Q98000178', 'Q98000176', 'Q98000184', 'Q98000195', 'Q98000192', 'Q98000199', 'Q98000196', 'Q98000202', 'Q98000200', 'Q98000207', 'Q98000204', 'Q98000208', 'Q98000209', 'Q98000293', 'Q98000388', 'Q98000395', 'Q98000393', 'Q98000401', 'Q98000406', 'Q98000405', 'Q98000409', 'Q98000418', 'Q98001193', 'Q98001302', 'Q98002979', 'Q98002981', 'Q98002989', 'Q98066428', 'Q98066443', 'Q98066440', 'Q98066458', 'Q98066479', 'Q98066485', 'Q98066493', 'Q98066500', 'Q98066515', 'Q98066559', 'Q98066578', 'Q98066649', 'Q98066657', 'Q98066668', 'Q98066674', 'Q98066679', 'Q98066685', 'Q98066689', 'Q98066695', 'Q98066713', 'Q98066811', 'Q98066817', 'Q98066845', 'Q98066873', 'Q98066908', 'Q98066915', 'Q98066921', 'Q98066927', 'Q98066939', 'Q98066945', 'Q98066955', 'Q98066962', 'Q98066968', 'Q98066977', 'Q98066983', 'Q98066991', 'Q98066996', 'Q98067002', 'Q98067007', 'Q98067012', 'Q98067017', 'Q98067022', 'Q98067173', 'Q98067182', 'Q98067188', 'Q98067193', 'Q98067199', 'Q98068149', 'Q98068174', 'Q98068184', 'Q98068575', 'Q98068624', 'Q98068724', 'Q98068731', 'Q98068737', 'Q98068759', 'Q98068765', 'Q98068772', 'Q98068781', 'Q98068789', 'Q98068797', 'Q98068802', 'Q98068808', 'Q98068818', 'Q98068824', 'Q98068888', 'Q98068920', 'Q98068936', 'Q98068944', 'Q98068951', 'Q98068956', 'Q98068961', 'Q98069039', 'Q98069047', 'Q98069055', 'Q98069094', 'Q98069106', 'Q98069122', 'Q98069130', 'Q98069140', 'Q98069149', 'Q98069156', 'Q98069162', 'Q98069172', 'Q98069178', 'Q98069184', 'Q98069196', 'Q98069202', 'Q98069210', 'Q98069216', 'Q98069758', 'Q98069771', 'Q98069779', 'Q98069783', 'Q98069787', 'Q98069998', 'Q98071571', 'Q98072105', 'Q98072115', 'Q98072138', 'Q98072139', 'Q98072162', 'Q98072167', 'Q98072164', 'Q98072168', 'Q98072187', 'Q98072190', 'Q98072189', 'Q98072193', 'Q98072206', 'Q98072207', 'Q98072210', 'Q98072250', 'Q98072267', 'Q98072337', 'Q98072351', 'Q98072381', 'Q98072538', 'Q98072542', 'Q98072540', 'Q98072554', 'Q98072558', 'Q98072563', 'Q98072566', 'Q98072565', 'Q98072568', 'Q98072569', 'Q98072595', 'Q98072593', 'Q98072598', 'Q98072641', 'Q98072646', 'Q98072651', 'Q98072648', 'Q98072906', 'Q98073223', 'Q98073221', 'Q98073450', 'Q98073454', 'Q98073453', 'Q98073457', 'Q98073474', 'Q98073479', 'Q98073477', 'Q98073482', 'Q98073486', 'Q98074108', 'Q98074119', 'Q98074122', 'Q98074130', 'Q98074136', 'Q98074144', 'Q98074151', 'Q98074149', 'Q98074154', 'Q98074158', 'Q98074163', 'Q98074167', 'Q98074170', 'Q98074177', 'Q98074182', 'Q98074185', 'Q98074190', 'Q98074195', 'Q98075852', 'Q98075944', 'Q98075948', 'Q98075954', 'Q98075999', 'Q98076008', 'Q98076015', 'Q98076012', 'Q98076074', 'Q98076456', 'Q98076462', 'Q98076468', 'Q98083219', 'Q98083230', 'Q98083256', 'Q98083273', 'Q98083308', 'Q98083355', 'Q98083369', 'Q98083383', 'Q98083393', 'Q98083419', 'Q98083428', 'Q98083462', 'Q98083474', 'Q98083488', 'Q98083593', 'Q98083602', 'Q98083611', 'Q98083619', 'Q98083643', 'Q98083654', 'Q98083667', 'Q98083675', 'Q98083749', 'Q98083826', 'Q98057867', 'Q98057864', 'Q98057868', 'Q98057869', 'Q98058012', 'Q98058019', 'Q98058457', 'Q98058482', 'Q98058494', 'Q98058495', 'Q98058534', 'Q98058555', 'Q98058552', 'Q98058559', 'Q98058561', 'Q98058581', 'Q98058622', 'Q98058623', 'Q98058627', 'Q98058625', 'Q98058630', 'Q98058631', 'Q98058633', 'Q98058687', 'Q98058725', 'Q98058739', 'Q98058742', 'Q98058798', 'Q98058799', 'Q98058796', 'Q98058801', 'Q98060014', 'Q98060016', 'Q98060017', 'Q98060021', 'Q98060027', 'Q98060025', 'Q98060029', 'Q98060059', 'Q98060056', 'Q98060063', 'Q98060071', 'Q98060068', 'Q98060076', 'Q98060083', 'Q98060081', 'Q98060084', 'Q98060091', 'Q98060106', 'Q98060107', 'Q98060104', 'Q98060108', 'Q98060109', 'Q98060113', 'Q98060117', 'Q98060122', 'Q98060127', 'Q98060124', 'Q98060125', 'Q98060129', 'Q98060134', 'Q98060133', 'Q98060138', 'Q98060136', 'Q98060140', 'Q98060141', 'Q98060307', 'Q98060318', 'Q98060323', 'Q98060321', 'Q98061931', 'Q98062157', 'Q98062189', 'Q98062216', 'Q98062245', 'Q98062272', 'Q98062297', 'Q98062321', 'Q98062352', 'Q98062376', 'Q98062402', 'Q98062813', 'Q98062914', 'Q98062995', 'Q98063017', 'Q98063044', 'Q98063067', 'Q98063093', 'Q98063120', 'Q98063146', 'Q98063171', 'Q98063191', 'Q98063216', 'Q98063587', 'Q98063962', 'Q98063990', 'Q98064019', 'Q98064067', 'Q98066413', 'Q98066418', 'Q98112733', 'Q98112738', 'Q98112736', 'Q98112742', 'Q98112749', 'Q98112753', 'Q98112765', 'Q98112770', 'Q98112774', 'Q98112778', 'Q98112781', 'Q98112784', 'Q98112815', 'Q98112818', 'Q98112819', 'Q98112816', 'Q98112823', 'Q98112821', 'Q98112826', 'Q98112827', 'Q98112830', 'Q98112828', 'Q98112908', 'Q98112918', 'Q98112928', 'Q98112939', 'Q98112943', 'Q98112945', 'Q98119425', 'Q98119599', 'Q98119633', 'Q98119642', 'Q98119646', 'Q98119651', 'Q98119653', 'Q98119663', 'Q98119660', 'Q98119670', 'Q98119677', 'Q98119684', 'Q98119693', 'Q98119700', 'Q98119705', 'Q98119721', 'Q98119729', 'Q98119738', 'Q98119744', 'Q98119748', 'Q98119756', 'Q98119761', 'Q98119768', 'Q98119773', 'Q98119779', 'Q98119789', 'Q98119797', 'Q98119810', 'Q98119828', 'Q98119836', 'Q98119841', 'Q98119846', 'Q98119851', 'Q98119858', 'Q98119864', 'Q98119869', 'Q98119877', 'Q98119881', 'Q98119885', 'Q98119890', 'Q98119894', 'Q98119899', 'Q98120757', 'Q98120799', 'Q98120806', 'Q98120811', 'Q98120848', 'Q98121105', 'Q98121920', 'Q98121962', 'Q98121985', 'Q98121989', 'Q98122012', 'Q98122050', 'Q98122057', 'Q98122063', 'Q98122071', 'Q98122077', 'Q98122111', 'Q98122140', 'Q98122147', 'Q98122152', 'Q98122157', 'Q98122162', 'Q98122194', 'Q98123037', 'Q98123048', 'Q98123134', 'Q98123141', 'Q98123165', 'Q98123204', 'Q98123209', 'Q98096684', 'Q98096689', 'Q98096693', 'Q98096875'
      )
    )
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...