如果order by 中含有 判断语句的话
如下:
order by p.classification_id is null asc , c.parent_id=1 desc , p.classification_id asc
jfinal分页的时候查询总数去掉order by 的正则
order\\s+by\\s+[^,\\s]+(\\s+asc|\\s+desc)?(\\s*,\\s*[^,\\s]+(\\s+asc|\\s+desc)?)*
只会去掉 order by p.classification_id ,并没有去掉全部的order by 导致报错
项目:JFinal