for some strange reason i think i'm getting close... nothing was working at all but now i create attributes (that i was not using before at all) and it seems that i have product showing while making a search...except 2 issues...
- in Fact all products appears, so the filter does not work.,.it does not filter at all..
- while make a sorting by attributes this is what is have :
1146 Table 'eq74179.zs_products_attributes' doesn't exist
[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 ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE ( pa.options_id = 1 AND pa.options_values_id = 3 )))) AND p.products_id = pa.products_id AND p.products_quantity > 0 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id) ]