Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
Column 'ProductPrice' in where clause is ambiguous (SELECT COUNT(DISTINCT ProductID) AS Count FROM (SELECT "scUserSearchProductVariantsFinder" AS ResultFinder,(CASE
WHEN (SELECT PC.ProductID FROM Products as PC WHERE PC.ProductIsVariant = 1 AND PC.ProductCode = "Nokia 6 Dual Sim") IS NULL
THEN COALESCE(GROUP_CONCAT(DISTINCT Products2.ProductID ORDER BY ProductVariantIsDefault DESC), SearchProducts.ProductID)
ELSE (SELECT DISTINCT PCC.ProductID FROM Products PCC WHERE PCC.ProductIsVariant = 1 AND PCC.ProductCode = "Nokia 6 Dual Sim") END
) AS ResultID,SearchProducts.ProductID AS ProductID,SearchProducts.ProductCreatedTimestamp AS ProductCreatedTimestamp,(MATCH(ProductQuickSearchIndex.ProductName) AGAINST ("+Nokia* +6* +Dual* +Sim*" IN BOOLEAN MODE)*2000000000 - ProductQuickSearchIndex.ProductSort) AS PhraseRelevance FROM Products AS SearchProducts LEFT JOIN ProductVariants ON (ProductVariants.ProductID = SearchProducts.ProductID) LEFT JOIN Products AS Products2 ON (ProductVariants.ProductVariantID = Products2.ProductVariantID) INNER JOIN ProductXCategories ON (ProductXCategories.ProductID = IF(SearchProducts.ProductIsVariant, SearchProducts.ProductParentID, SearchProducts.ProductID)) INNER JOIN Categories ON ProductXCategories.CategoryID = Categories.CategoryID AND CategoryStatus = 1 INNER JOIN ProductQuickSearchIndex ON (SearchProducts.ProductID = ProductQuickSearchIndex.ProductID) WHERE SearchProducts.ProductIsActive IN ("1","3","5","6") AND SearchProducts.ProductPublicationTimestamp<="1711638819" AND SearchProducts.ProductShowInCategory="1" AND MATCH(ProductQuickSearchIndex.ProductDetails) AGAINST ("+Nokia* +6* +Dual* +Sim*" IN BOOLEAN MODE) AND 0+ProductPrice <= 0+"299" AND 0+ProductPrice >= 0+"299" GROUP BY ProductID) AS Products)