I'm trying to get this module to work - the sidebox displays fine with the attributes dropdowns listed but as soon as I try and filter by any of the attribute options I get this error on the page:

1054 Unknown column 'options_1' in 'where clause'
in:
[select count(distinct p.products_id) as total FROM products p, products_description pd, products_to_categories p2c, products_attributes pa, products_options po , products_options_values pov WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = options_1 AND p.products_status =1 AND p.products_quantity > 0 )]

I've Googled this and up to now I have only found a reference to SQL5 and the JOIN function - but this server is SQL4.x and this script doesn't use the JOIN function as far as I can see...?

Any ideas anyone?