{
  "db_name": "SQLite",
  "query": "SELECT l.uri AS \"uri!\", l.cid AS \"cid!\", l.name AS \"name!\",\n                  l.description, l.purpose, l.created_at AS \"created_at!\",\n                  COUNT(li.subject_uri) AS \"item_count!: i64\"\n           FROM lists l\n           LEFT JOIN listitems li ON li.list_uri = l.uri\n           WHERE l.did = ?\n           GROUP BY l.uri, l.cid, l.name, l.description, l.purpose, l.created_at\n           ORDER BY l.created_at DESC, l.rkey DESC",
  "describe": {
    "columns": [
      {
        "name": "uri!",
        "ordinal": 0,
        "type_info": "Text",
        "origin": {
          "Table": {
            "table": "lists",
            "name": "uri"
          }
        }
      },
      {
        "name": "cid!",
        "ordinal": 1,
        "type_info": "Text",
        "origin": {
          "Table": {
            "table": "lists",
            "name": "cid"
          }
        }
      },
      {
        "name": "name!",
        "ordinal": 2,
        "type_info": "Text",
        "origin": {
          "Table": {
            "table": "lists",
            "name": "name"
          }
        }
      },
      {
        "name": "description",
        "ordinal": 3,
        "type_info": "Text",
        "origin": {
          "Table": {
            "table": "lists",
            "name": "description"
          }
        }
      },
      {
        "name": "purpose",
        "ordinal": 4,
        "type_info": "Text",
        "origin": {
          "Table": {
            "table": "lists",
            "name": "purpose"
          }
        }
      },
      {
        "name": "created_at!",
        "ordinal": 5,
        "type_info": "Integer",
        "origin": {
          "Table": {
            "table": "lists",
            "name": "created_at"
          }
        }
      },
      {
        "name": "item_count!: i64",
        "ordinal": 6,
        "type_info": "Integer",
        "origin": "Expression"
      }
    ],
    "parameters": {
      "Right": 1
    },
    "nullable": [
      false,
      false,
      false,
      true,
      true,
      false,
      false
    ]
  },
  "hash": "f9a966b813a57d70db9c813acf49adc705c42ff6fbea402c51fe9b8451492616"
}
