Warning: getimagesize(./img/logo/race_.gif) [function.getimagesize]: failed to open stream: No such file or directory in /home/users2/u/ultratox/www/lutece/php/page_15.php on line 21
Echec de la requête !SELECT
t1.team_id AS id_home,t1.team_nom AS nom_home,
t2.team_id AS id_visit,t2.team_nom AS nom_visit,
r1.race_id AS race_id_home,r1.race_nom AS race_home,
r2.race_id AS race_id_visit,r2.race_nom AS race_visit,
o1.opp_score AS score_home,o1.opp_valeur AS valeur_home,o1.opp_ab AS ab_home,
o2.opp_score AS score_visit,o2.opp_valeur AS valeur_visit,o2.opp_ab AS ab_visit,
c1.coach_id AS coach_id_home,c1.coach_pseudo AS coach_home,
c2.coach_id AS coach_id_visit,c2.coach_pseudo AS coach_visit,
m.match_id,m.match_day,m.match_public,m.match_meteo,m.match_set
FROM lut_matchs AS m
INNER JOIN lut_matchs_opp AS o1 ON o1.match_id=m.match_id
INNER JOIN lut_matchs_opp AS o2 ON o2.match_id=m.match_id
INNER JOIN lut_teams AS t1 ON t1.champ_id=o1.champ_id
INNER JOIN lut_teams AS t2 ON t2.champ_id=o2.champ_id
INNER JOIN lut_race AS r1 ON r1.race_id=t1.race_id
INNER JOIN lut_race AS r2 ON r2.race_id=t2.race_id
INNER JOIN lut_coachs AS c1 ON c1.coach_id=t1.coach_id
INNER JOIN lut_coachs AS c2 ON c2.coach_id=t2.coach_id
WHERE (o1.champ_id=
OR o2.champ_id=)
AND o1.opp_side='home' AND o2.opp_side='visit'
AND m.match_day<16
UNION
SELECT
t1.team_id AS id_home,t1.team_nom AS nom_home,
t2.team_id AS id_visit,t2.team_nom AS nom_visit,
r1.race_id AS race_id_home,r1.race_nom AS race_home,
r2.race_id AS race_id_visit,r2.race_nom AS race_visit,
o1.opp_score AS score_home,o1.opp_valeur AS valeur_home,o1.opp_ab AS ab_home,
o2.opp_score AS score_visit,o2.opp_valeur AS valeur_visit,o2.opp_ab AS ab_visit,
c1.coach_id AS coach_id_home,c1.coach_pseudo AS coach_home,
c2.coach_id AS coach_id_visit,c2.coach_pseudo AS coach_visit,
m.match_id,m.match_day,m.match_public,m.match_meteo,m.match_set
FROM lut_matchs AS m
INNER JOIN lut_matchs_opp AS o1 ON o1.match_id=m.match_id
INNER JOIN lut_matchs_opp AS o2 ON o2.match_id=m.match_id
INNER JOIN lut_teams AS t1 ON t1.team_id=o1.champ_id
INNER JOIN lut_teams AS t2 ON t2.team_id=o2.champ_id
INNER JOIN lut_race AS r1 ON r1.race_id=t1.race_id
INNER JOIN lut_race AS r2 ON r2.race_id=t2.race_id
INNER JOIN lut_coachs AS c1 ON c1.coach_id=t1.coach_id
INNER JOIN lut_coachs AS c2 ON c2.coach_id=t2.coach_id
WHERE (o1.champ_id=
OR o2.champ_id=)
AND o1.opp_side='home' AND o2.opp_side='visit'
AND m.match_day>15 AND m.match_set='1'
ORDER BY match_day ASC