gistfile1.txt

 DECLARE @p0 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p1 NVARCHAR(2) = 't1'
DECLARE @p2 UNIQUEIDENTIFIER = 'a343151a-03e8-4d79-9c59-3ccbab4fe73d'
DECLARE @p3 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p4 NVARCHAR(3) = 'ct0'
DECLARE @p5 UNIQUEIDENTIFIER = 'a343151a-03e8-4d79-9c59-3ccbab4fe73d'

SELECT [t1].[data_item_no],
       CASE
         WHEN [t1].[audit_bd_version] IS NULL THEN 0x0000000000000000
         ELSE [t1].[audit_bd_version]
       END                      AS [t1.audit_BD_Version],
       [t1].[audit_bd_deleted]  AS [t1.audit_BD_Deleted],
       [t1].[matched]           AS [t1.matched],
       [t1].[data_id]           AS [t1.data_ID],
       CASE
         WHEN [ct0].[audit_bd_version] IS NULL THEN 0x0000000000000000
         ELSE [ct0].[audit_bd_version]
       END                      AS [ct0.audit_BD_Version],
       [ct0].[audit_bd_deleted] AS [ct0.audit_BD_Deleted],
       [ct0].[matched]          AS [ct0.matched],
       [ct0].[data_id]          AS [ct0.data_ID]
FROM   (SELECT CASE
                 WHEN [t1_sub].matched = 'true' THEN [t1_sub].data_id
                 ELSE [t1_audit].[id]
               END                     AS [data_ID],
               CASE
                 WHEN [t1_sub].matched = 'true' THEN [t1_sub].data_item_no
                 ELSE [t1_audit].[item_no]
               END                     AS [data_item_no],
               [t1_audit].[bd_version] AS [audit_BD_Version],
               [t1_audit].[bd_deleted] AS [audit_BD_Deleted],
               'true'                  AS [matched]
        FROM   (SELECT [id]      AS [data_ID],
                       [item_no] AS [data_item_no],
                       'true'    AS [matched]
                FROM   [dbo].[imitmidx_sql]) AS [t1_sub]
               FULL OUTER JOIN (SELECT *
                                FROM   [dbo].[bd_audit_imitmidx_sql]) AS
                               [t1_audit]
                            ON ( [t1_sub].[data_id] = [t1_audit].[id] )) AS [t1]
       LEFT JOIN (SELECT CASE
                           WHEN [ct0_sub].matched = 'true' THEN
                           [ct0_sub].data_id
                           ELSE [ct0_audit].[id]
                         END                      AS [data_ID],
                         CASE
                           WHEN [ct0_sub].matched = 'true' THEN
                           [ct0_sub].data_item_no
                           ELSE [ct0_audit].[item_no]
                         END                      AS [data_item_no],
                         CASE
                           WHEN [ct0_sub].matched = 'true' THEN
                           [ct0_sub].data_loc
                           ELSE [ct0_audit].[loc]
                         END                      AS [data_loc],
                         [ct0_audit].[bd_version] AS [audit_BD_Version],
                         [ct0_audit].[bd_deleted] AS [audit_BD_Deleted],
                         'true'                   AS [matched]
                  FROM   (SELECT [id]      AS [data_ID],
                                 [item_no] AS [data_item_no],
                                 [loc]     AS [data_loc],
                                 'true'    AS [matched]
                          FROM   [dbo].[iminvloc_sql]) AS [ct0_sub]
                         FULL OUTER JOIN (SELECT *
                                          FROM   [dbo].[bd_audit_iminvloc_sql])
                                         AS
                                         [ct0_audit]
                                      ON ( [ct0_sub].[data_id] =
                                           [ct0_audit].[id] )) AS
              [ct0]
              ON ( [t1].[data_item_no] = [ct0].[data_item_no] )
       LEFT JOIN (SELECT *
                  FROM   [dbo].[bd_lastversion_imitmidx_sql]
                  WHERE  [group] = @p0
                         AND [tablealias] = @p1
                         AND [targetid] = @p2) AS [t1_last]
              ON ( [t1].[data_id] = [t1_last].[key_id] )
       LEFT JOIN (SELECT *
                  FROM   [dbo].[bd_lastversion_iminvloc_sql]
                  WHERE  [group] = @p3
                         AND [tablealias] = @p4
                         AND [targetid] = @p5) AS [ct0_last]
              ON ( [ct0].[data_id] = [ct0_last].[key_id] )
WHERE  ( ( [t1_last].[last] IS NULL
           AND [t1].[data_id] IS NOT NULL )
          OR ( t1.audit_bd_version > t1_last.last ) )
        OR ( ( [ct0_last].[last] IS NULL
               AND [ct0].[data_id] IS NOT NULL )
              OR ( ct0.audit_bd_version > ct0_last.last ) )
           AND ( [t1].[data_item_no] IN (SELECT DISTINCT item_no
                                         FROM   iminvloc_sql
                                         WHERE  item_no IN (
                                                '52745SOF', '37165HF',
                                                '23787EK-CRW'
                                                           )
                                                AND loc IN ( '368', '888' ))
                  OR [t1].[audit_bd_deleted] = 'true' )