{
  "db_name": "PostgreSQL",
  "query": "\n        SELECT DISTINCT m.id\n        FROM mods m\n        WHERE\n            EXISTS(\n                SELECT 1\n                FROM delphi_issue_details_with_statuses didws\n                INNER JOIN delphi_report_issues dri ON dri.id = didws.issue_id\n                WHERE\n                    didws.project_id = m.id\n                    AND didws.status = 'pending'\n                    -- see delphi.rs todo comment\n                    AND dri.issue_type != '__dummy'\n            )\n            AND NOT EXISTS(\n                SELECT 1\n                FROM delphi_issue_details_with_statuses didws\n                INNER JOIN delphi_report_issues dri ON dri.id = didws.issue_id\n                WHERE\n                    didws.project_id = m.id\n                    AND didws.status IN ('safe', 'unsafe')\n                    -- see delphi.rs todo comment\n                    AND dri.issue_type != '__dummy'\n            )\n        ",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "id",
        "type_info": "Int8"
      }
    ],
    "parameters": {
      "Left": []
    },
    "nullable": [
      false
    ]
  },
  "hash": "9b0edb6399bc5f38ee96677cb2539476ecf08549b914f96f0c23fbfbe3f17f2e"
}
