0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

select
count(comments.id) as 'totalcommentcount',
CAST(DATEDIFF(DAY, users.creationdate, GETDATE()) AS FLOAT) / 365.25 AS accountage


from comments left join users on users.id = comments.userid 
where comments.userid in ('884488', '849926', '236774', '1102192', '453535', '1020754', '805986', '111923', '250285', '512427', '1291430', '813136', '1105545', '599991', '587811', '941582', '109776', '20792', '157864', '702442', '1296348', '367317', '1249914', '454468', '966949', '592654', '819720', '92883', '30779', '1043305', '63418', '892301', '1231410', '658911', '761309', '1176467', '422682', '177922', '635110', '44594', '1194585', '148797', '384690', '237274', '372377', '1237502', '1108876', '325170', '392007', '670547', '184224', '72135', '140552', '99480', '832773', '758950', '552128', '1162572', '482927', '441734', '431788', '31782', '563978', '934670', '287722', '386359', '1205349', '812453', '1100659', '1017247', '1119085', '645404', '836227', '765051', '1071750', '455091', '1137282', '356265', '764953', '1266205', '225377', '1190317', '856921', '218304', '1177799', '1272225', '426670', '411600', '581587', '273476', '520615', '1197641', '1303704', '218717', '291979', '302700', '858472', '29130', '129163', '327722', '382528', '1135400', '364305', '86079', '291333', '686497', '435327', '962589', '505243', '434684', '1254945', '184056', '795266', '348810', '829569', '957294', '442992', '705320', '98135', '1101265', '1309628', '45194', '513009', '527943', '1040743', '272090', '307987', '451469', '803415', '1199779', '324842', '955277', '209448', '238549', '961659', '555533', '579770', '856762', '379988', '485758', '1114569', '1158755', '206341', '891368', '457624', '67855', '847919', '919330', '79002', '872120', '732321', '183940', '905869', '615867', '749983', '507407', '435763', '323058', '1154979', '1279437', '757325', '527700', '590669', '1196185', '666293', '575190', '63328', '1081295', '749398', '1223182', '300737', '186393', '1277226', '1227629', '1301024', '337882', '777134', '221733', '1105325', '546855', '654645', '1201807', '1110852', '727220', '423245', '1171054', '967159', '316359', '672000', '398415', '80642', '381939', '1020449', '315567', '369873', '1169440', '190516', '557016', '294232', '888411', '31424', '94411', '178944', '1240659', '409853', '1210777', '951432', '111365', '722037', '906140', '1135670', '1139130', '1085698', '184362', '263326', '910581', '382898', '455888', '1043884', '1116190', '923991', '420083', '558754', '598066', '289107', '1189370', '1293130', '305611', '968895', '161488', '224686', '1003770', '438100', '1196905', '1136721', '225482', '1155186', '306996', '598203', '369394', '964899', '1222882', '41138', '1161070', '732743', '991641', '171368', '813587', '879802', '444991', '1050929', '1300337', '480037', '985920', '1283362', '879968', '1251761', '1279485', '395813', '1136371', '348414', '536002', '1189740', '249233', '274386', '620351', '357727', '1102407', '252115', '743468', '305549', '178445', '409312', '1236607', '81843', '15859', '1035727', '1218372', '514439', '330235', '1151840', '808222', '164210', '648398', '1037020', '611944', '734618', '1231150', '859230', '651249', '1215231', '333541', '205319', '850134', '909757', '633731', '59837', '605557', '188116', '669533', '947539', '1024311', '217644', '588146', '286810', '432049', '52956', '161788', '987343', '824742', '1171632', '1269666', '347574', '777261', '1145543', '119604', '140789', '102836', '1030527', '852385', '778194', '154160', '1202013', '883250', '738825', '1187097', '825304', '473391', '1046052', '628384', '979561', '1067545', '94709', '740008', '183581', '1262334', '369810', '239429', '206325', '702489', '770982', '938755', '310', '653319', '930966', '1086005', '663545', '655519', '273844', '16287', '1295220', '1174662', '814759', '1325568', '521980', '760738', '441015', '363661', '886515', '1121938', '1280567', '1176853', '244577', '1271427', '225459', '410552', '1193493', '1083727', '412994', '703580', '283630', '222338', '39898', '495616', '852826', '1269041', '452298', '1242173', '918022', '232326', '1241880', '147476', '1123671', '99982', '879437', '872641', '110769', '1184686', '75654', '949811', '623100', '1109174', '582158', '1060274', '907028', '877360', '509349', '342712', '948655', '1321347', '107642', '592641', '35245', '1179394', '353485', '523766', '377078', '850566', '104705', '125674', '375027', '1175279', '661070', '640342', '335339', '142358', '598590', '681673', '1005016', '827113', '387781', '928970', '619107', '1133839', '1149305', '343694', '1207019', '851203', '3735', '832299', '619269', '146068', '54086', '181104', '7772', '1093209', '352782', '637963', '397040', '35366', '1186774', '409948', '905232', '211704', '310619', '1209722', '720511', '545784', '1309441', '554594', '347466', '119370', '271513', '780709', '885158', '621978', '1086590', '1020251', '67335', '11400', '1177474', '1211341', '114520', '1212365', '112962', '371682', '599483', '327399', '622627', '638035', '1012719', '495419', '784949', '283278', '1052236', '83878', '154041', '840218', '562652', '706537', '787268', '856983', '342043', '1072071', '104880', '1322401', '1263002', '23678', '533851', '708092', '836928', '957146', '968805', '1007438', '1132999', '967262', '771684', '505013', '402762', '1106214', '489395', '1234546', '63549', '1327334', '629215', '254565', '178224', '403416', '944534', '1304713', '683140', '646171', '1046275', '670272', '211845', '1156724', '397717', '6019', '394412', '744346', '864601', '195949', '1117295', '237982', '591188', '1159640', '1205976', '444266', '1168887', '150049', '1145908', '965669', '1055559', '705373', '274474', '463370', '1216596', '961784', '123658', '1191600', '915048', '1290421', '436974', '1034524', '165473', '152135', '632288', '494192', '689695', '850397', '821566', '491107', '187235', '85099', '558032', '631117', '209728', '72516', '538161', '877671', '162762', '1072680', '751112', '725338', '754972', '804742', '441339', '1050799', '1158234', '70554', '830139', '194754', '663350', '329786', '1015126', '946023', '1007540', '631791', '621891', '1158754', '687051', '280231', '1151215', '372323', '338839', '33037', '659489', '554131', '369026', '201011', '1291588', '1127181', '276583', '508704', '59782', '485251', '705144', '572478', '98141', '56299', '421376', '416558', '206325', '907172', '1123547', '572185', '312203', '120795', '1198507', '734712', '724071', '222324', '439692', '598879', '1056186', '705990', '1064906', '695437', '257510', '731380', '414706', '1191970', '574710', '47786', '683917', '770893', '1213050', '77366', '934412', '711669', '375338', '348311', '620061', '957291', '1111223', '168290', '789556', '1194450', '1105063', '1060612', '665793', '1149151', '731263', '907986', '609100', '1110267', '834094', '1315852', '220389', '1249117', '1069475', '1249227', '288701', '1256314', '728780', '896380', '870454', '965427', '505094', '1140308', '461968', '956776', '247615', '1200052', '234601', '1233382', '391599', '617703', '288048', '1054033', '316870', '1263662', '1238568', '162458', '1259145', '574773', '1200247', '1284349', '112636', '573486', '485101', '1015115', '751503', '644177', '1134828', '595306', '1244216', '1196722', '398213', '1272736', '222706', '1192735', '1282436', '545833', '43839', '713044', '1095371', '171211', '470982', '253010', '96748', '1119765', '1076494', '99830', '648091', '1158867', '1159867', '178638', '1053561', '368459', '137112', '370607', '628794', '725920', '536999', '699439', '386647', '287594', '870810', '1204993', '148363', '399405', '534826', '155188', '738820', '574187', '1103580', '161356', '86189', '565966', '1291874', '1224402', '381038', '1032640', '912041', '135126', '206634', '432165', '702385', '825173', '667477', '652744', '753994', '757714', '1286415', '592904', '722286', '1177286', '1178230', '454111', '690132', '1151103', '1238259', '1108477', '11609', '798246', '507607', '797827', '46467', '131202', '918637', '631745', '94519', '1172825', '985298', '426907', '583813', '1115167', '50061', '1185151', '672945', '1058503', '842990', '75890', '828962', '700920', '802216', '225401', '1152679', '1139139', '113270', '62145', '264579', '111095', '1132885', '1044179', '634739', '872771', '925559', '368669', '272714', '478324', '199125', '850871', '156153', '312036', '172766', '331840', '294821', '90589', '553689', '1192613', '432169', '1189219', '199235', '74646', '310792', '81977', '1320022', '623723', '535860', '1269694', '909400', '527473', '302133', '1057748', '1118058', '693567', '936839', '239985', '671887', '1147759', '678799', '1264544', '410423', '216709', '418453', '794118', '601229', '338268', '333008', '859992', '35401', '696767', '483869', '826718', '563105', '536689', '401002', '640328', '1171122', '192885', '1191401', '819598', '327601', '157517', '315487', '775601', '383525', '272879', '107379', '741670', '813445', '111252', '1284554', '315168', '433727', '463803', '109457', '135574', '381784', '47544', '1169099', '492068', '841930', '533448', '592401', '1246520', '319739', '368889', '1123379', '470699', '665091', '470160', '684279', '1179343', '142118', '561328', '732329', '659646', '261529', '205778', '1172727', '951520', '454210', '809337', '287727', '1019484', '614444', '737118', '763632', '55387', '501281', '502416', '994132', '7895', '93486', '775112', '965681', '116382', '370312', '1135933', '1300687', '1005353', '964409', '71698', '242279', '131990', '697503', '837849', '881125', '922809', '1263380', '308790', '399005', '427762', '1052829', '1187278', '543405', '813140', '874922', '940827', '57565', '634487', '1248165', '543933', '533057', '927050', '1061842', '1103533', '864526', '1119203', '817034', '1189055', '995415', '153871', '1147988', '948405', '907863', '223624', '572398', '996482', '968294', '638288', '769404', '197239', '1244560', '398729', '598510', '365676', '357959', '1267814', '313489', '474387', '172746', '425136', '87780', '917404', '729152', '1262151', '542293', '697799', '1227435', '912344', '685099', '1155213', '163034', '111063', '1003974', '117467', '167870', '999270', '1312019', '12267', '1220545', '813375', '759991', '440023', '275940', '425701', '1138938', '129049', '700460', '342025', '389789', '370325', '876051', '1045159', '356259', '129289', '1162898', '907456', '1157309', '156216', '1178038', '49053', '870272', '787521', '1234023')
group by users.id, users.creationdate

fork query

edited dec 3

created nov 30 jordan0330