| 197,7 → 197,16 |
|---|
| query.append(" from Pages p"); |
| query.append(" join Users creator on p.created_by = creator.id"); |
| query.append(" left join Users modifier on p.modified_by = modifier.id"); |
| query.append(" where p.deleted = 'F'"); |
| query.append(" where p.deleted = 'F' and p.language_id in ("); |
| |
| List<Language> langs = Language.all(); |
| int count = 0; |
| for(Language lang : langs) { |
| if (count++ > 0) query.append(","); |
| query.append(lang.getId()); |
| } |
| query.append(")"); |
| |
| if (!includeSystemPages) { |
| query.append(" and p.system_page = 'F'"); |
| } |