Меню
Профил
Език

Категории

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

Грешка

Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
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 = "Paco Rabanne Pure XS For Her Eau de Parfum") 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 = "Paco Rabanne Pure XS For Her Eau de Parfum") END ) AS ResultID,SearchProducts.ProductID AS ProductID,ProductXCategories.ProductSortInCategory AS ProductIDSort,(MATCH(ProductQuickSearchIndex.ProductName) AGAINST ("+Paco* +Rabanne* +Pure* +XS* +For* +Her* +Eau* +de* +Parfum*" 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<="1710817337" AND SearchProducts.ProductShowInCategory="1" AND MATCH(ProductQuickSearchIndex.ProductDetails) AGAINST ("+Paco* +Rabanne* +Pure* +XS* +For* +Her* +Eau* +de* +Parfum*" IN BOOLEAN MODE) AND 0+ProductPrice >= 0+"100" AND ProductXCategories.CategoryID IN(4) AND SearchProducts.ProductID IN (SELECT ProductID FROM ProductAttributeValues WHERE AttributeID = 35 AND (AttributeOptionID = "149")) GROUP BY ProductID) AS Products)