SELECT
   JOB.ID,
   DISTINCT COMPANY_NAME,
   CITY,
   JOB.TITLE,
   HOURLY_RATE_AMOUNT,
   CREATED_AT,
   COUNT(WORK_INTENT.ID),
   NUMBER_OF_CONTRACTORS,
   (
      COUNT(WORK_INTENT.ID) / NUMBER_OF_CONTRACTORS
   )
   AS AANTAL_REACTIES,
   (
      3959 * ACOS(COS(RADIANS(51.54348510000000)) * COS( RADIANS(ADDRESS.LATITUDE)) * COS(RADIANS(LONGITUDE) - RADIANS(4.94570490000000)) + SIN(RADIANS(51.54348510000000)) * SIN(RADIANS(LATITUDE)))
   )
   AS AFSTAND_KLUS
FROM
   (SELECT * FROM JOB GROUP BY COMPANY_NAME) AS JOB
   INNER JOIN
      CLIENT
      ON JOB.CLIENT_ID = CLIENT.ID
   INNER JOIN
      ADDRESS
      ON JOB.ADDRESS_ID = ADDRESS.ID
   LEFT JOIN
      WORK_INTENT
      ON JOB.ID = WORK_INTENT.JOB_ID
   INNER JOIN
      JOB_TITLE
      ON JOB.JOB_TITLE_ID = JOB_TITLE.ID
WHERE
   JOB_TITLE.ID = ANY (
   SELECT
      JOB_TITLE.ID
   FROM
      JOB_TITLE
   WHERE
      JOB.JOB_TITLE_ID = '28'
      OR JOB.JOB_TITLE_ID = '30'
      OR JOB.JOB_TITLE_ID = '31'
      OR JOB.JOB_TITLE_ID = '32'
      OR JOB.JOB_TITLE_ID = '35'
      OR JOB.JOB_TITLE_ID = '38'
      OR JOB.JOB_TITLE_ID = '39'
      OR JOB.JOB_TITLE_ID = '40'
      OR JOB.JOB_TITLE_ID = '41'
      OR JOB.JOB_TITLE_ID = '42'
      OR JOB.JOB_TITLE_ID = '46'
      OR JOB.JOB_TITLE_ID = '49'
      OR JOB.JOB_TITLE_ID = '50'
      OR JOB.JOB_TITLE_ID = '52'
      OR JOB.JOB_TITLE_ID = '53'
      OR JOB.JOB_TITLE_ID = '55'
      OR JOB.JOB_TITLE_ID = '59'
      OR JOB.JOB_TITLE_ID = '60'
      OR JOB.JOB_TITLE_ID = '61'
      OR JOB.JOB_TITLE_ID = '62'
      OR JOB.JOB_TITLE_ID = '66'
      OR JOB.JOB_TITLE_ID = '67'
      OR JOB.JOB_TITLE_ID = '68'
      OR JOB.JOB_TITLE_ID = '70' )
      AND JOB.STATUS = 'open'
      AND CONVERT(JOB.STARTS_AT, DATE) = '2019-09-25'
      AND HOURLY_RATE_AMOUNT > 1300
   GROUP BY
      JOB.ID
   HAVING
      AFSTAND_KLUS < 200
   ORDER BY
      AANTAL_REACTIES,
      AFSTAND_KLUS LIMIT 100