How to Fix MySQL COUNT IF Not Working and Giving All 0s with LEFT JOIN and Conditional Counting