An Error Was Encountered

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 prod_season_id = 3 and prod_available > 0 and prod_online = 1 limit 0, 16' at line 6

SELECT distinct ce_products.prod_id, prod_price, ce_products.prod_design, prod_colour, prod_fabric_code, prod_description, prod_available_desc FROM ce_products INNER JOIN ce_designs_link ON ce_designs_link.prod_id = ce_products.prod_id LEFT JOIN ce_brands ON ce_brands.brand_code = ce_products.prod_brand_code WHERE ce_brands.trade_only != 1 AND and prod_season_id = 3 and prod_available > 0 and prod_online = 1 limit 0, 16