Trying to develop a custom facet like search in Mysql.
I have 3 tables for this:
1.Attribute class 2.Attribute class Name 3.Attribute class Value - attributeClassName Id - productId 4.Products
Each product has one attribute class
Each attribute class has many values
Each value is contained in a sepparate row in the AttributeClassValue table, how can i Filter by values in that table ?
Group Concat is not the best solution....