| Nº |
SQL |
| 0 |
SELECT p.player_id,
p.name,
p.team_id,
p.number,
p.weight,
p.height,
p.date_of_birth,
tc.value AS birth_country,
tp.value AS position_name,
i.basepath,
i.filename,
t.sport_id,
pp.isgoalkeeper
FROM position pp,
translation tp,
team t,
player p
LEFT JOIN image i ON i.image_id = p.photo_image_id
LEFT JOIN country c ON c.country_id = p.birth_country_id
LEFT JOIN translation tc
ON tc.translation_id = c.name_tid AND tc.language_id = :languageid
WHERE p.team_id = t.team_id
AND p.position_id = pp.position_id
AND pp.name_tid = tp.translation_id
AND tp.language_id = :languageid
AND p.player_id = :playerid
|
| 1 |
SELECT `t`.`team_id`, `t`.`name`, `i`.`basepath`, `i`.`filename`, `s`.`basepath` AS `basepath_squad`, `s`.`filename` AS `filename_squad`, `t`.`season`, `t`.`field`, `t`.`sport_id` FROM `team` `t` LEFT OUTER JOIN `image` `i` ON `i`.`image_id` = `t`.`logo_image_id` LEFT OUTER JOIN `image` `s` ON `s`.`image_id` = `t`.`squad_image_id` JOIN `channel_team` `ct` ON `ct`.`team_id` = `t`.`team_id` WHERE `ct`.`channel_id` = '450' AND `t`.`team_id` = '57348' LIMIT 1 |
| 2 |
SELECT `sport_id`, `sport_folder`, `goalkeepers_number`, `players_number` FROM `sport` WHERE `sport_id` = '1' LIMIT 1 |
| 3 |
SELECT `s`.`staff_id`, `s`.`name`, `s`.`staff_position`, `i`.`basepath`, `i`.`filename`, `s`.`is_main_coach` FROM `staff` `s` LEFT OUTER JOIN `image` `i` ON `i`.`image_id` = `s`.`photo_image_id` WHERE `s`.`team_id` = '57348' ORDER BY `s`.`is_main_coach` DESC |
| 4 |
SELECT `parent_match_type_id`, `match_type_id` FROM `channel_default_fixture` WHERE `channel_id` = '450' LIMIT 1 |
| 5 |
SELECT m.match_type_id
FROM `match` m, channel_match cm
WHERE m.match_id = cm.match_id AND cm.channel_id = :channelid
ORDER BY m.date ASC
LIMIT 1
|
| 6 |
SELECT `u`.`sport_id` FROM `channel` `c` JOIN `user` `u` ON `u`.`user_id` = `c`.`owner_user_id` WHERE `c`.`channel_id` = '450' LIMIT 1 |
| 7 |
SELECT m.match_id,
m.`date`,
m.field,
th.team_id AS home_team_id,
th.name AS home_team,
hg.goal AS stats_goal_home,
m.goals_home,
ta.team_id AS away_team_id,
ta.name AS away_team,
ag.goal AS stats_goal_away,
m.goals_away,
hi.basepath AS home_basepath,
hi.filename AS home_filename,
ai.basepath AS away_basepath,
ai.filename AS away_filename,
m.description,
m.match_type_id,
mt.name AS match_type,
mt.parent_match_type_id,
mtp.name AS match_type_parent
FROM channel_match cm,
team th
LEFT JOIN
image hi
ON hi.image_id = th.logo_image_id
JOIN
team ta
LEFT JOIN
image ai
ON ai.image_id = ta.logo_image_id
JOIN
`match` m
LEFT JOIN
match_type mt
ON mt.match_type_id = m.match_type_id
LEFT JOIN
match_type mtp
ON mt.parent_match_type_id = mtp.match_type_id
LEFT JOIN
statistics_handball_team hg
ON hg.match_id = m.match_id AND hg.team_id = m.home_team_id
LEFT JOIN
statistics_handball_team ag
ON ag.match_id = m.match_id AND ag.team_id = m.away_team_id
WHERE m.match_id = cm.match_id
AND cm.channel_id = :channel_id
AND m.match_type_id = :match_type_id
AND m.sport_id = :sport_id
AND m.home_team_id = th.team_id
AND m.away_team_id = ta.team_id
ORDER BY m.`date` DESC
|
| 8 |
SELECT `match_type_id`, `parent_match_type_id`, `name` FROM `match_type` WHERE `channel_id` = '450' |
| 9 |
SELECT `action_id`, `color`, `text_color` FROM `action` WHERE `sport_id` = '1' |
| 10 |
SELECT SUM(shot+fast_break) AS shot,
SUM(missed) AS missed,
SUM(blocked) AS blocked,
SUM(saved) AS saved,
SUM(goal) AS goal,
SUM(assist) AS assist,
SUM(yellow_card) AS yellow_card,
SUM(red_card) AS red_card,
SUM(two_minutes) AS two_minutes,
SUM(seven_meters) AS seven_meters,
SUM(seven_meters_goal) AS seven_meters_goal,
SUM(seven_meters_missed) AS seven_meters_missed,
SUM(seven_meters_saved) AS seven_meters_saved,
SUM(shots_zone_6m) AS shots_zone_6m,
SUM(shots_zone_9m) AS shots_zone_9m,
SUM(shots_zone_wing) AS shots_zone_wing,
SUM(goals_zone_6m) AS goals_zone_6m,
SUM(goals_zone_9m) AS goals_zone_9m,
SUM(goals_zone_wing) AS goals_zone_wing,
COUNT(match_id) as count_matches
FROM statistics_handball_player
WHERE player_id = :playerid
|
| 11 |
SELECT DISTINCT e.event_id,
e.match_id,
e.start_position_x,
e.start_position_y,
e.end_position_x,
e.end_position_y,
e.goal_position_x,
e.goal_position_y,
e.video_time,
e.match_time AS game_time,
e.team_id,
e.direction,
action.action_id
FROM event e,
match_player mp,
event_action ea,
(SELECT ea.action_id, ea.event_id
FROM event_action ea
JOIN
(SELECT MAX(ea.position) AS maxposition, ea.event_id
FROM event e, event_action ea, match_player mp
WHERE e.event_id = ea.event_id
AND mp.match_player_id = e.start_player_id
AND mp.player_id = :playerid
GROUP BY ea.event_id) eas
ON ea.event_id = eas.event_id
AND ea.position = eas.maxposition) AS action
WHERE mp.match_player_id = e.start_player_id
AND mp.player_id = :playerid
AND e.event_id = ea.event_id
AND ea.action_id IN (11,14,12,32)
AND e.event_id = action.event_id
AND e.event_id NOT IN
(SELECT e.event_id
FROM event e, event_action ea, match_player mp
WHERE mp.match_player_id = e.start_player_id
AND mp.player_id = :playerid
AND e.event_id = ea.event_id
AND ea.action_id IN (13))
ORDER BY e.event_id ASC, e.video_time
|
| 12 |
SELECT DISTINCT e.event_id,
e.match_id,
e.start_position_x,
e.start_position_y,
e.end_position_x,
e.end_position_y,
e.goal_position_x,
e.goal_position_y,
e.video_time,
e.match_time AS game_time,
e.team_id,
e.direction,
action.action_id
FROM event e,
match_player mp,
event_action ea,
(SELECT ea.action_id, ea.event_id
FROM event_action ea
JOIN
(SELECT MAX(ea.position) AS maxposition, ea.event_id
FROM event e, event_action ea, match_player mp
WHERE e.event_id = ea.event_id
AND mp.match_player_id = e.start_player_id
AND mp.player_id = :playerid
GROUP BY ea.event_id) eas
ON ea.event_id = eas.event_id
AND ea.position = eas.maxposition) AS action
WHERE mp.match_player_id = e.start_player_id
AND mp.player_id = :playerid
AND e.event_id = ea.event_id
AND ea.action_id IN (32)
AND e.event_id = action.event_id
AND e.event_id NOT IN
(SELECT e.event_id
FROM event e, event_action ea, match_player mp
WHERE mp.match_player_id = e.start_player_id
AND mp.player_id = :playerid
AND e.event_id = ea.event_id
AND ea.action_id IN (13))
ORDER BY e.event_id ASC, e.video_time
|
| 13 |
SELECT `t`.`team_id`, `t`.`name`, `i`.`basepath`, `i`.`filename`, `t`.`color_home`, `t`.`text_color_home`, `t`.`color_away`, `t`.`text_color_away` FROM `team` `t` LEFT OUTER JOIN `image` `i` ON `i`.`image_id` = `t`.`logo_image_id` JOIN `channel_team` `ct` ON `ct`.`team_id` = `t`.`team_id` WHERE `ct`.`channel_id` = '450' ORDER BY `t`.`name` ASC |
