0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

DECLARE @pixelCreateDate datetime;
DECLARE @pixelRep int;

select @pixelCreateDate = CreationDate, @pixelRep = Reputation from Users
  where Id = 27134;
  
select distinct Users.DisplayName, Users.Reputation, Users.CreationDate, Users.LastAccessDate
from Users, Posts
where Users.Reputation < @pixelRep
  and DateDiff(mm, Users.CreationDate, @pixelCreateDate) > 18
  and DateDiff(dd, @pixelCreateDate, Users.LastAccessDate) > 0
  and (select count(*) from Posts
    where Users.Id = Posts.OwnerUserId
    and DateDiff(dd, @pixelCreateDate, Posts.CreationDate) > 0) > 0
order by Reputation desc;

view current version

edited jul 31 12

created jul 31 12 MBraedley