6

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

  • 13
    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 10 Years 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.. :) – Himanshu Jansari 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 10 Years Wizard Oct 10 '13 at 10:41
15

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            ║
║   ... ║                 ║           ║              ║                         ║
╚═══════╩═════════════════╩═══════════╩══════════════╩═════════════════════════╝
| improve this answer | |
11

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  
| 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 10 Years Wizard May 23 '13 at 13:33
6

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

| improve this answer | |
  • 6
    There is an interesting competiting between his reputation and profile views. – fedorqui 'SO stop harming' 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 .