The smart safe transaction table has two possible eventcode values DECL and VER

a VER transaction can relate to one or DECL transactions.

The verifyid column in a DECL transaction points to the VER transaction for that row, if any.

I was to select ALL DECL rows where the verifyid column is 0 or if it's not zero the postingdate in the related VER transaction is earlier than a given date

I get this far and go blank

select * from view_expandedsmartsafetrans where eventcode = 'DECL' and verifyid = 0