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) AS creations
FROM
	revision JOIN actor ON rev_actor=actor_id JOIN page ON rev_page=page_id
WHERE
	rev_parent_id=0
	AND rev_page IN (
        SELECT
      		page_id
      	FROM
      		page
      	WHERE
      		page_namespace=0
      		AND page_title IN (
                'Q66983327', 'Q96194629', 'Q67301591', 'Q87145400', 'Q96197400', 'Q96194859', 'Q96194872', 'Q96197444', 'Q96194843', 'Q96196653', 'Q91495669', 'Q91452662', 'Q96197528', 'Q91246392', 'Q91359698', 'Q91450055', 'Q91361889', 'Q87900301', 'Q96192972', 'Q87903211', 'Q96196522', 'Q91495543', 'Q91340951', 'Q96197546', 'Q66781964', 'Q91245789', 'Q87902199', 'Q96192986', 'Q96194773', 'Q96192312', 'Q91454256', 'Q96194653', 'Q91461796', 'Q91246387', 'Q87900351', 'Q96195050', 'Q91340870', 'Q91360822', 'Q96194240', 'Q96197113', 'Q96194820', 'Q96197032', 'Q96195036', 'Q96196993', 'Q96197551', 'Q96194636', 'Q87902206', 'Q91244248', 'Q91461786', 'Q87900292', 'Q91451087', 'Q87902960', 'Q91259968', 'Q87901250', 'Q96192999', 'Q67301877', 'Q91359883', 'Q96192475', 'Q96194478', 'Q91450879', 'Q87902203', 'Q91359578', 'Q66773712', 'Q91338530', 'Q91338508', 'Q96194884', 'Q96194136', 'Q91454981', 'Q96196968', 'Q91341297', 'Q96194955', 'Q96194828', 'Q87902964', 'Q67302266', 'Q96197408', 'Q91458252', 'Q91468250', 'Q96196549', 'Q87900668', 'Q91361491', 'Q66773700', 'Q96196599', 'Q91248374', 'Q96195013', 'Q91453438', 'Q91458040', 'Q66773697', 'Q66765330', 'Q96196945', 'Q91483462', 'Q96196663', 'Q72296873', 'Q91464598', 'Q87902957', 'Q91359454', 'Q96194987', 'Q66765188', 'Q91361708', 'Q91459370', 'Q67302557', 'Q96197571', 'Q91245657', 'Q91248617', 'Q91466124', 'Q96197899', 'Q87900794', 'Q87903648', 'Q87902967', 'Q87903554', 'Q91452473', 'Q91355914', 'Q91259922', 'Q96197599', 'Q96196953', 'Q96196982', 'Q96196920', 'Q91495408', 'Q91452786', 'Q96194141', 'Q91259312', 'Q91257993', 'Q67303983', 'Q96194893', 'Q96197565', 'Q66781770', 'Q91464521', 'Q96197082', 'Q96196907', 'Q67296157', 'Q96192289', 'Q91451650', 'Q91453084', 'Q91248622', 'Q91452892', 'Q91244137', 'Q87900296', 'Q96196858', 'Q91249007', 'Q91340805', 'Q67304426', 'Q67296355', 'Q87902633', 'Q96197010', 'Q96197410', 'Q67296622', 'Q87902771', 'Q96196962', 'Q96196651', 'Q87903414', 'Q96194634', 'Q91455973', 'Q87902213', 'Q91357729', 'Q96194896', 'Q96192107', 'Q91357269', 'Q96197391', 'Q96197468', 'Q96197412', 'Q96197394', 'Q91341485', 'Q96196639', 'Q91335970', 'Q91360731', 'Q96194318', 'Q87145446', 'Q96192047', 'Q91451525', 'Q96195650', 'Q91355751', 'Q91456909', 'Q91340795', 'Q96196938', 'Q91460670', 'Q91463408', 'Q91340791', 'Q91468262', 'Q96194801', 'Q67304863', 'Q96194888', 'Q96195025', 'Q91353910', 'Q96194329', 'Q96194343', 'Q91450790', 'Q91450693', 'Q91248610', 'Q91453701', 'Q91453597', 'Q91452197', 'Q91338829', 'Q66777826', 'Q91359343', 'Q91360607', 'Q96197982', 'Q91244668', 'Q91360318', 'Q96196634', 'Q67296864', 'Q87145451', 'Q96194657', 'Q91338309', 'Q87903721', 'Q91484998', 'Q91259664', 'Q96194145', 'Q72297629', 'Q72297800', 'Q87901439', 'Q91248506', 'Q91335949', 'Q66781654', 'Q96197941', 'Q91351913', 'Q87901760', 'Q96196840', 'Q96197052', 'Q91259876', 'Q91248605', 'Q91248413', 'Q91483295', 'Q91250614', 'Q67305755', 'Q96196525', 'Q96195005', 'Q91468233', 'Q96197428', 'Q91351873', 'Q96196826', 'Q91461793', 'Q91457521', 'Q91338687', 'Q67306180', 'Q91463322', 'Q91465946', 'Q91468243', 'Q67298606', 'Q91458138', 'Q96194977', 'Q91461792', 'Q91456372', 'Q87902525', 'Q91457265', 'Q96196966', 'Q96192290', 'Q91460667', 'Q96192038', 'Q91464540', 'Q66777819', 'Q96197392', 'Q91456770', 'Q96192074', 'Q91359143', 'Q96194890', 'Q96197843', 'Q67306644', 'Q96194898', 'Q96192051', 'Q96197935', 'Q91356881', 'Q91357385', 'Q87902221', 'Q67298831', 'Q96196526', 'Q96196510', 'Q96196517', 'Q96197954', 'Q91455858', 'Q91455733', 'Q91341230', 'Q66777795', 'Q96194211', 'Q91248919', 'Q96194939', 'Q91259728', 'Q96197090', 'Q96194650', 'Q91451279', 'Q91450575', 'Q96196570', 'Q96194139', 'Q96192325', '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'
            )
    )
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...