public function load_categories_for_infotype($infotype_id, $lang = 'lat') {
    //TODO filter by $infotype_id in information table
    $query = DB::select();
    $query = $query->where('infocategories.language_id', '=', $lang);
    $query = $query->order_by('ordernumber');
    $query = $query->join(array('information', 't'), 'left')->on('infotype_id', '=', 't.id');

    return Sprig::factory('infocategory')->load($query, false);
  }

// pseudo code
  public function load_categories_for_infotype($infotype_id, $lang = 'lat') {
    //TODO filter by $infotype_id in information table
    $query = DB::select();
    $query = $query->join(array('type_categories', 't'), 'left')->on('infocategory.id', '=', 't.infocategory_id');
    $query = $query->join(array('infotypes', 'it'), 'left')->on('it.id', '=', 't.infotype_id');
    $query = $query->where('infocategories.language_id', '=', $lang);
    $query = $query->where('it.language_id', '=', $lang);
    $query = $query->order_by('ordernumber');


    return Sprig::factory('infocategory')->load($query, false);
  }