Montréal Technology Jobs

iOS Developer

iOS Developer

As key members of our Development team, iOS developers are responsible for the design and implementation of... read more

SELECT SQL_CALC_FOUND_ROWS `jobs`.*, ROUND((DEGREES( ACOS( ( SIN(RADIANS("45.516779223")) * SIN(RADIANS(jobs.location_lat)) ) + ( COS(RADIANS("45.516779223")) *COS(RADIANS(jobs.location_lat)) * COS(RADIANS("-73.649179482" - jobs.location_lng))) ) * 60 * 1.1515 ) ) / 10) * 10 AS `distance` FROM `jobs` WHERE (jobs.is_spam = 0) AND (jobs.deleted = 0) AND (jobs.status = 1) GROUP BY `jobs`.`id` HAVING (distance IS NOT NULL) AND (distance <= 50) ORDER BY `distance` ASC, `date_created` DESC LIMIT 30 OFFSET 30