Array
(
[0] => Array
(
[empID] => 0855574
)
[1] => Array
(
[empID] => 0090499
)
[2] => Array
(
[empID] => 0897507
)
[3] => Array
(
[empID] => 0889406
)
[4] => Array
(
[empID] => 0864630
)
[5] => Array
(
[empID] => 0886910
)
[6] => Array
(
[empID] => 0861489
)
[7] => Array
(
[empID] => 0783873
)
[8] => Array
(
[empID] => 0858893
)
[9] => Array
(
[empID] => 0832199
)
[10] => Array
(
[empID] => 0091030
)
[11] => Array
(
[empID] => 0878140
)
[12] => Array
(
[empID] => 0845252
)
[13] => Array
(
[empID] => 0792822
)
[14] => Array
(
[empID] => 0786658
)
[15] => Array
(
[empID] => 0785177
)
[16] => Array
(
[empID] => 0786867
)
[17] => Array
(
[empID] => 0714782
)
[18] => Array
(
[empID] => 0090642
)
[19] => Array
(
[empID] => 0810271
)
[20] => Array
(
[empID] => 0090965
)
[21] => Array
(
[empID] => 0782126
)
[22] => Array
(
[empID] => 0827204
)
[23] => Array
(
[empID] => 0858881
)
[24] => Array
(
[empID] => 0861969
)
[25] => Array
(
[empID] => 0708239
)
[26] => Array
(
[empID] => 0828035
)
[27] => Array
(
[empID] => 0864403
)
[28] => Array
(
[empID] => 0873265
)
[29] => Array
(
[empID] => 0867658
)
[30] => Array
(
[empID] => 0830193
)
[31] => Array
(
[empID] => 0786862
)
[32] => Array
(
[empID] => 0841888
)
[33] => Array
(
[empID] => 0813503
)
[34] => Array
(
[empID] => 0865311
)
[35] => Array
(
[empID] => 0865391
)
[36] => Array
(
[empID] => 0826770
)
[37] => Array
(
[empID] => 0094200
)
[38] => Array
(
[empID] => 0510696
)
[39] => Array
(
[empID] => 0889533
)
[40] => Array
(
[empID] => 0889708
)
)
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