Gold Badges achieved after a high rep user stopped logging in

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

select b.id as badge_id, b.name, b.date as badge_achievement_date, u.views, u.id as [User Link], u.reputation, u.lastaccessdate, concat('https://www.linkedin.com/search/results/all/?keywords=', '"', u.displayname,'"') as linkedin_search
from badges b inner join users u
on u.id = b.userid
where u.lastaccessdate < '2020-01-01'
and u.reputation > 10000
and u.views > 5000
and b.date > '2020-01-01'
and b.class = 1

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results