SQL Syntax error
Getting this error
Here:
Any idea what I may be doing wrong?
[ { message: 'syntax error at or near "SELECT"' } ], [ { 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;
`; 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?
