Select * from resistors where res_active = 1 order by res_sortorder, res_part_number