Facing error when login vendor account and go to product listing page

-- url of the page with the problem -- : bookshop.school2u.my/booklist?limitstart...&filter_SetType_12=+
-- HikaShop version -- : 4.5.1
-- HikaMarket version -- : 4.1.0
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.4
-- Error-message(debug-mod must be tuned on) -- : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ((hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published =' at line 1

When login certain vendor account

visiting product list page as per mentioned

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ((hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published =' at line 1

will hit above error?

any clue which source code to check or optmized for this issue?

only happen on certain vendor account, suspect naming or setting of vendor causing this

Thanks for following up the issue

attached the debug we found that causing the error

there is an empty part in the query?

could you advise this query script location/path? or advise the method to fix this query

upgrade cant be done as there is lot of layout and customization changes conducted