两个单独的JOIN中的MySQL COUNT行给出了错误的结果

I am attempting to join two tables to my query and count the number of matching rows from each of the joins. It seems to come back with the wrong result though. It seems to be doubling the results. Here is the queryI am attempting to join two tables to my query