cancel
Showing results for 
Search instead for 
Did you mean: 

Raw SQL to list products with specific attribute value

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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