DB Server: mysqlprod.auburn.edu
Web Host Name : sysweb-10.auburn.edu
Web Host IP Address : 10.138.7.20
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 # 400
Query execution time: 7 miliseconds.