SQL Server：查询简化 - 许多连接和一个巨大的WHERE部分

I am trying to run a stored procedure, but it keeps timing out from using too much ram. The server its being run on only has 1.5GB of ram to work with. Here is the original query:I am trying to run a stored procedure, but it k