VladimirAlexiev added a comment.
The following query (from https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/query_optimization#Distinct_term_scan,_and_group_by_and_count_optimization) SELECT ?p (COUNT(?p) AS ?count) WHERE { [] ?p [] . } GROUP BY ?p order by desc(?count) when ran at the WD query service <https://query.wikidata.org/#SELECT%20%3Fp%20%28COUNT%28%3Fp%29%20AS%20%3Fcount%29%0AWHERE%20%7B%20%5B%5D%20%3Fp%20%5B%5D%20.%20%7D%0AGROUP%20BY%20%3Fp%20order%20by%20desc%28%3Fcount%29> shows the interesting counts: - wikibase:statements 107093728 - wikibase:identifiers 105929733 - wikibase:sitelinks 105928930 I have no idea why the numbers are slightly different, and less than the total 107,093,911 WD items. TASK DETAIL https://phabricator.wikimedia.org/T270764 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: VladimirAlexiev Cc: Nicksinch, Aklapper, VladimirAlexiev, Danny_Benjafield_WMDE, Astuthiodit_1, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected]
