Follow

クエγƒͺγ‘γ‚‡γ£γ¨ι‡γ‹γ£γŸγ‘γ©γ γ„γŸγ„ζ—₯本θͺžγ¨γ—γ¦ζ€œε‡Ίγ•γ‚Œγ¦γŸγ­γƒΌ

> SELECT language, count(1) FROM statuses WHERE local=true AND reblog_of_id IS NULL AND created_at > now() - interval '1 month' GROUP BY language ORDER by count DESC;
language | count
----------+-------
ja | 1994
en | 36
kk | 17
zh | 11
sn | 5
bg | 4
| 3
de | 2
fy | 1
la | 1
nl | 1
sm | 1
sr | 1
cy | 1
id | 1
| 1
(16 rows)

Time: 13706.576 ms (00:13.707)

Β· Web Β· 0 Β· 0 Β· 1
Sign in to participate in the conversation
zundon

Zundon is a single user instance as home of @zundan as well as a test bed for changes of the code.