With the group+match optimisation in SERVER-73241, for some of the tests in sharded_lookup_execution.js having lookups with subpipeline containing non-correlated pipeline prefix, the subpipeline becomes correlated due to the match stages being optimised before the $group. Since this defeats the purpose of the original test of having non-correlated subpipeline prefix and caching the result, modify the query to make it non-correlated again.