sorting related table error duplicate join

[aviqbaihaqy]

in request orderBy=sias_peserta_didik:peserta_didik_id|sias_peserta_didik.nisn&sortedBy=asc i get error:

code: "42000" exception: "Illuminate\Database\QueryException" file: "D:\WWW\sias\vendor\laravel\framework\src\Illuminate\Database\Connection.php" line: 664 message: "SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'sias_peserta_didik' (SQL: select count(*) as aggregate from sias_peserta_didik_rombelleft joinsias_peserta_didikonsias_peserta_didik_rombel.peserta_didik_id=sias_peserta_didik.idleft joinsias_peserta_didikonsias_peserta_didik_rombel.peserta_didik_id=sias_peserta_didik.id)" status: "error" status_code: 500

the duplicate join: select count(*) as aggregate from sias_peserta_didik_rombelleft joinsias_peserta_didikonsias_peserta_didik_rombel.peserta_didik_id=sias_peserta_didik.idleft joinsias_peserta_didikonsias_peserta_didik_rombel.peserta_didik_id=sias_peserta_didik.id`

[cesasol]

I can confirm that this happens when the relation to order by has a pivot table like many to many and polymorphic many to many

[coalman1]

Any updates on this or alternate way to implement the same