The wrong count of ships by type is displayed on the character page
https://bit.ly/2XuCiBe
Because null values of ship_type_id are not filtered with left join
If add the filter whereNotNull('ship_type_id'), there is displayed correctly.
https://bit.ly/2RMorTx
The wrong count of ships by type is displayed on the character page https://bit.ly/2XuCiBe Because null values of ship_type_id are not filtered with left join If add the filter whereNotNull('ship_type_id'), there is displayed correctly. https://bit.ly/2RMorTx