SELECT * FROM
(
    SELECT TOP 10 * FROM
    (
        SELECT TOP 10  me.route_beg, me.route_end, nodes.node_name AS node_name_beg, nodes_2.node_name AS node_name_end, COUNT(me.route_beg) as grp_count FROM vi_route me  JOIN vi_nodes nodes ON ( nodes.node_id = me.route_beg )  JOIN vi_nodes nodes_2 ON ( nodes_2.node_id = me.route_beg ) WHERE ( ( ( me.route_beg = ? ) AND ( me.net_id = ? ) AND ( me.route_end = ? ) AND ( me.net_id = ? ) ) AND me.net_id = ? ) ORDER BY node_name_beg ASC
    ) AS foo
    ORDER BY node_name_beg DESC
) AS bar
ORDER BY node_name_beg ASC
: 'nodes.node_id', 'nodes.net_id', 'nodes_2.node_id', 'nodes_2.net_id', 'СЕВ'