Select Code to Download

$c->stash->{routes} = [$c->model('QDB::Route')->search(
    {
...
        'group_by' => [qw/ rt.route_beg rt.route_end node_name_beg nod
+e_name_end /],
    },
      )];

SELECT rt.route_beg, 
rt.route_end, 
...
WHERE ( n_1.net_id = ? ) 
GROUP BY rt.route_beg, rt.route_end, n_1.node_name, n_2.node_name 
ORDER BY node_name_beg: 'param_value'

page => 1,  # page to return (defaults to 1)
rows => 10, # number of results per page

SELECT * FROM
(
...
) AS bar
ORDER BY node_name_beg ASC
: 'param_value'