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