SQL Error on price filter

-- HikaShop version -- : 3.3.3
-- Joomla version -- : 3.3.4
-- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'b.product_id' in 'on clause' SQL=SELECT DISTINCT b.product_id,b.compatibility, pprice.price_value FROM xzs4r_hikashop_product_category AS a LEFT JOIN (SELECT * FROM xzs4r_hikashop_product AS product1 LEFT JOIN xzs4r_hikashop_price AS price1 ON product1.product_id=price1.price_product_id LEFT JOIN xzs4r_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE (price1.price_access = 'all' OR price1.price_access LIKE '%,8,%' OR ISNULL(price1.price_access)) AND product1.product_type='main' GROUP BY product1.product_id ORDER BY price1.price_min_quantity ASC) AS b ON a.product_id=b.product_id LEFT JOIN xzs4r_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,2) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') AND ( ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' then b.price_value when b.price_currency_id IS NULL then 0 when b.price_currency_id = '2' then (b.price_value/1) end ) >= 1 ) AND ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' then b.price_value when b.price_currency_id IS NULL then 0 when b.price_currency_id = '2' then (b.price_value/1) end ) BETWEEN 0 AND 0 ORDER BY b.product_created DESC

Hi again
I'm using the filters and I have set a filter for Price, type cursor, min - max: 0 - 100
As soon as I choose apply on "Price", it gives me an error

1054 - Unknown column 'b.product_id' in 'on clause' SQL=SELECT DISTINCT b.product_id,b.compatibility, pprice.price_value FROM xzs4r_hikashop_product_category AS a LEFT JOIN (SELECT * FROM xzs4r_hikashop_product AS product1 LEFT JOIN xzs4r_hikashop_price AS price1 ON product1.product_id=price1.price_product_id LEFT JOIN xzs4r_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE (price1.price_access = 'all' OR price1.price_access LIKE '%,8,%' OR ISNULL(price1.price_access)) AND product1.product_type='main' GROUP BY product1.product_id ORDER BY price1.price_min_quantity ASC) AS b ON a.product_id=b.product_id LEFT JOIN xzs4r_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,2) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') AND ( ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' then b.price_value when b.price_currency_id IS NULL then 0 when b.price_currency_id = '2' then (b.price_value/1) end ) >= 1 ) AND ( case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' then b.price_value when b.price_currency_id IS NULL then 0 when b.price_currency_id = '2' then (b.price_value/1) end ) BETWEEN 0 AND 0 ORDER BY b.product_created DESC

I have taken the new file , replaced and it works for me.
Now I see that when I search, for example with no filter filled, it returns nothing. Or it should return all ? as no filter is set
for example :
- dropdown (version) - no value set, I leave the default text which is the filter name
- text, idem dropdown
- price :I set from 0 to 0 to have all items from all versions that are free.

This does not work. Am I missing or misunderstanding someting ?
CEd

I have checked and the module option is set to my menu item "105" with force redirect
My item 105 is the main link item to "products listing"
Then I have tried to filter from 0 to 0 euros, >> no result. Then I delete the price filter and click on filter again and there is no more items to show.

themes(point)joomlack.fr

let me know when you have checked so that I can delete this url as it is a temporary website

Test procedure :
1/ select compatibility joomla3
>> 2 results, 1 free+1 paid

2/ set the price to 0-0
>> no result (should have 1)

3/ reset the price an compatibility (in the dropdown click on the word "compatibility")
>> no result (should return all)

I have enabled the debug mode so you can check and find what you need

Regarding the 3rd test case, that's something which should be fixed in next version and here is the thread about it:
www.hikashop.com/support/forum/filters-s...iltering.html#174257