gistfile1.txt

SELECT player_status_requests.player_id, player_status_requests.status AS record_status, players.status, COUNT(player_status_requests.status) AS status_count, (SELECT COUNT(*) FROM `player_status_requests` WHERE `player_status_requests`.`player_id` = `players`.`id` AND player_status_requests.created_at >= '2017-08-08T00:00:00+00:00') AS total_status_count FROM `player_status_requests` JOIN `players` ON `players`.`id` = `player_status_requests`.`player_id` WHERE `player_status_requests`.`player_id` IN (15471, 15472, 15473, 15475, 15476, 15478, 15480, 15485, 15488, 15489, 15490, 15491, 15492, 15493, 15494, 15496, 15497, 15498, 15500, 15501, 15502, 15503, 15505, 15506, 15508, 15509, 15510, 15511, 15512, 15513, 15515, 15516, 15517, 15518, 15519, 15520, 15521, 15522, 15523, 15524, 15525, 15526, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15538, 15539, 15540, 15541, 15542, 15543, 15544, 15545, 15546, 15547, 15549, 15551, 15552, 15553, 15554, 15555, 15557, 15558, 15560, 15561, 15562, 15563, 15564, 15565, 15567, 15568, 15569, 15570, 15572, 15573, 15574, 15575, 15576, 15577, 15578, 15579, 15580, 15582, 15583, 15584, 15585, 15586, 15587, 15588, 15589, 15590, 15591, 15592, 15593, 15594, 15595, 15596, 15597, 15598, 15599, 15600, 15601, 15602, 15603, 15604, 15605, 15606, 15607, 15608, 15609, 15610, 15611, 15612, 15613, 15614, 15616, 15617, 15618, 15619, 15620, 15621, 15622, 15623, 15624, 15625, 15626, 15627, 15628, 15629, 15630, 15631, 15633, 15634, 15635, 15636, 15637, 15638, 15639, 15640, 15641, 15643, 15644, 15647, 15648, 15650, 15652, 15653, 15654, 15657, 15658, 15659, 15660, 15662, 15663, 15664, 15665, 15666, 15670, 15671, 15673, 15675, 15676, 15677, 15678, 15680, 15682, 15683, 15684, 15686, 15687, 15688, 15689, 15690, 15691, 15693, 15694, 15695, 15697, 15698, 15699, 15700, 15701, 15703, 15704, 15707, 15708, 15709, 15710, 15711, 15713, 15715, 15716, 15722, 15723, 15724, 15725, 15727, 15729, 15731, 15733, 15734, 15735, 15737, 15739, 15740, 15741, 15742, 15744, 15745, 15746, 15747, 15748, 15749, 15750, 15751, 15752, 15753, 15754, 15755, 15756, 15757, 15758, 15759, 15760, 15761, 15762, 15764, 15765, 15766, 15767, 15768, 15770, 15771, 15772, 15773, 15774, 15775, 15776, 15777, 15778, 15779, 15780, 15781, 15782, 15783, 15784, 15785, 15786, 15787, 15788, 15789, 15791, 15792, 15793, 15794, 15795, 15796, 15798, 15800, 15801, 15802, 15807, 15809, 15810, 15811, 15815, 15817, 15832, 15838, 15839, 15841, 15842, 15843, 15844, 15848, 15850, 15853, 15858, 15862, 15864, 15874, 15875, 15876, 15877, 15880, 15881, 15882, 15883, 15884, 15886, 15890, 15891, 15892, 15894, 15895, 15896, 15897, 15900, 15905, 15906, 15907, 15908, 15909, 15911, 15914, 15915, 15917, 15918, 15919, 15921, 15922, 15925, 15926, 15927, 15929, 15930, 15931, 15932, 15933, 15934, 15935, 15936, 15937, 15938, 15941, 15943, 15945, 15946, 15947, 15948, 15949, 15952, 15953, 15954, 15957, 15958, 15959, 15961, 15962, 15966, 15967, 15968, 15969, 15970, 15972, 15973, 15974, 15976, 15977, 15978, 15983, 15987, 15988, 15990, 15991, 15992, 15993, 15994, 15995, 15996, 15998, 15999, 16000, 16002, 16003, 16004, 16005, 16007, 16008, 16009, 16010, 16012, 16013, 16014, 16015, 16016, 16017, 16018, 16019, 16020, 16021, 16022, 16023, 16024, 16025, 16026, 16027, 16028, 16029, 16030, 16031, 16032, 16033, 16034, 16035, 16036, 16037, 16038, 16039, 16040, 16041, 16042, 16043, 16044, 16045, 16046, 16047, 16048, 16049, 16050, 16051, 16055, 16056, 16059, 16060, 16061, 16069, 16070, 16071, 16072, 16073, 16075, 16076, 16077, 16079, 16080, 16081, 16082, 16083, 16084, 16085, 16086, 16088, 16091, 16093, 16094, 16096, 16097, 16098, 16099, 16100, 16101, 16102, 16104, 16105, 16106, 16107, 16109, 16110, 16115, 16117, 16118, 16120, 16121, 16124, 16129, 16132, 16133, 16134, 16135, 16137, 16138, 16139, 16142, 16143, 16144, 16145, 16146, 16147, 16148, 16149, 16152, 16153, 16154, 16155, 16156, 16157, 16158, 16159, 16160, 16161, 16164, 16166, 16168, 16169, 16170, 16171, 16172, 16175, 16176, 16177, 16178, 16179, 16180, 16181, 16182, 16183, 16184, 16185, 16186, 16187, 16190, 16191, 16193, 16194, 16195, 16196, 16197, 16198, 16200, 16202, 16203, 16205, 16206, 16207, 16208, 16209, 16210, 16213, 16214, 16215, 16216, 16217, 16218, 16220, 16221, 16222, 16223, 16224, 16225, 16226, 16227, 16229, 16230, 16232, 16233, 16234, 16235, 16237, 16238, 16239, 16241, 16244, 16247, 16250, 16251, 16252, 16253, 16254, 16255, 16256, 16257, 16258, 16259, 16260, 16263, 16264, 16265, 16266, 16267, 16268, 16270, 16271, 16272, 16273, 16275, 16276, 16277, 16282, 16283, 16284, 16285, 16286, 16287, 16288, 16289, 16290, 16291, 16292, 16293, 16294, 16295, 16296, 16297, 16298, 16299, 16300, 16301, 16302, 16303, 16304, 16306, 16309, 16310, 16311, 16312, 16313, 16315, 16318, 16319, 16321, 16322, 16323, 16324, 16328, 16329, 16330, 16331, 16333, 16334, 16335, 16336, 16337, 16340, 16342, 16343, 16344, 16347, 16349, 16350, 16351, 16352, 16353, 16354, 16355, 16356, 16357, 16358, 16359, 16360, 16361, 16362, 16363, 16364, 16365, 16366, 16367, 16368, 16369, 16370, 16371, 16372, 16373, 16374, 16375, 16376, 16377, 16378, 16379, 16380, 16381, 16382, 16385, 16386, 16387, 16396, 16398, 16399, 16402, 16405, 16406, 16407, 16408, 16412, 16413, 16414, 16416, 16419, 16420, 16423, 16424, 16429, 16430, 16431, 16434, 16435, 16437, 16446, 16449, 16452, 16457, 16459, 16464, 16466, 16467, 16469, 16470, 16472, 16473, 16474, 16475, 16476, 16478, 16479, 16480, 16481, 16482, 16483, 16486, 16487, 16488, 16489, 16492, 16493, 16494, 16498, 16499, 16500, 16501, 16502, 16504, 16505, 16507, 16508, 16509, 16510, 16511, 16512, 16513, 16514, 16515, 16517, 16518, 16519, 16521, 16523, 16524, 16528, 16529, 16532, 16534, 16536, 16539, 16540, 16541, 16542, 16543, 16544, 16545, 16547, 16552, 16555, 16556, 16557, 16558, 16559, 16560, 16563, 16567, 16568, 16573, 16574, 16575, 16577, 16585, 16586, 16587, 16588, 16589, 16590, 16591, 16592, 16593, 16594, 16597, 16599, 16600, 16601, 16602, 16604, 16605, 16606, 16608, 16609, 16610, 16611, 16612, 16613, 16614, 16615, 16616, 16617, 16618, 16619, 16620, 16622, 16627, 16628, 16629, 16630, 16632, 16634, 16636, 16637, 16638, 16641, 16642, 16644, 16646, 16651, 16653, 16664, 16665, 16667, 16668, 16669, 16670, 16671, 16672, 16679, 16680, 16687, 16692, 16693, 16697, 16699, 16701, 16703, 16704, 16705, 16707, 16708, 16711, 16712, 16713, 16714, 16715, 16716, 16717, 16718, 16719, 16720, 16724, 16728, 16731, 16735, 16742, 16744, 16745, 16747, 16750, 16751, 16752, 16753, 16756, 16760, 16762, 16763, 16764, 16765, 16766, 16772, 16775, 16776, 16778, 16779, 16781, 16783, 16784, 16785, 16786, 16787, 16790, 16796, 16799, 16801, 16802, 16804, 16807, 16816, 16817, 16818, 16819, 16822, 16823, 16835, 16839, 16840, 16842, 16844, 16845, 16846, 16847, 16849, 16850, 16851, 16852, 16853, 16855, 16857, 16858, 16859, 16860, 16861, 16868, 16869, 16870, 16872, 16875, 16877, 16879, 16880, 16882, 16883, 16884, 16885, 16887, 16888, 16889, 16890, 16891, 16892, 16893, 16894, 16895, 16896, 16897, 16899, 16900, 16901, 16902, 16903, 16904, 16905, 16908, 16910, 16911, 16912, 16913, 16914, 16918, 16919, 16922, 16923, 16924, 16925, 16926, 16927, 16928, 16934, 16935, 16936, 16937, 16939, 16940, 16941, 16942, 16943, 16944, 16947, 16948, 16949, 16950, 16951, 16952, 16953, 16954, 16955, 16956, 16957, 16958, 16959, 16960, 16961, 16962, 16963, 16964, 16965, 16966, 16967, 16968, 16969, 16970, 16971, 16972, 16973, 16974, 16975, 16976, 16977, 16978, 16979, 16980, 16981, 16982, 16983, 16984, 16985, 16986, 16987, 16988, 16989, 16991, 16992, 16993, 16994, 16995, 16996, 16998, 16999, 17000, 17001, 17002, 17003, 17004, 17005, 17006, 17007, 17008, 17020, 17021, 17022, 17023, 17024, 17025, 17026, 17027, 17028, 17029, 17030, 17031, 17032, 17033, 17034, 17035, 17036, 17037, 17038, 17039, 17040, 17041, 17043, 17045, 17046, 17047, 17048, 17049, 17050, 17051, 17052, 17053, 17054, 17055, 17056, 17057, 17058, 17059, 17060, 17061, 17062, 17063, 17067, 17070, 17071, 17072, 17074, 17075, 17077, 17078, 17079, 17080, 17081, 17082, 17083, 17084, 17085, 17086, 17087, 17088, 17089, 17090, 17092, 17093, 17094, 17095, 17096, 17097, 17098, 17099, 17100, 17101, 17102, 17103, 17104, 17105, 17106, 17107, 17108, 17110, 17111, 17113, 17114, 17115, 17116, 17117, 17118, 17120, 17121, 17123, 17124, 17125, 17127, 17128, 17129, 17130, 17132, 17134, 17136, 17137, 17142, 17145, 17146, 17147, 17148, 17149, 17153, 17160, 17166, 17171, 17172, 17173, 17174, 17175, 17176, 17177, 17182, 17183, 17184, 17186, 17187, 17188, 17311, 17313, 17318, 17320, 17324, 17326, 17327, 17328, 17330, 17334, 17335, 17336, 17346, 17358, 17361, 17362, 17363, 17365, 17366, 17367, 17369, 17370, 17372, 17378, 17379, 17389, 17390, 17391, 17406, 17433, 17437, 17449, 17450, 17451, 17452, 17453, 17454, 17455, 17457, 17458, 17461, 17462, 17463) AND `player_status_requests`.`status` = 1 AND (player_status_requests.created_at >= '2017-08-08 00:00:00') GROUP BY player_status_requests.player_id, player_status_requests.status ORDER BY player_status_requests.created_at ASC LIMIT 10;