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

Категории

Грешка

Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
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<="1711645927" AND ProductVariants.ProductVariantID IS NULL AND SearchProducts.ProductID IN (SELECT ProductID FROM ProductAttributeValues INNER JOIN AttributeIntervals USING (AttributeID) WHERE ProductAttributeValues.AttributeID = 74 AND (CONCAT("", ProductAttributeValue) <> "" AND 0+ProductAttributeValue >= 0+"1800" AND 0+ProductAttributeValue <= 0+"2000")) AND ProductCreatedTimestamp>"1495645927" 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<="1711645927" AND SearchProducts.ProductID IN (SELECT ProductID FROM ProductAttributeValues INNER JOIN AttributeIntervals USING (AttributeID) WHERE ProductAttributeValues.AttributeID = 74 AND (CONCAT("", ProductAttributeValue) <> "" AND 0+ProductAttributeValue >= 0+"1800" AND 0+ProductAttributeValue <= 0+"2000")) AND ProductCreatedTimestamp>"1495645927" GROUP BY ProductID)) AS Products)

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