| 0.0001 |
SELECT *
FROM (`core_leagues`)
WHERE `league_active` = 1
ORDER BY `league_name` ASC
|
| 0.0001 |
SELECT C.ID_CUP AS ID_CUP, C.cup_name AS cup_name, C.cup_abbrev AS cupAbbrev, L.abbrev AS leagueAbbrev
FROM core_cups C
JOIN core_leagues L ON (L.ID_LEAGUE = C.ID_LEAGUE)
WHERE C.ID_LEAGUE = 0
ORDER BY C.cup_name
|
| 0.0000 |
SELECT C.ID_CUP, C.cup_name AS cup_name, a.name as assoc
FROM core_cups C
JOIN core_assoc a ON (a.id = C.assoc_id)
WHERE C.active = "yes"
ORDER BY C.assoc_id, C.cup_name
|
| 0.0001 |
SELECT *
FROM core_teams T
JOIN core_division_teams TD ON (TD.ID_TEAM = T.ID_TEAM)
JOIN core_divisions D ON (D.ID_DIVISION = TD.ID_DIVISION)
JOIN core_seasons S ON (S.ID_SEASON = TD.ID_SEASON)
WHERE T.ID_TEAM = '396'
ORDER BY S.ID_SEASON DESC
LIMIT 1
|
| 0.0000 |
SELECT *
FROM (`core_divisions`)
WHERE `ID_DIVISION` = '31'
|
| 0.0000 |
SELECT *
FROM (`core_leagues`)
WHERE `ID_LEAGUE` = '7'
|
| 0.0002 |
SELECT *
FROM (`core_teams` t)
WHERE `t`.`ID_TEAM` = '396'
|
| 0.0001 |
SELECT *
FROM (`core_leagues`)
WHERE `ID_LEAGUE` = '7'
|
| 0.0000 |
SELECT *
FROM (`core_divisions`)
WHERE `ID_DIVISION` = '31'
|
| 0.0097 |
SELECT `P`.`ID_PLAYER`, `P`.`firstname`, `P`.`lastname`, `P`.`position`
FROM (`core_players` P)
LEFT JOIN `core_player_appearances` A ON `P`.`ID_PLAYER` = `A`.`ID_PLAYER` AND A.ID_SEASON = '8'
LEFT JOIN `core_player_substitutes` S ON `P`.`ID_PLAYER` = `S`.`ID_PLAYER` AND S.ID_SEASON ='8'
JOIN `core_teams` T ON `A`.`ID_TEAM` = `T`.`ID_TEAM` OR S.ID_TEAM = T.ID_TEAM
WHERE `T`.`ID_TEAM` = '396'
|
| 0.0000 |
SELECT *
FROM (`core_seasons`)
WHERE `ID_SEASON` = '8'
|
| 0.0000 |
SELECT *
FROM (`core_leagues`)
WHERE `ID_LEAGUE` = '7'
|
| 0.0000 |
SELECT IFNULL( dc.new_division_name, d.division_name ) as division_name, d.ID_DIVISION
FROM core_divisions d
LEFT JOIN core_division_changes dc ON ( d.ID_DIVISION = dc.division_id AND dc.season_id = '8' )
LEFT JOIN core_division_details dt ON ( d.ID_division = dt.ID_DIVISION AND dt.ID_SEASON = '8')
WHERE dt.ID_DIVISION = '31' AND dt.ID_SEASON = '8'
|
| 0.0001 |
SELECT *
FROM (`core_leagues`)
WHERE `league_active` = 1
ORDER BY `league_name` ASC
|
| 0.0001 |
SELECT
t.team_name AS opponent,
t.ID_TEAM AS opponent_id,
ht.team_name AS hometeam,
at.team_name AS awayteam,
LM.home_goals AS goals_home,
LM.away_goals AS goals_away,
N.id AS report_id,
LM.info AS info,
LM.extraInfo AS extraInfo,
LM.ID_MATCH,
DATE_FORMAT(LM.match_date, '%d/%m/%y') AS date,
division_name,
cup_name,
description
FROM core_matches LM
JOIN core_teams t ON ( t.ID_TEAM = IF( LM.ID_HOME_TEAM = '396', LM.ID_AWAY_TEAM, LM.ID_HOME_TEAM ) )
JOIN core_teams ht ON (ht.ID_TEAM = LM.ID_HOME_TEAM )
JOIN core_teams at ON (at.ID_TEAM = LM.ID_AWAY_TEAM)
LEFT JOIN core_divisions D ON (LM.ID_DIVISION = D.ID_DIVISION)
LEFT JOIN core_cups ON (LM.ID_CUP = core_cups.ID_CUP)
LEFT JOIN core_rounds R ON (LM.ID_ROUND = R.ID_ROUND)
LEFT JOIN core_news N ON (N.match_id = LM.ID_MATCH AND N.team_id = '396')
WHERE (LM.ID_HOME_TEAM = '396' OR LM.ID_AWAY_TEAM = '396')
AND LM.ID_SEASON = '8'
ORDER BY LM.match_date, division_name, cup_name
LIMIT 50
|
