Добре дошли в нашия магазин!

Категории

Грешка

Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
Unknown column 'ProductPublicationTimestamp' in 'where clause' (SELECT ResultFinder, ResultID, ProductID 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<="1711703536" AND ProductVariants.ProductVariantID IS NULL AND ProductXCategories.CategoryID="176" 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<="1711703536" AND ProductXCategories.CategoryID="176" GROUP BY ProductID)) AS Products GROUP BY ProductID ORDER BY ProductIDSort, ProductIDSort, ProductID DESC LIMIT 0, 24)

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