select assetvalue,assetvalue FROM assetdetails where itemdetailsid=142 and (select if(data='raw card location',1,0) from sd_servicereq_additionalparams where problemid=786230 and fieldid=132 ) union select locationname,locationname from servicedesklocationmaster where locationname like '%n5%' and (select if(data='raw card location',0,1) from sd_servicereq_additionalparams where problemid=786230 and fieldid=132) limit 1 |
2
|
2
|
0
|
|
0.00
|