NEETzscheJust realized you can build top ten lists with SQL. Here's one for the top ten artists of all time:
pleroma=> SELECT COUNT(*) "count", data->>'artist' "artist" FROM objects WHERE data->>'type' = 'Audio' AND LENGTH(TRIM(COALESCE(data->>'artist', ''))) > 0 GROUP BY data->>'artist' ORDER BY COUNT(*) DESC LIMIT 10; count | artist -------+------------------ 469 | OT the Real 440 | James Kibbie 278 | Jedi Mind Tricks 247 | Vinnie Paz 240 | e00 220 | Rippingtons 209 | Aesop Rock 204 | 2023 193 | Taylor Swift 193 | Outerspace (10 rows)
GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.