Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Version, tblAssets.Domain, tblAssetCustom.Location, tsysIPLocations.IPLocation, tblAssets.IPAddress, tsysAssetTypes.AssetTypename As Type, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblAssets.Lastseen, tsysAssetTypes.AssetTypeIcon10 As icon, Case When tblAssets.Version Like '1903%' Then '#d4f4be' Else '#ffadad' End As backgroundcolor From tblAssets Left Outer Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblAssets.IPAddress Is Not Null And tblAssets.IPAddress != '' And tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1 Order By tblAssets.Version, tblAssets.IPNumeric