SELECT id_way, SUM(cnt) CNT
  FROM (
    SELECT id_way_a ad id_way,
           SUM( CASE id_carriage_a
                WHEN 1 THEN 2
                WHEN 4 THEN 36
                WHEN 6 THEN 20
                WHEN 7 THEN 54
                END
           ) CNT
      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
   UNION ALL
    SELECT id_way, -COUNT(id_civil_booking)
      FROM civil_bookings
     WHERE (id_connection_a IN(SELECT id_connection FROM connections WHERE id_way_a IN(SELECT id_way FROM ways WHERE (way LIKE '%' + @way + '%')))))
     GROUP BY id_way
  ) X
GROUP BY id_way