www.Drogeriq.com Смеси здраве и удоволствие!

Категории

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

Грешка

Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
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 ProductXCategories.CategoryID="419" GROUP BY ProductID) AS Products' at line 1 (SELECT COUNT(DISTINCT ProductID) AS Count FROM (SELECT "scUserSearchProductVariantsFinder" AS ResultFinder,COALESCE(GROUP_CONCAT(DISTINCT Products2.ProductID ORDER BY ProductVariantIsDefault DESC), SearchProducts.ProductID) AS ResultID,SearchProducts.ProductID AS ProductID,ProductXCategories.ProductSortInCategory AS ProductIDSort 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 WHERE SearchProducts.ProductIsActive IN ("1","3","5","6") AND SearchProducts.ProductPublicationTimestamp<="1711672283" AND SearchProducts.ProductShowInCategory="1" AND SearchProducts.ProductID IN (SELECT ProductID FROM Products WHERE ProductID IN (SELECT ProductID FROM Products LEFT JOIN ProductTaxClasses USING(ProductID) WHERE )) AND ProductXCategories.CategoryID="419" GROUP BY ProductID) AS Products)

Най-продавани