Theo's Typesafe CultTTC
Theo's Typesafe Cult4y ago
7 replies
utdev

SQL Syntax error

Getting this error
  [ { message: 'syntax error at or near "SELECT"' } ],

Here:
    const query = `
      SELECT
          "geo"."city" city,
          "jt".title,
          "deputy"
      FROM
          "jobposition" "jp"
      LEFT JOIN "geo_location" "geo" ON "geo"."id" = "jp"."geoLocationId"
      LEFT JOIN "jp_jobtitles" "jp_jt" ON "jp_jt"."jobpositionId" = "jp".id
      LEFT JOIN "jobtitle" "jt" ON "jt".id = "jp_jt"."jobtitleId" AND "deputy" = false
      WHERE
          "jp"."geoLocationId" IS NOT NULL
          AND "jt"."title" IS NOT NULL
      GROUP BY
          city, jt.title, deputy
      ORDER BY
          title
      OFFSET $1
      LIMIT $2;
    `;

Any idea what I may be doing wrong?
Was this page helpful?