Adding subquery to main query breaks paged bootstrap table

PHP
WAPPLER 4.9.1
WINDOWS 10
MariaDB
WAMP

I take a basic paged query, in this case invoices

image1017×745 39.4 KB

and generate a bootstrap 5 table using generator

image751×604 18.4 KB

and all works correctly

image1331×168 11.2 KB

I now add a sub query to the original query adding invoice items

image1530×830 55 KB

And the table breaks, no invoices are listed

image1405×220 6.27 KB

data is being returned correctly

image424×547 8.82 KB

No errors in console