เกิดข้อผิดพลาดของฐานข้อมูล

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 'ORDER BY p.order ASC' at line 1

SELECT p.product_id , p.product_name , p.product_price , p.image_large , d.dealer_name FROM tb_product AS p LEFT JOIN tb_product_dealer AS d ON(p.dealer_id = d.dealer_id) WHERE p.brand_id = ORDER BY p.order ASC

Filename: models/frontend/Product_model.php

Line Number: 45