title: SQL Execution failed: Error Binding parameter 0 - probably unsupported type
body: <p>I've tried some solutions from different questions, but still getting this error:</p>
  <pre><code>pandas.io.sql.DatabaseError: Execution failed on sql 'SELECT REAL_ESTATE.UNIQUE_RE_NUMBER, MAX(PRICE.UPDATE_DATE) AS MAX_DATE, PRICE.RE_PRICE FROM REAL_ESTATE INNER JOIN PRICE WHERE UNIQUE_RE_NUMBER = (?)': Error binding parameter 0 - probably unsupported type.
  </code></pre>
  <p>My code looks like this:</p>
  <pre><code>    IDs = []
      i = 0
      items = Saved.query.filter_by(userID=current_user.id).order_by(Saved.id)
      conn = sqlite3.connect('REDB.db')
      for item in items:
          realityID = conn.execute('SELECT UNIQUE_RE_NUMBER FROM REAL_ESTATE WHERE UNIQUE_RE_NUMBER = ?', (item.unqNum,)).fetchone()
          IDs.append(realityID[0])
          i = i + 1
      print(IDs)
      more_info = pd.read_sql_query('SELECT REAL_ESTATE.UNIQUE_RE_NUMBER, MAX(PRICE.UPDATE_DATE) AS MAX_DATE, PRICE.RE_PRICE FROM REAL_ESTATE INNER JOIN PRICE WHERE UNIQUE_RE_NUMBER = (?)', conn, params=(IDs,))
      conn.close()
      print(more_info)
      return render_template(&quot;saved.html&quot;, items=items, more_info=more_info)
  </code></pre>
  <p>From items I am getting unique number of real estate. These numbers then want to use to find in my database, where I update prices of real estate daily.</p>
  <p>Hopefully you can understand my problem, can anybody help?</p>