Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'or brand IN (select id from brands where category = and status=1))' at line 3
SELECT * FROM `products` WHERE `id` IN (select product from products_cat where (category=1) and `status` = 1) and `status` = 1 and (`brand` = or brand IN (select id from brands where category = and status=1))
Filename: models/Index.php
Line Number: 432