Why are my SEDE results inaccurate/obsolete/incorrect/outdated?
I just went to
data.StackExchange and tried top users in Singapore Query, I didn't see my name in the first half of the list, in fact my name appears as 984
and then I modified and ran this query, thinking may be it is not picking up correctly, so provide the username.
SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation FROM Users WHERE (LOWER(Location) LIKE '%singapore%' OR UPPER(Location) LIKE '%SG') AND DisplayName = 'mprabhat' ORDER BY Reputation DESC;
Result shows I have just 1 reputation, Why ?