I have 4 Lic. 2 registered /2 not registered - 1 with a transaction ID 3 without.... showing 50% reward...
I guess the query needs to be updated to included unregistered and null transaction id ?

Not that I need more of them or anything :)