Duplicate View results when sorting by weight_in_tid (D8)

I solved this by using the "Content with term" relationship and then patching core with #2674832-3: "Content with term" views relationship not working due to wrong base table.

Any progress in this? I am pretty much stuck. My view is easy but adding nodeorder sort filter just triples all the results. When I use aggregation I am able to reduce the number of duplicates or completelly eliminate them, but they are not ordered right as they should be. I kind of do not understand why nodeorder module does not take any arguments. Maybe adding token / relationship to noderorder would solve this problem?

There is no other workaround currently as follows. Write your custom module and in .module file add:

use Drupal\views\ViewExecutable;
use Drupal\views\Plugin\views\query\QueryPluginBase;

function YOUR_MODULE_views_query_alter(ViewExecutable $view, QueryPluginBase $query) {
	
  if ($view->id() == 'VIEW_NAME') {
	  $query->addWhereExpression(0,'taxonomy_index.tid = node__field_druh_materialu.field_druh_materialu_target_id');
  }
  
}

You need to replace node__field_druh_materialu.field_druh_materialu_target_id with a field used in node to reference a taxonomy. So for example im my case the field was "field_druh_materialu" which is a taxonomy reference field added to node content type.