Added a few new products and all of a sudden every 10-15 minutes database errors after running error free for months?
Error: Not unique table/alias: ‘cscart_product_prices’ (1066)
Query: SELECT cscart_product_features_values.feature_id, COUNT(DISTINCT cscart_products.product_id) as products, cscart_product_features_values.variant_id as range_id, cscart_product_feature_variant_descriptions.variant as range_name, cscart_product_features.feature_type, cscart_product_filters.filter_id FROM cscart_product_features_values LEFT JOIN cscart_products ON cscart_products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filters ON cscart_product_filters.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_feature_variants ON cscart_product_feature_variants.variant_id = cscart_product_features_values.variant_id LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variant_descriptions.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_feature_variant_descriptions.lang_code = ‘EN’ LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_filters.feature_id LEFT JOIN cscart_product_features_values as d_0 ON d_0.product_id = cscart_products.product_id LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = ‘1’ LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = ‘1’ INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id LEFT JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id WHERE cscart_product_features_values.feature_id IN (5, 2) AND cscart_product_features_values.lang_code = ‘EN’ AND cscart_product_features_values.variant_id AND d_0.variant_id = 97 AND cscart_product_prices.price >= 20 AND cscart_product_prices.price <= 50 AND cscart_categories.membership_id IN (0, 0) AND cscart_categories.status IN (‘A’, ‘H’) AND cscart_products.status IN (‘A’, ‘H’) AND cscart_product_features.feature_type IN (‘S’, ‘M’, ‘E’) GROUP BY cscart_product_features_values.variant_id ORDER BY cscart_product_feature_variants.position, cscart_product_feature_variant_descriptions.variant