Select Code to Download

$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'
+, 'СЕВ'