Multiple line items in the database but one in the order page
I am doing a report module to show various information about drupal commerce orders and line items.
I am now facing a problem with the line items:
For some orders, in the commerce_line_item table, there are multiple line items for the same product and quantity.
However, in the order page of these orders, I only see one line item.
I suppose only one of these line items is the good one, but how can I know which one is good in the table?
They looks the same except the line_item_id field which is different.
So how can I get the line items of an order without any of these dupplicate line items?
Why are there dupplicate line items in the table?
For instance, this query:
WHERE order_id = 388
gives me 5 intead of 1.
I am using Drupal Commerce 7.x-1.3.
Thanks for your help.