SELECT user_id,SUM(points),SUM(played),SUM(won),SUM(lost)
FROM
  (
     SELECT user_id,points,played,won,lost FROM table1
     UNION ALL
     SELECT user_id,points,played,won,lost FROM table2
  ) AS t
GROUP BY user_id

SELECT user_id,points,played,won,lost
FROM
  (
     SELECT t.user_id,SUM(t.points+t1.points) AS points,
                SUM(t.played+t1.played) AS played,
                SUM(t.won+t1.won) AS won,
                SUM(t.lost+t1.lost) AS lost
      FROM table1 t
      INNER JOIN
      table2 t1
      ON t.user_id=t1.user_id
      GROUP BY t.user_id
  ) AS tb

$sql_local = 'SELECT id_usuario1 as id_usuario,'
			. ' SUM(CASE '
			. ' WHEN goles1 - goles2 > 0 THEN 3'
			. ' WHEN goles1 - goles2 = 0 THEN 1'
			. ' ELSE 0'
			. ' END ) pts,'
			. ' SUM(CASE '
			. ' WHEN goles1 - goles2 > 0 THEN 1'
			. ' ELSE 0'
			. ' END ) ganados,'
			. ' SUM(CASE '
			. ' WHEN goles1 - goles2 = 0 THEN 1'
			. ' ELSE 0'
			. ' END ) empates, '
			. ' SUM(CASE '
			. ' WHEN goles1 - goles2 < 0 THEN 1'
			. ' ELSE 0'
			. ' END ) perdidos, '
			. ' SUM(goles1) gf, '
			. ' SUM(goles2) gc '
			. ' FROM partidos GROUP BY  id_usuario1 ORDER By pts DESC LIMIT 0, 30';		
WHEN goles1 - goles2 > 0 THEN 3 WHEN goles1 - goles2 = 0 THEN 1 ELSE 0 END ) pts, SUM(CASE WHEN goles1 - goles2 > 0 THEN 1 ELSE 0 END ) ganados, SUM(CASE WHEN goles1 - goles2 = 0 THEN 1 ELSE 0 END ) empates, SUM(CASE WHEN goles1 - goles2 < 0 THEN 1 ELSE 0 END ) perdidos FROM partidos GROUP BY id_usuario1 ORDER By pts DESC LIMIT 0, 30";*/
		$sql_visitante = 'SELECT id_usuario2 as id_usuario,'
			. ' SUM(CASE WHEN goles2 - goles1 > 0 THEN 3'
			. ' WHEN goles2 - goles1 = 0 THEN 1'
			. ' ELSE 0'
			. ' END ) pts,'
			. ' SUM(CASE WHEN goles2 - goles1 > 0 THEN 1'
			. ' ELSE 0'
			. ' END ) ganados,'
			. ' SUM(CASE WHEN goles2 - goles1 = 0 THEN 1'
			. ' ELSE 0'
			. ' END ) empates, '
			. ' SUM(CASE WHEN goles2 - goles1 < 0 THEN 1'
			. ' ELSE 0'
			. ' END ) perdidos, '
			. ' SUM(goles2) gf, '
			. ' SUM(goles1) gc '
			. ' FROM partidos GROUP BY id_usuario2 ORDER BY pts DESC LIMIT 0, 30';

SELECT
	teamid
	, SUM(goals_for) as goals_scored
	, SUM(goals_against) as goals_allowed
	, SUM(win) as wins
	, SUM(loss) as losses
	, SUM(tie) as ties
FROM
	((
	SELECT
		id_local as teamid
		, golas_local as goals_for
		, golas_visit as goals_against
		, (SELECT IF( (golas_local - golas_visit) > 0, 1, 0 )) as win
		, (SELECT IF( (golas_local - golas_visit) < 0, 1, 0 )) as loss
		, (SELECT IF( (golas_local - golas_visit) = 0, 1, 0 )) as tie
	FROM
		games
	)
	UNION ALL
	(
	SELECT	
		id_visit as teamid
		, golas_visit as goals_for
		, golas_local as goals_against
		, (SELECT IF( (golas_visit - golas_local) > 0, 1, 0 )) as win
		, (SELECT IF( (golas_visit - golas_local) < 0, 1, 0 )) as loss
		, (SELECT IF( (golas_visit - golas_local) = 0, 1, 0 )) as tie
	FROM
		games
	)) AS tbl
GROUP BY 
	teamid
ORDER BY 
	wins DESC
	, losses DESC
	, ties DESC
	, goals_scored DESC
	, goals_allowed DESC