Array
(
[0] => Array
(
[empID] => 0760054
)
[1] => Array
(
[empID] => 0417143
)
[2] => Array
(
[empID] => 0461472
)
[3] => Array
(
[empID] => 0801322
)
[4] => Array
(
[empID] => 0865033
)
[5] => Array
(
[empID] => 0875374
)
[6] => Array
(
[empID] => 0893456
)
[7] => Array
(
[empID] => 0853374
)
[8] => Array
(
[empID] => 0884570
)
[9] => Array
(
[empID] => 0793032
)
[10] => Array
(
[empID] => 0849738
)
[11] => Array
(
[empID] => 0262067
)
[12] => Array
(
[empID] => 0783593
)
[13] => Array
(
[empID] => 0883022
)
[14] => Array
(
[empID] => 0092842
)
[15] => Array
(
[empID] => 0888166
)
[16] => Array
(
[empID] => 0791803
)
[17] => Array
(
[empID] => 0092784
)
[18] => Array
(
[empID] => 0360922
)
[19] => Array
(
[empID] => 0815282
)
[20] => Array
(
[empID] => 0892628
)
[21] => Array
(
[empID] => 0885655
)
[22] => Array
(
[empID] => 0896272
)
[23] => Array
(
[empID] => 0888910
)
[24] => Array
(
[empID] => 0847272
)
[25] => Array
(
[empID] => 0181264
)
[26] => Array
(
[empID] => 0895454
)
[27] => Array
(
[empID] => 0885079
)
[28] => Array
(
[empID] => 0883193
)
[29] => Array
(
[empID] => 0889535
)
[30] => Array
(
[empID] => 0894208
)
[31] => Array
(
[empID] => 0889325
)
[32] => Array
(
[empID] => 0090525
)
[33] => Array
(
[empID] => 0854750
)
[34] => Array
(
[empID] => 0823534
)
[35] => Array
(
[empID] => 0564331
)
[36] => Array
(
[empID] => 0180580
)
[37] => Array
(
[empID] => 0884611
)
[38] => Array
(
[empID] => 0832264
)
[39] => Array
(
[empID] => 0461884
)
[40] => Array
(
[empID] => 0754879
)
[41] => Array
(
[empID] => 0895235
)
[42] => Array
(
[empID] => 0093344
)
[43] => Array
(
[empID] => 0880913
)
[44] => Array
(
[empID] => 0758356
)
[45] => Array
(
[empID] => 0873778
)
[46] => Array
(
[empID] => 0887476
)
[47] => Array
(
[empID] => 0664003
)
[48] => Array
(
[empID] => 0883034
)
[49] => Array
(
[empID] => 0093769
)
[50] => Array
(
[empID] => 0857768
)
[51] => Array
(
[empID] => 0887999
)
[52] => Array
(
[empID] => 0863536
)
[53] => Array
(
[empID] => 0886406
)
[54] => Array
(
[empID] => 0799572
)
[55] => Array
(
[empID] => 0176362
)
[56] => Array
(
[empID] => 0872665
)
[57] => Array
(
[empID] => 0896638
)
[58] => Array
(
[empID] => 0884984
)
[59] => Array
(
[empID] => 0091286
)
[60] => Array
(
[empID] => 0091436
)
[61] => Array
(
[empID] => 0561913
)
[62] => Array
(
[empID] => 0893057
)
[63] => Array
(
[empID] => 0865462
)
[64] => Array
(
[empID] => 0865156
)
[65] => Array
(
[empID] => 0176244
)
[66] => Array
(
[empID] => 0854777
)
[67] => Array
(
[empID] => 0793468
)
[68] => Array
(
[empID] => 0090546
)
[69] => Array
(
[empID] => 0899205
)
[70] => Array
(
[empID] => 0093027
)
[71] => Array
(
[empID] => 0515220
)
[72] => Array
(
[empID] => 0781595
)
[73] => Array
(
[empID] => 0757253
)
[74] => Array
(
[empID] => 0607930
)
[75] => Array
(
[empID] => 0820513
)
[76] => Array
(
[empID] => 0814360
)
[77] => Array
(
[empID] => 0801707
)
[78] => Array
(
[empID] => 0867309
)
[79] => Array
(
[empID] => 0364069
)
[80] => Array
(
[empID] => 0809768
)
[81] => Array
(
[empID] => 0803153
)
[82] => Array
(
[empID] => 0877705
)
[83] => Array
(
[empID] => 0862605
)
[84] => Array
(
[empID] => 0773026
)
[85] => Array
(
[empID] => 0767280
)
[86] => Array
(
[empID] => 0762459
)
[87] => Array
(
[empID] => 0411000
)
[88] => Array
(
[empID] => 0369248
)
[89] => Array
(
[empID] => 0094324
)
[90] => Array
(
[empID] => 0559526
)
[91] => Array
(
[empID] => 0825527
)
[92] => Array
(
[empID] => 0418292
)
[93] => Array
(
[empID] => 0865081
)
[94] => Array
(
[empID] => 0893946
)
[95] => Array
(
[empID] => 0659055
)
[96] => Array
(
[empID] => 0875484
)
[97] => Array
(
[empID] => 0831415
)
[98] => Array
(
[empID] => 0879980
)
[99] => Array
(
[empID] => 0513825
)
[100] => Array
(
[empID] => 0839914
)
[101] => Array
(
[empID] => 0770827
)
[102] => Array
(
[empID] => 0870104
)
[103] => Array
(
[empID] => 0883205
)
[104] => Array
(
[empID] => 0855134
)
[105] => Array
(
[empID] => 0883561
)
[106] => Array
(
[empID] => 0865785
)
)
SELECT DISTINCT id, userName, firstName, lastName, photo, title, officeNumber, officeBuild, email, empStatus, namePrefix, nameTitle, officeRoomNum, idkey, O_firstName, O_lastname, O_title, O_Phone, O_Location, O_Email FROM vw_directory_override WHERE id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND lastName != '' ORDER BY lastName ASC