Product Recommendations

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND amount > 0 ORDER BY season_id' at line 27]
SELECT ta_soil_test.test_id, ta_soil_test.customer_id, ta_test_types.test_type_id, ta_test_types.name test_type, ta_elements.element_id, ta_elements.name element_name, ta_seasons.season_id, ta_seasons.name season, ta_recommendations.recommendation_id, ta_product_groups.product_group_id, ta_product_groups.name product_group, ta_products.name product_name, ta_products.product_page_link product_link, ta_product_recommendations.amount FROM ta_soil_test LEFT JOIN ta_test_types ON ta_soil_test.test_type_id = ta_test_types.test_type_id LEFT JOIN ta_recommendations on ta_soil_test.test_id = ta_recommendations.test_id LEFT JOIN ta_product_groups on ta_recommendations.product_group_id = ta_product_groups.product_group_id LEFT JOIN ta_product_recommendations on ta_recommendations.recommendation_id = ta_product_recommendations.recommendation_id LEFT JOIN ta_product_group_products on ta_product_groups.product_group_id = ta_product_group_products.product_group_id AND ta_test_types.test_type_id = ta_product_group_products.test_type_id AND ta_product_recommendations.pgp_id = ta_product_group_products.pgp_id LEFT JOIN ta_elements ON ta_elements.element_id = ta_product_group_products.element_id LEFT JOIN ta_seasons on ta_seasons.season_id = ta_product_group_products.season_id LEFT JOIN ta_products on ta_products.product_id = ta_product_group_products.product_id WHERE ta_soil_test.test_id = AND amount > 0 ORDER BY season_id