select top 1000 * from [zero-k_test].[dbo].[Avatars] where NOT AvatarName IN (select Replacement from [zero-k].[dbo].[UnitInternalRenames]);


AvatarName
--------------
armadvcom
armcarry
armcom
armpt
armraz
armroy
armtboat
commadvrecon
commadvsupport
commbattle1_1
commbattle2_1
commrecon
commrecon1_1
commrecon2_1
commstrike1_1
commstrike2_1
commsupport
commsupport1_1
commsupport2_1
coradvcom
corape
corarch
corbats
corcom
corcrus
corcs
coresupp
cormine1
cormort
cornukesub
corpre
corroy
corsub
corsy
cortl
corvrad
dclship
empmissile
factorycloak
factorygunship
factoryhover
factoryjump
factoryplane
factoryshield
factoryspider
factorytank
factoryveh
fakeunit
gorg
hoveraa
hoverassault
hoverriot
chicken
chicken_blimpy
chicken_digger
chicken_digger_b
chicken_dodo
chicken_dragon
chicken_drone
chicken_drone_starter
chicken_leaper
chicken_listener
chicken_listener_b
chicken_pigeon
chicken_shield
chicken_spidermonkey
chicken_sporeshooter
chicken_tiamat
chickena
chickenblobber
chickenbroodqueen
chickenc
chickend
chickenf
chickenlandqueen
chickenq
chickenqueenlite2
chickenr
chickens
chickenspire
chickenwurm
levelterra
logareamine
mahlazer
napalmmissile
nest
punisher
railgunturret
raveparty
roost
roostfac
seismic
serpent
shieldarty
spideraa
spiderassault
tacnuke
terraunit
thicket
wolverine_mine