Q&A about the site for teachers and students of the Esperanto language
-- Step 2: Extract posts for the selected users WITH PostBatch AS ( SELECT p.Id AS PostId, p.Title, p.Body, p.OwnerUserId AS UserId, u.DisplayName, t.TagName, u.Location, ROW_NUMBER() OVER (PARTITION BY p.OwnerUserId ORDER BY p.CreationDate DESC) AS PostRowNum FROM Posts p INNER JOIN Users u ON p.OwnerUserId = u.Id INNER JOIN PostTags pt ON p.Id = pt.PostId INNER JOIN Tags t ON pt.TagId = t.Id WHERE LOWER(t.TagName) IN ('python', 'java', 'csharp', 'php', 'javascript', 'go', 'swift') -- Programming languages filter AND p.OwnerUserId IN (605153,1206613,521070,51,7409220,5353753,871910,67824,1113002,1120015,617373,827927,435605,6539317,3191896,5311735,960558,768110,62192,1646240,279776,735446,356716,637669,286595,403105,188826,3523579,2176945,936986,388427,512042,76393,1349754,417810,1467858,4842742,19772,817657,1430927,75284,12123,470717,1503018,1024794,860478,3563993,654891,4251546,2427222,185919,2894369,5997596,1542806,435904,909085,1031981,11227781,558018,2363866,1052325,1863950,482864,411928,677881,7093741,1709725,37664,55808,10340970,2729109,2930152,785923,4691207,3523935,8107092,8412192,136132,174622,2513872,2746582,961314,10199138,3473770,799734,337988,3278063,9279003,1025379,779076,56995,18382,3239341,126039,8601760,10959940,704703,1168156,29347,1869846) ) SELECT p.PostId, p.Title AS PostTitle, p.Body AS PostBody, p.UserId, P.DisplayName AS UserName, p.Location AS UserCountry, p.TagName AS PostTag FROM PostBatch p WHERE p.PostRowNum BETWEEN 0 AND 500;