0

Please login or register to vote for this query.

(click on this box to dismiss)

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(55732, 2541, 18926, 2543, 1220637, 18933, 2083318, 363002, 15088, 10755, 10759, 4290136, 2927114, 617559, 18961, 215571, 1444372, 1165845, 1624598, 109079, 2586, 2910747, 10780, 2589, 436766, 281119, 2593, 2594, 23643, 10788, 18981, 2598, 707111, 2603, 1059372, 297518, 435, 2612, 2614, 1955593, 10808, 2617, 109114, 2619, 207421, 43582, 35392, 2626, 27204, 584262, 1002058, 2637, 568021, 15459, 2644, 530190, 2647, 2648, 2649, 3907, 6859356, 43613, 346719, 2247264, 2189927, 3746411, 10861, 2670, 3230321, 2674, 2678, 1428089, 2682, 76413, 2686, 247573, 1116802, 2695, 2697, 772748, 43662, 10897, 2710, 244484, 2718, 1556933, 535203, 379556, 43685, 289447, 846504, 2730, 60075, 104021, 76472, 2745, 420540, 166589, 2750, 453314, 10947, 2757, 445126, 1300257, 215752, 10954, 2768, 2773, 355030, 3193, 577764, 330457, 19163, 34463, 19165, 27358, 2783, 494307, 2789, 142061, 68336, 1403638, 268074, 18219, 2822, 2823, 248584, 2828, 2831, 2832, 125713, 315158, 1002260, 305945, 2844, 2575134, 2847, 401085, 19235, 633638, 806440, 11052, 207661, 2862, 2863, 3517232, 1600305, 1198898, 689971, 1503127, 305973, 797495, 1616697, 2902842, 453435, 584508, 2882, 3211, 19272, 1805129, 3640138, 11084, 2894, 1690448, 813905, 1861837, 2900, 2902, 239054, 2906, 2908, 1510544, 2915, 19302, 3885927, 240488, 2329450, 1502059, 912236, 2925, 2730862, 2927, 2933, 2100086, 2935, 2937, 248701, 11138, 2948, 2951, 492, 2954, 265100, 2957, 2959, 375960, 2963, 5360532, 2965, 142233, 2974, 2975, 2976, 2978, 16881, 142249, 2988, 650157, 1039517, 2993, 1534898, 289715, 224182, 84919, 3002, 3005, 150463, 281545, 3018, 19404, 43981, 52176, 199635, 2100180, 3029, 1379286, 158680, 1871, 1267536, 11234, 3043, 11236)

fork query

edited mar 29 17

created mar 29 17 anonymous