oh, that's smart, i think i'll have it add the HP at time of scan to the db too, might make some of it a bit easier, select sum(vests) and a JOIN from authority where authority_granted = "steemauto" would do 90% of the work.
Yeah, alternatively, it could be an inner join on the extracted list after the fact. Lots of ways to do it, depends on what has the least computational load, much of a muchness at the end of the day, given the large amount of accounts.
The problem with my thoughts is they are often far too ambitious for my current skills, (or my hardware! - like my recent post about AI detection using a local llm) so I am constantly trying to expand said skills :D