Bug Report: SQLite Error in Notes Query

[hpnightowl]

What happened?

SQLite query error occurs when attempting to count notes, specifically with the IN clause parameter binding.

Steps to reproduce the problem

• Open NotesNook Desktop
• Attempt to view/filter notes (specific action that triggers the count query)
• Observe SQLite error in console

Version

3.0.23-123705f-desktop

Platform/OS

Windows

Relevant log output

SqliteError: near "?": syntax error (query: select count("id") as "count" from "notes" where ("dateDeleted" is null or "dateDeleted" == 0) and ("deleted" is null or "deleted" == 0) and "id" in ?)
SqliteError: near "?": syntax error (query: select count("id") as "count" from "notes" where ("dateDeleted" is null or "dateDeleted" == 0) and ("deleted" is null or "deleted" == 0) and "id" in ?)
    at Database.prepare (C:\Users\hpal\AppData\Local\Programs\@notesnookdesktop\resources\app\node_modules\better-sqlite3-multiple-ciphers\lib\methods\wrappers.js:5:21)
    at z.<anonymous> (https://app.notesnook.com/assets/sqlite.worker.desktop-CP9v2gK6.js:1:884)
    at Generator.next (<anonymous>)
    at https://app.notesnook.com/assets/sqlite.worker.desktop-CP9v2gK6.js:1:298
    at new Promise (<anonymous>)
    at g (https://app.notesnook.com/assets/sqlite.worker.desktop-CP9v2gK6.js:1:95)
    at z.prepare (https://app.notesnook.com/assets/sqlite.worker.desktop-CP9v2gK6.js:1:701)
    at z.<anonymous> (https://app.notesnook.com/assets/sqlite.worker.desktop-CP9v2gK6.js:1:1312)
    at Generator.next (<anonymous>)
    at https://app.notesnook.com/assets/sqlite.worker.desktop-CP9v2gK6.js:1:298