Clearance

Database error: Invalid SQL: SELECT count(*) as num_rows FROM product WHERE product.product_parent_id='' AND product.product_publish='Y' AND product.product_clearance='Y' AND product_brand='d'Avenza' ORDER BY product_brand, product_name
MySQL Error: 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 'Avenza' ORDER BY product_brand, product_name' at line 1)