glorious new db

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");