What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

Can you please tell me how to find the user or developer that has the highest number of profile views?

share|improve this question
12  
Didn't look, but I can pretty much guarantee that on Stack Overflow that is Jon Skeet. –  Oded May 23 '13 at 13:23
    
@Oded Yeah, that i know but may be he is base on reputation but i want to check out base on profile view :) –  chintan khetiya May 23 '13 at 13:25
1  
Um. Yes. Also that. –  Oded May 23 '13 at 13:25
2  
@chintankhetiya There's a pretty strong correlation between reputation and profile views, I imagine. –  Anthony Grist May 23 '13 at 13:26
8  
Jon Skeet is answer to "who is the user with the most/highest/maximum X" questions, for great many X values. –  Shadow Wizard May 23 '13 at 13:28
    
Don't you think that my question is also deserve for up votes. –  chintan khetiya May 23 '13 at 13:31
4  
Not... really... I don't see the significance in having the most profile views out of any user. –  BoltClock's a Unicorn May 23 '13 at 13:41
    
Last time I looked, Jon Skeet had as many profile views as reputation points. –  Linuxios May 23 '13 at 13:45
    
@ShaWizDowArd - Not in every highest X. E.g. downvotes, review etc.. :) –  hims056 Oct 10 '13 at 10:39
2  
@hims056 yeah, though if he'll focus his attention on reviews he'll reach the top before we can say "Jon Skeet". :D –  Shadow Wizard Oct 10 '13 at 10:41

3 Answers 3

up vote 13 down vote accepted

Here you go with Data Explorer query

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

Output:

╔═══════╦═════════════════╦═══════════╦══════════════╦═════════════════════════╗
║ Rank  ║      User       ║    Views  ║  Reputation  ║        Location         ║
╠═══════╬═════════════════╬═══════════╬══════════════╬═════════════════════════╣
║     1 ║ Jon Skeet       ║    639947 ║       610427 ║ Reading, United Kingdom ║
║     2 ║ Eric Lippert    ║    176837 ║       249482 ║ Seattle, WA             ║
║     3 ║ Marc Gravell    ║    133054 ║       423970 ║ Forest of Dean, UK      ║
║     4 ║ Jeff Atwood     ║    122506 ║        27684 ║ El Cerrito, CA          ║
║     5 ║ BalusC          ║    115142 ║       425228 ║ Willemstad, Curaçao     ║
║     6 ║ Darin Dimitrov  ║    106748 ║       466354 ║ Sofia, Bulgaria         ║
║     7 ║ Bill the Lizard ║     82214 ║       124132 ║ Charlotte, NC           ║
║     8 ║ Hans Passant    ║     80089 ║       389208 ║ Madison, WI             ║
║     9 ║ CommonsWare     ║     75888 ║       322395 ║ Where You Least Expect  ║
║    10 ║ casperOne       ║     62554 ║        45832 ║ Brooklyn, NY            ║
║   ... ║                 ║           ║              ║                         ║
╚═══════╩═════════════════╩═══════════╩══════════════╩═════════════════════════╝
share|improve this answer
13  
Amazing how outdated the data is, 559,060 views live vs. "only" 195,496 in the data explorer. Oh, there is open bug report. –  Shadow Wizard May 23 '13 at 13:26
    
@ShaWizDowArd - Yeah thanks for adding a bounty –  hims056 May 23 '13 at 13:33
2  
That was back when Rich B was one of the most well-known users. He's 17th according to the Data Explorer and he might have had the most profile views of anyone (save possibly Jeff Atwood) at one point. –  mmyers May 24 '13 at 4:58

You can use the Data Explorer for this. At the time of writing, here's the top 10:

Id    Reputation DisplayName            Views  

----- ---------- ---------------------- ------ 

22656 566017     Jon Skeet              195496 
23354 392057     Marc Gravell           49421  
1     25815      Jeff Atwood            41072  
88656 224983     Eric Lippert           36676  
4     19569      Joel Spolsky           32408  
95810 260640     Alex Martelli          26717  
18393 218278     cletus                 23156  
34509 202424     Johannes Schaub - litb 19393  
33708 162443     Mehrdad Afshari        19160  
1288  112464     Bill the Lizard        18229  
share|improve this answer
3  
These counts are awfully low, actually. I'd be in 8th place according to my profile counter.. –  Martijn Pieters May 23 '13 at 13:28
    
Did not realize how far behind that is. –  user7116 May 23 '13 at 13:28
2  
@MartijnPieters yep. :/ –  Shadow Wizard May 23 '13 at 13:33

I believe the property you're looking for is static readonly.

share|improve this answer
6  
There is an interesting competiting between his reputation and profile views. –  fedorqui May 23 '13 at 13:24
    
yeah ,that was the reason behind to ask :) –  chintan khetiya May 23 '13 at 13:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .