"Backend dashboard legacy" doesn't work

-- HikaShop version -- : 4.0.1
-- Joomla version -- : 3.9.1
-- PHP version -- : 7.1.24

Hello.
I've kept the "Backend dashboard legacy" active, because it lets me customize the reports.

After I upgraded to Hikashop Business 4.0.0, the old dashboard throws this error:
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 'FROM #__hikashop_order AS a LEFT JOIN #__hikashop_order_product AS prod ON a.o' at line 1

I upgraded to 4.0.1 but the issue persists.
Can you help, please?

Thanks.
I am not getting this:
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 'FROM #__hikashop_order AS a LEFT JOIN #__hikashop_order_product AS prod ON a.o' at line 1 SELECT FROM j25_hikashop_order AS a LEFT JOIN j25_hikashop_order_product AS prod ON a.order_id=prod.order_id AND prod.order_product_tax > 0 WHERE a.order_type='sale' AND a.order_status IN ('confirmed') AND a.order_currency_id IN ('1') AND a.order_created > 1538352000 AND a.order_created < 1546214400

Thank you very much, that worked great.
I was able to isolate and delete the report that was giving the error.