SELECT `Company`.`id`, `Company`.`name`, `Company`.`slug`, `Company`.`description`,  `Company`.`priority`, `City`.`name`, `City`.`slug` FROM `cms_companies_categories` AS `CompanyCategory` LEFT JOIN `cms_companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`id`) LEFT JOIN `cms_cities` AS `City` ON (`CompanyCategory`.`city_id` = `City`.`id`) WHERE `CompanyCategory`.`category_id` = 485 ORDER BY `Company`.`priority` ASC