You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[t]' at line 7
DB Error: syntax error
SELECT
COUNT(*) AS count_product
FROM cms_product product
LEFT JOIN cms_product_category product_category ON product.product_category_id = product_category.product_category_id
LEFT JOIN cms_setting s_region ON product.region = s_region.value AND s_region.code = 'region'
LEFT JOIN cms_setting s_chateau ON product.chateau = s_chateau.value AND s_chateau.code = 'chateau'
WHERE product.stock > 0 AND product.product_category_id = [t]
Array
(
)