Employee posts on Meta.SO

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

select top(100) p.Id as [Post Link], u.Id as [User Link], p.CreationDate
from Posts as p
join Users as u on p.OwnerUserId = u.Id
where u.AccountId in (2,3,4,41,75,620,1083,2921,4188,5960,7598,11975,20808,23123,29738,32917,34933,37099,51875,59521,64170,72238,87273,89201,102159,160328,179006,188123,272910,328700,459488,463168,466409,996254,1036558,1345480,1399708,1454845,1458270,1653707,1992677,2815887,3337610,3979517,5161054,6254215,7156020,7228886,7356150,7401004,7846121,8713257,10049901,11112584,13924871,14260853,14281589,15375904,15800544)
order by p.CreationDate desc

-- employee AccountIds available via API:
-- (await (await fetch('https://api.stackexchange.com/2.2/users/moderators?site=superuser&pagesize=100&filter=!26cNQ1aMobyk')).json()).items.filter(i => i.is_employee).map(i => i.account_id).sort((a, b) => a - b).join(',')
-- SO has a different list:
-- (await (await fetch('https://api.stackexchange.com/2.2/users/moderators?site=stackoverflow&pagesize=100&filter=!26cNQ1aMobyk')).json()).items.filter(i => i.is_employee).map(i => i.account_id).sort((a, b) => a - b).join(',')

Enter Parameters

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