SELECT id_way, SUM( CASE id_carriage_a
            WHEN 1 THEN 2
            WHEN 4 THEN 36
            WHEN 6 THEN 20
            WHEN 7 THEN 54
            END
          )
  FROM connections WHERE (id_way_a IN(SELECT id_way FROM ways WHERE way LIKE '%' + @way + '%') AND id_carriage_a IN(1,4,6,7)
 GROUP BY id_way