I have a problem with SQL query for select count of ID

Question

I have a problem with COUNT - INNER JOIN query, I tried to find a soluton, but I didn't.. Someone have idea what is the problem? Thanks on answer!

SELECT COUNT(id) AS total
FROM products 
INNER JOIN `navigation_items` 
ON navigation_items.id = products.navigation_item 
INNER JOIN `navigation_items_group` 
ON navigation_items_group.id = products.navigation_item_group 
INNER JOIN `navigation_items_brand` 
ON navigation_items_brand.id = products.navigation_item_brand 
WHERE navigation_items.id='1' AND navigation_items_group.id='1' AND navigation_items_brand.id='1'

This is image od my database table 'products'

This is the error message what I get