Seems it was fixed back in 2001, but it looks like it was only for PHP and the NodeJS still has the issue.
Sortable Headers - not working on joined COUNT - Wappler General / Bugs - Wappler Community
Here an update for NodeJS: dbconnector.zip (3.5 KB)
unzip to lib/modules.