zunda ? nはおまけ :green_dango:
> SELECT COUNT(1) AS BEER, (SELECT COUNT(1) FROM statuses WHERE account_id=1) AS total FROM statuses WHERE account_id=1 AND text LIKE '%ビール%'; beer | total
------+-------
130 | 18380
(1 row)
ビールはたったの0.7%。たいしたことないねー
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.