mysql causing page to load slow

I have a page on my site that is loading slow. I know where the issue is since I take that particular code out and it loads quickly. the issues lies within the $select_data. If they are all taken out it loads quickly. I need someone that can fix the issue(s) and make this load quick again :) here is the code //THERE IS MORE CODE HERE $select_data .= ", (SELECT count(*) FROM goalinfo WHERE goaltype = 3 and seasonid = $open_season and (assist1 = [login to view URL] or assist2 = [login to view URL])) as sha"; $select_data .= ", (SELECT count(*) FROM goalinfo WHERE goaltype = 0 and seasonid = $open_season and ([login to view URL] = assist1 or [login to view URL] = assist2) ) as ppa"; $select_data .= ", (SELECT count(*) FROM goalinfo WHERE [login to view URL] = playerid and seasonid = $open_season and (goalperiod = 4 or goalperiod =5)) as otg"; $select_data .= ", (SELECT count(*) FROM goalinfo WHERE seasonid = $open_season and (goalperiod = 4 or goalperiod =5) AND ([login to view URL] = assist1 or [login to view URL] = assist2) ) as ota"; $output_sql = "SELECT $select_data, [login to view URL] as gwg, [login to view URL] as gtg, [login to view URL] as fow, [login to view URL] as fol FROM player_stats, teams, schedule_scores, players, player_stats_additional WHERE [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL] AND players.ext_key = player_stats_additional.ext_key AND [login to view URL] = '" . $this->leagueId . "' AND player_stats.game_id = [login to view URL] $where_sql AND [login to view URL] = $open_season GROUP BY [login to view URL] ORDER BY $order_by_sql"; //MORE CODE HERE