Guest User

Untitled

a guest
Jan 29th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 50.61 KB | None | 0 0
  1. import MySQLdb as dbapi
  2. import sys
  3. import csv
  4. import json
  5. import requests
  6. import urllib2
  7.  
  8. def get_all_data_from_db():
  9. array_authors = ['4', '6', '10', '12', '16', '17', '18', '24', '26', '30', '31', '32', '33', '34', '35', '37', '39', '40', '41', '44', '45', '50', '51', '55', '56', '57', '59', '60', '69', '72', '75', '78', '79', '80', '82', '85', '97', '99', '102', '104', '105', '106', '114', '115', '118', '119', '122', '127', '128', '129', '133', '136', '139', '146', '158', '163', '165', '168', '175', '178', '183', '186', '191', '193', '200', '206', '208', '209', '211', '215', '217', '224', '225', '226', '229', '231', '240', '246', '248', '253', '257', '262', '267', '269', '270', '274', '276', '278', '279', '282', '283', '284', '287', '290', '292', '305', '316', '318', '323', '325', '334', '354', '356', '357', '369', '381', '413', '424', '443', '444', '449', '454', '471', '491', '492', '499', '505', '542', '544', '555', '558', '563', '564', '570', '573', '574', '578', '579', '584', '588', '589', '590', '591', '596', '605', '610', '611', '616', '619', '622', '625', '630', '632', '633', '634', '638', '640', '657', '660', '665', '678', '680', '683', '687', '689', '693', '697', '698', '701', '720', '726', '744', '746', '747', '762', '766', '770', '786', '801', '803', '912', '948', '992', '1035', '1050', '1078', '1084', '1101', '1103', '1115', '1137', '1143', '1159', '1166', '1196', '1201', '1215', '1223', '1228', '1235', '1249', '1259', '1260', '1331', '1344', '1354', '1355', '1357', '1362', '1366', '1367', '1370', '1374', '1387', '1399', '1400', '1405', '1417', '1421', '1422', '1428', '1435', '1446', '1467', '1469', '1480', '1481', '1482', '1484', '1487', '1490', '1495', '1507', '1514', '1515', '1516', '1517', '1525', '1527', '1528', '1529', '1530', '1532', '1539', '1543', '1553', '1574', '1577', '1578', '1580', '1581', '1589', '1591', '1601', '1602', '1605', '1607', '1610', '1612', '1633', '1635', '1636', '1640', '1641', '1651', '1656', '1659', '1667', '1676', '1679', '1681', '1693', '1696', '1706', '1707', '1710', '1712', '1717', '1720', '1722', '1729', '1730', '1731', '1733', '1736', '1740', '1747', '1767', '1770', '1771', '1776', '1777', '1787', '1788', '1804', '1815', '1820', '1824', '1828', '1833', '1836', '1851', '1854', '1859', '1860', '1862', '1863', '1866', '1867', '1875', '1889', '1890', '1900', '1903', '1905', '1906', '1919', '1924', '1927', '1930', '1937', '1940', '1954', '1955', '1961', '1962', '1966', '1993', '2004', '2010', '2011', '2013', '2014', '2026', '2035', '2038', '2040', '2043', '2047', '2049', '2054', '2063', '2065', '2066', '2067', '2068', '2071', '2072', '2077', '2078', '2081', '2082', '2084', '2087', '2089', '2109', '2119', '2120', '2123', '2126', '2135', '2148', '2153', '2154', '2157', '2158', '2167', '2170', '2171', '2205', '2208', '2212', '2219', '2221', '2222', '2223', '2238', '2241', '2268', '2270', '2292', '2297', '2306', '2338', '2346', '2355', '2356', '2367', '2369', '2381', '2398', '2400', '2403', '2413', '2428', '2435', '2444', '2446', '2458', '2459', '2471', '2483', '2514', '2518', '2526', '2533', '2550', '2556', '2564', '2605', '2620', '2622', '2624', '2629', '2632', '2634', '2651', '2663', '2672', '2673', '2676', '2678', '2680', '2691', '2702', '2708', '2709', '2710', '2712', '2733', '2737', '2780', '2807', '2809', '2827', '2828', '2832', '2837', '2840', '2848', '2854', '2908', '2911', '2914', '2916', '2917', '2925', '2926', '2929', '2938', '2944', '2946', '2949', '2952', '2954', '2955', '2958', '2960', '2965', '2969', '2970', '2973', '2980', '2991', '3003', '3005', '3007', '3008', '3010', '3011', '3012', '3013', '3014', '3015', '3021', '3022', '3024', '3025', '3028', '3029', '3033', '3040', '3042', '3045', '3046', '3047', '3048', '3050', '3059', '3064', '3066', '3070', '3076', '3077', '3078', '3079', '3080', '3082', '3092', '3093', '3097', '3099', '3100', '3103', '3104', '3110', '3116', '3119', '3120', '3121', '3123', '3124', '3125', '3127', '3130', '3133', '3134', '3138', '3141', '3142', '3143', '3148', '3150', '3151', '3152', '3160', '3166', '3167', '3168', '3172', '3174', '3176', '3177', '3179', '3180', '3181', '3183', '3189', '3196', '3197', '3198', '3214', '3219', '3225', '3226', '3230', '3238', '3239', '3240', '3241', '3245', '3246', '3266', '3274', '3276', '3277', '3284', '3285', '3286', '3293', '3294', '3304', '3308', '3309', '3310', '3311', '3314', '3315', '3318', '3322', '3326', '3329', '3342', '3346', '3347', '3353', '3368', '3369', '3375', '3515', '3721', '3760', '3846', '3848', '3854', '3861', '3871', '3875', '3930', '3932', '3933', '3934', '3939', '3949', '3950', '3971', '3972', '3976', '3997', '4000', '4006', '4008', '4011', '4012', '4015', '4020', '4021', '4025', '4028', '4032', '4041', '4043', '4048', '4062', '4063', '4070', '4071', '4073', '4080', '4081', '4090', '4091', '4097', '4098', '4100', '4101', '4102', '4104', '4106', '4107', '4109', '4110', '4114', '4119', '4122', '4126', '4128', '4130', '4138', '4143', '4175', '4177', '4179', '4180', '4182', '4185', '4187', '4189', '4190', '4196', '4198', '4199', '4200', '4201', '4205', '4208', '4216', '4219', '4221', '4224', '4228', '4231', '4235', '4237', '4249', '4251', '4255', '4256', '4263', '4271', '4273', '4279', '4291', '4292', '4303', '4306', '4316', '4320', '4332', '4335', '4345', '4348', '4353', '4359', '4361', '4362', '4363', '4365', '4366', '4368', '4369', '4371', '4384', '4388', '4390', '4403', '4408', '4414', '4417', '4420', '4427', '4438', '4439', '4441', '4443', '4444', '4447', '4449', '4452', '4455', '4459', '4462', '4464', '4465', '4466', '4467', '4468', '4471', '4472', '4475', '4477', '4479', '4533', '4542', '4551', '4555', '4566', '4577', '4588', '4601', '4608', '4610', '4618', '4640', '4641', '4642', '4643', '4646', '4652', '4655', '4659', '4662', '4671', '4675', '4676', '4699', '4705', '4707', '4735', '4758', '4760', '4761', '4763', '4770', '4772', '4777', '4781', '4782', '4783', '4786', '4795', '4802', '4805', '4806', '4814', '4831', '4854', '4877', '4884', '4895', '4903', '4930', '4932', '4933', '4955', '4958', '4966', '4980', '4982', '4985', '4993', '4996', '5012', '5041', '5048', '5060', '5066', '5069', '5079', '5082', '5086', '5096', '5102', '5103', '5106', '5123', '5143', '5144', '5145', '5148', '5156', '5173', '5201', '5207', '5218', '5224', '5226', '5229', '5233', '5234', '5237', '5243', '5250', '5252', '5255', '5263', '5280', '5281', '5284', '5289', '5302', '5303', '5310', '5321', '5323', '5328', '5330', '5331', '5333', '5356', '5358', '5360', '5367', '5369', '5458', '5516', '5529', '5530', '5537', '5539', '5543', '5547', '5548', '5561', '5562', '5563', '5571', '5572', '5573', '5576', '5577', '5579', '5580', '5582', '5584', '5585', '5586', '5591', '5592', '5595', '5596', '5598', '5601', '5602', '5604', '5606', '5609', '5612', '5615', '5616', '5617', '5618', '5624', '5631', '5634', '5643', '5644', '5647', '5649', '5655', '5657', '5659', '5661', '5665', '5666', '5668', '5669', '5670', '5674', '5678', '5688', '5690', '5708', '5715', '5722', '5755', '5756', '5765', '5767', '5768', '5779', '5784', '5799', '5802', '5806', '5810', '5820', '5833', '5851', '5869', '5875', '5884', '5892', '5897', '5904', '5905', '5915', '5916', '5922', '5924', '5925', '5931', '5934', '5937', '5941', '5942', '5944', '5949', '5960', '5965', '5969', '5975', '5979', '5982', '5984', '5987', '5995', '6001', '6002', '6004', '6005', '6007', '6010', '6013', '6015', '6022', '6027', '6032', '6033', '6039', '6047', '6057', '6060', '6062', '6083', '6086', '6090', '6092', '6093', '6097', '6105', '6108', '6130', '6137', '6139', '6166', '6172', '6188', '6196', '6198', '6201', '6248', '6274', '6287', '6313', '6319', '6346', '6351', '6353', '6357', '6373', '6375', '6383', '6408', '6412', '6429', '6466', '6474', '6512', '6518', '6524', '6526', '6529', '6531', '6544', '6552', '6554', '6555', '6559', '6560', '6567', '6568', '6576', '6577', '6583', '6588', '6589', '6592', '6595', '6597', '6599', '6600', '6607', '6623', '6636', '6639', '6642', '6644', '6650', '6651', '6652', '6653', '6654', '6655', '6664', '6668', '6670', '6678', '6683', '6687', '6692', '6705', '6708', '6718', '6729', '6731', '6736', '6738', '6743', '6744', '6754', '6756', '6759', '6761', '6766', '6768', '6775', '6777', '6778', '6781', '6785', '6786', '6788', '6790', '6791', '6792', '6793', '6799', '6800', '6802', '6806', '6817', '6822', '6823', '6825', '6828', '6829', '6831', '6832', '6838', '6840', '6845', '6847', '6848', '6850', '6854', '6865', '6878', '6880', '6898', '6899', '6901', '6905', '6907', '6911', '6913', '6919', '6924', '6925', '6933', '6936', '6942', '6960', '6965', '6983', '7001', '7007', '7008', '7010', '7012', '7036', '7041', '7046', '7054', '7061', '7067', '7077', '7081', '7082', '7088', '7103', '7105', '7112', '7115', '7117', '7118', '7120', '7125', '7147', '7158', '7165', '7167', '7168', '7181', '7182', '7190', '7193', '7201', '7203', '7205', '7206', '7213', '7218', '7222', '7223', '7226', '7227', '7240', '7246', '7247', '7250', '7254', '7255', '7264', '7268', '7269', '7286', '7290', '7295', '7304', '7314', '7318', '7322', '7334', '7335', '7340', '7351', '7356', '7375', '7378', '7379', '7380', '7392', '7403', '7405', '7408', '7409', '7411', '7413', '7415', '7417', '7420', '7422', '7427', '7440', '7443', '7451', '7453', '7496', '7502', '7503', '7505', '7513', '7517', '7522', '7528', '7529', '7530', '7531', '7557', '7562', '7568', '7573', '7583', '7584', '7601', '7608', '7636', '7638', '7649', '7653', '7654', '7667', '7668', '7670', '7672', '7685', '7697', '7706', '7734', '7751', '7752', '7756', '7761', '7767', '7773', '7774', '7779', '7780', '7782', '7787', '7800', '7811', '7814', '7815', '7828', '7840', '7841', '7855', '7863', '7866', '7868', '7880', '7890', '7894', '7897', '7909', '7910', '7930', '7934', '7935', '7945', '7948', '7949', '7963', '7964', '7975', '7980', '7992', '8007', '8012', '8014', '8015', '8018', '8019', '8038', '8040', '8062', '8064', '8070', '8072', '8075', '8078', '8087', '8100', '8110', '8122', '8125', '8126', '8129', '8137', '8141', '8145', '8146', '8175', '8195', '8204', '8220', '8226', '8244', '8251', '8256', '8267', '8269', '8289', '8290', '8291', '8294', '8328', '8340', '8353', '8355', '8376', '8385', '8392', '8400', '8401', '8405', '8420', '8425', '8432', '8438', '8440', '8446', '8448', '8456', '8472', '8479', '8489', '8501', '8502', '8508', '8510', '8511', '8513', '8514', '8515', '8518', '8524', '8535', '8538', '8542', '8543', '8551', '8566', '8568', '8570', '8588', '8589', '8590', '8699', '8707', '8740', '8746', '8748', '8752', '8768', '8769', '8770', '8775', '8795', '8827', '8830', '8836', '8862', '8871', '8909', '8910', '8925', '8933', '8946', '8958', '8967', '8975', '8982', '8996', '9022', '9039', '9049', '9051', '9061', '9084', '9102', '9121', '9146', '9152', '9168', '9187', '9226', '9230', '9232', '9247', '9254', '9255', '9269', '9274', '9275', '9285', '9306', '9308', '9321', '9326', '9327', '9330', '9334', '9337', '9349', '9366', '9374', '9375', '9384', '9394', '9396', '9399', '9412', '9438', '9440', '9460', '9473', '9481', '9504', '9513', '9516', '9529', '9531', '9542', '9543', '9544', '9552', '9577', '9592', '9611', '9613', '9622', '9623', '9639', '9654', '9658', '9674', '9684', '9687', '9692', '9723', '9726', '9730', '9738', '9740', '9744', '9745', '9750', '9753', '9755', '9762', '9775', '9783', '9797', '9808', '9816', '9820', '9829', '9833', '9835', '9843', '9860', '9874', '9876', '9886', '9906', '9908', '9911', '9912', '9928', '9942', '9957', '9963', '9976', '9986', '9989', '9998', '10001', '10003', '10022', '10028', '10034', '10039', '10040', '10047', '10050', '10055', '10056', '10057', '10063', '10066', '10069', '10072', '10075', '10076', '10082', '10086', '10092', '10093', '10094', '10119', '10121', '10123', '10127', '10137', '10146', '10147', '10148', '10152', '10158', '10161', '10162', '10172', '10174', '10183', '10197', '10207', '10211', '10212', '10215', '10219', '10223', '10230', '10231', '10239', '10258', '10260', '10261', '10266', '10270', '10277', '10286', '10289', '10302', '10321', '10322', '10324', '10335', '10342', '10345', '10353', '10355', '10357', '10359', '10366', '10377', '10397', '10401', '10402', '10415', '10418', '10447', '10448', '10449', '10450', '10467', '10473', '10478', '10482', '10490', '10493', '10509', '10520', '10528', '10530', '10541', '10543', '10544', '10546', '10547', '10548', '10551', '10554', '10559', '10566', '10572', '10573', '10596', '10603', '10605', '10608', '10611', '10622', '10624', '10626', '10635', '10645', '10646', '10650', '10652', '10655', '10658', '10661', '10662', '10664', '10666', '10679', '10682', '10687', '10695', '10698', '10702', '10712', '10718', '10733', '10739', '10782', '10798', '10812', '10824', '10843', '10848', '10868', '10869', '10882', '10884', '10899', '10906', '10909', '10914', '10915', '10956', '10957', '10958', '10962', '10969', '10974', '10977', '10978', '10989', '10996', '10997', '11013', '11022', '11023', '11045', '11050', '11051', '11055', '11056', '11060', '11070', '11073', '11080', '11086', '11097', '11109', '11114', '11133', '11139', '11150', '11156', '11159', '11162', '11166', '11170', '11173', '11174', '11194', '11196', '11204', '11208', '11213', '11223', '11225', '11231', '11235', '11238', '11256', '11257', '11268', '11275', '11277', '11280', '11285', '11289', '11301', '11303', '11313', '11315', '11317', '11351', '11370', '11371', '11399', '11402', '11405', '11412', '11417', '11420', '11427', '11429', '11431', '11433', '11437', '11446', '11458', '11483', '11484', '11487', '11488', '11495', '11513', '11529', '11531', '11534', '11554', '11570', '11589', '11600', '11602', '11603', '11613', '11615', '11624', '11630', '11632', '11661', '11690', '11704', '11709', '11719', '11728', '11746', '11764', '11768', '11778', '11779', '11788', '11792', '11795', '11796', '11800', '11814', '11836', '11851', '11869', '11875', '11883', '11890', '11894', '11909', '11911', '11920', '11923', '11929', '11964', '11977', '11979', '11983', '11996', '11998', '12009', '12023', '12028', '12038', '12043', '12046', '12081', '12083', '12088', '12093', '12110', '12120', '12131', '12134', '12140', '12147', '12148', '12180', '12183', '12184', '12191', '12194', '12195', '12196', '12202', '12203', '12206', '12209', '12218', '12228', '12270', '12301', '12325', '12331', '12342', '12344', '12358', '12376', '12384', '12389', '12390', '12395', '12399', '12408', '12411', '12431', '12442', '12447', '12455', '12459', '12460', '12466', '12467', '12474', '12477', '12491', '12502', '12506', '12521', '12526', '12535', '12548', '12562', '12567', '12605', '12626', '12627', '12640', '12644', '12666', '12694', '12697', '12731', '12751', '12757', '12760', '12769', '12772', '12811', '12834', '12838', '12843', '12856', '12865', '12869', '12916', '12917', '12922', '12924', '12934', '12951', '12953', '12971', '12994', '12996', '13019', '13021', '13050', '13066', '13097', '13104', '13132', '13138', '13174', '13183', '13187', '13194', '13211', '13212', '13226', '13231', '13248', '13257', '13268', '13299', '13315', '13408', '13444', '13448', '13506', '13562', '13621', '13640', '13679', '13685', '13703', '13706', '13725', '13732', '13745', '13805', '13811', '13832', '13870', '13875', '13878', '13880', '13900', '13918', '13932', '13936', '13938', '13943', '13980', '14047', '14059', '14062', '14072', '14104', '14194', '14267', '14305', '14336', '14421', '14441', '14445', '14447', '14520', '14563', '14579', '14630', '14661', '14729', '14732', '14734', '14743', '14749', '14782', '14793', '14835', '14851', '14855', '14873', '14874', '14949', '15051', '15053', '15059', '15174', '15177', '15178', '15224', '15243', '15254', '15296', '15323', '15365', '15382', '15407', '15412', '15419', '15458', '15496', '15507', '15594', '15599', '15799', '15825', '15834', '15883', '15886', '15887', '15893', '15894', '15920', '15960', '15997', '16012', '16022', '16028', '16053', '16059', '16076', '16128', '16133', '16139', '16156', '16192', '16198', '16204', '16211', '16240', '16245', '16313', '16383', '16419', '16442', '16449', '16561', '16601', '16605', '16637', '16654', '16668', '16704', '16752', '16755', '16766', '16798', '16849', '16962', '16978', '17055', '17081', '17124', '17128', '17129', '17135', '17172', '17175', '17176', '17184', '17278', '17414', '17524', '17564', '17614', '17628', '17657', '17683', '17692', '17697', '17736', '17751', '17784', '17838', '17872', '17877', '17879', '17882', '17883', '17888', '17908', '17930', '17956', '17957', '17977', '18069', '18094', '18140', '18156', '18182', '18188', '18210', '18211', '18231', '18264', '18286', '18320', '18360', '18370', '18397', '18407', '18508', '18556', '18573', '18577', '18633', '18642', '18653', '18664', '18678', '18713', '18719', '18736', '18753', '18763', '18771', '18774', '18817', '18846', '18858', '18863', '18871', '18888', '18890', '18908', '18911', '18918', '18962', '18973', '18978', '18981', '19039', '19040', '19045', '19050', '19068', '19111', '19199', '19400', '19424', '19440', '19478', '19535', '19546', '19552', '19556', '19582', '19607', '19616', '19624', '19625', '19662', '19677', '19700', '19702', '19718', '19748', '19762', '19776', '19850', '19904', '19936', '19967', '19987', '19995', '20006', '20014', '20045', '20188', '20193', '20202', '20237', '20244', '20272', '20279', '20331', '20338', '20360', '20396', '20427', '20431', '20445', '20446', '20469', '20471', '20473', '20474', '20489', '20501', '20509', '20526', '20527', '20528', '20529', '20566', '20570', '20576', '20633', '20652', '20654', '20655', '20707', '20712', '20730', '20737', '20781', '20789', '20814', '20845', '20969', '20976', '20992', '20993', '21000', '21024', '21028', '21038', '21040', '21043', '21082', '21112', '21114', '21117', '21120', '21134', '21143', '21154', '21194', '21247', '21260', '21276', '21297', '21298', '21332', '21336', '21383', '21392', '21452', '21469', '21488', '21529', '21532', '21533', '21560', '21616', '21649', '21732', '21746', '21764', '21863', '21987', '22003', '22042', '22083', '22109', '22170', '22243', '22289', '22299', '22417', '22436', '22515', '22581', '22591', '22594', '22683', '22812', '22840', '22848', '22887', '22900', '22960', '22964', '23000', '23029', '23033', '23101', '23106', '23160', '23220', '23228', '23344', '23430', '23461', '23564', '23620', '23622', '23647', '23654', '23662', '23671', '23914', '23942', '23943', '23983', '24001', '24010', '24043', '24061', '24105', '24129', '24238', '24268', '24331', '24358', '24365', '24418', '24454', '24461', '24478', '24492', '24524', '24525', '24548', '24556', '24606', '24676', '24764', '24839', '24858', '24916', '24922', '25041', '25141', '25160', '25164', '25244', '25245', '25279', '25324', '25333', '25368', '25375', '25412', '25431', '25446', '25507', '25566', '25648', '25683', '25702', '25705', '25803', '25852', '25918', '25979', '26045', '26471', '26497', '26548', '26575', '26585', '26598', '26650', '26720', '26793', '26799', '26800', '26904', '26910', '26936', '26981', '27009', '27048', '27097', '27134', '27145', '27148', '27185', '27303', '27809', '27812', '27836', '27867', '27937', '27942', '27949', '27951', '27954', '27956', '27962', '27969', '27974', '28054', '28056', '28067', '28088', '28100', '28116', '28271', '28306', '28329', '28374', '28403', '28551', '28571', '28782', '28802', '29020', '29079', '29118', '29163', '29218', '29227', '29276', '29299', '29625', '29630', '29705', '29812', '29928', '29930', '29990', '30009', '30058', '30221', '30340', '30377', '30387', '30557', '30564', '30647', '30655', '30716', '30862', '30889', '30911', '30919', '30936', '30975', '30980', '30983', '31021', '31078', '31092', '31119', '31149', '31168', '31172', '31383', '31386', '31435', '31473', '31474', '31485', '31505', '31587', '31604', '31672', '31709', '31747', '31866', '31898', '31912', '31914', '31928', '31968', '31970', '31990', '32044', '32113', '32116', '32124', '32142', '32154', '32398', '32402', '32432', '32434', '32439', '32441', '32466', '32570', '32630', '32638', '32640', '32655', '32778', '32823', '32929', '33070', '33078', '33119', '33120', '33264', '33293', '33301', '33380', '33382', '33459', '33477', '33493', '33661', '33672', '33673', '33794', '33865', '33884', '33919', '33963', '33993', '34117', '34166', '34168', '34245', '34293', '34348', '34349', '34381', '34413', '34443', '34468', '34477', '34480', '34509', '34598', '34683', '34765', '34807', '34810', '34848', '34913', '34939', '34963', '35040', '35061', '35073', '35081', '35087', '35095', '35138', '35241', '35255', '35257', '35265', '35314', '35403', '35427', '35450', '35496', '35503', '35517', '35566', '35596', '35601', '35702', '35826', '35856', '35857', '35865', '35872', '35888', '35958', '35967', '35975', '36046', '36050', '36058', '36072', '36113', '36148', '36259', '36307', '36313', '36410', '36436', '36611', '36630', '36639', '36642', '36721', '36723', '36725', '36783', '36798', '36861', '36891', '36910', '36938', '37006', '37109', '37138', '37175', '37190', '37210', '37218', '37222', '37345', '37400', '37589', '37612', '37684', '37720', '37843', '37878', '37945', '38114', '38377', '38464', '38600', '38749', '38774', '38787', '39250', '39421', '39529', '39583', '39585', '39611', '39642', '39848', '39902', '40030', '40133', '40165', '40234', '40235', '40278', '40282', '40376', '40457', '40493', '40537', '40558', '40648', '40898', '41009', '41054', '41249', '41258', '41259', '41263', '41561', '41764', '41783', '41886', '42034', '42048', '42174', '42332', '42356', '42411', '42421', '42576', '42582', '42670', '42715', '42991', '43035', '43332', '43651', '43786', '43867', '43870', '43999', '44171', '44198', '44261', '44354', '44680', '44922', '45273', '45275', '45421', '45715', '46029', '46058', '46293', '46365', '46475', '46688', '46916', '46952', '46962', '47017', '47085', '47174', '47188', '47259', '47286', '47322', '47423', '47548', '47576', '47584', '47822', '48057', '48219', '48262', '48293', '48360', '48390', '48569', '48633', '48681', '48691', '48839', '48884', '49126', '49172', '49567', '49904', '50810', '50842', '50944', '51026', '51097', '51142', '51440', '51552', '52124', '52359', '52400', '52584', '52630', '53089', '53237', '53413', '53415', '53465', '53514', '53537', '53566', '53571', '53623', '53625', '53723', '53852', '53932', '53966', '54129', '54250', '54428', '54710', '54905', '55570', '55986', '56231', '56245', '56698', '57047', '57127', '57272', '57327', '57352', '57360', '57370', '57469', '57491', '57720', '58031', '58610', '58628', '58674', '58758', '58779', '59005', '59012', '59058', '59273', '59330', '59696', '59789', '60260', '60291', '60458', '60482', '60554', '60699', '60812', '60868', '60885', '61001', '61035', '61041', '61047', '61072', '61318', '61359', '61389', '61416', '61488', '61499', '61515', '61559', '61893', '61946', '62179', '62265', '62277', '62420', '62575', '62600', '62624', '62642', '62644', '62692', '62725', '62747', '62779', '62898', '62930', '62949', '63005', '63051', '63064', '63586', '63777', '63824', '64070', '64200', '64297', '64342', '64367', '64373', '64550', '64596', '64821', '64919', '65008', '65131', '65155', '65156', '65178', '65237', '65378', '65720', '65727', '65811', '65869', '65907', '65914', '66016', '66250', '66323', '66364', '66555', '66600', '66609', '66615', '66678', '66794', '66812', '66867', '67079', '67095', '67167', '67180', '67190', '67283', '67762', '67833', '67838', '68014', '68143', '68329', '68410', '68501', '68628', '68704', '68800', '68829', '68903', '68942', '68953', '69029', '69037', '69092', '69150', '69164', '69672', '69693', '70037', '70482', '70711', '70904', '70913', '71090', '71193', '71214', '71673', '71690', '71697', '71867', '72053', '72272', '72360', '72622', '72666', '72737', '73049', '73249', '73326', '73345', '73549', '73559', '73658', '73827', '73906', '73983', '73990', '74134', '74186', '74538', '74703', '74945', '75037', '75061', '75123', '75205', '75229', '75236', '75496', '75516', '75644', '75803', '75903', '76028', '76092', '76243', '76293', '76514', '76567', '76655', '76858', '76894', '76895', '76977', '77000', '77325', '77351', '77366', '77421', '77537', '77551', '77760', '77801', '78307', '78369', '78450', '78635', '78653', '78790', '78893', '78931', '79020', '79072', '79096', '79102', '79129', '79133', '79489', '79506', '79602', '79676', '79838', '79901', '79905', '80030', '80621', '81173', '81234', '81648', '81698', '81774', '81793', '81892', '82035', '82036', '82257', '82457', '82569', '82605', '82805', '82979', '83037', '83073', '83356', '83387', '83453', '83595', '83737', '83972', '84071', '84105', '84155', '84166', '84176', '84383', '84473', '84493', '84580', '84626', '84639', '84646', '84670', '84707', '84749', '84817', '84881', '84959', '84984', '85122', '85165', '85199', '85206', '85286', '85320', '85339', '85366', '85472', '85534', '85609', '85643', '85688', '85728', '85741', '85886', '85893', '86031', '86043', '86540', '86633', '86692', '86695', '86736', '86806', '87164', '87173', '87345', '87883', '87950', '88016', '88067', '88114', '88243', '88261', '88269', '88877', '89505', '89520', '89524', '89682', '89694', '89836', '89847', '89981', '90025', '90092', '90175', '90184', '90394', '90424', '90515', '90698', '90709', '90768', '90875', '90887', '90915', '90927', '90981', '91039', '91050', '91140', '91171', '91180', '91207', '91216', '91229', '91314', '91431', '91497', '91498', '91518', '91540', '91559', '91570', '91619', '91646', '91710', '91724', '91875', '91882', '91889', '91904', '91928', '91977', '91979', '91996', '92006', '92061', '92069', '92275', '92345', '92462', '92483', '92497', '92509', '92549', '92587', '92603', '92653', '92681', '92725', '92740', '92768', '92901', '92911', '92914', '92942', '92976', '93026', '93078', '93115', '93133', '93213', '93232', '93360', '93374', '93535', '93542', '93544', '93545', '93750', '93972', '94061', '94093', '94132', '94135', '94151', '94205', '94233', '94249', '94262', '94282', '94303', '94356', '94608', '94625', '94629', '94673', '94752', '94760', '94774', '94795', '94817', '94909', '95587', '95619', '95635', '95845', '95849', '95878', '95888', '95891', '95908', '95961', '95991', '96018', '96027', '96032', '96052', '96081', '96105', '96112', '96192', '96226', '96341', '96351', '96361', '96386', '96391', '96443', '96458', '96471', '96473', '96509', '96513', '96514', '96553', '96587', '96629', '96644', '96725', '96728', '96742', '96750', '96758', '96762', '96822', '96849', '96964', '96988', '97057', '97123', '97183', '97200', '97201', '97204', '97214', '97228', '97262', '97287', '97296', '97336', '97341', '97343', '97347', '97348', '97350', '97396', '97415', '97417', '97517', '97520', '97591', '97596', '97621', '97713', '97749', '97764', '97765', '97783', '97797', '97817', '97819', '97850', '97862', '97883', '97975', '97984', '98012', '98015', '98019', '98199', '98236', '98240', '98259', '98298', '98387', '98404', '98427', '98442', '98457', '98470', '98512', '98548', '98666', '98667', '98676', '98726', '98758', '98810', '98834', '98858', '98893', '98913', '98920', '98936', '98956', '98979', '98997', '99014', '99023', '99085', '99150', '99152', '99187', '99208', '99210', '99212', '99213', '99217', '99236', '99241', '99293', '99310', '99331', '99332', '99362', '99382', '99491', '99492', '99510', '99551', '99715', '99742', '99792', '99854', '99887', '99898', '99967', '99969', '99978', '99983', '100000', '100011', '100129', '100131', '100159', '100179', '100199', '100205', '100214', '100231', '100329', '100371', '100385', '100389', '100461', '100495', '100516', '100553', '100685', '100702', '100730', '100738', '100797', '100807', '100829', '100863', '100900', '100965', '101063', '101065', '101100', '101171', '101186', '101200', '101209', '101227', '101233', '101241', '101251', '101272', '101321', '101383', '101390', '101497', '101603', '101625', '101666', '101670', '101679', '101702', '101738', '101747', '101754', '101772', '101787', '101801', '101818', '101826', '101899', '101925', '101932', '101935', '101966', '101976', '101995', '102009', '102039', '102040', '102068', '102115', '102124', '102137', '102161', '102221', '102271', '102376', '102423', '102429', '102431', '102440', '102524', '102536', '102583', '102607', '102609', '102650', '102683', '102690', '102705', '102713', '102742', '102773', '102826', '102836', '102874', '102904', '102905', '102961', '102995', '103003', '103025', '103103', '103120', '103195', '103245', '103249', '103269', '103310', '103351', '103365', '103378', '103397', '103462', '103469', '103530', '103559', '103563', '103600', '103615', '103616', '103623', '103695', '103764', '103783', '103805', '103810', '103832', '103833', '103842', '103904', '103930', '104052', '104077', '104097', '104120', '104201', '104203', '104205', '104237', '104240', '104269', '104279', '104318', '104323', '104350', '104365', '104372', '104384', '104455', '104480', '104497', '104511', '104546', '104591', '104652', '104657', '104724', '104745', '104761', '104770', '104778', '104780', '104817', '104906', '104917', '104939', '104970', '104981', '104987', '105006', '105009', '105021', '105031', '105057', '105077', '105088', '105099', '105150', '105151', '105159', '105161', '105164', '105183', '105200', '105498', '105524', '105554', '105571', '105611', '105614', '105711', '105712', '105725', '105741', '105749', '105763', '105779', '105810', '105827', '105839', '105855', '105864', '105881', '105883', '105903', '105906', '105914', '105942', '105973', '106049', '106062', '106067', '106070', '106121', '106123', '106127', '106132', '106158', '106173', '106187', '106188', '106198', '106201', '106205', '106239', '106246', '106253', '106263', '106265', '106272', '106284', '106285', '106291', '106294', '106298', '106306', '106313', '106336', '106356', '106357', '106361', '106366', '106369', '106371', '106376', '106378', '106379', '106380', '106385', '106387', '106389', '106396', '106401', '106405', '106409', '106410', '106411', '106412', '106414', '106415', '106419', '106437', '106439', '106441', '106450', '106528', '106558', '106579', '106605', '106608', '106615', '106623', '106628', '106630', '106634', '106644', '106645', '106651', '106654', '106657', '106660', '106667', '106674', '106676', '106678', '106680', '106682', '106686', '106690', '106693', '106696', '106709', '106711', '106713', '106722', '106725', '106726', '106731', '106733', '106736', '106739', '106748', '106749', '106755', '106759', '106766', '106771', '106779', '106783', '106785', '106790', '106811', '106812', '106817', '106820', '106824', '106834', '106839', '106843', '106846', '106849', '106858', '106861', '106862', '106863', '106868', '106873', '106875', '106893', '106894', '106901', '106905', '106914', '106921', '106922', '106924', '106929', '106933', '106939', '106952', '106953', '106955', '106958', '106965', '106966', '106968', '106989', '107004', '107016', '107017', '107020', '107032', '107044', '107045', '107051', '107052', '107054', '107074', '107078', '107081', '107085', '107091', '107092', '107098', '107101', '107102', '107109', '107110', '107113', '107144', '107147', '107148', '107151', '107166', '107167', '107173', '107184', '107185', '107187', '107190', '107191', '107192', '107196', '107217', '107226', '107227', '107233', '107237', '107239', '107254', '107259', '107264', '107272', '107273', '107279', '107283', '107284', '107300', '107321', '107324', '107339', '107355', '107363', '107377', '107383', '107391', '107394', '107414', '107422', '107427', '107428', '107429', '107434', '107437', '107438', '107450', '107453', '107455', '107481', '107482', '107483', '107485', '107489', '107499', '107502', '107533', '107538', '107540', '107558', '107562', '107563', '107573', '107580', '107583', '107596', '107604', '107609', '107614', '107623', '107624', '107628', '107639', '107640', '107642', '107646', '107654', '107656', '107659', '107667', '107670', '107691', '107692', '107699', '107707', '107709', '107711', '107718', '107722', '107724', '107732', '107735', '107738', '107745', '107746', '107753', '107758', '107764', '107765', '107767', '107777', '107786', '107801', '107809', '107811', '107812', '107831', '107847', '107849', '107850', '107860', '107868', '107875', '107878', '107880', '107882', '107889', '107892', '107895', '107897', '107901', '107913', '107915', '107916', '107920', '107924', '107931', '107948', '107949', '107955', '107957', '107967', '107975', '107980', '107992', '107994', '107999', '108002', '108008', '108009', '108010', '108016', '108020', '108043', '108044', '108048', '108066', '108070', '108075', '108077', '108098', '108110', '108127', '108136', '108149', '108150', '108151', '108157', '108158', '108169', '108197', '108221', '108226', '108269', '108270', '108274', '108278', '108299', '108315', '108316', '108319', '108325', '108338', '108342', '108360', '108363', '108385', '108388', '108401', '108403', '108405', '108409', '108416', '108437', '108443', '108449', '108456', '108472', '108483', '108493', '108503', '108542', '108552', '108568', '108585', '108591', '108599', '108629', '108641', '108643', '108668', '108669', '108673', '108679', '108708', '108710', '108725', '108727', '108728', '108733', '108738', '108742', '108745', '108755', '108769', '108770', '108774', '108787', '108788', '108810', '108833', '108844', '108845', '108857', '108870', '108872', '108877', '108880', '108884', '108885', '108931', '108935', '108939', '108957', '108974', '108994', '109010', '109015', '109021', '109022', '109023', '109039', '109044', '109045', '109046', '109048', '109053', '109060', '109066', '109095', '109099', '109102', '109114', '109122', '109133', '109136', '109138', '109143', '109146', '109158', '109159', '109166', '109169', '109174', '109183', '109184', '109189', '109196', '109216', '109224', '109226', '109227', '109234', '109239', '109246', '109247', '109252', '109257', '109267', '109279', '109283', '109291', '109300', '109325', '109332', '109340', '109343', '109354', '109357', '109371', '109375', '109382', '109383', '109385', '109389', '109394', '109417', '109428', '109429', '109436', '109441', '109444', '109445', '109459', '109467', '109476', '109477', '109479', '109483', '109498', '109511', '109523', '109524', '109526', '109531', '109537', '109548', '109552', '109576', '109588', '109596', '109619', '109631', '109640', '109643', '109651', '109668', '109675', '109685', '109688', '109693', '109694', '109703', '109712', '109714', '109724', '109726', '109728', '109735', '109736', '109778', '109780', '109791', '109803', '109809', '109814', '109816', '109818', '109821', '109824', '109832', '109836', '109837', '109844', '109846', '109847', '109850', '109851', '109858', '109860', '109868', '109882', '109883', '109886', '109889', '109896', '109902', '109906', '109909', '109924', '109934', '109939', '109952', '109971', '109973', '109977', '109985', '109992', '109999', '110001', '110003', '110009', '110010', '110030', '110031', '110040', '110042', '110043', '110048', '110065', '110075', '110087', '110093', '110100', '110107', '110128', '110140', '110142', '110151', '110158', '110160', '110173', '110179', '110210', '110219', '110240', '110247', '110255', '110278', '110292', '110304', '110311', '110312', '110317', '110340', '110348', '110351', '110352', '110364', '110379', '110391', '110392', '110405', '110414', '110421', '110433', '110438', '110441', '110456', '110484', '110495', '110532', '110591', '110592', '110603', '110604', '110626', '110634', '110635', '110648', '110653', '110656', '110702', '110705', '110712', '110717', '110733', '110738', '110742', '110749', '110754', '110760', '110766', '110767', '110773', '110778', '110792', '110797', '110852', '110860', '110866', '110874', '110877', '110878', '110888', '110892', '110907', '110923', '110924', '110951', '110952', '111007', '111016', '111038', '111039', '111045', '111046', '111084', '111094', '111104', '111127', '111137', '111185', '111186', '111187', '111188', '111190', '111209']
  10.  
  11. editors_pick = [0, 2, 0, 0, 0, 1, 0, 15, 6, 0, 1, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 30, 2, 0, 0, 0, 4, 0, 2, 0, 0, 0, 0, 0, 1, 1, 9, 0, 0, 0, 0, 0, 0, 0, 1, 1, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 23, 5, 0, 0, 176, 1, 0, 9, 0, 0, 0, 6, 0, 113, 0, 0, 0, 0, 0, 0, 97, 0, 25, 0, 0, 0, 33, 0, 0, 4, 0, 5, 0, 0, 2, 0, 0, 1, 0, 13, 0, 0, 0, 0, 0, 0, 88, 0, 2, 1, 15, 0, 1, 2, 97, 0, 10, 0, 0, 1, 11, 0, 3, 5, 2, 4, 82, 23, 0, 3, 8, 0, 2, 0, 0, 0, 0, 7, 0, 21, 0, 0, 0, 2, 1, 0, 0, 0, 2, 2, 0, 1, 1, 2, 21, 0, 0, 25, 1, 5, 1, 12, 4, 23, 0, 0, 0, 0, 0, 0, 1, 22, 0, 0, 0, 18, 0, 0, 0, 0, 5, 59, 5, 3, 5, 0, 2, 1, 21, 0, 20, 0, 1, 0, 0, 11, 4, 0, 1, 0, 5, 11, 0, 0, 7, 0, 0, 0, 3, 2, 1, 8, 12, 0, 6, 1, 1, 0, 0, 25, 0, 0, 6, 0, 1, 0, 3, 19, 2, 0, 5, 6, 2, 1, 2, 1, 1, 1, 0, 0, 0, 0, 0, 10, 0, 1, 0, 0, 0, 53, 46, 0, 0, 0, 12, 0, 0, 1, 3, 2, 2, 0, 0, 33, 0, 1, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 24, 1, 0, 37, 0, 0, 18, 3, 12, 0, 0, 0, 0, 6, 1, 0, 20, 1, 0, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 2, 1, 0, 14, 0, 1, 0, 1, 0, 4, 0, 0, 1, 0, 2, 0, 1, 0, 1, 1, 2, 0, 2, 0, 8, 0, 0, 0, 14, 0, 1, 1, 7, 1, 0, 16, 0, 0, 0, 0, 3, 1, 0, 0, 6, 7, 0, 0, 1, 12, 1, 6, 2, 0, 0, 0, 4, 2, 0, 0, 8, 6, 0, 1, 0, 12, 2, 0, 0, 8, 1, 0, 3, 0, 2, 3, 15, 1, 18, 0, 1, 9, 0, 24, 3, 7, 12, 2, 12, 0, 0, 8, 0, 0, 7, 2, 1, 0, 0, 28, 8, 2, 20, 0, 58, 0, 0, 0, 13, 1, 0, 5, 0, 3, 0, 17, 0, 1, 2, 11, 1, 2, 1, 1, 0, 0, 0, 0, 0, 5, 0, 22, 0, 1, 4, 0, 0, 0, 0, 0, 0, 0, 3, 3, 0, 1, 5, 1, 1, 0, 10, 9, 0, 1, 50, 11, 7, 1, 40, 2, 0, 0, 0, 0, 1, 0, 3, 1, 1, 2, 1, 5, 1, 6, 0, 50, 7, 0, 0, 0, 0, 2, 5, 42, 8, 20, 0, 5, 5, 1, 0, 0, 3, 0, 0, 0, 7, 0, 9, 1, 0, 14, 7, 39, 10, 0, 20, 11, 0, 3, 0, 27, 0, 22, 9, 13, 1, 0, 4, 3, 3, 0, 0, 10, 2, 1, 0, 2, 3, 1, 1, 11, 1, 0, 0, 64, 0, 0, 0, 13, 4, 0, 1, 1, 2, 1, 5, 0, 0, 0, 1, 5, 41, 1, 10, 6, 1, 6, 9, 0, 0, 7, 0, 1, 16, 7, 4, 1, 3, 0, 0, 35, 1, 2, 0, 1, 16, 4, 1, 8, 1, 9, 9, 9, 9, 0, 11, 7, 8, 1, 4, 1, 2, 0, 0, 8, 7, 0, 0, 1, 4, 1, 1, 1, 1, 1, 2, 12, 1, 34, 0, 0, 0, 0, 1, 0, 1, 1, 1, 4, 36, 1, 0, 1, 7, 4, 2, 0, 3, 5, 7, 15, 1, 1, 0, 1, 6, 0, 0, 0, 2, 0, 3, 0, 1, 7, 1, 2, 34, 1, 32, 0, 0, 18, 0, 58, 3, 32, 4, 0, 6, 1, 0, 4, 0, 1, 0, 5, 0, 1, 0, 5, 0, 0, 25, 4, 0, 5, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 4, 0, 0, 2, 31, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 4, 1, 0, 1, 0, 0, 1, 1, 6, 0, 0, 0, 1, 0, 0, 3, 0, 0, 66, 0, 2, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 14, 0, 1, 0, 1, 1, 0, 0, 6, 0, 1, 0, 0, 0, 0, 2, 1, 0, 33, 1, 0, 1, 0, 0, 5, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 20, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 3, 0, 3, 32, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 3, 1, 0, 0, 0, 1, 0, 0, 1, 4, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 8, 0, 0, 1, 0, 1, 0, 0, 0, 0, 3, 2, 0, 3, 0, 1, 0, 20, 1, 0, 0, 0, 0, 1, 1, 0, 0, 2, 9, 0, 9, 1, 0, 1, 0, 3, 1, 7, 0, 0, 0, 8, 0, 0, 2, 0, 19, 0, 0, 13, 3, 0, 0, 0, 0, 0, 2, 0, 0, 0, 7, 0, 0, 0, 0, 8, 0, 0, 2, 0, 0, 2, 0, 2, 0, 4, 0, 1, 0, 0, 8, 0, 34, 0, 0, 18, 4, 0, 0, 0, 0, 0, 1, 0, 20, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 1, 2, 0, 0, 1, 0, 0, 0, 11, 0, 0, 13, 5, 0, 0, 1, 0, 0, 0, 2, 0, 1, 0, 0, 0, 0, 1, 0, 0, 2, 0, 0, 0, 0, 12, 0, 0, 10, 7, 2, 10, 0, 2, 0, 4, 0, 3, 0, 0, 0, 0, 1, 1, 8, 6, 0, 6, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 10, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 5, 0, 0, 0, 0, 0, 0, 4, 1, 26, 0, 0, 0, 0, 0, 0, 0, 3, 1, 1, 0, 0, 0, 23, 0, 0, 0, 0, 44, 0, 0, 0, 2, 0, 0, 0, 0, 1, 1, 0, 0, 2, 0, 0, 0, 0, 0, 18, 0, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 0, 1, 0, 0, 4, 0, 3, 0, 0, 0, 0, 0, 0, 1, 13, 34, 0, 0, 4, 0, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 3, 0, 4, 10, 1, 0, 0, 0, 1, 0, 0, 0, 0, 25, 0, 0, 10, 0, 17, 0, 0, 1, 0, 0, 0, 1, 0, 1, 24, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 3, 0, 0, 0, 0, 0, 0, 1, 1, 2, 0, 0, 3, 0, 0, 4, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 5, 1, 0, 22, 0, 0, 0, 6, 1, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 2, 9, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, 0, 7, 0, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 3, 0, 0, 0, 5, 0, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 9, 0, 0, 1, 13, 0, 0, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 5, 0, 28, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 6, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 9, 0, 0, 0, 0, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 12, 0, 0, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 2, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 19, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 9, 0, 1, 1, 2, 0, 0, 0, 0, 3, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 5, 27, 1, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 4, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 4, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 5, 0, 0, 0, 0, 0, 2, 0, 3, 0, 0, 0, 0, 0, 0, 0, 2, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 12, 0, 0, 1, 0, 13, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2, 0, 24, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 3, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 3, 0, 0, 0, 0, 0, 4, 0, 0, 0, 6, 0, 0, 0, 0, 1, 0, 1, 0, 0, 47, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 3, 1, 0, 14, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 40, 0, 0, 0, 6, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 11, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 2, 0, 0, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 3, 0, 0, 15, 1, 0, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 2, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 3, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 1, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 4, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 1, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 3, 3, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 10, 0, 0, 0, 0, 1, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 0, 0, 0, 14, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 6, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 6, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]
  12.  
  13.  
  14.  
  15.  
  16. dbServer='localhost'
  17. dbPass=''
  18. dbSchema='sportskeeda'
  19. dbUser='sportskeeda'
  20. database_location="/var/lib/mysql/sportskeeda"
  21. conn = dbapi.connect(host=dbServer,user=dbUser,passwd=dbPass,db="sportskeeda")
  22. c = conn.cursor()
  23. c1 = conn.cursor()
  24. c2 = conn.cursor()
  25. results1 = []
  26. dbquery1 = "SELECT author_id FROM keeda_author_fact WHERE modified_date>2013-01-01 AND author_post_count>0 ORDER BY created_date DESC;"
  27. c.execute(dbquery1)
  28. authors = c.fetchall()
  29. # print authors
  30. array_of_authors = []
  31. for author in authors:
  32. array_of_authors.append(author)
  33. # print len(array_of_authors)
  34. final_results = []
  35. for auth_id in array_of_authors:
  36. author_id = str(auth_id)
  37. author_id1 = author_id.split(',')[0]
  38. author_id2 = author_id1.split('(')[1]
  39. db_query2 = "select b.author_id, a.author_name, a.author_nicename, b.author_post_count, b.total_reads, a.read_count, a.modified_date, a.post_date_formatted, count(a.author_id) as editors_pick , a.author_email, b.author_rss, b.author_url from keeda_post_fact a, keeda_author_fact b where a.author_id=b.author_id and a.author_id='" + author_id2 + "' and a.section_tt_id=19688;"
  40. # print db_query2
  41. c1.execute(db_query2)
  42. results2 = c1.fetchall()
  43. final_results.append(results2)
  44. print len(final_results)
  45. for item in final_results:
  46. with open('/home/puja/Documents/fb-api-test/writers2.csv', 'a') as outfile:
  47. a = csv.writer(outfile, delimiter=',')
  48. data = item
  49. a.writerows(data)
  50. # print results2
  51.  
  52. # for item in array_authors:
  53. # db_query3 = "SELECT DISTINCT a.author_id, a.author_email, a.author_nicename, b.author_post_count, b.total_reads, a.modified_date FROM keeda_post_fact a, keeda_author_fact b WHERE a.author_id=b.author_id and a.author_id='" + item +"'LIMIT 1;"
  54. # # print db_query3
  55. # c.execute(db_query3)
  56. # results = c.fetchall
  57. # print results
  58. # for result in results:
  59. # print result
  60.  
  61.  
  62. # db_query3 = "SELECT DISTINCT a.author_id, a.author_email, a.author_nicename, b.author_post_count, b.total_reads, a.modified_date FROM keeda_post_fact a, keeda_author_fact b WHERE a.author_id=b.author_id;"
  63. # c1.execute(db_query3)
  64. # result2 = c1.fetchall()
  65. # print result2
  66.  
  67.  
  68. # db_query1 = "SELECT DISTINCT author_id from keeda_post_fact LIMIT 0,50000;"
  69. # db_query2 = "SELECT count(author_id) from keeda_post_fact WHERE section_tt_id=19688 AND author_id=31;"
  70. # db_query3 = "SELECT DISTINCT a.author_id, a.author_email, a.author_nicename, b.author_post_count, b.total_reads, a.modified_date FROM keeda_post_fact a, keeda_author_fact b WHERE a.author_id=b.author_id and a.author_id='98015L'"
  71. # c.execute(db_query3)
  72. # results = c.fetchall()
  73. # for result in results:
  74. # array_authors.append(result)
  75. # print array_authors
  76. # for item in array_authors:
  77. # print item
  78. # db_query2 = "SELECT count(author_id) from keeda_post_fact WHERE section_tt_id=19688 AND author_id='" + item + "';"
  79. # print db_query2
  80. # print db_query2
  81. # db_query3 = "SELECT DISTINCT a.author_id, a.author_email, a.author_nicename, b.author_post_count, b.total_reads, a.modified_date FROM keeda_post_fact a, keeda_author_fact b WHERE a.author_id=b.author_id='" + item + "';"
  82. # print db_query2
  83. # print db_query3
  84. # c.execute(db_query2)
  85. # c1.execute(db_query3)
  86. # result1 = c.fetchall()
  87. # results1.append(result1)
  88. # print results1
  89.  
  90. # result2 = c1.fetchall()
  91. # print result1
  92. # print result2
  93.  
  94.  
  95. get_all_data_from_db()
Add Comment
Please, Sign In to add comment