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
add comment

3 Answers

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
add comment

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
add comment

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
add comment

You must log in to answer this question.

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