Q&A for professionals, academics, and students working within the systems development life cycle
select a.Id as answererId, u.Id as askerId from Users a inner join Posts ans on ans.OwnerUserId=a.Id inner join Posts que on ans.ParentId=que.Id inner join Users u on u.Id=que.OwnerUserId where que.PostTypeId=1 and a.Id in(2010, 19217, 2016, 2018, 288671, 1017830, 10216, 2025, 1894055, 2030, 104816, 37203, 1345527, 34813, 2046, 781312, 1091587, 10245, 1878022, 3278858, 2648077, 2063, 1116177, 1943570, 67606, 2140183, 2279448, 968732, 1812509, 10272, 2083, 2084, 2086, 3311658, 1067051, 3917868, 960558, 239663, 2098, 31167, 843888, 747579, 2108, 461834, 1329214, 288831, 510017, 10307, 1255493, 2119, 10314, 1214542, 10320, 10322, 2131, 2132, 2134, 10333, 2041950, 788575, 18528, 370786, 452708, 133221, 2150, 18535, 723050, 59501, 75889, 10354, 1067124, 436341, 2166, 361, 977017, 657525, 10369, 551045, 3389121, 305288, 288906, 329870, 2193, 1542290, 1806702, 1435800, 10394, 886941, 428190, 9925, 84131, 6400165, 5105831, 84136, 59561, 3090602, 1683826, 2730161, 321714, 1427636, 2230, 2924916, 157882, 583867, 2238, 18625, 5596875, 116932, 215237, 108743, 174284, 2253, 1741, 2257, 3270866, 2814021, 981001, 985306, 18655, 1460448, 4999394, 2275, 10468, 2279, 1509608, 10474, 2284, 2287, 2795762, 223478, 9940, 2298, 383, 1689852, 1191400, 493823, 4612829, 1075459, 698632, 1853705, 6375692, 2326914, 4720910, 18706, 20092, 18715, 534812, 543005, 18721, 126001, 878888, 18729, 2346, 1599792, 255710, 2362, 2066143, 2367, 10560, 1395009, 567620, 2374, 141639, 2345289, 1149259, 35149, 2384, 3931192, 2386, 330067, 61838, 2083160, 10585, 182619, 2405, 479633, 43371, 2559037, 5285608, 4221299, 1769, 2424, 878969, 1722752, 27009, 2437, 3950982, 43399, 67976, 1231241, 2443, 149901, 214765, 1326147, 2453, 20889, 313756, 65004, 18846, 51616, 797092, 2469, 166312, 2374900, 2474, 2608199, 2477, 289203, 2486, 5615038, 10680, 18874, 27067, 477628, 14069, 969552, 264642, 3148228, 2501, 10696, 1354185, 2506, 1812942, 73831, 2877905, 313810, 68054, 2525, 229797, 395744, 18914, 387558, 10728, 92650)