0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

-- Enter Query Title
-- Enter Query Description


select distinct top 100
  u.id as [User Link],
  round((100.0 * (u.Reputation/10)) / (u.Upvotes+1), 2) as [Ratio %],
  u.Reputation as Rep, 
  u.UpVotes as [+ Votes],
  u.DownVotes [- Votes],
  u.location,
  u.aboutme,
  u.websiteurl,
  (select count(*) as c
   from   posts 
   where  owneruserid = u.id 
     and  tags like '%python%') as Pcount,  
  (select count(*) as c
   from   posts 
   where  owneruserid = u.id 
     and  tags like '%memcached%') as Mcount
from Users u
where u.websiteurl != ''
  and u.age < 40
--order by [Ratio %] desc

  and   (select count(*)
         from   posts 
         where  owneruserid = u.id 
         and  tags like '%memcached%') > 5
order by u.Reputation desc

fork query

created mar 24 11 anonymous