Добре дошли в нашия магазин!
Категории

0

Начало Грешка

Грешка

Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
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)