Update:

I got around the issue by just doing a quick fix, just made 2 seperate scripts one to only be "Private" and one to exclude only "Private" in my where condition.

I'm Not to worried about the permanent fix to my problem as it was a once off so thats fine, but would like to know for future reference if that is possible to achieve what has been requested or seperate scripts is the only way to go.