Hello,
I cannot find any query which feet your description.
Please update to HikaShop 4.0.1 in order to have latest patches regarding the "shipping per price".
If the problem remains, it would be interesting to activate the debug mode to get the full trace and know from which file that query is generated.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.