Okanagan Technology Jobs

Unity Developer

Unity Developer

About Hyper Hippo Find the Fun! That is why we are here at Hyper Hippo, always creating new games. Nothing thrills... read more



Who's Hiring




Recent Comments

Powered by Disqus

SELECT SQL_CALC_FOUND_ROWS `jobs`.*, ROUND((DEGREES( ACOS( ( SIN(RADIANS("49.883073715")) * SIN(RADIANS(jobs.location_lat)) ) + ( COS(RADIANS("49.883073715")) *COS(RADIANS(jobs.location_lat)) * COS(RADIANS("-119.485675106" - 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