Hello, I'm creating a small app where admin users can judge videos. I'm getting good results from this current query but what I would ultimately like to do is now is to show all admin users that have judged or not with ADMIN_ROLE = 1. My query below only shows admins that have judged the videos only. I can't seem to figure that out.
SELECT *, t3.record_id AS recordID, SUM(onex + twox + threex) AS score
FROM tag_playlists t1
LEFT JOIN video_playlist_tag_rel t2
ON t1.record_id = t2.video_playlist_tag_record_id
INNER JOIN video_searches t3
ON t2.video_rel_record_id = t3.record_id
INNER JOIN video_status t4
ON t3.record_id = t4.rel_record_id
LEFT JOIN video_ratings t5
ON t4.rel_record_id = t5.video_rel_record_id
LEFT JOIN admins t6
ON t5.user_id = t6.admin_id
WHERE 0 = 0
AND DATE(t3.search_request_date) = '#day#'
GROUP BY t1.record_id, t3.record_id, t6.admin_id