$sql = "SELECT `$module_table_name`.`pickem_id`, `$module_table_name`.`division_id`, `$module_table_name`.`match_date`, `$module_table_name`.`home_team_id`, `$module_table_name`.`away_team_id`, `home_team`.`opponent_name` AS `home_team_name`, `away_team`.`opponent_name` AS `away_team_name` FROM `$module_table_name` LEFT JOIN `jcp_divisions` ON `$module_table_name`.`division_id` = `jcp_divisions`.`division_id` LEFT JOIN `jcp_leagues` ON `$module_table_name`.`league_id` = `jcp_leagues`.`league_id` LEFT JOIN `jcp_opponents` AS `home_team` ON `$module_table_name`.`home_team_id` = `home_team`.`opponent_id` LEFT JOIN `jcp_opponents` AS `away_team` ON `$module_table_name`.`away_team_id` = `away_team`.`opponent_id` ";