select * from qcf_dispInteractionProducts order by qcf_dispInteractionProducts.itemType desc, qcf_dispInteractionProducts.sku select * from tbl_CRM_InteractionLinkedAssets ila with (nolock) where ila.ownerId = and ila.ownerType = and ila.interactionId = and ila.linkid = and ila.linkType = and ila.assetid = and ila.assetType = select * from tbl_CRM_InteractionLinkedAssets ila with (nolock) where ila.ownerId = and ila.ownerType = and ila.interactionId = and ila.linkid = and ila.linkType = and ila.assetid = and ila.assetType =