REPLACE INTO proc VALUES ('fspow3r_futsal','fill_smallpts_09','PROCEDURE','fill_smallpts_09','SQL','CONTAINS_SQL','NO','DEFINER','','','BEGIN

  DECLARE fetched_league_id INT UNSIGNED;
  DECLARE fetched_points INT;

  DROP TEMPORARY TABLE IF EXISTS temp_rx;
  CREATE TEMPORARY TABLE temp_rx AS
    SELECT league_id, team_id, points
    FROM temp_round_table;

        UPDATE temp_round_table trt,
         (SELECT r.team_id, sum(r.points) AS points, sum(r.score)-sum(rl.score) AS ballance, sum(r.score) AS scored
          FROM
             (SELECT mb.match_id
              FROM
               (SELECT m.match_id
                  FROM
                     (SELECT team_id
                      FROM temp_rx
                      WHERE league_id=fetched_league_id AND points=fetched_points) tx
                WHERE true) mb
              GROUP BY mb.match_id
              HAVING count(*)>1) mx
          GROUP BY r.team_id) stb
        SET trt.small_points=stb.points, trt.small_scored=stb.scored, trt.small_ballance=stb.ballance
        WHERE trt.team_id=stb.team_id;

END','fspow3r_futsal@mysql5','2010-09-15 18:56:16','2010-09-15 18:56:16','','','utf8','utf8_polish_ci','utf8_polish_ci','
');