Help for this page
$c->stash->{routes} = [$c->model('QDB::Route')->search( { ... rows => $rows, # number of results per page }, )];
SELECT * FROM ( ... ) AS bar ORDER BY node_name_beg ASC : 'nodes.node_id', 'nodes.net_id', 'nodes_2.node_id', 'nodes_2.net_id' +, 'СЕВ'