{% set language = language|default(current_language) %} {% set category = createModel('Category','category') %} {% if branch is not empty %} {% set category = category.where('branch','=',branch) %} {% endif %} {% set translations = category.join('category_translations','category.id','=','category_translations.category_id') %} {% set total = category.count() %} {% set total_translations = translations.where('language','=',language).count() %}