)]}'
{
  "commit": "69b72d5a29c2e2db120376ebae702ee353fb9bfd",
  "tree": "fae0d18c408636e057538484a55d51337d2dcf4d",
  "parents": [
    "fcb9f4f3caa92fa042a988fa19d99ade66382287"
  ],
  "author": {
    "name": "drh",
    "email": "drh@noemail.net",
    "time": "Mon Jun 01 20:28:03 2015"
  },
  "committer": {
    "name": "drh",
    "email": "drh@noemail.net",
    "time": "Mon Jun 01 20:28:03 2015"
  },
  "message": "For FROM-clause subqueries that cannot be flattened, try to push WHERE clause\nterms of the outer query down into the subquery in order to help the subquery\nrun faster and/or use less memory.\n\nFossilOrigin-Name: 297fae7551a2af9e600d833801ff79fca0602ad5",
  "tree_diff": [
    {
      "type": "modify",
      "old_id": "879a00fb946a380d2843fc52f9d5b9d2269430e5",
      "old_mode": 33188,
      "old_path": "manifest",
      "new_id": "ca7b8564e1c3770f96240fdec1ed23532c1b84f8",
      "new_mode": 33188,
      "new_path": "manifest"
    },
    {
      "type": "modify",
      "old_id": "f27f0a326096ebb165e7f145d7c5bfb5daa64158",
      "old_mode": 33188,
      "old_path": "manifest.uuid",
      "new_id": "d83252b194bad63f9a82ca81ed95ac416f19133e",
      "new_mode": 33188,
      "new_path": "manifest.uuid"
    },
    {
      "type": "modify",
      "old_id": "e5e1a9988be716e1b6c09913d02a9fd0b2e2447d",
      "old_mode": 33188,
      "old_path": "src/select.c",
      "new_id": "0558c792818b87e279c255576e3591b1b38ab9b9",
      "new_mode": 33188,
      "new_path": "src/select.c"
    }
  ]
}