Google-sheets – filter or query an IMPORTRANGE in a single formula without importing the range multiple times or using a second worksheet

My experiments on this would suggest that there is a max limit on the number of items that you can import using importrange() which id not linked to the total number of cells in your Google Sheet.

This figure seems to be around 175,000 cells. I'm not sure if this is the offical max, but that's the most I have been able to import without getting a 'too large' error.

Ok, so I've figured it out somehow by adding an extra array {}. No idea why this is working, but hey...

=QUERY({
    ARRAYFORMULA({
            IMPORTRANGE("f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU","Sample!A1:A"),
            IMPORTRANGE("f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU","Sample!SB1:SB"),
            IMPORTRANGE("f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU","Sample!SA1:SA"),
            IMPORTRANGE("f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU","Sample!CY1:GP")
    })},
    "SELECT * WHERE Col2 <> 0 AND Col1 IS NOT NULL",1)