{"timestamp":"2024-03-29T15:05:07.380+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 '-5,5' at line 21\n### The error may exist in file [/opt/kanfang-user/webapps/ROOT/WEB-INF/classes/mapper/SojournVideoMapper.xml]\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: select t.id, t.video_title, t.video_address, t.video_thumbnail, t.class_name, t.clicks, sv.city_abbreviation, sv.city_name, sv.create_time, ui.user_name as create_user, (select sdc.dictionary_name from sys_dictionary_code sdc where sdc.dictionary_type_code = 'sojourn_video-type' and sdc.is_del = '0' and sdc.dictionary_code = sv.type ) as type from sys_video t left join sojourn_video sv on sv.id = t.source_id left join user_information ui on ui.id = sv.create_user WHERE sv.type = ? and sv.city_abbreviation = ? and t.class_name = 'SojournVideo' and t.is_disable = '0' and t.is_del = '0' and sv.is_disable = '0' and sv.is_del = '0' order by isnull(t.sort) || t.sort = '', t.sort * 1 asc, t.create_time desc 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 '-5,5' at line 21\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 '-5,5' at line 21","path":"/v2/lj-wc-3-0.html"}