@Mattias Uppström I'm not really sure what you are trying to do, but I'd suggest trying to build the query in an analytics workbook and then checking the SQL used by NetSuite

sorry for stupid question but how do I export it as suiteql / sql?

Run in debugger or browser console on a record page in edit mode

require(['N/query'], function(query) {
   const sql = query.load({ id: 'workBookId' }).query;
   console.log(sql);
});

thanks