Matty-kun on Nostr: Looks like it's a little more than that. I'm sure there's a better way of doing this. ...
Looks like it's a little more than that. I'm sure there's a better way of doing this.
pleroma=# SELECT count(*) FROM objects WHERE split_part(data->>'actor', '/', 3) in ('nicecrew.digital') AND data->>'content' ILIKE '%nigger%' OR data->>'content' ILIKE '%niggers%';
count
--------
167273
(1 row)
Published at
2024-11-16 21:35:47Event JSON
{
"id": "86ce193a266b2b8b82cd0206f84c1080f3be07b55147ab808437d0c37adc38a9",
"pubkey": "8b347916be2cb3ab9687c9eb78a8d05224c045bce5b416bdd50169965eb0f45c",
"created_at": 1731792947,
"kind": 1,
"tags": [
[
"p",
"84762e242981fd353e166f0986e0b4060d852e204de65e58890a59a312b29fdc",
"wss://relay.mostr.pub"
],
[
"p",
"e9c3448952ee9b09ac0c9a13e32b32f20358814e3e4f4fa666064d00361f0eda",
"wss://relay.mostr.pub"
],
[
"e",
"e1f7f238c8bafac52413947480f13cf6fed76e5507051d993caa5028420324e1",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://nicecrew.digital/objects/16440cc0-dc16-47c7-844b-e56af38e7ae8",
"activitypub"
]
],
"content": "Looks like it's a little more than that. I'm sure there's a better way of doing this.\n\npleroma=# SELECT count(*) FROM objects WHERE split_part(data-\u003e\u003e'actor', '/', 3) in ('nicecrew.digital') AND data-\u003e\u003e'content' ILIKE '%nigger%' OR data-\u003e\u003e'content' ILIKE '%niggers%';\n\n count\n--------\n 167273\n(1 row)",
"sig": "cfc8ff84d768eac24db7b08d2f0fb8dc8d27f03e65be90ec958e69d857a8c9aea99c5f6aa643fed37dd80d43145a4d01fcac365954d6d0fa005b5dbf8cc45ffb"
}
