| query | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
|||||||||||||||||||||||||
| CACHED | false | |||||||||||||||||||||||||
| EXECUTIONTIME | 32 | |||||||||||||||||||||||||
| SQL | SELECT cats.attrID, cats.attrDescription AS CategoryName, cats.lockFlag, link.mstr_attrID AS sectnid FROM tbl_ORG_Attributes cats, tbl_ORG_AttributeLinks link WHERE cats.OwnerID = 67 AND cats.FSL_TableCode = 'MSC' AND cats.attrTypeID = ? AND cats.attrID = link.child_attrID AND link.child_attrTypeID = ? AND link.mstr_attrTypeID = ? AND link.child_attrId in ( 17624,17625,17626 ) ORDER BY cats.attrDescription | |||||||||||||||||||||||||
| SQLPARAMETERS |
|
|||||||||||||||||||||||||