Deleted Characters Being Reviewed

They actually don't have a creation date in the character database unless they've added one.
Just the logout date.

Not sure how they're doing the UA link either but I doubt it's in the character table, more likely a separate table like spouses.
Banning of course isn't in the character DB at all, that's done in the account DB.

LOL, the fact that there's no creation date unless they've created one is fail within itself (not like I know the exact columns/table names which are there anyway). Even without the line of code relating to the creation date, that algorithm would work based on the fact that characters with unreleased hair/face ids are released. Same thing with character type id. Revised:

UPDATE character_table
SET end_date = today, main_account_perm_banned = YES
WHERE (hair_id IN (list of hair ids not yet available) OR face_id IN (list of face ids not yet available))

^still works and is full-proof.

As for hacked UA chars without the new hair/face, there's gotta be other simple ways.