select [tbContainer].[containerId],[tbContainer].[name],[tbContainer].[containerTypeId]  ,[tbContainerType].[name] [containerTypeName]  ,[tbContainer].[parentContainerId],[tbContainer].[packProfileMasterId],[tbConParent].[name] [parentContainerName],[tbContainer].[isActive]  ,[tbContainer].[createdBy]  ,[tbContainer].[closedDateTime]  ,[tbContainer].[statusId] [containerStatusId],[tbStatus].[name] [containerStatus] , isnull([tbStockContainer].[stockContainerId] ,0) as [stockContainerId],[tbStock].[stockId],[tbStock].[name] AS [stockName] ,[tbStock].[aliasname] AS [stockAliasName] ,([tbStockQty].[initialQty] - isnull([tbStockQty].[currFailedQty],0)) AS [stockQty] ,[tbStock].[routerId],[tbOrder].[orderId] ,[tbOrder].[name] AS [orderName] ,[tbOrder].[lotOrSnBase],[tbOrder].[boardType],isnull([tbStock].[modelId], [tbOrder].[modelId]) as modelId,[tbModel].[name] as [modelName] ,[tbFamily].[familyId] ,[tbFamily].[name] as [familyName],[tbStock].[statusId],(select top 1 isnull([name], '') from [tbStatus] where [isActive]=1 and [statusId] = [tbStock].[statusId]) as [statusName],[tbStock].[currentOperationId] [operationId] ,[tbOperation].[name] AS [operationName] ,[tbStock].[isActive],1 as [level],isnull(max([tbTracking].trackingId),0) AS trackingId,isnull(max([tbTracking].loginIdIn),0) AS loginIdIn,isnull([tbSamplingMember].samplingMemberId,0) AS samplingMemberId,[tbOrder].[orderItemType],isnull([tbShipDetail].shipDetailId,0) AS shipDetailId,[tbStock].isShippedfrom [tbContainer] join [tbContainerType] on [tbContainerType].[containerTypeId] = [tbContainer].[containerTypeId]  join [tbStatus] on [tbStatus].[statusId] = [tbContainer].[statusId] left join [tbStockContainer] on [tbContainer].[containerId] = [tbStockContainer].[containerId]left join [tbShipDetail] on [tbContainer].[containerId] = [tbShipDetail].[containerId]left join [tbContainer] [tbConParent] on [tbContainer].[parentContainerId] = [tbConParent].[containerId]left join [tbStock] on [tbStock].[stockId] = [tbStockContainer].[stockId] left join [tbSamplingMember] on [tbSamplingMember].[stockId] = [tbStock].[stockId]left join [tbOperation] on [tbOperation].[operationId] = [tbStock].[currentOperationId]left join [tbStockQty] on [tbStockQty].[stockId] = [tbStock].[stockId]left join [tbOrder] on [tbStock].[orderId] = [tbOrder].[orderId]left join [tbModel] on isnull([tbStock].[modelId], [tbOrder].[modelId]) = [tbModel].[modelId]left join [tbFamily] on [tbFamily].[familyId] = [tbModel].[familyId] left join [tbTracking] on [tbTracking].stockId= [tbStock].[stockId]  and [tbTracking].[operationId] = @operationId where [tbContainer].isActive = 1 and [tbContainer].isDeleted = 0  and ( [tbContainer].[containerId] in (190) )   group by  [tbContainer].[containerId],[tbContainer].[name],[tbContainer].[containerTypeId]  ,[tbContainerType].[name]  ,[tbContainer].[parentContainerId],[tbContainer].[packProfileMasterId],[tbConParent].[name] ,[tbContainer].[isActive]  ,[tbContainer].[createdBy]  ,[tbContainer].[closedDateTime] ,[tbContainer].[statusId] ,[tbStatus].[name]  , [tbStockContainer].[stockContainerId],[tbStock].[stockId],[tbStock].[name],[tbStock].[aliasname] ,[tbStockQty].[initialQty],tbStockQty.currFailedQty,[tbStock].[routerId],[tbOrder].[orderId] ,[tbOrder].[name],[tbOrder].[lotOrSnBase],[tbOrder].[boardType],[tbStock].[modelId],[tbModel].[name] ,[tbFamily].[familyId] ,[tbFamily].[name],[tbStock].[statusId],[tbStock].[currentOperationId] ,[tbOperation].[name] ,[tbStock].[isActive],[tbSamplingMember].samplingMemberId,[tbOrder].[orderItemType],[tbShipDetail].shipDetailId,tbOrder.modelId,[tbStock].isShipped