Report showing incorrect amount

-- url of the page with the problem -- : eop-inc.com
-- HikaShop version -- : 5.1.6
-- Joomla version -- : 3.10.12
-- PHP version -- : 8.2.28
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : n/a

I've taken the "Weekly Performance" report and turned it into an annual report. It is showing one category as having over $30,000 worth of sales when it has only had about $1,200. Other categories appear to be correct. Where could this innacuracy possibly be coming from?

My report settings are:
Display: Type: Listing, Date Type: Created, Period 2025-01-01 to 2025-12-31
Filters: Order Status: Confirmed, Including Sub Categories Yes (No shows same result)
Options: Limit:100

All other settings are still at defualt

Sorry yes, Categories
snipboard.io/sJU20j.jpg

There are 55 queries being shown in the debug, not sure which one you need.

Is this the one you are looking for?

#32
SELECT *, SUM(order_full_price) as Total
FROM josdh_hikashop_order as a
LEFT JOIN josdh_hikashop_order_product as prod
ON a.order_id=prod.order_id
LEFT JOIN josdh_hikashop_product AS p
ON p.product_id=prod.product_id
LEFT JOIN josdh_hikashop_product_category as cat
ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id
LEFT JOIN josdh_hikashop_category as c
ON cat.category_id=c.category_id
WHERE a.order_type='sale'
AND a.order_status IN ('confirmed')
AND a.order_created > 1735707600
AND a.order_created < 1767157200
GROUP BY c.category_id
ORDER BY Total DESC
LIMIT 100