84.dbout

select
d.name,
d.owner_address,
e.node, 
count(*) total,
count(distinct e.blockchain) bchains
from crypto_registry_events e, domains d
where 1=1
and e.node = d.node
and e.type = 'NewURI'
group by d.name, e.node, d.owner_address
having count(*) > 1
 order by total desc
limit 100;

Timing is on.
             name              |               owner_address                |                                node                                | total | bchains 
-------------------------------+--------------------------------------------+--------------------------------------------------------------------+-------+---------
 udtestdev-4711.crypto         | 0x39beb60bc4c1b8b0ebeedc515c7a56e7dfb3a5a9 | 0x1c3d76c5aee31c216a0403738a32ffdc3630e7449fc9c450be78316a2d817a2e |     2 |       2
 udtestdev-anamulhaque.888     | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x86bb018a74f3c34bfb465b5d1cac3249d0f796f1c0a0eb36b660691362bf67ed |     2 |       2
 udtestdev-anamulhaque.bitcoin | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0xcf834adb93fb38d63d07842e48b31e98d9569e480dc4a846c84a7be14f09b505 |     2 |       2
 udtestdev-anamulhaque.coin    | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x840f64c72314d7cd32eb282790561488f0a50a074fd63b22ea60cc0b4dce9d0c |     2 |       2
 udtestdev-anamulhaque.crypto  | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x58466107a20ff6ee309ad42beaaade0bd56954571a33177762e8a894967834f2 |     2 |       2
 udtestdev-anamulhaque.dao     | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0xb36a47330d2bc1ca09cd7bfb118384ca0b5e6c961d4886f69bef5b3f63a339f5 |     2 |       2
 udtestdev-anamulhaque.nft     | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0xba686e38eab2b638973804553c4b640e584aa94d43cc2a7f47575094906c2e7b |     2 |       2
 udtestdev-anamulhaque.wallet  | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x3485a7e5a184251f7d319529cf77dd7e6c11b7ecd263654e2d4aa1e61336e39f |     2 |       2
 udtestdev-anamulhaque.x       | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x1c46e07f1ba6cae30158a2ee611768e816fad6272117f63d9575051a69bac99e |     2 |       2
 udtestdev-devtestud.crypto    | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x8d3802cf52caa98fef08e14eac95a424b454cb402c30f436989feb69400de2b5 |     2 |       2
 udtestdev-devtestud.x         | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0xa95e18886f775f6de144d7ce07626ce76e49c3b939fceef1455c56d7bbb47d19 |     2 |       2
 udtestdev-hexaorzo.crypto     | 0x354b9bc5cefef910f507ab92bf1d37fc8b607033 | 0x4fb837d48bf9ba34bb7ea1feef6b9ac1433002015fcdfe224463fc0d5461a1ec |     2 |       2
 udtestdev-udtestdev.crypto    | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x00b0ab2a19d92c415a1f8c4a1da3fff2d5253a84cc4679b937e0a6f9fbe789b0 |     2 |       2
 udtestdev-udtestdev.x         | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x38f9db245e9f647e7551727085f5b3b44fa7fa20ce4c465239dbfe67277a26db |     2 |       2
 udtestdev-vedtsetdu.crypto    | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x3e2985327f419be82ebcb039c15c3ba0926097272edc2642798c77df6d3e5dd9 |     2 |       2
 udtestdev-vedtsetdu.x         | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0x9d2560aecd207c1656f7e236ff973fc590b6982931d19c5a1faa287f879c27c7 |     2 |       2
 udtestdev-x.x                 | 0xbd26b906b84de5bd4816808852595b0e079489ce | 0xf6f8e5bd9ba534db090384101a48f299d17283792fc87ee681497e44c3eb6b7c |     2 |       2
 uns-devtest-oivas7572.x       | 0xe0a3b8e9f7a9684dbe479413ee7d8693eeb65589 | 0x4be85e4521321367e838adc10ea608a695d8ee49f2386ece68939b7e4ef2d4ee |     2 |       2
(18 rows)

Time: 193.857 ms