@ars42525 こんな感じ。

select domain from statuses join accounts on accounts.id = statuses.account_id where quote_id is not null group by domain;
domain
---------------
biwakodon.com
comm.cx
fedibird.com
nitiasa.com
odakyu.app
seichi.work
wakakyu.tk

(8 rows)