ATProto Browser

ATProto Browser

Experimental browser for the Atmosphere

Post

SQL queries for the most-frequently reported accounts, especially those with manual reports helps to prioritize. github.com/SteveTownsen... queries for the most-frequently reported accounts, especially those with manual reports helps to prioritize. github.com/SteveTownsen...

Apr 23, 2025, 2:44 PM

Record data

{
  "uri": "at://did:plc:uac6er53o2pvr5y2qmvaf7hw/app.bsky.feed.post/3lnigkxuhlk25",
  "cid": "bafyreigrcf36axkhbqs3nwirbpjq3vxusjeqbc5ophqxhq33r6qcmwqbhu",
  "value": {
    "text": "SQL queries for the most-frequently reported accounts, especially those with manual reports helps to prioritize.\ngithub.com/SteveTownsen... queries for the most-frequently reported accounts, especially those with manual reports helps to prioritize.\ngithub.com/SteveTownsen...",
    "$type": "app.bsky.feed.post",
    "embed": {
      "$type": "app.bsky.embed.external",
      "external": {
        "uri": "https://github.com/SteveTownsend/pef-moderation/wiki/Useful-SQL-Queries",
        "thumb": {
          "$type": "blob",
          "ref": {
            "$link": "bafkreigdami3jw2i3ruamzos5gzepklds2tuct2erwfohukpiuyqcenyxu"
          },
          "mimeType": "image/jpeg",
          "size": 218942
        },
        "title": "Useful SQL Queries",
        "description": "Public Education Forum Ozone moderation tools. Contribute to SteveTownsend/pef-moderation development by creating an account on GitHub."
      }
    },
    "langs": [
      "en"
    ],
    "reply": {
      "root": {
        "cid": "bafyreifoprt5gjinqee7zcjloswq3akoome26zul2edssvhnjrxx43zx3y",
        "uri": "at://did:plc:uac6er53o2pvr5y2qmvaf7hw/app.bsky.feed.post/3lnigkx2bp225"
      },
      "parent": {
        "cid": "bafyreicg55th7f2ikobm3nbreb7xct3tvuaqbeesvchjzbaefy3zmxveqq",
        "uri": "at://did:plc:uac6er53o2pvr5y2qmvaf7hw/app.bsky.feed.post/3lnigkxugmc25"
      }
    },
    "facets": [
      {
        "index": {
          "byteEnd": 139,
          "byteStart": 113
        },
        "features": [
          {
            "uri": "https://github.com/SteveTownsend/pef-moderation/wiki/Useful-SQL-QueriesSQL",
            "$type": "app.bsky.richtext.facet#link"
          }
        ]
      },
      {
        "index": {
          "byteEnd": 275,
          "byteStart": 249
        },
        "features": [
          {
            "uri": "https://github.com/SteveTownsend/pef-moderation/wiki/Useful-SQL-Queries",
            "$type": "app.bsky.richtext.facet#link"
          }
        ]
      }
    ],
    "createdAt": "2025-04-23T14:44:01.810Z"
  }
}