Can't execute query

SELECT b.id, b.nazev_ AS name
FROM eshop_brands b
JOIN eshop_products p ON b.id = p.id_eshop_brands AND p.view = 1
JOIN eshop_products_mn_eshop_categories c ON p.id = c.id_eshop_products
WHERE c.id_eshop_categories IN (195,0)
AND b.active = 't' AND b.nazev_ != ''
GROUP BY b.id
ORDER BY name