Query SELECT `listings`.`sid` as `object_sid`FROM `listings`   WHERE 1 AND `listings`.`active` = '1' AND ( FIND_IN_SET('735', `listings`.`JobCategory`) ) AND `listings`.`listing_type_sid` = '6' AND `listings`.`status` = 'approved'  ORDER BY Distance DESC, priority DESC : 
Statement could not be executed (42S22 - 1054 - Unknown column 'Distance' in 'order clause')