• Breaking up the query changed results. For example, the predicate

    nt on a.ArtworkId = nt.ArtworkId

    was not tested.

    And to be sure that T-SQL is what SSRS is running, it would be best to trace or collect an extended event.