Открита грешка при изпълнение на вашата заявка. Ако грешката се повтори моля свържете се със собственика на магазина.
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Products.ResultFinder' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SELECT * FROM ((SELECT "scUserSearchProductsFinder" AS ResultFinder,SearchProducts.ProductID AS ResultID,SearchProducts.ProductID AS ProductID,SearchProducts.ProductSortInCategory AS ProductIDSort,ProductsML.ProductName,ProductPrice FROM ProductVariants RIGHT JOIN Products AS SearchProducts USING(ProductID) LEFT JOIN ProductsML ON SearchProducts.ProductID = ProductsML.ProductID AND ProductsML.LanguageID = 2 INNER JOIN Categories ON SearchProducts.CategoryID = Categories.CategoryID AND CategoryStatus = 1 WHERE ProductIsActive="1" AND SearchProducts.CategoryID="9") UNION (SELECT "scUserSearchAdditionalFinder" AS ResultFinder,SearchProducts.ProductID AS ResultID,SearchProducts.ProductID AS ProductID,ProductXCategories.ProductSortInCategory AS ProductIDSort,ProductsML.ProductName,ProductPrice FROM ProductVariants RIGHT JOIN Products AS SearchProducts USING(ProductID) LEFT JOIN ProductsML ON SearchProducts.ProductID = ProductsML.ProductID AND ProductsML.LanguageID = 2 INNER JOIN ProductXCategories ON (SearchProducts.ProductID = ProductXCategories.ProductID) INNER JOIN Categories ON ProductXCategories.CategoryID = Categories.CategoryID AND CategoryStatus = 1 WHERE ProductIsActive="1" AND ProductXCategories.CategoryID="9")) AS Products GROUP BY ProductID ORDER BY ProductIDSort LIMIT 0, 10)