diff options
Diffstat (limited to 'src/lib/db/index.ts')
-rw-r--r-- | src/lib/db/index.ts | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/src/lib/db/index.ts b/src/lib/db/index.ts index fcfab57..6bd417c 100644 --- a/src/lib/db/index.ts +++ b/src/lib/db/index.ts @@ -92,10 +92,16 @@ class DatabaseHandler { const query = this.db.query( ` SELECT * FROM expressions e - WHERE e.syllables = 1 AND e.lang = ? + WHERE e.type = 'syllable' AND e.lang = ? ORDER BY frequency DESC LIMIT ${PAGE_SIZE} ${page ? "OFFSET " + getDBOffset(page, PAGE_SIZE) : ""} `, + // ` + // SELECT * FROM expressions e + // WHERE e.syllables = 1 AND e.lang = ? + // ORDER BY frequency DESC + // LIMIT ${PAGE_SIZE} ${page ? "OFFSET " + getDBOffset(page, PAGE_SIZE) : ""} + // `, ); const results = query.all(lang); console.log({ lang, page }, "results"); |