SELECT t1.name AS hometeam, t2.name AS guestteam, t1.id AS hometeam_id, pt1.id AS project_hometeam_id, team1_result AS homegoals, team2_result AS guestgoals, t2.id AS awayteam_id, pt2.id AS project_awayteam_id FROM jos_joomleague_match as matches INNER JOIN jos_joomleague_project_team pt1 ON pt1.id = matches.projectteam1_id INNER JOIN jos_joomleague_team t1 ON t1.id = pt1.team_id INNER JOIN jos_joomleague_project_team pt2 ON pt2.id = matches.projectteam2_id INNER JOIN jos_joomleague_team t2 ON t2.id = pt2.team_id WHERE pt1.project_id = 1 AND published=1 AND alt_decision=0 AND team1_result > team2_result AND (matches.cancel IS NULL OR matches.cancel = 0) ORDER BY (team1_result-team2_result) DESC