Materialized view и запрос данных из одной таблицы

CREATE MATERIALIZED VIEW tournaments_matches_alldata AS
SELECT tournaments.id AS tid, tournaments.tournament_name, tournaments_matches.id AS mid, profiles.id AS pid_1, profiles.first_name AS p1_fn, profiles.last_name AS p1_ln, profiles.id AS pid_2, profiles.first_name AS p2_fn, profiles.last_name AS p2_ln
FROM tournaments_matches
JOIN tournaments ON tournaments.id = tournament
INNER JOIN profiles AS player_1 ON profiles.id = player_1
INNER JOIN profiles AS player_2 ON profiles.id = player_2;

ON player_1.id = tournaments.id

CREATE materialized VIEW tournaments_matches_alldata AS
SELECT tournaments.id AS tid, tournaments.tournament_name, tournaments_matches.id AS mid, profiles.id AS pid_1, profiles.first_name AS p1_fn, profiles.last_name AS p1_ln, profiles.id AS pid_2, profiles.first_name AS p2_fn, profiles.last_name AS p2_ln
FROM tournaments_matches
INNER JOIN tournaments ON tournaments.id = tournament
INNER JOIN profiles ON profiles.id = player_1
INNER JOIN profiles ON profiles.id = player_2;

SELECT *
FROM
  tournaments_matches
    JOIN
  (SELECT player_1_id, first_name AS player_1_first_name FROM profiles) AS player_1_profiles
    ON tournaments_matches.player_1 = player_1_profiles.player_1_id
    JOIN
  (SELECT player_2_id, first_name AS player_2_first_name FROM profiles) AS player_2_profiles
    ON tournaments_matches.player_2 = player_2_profiles.player_2_id

CREATE VIEW player_1_profiles AS SELECT
  id AS player_1_id,
  first_name AS player_1_first_name,
  last_name AS player_1_last_name
FROM profiles;
 
CREATE VIEW player_2_profiles AS SELECT
  id AS player_2_id,
  first_name AS player_2_first_name,
  last_name AS player_2_last_name
FROM profiles;

SELECT *
FROM
  tournaments_matches
    JOIN
  player_1_profiles
    ON tournaments_matches.player_1 = player_1_profiles.player_1_id
    JOIN
  player_2_profiles
    ON tournaments_matches.player_2 = player_2_profiles.player_2_id

CREATE TABLE "Project" (
    "Project_ID" bigserial NOT NULL,
    "Project_Title" VARCHAR(300) NOT NULL,
    "Project_Acronym" VARCHAR(150) NOT NULL,
    "Project_Description" VARCHAR(1000)
);