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'"); |
} |