Query SELECT `listings`.`sid` as `object_sid`FROM `listings`   INNER JOIN `users` as users ON `users`.sid = `listings`.user_sid WHERE 1 AND `listings`.`active` = '1' AND ( FIND_IN_SET('684', `listings`.`JobCategory`) ) AND `listings`.`listing_type_sid` = '6' AND `listings`.`status` = 'approved'  ORDER BY priority DESC, CompanyName ASC : 
Statement could not be executed (23000 - 1052 - Column 'CompanyName' in order clause is ambiguous)