{
  "db_name": "PostgreSQL",
  "query": "SELECT\n                 survey_mcaptcha_campaign.campaign_id,\n                 survey_mcaptcha_upload_jobs.public_id,\n                 survey_mcaptcha_hostname.url\n              FROM\n                 survey_mcaptcha_campaign\n              INNER JOIN\n                  survey_mcaptcha_upload_jobs\n              ON\n                  survey_mcaptcha_upload_jobs.campaign_id = survey_mcaptcha_campaign.ID\n              INNER JOIN\n                  survey_mcaptcha_hostname\n              ON\n                  survey_mcaptcha_hostname.ID = survey_mcaptcha_campaign.url_id\n              WHERE\n                     survey_mcaptcha_upload_jobs.job_state = (\n                         SELECT ID FROM survey_mcaptcha_upload_job_states WHERE name = $1\n                     )\n             AND\n                 survey_mcaptcha_upload_jobs.finished_at is NULL\n             AND\n                 survey_mcaptcha_upload_jobs.scheduled_at is NULL\n             ORDER BY created_at ASC;",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "campaign_id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 1,
        "name": "public_id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 2,
        "name": "url",
        "type_info": "Varchar"
      }
    ],
    "parameters": {
      "Left": [
        "Text"
      ]
    },
    "nullable": [
      false,
      false,
      false
    ]
  },
  "hash": "d7a099c6f381fd02ad6a114b0146e4e52f7886f0164d05ccd3f1818a2a70cf67"
}
