Топ всех времён. Скрипт для базы данных JL 1.6 - JoomLeague

SELECT pl_g.goals, pl_m.games, pl_g.goals / pl_m.games AS goals_per_game, pl_g.name, pl_g.p_id
FROM (
	SELECT CONCAT(p.firstname, ' ', p.lastname) AS name, COUNT(mp.id) AS games, p.id AS p_id
	FROM jos_joomleague_match_player AS mp
	JOIN jos_joomleague_match AS m ON mp.match_id = m.id
	JOIN jos_joomleague_team_player AS tp ON mp.teamplayer_id = tp.id
	JOIN jos_joomleague_person AS p ON tp.person_id = p.id
	JOIN jos_joomleague_project_team AS pt ON tp.projectteam_id = pt.id
	JOIN jos_joomleague_project AS pr ON pt.project_id = pr.id
	WHERE m.published = 1
		AND m.alt_decision != 1
		AND pr.sports_type_id = 5            /* Выделение нужного вида спорта */
		AND pr.id NOT IN(47,70,82,85)     /* Исключение ненужных проектов */
	GROUP BY p.id 
	) AS pl_m
JOIN (
    SELECT CONCAT(p.firstname, ' ', p.lastname) AS name, SUM(me.event_sum) AS goals, p.id AS p_id
	FROM jos_joomleague_match_event AS me
		JOIN jos_joomleague_project_team AS pt ON me.projectteam_id = pt.id
		JOIN jos_joomleague_project AS pr ON pt.project_id = pr.id
		JOIN jos_joomleague_team_player AS tp ON me.teamplayer_id = tp.id
		JOIN jos_joomleague_person AS p ON tp.person_id = p.id
		JOIN jos_joomleague_match AS m ON me.match_id = m.id
	WHERE me.event_type_id IN ( 1 )         /* id события. Если больше одного, то указать через запятую */
		AND m.alt_decision != 1 
		AND pr.sports_type_id = 5           /* Выделение нужного вида спорта */
		AND pr.id NOT IN(47,70,82,85)    / * Исключение ненужных проектов */
	GROUP BY p.id 
	) AS pl_g
WHERE pl_m.p_id = pl_g.p_id
	AND (pl_g.goals > 60 OR pl_m.games > 40)               /* Минимум забитых голов или сыгранных матчей */
ORDER BY goals_per_game DESC