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,NULL AS PhraseRelevance 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<="1711631520" AND ProductVariants.ProductVariantID IS NULL AND ProductVariants.ProductVariantID IN (SELECT ProductVariantOptions.ProductVariantID FROM ProductVariantOptions INNER JOIN Options ON ProductVariantOptions.OptionID = Options.OptionID WHERE OptionGroupID="12" AND ProductVariantOptions.OptionID="111") 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,NULL AS PhraseRelevance 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<="1711631520" AND ProductVariants.ProductVariantID IN (SELECT ProductVariantOptions.ProductVariantID FROM ProductVariantOptions INNER JOIN Options ON ProductVariantOptions.OptionID = Options.OptionID WHERE OptionGroupID="12" AND ProductVariantOptions.OptionID="111") GROUP BY ProductID)) AS Products)

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