Untitled query #18940

This query is marked as a draft This query has been published by Ananth subray.
SQL

#select tl_from from templatelinks where tl_title='reflist' and tl_from in(select cl_from from categorylinks where cl_to='All_WikiProject_Medicine_articles');
select  page_len, page_title from page where page_id in ('14926397', '2954517', '22606606', '23146629', '22605234', '23403404', '48778225', '7707485', '47766976', '1292109', '739341', '44579357', '1308059', '14151874', '18536636', '651594', '13118318', '38537572', '159422', '18516877', '1513384', '2013', '6627843', '2219526', '285607', '1305937', '15098296', '6888619', '21231943', '2931', '5172874', '24387475', '18824937', '5955242', '5346986', '27515755', '58836', '382981', '2967091', '18914041', '13209921', '7707272', '53406261', '5033541', '44053254', '19375379', '9790176', '8010695', '1161449', '9826696', '5375818', '8852906', '32743283', '99765', '3213', '4034410', '1439748', '743647', '299603', '6015833', '38574797', '9548090', '21090646', '43340', '19389312', '301186', '2380068', '151596', '21090847', '667770', '10675802', '44741', '12071346', '14070816', '4089590', '629047', '3872', '887321', '15726449', '22484140', '7561550', '40390912', '8639291', '5572819', '24235332', '690425', '33095543', '13683036', '5925561', '1808705', '19477654', '25059058', '4894', '18978748', '25514842', '437934', '3074418', '151531', '1508830', '796878', '3684153', '1245477', '13705080', '34661902', '19347042', '5036407', '10597503', '8962605', '1439424', '1063522', '16392928', '1809389', '2056496', '14006972', '27474087', '19576849', '2787073', '354407', '57869', '5106741', '22849857', '2521803', '5757', '47233458', '2411906', '25434861', '7862104', '9080713', '1801955', '227966', '41765776', '51610968', '6848927', '41121120', '9970065', '9129005', '41525317', '681421', '2033153', '424940', '5757330', '49319518', '13350805', '4588521', '19614399', '1967508', '7544333', '440986', '3674095', '43109924', '10084918', '3857297', '41253507', '1308288', '3489028', '22104758', '24750891', '882371', '241752', '18509375', '2736130', '21090504', '28328981', '19375687', '10712045', '43920380', '5994060', '681248', '3312511', '36082820', '1490141', '1582697', '10580380', '36347964', '16906102', '1807391', '19204085', '197311', '269906', '2783640', '173689', '35773891', '1219878', '45496', '3880739', '19136065', '6893658', '19628830', '951709', '9476508', '3001907', '13722073', '3131539', '978617', '21320482', '3419095', '513662', '9765250', '21137185', '8499', '58131', '4361869', '11308632', '1629384', '2296300', '1577269', '35760681', '28634601', '13250385', '14336231', '27360422', '18973508', '5781871', '894883', '731029', '23232432', '19719064', '6320649', '23427260', '6084041', '25087467', '12442092', '4418373', '24145664', '4730812', '38799637', '58012', '4468665', '8080291', '1612932', '2146161', '640368', '531708', '15087626', '47017014', '667498', '925408', '7984144', '1558032', '42046016', '5075282', '1162983', '868905', '769170', '21090651', '2653762', '312996', '26350608', '27110670', '23855474', '2186292', '18464825', '8986979', '5942776', '2843043', '27008858', '3668090', '2829712', '7989873', '1620917', '10009450', '1148801', '1027900', '29304033', '12457485', '1559110', '1080238', '14939074', '9550319', '11583', '4132814', '19686322', '19178833', '1580065', '34870852', '15700010', '17491160', '7123584', '7681703', '29901409', '13882981', '10009761', '15437464', '6623338', '12036765', '43001903', '90573', '8544040', '7708071', '39915401', '866143', '295702', '14456', '904779', '19691666', '168135', '40748240', '808855', '40687749', '2056659', '17065982', '3161625', '1369099', '7885749', '2227874', '36873408', '1977071', '4566715', '457328', '9496441', '2751213', '963032', '6925728', '11618353', '10009480', '3492513', '16734138', '882529', '10415505', '16116280', '36918691', '340028', '2066', '20351302', '11331539', '14274', '6499195', '19526017', '8101533', '6648112', '3909114', '5621922', '1672441', '188666', '457301', '5292451', '5728149', '184516', '13683719', '748631', '1842493', '927934', '1289854', '3044574', '1435602', '35137864', '7933684', '15986978', '29228737', '3776762', '7635596', '8912578', '9698393', '97999', '54747', '28843151', '14630155', '30593653', '540045', '1216568', '19572176', '2997470', '5582010', '38777973', '2001964', '7439653', '29513418', '10908755', '15949325', '27928920', '35276525', '1777065', '41693584', '42508152', '1263274', '32013590', '29321913', '14589795', '527559', '10000722', '19349525', '210094', '15714475', '7557860', '939776', '7782214', '46223517', '251926', '1003695', '1658790', '19359744', '6420085', '2387500', '294816', '4156491', '6169317', '1937214', '3113716', '44704', '2296025', '24359169', '3801402', '9909190', '33846449', '40011151', '12841274', '40370439', '5700399', '13776726', '481855', '3503343', '1498773', '2403423', '461267', '23871763', '18636', '39409470', '18006', '29229649', '14486446', '2094701', '29151576', '10299936', '12014219', '13669059', '54392', '45572', '47365508', '6209280', '9668050', '44082754', '20550118', '5418871', '58994', '2550133', '23998216', '26859344', '13376407', '4105327', '641863', '46444088', '27081849', '3851566', '10003460', '1446352', '1141396', '1897794', '21010056', '7710432', '52320025', '9299670', '339070', '3013210', '5635085', '192602', '693775', '868941', '37132574', '47456369', '19936', '470602', '24209637', '25422381', '26106065', '226755', '49498415', '4322445', '30823586', '41894653', '548786', '156530', '6087955', '3764878', '31304761', '1547277', '7710487', '1445350', '21090518', '51236603', '27386361', '4996436', '641663', '7558627', '7710511', '13860564', '5353002', '8154330', '2439939', '10636279', '1392097', '249739', '38187', '3574576', '18060440', '1063420', '19594595', '53068266', '3222974', '13966597', '21009949', '34946270', '511045', '7791723', '10008976', '25167695', '8707692', '6322620', '1085676', '37238097', '1121799', '660043', '13796226', '4121018', '1717891', '35151048', '45030797', '71419', '1332626', '206420', '17468689', '26266700', '742635', '2403872', '9797687', '8710983', '13547425', '53044505', '3262990', '512201', '3054401', '7061892', '968190', '47113819', '13860635', '36178847', '24192497', '1178728', '5209221', '3523575', '10004116', '43192347', '1063402', '1958320', '1034695', '24273144', '3493672', '8710323', '226460', '19784394', '23868', '3026877', '25422548', '21010261', '36733160', '31819239', '21287175', '23453349', '54102891', '4984867', '238984', '19232635', '1727600', '18458815', '2505769', '2168680', '792100', '349449', '4608041', '28914930', '615483', '24432', '807958', '1149915', '13765935', '1051419', '10124481', '9552392', '2944649', '1995005', '10004424', '12443620', '7988845', '21869718', '2894204', '10004470', '3815616', '18571227', '3669509', '21402352', '36794228', '52517885', '7159007', '1303467', '6812287', '169087', '18715931', '2527636', '430895', '25045064', '35812005', '40196305', '1421817', '20851286', '717240', '1929285', '24953438', '8228432', '12311532', '18211427', '37291266', '4934294', '27156853', '21642627', '26015083', '42516997', '21159063', '10066226', '527713', '5238683', '4739671', '42877834', '49093087', '21642988', '13500589', '1124216', '11126807', '1454839', '1697647', '17865674', '1474020', '208193', '9800200', '18788218', '1876921', '14307008', '44472005', '1588676', '5335838', '31151496', '18338134', '1529964', '1942912', '27792', '3179826', '2530204', '46342831', '30912851', '166076', '10008750', '10004521', '707107', '35021601', '2011104', '726102', '1796987', '28031', '631853', '4047947', '4824560', '21090556', '7764208', '49606213', '4819792', '23049589', '272937', '4326932', '2708311', '8392444', '23733927', '7560465', '51352858', '16675016', '24583410', '33832497', '52260826', '5944870', '194096', '4525598', '37974838', '8179625', '6737907', '6626886', '696143', '10517510', '21009701', '5061391', '10061478', '5792477', '227266', '13897242', '21000025', '3383377', '46602361', '1629626', '19062763', '2623773', '26993108', '17611620', '29202755', '1729583', '19373678', '19350107', '4969979', '7711152', '54144328', '33577136', '13186234', '49621781', '825678', '14552382', '38627366', '38910639', '3373730', '31977287', '3583511', '20241507', '803775', '1773030', '1054471', '1581081', '741438', '271086', '47326863', '4032698', '1552530', '37007331', '34345191', '50284349', '2041534', '1215379', '68450', '940591', '374493', '4748291', '2068898', '13897318', '9541521', '15798136', '2976377', '2961401', '5067817', '3222567', '25081167', '88870', '1929979', '4227843', '10091856', '31219', '2064251', '10005611', '437209', '18634933', '3938383', '32474', '4028818', '18454987', '12377770', '11401305', '22320554', '4268007', '20741428', '8918831', '15947701', '1766183', '7336095', '35179177', '15359790', '31632907', '521390', '23060526', '2016276', '21814932', '3904845', '8204400', '32540', '20968509', '36376917', '1557488', '19931008', '37104104', '1652931', '1749930', '42345103', '8742967', '362755', '21658034', '19730657', '21090521', '144828', '6341312', '1502160', '1918762', '20090761', '13861600', '32996141', '8249616', '18133252');
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
