Zdravim, mam nasledujuce tabulky:
http://img824.imageshack.us/i/27501853.jpg/
Aktívne filtre získam:
Kód:
SELECT feature_value FROM products_features INNER JOIN features ON feature_id = features.id WHERE features.label = '...' AND product_id IN (SELECT product_id FROM products_features WHERE feature_value = '...')
Problém je v tomto:
Kód:
SELECT product_id FROM products_features WHERE feature_id = 1 AND feature_value IN ('value1','value2')
Ako mám vybrat riadky ktoré zodpovedajú viacerým filtrom??
Niečo v zmysle (toto nefunguje):
Kód:
SELECT product_id FROM products_features WHERE feature_id = 1 AND feature_id = 2 AND feature_value IN ('value1','value2')
Dik.
