おさ自分だったらselect uri,count(*) as cnt from statuses group by uri order by cnt desc limit 10あたりを叩いて、まず手作業で対応できる範囲かどうか見極めるかな。
senooken JP Socialはsenookenの専用分散SNSです。
senooken JP Social is a social network, courtesy of senooken. It runs on GNU social, version 2.0.2-beta0, available under the GNU Affero General Public License.
All senooken JP Social content and data are available under the Creative Commons Attribution 3.0 license.