select * from signature where path in (select path from apps where path like '%/Transmission.app' or path = '/Applications/Transmission.app') and cdhash = '37ffe70260919ee70e9f2a601d5ad00e2dd5a011';