❌ FETCH ALL ERROR

SQLSTATE[42000]: Syntax error or access violation: 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 'LIMIT 9 OFFSET 0' at line 14

SQL:

SELECT
    p.*,
    i.thumbnail, 
    b.url AS brand_url, 
    b.title AS brand_title, 
    c.url AS category_url, 
    c.title AS category_title
    FROM products p
    LEFT JOIN images i ON i.id = p.idmainimage
    LEFT JOIN category c ON c.id = p.idcategory
    LEFT JOIN brands b ON b.id = p.idbrand
    WHERE p.idbrand = :bid
    ORDER BY 
    LIMIT 9 OFFSET 0
    

PARAMS:
Array
(
    [bid] => 23
)

TRACE:
#0 /var/www/dotsurveying.com/config/dbclass.php(105): PDO->prepare()
#1 /var/www/dotsurveying.com/manufacture.php(51): Database->fetchAll()
#2 {main}