Jeu de service
Break
Inconnu
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 = '434264'
&& 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 = '434264'
&& 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 = '434264'
&& 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 = '440607'
&& 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 = '440607'
&& 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 = '440607'
&& M.type_tournoi_add = 2
&& (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut))
LIMIT 1
쿼리, 올해의 최고 선수로 스비아테크 선택: "윔블던이 판도를 바꿨다"
샘 쿼리의 팟캐스트 Nothing Major에서 그는 스티브 존슨과 함께 2025년 최고의 여자 선수를 논의했습니다.
쿼리에 따르면, 이가 스비아테크가 연말 세계 1위 자리를 지키지 못했지만, 빠른 코트에서의 발전을 보여주며 이제 어떤 토너먼트에서도 우승할 수 있음을 증명했습니다.
[h2]클레이 코트에서의 지배력이 이제 다른 코트로 확장되다[/h2]
...
쿼리: "시너와 알카라스는 어떤 것에도 절대 불평하지 않는다"
샘 쿼리, 존 이스너, 잭 소크, 스티브 존슨이 진행하는 팟캐스트 Nothing Major에서 얀니크 시너, 카를로스 알카라스와 다른 선수들 사이의 뚜렷한 차이점이 논의되었다.
쿼리에 따르면, 현재 최고의 두 선수는 결코 불평하지 않는다고 한다. 그는 이렇게 설명했다: "특히 시너와 알카라스는 어떤 것에도 절대 불평하지 않습니다.
[h2]나달과의 공통점...
"유럽에는 더 큰 TV가 없나요?": 알카라스의 거실 사진이 미국 스타들을 충격에 빠뜨리다
데이비스 컵이 이탈리아 국기 아래 유럽을 세 번째로 뜨겁게 달구기도 전에, 한 장의 사진이 팬들의 시선을 사로잡았다:
작은 소파에 앉아 거실에서 스페인과 독일의 경기를 지켜보고 있는 카를로스 알카라스.
최신식 대형 TV도, 멀티미디어 룸도 없이, 그저 수수한 방과 선반 위에 놓인 트로피 몇 개, 그리고 아무 일도 아니라는 듯 부모님 집에 있는 알카라스....
"사람들은 신경 쓰지 않아": 이스너와 퀘리, 현재 데이비스컵 버전 비판
2025년 데이비스컵이 이번 주 일요일 이탈리아-스페인 결승전으로 막을 내리면서, 이번 주 내내 대회 형식이 참가 선수들과 테니스 관계자들 모두로부터 크게 비판을 받았다.
예를 들어, 야니크 시너와 로렌초 무세티의 기권이 논쟁을 다시 불러일으켰다. Sam Querrey는 Nothing Major 팟캐스트에서 주저 없이 공허하게 돌아가는 시스템을 지적했다:...
33번의 타격과 화려한 결말: 아테네에서 맥도날드와 에체베리 간의 엄청난 랠리!
맥도날드가 아테네에서 에체베리를 상대로 화려한 랠리를 승리로 장식했습니다.
예선을 간신히 통과한 세계 랭킹 110위의 매켄지 맥도널드는 ATP 250 아테네 대회 센트럴 코트에서 열린 개막 경기에서 아르헨티나의 토마스 마틴 에체베리와 맞섰습니다.
첫 세트부터 치열한 접전이 펼쳐졌고(미국 선수가 7-6으로 승리), 이 싸움은 다음 세트로 이어졌습니다.
...
이스너: "저는 조코비치가 ATP 파이널에 참가하지 않을 것이라고 생각합니다"
토리노에 의혹이 떠돈다. 존 이스너는 노박 조코비치가 2025년 ATP 파이널을 건너뛸 것이라고 생각하지만, 샘 쿠에리는 전혀 다른 의견을 가지고 있다.
최근 Nothing Major 팟캐스트에서 존 이스너는 자신의 견해로는 노박 조코비치가 2025년 ATP 파이널에 참가하지 않을 것이라고 밝혔다.
"저는 그렇게 생각하지 않습니다. 그리고 제가 틀렸으면...
코로나가 내 커리어를 구했다" 미켈센, 프로 테니스계 데뷔 과정 털어놓다
'Nothing Major Show' 팟캐스트에서 알렉스 미켈센은 존 이스너, 잭 소크, 샘 쿠에리, 스티브 존슨에게 자신의 프로 테니스계 데뷔 과정을 이야기했다. 그에 따르면 코로나 팬데믹이 결정적인 역할을 했다.
그는 이렇게 설명했다: "저는 제 자신을 프로 테니스 선수라고 생각하지 않았지만, 제가 꽤 잘한다는 것은 알고 있었습니다. 제 학급에서 상위...
Latest video
Top 5 수요일 3
