SELECT IFNULL((SELECT IF(ad1.AssetValue='No Service', 'No', 'Yes') AS attribute6 FROM Assetmaster am INNER JOIN AssetDetails ad ON ad.AssetID=am.AssetID INNER JOIN AssetDetails ad1 ON ad1.AssetID=am.AssetID WHERE am.Status=0 AND am.ItemTypeID=20005 AND ad.ItemDetailsID=121 AND ad1.ItemDetailsID=128 AND ad.AssetValue='462039' LIMIT 1),'No') AS attribute6 |
741
|
1,962
|
299
|
|
0.00
|