A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND AND prod.style LIKE 'Running' ORDER BY prod.brand ASC' at line 25

SELECT * FROM ( SELECT *, p.id as pid FROM products AS p LEFT JOIN ( SELECT * FROM fe_campaign_product_stack WHERE (product_id, campaign_product_set_id) IN ( SELECT product_id, MAX(campaign_product_set_id) FROM fe_campaign_product_stack GROUP BY product_id ) ) AS cps ON p.id=cps.product_id WHERE p.isactive LIKE 'Yes' ) AS prod, brands AS b WHERE b.manuf=prod.brand AND b.isactive='Yes' AND prod.gender LIKE '%' AND prod.brand LIKE '%' AND prod.price BETWEEN AND AND prod.style LIKE 'Running' ORDER BY prod.brand ASC

Filename: /home3/hanmade/public_html/shoeboxnh.com/models/nav_facets_model.php

Line Number: 208