Addshore added a comment. You do need distinct if you want the correct number there! I was simply pointing out that distinct is what makes the query a long one, not actually the count.
I think the issue with potential duplication is being addressed and the datasets are being rebuilt this week https://phabricator.wikimedia.org/T116622#1839670 My goal is to have these number by the end of the year, hence my working around any potential problems right now.! TASK DETAIL https://phabricator.wikimedia.org/T117234 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Christopher, Addshore Cc: Lydia_Pintscher, StudiesWorld, Addshore, Christopher, Aklapper, Wikidata-bugs, aude, Mbch331 _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
