Сравни
0 Количка
Всички категории
  • Начало
  • Промоции
  • Lavazza Firma
  • Lavazza A Modo Mio
  • NESCAFE Dolce Gusto
  • BANGE
  • Контакти

Категории

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

Грешка

Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
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 IN(829) 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<="1711639451" 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 IN(829) GROUP BY ProductID) AS Products)