Friends layout top banner Friends layout top banner
Ошибка 500

К сожалению, возникла ошибка при открытии страницы.
Воспользуйтесь поиском или меню.

Exception: Syntax error, unexpected token INTEGER(202719), near to ' 202782 226050) , catalog__parent__parent.sort, catalog__parent.sort, product.sort_top desc, (product.new_until_date < now()), catalog.sort, product.sort', when parsing: SELECT product.*, storeProduct.*, productScore.*, warehouseCalc.*, catalog.*, catalog__parent.*, catalog__parent__parent.*, storeProduct__supplier.*, merchant.* FROM [App\Model\Product] AS [product] INNER JOIN [App\Model\StoreProduct] AS [storeProduct] ON storeProduct.product_id = product.id AND storeProduct.store_id = 1 LEFT JOIN [App\Model\ProductScore] AS [productScore] ON productScore.product_id = product.id AND productScore.city_id = 21 LEFT JOIN [App\Model\ProductMovementWarehouseLiveCalc] AS [warehouseCalc] ON warehouseCalc.product_id = product.id AND warehouseCalc.warehouse_id = 1 LEFT JOIN [App\Model\Supplier] AS [storeProduct__supplier] ON storeProduct__supplier.id = storeProduct.supplier_id LEFT JOIN [App\Model\Merchant] AS [merchant] ON merchant.id = product.merchant_id JOIN [App\Model\Catalog] AS [catalog] ON catalog.id = product.catalog_id JOIN [App\Model\Catalog] AS [catalog__parent] ON catalog__parent.id = catalog.parent_id JOIN [App\Model\Catalog] AS [catalog__parent__parent] ON catalog__parent__parent.id = catalog__parent.parent_id WHERE ((((((storeProduct.is_active = 1 AND catalog.is_active = 1 AND catalog__parent.is_active = 1 AND catalog__parent__parent.is_active = 1) AND ( ( (ifnull(warehouseCalc.quantity_sum, 0) - (storeProduct.reserved + IFNULL(storeProduct.min_quantity, 0))) > IF(product.is_weight = 1, product.weight_min, 0) ) and ( ( storeProduct.min_quantity is not null and ifnull(warehouseCalc.quantity_sum, 0) - storeProduct.reserved > storeProduct.min_quantity ) or storeProduct.min_quantity is null ))) AND (is_promotional = 0)) AND (product.is_stopped = 0 AND product.is_catalog_hidden = 0 AND (storeProduct.price_actual > 0 or product.is_promotional = 1))) AND (product.is_catalog_hidden = 0)) AND ((product.id in ({products:array}) OR product.catalog_id in ({catalogs0:array}) or catalog.parent_id in ({catalogs1:array}) or catalog__parent.parent_id in ({catalogs2:array})))) AND (is_promotional = 0) ORDER BY FIELD(product.id, 202718 202719 202782 226050) , catalog__parent__parent.sort, catalog__parent.sort, product.sort_top desc, (product.new_until_date < now()), catalog.sort, product.sort (2275)