CREATE DEFINER=`root`@`localhost` PROCEDURE `cbtl`()
BEGIN
				DROP TABLE IF EXISTS t;
CREATE TEMPORARY TABLE t (`id` int NOT NULL auto_increment,score INT, alias VARCHAR(255), gid INT, email varchar(255), date_played BIGINT, PRIMARY KEY(id));


         insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =1 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =5 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

 insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =6 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

 insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =7 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

 insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =8 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

 insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =9 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =10 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =11 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

           insert into t (`id`,`score`,`alias`, `gid`, `email`,`date_played`)
	SELECT null, max(hiscore.score) as score,
             `user`.alias as alias,
            fk_game_id as gid,
            user_extra_data.value as email2,
date_played

            FROM
            hiscore
            Inner Join `user` ON hiscore.fk_player_id = `user`.id
            inner Join user_extra_data ON user_extra_data.fk_id = `user`.id
            where hiscore.fk_game_id  =12 AND user_extra_data.name = 'email'
           group by email2 order by score DESC, date_played ASC;

select sum(score) as s, alias, email from t group by email order by s desc;
END