0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  u.Id AS UserId,
  COUNT(DISTINCT q.Id) AS Questions,
  COUNT(DISTINCT a.Id) AS Answers,
  CAST(SUM(CAST(u.Upvotes AS BIGINT)) AS BIGINT) AS Upvotes,
  CAST(SUM(CAST(u.DownVotes AS BIGINT)) AS BIGINT) AS Downvotes,
  u.CreationDate AS AccountCreated,
  CAST(SUM(CAST(q.ViewCount AS BIGINT)) AS BIGINT) AS QuestionsViewed,
  COUNT(DISTINCT f.PostId) AS Favourites,
  CAST(SUM(CAST(u.Views AS BIGINT)) AS BIGINT) AS ProfileViews
FROM
  Users u
LEFT JOIN
  Posts q ON u.Id = q.OwnerUserId AND q.PostTypeId = 1 AND q.CreationDate >= '2021-01-01'
LEFT JOIN
  Posts a ON u.Id = a.OwnerUserId AND a.PostTypeId = 2 AND a.CreationDate >= '2021-01-01'
LEFT JOIN
  Votes v ON u.Id = v.UserId AND v.CreationDate >= '2021-01-01'
LEFT JOIN
  PostHistory f ON u.Id = f.UserId AND f.PostHistoryTypeId = 5 AND f.CreationDate >= '2021-01-01'
WHERE
  u.Id IN (1, 3, 4, 5, 13, 16, 17, 19, 24, 29, 33, 35, 37, 40, 43, 44, 48, 50, 51, 55, 56, 57, 58, 60, 67, 72, 75, 77, 91, 95, 96, 103, 105, 108, 112, 114, 115, 116, 117, 118, 136, 139, 145, 147, 148, 149, 150, 152, 156, 157, 161, 173, 186, 189, 198, 199, 200, 202, 204, 206, 207, 210, 216, 219, 225, 227, 243, 244, 245, 247, 253, 255, 258, 260, 265, 268, 285, 302, 305, 318, 320, 322, 326, 331, 339, 342, 354, 355, 358, 359, 363, 371, 376, 382, 384, 396, 411, 415, 417, 418, 423, 426, 432, 437, 448, 463, 470, 472, 476, 477, 481, 482, 484, 486, 489, 492, 499, 500,
506, 507, 510, 519, 528, 533, 544, 548, 549, 550, 557, 560, 568, 572, 573, 577, 582, 586, 607, 609, 615, 620, 624, 625, 630, 632, 639, 646, 650, 653, 657, 677, 680, 684, 691, 698, 703, 706, 713, 726, 729, 731, 732, 735, 736, 740, 741, 742, 743, 745, 747, 751, 756, 767, 774, 775, 782, 807, 809, 813, 814, 820, 822, 831, 834, 841, 842, 859, 869, 878, 881, 884, 886, 890, 891, 893, 898, 905, 909, 914, 917, 936, 947, 954, 956, 963, 966, 967, 969, 971, 974, 976, 995, 997, 999, 1013, 1026, 1034, 1039, 1042, 1055, 1063, 1067, 1070, 1074, 1078, 1083, 1101, 1107, 1108, 1109, 1117, 1131, 1133, 1137, 1142, 1153, 1154, 1156, 1157, 1163, 1173, 1175, 1181, 1196, 1200, 1204, 1206, 1219, 1224, 1226, 1231, 1233, 1238, 1248, 1249, 1254, 1264, 1276, 1278, 1280, 1288, 1296, 1297, 1300, 1304, 1319, 1321, 1324, 1328, 1337, 1339, 1346, 1363, 1367, 1369, 1381, 1388, 1403, 1407, 1409, 1412, 1414, 1418, 1438, 1449, 1450, 1454, 1455, 1456, 1463, 1467, 1474, 1478, 1483, 1490, 1492, 1497, 1503, 1532, 1537, 1540, 1549, 1551, 1554, 1559, 1563, 1591, 1599, 1606, 1622, 1627, 1629, 1630, 1632, 1633, 1644, 1654, 1659, 1666, 1676, 1680, 1691, 1708, 1709, 1714, 1727, 1738, 1741, 1754, 1755, 1758, 1768, 1771, 1782, 1785, 1786, 1797, 1801, 1804, 1812, 1816, 1831, 1843, 1849, 1852, 1853, 1870, 1886, 1889, 1891, 1894, 1895, 1897, 1899, 1904, 1907, 1915, 1916, 1922, 1942, 1943, 1944, 1946, 1950, 1954, 1968, 1969, 1980, 1984, 1988, 1999, 2010, 2012, 2025, 2029, 2030, 2039, 2041, 2044, 2049, 2050, 2062, 2064, 2069, 2070, 2077, 2079, 2080, 2084, 2094, 2114, 2118, 2130, 2131, 2134, 2138, 2140, 2144, 2145, 2154, 2164, 2168, 2177, 2183, 2187, 2196, 2210, 2214, 2218, 2222, 2239, 2249, 2250, 2260, 2266, 2271, 2281, 2285, 2287, 2291, 2305, 2310, 2314, 2329, 2338, 2347, 2354, 2362, 2429, 2434, 2443, 2457, 2460, 2472, 2477, 2483, 2491, 2492, 2493, 2496, 2508, 2517, 2518, 2519, 2525, 2535, 2543, 2547, 2551, 2575, 2585, 2589, 2593, 2597, 2598, 2603, 2614, 2627, 2628, 2635, 2637, 2644, 2653, 2655, 2659, 2662, 2663, 2669, 2670, 2680, 2683, 2688, 2692, 2696, 2699, 2701, 2709, 2710, 2711, 2715, 2726, 2728, 2733, 2756, 2766, 2779, 2794, 2812, 2815, 2820, 2821, 2822, 2836, 2841, 2843, 2847, 2850, 2863, 2867, 2890, 2892, 2898, 2908, 2918, 2928, 2932, 2935, 2938, 2942, 2947, 2959, 2961, 2965, 2974, 2975, 2983, 2990, 2994, 2995, 2998, 3005, 3013, 3023, 3037, 3046, 3050, 3055, 3071, 3085, 3086, 3095, 3109, 3111, 3117, 3121, 3134, 3139, 3140, 3161, 3171, 3181, 3189, 3191, 3193, 3196, 3205, 3207, 3212, 3214, 3218, 3219, 3225, 3226, 3227, 3233, 3240, 3250, 3256, 3269, 3275, 3279, 3287, 3305, 3306, 3312, 3323, 3333, 3334, 3338, 3340, 3341, 3347, 3349, 3362, 3381, 3388, 3390, 3395, 3407, 3408, 3410, 3415, 3418, 3422, 3429, 3436, 3445, 3446, 3448, 3455, 3461, 3462, 3467, 3475, 3488, 3494, 3501, 3509, 3510, 3528, 3534, 3552, 3565, 3568, 3572, 3574, 3582, 3584, 3596, 3603, 3605, 3609, 3617, 3641, 3643, 3656, 3659, 3663, 3665, 3674, 3694, 3695, 3702, 3719, 3720, 3736, 3737, 3743, 3747, 3756, 3765, 3767, 3779, 3782, 3784, 3785, 3805, 3807, 3819, 3820, 3827, 3829, 3831, 3835, 3836, 3848, 3849, 3853, 3857, 3858, 3880, 3887, 3889, 3897, 3904, 3909, 3916, 3926, 3927, 3937, 3950, 3957, 3962, 3971, 3973, 3977, 3983, 4000, 4004, 4012, 4035, 4037, 4038, 4039, 4043, 4046, 4050, 4055, 4061, 4065, 4069, 4082, 4086, 4092, 4096, 4118, 4120, 4137, 4144, 4160, 4172, 4181, 4193, 4196, 4206, 4212, 4213, 4239, 4241, 4243, 4252, 4264, 4265, 4273, 4275, 4286, 4287, 4298, 4307, 4322, 4332, 4353, 4388, 4396, 4397, 4407, 4418, 4433, 4435, 4437, 4450, 4454, 4455, 4468, 4479, 4480, 4494, 4500, 4504, 4505, 4510, 4512, 4527, 4534, 4554, 4570, 4591, 4597, 4600, 4608, 4612, 4657, 4668, 4685, 4687, 4692, 4711, 4723, 4725, 4734, 4747, 4749, 4755, 4761, 4794, 4799, 4816, 4820, 4821, 4830, 4835, 4848, 4853, 4856, 4857, 4858, 4876, 4897, 4900, 4911, 4913, 4915, 4916, 4918, 4933, 4936, 4950, 4970, 4972, 4977, 4979, 4985, 4991, 4992, 5000, 5017, 5018, 5022, 5026, 5043, 5047, 5055, 5056, 5058, 5061, 5070, 5072, 5079, 5086, 5101, 5114, 5123, 5165, 5168, 5169, 5171, 5192, 5203, 5207, 5210, 5216, 5221, 5234, 5247, 5286, 5295, 5296, 5336, 5355, 5380, 5398, 5409, 5416, 5436, 5441, 5442, 5446, 5453, 5454, 5487, 5496, 5548, 5549, 5556, 5562, 5569, 5577, 5587, 5592, 5597, 5601, 5610, 5620, 5625, 5628, 5630, 5651, 5662, 5675, 5691, 5696, 5697, 5699, 5702, 5703, 5707, 5715, 5716, 5720, 5721, 5726, 5728, 5731, 5740, 5742, 5744, 5746, 5757, 5769, 5777, 5784, 5791, 5809, 5811, 5814, 5817, 5836, 5852, 5854, 5856, 5862, 5869, 5884, 5889, 5897, 5901, 5903, 5926, 5950, 5966, 5981, 5984, 5991, 6010, 6022, 6023, 6033, 6037, 6042, 6053, 6061, 6062, 6068, 6069, 6073, 6083, 6084, 6088, 6096, 6101, 6108, 6144, 6156, 6158, 6193, 6212, 6216, 6244, 6247, 6260, 6262, 6264, 6276, 6282, 6284, 6289, 6291, 6304, 6309, 6329, 6340, 6342, 6346, 6356, 6359, 6364, 6369, 6372, 6375, 6385, 6400, 6408, 6409, 6412, 6415, 6430, 6444, 6448, 6452, 6461, 6469, 6482, 6486, 6488, 6489, 6504, 6509, 6528, 6536, 6540, 6551, 6560, 6563, 6583, 6604, 6605, 6610, 6615, 6618, 6648, 6651, 6678, 6689, 6694, 6698, 6716, 6722, 6728, 6735, 6760, 6776, 6779, 6782, 6801, 6819, 6844, 6845, 6850, 6851, 6855, 6872, 6874, 6884, 6885, 6886, 6918, 6937, 6939, 6951, 6962, 6980, 6987, 6992, 7001, 7007, 7008, 7012, 7028, 7031, 7046, 7055, 7072, 7082, 7106, 7138, 7141, 7143, 7173, 7178, 7210, 7223, 7231, 7233, 7264, 7267, 7271, 7277, 7278, 7285, 7288, 7290, 7335, 7363, 7376, 7407, 7426, 7434, 7446, 7469, 7483, 7507, 7511, 7512, 7516, 7518, 7529, 7532, 7546, 7552, 7561, 7567, 7586, 7595, 7596, 7599, 7620, 7625, 7641, 7643, 7647, 7648, 7650, 7671, 7672, 7674, 7679, 7693, 7703, 7709, 7714, 7717, 7724, 7740, 7748, 7752, 7769, 7779, 7819, 7824, 7847, 7849, 7850, 7853, 7870, 7872, 7898, 7911, 7913, 7918, 7920, 7925, 7927, 7948, 7963, 7979, 7985, 8002, 8024, 8037, 8047, 8049, 8061, 8071, 8080, 8083, 8086, 8091, 8092, 8117, 8123, 8127, 8136, 8151, 8152, 8157, 8167, 8171, 8187, 8205, 8206, 8207, 8223, 8232, 8243, 8252, 8297, 8305, 8311, 8320, 8331, 8342, 8344, 8351, 8354, 8368, 8376, 8388, 8409, 8418, 8427, 8438, 8446, 8450, 8454, 8507, 8508, 8513, 8542, 8543, 8560, 8613, 8655, 8668, 8681, 8696, 8710, 8718, 8724, 8728, 8731, 8743, 8755, 8768, 8799, 8802, 8815, 8840, 8843, 8844, 8879, 8884, 8896, 8899, 8907, 8911, 8912, 8945, 8946, 8964, 8965, 8976, 8985, 8986, 8994, 8995, 9021, 9022, 9040, 9056, 9094, 9122, 9131, 9137, 9149, 9150, 9157, 9167, 9183, 9191, 9195, 9204, 9268, 9269, 9275, 9276, 9280, 9303, 9304, 9324, 9345, 9364, 9379, 9394, 9414, 9417, 9418, 9422, 9431, 9433, 9436, 9439, 9474, 9530, 9532, 9535, 9536, 9539, 9540, 9544, 9585, 9604, 9611, 9615, 9632, 9636, 9642, 9644, 9649, 9660, 9664, 9677, 9686, 9700, 9706, 9714, 9733, 9752, 9754, 9760, 9769, 9777, 9793, 9805, 9811, 9816, 9822, 9823, 9832, 9858, 9861, 9908, 9913, 9916, 9922, 9947, 9950, 9960, 9967, 9968, 9979, 9990, 10018, 10030, 10039, 10067, 10104, 10105, 10116, 10127, 10141, 10156, 10161, 10165, 10168, 10176, 10202, 10238, 10245, 10259, 10264, 10278, 10286, 10292, 10311, 10321, 10322, 10333, 10354, 10369, 10389, 10391, 10393, 10396, 10423, 10466, 10468, 10486, 10511, 10514, 10523, 10537, 10547, 10556, 10569, 10571, 10573, 10577, 10583, 10585, 10589, 10593, 10601, 10612, 10627, 10631, 10638, 10639, 10658, 10673, 10682, 10728, 10762, 10768, 10771, 10808, 10821, 10831, 10873, 10941, 10947, 10973, 10976, 11002, 11023, 11047, 11062, 11063, 11065, 11092, 11098, 11099, 11123, 11167, 11173, 11177, 11182, 11208, 11219, 11225, 11229, 11238, 11267, 11281, 11301, 11303, 11308, 11333, 11343, 11354, 11361, 11388, 11398, 11399, 11403, 11409, 11414, 11419, 11427, 11439, 11460, 11480, 11483, 11498, 11543, 11544, 11558, 11577, 11581, 11604, 11626, 11628, 11635, 11649, 11650, 11702, 11730, 11732, 11742, 11760, 11780, 11786, 11792, 11797, 11800, 11801, 11807, 11819, 11827, 11874, 11886, 11895, 11912, 11927, 11940, 11963, 11988, 12002, 12016, 12030, 12037, 12045, 12086, 12096, 12124, 12171, 12183, 12195, 12223, 12225, 12226, 12257, 12266, 12280, 12293, 12355, 12361, 12448, 12449, 12480, 12484, 12559, 12563, 12568, 12570, 12606, 12635, 12636, 12637, 12651, 12679, 12689, 12704, 12716, 12722, 12730, 12731, 12753, 12762, 12784, 12790, 12791, 12799, 12802, 12804, 12829, 12832, 12852, 12854, 12866, 12890, 12892, 12895, 12915, 12916, 12917, 12919, 12934, 12948, 12950, 13000, 13019, 4889030, 9214453, 58843, 3584572, 4255736, 9433132, 2730233, 2540895, 9817213, 833071, 7906938, 4535491, 8339962, 404409, 3589058, 8209469, 345284, 9922171, 1930822, 1073967, 3642301, 1708068, 8804776, 9320660, 2075914, 8323529, 4948483, 4125574, 642022, 8499555, 10005697, 7477976, 4416726, 9488284, 3287213, 5929571, 5421647, 10298995, 1412506, 2092076, 3168717, 6803766, 7577274, 2923806, 10251653, 8411805, 2558694, 353542, 1346337, 3470743, 3117955, 3367300, 8713928, 1699701, 825421, 6301582, 9402616, 7020896, 8396619, 2836040, 274519, 226917, 9537956, 3247517, 907119, 7239176, 1265315, 9308373, 8303093, 6939088, 4204101, 1253312, 2451295, 8341482, 7477402, 4746562, 2999308, 2273013, 2006333, 21574, 4475757, 5525269, 2675392, 1729784, 1530987, 764601, 388044, 2270093, 5133524, 1945186, 691288, 4408787, 9457036, 8395583, 1900672, 1016019, 9862398, 6064621, 3486675, 7657035, 6761181, 6106120, 2024183, 988121, 1895405, 7697652, 9674167, 6078425, 1823698, 8507529, 592246, 7216722, 1563278, 2168948, 225925, 889347, 681752, 8015920, 2485280, 3242314, 59532, 8493848, 7662934, 3302511, 8053309, 7138241, 6114097, 4433722, 2014745, 7652827, 6514924, 8460305, 1393879, 3864828, 8320595, 6666564, 3556067, 9905296, 6854020, 2566486, 5594490, 2624495, 1021819, 3864652, 7305690, 3711189, 10148722, 9261662, 5204454, 4626495, 490282, 2987285, 853560, 1121288, 6463797, 4832603, 8027059, 3561943, 2902278, 6283067, 9977127, 6534009, 4351786, 1266511, 9704293, 9931252, 7319224, 1141553, 5365650, 53538, 6253915, 8453485, 3584859, 814747, 10198411, 8648210, 4016294, 4143356, 1040308, 613540, 6699644, 4237291, 832074, 4175524, 1738661, 1468180, 3020713, 8270089, 9988877, 10060692, 1817590, 1749565, 7869240, 7713090)
GROUP BY
  u.Id, u.CreationDate

fork query

edited feb 14

created feb 13 Elim.Lemango