ええっ…🤔

SELECT encode(event_pubkey::bytea, 'hex'), COUNT(*) AS event_count FROM events WHERE first_seen >= '2023-04-06 00:00:00' AND first_seen < '2023-04-07 00:00:00' AND event_kind = 1 GROUP BY event_pubkey ORDER BY event_count DESC;

のクエリ結果の1番上に

43658ae91382bee7dfa3c7c360b13a5ec8c222635f2b2aad3de75e4bb20da906 340

って表示されてるんだけどなあ…🤔