If your DBMS cares a little bit and enforces the ONLY_FULL_GROUP_BY SQL mode, the query won't even execute for your safety. You might even have seen this error before:
ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP
BY clause and contains nonaggregated column 'fur_score' which
is not functionally dependent on columns in GROUP BY clause; this
is incompatible with sql_mode=only_full_group_by
Ret the Folf /
npub136…xkh6w
2025-04-16 21:18:41
in reply to nevent1q…4q3m
Author Public Key
npub136mqky5kqr4jxtvulh2dq8egal2408t3tf3rptq0ah0ydufsfx3qzxkh6wSeen on
wss://relay.mostr.pubPublished at
2025-04-16 21:18:41Event JSON
{
"id": "f45a0e4455b704d9101924eecac619f5497477d1dc8486cffd5a0eea9e5ad786",
"pubkey": "8eb60b129600eb232d9cfdd4d01f28efd5579d715a6230ac0fedde46f13049a2",
"created_at": 1744838321,
"kind": 1,
"tags": [
[
"e",
"972015a28188ffad4fc9c0215f681153a75a553f162424fd8ab7de51387b89e8",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://furry.engineer/users/ret/statuses/114349724242732832",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.mostr.pub"
]
],
"content": "If your DBMS cares a little bit and enforces the ONLY_FULL_GROUP_BY SQL mode, the query won't even execute for your safety. You might even have seen this error before:\n\nERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP\nBY clause and contains nonaggregated column 'fur_score' which\nis not functionally dependent on columns in GROUP BY clause; this\nis incompatible with sql_mode=only_full_group_by\n",
"sig": "0fe89b72d4f932e136fb2b634e1d849aca13fba0920096d49891d83748b44bf854e4baec57b8b87c1c0b7c1f10d28769920bd6e68508623807c7a97d4923e497"
}