| | |
| | | if (s.contains("LIMIT. orgid")) { |
| | | s = s.replace("LIMIT. orgid", "orgid"); |
| | | } |
| | | if (s.contains("limit. orgid")) { |
| | | s = s.replace("limit. orgid", "orgid"); |
| | | } |
| | | if (s.contains("ORDER BY. orgid")) { |
| | | s = s.replace("ORDER BY. orgid", "orgid"); |
| | | } |
| | | if (s.contains("order by. orgid")) { |
| | | s = s.replace("order by. orgid", "orgid"); |
| | | } |
| | | if (s.contains("ORDER. orgid")) { |
| | | s = s.replace("ORDER. orgid", "orgid"); |
| | | } |
| | | if (s.contains("order. orgid")) { |
| | | s = s.replace("order. orgid", "orgid"); |
| | | } |
| | | if (s.contains("GROUP BY. orgid")) { |
| | | s = s.replace("GROUP BY. orgid", "orgid"); |
| | | } |
| | | if (s.contains("group by. orgid")) { |
| | | s = s.replace("group by. orgid", "orgid"); |
| | | } |
| | | if (s.contains("GROUP. orgid")) { |
| | | s = s.replace("GROUP. orgid", "orgid"); |
| | | } |
| | | if (s.contains("group. orgid")) { |
| | | s = s.replace("group. orgid", "orgid"); |
| | | } |
| | | return s; |
| | | } else { |
| | | // 如果没有 WHERE,也没有 ORDER BY 或 LIMIT,直接加 WHERE |