DB Server: mysqlprod.auburn.edu

Web Host Name : sysweb-04.auburn.edu
Web Host IP Address : 10.138.7.14

SELECT e.iEntitlementID, u.sUsername, u.sPreferredName, u.sLastName, d.iBannerDivCode, d.sName AS divisionName, CONCAT(s.sName, ' (', c.sName, ')') AS softwareName, e.sVersion, e.sAuthCode, acc.sCode, act.sChargeCode, e.dtAssigned, e.fInitialPayment, e.iRights, cc.sFOP FROM entitlement e JOIN user u ON e.iUserID = u.iUserID JOIN division d ON u.iDivisionID = d.iDivisionID JOIN software s ON e.iSoftwareID = s.iSoftwareID JOIN company c ON s.iCompanyID = c.iCompanyID JOIN accountCode acc ON e.iAccountCodeID = acc.iAccountCodeID JOIN activityCode act ON e.iActivityCodeID = act.iActivityCodeID LEFT JOIN costCenter cc ON e.iCostCenterID = cc.iCostCenterID WHERE u.iDivisionID IN ( SELECT iDivisionID FROM deptAdmin WHERE iUserID = 1) AND e.bArchived = 0 AND e.iAccountCodeID != 3 ORDER BY u.sLastName, u.sPreferredName;

Total rows # 382

Query execution time: 7 miliseconds.