Seliton демо магазин със Speedy Rest модул

Категории

Грешка

Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
Unknown column 'ProductPublicationTimestamp' in 'where clause' (SELECT COUNT(DISTINCT ProductID) AS Count FROM ((SELECT "scUserSearchProductsFinder" AS ResultFinder,SearchProducts.ProductID AS ResultID,SearchProducts.ProductID AS ProductID,ProductXCategories.ProductSortInCategory AS ProductIDSort FROM ProductVariants RIGHT JOIN Products AS SearchProducts USING(ProductID) INNER JOIN ProductXCategories ON (SearchProducts.ProductID = ProductXCategories.ProductID) INNER JOIN Categories ON ProductXCategories.CategoryID = Categories.CategoryID AND CategoryStatus = 1 WHERE ProductIsActive IN ("1","3","5") AND SearchProducts.ProductIsVariant="0" AND ProductPublicationTimestamp<="1711667500" AND ProductVariants.ProductVariantID IS NULL AND ProductXCategories.CategoryID IN(195) GROUP BY ProductID) UNION (SELECT "scUserSearchProductVariantsFinder" AS ResultFinder,(CASE WHEN (SELECT ProductVariantID FROM ProductVariants WHERE ProductVariantCode = "" AND ProductVariantCode <> "") IS NULL THEN GROUP_CONCAT(DISTINCT ProductVariants.ProductVariantID ORDER BY ProductVariantIsDefault DESC) ELSE (SELECT DISTINCT ProductVariantID FROM ProductVariants WHERE ProductVariantCode = "" AND ProductVariantCode <> "") END ) AS ResultID,ProductVariants.ProductID AS ProductID,ProductXCategories.ProductSortInCategory AS ProductIDSort FROM ProductVariants INNER JOIN Products AS SearchProducts USING(ProductID) INNER JOIN ProductXCategories ON (SearchProducts.ProductID = ProductXCategories.ProductID) INNER JOIN Categories ON ProductXCategories.CategoryID = Categories.CategoryID AND CategoryStatus = 1 WHERE ProductIsActive IN ("1","3","5") AND ProductPublicationTimestamp<="1711667500" AND ProductXCategories.CategoryID IN(195) GROUP BY ProductID)) AS Products)

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