kid no auto_increment but refered to for blacklists
as I remember, historically VMS used some TAN in combination with the advertising format to identify a specific ad. This version however does support a "kid" field which stays 0 when adding banner using adminforce.
- Check wether it is used by some cron e.g. pulling ads from external sources
- Create/Modify/Use an unique index either of auto_increment numbers or tan+ad format
Before that, some joins on blacklist table are useless because they only check kid which as stated is always 0 so far.