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