cancel
Showing results for 
Search instead for 
Did you mean: 

Raw SQL to list products with specific attribute value

Raw SQL to list products with specific attribute value

Hi,

I want to have a custom form on home page similar to makemytrip.com

For this need Raw SQL query which can result products with attribute values and category as criteria.

e.g. i want to list products which belong to category 'cars' and having attribute values 'volvo'  and '10000 to 20000'  for the attributes 'model' and 'price range' respectively.  please help. Thanks