Need to extend my query
This current query works just fine.

**Current query:**

    SELECT a.title, a.askprice, a.picture, a.description, a.userid, a.id FROM 
    
    (SELECT aid FROM mm_ads_fields_values afv WHERE value = '2913' OR value = '3022' GROUP BY aid HAVING COUNT(*) = 2 ) af 
    
    JOIN mm_ads AS a ON (a.id = af.aid) WHERE a.category = 227 AND a.status = 1 ORDER BY askprice DESC LIMIT 0,20

Query generates all cars that are "BMW" AND "black". 

**Update:**

mm_ads: Table where ads are stored in 

mm_ads_fields_values: Table where options for ads are stored in.


Example: Car is ad and having one row in table mm_ads. Car has following options: brand, model, color,... So Car ad has more than one row in table mm_ads_fields_values.

**Update 2:**

2913 means "black" color option

3022 means "bmw" brand option

I need to add 3020 which means "gray" color option


**Question:**

What if I want to get cars that are "BMW" AND ("black" OR "gray") ? How would query look like?
Need to extend my query
===

This current query works just fine.

**Current query:**

    SELECT a.title, a.askprice, a.picture, a.description, a.userid, a.id FROM 
    
    (SELECT aid FROM mm_ads_fields_values afv WHERE value = '2913' OR value = '3022' GROUP BY aid HAVING COUNT(*) = 2 ) af 
    
    JOIN mm_ads AS a ON (a.id = af.aid) WHERE a.category = 227 AND a.status = 1 ORDER BY askprice DESC LIMIT 0,20

Query generates all cars that are "BMW" AND "black". 

**Update:**

mm_ads: Table where ads are stored in 

mm_ads_fields_values: Table where options for ads are stored in.


Example: Car is ad and having one row in table mm_ads. Car has following options: brand, model, color,... So Car ad has more than one row in table mm_ads_fields_values.

**Update 2:**

2913 means "black" color option

3022 means "bmw" brand option

I need to add 3020 which means "gray" color option


**Question:**

What if I want to get cars that are "BMW" AND ("black" OR "gray") ? How would query look like?