MySQL Error Occurred

Error Message:
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 rand() LIMIT 8' at line 1

SQL:
SELECT I.name, I.description, I.productId, I.weight, I.price,I.amz_price,I.amz_list_price, I.sale_price, I.image , I.cat_id,I.prod_flag,I.disabled ,C.cat_name, I.showFeatured FROM cubecart_inventory AS I, cubecart_category AS C WHERE C.cat_id = I.cat_id AND I.cat_id > 0 AND I.status = 0 AND I.prod_flag = '0' AND I.image!='' AND I.cat_id= ORDER BY rand() LIMIT 8