xml version=10 encoding=UTF-8!DOCTYPE mapper PUBLIC -mybatisorgDTD Mapper 30EN httpmybatisorgdtdmybatis-3-mapperdtdmapper namespace=comecommercebookmapperOrderItemsMapper resultMap id

在XML文件中，查询语句中有一个额外的逗号(","),可能会导致语法错误。正确的查询语句应该如下：

<select id="selectByOrderId" resultMap="BaseResultMap">
    select oi.id, oi.order_id, oi.product_id, oi.quantity, oi.price, oi.created_at, oi.updated_at,
    p.name, p.description, p.price, p.category_id, p.image_url, p.stock, p.is_featured, p.created_at, p.updated_at, p.weight, p.brand, p.supplier, p.origin, p.is_active, p.is_deleted
    from order_items oi
    left join products p on oi.product_id = p.id
    where oi.order_id = #{orderId}
</select>

除此之外，代码中没有其他明显的错误