Addshore added a comment.
SELECT COUNT(*) FROM (
SELECT DISTINCT page_id
FROM page
INNER JOIN slots ON slot_revision_id = page_latest
INNER JOIN content ON slot_content_id = content_id AND content_size >
122
INNER JOIN slot_roles ON role_id = slot_role_id AND role_name =
'mediainfo'
UNION
SELECT DISTINCT page_id
FROM page
INNER JOIN wbc_entity_usage ON eu_page_id = page_id
WHERE page_namespace = 6
) AS t;
Is it just me or will this query be counting some pages twice?
TASK DETAIL
https://phabricator.wikimedia.org/T239565
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Milimetric, Addshore
Cc: Abit, Ramsey-WMF, kzimmerman, Addshore, matthiasmullie, gsingers,
Mayakp.wiki, Ladsgroup, nettrom_WMF, Cparle, Nuria, Milimetric, mpopov,
4748kitoko, darthmon_wmde, DannyS712, Nandana, JKSTNK, Akovalyov, Lahi,
PDrouin-WMF, Gq86, E1presidente, Anooprao, SandraF_WMF, GoranSMilovanovic,
QZanden, Tramullas, Acer, LawExplorer, Salgo60, Silverfish, _jensen,
rosalieper, Scott_WUaS, Susannaanas, JAllemandou, Jane023, terrrydactyl,
Wikidata-bugs, Base, aude, Ricordisamoa, Wesalius, Lydia_Pintscher,
Fabrice_Florin, Raymond, Steinsplitter, Mbch331, jeremyb
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
