{"timestamp":"2024-03-28T15:45:45.895+0000","status":500,"error":"Internal Server Error","message":"\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '-10,10' at line 11\n### The error may exist in file [/opt/kanfang-user-deprecated/webapps/ROOT/WEB-INF/classes/mapper/NewHouseTypeMapper.xml]\n### The error may involve com.kanFang.project.mapper.NewHouseTypeMapper.selectPageList-Inline\n### The error occurred while setting parameters\n### SQL: select id, house_type_name, house_room, house_hall, house_toilet, building_area, total_price, orientation, sale_type from new_house_type WHERE new_house_id = ? and house_room = ? and is_disable = '0' and is_del = '0' order by isnull(sort) || sort = '', sort * 1 asc, field(sale_type, '1', '3','4', '2', '5') asc limit ?,?\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '-10,10' at line 11\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '-10,10' at line 11","path":"/cm/3238-hx-1-0.html"}