select osa.data,osa.fieldid ,(SELECT FIELD_DISPLAYNAME FROM sd_additionalparams where FIELDID = osa.fieldid ) as displayname from sd_servicereq_additionalparams osa where osa.problemid = 787000 and osa.instanceid = 0 and osa.fieldid = (select if(count(distinct(sd.AccessID)) = count(distinct(u.accessid)),sd.FieldID,0) from sd_additionalparams_access_details sd,usermgmt_details u where sd.accessid <> 0 and FieldID = osa.fieldid ) |
14
|
15
|
1
|
|
0.00
|