Серверная часть

Метод Статус
Список упражнений
Работает
Список Клиентов
Работает
Список продуктов
Не работает
503|Ошибка при выполнении запроса в БД|constructor|products_list2|getFilteredProductsList_2_2 Error SQL " SELECT v2_products.id as item_id, v2_products.expert_id, v2_products.org_id, v2_products.categ, v2_products.caption, v2_products.caption_alias, v2_products.proteins_in_gr, v2_products.fats_in_gr, v2_products.carbs_in_gr, v2_products.cellulose_in_gr, v2_products.kkal, v2_products.img, v2_products.picture, v2_products.picture_orig, v2_products.picture_local, v2_products.timestamp as date_add, v2_products.calc_used, v2_products.calc_vit_fullness, (SELECT GROUP_CONCAT( `season_id`) FROM v2_products_seasonality WHERE `product_id`= item_id) as seasonality FROM v2_products WHERE v2_products.is_deleted=0 AND v2_products.org_id IN (44,5) ORDER BY calcOrder ASC LIMIT -25,25"; error="You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-25,25' at line 25" [#1064]
Список блюд
Не работает
503|Ошибка при выполнении запроса в БД|constructor|dishes_list2|getFilteredDishesList_2_2 Error SQL " SELECT v2_dishes.id as item_id, v2_dishes.expert_id, v2_dishes.caption, v2_dishes.org_id, v2_dishes.categ, v2_dishes.recipe, v2_dishes.proteins_on_100, v2_dishes.fats_on_100, v2_dishes.carbs_on_100, v2_dishes.cellulose_on_100, v2_dishes.kkal_on_100, v2_dishes.img, v2_dishes.picture, v2_dishes.picture_orig, v2_dishes.picture_local, v2_dishes.prepare_time, v2_dishes.calc_used, v2_dishes.timestamp as date_add, ( SELECT GROUP_CONCAT(v2_dishes_destinations.id SEPARATOR '|') FROM v2_dishes_TO_destinations LEFT JOIN v2_dishes_destinations ON (v2_dishes_destinations.id=v2_dishes_TO_destinations.destination_id) WHERE v2_dishes_TO_destinations.dish_id=item_id ) AS destination, (SELECT GROUP_CONCAT(v2_dishes_dietaries.id SEPARATOR '|') FROM v2_dishes_TO_dietaries RIGHT JOIN v2_dishes_dietaries ON (v2_dishes_dietaries.id=v2_dishes_TO_dietaries.dietary_id) WHERE v2_dishes_TO_dietaries.dish_id=item_id) AS dietary, (SELECT GROUP_CONCAT(v2_dishes_prepare_methods.id SEPARATOR '|') FROM v2_dishes_TO_prepare_methods RIGHT JOIN v2_dishes_prepare_methods ON (v2_dishes_prepare_methods.id=v2_dishes_TO_prepare_methods.prepare_method_id) WHERE v2_dishes_TO_prepare_methods.dish_id=item_id) AS prepare_method FROM v2_dishes WHERE v2_dishes.is_deleted=0 AND v2_dishes.org_id IN (44,5) ORDER BY calcOrder ASC LIMIT -25,25"; error="You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-25,25' at line 43" [#1064]