Объединение (суммирование) одинаковых таблиц

for($i = 1; $i <=18; $i++){
    $query="SELECT * FROM 2011_r_".$i." UNION SELECT * FROM 2012_r_".$i."";
//echo $query.'<br>';
    $res = mysql_query($query) or die ('Ошибка базы данных'.mysql_error());
   
    if(mysql_num_rows($res) > 0){
        while($row = mysql_fetch_assoc($res))
        {
            if ($row['pokazatel']!='name' and $row['pokazatel']!='fo')
            {
                foreach($row as $key2 => $value){
                    if($key2 != 'pokazatel') {
                        $data[$key][$i][$row['pokazatel']][$key2] = $value; //$key определяется выше
                 }
                }
            }
        }
    }
}

$query="SELECT SUM(all),SUM(go) FROM (
SELECT all, go FROM 2012_r_1_f1
UNION ALL 
SELECT all, go FROM 2012_r_2_f1) 
GROUP BY uid";

$sub_query='(';
for($i = 1; $i <=82; $i++){
    $sub_query.='SELECT `uid`, `all` as tot, `go` as tot2
    FROM 2012_r_'.$i.'_f1 where uid=2
    UNION ALL
    ';
}
    $sub_query.='SELECT `uid`, `all` as tot, `go` as tot2
    FROM 2012_r_83_f1 where uid=2
    ) AS Total 
    LEFT JOIN 2012_cfo_f1 ON Total.uid = 2012_cfo_f1.uid';
 
$query="SELECT 2012_cfo_f1.uid, SUM( tot ) as `all` , SUM( tot2 ) as `go` 
FROM ".$sub_query;

$sub_query='(';
for($i = 1; $i <=82; $i++){
    $sub_query.='SELECT `pokazatel`, `uid`, `all` as tot, `go` as tot2 FROM 2012_r_'.$i.'_f1
    UNION ALL 
    ';
}
    $sub_query.='SELECT `pokazatel`,`uid`, `all` as tot, `go` as tot2 FROM 2012_r_83_f1) AS u  GROUP BY uid';
 
   $query="SELECT pokazatel, uid,SUM(tot) as `all`, SUM(tot2) AS `go` FROM ".$sub_query;

$sub_query='(';
for($i = 1; $i <=82; $i++){
    $sub_query.='SELECT `name_rus`,`pokazatel`, `uid`, `all` as tot, `go` as tot2 FROM 2012_r_'.$i.'_f1
    UNION ALL 
    ';
}
    $sub_query.='SELECT `name_rus`,`pokazatel`,`uid`, `all` as tot, `go` as tot2 FROM 2012_r_83_f1) AS u  GROUP BY uid';
 
$query="CREATE TABLE itog AS SELECT name_rus, pokazatel, uid,SUM(tot) as `all`, SUM(tot2) AS `go` FROM ".$sub_query;