Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
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)