SELECT `vSegment`.`segmentId` AS `id`, `vSegment`.`segment` AS `what` FROM `vSegment` WHERE (`vSegment`.`lineId` = 9) ORDER BY `vSegment`.`net`, `vSegment`.`line`, `vSegment`.`segment`