summaryrefslogtreecommitdiff
path: root/src/lib/db/index.ts
diff options
context:
space:
mode:
Diffstat (limited to 'src/lib/db/index.ts')
-rw-r--r--src/lib/db/index.ts8
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");