Query(Importrange) in Google Sheets

I am attempting to use the abve formula and i want to return values based on the foolowing criteria

Col2 is Blank, Col6 is either 'private or 'Private' and Col7 is <>'Not Applicable'

I seem to get some of the results but not exact using this formula:

=query(IMPORTRANGE("TEST","TEST!a1:z3000"),"where Col7 <>'Not Applicable' and Col6='private' or Col6='Private'")

ANy advise appreciated

thanks
lee

are you able to post links for sample versions of the source and target files?