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 = '3526028' && 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 = '3526028' && 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 = '3526028' && M.type_tournoi_add = 2 && (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut)) LIMIT 1 Vorhersage Kratzmann Chesnokov - Australian Open 1988
0
Tennis selected
5
Vorhersagespiel
0
Community
Anmelden
Nachrichten Spiele Rankings Wettbewerbe Videos Recherchen
Tennis
5
Vorhersagespiel
Community
background
Australian Open 1988  - 3. Runde
Beendet - ??:??
Mark Kratzmann
Kratzmann, Mark
0
0
0
0
0
Andrei Chesnokov
Chesnokov, Andrei
75 76 62
0
0
0
0
Vorhersagen sind geschlossen
À lire aussi
Zwei Spieler außerhalb der Top 50 im Halbfinale in Shanghai: Vacherot und Rinderknech schließen sich einem sehr exklusiven Kreis an
Zwei Spieler außerhalb der Top 50 im Halbfinale in Shanghai: Vacherot und Rinderknech schließen sich einem sehr exklusiven Kreis an
Clément Gehl 10/10/2025 à 10h10
Valentin Vacherot und Arthur Rinderknech haben ihre Tickets für das Halbfinale des Shanghai Masters 1000 gelöst, indem sie jeweils Holger Rune und Felix Auger-Aliassime besiegten. Wie der X-Account J...
Acht Mitglieder der Top 10 haben noch nie ein Match in Wimbledon gewonnen, darunter ein noch aktiver Spieler
Acht Mitglieder der Top 10 haben noch nie ein Match in Wimbledon gewonnen, darunter ein noch aktiver Spieler
Clément Gehl 29/06/2025 à 17h58
Wimbledon beginnt diesen Montag. Gespielt wird auf Rasen, einem Belag, der längst nicht von allen geschätzt wird und auf dem es manchmal schwer ist, sich wohlzufühlen. Das gilt besonders für acht S...
Rublev is the 1st Russian player in Monte-Carlo final since Chesnokov in 1990
Rublev is the 1st Russian player in Monte-Carlo final since Chesnokov in 1990
Guillaume Nonque 17/04/2021 à 19h28
31 years ago, his compatriot earned title against Muster....
Rublev est le 1er Russe en finale de Monte-Carlo depuis Andrei Chesnokov en 1990
Rublev est le 1er Russe en finale de Monte-Carlo depuis Andrei Chesnokov en 1990
Guillaume Nonque 17/04/2021 à 19h19
Il y a 31 ans, ce dernier l'avait emporté sur Muster....
Teilen
Letzten Informationen flash
video Neuste Video + alle
35:04
Epische Duelle 2025 - Shelton, Alcaraz, Zverev, Moutet, Rune & Mehr: Teil 2
Top des commentaires
top Artikel!
0
BrancaStedenka BrancaStedenka
Blamabel
0
Heaven Heaven
ranking Live-Ranking
ranking Top 5 Mittwoch 3
Rémi G 2 Rémi G 9Pkt
4 9Pkt
Rafa76 5 Rafa76 8Pkt
Spiele die Vorhersagen