|
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, |