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;
`;