SELECT M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, M.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, T.id tournament_id
, T.idt tournament_idt
, '?' rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, T.ville tournament_city
, T.stade tournament_stadium
, T.surface tournament_surface
, T.surface_photo tournament_surface_photo
, T.surface_color tournament_surface_color
, T.monnaie tournament_currency
, T.prix tournament_prize_money
, SCO.nom_fr tournament_country
, T.logo tournament_logo
, T.debut tournament_start
, T.fin tournament_end
, T.nbj tournament_nbPlayer
, T.genre tournament_genre
, T.category tournament_category
, T.type tournament_type
, T.ids tournament_site
, T.year tournament_year
, T.importance tournament_importance
, '' team1
, '' team2
, T.importance
, T.background tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, C.nom court_name
, C.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
INNER JOIN tournois T on T.id = M.idt
INNER JOIN tournois_name N on N.id = T.id && N.cup = 0
LEFT OUTER JOIN lieux_sites SL on T.ids = SL.id
LEFT OUTER JOIN lieux_villes SC on SL.idv = SC.id
LEFT OUTER JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT OUTER JOIN `livescores_new`.`matchs` LS on LS.tt_match_id = M.id
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts C on C.ids = S.ids && C.ordre = S.court
WHERE
M.id = '9445306'
&& M.type_tournoi_add = 0
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, CR.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, C.id tournament_id
, C.parent tournament_idt
, CR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, CONCAT(CR.equipe_domicile, '|', CR.equipe_exterieur) tournament_city
, '' tournament_stadium
, CR.surface tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, CR.date_d tournament_start
, '' tournament_end
, C.nbj tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, CR.lieu tournament_site
, '' tournament_year
, 65 tournament_importance
, IF(T1.nom_fr, T1.nom_fr, CR.equipe_domicile) team1
, IF(T2.nom_fr, T1.nom_fr, CR.equipe_exterieur) team2
, 65 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT OUTER JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
INNER JOIN `coupes_rencontres` CR on CR.id = M.idt
INNER JOIN `coupes` C on C.id = CR.coupe_id
INNER JOIN tournois_name N on N.id = C.id
LEFT JOIN lieux_sites SL on SL.id = CR.lieu
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT JOIN `lieux_pays` T1 ON (T1.code = CR.equipe_domicile)
LEFT JOIN `lieux_pays` T2 ON (T2.code = CR.equipe_exterieur)
WHERE
M.id = '9445306'
&& M.type_tournoi_add = 1
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, '' level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, L.id tournament_id
, 0 tournament_idt
, LR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, SC.nom tournament_city
, '' tournament_stadium
, '3' tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, L.time_start tournament_start
, '' tournament_end
, '' tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, LR.site tournament_site
, L.year tournament_year
, 0 tournament_importance
, '' team1
, '' team2
, 3 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
JOIN joueurs P1 on P1.id = M.j1
LEFT JOIN `joueurs` P1B on P1B.id = M.j1_bis
JOIN joueurs P2 on P2.id = M.j2
LEFT JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT JOIN tournois_programmes S on S.idm = M.id
LEFT JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
JOIN `leagues_rounds` LR on LR.id = M.league_round
JOIN `leagues` L on L.id = LR.league
JOIN tournois_name N on N.league = L.id
LEFT JOIN lieux_sites SL on SL.id = LR.site
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
WHERE
M.id = '9445306'
&& M.type_tournoi_add = 2
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
LIMIT 1
SELECT M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, M.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, T.id tournament_id
, T.idt tournament_idt
, '?' rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, T.ville tournament_city
, T.stade tournament_stadium
, T.surface tournament_surface
, T.surface_photo tournament_surface_photo
, T.surface_color tournament_surface_color
, T.monnaie tournament_currency
, T.prix tournament_prize_money
, SCO.nom_fr tournament_country
, T.logo tournament_logo
, T.debut tournament_start
, T.fin tournament_end
, T.nbj tournament_nbPlayer
, T.genre tournament_genre
, T.category tournament_category
, T.type tournament_type
, T.ids tournament_site
, T.year tournament_year
, T.importance tournament_importance
, '' team1
, '' team2
, T.importance
, T.background tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, C.nom court_name
, C.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
INNER JOIN tournois T on T.id = M.idt
INNER JOIN tournois_name N on N.id = T.id && N.cup = 0
LEFT OUTER JOIN lieux_sites SL on T.ids = SL.id
LEFT OUTER JOIN lieux_villes SC on SL.idv = SC.id
LEFT OUTER JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT OUTER JOIN `livescores_new`.`matchs` LS on LS.tt_match_id = M.id
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts C on C.ids = S.ids && C.ordre = S.court
WHERE
M.id = '9445079'
&& M.type_tournoi_add = 0
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, CR.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, C.id tournament_id
, C.parent tournament_idt
, CR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, CONCAT(CR.equipe_domicile, '|', CR.equipe_exterieur) tournament_city
, '' tournament_stadium
, CR.surface tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, CR.date_d tournament_start
, '' tournament_end
, C.nbj tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, CR.lieu tournament_site
, '' tournament_year
, 65 tournament_importance
, IF(T1.nom_fr, T1.nom_fr, CR.equipe_domicile) team1
, IF(T2.nom_fr, T1.nom_fr, CR.equipe_exterieur) team2
, 65 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT OUTER JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
INNER JOIN `coupes_rencontres` CR on CR.id = M.idt
INNER JOIN `coupes` C on C.id = CR.coupe_id
INNER JOIN tournois_name N on N.id = C.id
LEFT JOIN lieux_sites SL on SL.id = CR.lieu
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT JOIN `lieux_pays` T1 ON (T1.code = CR.equipe_domicile)
LEFT JOIN `lieux_pays` T2 ON (T2.code = CR.equipe_exterieur)
WHERE
M.id = '9445079'
&& M.type_tournoi_add = 1
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, '' level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, L.id tournament_id
, 0 tournament_idt
, LR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, SC.nom tournament_city
, '' tournament_stadium
, '3' tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, L.time_start tournament_start
, '' tournament_end
, '' tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, LR.site tournament_site
, L.year tournament_year
, 0 tournament_importance
, '' team1
, '' team2
, 3 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
JOIN joueurs P1 on P1.id = M.j1
LEFT JOIN `joueurs` P1B on P1B.id = M.j1_bis
JOIN joueurs P2 on P2.id = M.j2
LEFT JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT JOIN tournois_programmes S on S.idm = M.id
LEFT JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
JOIN `leagues_rounds` LR on LR.id = M.league_round
JOIN `leagues` L on L.id = LR.league
JOIN tournois_name N on N.league = L.id
LEFT JOIN lieux_sites SL on SL.id = LR.site
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
WHERE
M.id = '9445079'
&& M.type_tournoi_add = 2
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
LIMIT 1
SELECT M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, M.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, T.id tournament_id
, T.idt tournament_idt
, '?' rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, T.ville tournament_city
, T.stade tournament_stadium
, T.surface tournament_surface
, T.surface_photo tournament_surface_photo
, T.surface_color tournament_surface_color
, T.monnaie tournament_currency
, T.prix tournament_prize_money
, SCO.nom_fr tournament_country
, T.logo tournament_logo
, T.debut tournament_start
, T.fin tournament_end
, T.nbj tournament_nbPlayer
, T.genre tournament_genre
, T.category tournament_category
, T.type tournament_type
, T.ids tournament_site
, T.year tournament_year
, T.importance tournament_importance
, '' team1
, '' team2
, T.importance
, T.background tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, C.nom court_name
, C.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
INNER JOIN tournois T on T.id = M.idt
INNER JOIN tournois_name N on N.id = T.id && N.cup = 0
LEFT OUTER JOIN lieux_sites SL on T.ids = SL.id
LEFT OUTER JOIN lieux_villes SC on SL.idv = SC.id
LEFT OUTER JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT OUTER JOIN `livescores_new`.`matchs` LS on LS.tt_match_id = M.id
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts C on C.ids = S.ids && C.ordre = S.court
WHERE
M.id = '9445080'
&& M.type_tournoi_add = 0
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, CR.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, C.id tournament_id
, C.parent tournament_idt
, CR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, CONCAT(CR.equipe_domicile, '|', CR.equipe_exterieur) tournament_city
, '' tournament_stadium
, CR.surface tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, CR.date_d tournament_start
, '' tournament_end
, C.nbj tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, CR.lieu tournament_site
, '' tournament_year
, 65 tournament_importance
, IF(T1.nom_fr, T1.nom_fr, CR.equipe_domicile) team1
, IF(T2.nom_fr, T1.nom_fr, CR.equipe_exterieur) team2
, 65 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT OUTER JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
INNER JOIN `coupes_rencontres` CR on CR.id = M.idt
INNER JOIN `coupes` C on C.id = CR.coupe_id
INNER JOIN tournois_name N on N.id = C.id
LEFT JOIN lieux_sites SL on SL.id = CR.lieu
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT JOIN `lieux_pays` T1 ON (T1.code = CR.equipe_domicile)
LEFT JOIN `lieux_pays` T2 ON (T2.code = CR.equipe_exterieur)
WHERE
M.id = '9445080'
&& M.type_tournoi_add = 1
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, '' level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, L.id tournament_id
, 0 tournament_idt
, LR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, SC.nom tournament_city
, '' tournament_stadium
, '3' tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, L.time_start tournament_start
, '' tournament_end
, '' tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, LR.site tournament_site
, L.year tournament_year
, 0 tournament_importance
, '' team1
, '' team2
, 3 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
JOIN joueurs P1 on P1.id = M.j1
LEFT JOIN `joueurs` P1B on P1B.id = M.j1_bis
JOIN joueurs P2 on P2.id = M.j2
LEFT JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT JOIN tournois_programmes S on S.idm = M.id
LEFT JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
JOIN `leagues_rounds` LR on LR.id = M.league_round
JOIN `leagues` L on L.id = LR.league
JOIN tournois_name N on N.league = L.id
LEFT JOIN lieux_sites SL on SL.id = LR.site
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
WHERE
M.id = '9445080'
&& M.type_tournoi_add = 2
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
LIMIT 1
SELECT M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, M.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, T.id tournament_id
, T.idt tournament_idt
, '?' rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, T.ville tournament_city
, T.stade tournament_stadium
, T.surface tournament_surface
, T.surface_photo tournament_surface_photo
, T.surface_color tournament_surface_color
, T.monnaie tournament_currency
, T.prix tournament_prize_money
, SCO.nom_fr tournament_country
, T.logo tournament_logo
, T.debut tournament_start
, T.fin tournament_end
, T.nbj tournament_nbPlayer
, T.genre tournament_genre
, T.category tournament_category
, T.type tournament_type
, T.ids tournament_site
, T.year tournament_year
, T.importance tournament_importance
, '' team1
, '' team2
, T.importance
, T.background tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, C.nom court_name
, C.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
INNER JOIN tournois T on T.id = M.idt
INNER JOIN tournois_name N on N.id = T.id && N.cup = 0
LEFT OUTER JOIN lieux_sites SL on T.ids = SL.id
LEFT OUTER JOIN lieux_villes SC on SL.idv = SC.id
LEFT OUTER JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT OUTER JOIN `livescores_new`.`matchs` LS on LS.tt_match_id = M.id
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts C on C.ids = S.ids && C.ordre = S.court
WHERE
M.id = '3977851'
&& M.type_tournoi_add = 0
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, CR.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, C.id tournament_id
, C.parent tournament_idt
, CR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, CONCAT(CR.equipe_domicile, '|', CR.equipe_exterieur) tournament_city
, '' tournament_stadium
, CR.surface tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, CR.date_d tournament_start
, '' tournament_end
, C.nbj tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, CR.lieu tournament_site
, '' tournament_year
, 65 tournament_importance
, IF(T1.nom_fr, T1.nom_fr, CR.equipe_domicile) team1
, IF(T2.nom_fr, T1.nom_fr, CR.equipe_exterieur) team2
, 65 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT OUTER JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
INNER JOIN `coupes_rencontres` CR on CR.id = M.idt
INNER JOIN `coupes` C on C.id = CR.coupe_id
INNER JOIN tournois_name N on N.id = C.id
LEFT JOIN lieux_sites SL on SL.id = CR.lieu
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT JOIN `lieux_pays` T1 ON (T1.code = CR.equipe_domicile)
LEFT JOIN `lieux_pays` T2 ON (T2.code = CR.equipe_exterieur)
WHERE
M.id = '3977851'
&& M.type_tournoi_add = 1
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, '' level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, L.id tournament_id
, 0 tournament_idt
, LR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, SC.nom tournament_city
, '' tournament_stadium
, '3' tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, L.time_start tournament_start
, '' tournament_end
, '' tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, LR.site tournament_site
, L.year tournament_year
, 0 tournament_importance
, '' team1
, '' team2
, 3 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
JOIN joueurs P1 on P1.id = M.j1
LEFT JOIN `joueurs` P1B on P1B.id = M.j1_bis
JOIN joueurs P2 on P2.id = M.j2
LEFT JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT JOIN tournois_programmes S on S.idm = M.id
LEFT JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
JOIN `leagues_rounds` LR on LR.id = M.league_round
JOIN `leagues` L on L.id = LR.league
JOIN tournois_name N on N.league = L.id
LEFT JOIN lieux_sites SL on SL.id = LR.site
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
WHERE
M.id = '3977851'
&& M.type_tournoi_add = 2
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
LIMIT 1
SELECT M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, M.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, T.id tournament_id
, T.idt tournament_idt
, '?' rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, T.ville tournament_city
, T.stade tournament_stadium
, T.surface tournament_surface
, T.surface_photo tournament_surface_photo
, T.surface_color tournament_surface_color
, T.monnaie tournament_currency
, T.prix tournament_prize_money
, SCO.nom_fr tournament_country
, T.logo tournament_logo
, T.debut tournament_start
, T.fin tournament_end
, T.nbj tournament_nbPlayer
, T.genre tournament_genre
, T.category tournament_category
, T.type tournament_type
, T.ids tournament_site
, T.year tournament_year
, T.importance tournament_importance
, '' team1
, '' team2
, T.importance
, T.background tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, C.nom court_name
, C.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
INNER JOIN tournois T on T.id = M.idt
INNER JOIN tournois_name N on N.id = T.id && N.cup = 0
LEFT OUTER JOIN lieux_sites SL on T.ids = SL.id
LEFT OUTER JOIN lieux_villes SC on SL.idv = SC.id
LEFT OUTER JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT OUTER JOIN `livescores_new`.`matchs` LS on LS.tt_match_id = M.id
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts C on C.ids = S.ids && C.ordre = S.court
WHERE
M.id = '54225'
&& M.type_tournoi_add = 0
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, CR.niveau level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, C.id tournament_id
, C.parent tournament_idt
, CR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, CONCAT(CR.equipe_domicile, '|', CR.equipe_exterieur) tournament_city
, '' tournament_stadium
, CR.surface tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, CR.date_d tournament_start
, '' tournament_end
, C.nbj tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, CR.lieu tournament_site
, '' tournament_year
, 65 tournament_importance
, IF(T1.nom_fr, T1.nom_fr, CR.equipe_domicile) team1
, IF(T2.nom_fr, T1.nom_fr, CR.equipe_exterieur) team2
, 65 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
INNER JOIN joueurs P1 on P1.id = M.j1
LEFT OUTER JOIN `joueurs` P1B on P1B.id = M.j1_bis
INNER JOIN joueurs P2 on P2.id = M.j2
LEFT OUTER JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT OUTER JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT OUTER JOIN tournois_programmes S on S.idm = M.id
LEFT OUTER JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
INNER JOIN `coupes_rencontres` CR on CR.id = M.idt
INNER JOIN `coupes` C on C.id = CR.coupe_id
INNER JOIN tournois_name N on N.id = C.id
LEFT JOIN lieux_sites SL on SL.id = CR.lieu
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
LEFT JOIN `lieux_pays` T1 ON (T1.code = CR.equipe_domicile)
LEFT JOIN `lieux_pays` T2 ON (T2.code = CR.equipe_exterieur)
WHERE
M.id = '54225'
&& M.type_tournoi_add = 1
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
UNION
SELECT
M.*
, M.time_start time_start
, M.time time_end
, M.duration_pause
, M.type_match_add type_match
, M.type_tournoi_add type_tournament
, '' level
, M.qualif
, M.idw winner_id
, P1.id p1_id
, P1.nom p1_name
, P1.prenom p1_first_name
, P1.name_zh p1_name_zh
, P1.birthday p1_birthday
, P1.sexe p1_gender
, P1.nat p1_nat
, P1.photo p1_photo
, P1.taille p1_height
, P1.poids p1_weight
, R1.rank p1_rank
, R1.liveRank p1_rank_live
, P1.pro_depuis p1_turn_pro
, '?' p1_best_rank
, P1.prise p1_forehand
, P1.revers p1_backhand
, M.ts1 p1_seed
, P1B.id p1b_id
, P1B.nom p1b_name
, P1B.prenom p1b_first_name
, P1B.name_zh p1b_name_zh
, P1B.birthday p1b_birthday
, P1B.sexe p1b_gender
, P1B.nat p1b_nat
, P1B.photo p1b_photo
, P1B.taille p1b_height
, P1B.poids p1b_weight
, R1B.rank p1b_rank
, R1B.liveRank p1b_rank_live
, P1B.pro_depuis p1b_turn_pro
, P2.id p2_id
, P2.nom p2_name
, P2.prenom p2_first_name
, P2.name_zh p2_name_zh
, P2.birthday p2_birthday
, P2.sexe p2_gender
, P2.nat p2_nat
, P2.photo p2_photo
, P2.taille p2_height
, P2.poids p2_weight
, R2.rank p2_rank
, R2.liveRank p2_rank_live
, P2.pro_depuis p2_turn_pro
, '?' p2_best_rank
, P2.prise p2_forehand
, P2.revers p2_backhand
, M.ts2 p2_seed
, P2B.id p2b_id
, P2B.nom p2b_name
, P2B.prenom p2b_first_name
, P2B.name_zh p2b_name_zh
, P2B.birthday p2b_birthday
, P2B.sexe p2b_gender
, P2B.nat p2b_nat
, P2B.photo p2b_photo
, P2B.taille p2b_height
, P2B.poids p2b_weight
, R2B.rank p2b_rank
, R2B.liveRank p2b_rank_live
, P2B.pro_depuis p2b_turn_pro
, L.id tournament_id
, 0 tournament_idt
, LR.id rencontre_id
, N.name_fr tournament_name_fr
, N.name_en tournament_name_en
, N.name_zh tournament_name_zh
, N.name_de tournament_name_de
, N.name_es tournament_name_es
, SC.nom tournament_city
, '' tournament_stadium
, '3' tournament_surface
, '' tournament_surface_photo
, '0' tournament_surface_color
, '' tournament_currency
, '' tournament_prize_money
, SCO.nom_fr tournament_country
, '' tournament_logo
, L.time_start tournament_start
, '' tournament_end
, '' tournament_nbPlayer
, '' tournament_genre
, '' tournament_category
, '' tournament_type
, LR.site tournament_site
, L.year tournament_year
, 0 tournament_importance
, '' team1
, '' team2
, 3 importance
, '' tournament_background
, SC.fuseau_horaire
, IF(ISNULL(LS.status) || M.status = 2 || M.status = 3 || M.status = 4, M.status, LS.status) match_status
, LS.serve
, S.time s_time_start
, S.court
, S.date_loc
, S.type s_type
, S.ordre s_order
, CT.nom court_name
, CT.ordre court_order
FROM
tournois_matchs M
JOIN joueurs P1 on P1.id = M.j1
LEFT JOIN `joueurs` P1B on P1B.id = M.j1_bis
JOIN joueurs P2 on P2.id = M.j2
LEFT JOIN `joueurs` P2B on P2B.id = M.j2_bis
LEFT JOIN tennis_rankings R1 on R1.player = P1.id AND R1.id = IF(P1.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R1B on R1B.player = P1B.id AND R1B.id = IF(P1B.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2 on R2.player = P2.id AND R2.id = IF(P2.sexe = 1, 'wta', 'atp')
LEFT JOIN tennis_rankings R2B on R2B.player = P2B.id AND R2B.id = IF(P2B.sexe = 1, 'wta', 'atp')
LEFT JOIN `livescores_new`.`matchs` LS ON (LS.tt_match_id = M.id)
LEFT JOIN tournois_programmes S on S.idm = M.id
LEFT JOIN lieux_courts CT on (CT.ids = S.ids && CT.ordre = S.court)
JOIN `leagues_rounds` LR on LR.id = M.league_round
JOIN `leagues` L on L.id = LR.league
JOIN tournois_name N on N.league = L.id
LEFT JOIN lieux_sites SL on SL.id = LR.site
LEFT JOIN lieux_villes SC on SC.id = SL.idv
LEFT JOIN lieux_pays SCO on SCO.code = SC.pays
WHERE
M.id = '54225'
&& M.type_tournoi_add = 2
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
LIMIT 1
2025년 데이비스 컵: 이탈리아 대 벨기에 첫 번째 준결승 대진표 확정!
데이비스 컵 파이널 8에서 본격적인 경쟁이 치열해지고 있습니다. 4강에 진출한 네 국가가 모두 확정되었으며, 2025년 대회 첫 번째 준결승전이 금요일부터 개최국 이탈리아와 벨기에 사이에서 열립니다. 아주라 군단은 8강에서 오스트리아를 쉽게 꺾은 반면, 벨기에 팀은 화요일 저녁 프랑스를 탈락시켰습니다.
2회 연속 우승 팀인 이탈리아는 최고의 선수인 야니크...
다르시, 무테 변호: "그는 아티스트이기 때문에 그렇게 쇼를 만든다"
화요일 저녁, 벨기에가 데이비스컵 8강에서 프랑스를 탈락시키며 훌륭한 성과를 거두었습니다. 라파엘 콜리용과 지주 베르크스가 이끄는 스티브 다르시의 팀은 코렝탕 무테와 아르튀르 랑데르크네흐의 계획을 저지하며 두 선수 모두를 꺾었습니다.
이번 경기의 전환점 중 하나는 첫 번째 단식 경기에서 무테가 두 번째 세트 막판에 코트가 열려있음에도 다리 사이로 샷을 시...
"제가 부르면 오직 한 가지 대답만 돌아온다", 다르시스 감독이 그의 팀에 대해 밝혀
벨기에가 이번 데이비스컵 파이널 8에서 프랑스를 꺾는 멋진 성과를 거두었습니다. 팀의 승리 후 인터뷰에서 벨기에 대표팀의 스티브 다르시스 감독은 팀 내 데이비스컵 문화에 대해 언급했습니다.
"그들은 모두 코트에서 아주 잘 플레이했어요, 우리가 본 것처럼 모두 매우 집중했죠. 방금 그들에게 이겼든 졌든 상관없다고 말했어요, 제게 중요한 것은 그들이 최선을 ...
벨기에, 데이비스컵 파이널8 프랑스전 선수단 공개
11월 18일 금요일, 프랑스와 벨기에는 데이비스컵 파이널8 경기를 위해 볼로냐에서 맞대결을 펼칠 예정입니다.
스티브 다르시스 감독은 이번 경기에 참가할 선수 명단을 공개했습니다: 지주 베르흐스, 라파엘 콜리뇽, 산더 질, 요란 블리에헌. 현재 명단에 다비드 고팽이 포함되지 않은 점이 주목할 만합니다.
다르시스 감독은 선수 구성 발표 후 자신감을 나타내...
비디오 - 질 시몽의 기발한 샷: 2019년 안트베르펜을 뜨겁게 달군 헤드 뒤 발리
머리 뒤로 날아오는 공을 위닝 발리로 처리하다니? 믿기 어렵겠지만 질 시몽이 2019년 안트베르펜 대회에서 바로 그런 장면을 선보였습니다.
현지 선수 스티브 다르시와의 1라운드 경기에서 프랑스 선수는 상대의 트위너 샷에 이어 정통파와는 거리가 먼 기발한 발리로 미친 듯한 랠리를 승리로 장식했습니다.
이 샷을 본 다르시는 세계 랭킹 6위였던 선수의 성공률...
34세의 디미트로프, 1968년 이후 그랜드슬램 최다 기권 기록 보유
윔블던 8강전에서 시너를 상대로 기권을 하면서 디미트로프는 또 다시 메이저 대회를 조기에 떠나야 했습니다. 이번이 그가 최근 5번째 메이저 대회에서의 기권으로, 불가리아 선수는 이제 습관처럼 되었습니다.
2017년 ATP 파이널스 우승자인 디미트로프는 오픈 시대(1968년) 이후 그랜드슬램 대회에서 가장 많은 기권(10회)을 기록한 선수입니다. 그는 티프...
2013년 나달을 꺾은 다르시스는 회상한다: "너는 그가 또 빠져나갈 것이라고 생각한다"
라파엘 나달의 은퇴 발표를 맞아 RTBF는 이 주제에 대해 스티브 다르시스를 꽤 오랫동안 인터뷰했다.
참고로, 벨기에의 다르시스는 2013년 윔블던 1라운드에서 라파엘 나달을 예상을 뒤엎고 이겼다 (7-6, 7-6, 6-4).
이에 다르시스는 그 순간을 되돌아보며 특히 거의 믿지 못했다는 점을 언급했다: "그때 말했지만, 7-6, 7-6, 5-4, 40...
Latest video
Top 5 수요일 3
