create database league;
use league;

create table ground
(
    ground_id           int             auto_increment,
        constraint ground_pk PRIMARY KEY (ground_id),
    ground_name         varchar(75)     not null,
    ground_address      varchar(100)    not null,
    ground_capacity     int             
);

create table player
(
    player_id           int             auto_increment,
        constraint player_pk primary key (player_id),
    player_name         varchar(30)     not null
);

create table referee
(
    referee_id          int             auto_increment,
        constraint referee_pk primary key (referee_id),
    referee_name        varchar(30)     not null
);

create table team
(
    team_id             int             auto_increment,
        constraint team_pk primary key (team_id),
    team_name           varchar(75)     not null,
    team_manager        varchar(30)     not null,
    team_contact_number char(11)        not null,
    team_crest          varchar(75)     not null,
    ground_id           int             not null,
        constraint team_ground_idx unique (ground_id),
        constraint team_ground_fk foreign key (ground_id) references ground (ground_id)
);

create table team_player 
(
    team_id             int not null,
        constraint team_player_team_fk foreign key (team_id) references team (team_id),
    player_id           int not null,
        constraint team_player_player_fk foreign key (player_id) references player (player_id),
        constraint team_player_pk primary key (team_id, player_id)
);

create table fixture
(
    fixture_id          int auto_increment,
        constraint fixture_pk primary key (fixture_id),
    fixture_date        int not null,
    fixture_time        int not null,
    home_team_id        int not null,
        constraint fixture_team_fk1 foreign key (home_team_id) references team (team_id),
    away_team_id        int not null,
        constraint fixture_team_fk2 foreign key (away_team_id) references team (team_id),
    referee_id          int not null,
        constraint fixture_referee_fk foreign key (referee_id) references referee (referee_id)
);

create table fixture_player
(
    fixture_id          int not null,
        constraint fixture_player_fixture_fk foreign key (fixture_id) references fixture (fixture_id),
    player_id           int not null,
    team_id             int not null,
        constraint fixture_player_team_player_fk foreign key (player_id, team_id) references team_player (player_id, team_id),
        constraint fixture_player_pk primary key (fixture_id, player_id, team_id)
);

create table goalscorer
(
    fixture_id          int not null,
    player_id           int not null,
    team_id             int not null,
        constraint goalscorer_fixture_player_fk foreign key (fixture_id, player_id, team_id) references fixture_player (fixture_id, player_id, team_id)
);

create view goalscorers as
select
    player_name,
    team_name,
    count(*) as goals
from
    goalscorer
    inner join player on goalscorer.player_id = player.player_id
    inner join team on team.team_id = goalscorer.team_id
group by
    player_name
order by
    goals desc;
    
    
    
create view results_raw_1 as
select
    fixture_id,
    home_team_id,
    (
        select count(*)
        from goalscorer
        where
            fixture_id = fix.fixture_id and
            team_id = home_team_id
    ) as home_score,
    away_team_id,
    (
        select count(*)
        from goalscorer
        where
            fixture_id = fix.fixture_id and
            team_id = away_team_id
    ) as away_score
from fixture fix
where
    fix.fixture_date < curdate() + 0;
    
    create view results_raw as
select
    fixture_id,
    home_team_id,
    home_score as home_goals_for,
    case
        when home_score > away_score then 3
        when away_score > home_score then 0
        else 1
	end as home_points,
    away_team_id,
    away_score as away_goals_for,
    case
        when home_score < away_score then 3
        when away_score < home_score then 0
        else 1
	end as away_points
from results_raw_1;


create view results as
select
    home_team.team_name as home_team_name,
    away_team.team_name as away_team_name,
    home_goals_for,
    away_goals_for,
    fixture_date,
    fixture_time,
    home_team.team_id as home_team_id,
    away_team.team_id as away_team_id,
    referee_id,
    fixture.fixture_id
from
    results_raw
    inner join team home_team on home_team.team_id = results_raw.home_team_id
    inner join team away_team on away_team.team_id = results_raw.away_team_id
    inner join fixture on fixture.fixture_id = results_raw.fixture_id
order by
    fixture_date asc,
    fixture_time asc,
    home_team_name asc;


create view fixtures as
select
    home_team.team_name as home_team_name,
    away_team.team_name as away_team_name,
    fixture_date,
    fixture_time,
    referee_name
from fixture
    inner join referee on fixture.referee_id = referee.referee_id
    inner join team home_team on fixture.home_team_id = home_team.team_id
    inner join team away_team on fixture.away_team_id = away_team.team_id
where
    fixture_date >= curdate() + 0
order by
    fixture_date asc,
    fixture_time asc,
    home_team_name asc;

    
    create view team_player_name as
select
    player_name,
    fixture_player.player_id,
    fixture_id
from
    fixture_player
    inner join player on player.player_id = fixture_player.player_id;



create view fulltable as
select distinct
	team.team_name as team_name,
    (
		(select count(*) from results_raw where home_team_id = team_id and home_points = 3) +
		(select count(*) from results_raw where away_team_id = team_id and away_points = 3)
    ) as win,
	(
		(select count(*) from results_raw where home_team_id = team_id and home_points = 1) +
		(select count(*) from results_raw where away_team_id = team_id and away_points = 1)
    ) as draw,
	(
		(select count(*) from results_raw where home_team_id = team_id and home_points = 0) +
		(select count(*) from results_raw where away_team_id = team_id and away_points = 0)
    ) as lose,
    (
		select count(*) from results_raw where home_team_id = team_id or away_team_id = team_id
    ) as played,
    (
		(select sum(home_goals_for) from results_raw where home_team_id = team_id) +
        (select sum(away_goals_for) from results_raw where away_team_id = team_id)
    ) as gf,
    (
		(select sum(away_goals_for) from results_raw where home_team_id = team_id) +
        (select sum(home_goals_for) from results_raw where away_team_id = team_id)
    ) as ga,
    (
		(
			(select sum(home_goals_for) from results_raw where home_team_id = team_id) +
			(select sum(away_goals_for) from results_raw where away_team_id = team_id)
		) -
        (
			(select sum(away_goals_for) from results_raw where home_team_id = team_id) +
			(select sum(home_goals_for) from results_raw where away_team_id = team_id)
		)
    ) as gd,
    (
		(select sum(home_points) from results_raw where home_team_id = team_id) +
		(select sum(away_points) from results_raw where away_team_id = team_id)
    ) as points
from
	team
    inner join results_raw on team_id = results_raw.home_team_id or team_id = results_raw.away_team_id
order by
	points desc,
    gd desc,
    gf desc,
    ga desc;
    
    
INSERT INTO player (player_name) VALUES ('D. Torres');
INSERT INTO player (player_name) VALUES ('Y. Hanson');
INSERT INTO player (player_name) VALUES ('F. Matthews');
INSERT INTO player (player_name) VALUES ('D. Horne');
INSERT INTO player (player_name) VALUES ('S. Manning');
INSERT INTO player (player_name) VALUES ('B. Mccray');
INSERT INTO player (player_name) VALUES ('D. Horton');
INSERT INTO player (player_name) VALUES ('E. Stanton');
INSERT INTO player (player_name) VALUES ('V. Fisher');
INSERT INTO player (player_name) VALUES ('D. Branch');
INSERT INTO player (player_name) VALUES ('N. Daniels');
INSERT INTO player (player_name) VALUES ('G. Brooks');
INSERT INTO player (player_name) VALUES ('V. Soto');
INSERT INTO player (player_name) VALUES ('L. White');
INSERT INTO player (player_name) VALUES ('G. Bruce');
INSERT INTO player (player_name) VALUES ('K. Delgado');
INSERT INTO player (player_name) VALUES ('G. Valenzuela');
INSERT INTO player (player_name) VALUES ('Z. Castaneda');
INSERT INTO player (player_name) VALUES ('P. Horne');
INSERT INTO player (player_name) VALUES ('G. Witt');
INSERT INTO player (player_name) VALUES ('Z. Workman');
INSERT INTO player (player_name) VALUES ('G. Ashley');
INSERT INTO player (player_name) VALUES ('A. Mayo');
INSERT INTO player (player_name) VALUES ('S. Reilly');
INSERT INTO player (player_name) VALUES ('Q. Terrell');
INSERT INTO player (player_name) VALUES ('G. Shields');
INSERT INTO player (player_name) VALUES ('O. Yang');
INSERT INTO player (player_name) VALUES ('U. Russell');
INSERT INTO player (player_name) VALUES ('B. Kent');
INSERT INTO player (player_name) VALUES ('B. Klein');
INSERT INTO player (player_name) VALUES ('U. Monroe');
INSERT INTO player (player_name) VALUES ('V. Roberts');
INSERT INTO player (player_name) VALUES ('U. Garza');
INSERT INTO player (player_name) VALUES ('P. Cruz');
INSERT INTO player (player_name) VALUES ('Y. Mosley');
INSERT INTO player (player_name) VALUES ('M. Browning');
INSERT INTO player (player_name) VALUES ('L. Watts');
INSERT INTO player (player_name) VALUES ('I. Gardner');
INSERT INTO player (player_name) VALUES ('S. Chavez');
INSERT INTO player (player_name) VALUES ('O. Crawford');
INSERT INTO player (player_name) VALUES ('W. Pugh');
INSERT INTO player (player_name) VALUES ('M. Newton');
INSERT INTO player (player_name) VALUES ('Q. Taylor');
INSERT INTO player (player_name) VALUES ('Q. Love');
INSERT INTO player (player_name) VALUES ('B. Conley');
INSERT INTO player (player_name) VALUES ('A. Mclean');
INSERT INTO player (player_name) VALUES ('E. Haney');
INSERT INTO player (player_name) VALUES ('E. Foreman');
INSERT INTO player (player_name) VALUES ('K. Larsen');
INSERT INTO player (player_name) VALUES ('S. Johnson');
INSERT INTO player (player_name) VALUES ('I. Mcneil');
INSERT INTO player (player_name) VALUES ('M. Huffman');
INSERT INTO player (player_name) VALUES ('X. Palmer');
INSERT INTO player (player_name) VALUES ('M. Mercado');
INSERT INTO player (player_name) VALUES ('A. Ball');
INSERT INTO player (player_name) VALUES ('F. Villarreal');
INSERT INTO player (player_name) VALUES ('N. Golden');
INSERT INTO player (player_name) VALUES ('U. Durham');
INSERT INTO player (player_name) VALUES ('V. Carroll');
INSERT INTO player (player_name) VALUES ('O. Good');
INSERT INTO player (player_name) VALUES ('G. Brooks');
INSERT INTO player (player_name) VALUES ('F. Daniel');
INSERT INTO player (player_name) VALUES ('J. Moore');
INSERT INTO player (player_name) VALUES ('N. Harvey');
INSERT INTO player (player_name) VALUES ('P. Hopkins');
INSERT INTO player (player_name) VALUES ('A. Finley');
INSERT INTO player (player_name) VALUES ('U. Dejesus');
INSERT INTO player (player_name) VALUES ('Q. Nelson');
INSERT INTO player (player_name) VALUES ('I. Pate');
INSERT INTO player (player_name) VALUES ('S. Ruiz');
INSERT INTO player (player_name) VALUES ('G. Johns');
INSERT INTO player (player_name) VALUES ('E. Walton');
INSERT INTO player (player_name) VALUES ('P. Shaffer');
INSERT INTO player (player_name) VALUES ('D. Dalton');
INSERT INTO player (player_name) VALUES ('L. Joyner');
INSERT INTO player (player_name) VALUES ('U. Herrera');
INSERT INTO player (player_name) VALUES ('K. Velasquez');
INSERT INTO player (player_name) VALUES ('F. Sherman');
INSERT INTO player (player_name) VALUES ('G. Hunter');
INSERT INTO player (player_name) VALUES ('E. Owens');
INSERT INTO player (player_name) VALUES ('C. Jimenez');
INSERT INTO player (player_name) VALUES ('R. Frazier');
INSERT INTO player (player_name) VALUES ('B. Colon');
INSERT INTO player (player_name) VALUES ('Z. Page');
INSERT INTO player (player_name) VALUES ('B. Dean');
INSERT INTO player (player_name) VALUES ('R. Jimenez');
INSERT INTO player (player_name) VALUES ('I. Tanner');
INSERT INTO player (player_name) VALUES ('U. Marks');
INSERT INTO player (player_name) VALUES ('J. Boone');
INSERT INTO player (player_name) VALUES ('S. Morris');
INSERT INTO player (player_name) VALUES ('X. Zamora');
INSERT INTO player (player_name) VALUES ('H. Ferrell');
INSERT INTO player (player_name) VALUES ('B. White');
INSERT INTO player (player_name) VALUES ('V. Powers');
INSERT INTO player (player_name) VALUES ('B. Hudson');
INSERT INTO player (player_name) VALUES ('G. Fischer');
INSERT INTO player (player_name) VALUES ('X. Flowers');
INSERT INTO player (player_name) VALUES ('T. Sparks');
INSERT INTO player (player_name) VALUES ('S. Ewing');
INSERT INTO player (player_name) VALUES ('U. Bright');
INSERT INTO player (player_name) VALUES ('M. Phillips');
INSERT INTO player (player_name) VALUES ('Z. Leon');
INSERT INTO player (player_name) VALUES ('N. Mooney');
INSERT INTO player (player_name) VALUES ('K. Reyes');
INSERT INTO player (player_name) VALUES ('E. Rowe');
INSERT INTO player (player_name) VALUES ('C. Orr');
INSERT INTO player (player_name) VALUES ('U. Hewitt');
INSERT INTO player (player_name) VALUES ('E. Cooley');
INSERT INTO player (player_name) VALUES ('H. Ward');
INSERT INTO player (player_name) VALUES ('W. Stevens');
INSERT INTO player (player_name) VALUES ('G. Morton');
INSERT INTO player (player_name) VALUES ('X. Morales');
INSERT INTO player (player_name) VALUES ('L. Sellers');
INSERT INTO player (player_name) VALUES ('G. Faulkner');
INSERT INTO player (player_name) VALUES ('W. Day');
INSERT INTO player (player_name) VALUES ('D. Shaw');
INSERT INTO player (player_name) VALUES ('I. Nelson');
INSERT INTO player (player_name) VALUES ('R. Huff');
INSERT INTO player (player_name) VALUES ('F. Ferrell');
INSERT INTO player (player_name) VALUES ('L. Flowers');
INSERT INTO player (player_name) VALUES ('D. Carr');
INSERT INTO player (player_name) VALUES ('R. Mcdaniel');
INSERT INTO player (player_name) VALUES ('B. Mcknight');
INSERT INTO player (player_name) VALUES ('L. Leach');
INSERT INTO player (player_name) VALUES ('W. Watkins');
INSERT INTO player (player_name) VALUES ('S. Singleton');
INSERT INTO player (player_name) VALUES ('D. Wolf');
INSERT INTO player (player_name) VALUES ('F. Vaughan');
INSERT INTO player (player_name) VALUES ('B. Marquez');
INSERT INTO player (player_name) VALUES ('E. Martin');
INSERT INTO player (player_name) VALUES ('B. Valencia');
INSERT INTO player (player_name) VALUES ('V. Larsen');
INSERT INTO player (player_name) VALUES ('G. Dorsey');
INSERT INTO player (player_name) VALUES ('P. Koch');
INSERT INTO player (player_name) VALUES ('Q. Reeves');
INSERT INTO player (player_name) VALUES ('C. Crane');
INSERT INTO player (player_name) VALUES ('G. Delgado');
INSERT INTO player (player_name) VALUES ('O. Mann');
INSERT INTO player (player_name) VALUES ('D. Garrett');
INSERT INTO player (player_name) VALUES ('W. Hernandez');
INSERT INTO player (player_name) VALUES ('T. Molina');
INSERT INTO player (player_name) VALUES ('U. Hoover');
INSERT INTO player (player_name) VALUES ('A. Adkins');
INSERT INTO player (player_name) VALUES ('O. Franco');
INSERT INTO player (player_name) VALUES ('N. Robinson');
INSERT INTO player (player_name) VALUES ('R. Arnold');
INSERT INTO player (player_name) VALUES ('R. Whitaker');
INSERT INTO player (player_name) VALUES ('F. Solis');
INSERT INTO player (player_name) VALUES ('A. Frost');
INSERT INTO player (player_name) VALUES ('F. Benjamin');
INSERT INTO player (player_name) VALUES ('Q. Hooper');
INSERT INTO player (player_name) VALUES ('X. Mcintyre');
INSERT INTO player (player_name) VALUES ('Q. Albert');
INSERT INTO player (player_name) VALUES ('K. Vazquez');
INSERT INTO player (player_name) VALUES ('I. Alston');
INSERT INTO player (player_name) VALUES ('Q. Oconnor');
INSERT INTO player (player_name) VALUES ('C. Skinner');
INSERT INTO player (player_name) VALUES ('X. Clemons');
INSERT INTO player (player_name) VALUES ('N. Savage');
INSERT INTO player (player_name) VALUES ('Z. Wall');
INSERT INTO player (player_name) VALUES ('V. Robinson');
INSERT INTO player (player_name) VALUES ('A. Chan');
INSERT INTO player (player_name) VALUES ('M. Foley');
INSERT INTO player (player_name) VALUES ('R. Hutchinson');
INSERT INTO player (player_name) VALUES ('F. Greene');
INSERT INTO player (player_name) VALUES ('M. Mccray');
INSERT INTO player (player_name) VALUES ('U. Kramer');
INSERT INTO player (player_name) VALUES ('F. Mcclain');
INSERT INTO player (player_name) VALUES ('Z. Moss');
INSERT INTO player (player_name) VALUES ('S. Townsend');
INSERT INTO player (player_name) VALUES ('E. Humphrey');
INSERT INTO player (player_name) VALUES ('J. Merrill');
INSERT INTO player (player_name) VALUES ('F. Hansen');
INSERT INTO player (player_name) VALUES ('S. Mathews');
INSERT INTO player (player_name) VALUES ('C. Price');
INSERT INTO player (player_name) VALUES ('E. Hendrix');
INSERT INTO player (player_name) VALUES ('K. Wolf');
INSERT INTO player (player_name) VALUES ('V. Mccarty');
INSERT INTO player (player_name) VALUES ('E. Bradley');
INSERT INTO player (player_name) VALUES ('V. Oconnor');
INSERT INTO player (player_name) VALUES ('V. Mcconnell');
INSERT INTO player (player_name) VALUES ('W. Price');
INSERT INTO player (player_name) VALUES ('O. Swanson');
INSERT INTO player (player_name) VALUES ('D. Ford');
INSERT INTO player (player_name) VALUES ('X. Briggs');
INSERT INTO player (player_name) VALUES ('F. Velasquez');
INSERT INTO player (player_name) VALUES ('W. Gardner');
INSERT INTO player (player_name) VALUES ('X. Hines');
INSERT INTO player (player_name) VALUES ('U. House');
INSERT INTO player (player_name) VALUES ('U. Larsen');
INSERT INTO player (player_name) VALUES ('D. Kelly');
INSERT INTO player (player_name) VALUES ('I. Chan');
INSERT INTO player (player_name) VALUES ('N. Kline');
INSERT INTO player (player_name) VALUES ('M. Harper');
INSERT INTO player (player_name) VALUES ('X. Alvarez');
INSERT INTO player (player_name) VALUES ('T. Silva');
INSERT INTO player (player_name) VALUES ('N. Gilbert');
INSERT INTO player (player_name) VALUES ('A. Golden');
INSERT INTO player (player_name) VALUES ('G. Butler');
INSERT INTO player (player_name) VALUES ('D. Roberts');
INSERT INTO player (player_name) VALUES ('W. Wong');
INSERT INTO player (player_name) VALUES ('G. Horne');
INSERT INTO player (player_name) VALUES ('Z. Herman');
INSERT INTO player (player_name) VALUES ('I. Bonner');
INSERT INTO player (player_name) VALUES ('I. Campbell');
INSERT INTO player (player_name) VALUES ('T. Haynes');
INSERT INTO player (player_name) VALUES ('T. Bird');
INSERT INTO player (player_name) VALUES ('E. Collier');
INSERT INTO player (player_name) VALUES ('G. Hayes');
INSERT INTO player (player_name) VALUES ('D. Lang');
INSERT INTO player (player_name) VALUES ('F. Gates');
INSERT INTO player (player_name) VALUES ('O. Huff');
INSERT INTO player (player_name) VALUES ('U. Robbins');
INSERT INTO player (player_name) VALUES ('W. Hatfield');
INSERT INTO player (player_name) VALUES ('X. Meyer');
INSERT INTO player (player_name) VALUES ('A. Stone');
INSERT INTO player (player_name) VALUES ('V. Delgado');
INSERT INTO player (player_name) VALUES ('I. Foreman');
INSERT INTO player (player_name) VALUES ('M. Santos');
INSERT INTO player (player_name) VALUES ('Z. Anderson');
INSERT INTO player (player_name) VALUES ('U. Monroe');
INSERT INTO player (player_name) VALUES ('F. Burris');
INSERT INTO player (player_name) VALUES ('R. Sloan');
INSERT INTO player (player_name) VALUES ('E. Hall');
INSERT INTO player (player_name) VALUES ('U. Daniels');
INSERT INTO player (player_name) VALUES ('E. Hull');
INSERT INTO player (player_name) VALUES ('O. Buckley');
INSERT INTO player (player_name) VALUES ('T. Watkins');
INSERT INTO player (player_name) VALUES ('T. Curtis');
INSERT INTO player (player_name) VALUES ('Q. Lindsay');
INSERT INTO player (player_name) VALUES ('G. Luna');
INSERT INTO player (player_name) VALUES ('D. Langley');
INSERT INTO player (player_name) VALUES ('G. Hodge');
INSERT INTO player (player_name) VALUES ('W. Marshall');
INSERT INTO player (player_name) VALUES ('X. Trujillo');
INSERT INTO player (player_name) VALUES ('Z. Gordon');
INSERT INTO player (player_name) VALUES ('K. Willis');
INSERT INTO player (player_name) VALUES ('W. Ferguson');
INSERT INTO player (player_name) VALUES ('K. Taylor');
INSERT INTO player (player_name) VALUES ('T. Berger');
INSERT INTO player (player_name) VALUES ('T. Barton');
INSERT INTO player (player_name) VALUES ('T. Snyder');
INSERT INTO player (player_name) VALUES ('J. Jefferson');
INSERT INTO player (player_name) VALUES ('T. Wilkerson');
INSERT INTO player (player_name) VALUES ('K. Wolf');
INSERT INTO player (player_name) VALUES ('C. Beck');
INSERT INTO player (player_name) VALUES ('L. Love');
INSERT INTO player (player_name) VALUES ('L. Pacheco');
INSERT INTO player (player_name) VALUES ('T. Bell');
INSERT INTO player (player_name) VALUES ('D. Mosley');
INSERT INTO player (player_name) VALUES ('R. Valencia');
INSERT INTO player (player_name) VALUES ('X. Nelson');
INSERT INTO player (player_name) VALUES ('E. Wagner');
INSERT INTO player (player_name) VALUES ('X. Spears');
INSERT INTO player (player_name) VALUES ('T. Jensen');
INSERT INTO player (player_name) VALUES ('M. Bonner');
INSERT INTO player (player_name) VALUES ('M. Lowery');
INSERT INTO player (player_name) VALUES ('S. Monroe');
INSERT INTO player (player_name) VALUES ('Q. Boone');
INSERT INTO player (player_name) VALUES ('G. Suarez');
INSERT INTO player (player_name) VALUES ('H. Hughes');
INSERT INTO player (player_name) VALUES ('H. Bullock');
INSERT INTO player (player_name) VALUES ('S. Bartlett');
INSERT INTO player (player_name) VALUES ('A. Beck');
INSERT INTO player (player_name) VALUES ('I. Orr');
INSERT INTO player (player_name) VALUES ('R. Cline');
INSERT INTO player (player_name) VALUES ('F. Walters');
INSERT INTO player (player_name) VALUES ('Q. Lopez');
INSERT INTO player (player_name) VALUES ('Q. Livingston');
INSERT INTO player (player_name) VALUES ('Z. Valencia');
INSERT INTO player (player_name) VALUES ('Z. Strickland');
INSERT INTO player (player_name) VALUES ('M. Meyers');
INSERT INTO player (player_name) VALUES ('I. Estes');
INSERT INTO player (player_name) VALUES ('R. Jacobson');
INSERT INTO player (player_name) VALUES ('V. Winters');
INSERT INTO player (player_name) VALUES ('A. Lynch');
INSERT INTO player (player_name) VALUES ('N. Burks');
INSERT INTO player (player_name) VALUES ('M. Chavez');
INSERT INTO player (player_name) VALUES ('E. Shaw');
INSERT INTO player (player_name) VALUES ('B. Bray');
INSERT INTO player (player_name) VALUES ('X. Garrett');
INSERT INTO player (player_name) VALUES ('G. Johnston');
INSERT INTO player (player_name) VALUES ('G. Haney');
INSERT INTO player (player_name) VALUES ('D. Anderson');
INSERT INTO player (player_name) VALUES ('O. Ellison');
INSERT INTO player (player_name) VALUES ('H. Mitchell');
INSERT INTO player (player_name) VALUES ('S. Byers');
INSERT INTO player (player_name) VALUES ('W. Short');
INSERT INTO player (player_name) VALUES ('F. Mathews');
INSERT INTO player (player_name) VALUES ('K. Mcdonald');
INSERT INTO player (player_name) VALUES ('C. Cline');
INSERT INTO player (player_name) VALUES ('I. Duran');
INSERT INTO player (player_name) VALUES ('K. Silva');
INSERT INTO player (player_name) VALUES ('F. Riley');
INSERT INTO player (player_name) VALUES ('J. Steele');
INSERT INTO player (player_name) VALUES ('W. Kirk');
INSERT INTO player (player_name) VALUES ('Y. Rowe');
INSERT INTO player (player_name) VALUES ('R. Watts');
INSERT INTO player (player_name) VALUES ('T. Webster');
INSERT INTO player (player_name) VALUES ('H. Maldonado');
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Edinburgh Park', '20 Aliquam Street', 810);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Newcastle Park', '15 Ut Avenue', 616);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Green Peak', '7 Libero Ave', 1466);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Birmingham Chase', '13 Ultrices Avenue', 1464);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Wheatsheaf Park', '37 Sem Street', 769);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Horses Fields', '3 Diam Road', 371);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('North Field', '53 Sed Street', 670);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('North Road', '99 Egestas Street', 1342);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Amet Road', '29 Amet Road',NULL);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('West Park', '67 Semper Road',NULL);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('London Playing Ground', '96 Quisque Avenue', 478);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Manchester Playing Fields', '90 Sed Ave', 825);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Green Fields', '34 Lobortis Avenue', 106);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Canal Turn', '95 Nec Avenue', '759');
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Suffolk Arena', '89 Posuere Road', 1298);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('St Marys Park', '74 Justo Road', 510);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Yorkshire Park', '45 Mattis Road',NULL);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('North Park', '32 Sit Street',NULL);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('East Park', '81 Pede Avenue', 750);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Super Stadium', 'Super Street', 1400);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Stafford Stadium', '55 Ligula Street', 147);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Green Field', '28 Nec Street', 67);
INSERT INTO ground (ground_name, ground_address, ground_capacity) VALUES ('Sports Direct Stadium', '87 Adipiscing Avenue', 1140);
INSERT INTO referee (referee_name) VALUES ('Driscoll Stevens');
INSERT INTO referee (referee_name) VALUES ('Tanek Gay');
INSERT INTO referee (referee_name) VALUES ('Vaughan Reynolds');
INSERT INTO referee (referee_name) VALUES ('Luke Taylor');
INSERT INTO referee (referee_name) VALUES ('Kareem Bender');
INSERT INTO referee (referee_name) VALUES ('Quinn Bridges');
INSERT INTO referee (referee_name) VALUES ('Coby Morrow');
INSERT INTO referee (referee_name) VALUES ('Robert Strickland');
INSERT INTO referee (referee_name) VALUES ('Lars Reyes');
INSERT INTO referee (referee_name) VALUES ('Igor Stanley');
INSERT INTO referee (referee_name) VALUES ('Grant Ware');
INSERT INTO referee (referee_name) VALUES ('Gareth Ramsey');
INSERT INTO referee (referee_name) VALUES ('Kane Potter');
INSERT INTO referee (referee_name) VALUES ('Daniel Payne');
INSERT INTO referee (referee_name) VALUES ('Herman Randolph');
INSERT INTO referee (referee_name) VALUES ('Seth Bradford');
INSERT INTO referee (referee_name) VALUES ('Barclay Freeman');
INSERT INTO referee (referee_name) VALUES ('Myles Valenzuela');
INSERT INTO referee (referee_name) VALUES ('Salvador Rich');
INSERT INTO referee (referee_name) VALUES ('Kuame Terry');
INSERT INTO referee (referee_name) VALUES ('Erasmus Lambert');
INSERT INTO referee (referee_name) VALUES ('Roth Barron');
INSERT INTO referee (referee_name) VALUES ('Drake Boyle');
INSERT INTO referee (referee_name) VALUES ('Patrick Dixon');
INSERT INTO referee (referee_name) VALUES ('Timon Rhodes');
INSERT INTO referee (referee_name) VALUES ('Paul Cooley');
INSERT INTO referee (referee_name) VALUES ('Rashad Freeman');
INSERT INTO referee (referee_name) VALUES ('Davis Colon');
INSERT INTO referee (referee_name) VALUES ('Lev Rios');
INSERT INTO referee (referee_name) VALUES ('Warren Peterson');
INSERT INTO referee (referee_name) VALUES ('John Spencer');
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Queens Head', 'Jadyn Albert', '01470367932', 'https://www.queens-head.co.uk/images/crest.png', 10);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Black Horse', 'Rowan Davies', '01875562224', 'http://www.black-horse.co.uk/images/crest.png', 15);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('The Others FC', 'Johnie Peck', '01713699344', 'https://www.the-others.co.uk/images/logo.jpeg', 3);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Red Lion', 'Addison Harden', '01815667872', 'http://www.red-lion.co.uk/images/logo.jpg', 4);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('The Riders', 'Anne Example', '01234567890', 'https://www.riders.co.uk/images/logo.jpg', 20);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Coach and Horses', 'Joss Paris', '01486524938', 'http://www.coach-and-horses.co.uk/images/logo.jpg', 14);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Hare and Hounds', 'Morgan Baines', '01824015751', 'https://www.hare-and-hounds.co.uk/img/logo.gif', 13);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('George and Dragon', 'Georgie Danell', '01802305798', 'http://www.george-and-dragon.co.uk/img/logo.gif', 1);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Wellington', 'Vic Brown', '01665931620', 'https://www.wellington.co.uk/source/logo.gif', 17);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Royal Oak', 'Happy Grant', '01749005473', 'http://www.royal-oak.co.uk/source/logo.gif', 21);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Another Team FC', 'Kerry Southers', '01576659182', 'https://www.another-team.co.uk/source/crest.png', 23);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Three Horseshoes', 'Emery Pierce', '01355427900', 'http://www.threehorseshoes.co.uk/source/crest.png', 7);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Birmingham AFC', 'Mo Tennison', '01894411004', 'https://www.birminghamafc.co.uk/source/crest.png', 11);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Kings Head', 'Blair Varnham', '01841037892', 'http://www.kingshead.co.uk/source/crest.png', 18);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Someone Else AFC', 'Jules Colton', '01616928752', 'https://www.someoneelse.co.uk/img/logo.gif', 19);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Masons Arms', 'Laurie Waller', '01772955180', 'http://www.masonsarms.co.uk/img/logo.jpg', 6);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('The Queens', 'Montana Dwight', '01566941692', 'https://www.thequeens.co.uk/img/logo.jpg', 12);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Prince Of Wales', 'Robbie Randall', '01562905152', 'http://www.princeofwales.co.uk/images/logo.gif', 9);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Fox and Hounds', 'Sydney Potter', '01713544583', 'https://www.foxandhounds.co.uk/images/logo.gif', 5);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Black Bull', 'Braidy Brassington', '01591370909', 'http://www.blackbull.co.uk/images/crest.png', 16);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Rose and Crown', 'Hunter Baldwin', '01778161935', 'https://www.roseandcrown.co.uk/images/crest.png', 8);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('Some Team', 'Billie Hawk', '01563578503', 'http://www.someteam.co.uk/images/crest.png', 2);
INSERT INTO team (team_name, team_manager, team_contact_number, team_crest, ground_id) VALUES
    ('White Horse', 'Ainsley Page', '01748314505', 'https://www.whitehorse.co.uk/images/logo.jpeg', 22);
INSERT INTO team_player (team_id, player_id) VALUES (3, 82);
INSERT INTO team_player (team_id, player_id) VALUES (5, 27);
INSERT INTO team_player (team_id, player_id) VALUES (17, 179);
INSERT INTO team_player (team_id, player_id) VALUES (17, 67);
INSERT INTO team_player (team_id, player_id) VALUES (9, 296);
INSERT INTO team_player (team_id, player_id) VALUES (16, 242);
INSERT INTO team_player (team_id, player_id) VALUES (2, 142);
INSERT INTO team_player (team_id, player_id) VALUES (5, 173);
INSERT INTO team_player (team_id, player_id) VALUES (4, 280);
INSERT INTO team_player (team_id, player_id) VALUES (12, 246);
INSERT INTO team_player (team_id, player_id) VALUES (9, 285);
INSERT INTO team_player (team_id, player_id) VALUES (10, 157);
INSERT INTO team_player (team_id, player_id) VALUES (16, 253);
INSERT INTO team_player (team_id, player_id) VALUES (19, 129);
INSERT INTO team_player (team_id, player_id) VALUES (18, 166);
INSERT INTO team_player (team_id, player_id) VALUES (5, 249);
INSERT INTO team_player (team_id, player_id) VALUES (20, 80);
INSERT INTO team_player (team_id, player_id) VALUES (20, 220);
INSERT INTO team_player (team_id, player_id) VALUES (19, 156);
INSERT INTO team_player (team_id, player_id) VALUES (11, 277);
INSERT INTO team_player (team_id, player_id) VALUES (18, 291);
INSERT INTO team_player (team_id, player_id) VALUES (11, 56);
INSERT INTO team_player (team_id, player_id) VALUES (13, 36);
INSERT INTO team_player (team_id, player_id) VALUES (9, 113);
INSERT INTO team_player (team_id, player_id) VALUES (14, 219);
INSERT INTO team_player (team_id, player_id) VALUES (19, 37);
INSERT INTO team_player (team_id, player_id) VALUES (8, 158);
INSERT INTO team_player (team_id, player_id) VALUES (4, 46);
INSERT INTO team_player (team_id, player_id) VALUES (15, 143);
INSERT INTO team_player (team_id, player_id) VALUES (15, 201);
INSERT INTO team_player (team_id, player_id) VALUES (3, 114);
INSERT INTO team_player (team_id, player_id) VALUES (5, 229);
INSERT INTO team_player (team_id, player_id) VALUES (9, 185);
INSERT INTO team_player (team_id, player_id) VALUES (15, 148);
INSERT INTO team_player (team_id, player_id) VALUES (1, 7);
INSERT INTO team_player (team_id, player_id) VALUES (13, 77);
INSERT INTO team_player (team_id, player_id) VALUES (6, 45);
INSERT INTO team_player (team_id, player_id) VALUES (20, 131);
INSERT INTO team_player (team_id, player_id) VALUES (1, 10);
INSERT INTO team_player (team_id, player_id) VALUES (15, 216);
INSERT INTO team_player (team_id, player_id) VALUES (7, 122);
INSERT INTO team_player (team_id, player_id) VALUES (9, 300);
INSERT INTO team_player (team_id, player_id) VALUES (5, 225);
INSERT INTO team_player (team_id, player_id) VALUES (3, 88);
INSERT INTO team_player (team_id, player_id) VALUES (6, 138);
INSERT INTO team_player (team_id, player_id) VALUES (18, 279);
INSERT INTO team_player (team_id, player_id) VALUES (5, 214);
INSERT INTO team_player (team_id, player_id) VALUES (20, 69);
INSERT INTO team_player (team_id, player_id) VALUES (17, 25);
INSERT INTO team_player (team_id, player_id) VALUES (16, 259);
INSERT INTO team_player (team_id, player_id) VALUES (20, 93);
INSERT INTO team_player (team_id, player_id) VALUES (11, 294);
INSERT INTO team_player (team_id, player_id) VALUES (13, 278);
INSERT INTO team_player (team_id, player_id) VALUES (14, 217);
INSERT INTO team_player (team_id, player_id) VALUES (15, 120);
INSERT INTO team_player (team_id, player_id) VALUES (18, 159);
INSERT INTO team_player (team_id, player_id) VALUES (10, 150);
INSERT INTO team_player (team_id, player_id) VALUES (11, 118);
INSERT INTO team_player (team_id, player_id) VALUES (9, 149);
INSERT INTO team_player (team_id, player_id) VALUES (9, 127);
INSERT INTO team_player (team_id, player_id) VALUES (6, 20);
INSERT INTO team_player (team_id, player_id) VALUES (8, 83);
INSERT INTO team_player (team_id, player_id) VALUES (6, 298);
INSERT INTO team_player (team_id, player_id) VALUES (14, 92);
INSERT INTO team_player (team_id, player_id) VALUES (16, 258);
INSERT INTO team_player (team_id, player_id) VALUES (11, 87);
INSERT INTO team_player (team_id, player_id) VALUES (12, 61);
INSERT INTO team_player (team_id, player_id) VALUES (1, 11);
INSERT INTO team_player (team_id, player_id) VALUES (7, 28);
INSERT INTO team_player (team_id, player_id) VALUES (16, 237);
INSERT INTO team_player (team_id, player_id) VALUES (8, 91);
INSERT INTO team_player (team_id, player_id) VALUES (2, 23);
INSERT INTO team_player (team_id, player_id) VALUES (4, 239);
INSERT INTO team_player (team_id, player_id) VALUES (7, 184);
INSERT INTO team_player (team_id, player_id) VALUES (10, 197);
INSERT INTO team_player (team_id, player_id) VALUES (4, 276);
INSERT INTO team_player (team_id, player_id) VALUES (15, 153);
INSERT INTO team_player (team_id, player_id) VALUES (18, 29);
INSERT INTO team_player (team_id, player_id) VALUES (20, 94);
INSERT INTO team_player (team_id, player_id) VALUES (11, 272);
INSERT INTO team_player (team_id, player_id) VALUES (20, 190);
INSERT INTO team_player (team_id, player_id) VALUES (11, 292);
INSERT INTO team_player (team_id, player_id) VALUES (14, 240);
INSERT INTO team_player (team_id, player_id) VALUES (4, 32);
INSERT INTO team_player (team_id, player_id) VALUES (4, 257);
INSERT INTO team_player (team_id, player_id) VALUES (18, 251);
INSERT INTO team_player (team_id, player_id) VALUES (2, 192);
INSERT INTO team_player (team_id, player_id) VALUES (8, 86);
INSERT INTO team_player (team_id, player_id) VALUES (20, 51);
INSERT INTO team_player (team_id, player_id) VALUES (3, 275);
INSERT INTO team_player (team_id, player_id) VALUES (2, 250);
INSERT INTO team_player (team_id, player_id) VALUES (15, 199);
INSERT INTO team_player (team_id, player_id) VALUES (7, 119);
INSERT INTO team_player (team_id, player_id) VALUES (19, 281);
INSERT INTO team_player (team_id, player_id) VALUES (14, 187);
INSERT INTO team_player (team_id, player_id) VALUES (8, 78);
INSERT INTO team_player (team_id, player_id) VALUES (8, 263);
INSERT INTO team_player (team_id, player_id) VALUES (20, 84);
INSERT INTO team_player (team_id, player_id) VALUES (19, 163);
INSERT INTO team_player (team_id, player_id) VALUES (17, 35);
INSERT INTO team_player (team_id, player_id) VALUES (12, 180);
INSERT INTO team_player (team_id, player_id) VALUES (10, 170);
INSERT INTO team_player (team_id, player_id) VALUES (3, 125);
INSERT INTO team_player (team_id, player_id) VALUES (18, 161);
INSERT INTO team_player (team_id, player_id) VALUES (7, 297);
INSERT INTO team_player (team_id, player_id) VALUES (14, 169);
INSERT INTO team_player (team_id, player_id) VALUES (12, 167);
INSERT INTO team_player (team_id, player_id) VALUES (2, 101);
INSERT INTO team_player (team_id, player_id) VALUES (1, 5);
INSERT INTO team_player (team_id, player_id) VALUES (8, 248);
INSERT INTO team_player (team_id, player_id) VALUES (5, 212);
INSERT INTO team_player (team_id, player_id) VALUES (9, 176);
INSERT INTO team_player (team_id, player_id) VALUES (2, 243);
INSERT INTO team_player (team_id, player_id) VALUES (18, 52);
INSERT INTO team_player (team_id, player_id) VALUES (6, 60);
INSERT INTO team_player (team_id, player_id) VALUES (11, 74);
INSERT INTO team_player (team_id, player_id) VALUES (11, 49);
INSERT INTO team_player (team_id, player_id) VALUES (7, 269);
INSERT INTO team_player (team_id, player_id) VALUES (8, 270);
INSERT INTO team_player (team_id, player_id) VALUES (17, 203);
INSERT INTO team_player (team_id, player_id) VALUES (5, 54);
INSERT INTO team_player (team_id, player_id) VALUES (9, 134);
INSERT INTO team_player (team_id, player_id) VALUES (13, 181);
INSERT INTO team_player (team_id, player_id) VALUES (14, 111);
INSERT INTO team_player (team_id, player_id) VALUES (7, 218);
INSERT INTO team_player (team_id, player_id) VALUES (15, 40);
INSERT INTO team_player (team_id, player_id) VALUES (15, 194);
INSERT INTO team_player (team_id, player_id) VALUES (16, 254);
INSERT INTO team_player (team_id, player_id) VALUES (14, 207);
INSERT INTO team_player (team_id, player_id) VALUES (19, 247);
INSERT INTO team_player (team_id, player_id) VALUES (6, 244);
INSERT INTO team_player (team_id, player_id) VALUES (10, 70);
INSERT INTO team_player (team_id, player_id) VALUES (4, 265);
INSERT INTO team_player (team_id, player_id) VALUES (11, 144);
INSERT INTO team_player (team_id, player_id) VALUES (1, 6);
INSERT INTO team_player (team_id, player_id) VALUES (18, 136);
INSERT INTO team_player (team_id, player_id) VALUES (16, 19);
INSERT INTO team_player (team_id, player_id) VALUES (20, 71);
INSERT INTO team_player (team_id, player_id) VALUES (13, 34);
INSERT INTO team_player (team_id, player_id) VALUES (8, 282);
INSERT INTO team_player (team_id, player_id) VALUES (2, 33);
INSERT INTO team_player (team_id, player_id) VALUES (1, 3);
INSERT INTO team_player (team_id, player_id) VALUES (15, 208);
INSERT INTO team_player (team_id, player_id) VALUES (3, 48);
INSERT INTO team_player (team_id, player_id) VALUES (14, 66);
INSERT INTO team_player (team_id, player_id) VALUES (13, 140);
INSERT INTO team_player (team_id, player_id) VALUES (11, 116);
INSERT INTO team_player (team_id, player_id) VALUES (19, 97);
INSERT INTO team_player (team_id, player_id) VALUES (8, 22);
INSERT INTO team_player (team_id, player_id) VALUES (19, 228);
INSERT INTO team_player (team_id, player_id) VALUES (2, 128);
INSERT INTO team_player (team_id, player_id) VALUES (9, 126);
INSERT INTO team_player (team_id, player_id) VALUES (10, 102);
INSERT INTO team_player (team_id, player_id) VALUES (6, 145);
INSERT INTO team_player (team_id, player_id) VALUES (15, 221);
INSERT INTO team_player (team_id, player_id) VALUES (17, 76);
INSERT INTO team_player (team_id, player_id) VALUES (6, 210);
INSERT INTO team_player (team_id, player_id) VALUES (10, 198);
INSERT INTO team_player (team_id, player_id) VALUES (4, 85);
INSERT INTO team_player (team_id, player_id) VALUES (17, 53);
INSERT INTO team_player (team_id, player_id) VALUES (2, 65);
INSERT INTO team_player (team_id, player_id) VALUES (10, 106);
INSERT INTO team_player (team_id, player_id) VALUES (10, 26);
INSERT INTO team_player (team_id, player_id) VALUES (16, 256);
INSERT INTO team_player (team_id, player_id) VALUES (13, 268);
INSERT INTO team_player (team_id, player_id) VALUES (19, 293);
INSERT INTO team_player (team_id, player_id) VALUES (16, 231);
INSERT INTO team_player (team_id, player_id) VALUES (7, 286);
INSERT INTO team_player (team_id, player_id) VALUES (18, 230);
INSERT INTO team_player (team_id, player_id) VALUES (11, 200);
INSERT INTO team_player (team_id, player_id) VALUES (12, 273);
INSERT INTO team_player (team_id, player_id) VALUES (6, 108);
INSERT INTO team_player (team_id, player_id) VALUES (4, 188);
INSERT INTO team_player (team_id, player_id) VALUES (8, 171);
INSERT INTO team_player (team_id, player_id) VALUES (7, 165);
INSERT INTO team_player (team_id, player_id) VALUES (12, 168);
INSERT INTO team_player (team_id, player_id) VALUES (18, 63);
INSERT INTO team_player (team_id, player_id) VALUES (19, 202);
INSERT INTO team_player (team_id, player_id) VALUES (1, 12);
INSERT INTO team_player (team_id, player_id) VALUES (16, 75);
INSERT INTO team_player (team_id, player_id) VALUES (18, 289);
INSERT INTO team_player (team_id, player_id) VALUES (17, 123);
INSERT INTO team_player (team_id, player_id) VALUES (5, 81);
INSERT INTO team_player (team_id, player_id) VALUES (10, 99);
INSERT INTO team_player (team_id, player_id) VALUES (8, 110);
INSERT INTO team_player (team_id, player_id) VALUES (20, 96);
INSERT INTO team_player (team_id, player_id) VALUES (11, 133);
INSERT INTO team_player (team_id, player_id) VALUES (8, 213);
INSERT INTO team_player (team_id, player_id) VALUES (6, 124);
INSERT INTO team_player (team_id, player_id) VALUES (2, 234);
INSERT INTO team_player (team_id, player_id) VALUES (12, 224);
INSERT INTO team_player (team_id, player_id) VALUES (7, 132);
INSERT INTO team_player (team_id, player_id) VALUES (2, 121);
INSERT INTO team_player (team_id, player_id) VALUES (17, 204);
INSERT INTO team_player (team_id, player_id) VALUES (7, 100);
INSERT INTO team_player (team_id, player_id) VALUES (14, 41);
INSERT INTO team_player (team_id, player_id) VALUES (8, 164);
INSERT INTO team_player (team_id, player_id) VALUES (17, 160);
INSERT INTO team_player (team_id, player_id) VALUES (10, 284);
INSERT INTO team_player (team_id, player_id) VALUES (1, 2);
INSERT INTO team_player (team_id, player_id) VALUES (14, 299);
INSERT INTO team_player (team_id, player_id) VALUES (7, 130);
INSERT INTO team_player (team_id, player_id) VALUES (12, 264);
INSERT INTO team_player (team_id, player_id) VALUES (7, 271);
INSERT INTO team_player (team_id, player_id) VALUES (1, 4);
INSERT INTO team_player (team_id, player_id) VALUES (10, 44);
INSERT INTO team_player (team_id, player_id) VALUES (5, 21);
INSERT INTO team_player (team_id, player_id) VALUES (12, 64);
INSERT INTO team_player (team_id, player_id) VALUES (8, 72);
INSERT INTO team_player (team_id, player_id) VALUES (19, 39);
INSERT INTO team_player (team_id, player_id) VALUES (6, 59);
INSERT INTO team_player (team_id, player_id) VALUES (2, 186);
INSERT INTO team_player (team_id, player_id) VALUES (20, 227);
INSERT INTO team_player (team_id, player_id) VALUES (20, 241);
INSERT INTO team_player (team_id, player_id) VALUES (3, 16);
INSERT INTO team_player (team_id, player_id) VALUES (17, 109);
INSERT INTO team_player (team_id, player_id) VALUES (9, 105);
INSERT INTO team_player (team_id, player_id) VALUES (3, 209);
INSERT INTO team_player (team_id, player_id) VALUES (13, 62);
INSERT INTO team_player (team_id, player_id) VALUES (1, 9);
INSERT INTO team_player (team_id, player_id) VALUES (3, 196);
INSERT INTO team_player (team_id, player_id) VALUES (4, 135);
INSERT INTO team_player (team_id, player_id) VALUES (5, 235);
INSERT INTO team_player (team_id, player_id) VALUES (20, 288);
INSERT INTO team_player (team_id, player_id) VALUES (6, 195);
INSERT INTO team_player (team_id, player_id) VALUES (18, 267);
INSERT INTO team_player (team_id, player_id) VALUES (5, 283);
INSERT INTO team_player (team_id, player_id) VALUES (4, 177);
INSERT INTO team_player (team_id, player_id) VALUES (4, 290);
INSERT INTO team_player (team_id, player_id) VALUES (13, 30);
INSERT INTO team_player (team_id, player_id) VALUES (3, 191);
INSERT INTO team_player (team_id, player_id) VALUES (9, 115);
INSERT INTO team_player (team_id, player_id) VALUES (11, 98);
INSERT INTO team_player (team_id, player_id) VALUES (1, 1);
INSERT INTO team_player (team_id, player_id) VALUES (18, 193);
INSERT INTO team_player (team_id, player_id) VALUES (3, 189);
INSERT INTO team_player (team_id, player_id) VALUES (18, 226);
INSERT INTO team_player (team_id, player_id) VALUES (13, 233);
INSERT INTO team_player (team_id, player_id) VALUES (3, 287);
INSERT INTO team_player (team_id, player_id) VALUES (1, 13);
INSERT INTO team_player (team_id, player_id) VALUES (12, 89);
INSERT INTO team_player (team_id, player_id) VALUES (12, 205);
INSERT INTO team_player (team_id, player_id) VALUES (13, 211);
INSERT INTO team_player (team_id, player_id) VALUES (9, 47);
INSERT INTO team_player (team_id, player_id) VALUES (9, 73);
INSERT INTO team_player (team_id, player_id) VALUES (5, 152);
INSERT INTO team_player (team_id, player_id) VALUES (3, 117);
INSERT INTO team_player (team_id, player_id) VALUES (2, 232);
INSERT INTO team_player (team_id, player_id) VALUES (13, 252);
INSERT INTO team_player (team_id, player_id) VALUES (14, 79);
INSERT INTO team_player (team_id, player_id) VALUES (12, 17);
INSERT INTO team_player (team_id, player_id) VALUES (1, 14);
INSERT INTO team_player (team_id, player_id) VALUES (14, 162);
INSERT INTO team_player (team_id, player_id) VALUES (19, 50);
INSERT INTO team_player (team_id, player_id) VALUES (6, 183);
INSERT INTO team_player (team_id, player_id) VALUES (10, 172);
INSERT INTO team_player (team_id, player_id) VALUES (13, 155);
INSERT INTO team_player (team_id, player_id) VALUES (17, 274);
INSERT INTO team_player (team_id, player_id) VALUES (19, 139);
INSERT INTO team_player (team_id, player_id) VALUES (5, 236);
INSERT INTO team_player (team_id, player_id) VALUES (6, 255);
INSERT INTO team_player (team_id, player_id) VALUES (5, 238);
INSERT INTO team_player (team_id, player_id) VALUES (16, 68);
INSERT INTO team_player (team_id, player_id) VALUES (16, 38);
INSERT INTO team_player (team_id, player_id) VALUES (17, 154);
INSERT INTO team_player (team_id, player_id) VALUES (9, 182);
INSERT INTO team_player (team_id, player_id) VALUES (15, 222);
INSERT INTO team_player (team_id, player_id) VALUES (7, 58);
INSERT INTO team_player (team_id, player_id) VALUES (6, 107);
INSERT INTO team_player (team_id, player_id) VALUES (15, 266);
INSERT INTO team_player (team_id, player_id) VALUES (2, 43);
INSERT INTO team_player (team_id, player_id) VALUES (4, 223);
INSERT INTO team_player (team_id, player_id) VALUES (17, 245);
INSERT INTO team_player (team_id, player_id) VALUES (16, 55);
INSERT INTO team_player (team_id, player_id) VALUES (12, 141);
INSERT INTO team_player (team_id, player_id) VALUES (1, 15);
INSERT INTO team_player (team_id, player_id) VALUES (4, 90);
INSERT INTO team_player (team_id, player_id) VALUES (10, 24);
INSERT INTO team_player (team_id, player_id) VALUES (14, 261);
INSERT INTO team_player (team_id, player_id) VALUES (15, 57);
INSERT INTO team_player (team_id, player_id) VALUES (2, 42);
INSERT INTO team_player (team_id, player_id) VALUES (13, 295);
INSERT INTO team_player (team_id, player_id) VALUES (3, 178);
INSERT INTO team_player (team_id, player_id) VALUES (10, 174);
INSERT INTO team_player (team_id, player_id) VALUES (1, 8);
INSERT INTO team_player (team_id, player_id) VALUES (19, 112);
INSERT INTO team_player (team_id, player_id) VALUES (7, 206);
INSERT INTO team_player (team_id, player_id) VALUES (11, 147);
INSERT INTO team_player (team_id, player_id) VALUES (12, 262);
INSERT INTO team_player (team_id, player_id) VALUES (19, 215);
INSERT INTO team_player (team_id, player_id) VALUES (17, 95);
INSERT INTO team_player (team_id, player_id) VALUES (13, 146);
INSERT INTO team_player (team_id, player_id) VALUES (20, 137);
INSERT INTO team_player (team_id, player_id) VALUES (15, 104);
INSERT INTO team_player (team_id, player_id) VALUES (12, 31);
INSERT INTO team_player (team_id, player_id) VALUES (3, 18);
INSERT INTO team_player (team_id, player_id) VALUES (16, 175);
INSERT INTO team_player (team_id, player_id) VALUES (14, 260);
INSERT INTO team_player (team_id, player_id) VALUES (16, 151);
INSERT INTO team_player (team_id, player_id) VALUES (4, 103);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1500, 1, 2, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1500, 3, 4, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1500, 5, 6, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1500, 7, 8, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1500, 9, 10, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1500, 11, 12, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1500, 13, 14, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1500, 15, 16, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1600, 17, 18, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -42), 1600, 19, 20, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1500, 16, 11, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1500, 4, 5, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1500, 2, 19, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1500, 6, 1, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1500, 14, 15, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1500, 12, 7, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1500, 8, 17, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1600, 18, 9, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1600, 10, 3, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -35), 1600, 20, 13, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1500, 16, 14, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1500, 3, 9, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1500, 6, 4, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1500, 5, 1, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1500, 12, 15, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1500, 11, 2, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1500, 13, 18, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1500, 10, 17, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1600, 20, 7, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -28), 1600, 19, 8, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1500, 1, 12, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1500, 4, 10, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1500, 2, 3, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1500, 14, 19, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1500, 7, 16, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1500, 9, 13, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1500, 8, 11, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1500, 15, 5, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1600, 18, 20, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -21), 1600, 17, 6, 24);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1500, 16, 1, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1500, 3, 18, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1500, 6, 2, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1500, 5, 9, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1500, 12, 4, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1500, 11, 14, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1500, 13, 15, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1500, 10, 8, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1600, 20, 17, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -14), 1600, 19, 7, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1500, 1, 20, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1500, 4, 16, 18);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1500, 2, 5, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1500, 14, 12, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1500, 7, 6, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1500, 9, 19, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1500, 8, 13, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1500, 15, 11, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1600, 18, 10, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), -7), 1600, 17, 3, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1500, 16, 12, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1500, 4, 1, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1500, 14, 2, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1500, 5, 3, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1500, 7, 17, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1500, 9, 6, 10);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1500, 18, 15, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1500, 10, 11, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1600, 20, 8, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 0), 1600, 19, 13, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1500, 1, 14, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1500, 3, 19, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1500, 2, 4, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1500, 6, 16, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1500, 12, 20, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1500, 11, 5, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1500, 13, 7, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1500, 8, 18, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1600, 15, 10, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 7), 1600, 17, 9, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1500, 3, 6, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1500, 7, 14, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1500, 9, 4, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1500, 13, 16, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1500, 8, 15, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1500, 18, 1, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1500, 10, 5, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1500, 20, 11, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1600, 17, 2, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 14), 1600, 19, 12, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1500, 1, 3, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1500, 16, 20, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1500, 4, 13, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1500, 2, 18, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1500, 6, 10, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1500, 14, 8, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1500, 5, 17, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1500, 12, 9, 10);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1600, 11, 7, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 21), 1600, 15, 19, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1500, 3, 14, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1500, 7, 4, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1500, 9, 2, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1500, 13, 12, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1500, 8, 5, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1500, 18, 6, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1500, 10, 1, 10);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1500, 20, 15, 18);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1600, 17, 11, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 28), 1600, 19, 16, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1500, 1, 9, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1500, 16, 8, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1500, 4, 17, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1500, 2, 7, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1500, 6, 19, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1500, 14, 20, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1500, 5, 18, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1500, 12, 10, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1600, 11, 13, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 35), 1600, 15, 3, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1500, 3, 16, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1500, 7, 15, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1500, 9, 14, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1500, 13, 5, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1500, 8, 12, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1500, 18, 4, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1500, 10, 2, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1500, 20, 6, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1600, 17, 1, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 42), 1600, 19, 11, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1500, 1, 8, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1500, 3, 11, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1500, 2, 16, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1500, 5, 7, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1500, 9, 15, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1500, 10, 13, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1500, 17, 19, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1500, 4, 20, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1600, 6, 14, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 49), 1600, 18, 12, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1500, 16, 5, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1500, 14, 17, 18);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1500, 7, 18, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1500, 12, 6, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1500, 11, 4, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1500, 13, 3, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1500, 8, 9, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1500, 15, 1, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1600, 20, 2, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 56), 1600, 19, 10, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1500, 1, 11, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1500, 3, 8, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1500, 4, 14, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1500, 2, 15, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1500, 6, 13, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1500, 5, 12, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1500, 9, 7, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1500, 18, 19, 24);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1600, 10, 20, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 63), 1600, 17, 16, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1500, 16, 9, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1500, 14, 10, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1500, 7, 1, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1500, 12, 2, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1500, 11, 18, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1500, 13, 17, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1500, 8, 6, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1500, 15, 4, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1600, 20, 3, 24);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 70), 1600, 19, 5, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1500, 1, 13, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1500, 3, 7, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1500, 4, 19, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1500, 2, 8, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1500, 6, 15, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1500, 5, 20, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1500, 9, 11, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1500, 18, 14, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1600, 10, 16, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 77), 1600, 17, 12, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1500, 16, 18, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1500, 14, 5, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1500, 7, 10, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1500, 12, 3, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1500, 11, 6, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1500, 13, 2, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1500, 8, 4, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1500, 15, 17, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1600, 20, 9, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 84), 1600, 19, 1, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1500, 16, 2, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1500, 14, 6, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1500, 7, 5, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1500, 12, 18, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1500, 11, 3, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1500, 13, 10, 10);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1500, 8, 1, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1500, 15, 9, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1600, 20, 4, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 91), 1600, 19, 17, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1500, 1, 15, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1500, 3, 13, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1500, 4, 11, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1500, 2, 20, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1500, 6, 12, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1500, 5, 16, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1500, 9, 8, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1500, 18, 7, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1600, 10, 19, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 98), 1600, 17, 14, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1500, 16, 7, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1500, 3, 2, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1500, 6, 17, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1500, 5, 15, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1500, 12, 1, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1500, 11, 8, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1500, 13, 9, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1600, 10, 4, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1600, 20, 18, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 105), 1600, 19, 14, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1500, 1, 16, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1500, 4, 12, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1500, 2, 6, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1500, 14, 11, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1500, 7, 19, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1500, 9, 5, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1500, 8, 10, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1600, 15, 13, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1600, 18, 3, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 112), 1600, 17, 20, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1500, 16, 4, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1500, 3, 17, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1500, 6, 7, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1500, 5, 2, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1500, 12, 14, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1500, 11, 15, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1500, 13, 8, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1500, 10, 18, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1600, 20, 1, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 119), 1600, 19, 9, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1500, 1, 5, 18);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1500, 2, 11, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1500, 14, 16, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1500, 7, 20, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1500, 9, 3, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1500, 8, 19, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1500, 17, 10, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1600, 4, 6, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1600, 15, 12, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 126), 1600, 18, 13, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1500, 16, 15, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1500, 4, 3, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1500, 2, 1, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1500, 6, 5, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1500, 14, 13, 24);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1500, 12, 11, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1500, 8, 7, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1500, 18, 17, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1600, 10, 9, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 133), 1600, 20, 19, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1500, 1, 6, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1500, 3, 10, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1500, 5, 4, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1500, 7, 12, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1500, 9, 18, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1500, 11, 16, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1500, 13, 20, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1500, 15, 14, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1600, 17, 8, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 140), 1600, 19, 2, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1500, 16, 17, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1500, 14, 18, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1500, 7, 3, 24);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1500, 13, 1, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1500, 8, 2, 18);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1500, 19, 4, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1500, 12, 5, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1500, 11, 9, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1600, 15, 6, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 147), 1600, 20, 10, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1500, 1, 19, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1500, 3, 12, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1500, 4, 8, 18);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1500, 2, 13, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1500, 6, 11, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1500, 5, 14, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1500, 9, 20, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1600, 18, 16, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1600, 10, 7, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 154), 1600, 17, 15, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1500, 16, 10, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1500, 14, 4, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1500, 7, 9, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1500, 12, 17, 8);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1500, 11, 1, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1500, 13, 6, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1500, 8, 3, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1500, 15, 2, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1600, 20, 5, 24);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 161), 1600, 19, 18, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1500, 1, 7, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1500, 3, 20, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1500, 4, 15, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1500, 2, 12, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1500, 6, 8, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1500, 5, 19, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1500, 9, 16, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1600, 18, 11, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1600, 10, 14, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 168), 1600, 17, 13, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1500, 3, 1, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1500, 7, 11, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1500, 9, 12, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1500, 13, 4, 10);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1500, 8, 14, 18);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1500, 18, 2, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1500, 10, 6, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1500, 20, 16, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1600, 17, 5, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 175), 1600, 19, 15, 24);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1500, 1, 18, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1500, 16, 13, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1500, 4, 9, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1500, 2, 17, 18);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1500, 6, 3, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1500, 14, 7, 11);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1500, 5, 10, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1500, 12, 19, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1600, 11, 20, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 182), 1600, 15, 8, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1500, 1, 4, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1500, 3, 5, 25);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1500, 2, 14, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1500, 6, 9, 7);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1500, 12, 16, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1500, 11, 10, 24);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1500, 13, 19, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1500, 8, 20, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1600, 15, 18, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 189), 1600, 17, 7, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1500, 16, 6, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1500, 4, 2, 4);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1500, 14, 1, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1500, 5, 11, 19);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1500, 7, 13, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1500, 9, 17, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1500, 18, 8, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1500, 10, 15, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1600, 20, 12, 30);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 196), 1600, 19, 3, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1500, 1, 10, 21);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1500, 16, 19, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1500, 4, 7, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1500, 2, 9, 22);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1500, 6, 18, 16);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1500, 14, 3, 27);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1500, 5, 8, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1500, 12, 13, 6);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1600, 11, 17, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 203), 1600, 15, 20, 29);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1500, 3, 15, 26);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1500, 7, 2, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1500, 9, 1, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1500, 13, 11, 17);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1500, 8, 16, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1500, 18, 5, 12);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1500, 10, 12, 20);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1500, 20, 14, 1);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1600, 17, 4, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 210), 1600, 19, 6, 10);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1500, 1, 17, 3);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1500, 16, 3, 15);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1500, 4, 18, 14);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1500, 2, 10, 9);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1500, 6, 20, 13);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1500, 14, 9, 5);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1500, 5, 13, 28);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1600, 12, 8, 23);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1600, 11, 19, 2);
INSERT INTO fixture (fixture_date, fixture_time, home_team_id, away_team_id, referee_id) VALUES (ADDDATE(CURDATE(), 217), 1600, 15, 7, 30);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 1, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 2, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 3, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 4, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 5, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 6, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 7, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 8, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 9, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 10, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 11, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 12, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 13, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 14, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 23, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 33, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 42, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 43, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 65, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 101, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 121, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 128, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 142, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 186, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 192, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 232, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 234, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (1, 243, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 16, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 18, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 48, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 82, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 88, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 114, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 117, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 125, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 178, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 189, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 191, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 196, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 209, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 275, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 32, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 46, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 85, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 90, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 103, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 135, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 177, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 188, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 223, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 239, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 257, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 265, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 276, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (2, 280, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 21, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 27, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 54, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 81, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 152, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 173, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 212, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 214, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 225, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 229, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 235, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 236, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 238, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 249, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 20, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 45, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 59, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 60, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 107, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 108, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 124, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 138, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 145, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 183, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 195, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 210, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 244, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (3, 255, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 28, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 58, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 100, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 119, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 122, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 130, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 132, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 165, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 184, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 206, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 218, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 269, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 271, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 286, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 22, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 72, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 78, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 83, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 86, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 91, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 110, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 158, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 164, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 171, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 213, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 248, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 263, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (4, 270, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 47, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 73, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 105, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 113, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 115, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 126, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 127, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 134, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 149, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 176, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 182, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 185, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 285, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 296, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 24, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 26, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 44, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 70, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 99, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 102, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 106, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 150, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 157, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 170, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 172, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 174, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 197, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (5, 198, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 49, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 56, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 74, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 87, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 98, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 116, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 118, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 133, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 144, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 147, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 200, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 272, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 277, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 292, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 17, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 31, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 61, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 64, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 89, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 141, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 167, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 168, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 180, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 205, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 224, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 246, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 262, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (6, 264, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 30, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 34, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 36, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 62, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 77, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 140, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 146, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 155, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 181, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 211, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 233, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 252, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 268, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 278, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 41, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 66, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 79, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 92, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 111, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 162, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 169, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 187, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 207, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 217, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 219, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 240, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 260, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (7, 261, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 40, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 57, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 104, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 120, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 143, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 148, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 153, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 194, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 199, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 201, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 208, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 216, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 221, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 222, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 19, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 38, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 55, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 68, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 75, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 151, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 175, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 231, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 237, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 242, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 253, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 254, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 256, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (8, 258, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 25, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 35, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 53, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 67, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 76, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 95, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 109, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 123, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 154, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 160, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 179, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 203, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 204, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 245, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 29, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 52, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 63, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 136, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 159, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 161, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 166, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 193, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 226, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 230, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 251, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 267, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 279, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (9, 289, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 37, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 39, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 50, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 97, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 112, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 129, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 139, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 156, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 163, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 202, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 215, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 228, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 247, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 281, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 51, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 69, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 71, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 80, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 84, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 93, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 94, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 96, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 131, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 137, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 190, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 220, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 227, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (10, 241, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 19, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 38, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 55, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 68, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 75, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 151, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 175, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 231, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 237, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 242, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 253, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 254, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 256, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 258, 16);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 49, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 56, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 74, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 87, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 98, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 116, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 118, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 133, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 144, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 147, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 200, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 272, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 277, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (11, 292, 11);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 32, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 46, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 85, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 90, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 103, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 135, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 177, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 188, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 223, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 239, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 257, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 265, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 276, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 280, 4);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 21, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 27, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 54, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 81, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 152, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 173, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 212, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 214, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 225, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 229, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 235, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 236, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 238, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (12, 249, 5);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 23, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 33, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 42, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 43, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 65, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 101, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 121, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 128, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 142, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 186, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 192, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 232, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 234, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 243, 2);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 37, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 39, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 50, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 97, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 112, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 129, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 139, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 156, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 163, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 202, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 215, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 228, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 247, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (13, 281, 19);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 20, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 45, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 59, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 60, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 107, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 108, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 124, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 138, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 145, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 183, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 195, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 210, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 244, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 255, 6);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 1, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 2, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 3, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 4, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 5, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 6, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 7, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 8, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 9, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 10, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 11, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 12, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 13, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (14, 14, 1);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 41, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 66, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 79, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 92, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 111, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 162, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 169, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 187, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 207, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 217, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 219, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 240, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 260, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 261, 14);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 40, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 57, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 104, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 120, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 143, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 148, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 153, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 194, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 199, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 201, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 208, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 216, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 221, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (15, 222, 15);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 17, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 31, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 61, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 64, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 89, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 141, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 167, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 168, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 180, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 205, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 224, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 246, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 262, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 264, 12);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 28, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 58, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 100, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 119, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 122, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 130, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 132, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 165, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 184, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 206, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 218, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 269, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 271, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (16, 286, 7);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 22, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 72, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 78, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 83, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 86, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 91, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 110, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 158, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 164, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 171, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 213, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 248, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 263, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 270, 8);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 25, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 35, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 53, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 67, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 76, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 95, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 109, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 123, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 154, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 160, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 179, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 203, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 204, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (17, 245, 17);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 29, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 52, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 63, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 136, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 159, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 161, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 166, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 193, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 226, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 230, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 251, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 267, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 279, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 289, 18);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 47, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 73, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 105, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 113, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 115, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 126, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 127, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 134, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 149, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 176, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 182, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 185, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 285, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (18, 296, 9);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 24, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 26, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 44, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 70, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 99, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 102, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 106, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 150, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 157, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 170, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 172, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 174, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 197, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 198, 10);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 16, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 18, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 48, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 82, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 88, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 114, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 117, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 125, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 178, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 189, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 191, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 196, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 209, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (19, 275, 3);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 51, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 69, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 71, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 80, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 84, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 93, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 94, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 96, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 131, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 137, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 190, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 220, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 227, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 241, 20);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 30, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 34, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 36, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 62, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 77, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 140, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 146, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 155, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 181, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 211, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 233, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 252, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 268, 13);
INSERT INTO fixture_player (fixture_id, player_id, team_id) VALUES (20, 278, 13);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (1, 3, 1);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (1, 4, 1);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (1, 42, 2);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (1, 192, 2);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (2, 88, 3);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (2, 114, 3);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (2, 135, 4);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (3, 27, 5);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (3, 60, 6);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (4, 122, 7);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (4, 286, 7);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (5, 105, 9);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (5, 185, 9);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (5, 44, 10);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (5, 70, 10);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (5, 102, 10);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (6, 277, 11);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (7, 30, 13);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (7, 77, 13);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (7, 140, 13);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (7, 169, 14);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (7, 187, 14);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (8, 199, 15);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (8, 216, 15);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (8, 222, 15);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (9, 203, 17);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (9, 166, 18);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (9, 193, 18);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (9, 279, 18);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (10, 39, 19);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (10, 156, 19);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (10, 228, 19);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (10, 84, 20);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (10, 93, 20);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (11, 175, 16);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (11, 231, 16);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (11, 49, 11);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (11, 98, 11);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (11, 144, 11);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (12, 85, 4);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (12, 135, 4);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (12, 173, 5);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (12, 212, 5);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (13, 232, 2);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (13, 234, 2);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (13, 39, 19);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (13, 215, 19);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (14, 59, 6);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (14, 244, 6);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (14, 255, 6);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (14, 6, 1);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (15, 217, 14);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (16, 58, 7);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (16, 132, 7);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (17, 67, 17);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (18, 63, 18);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (18, 251, 18);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (19, 197, 10);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (19, 125, 3);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (19, 178, 3);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (19, 191, 3);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (20, 30, 13);
INSERT INTO goalscorer (fixture_id, player_id, team_id) VALUES (20, 146, 13);

select * from fulltable;