nostr:npub1zpfznv550fdlpmhx930h0jftuxc5g0flx93h7zxsd3r5688jzqks7vgzxv 


select id from channel_favorite GROUP BY id HAVING COUNT(id) > 1;
 id
----
(0 rows)
こういうことではなく...?
他にもいろいろ調べてみる