Error : 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 'and cm_products.brand_id =5 and cm_shops.shop_status = 'Open' and cm_products.' at line 1
SQL : SELECT * FROM cm_products INNER JOIN cm_shops ON cm_products.shop_id = cm_shops.shop_id where cm_shops.shop_id= and cm_products.brand_id =5 and cm_shops.shop_status = 'Open' and cm_products.product_display_id ='1'