SELECT * FROM `jobs` WHERE `city_id` = 0 order by `outside_location` asc