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 = '46240' && 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 = '46240' && 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 = '46240' && M.type_tournoi_add = 2 && (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut)) LIMIT 1 Comments Vagnozzi Gutierrez-Ferrol - Marbella Open 2012
0
Tennis selected
5
Predictions game
0
Community
Sign in
News Games Rankings Competitions Videos Investigations
Tennis
5
Predictions game
Community
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 = '46240' && 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 = '46240' && 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 = '46240' && M.type_tournoi_add = 2 && (S.statut = 0 || S.statut = 4 || S.statut = 2 || ISNULL(S.statut)) LIMIT 1
background
Marbella Open 2012  - 1st round
Finished - 01:17
Simone Vagnozzi
Vagnozzi, Simone
2
4
0
0
0
Sergio Gutierrez-Ferrol
Gutierrez-Ferrol, Sergio
6
6
0
0
0
Send
Règles à respecter
Avatar
À lire aussi
An Obsession with Perfection: Vagnozzi's Words That Sum Up Sinner's Monstrous Season
"An Obsession with Perfection": Vagnozzi's Words That Sum Up Sinner's Monstrous Season
Jules Hypolite 21/11/2025 à 17h32
In 2025, Jannik Sinner had a magnificent season: out of 12 tournaments played, he reached 10 finals, won six titles — including the Australian Open and Wimbledon — and fought for the world No. 1 spot,...
ATP Awards 2025: Alcaraz, Sinner, Vacherot… the nominees who marked the season!
ATP Awards 2025: Alcaraz, Sinner, Vacherot… the nominees who marked the season!
Jules Hypolite 20/11/2025 à 17h10
The ATP season having ended on Sunday, it is now time to reward those who marked this new year of tennis. The ATP revealed this Thursday the list of nominees in three categories that make up the ATP ...
Sinner: Convincing Cahill to continue will be my biggest challenge
Sinner: "Convincing Cahill to continue will be my biggest challenge"
Arthur Millot 06/11/2025 à 14h25
Jannik Sinner has discussed the future of his relationship with his coach: Australian Darren Cahill. Since their collaboration began, Sinner and Cahill have formed a formidable duo. Under the guidanc...
I couldn't make any commitment, Becker reveals he was close to coaching Sinner in 2022
"I couldn't make any commitment," Becker reveals he was close to coaching Sinner in 2022
Adrien Guyot 02/11/2025 à 12h01
Boris Becker revealed in an interview with Corriere Della Sera that he was close to becoming Jannik Sinner's coach three years ago. But he has no regrets, due to the work done by the duo Darren Cahill...
Sinner reflects on 2025: I consider this season to have been extraordinary
Sinner reflects on 2025: "I consider this season to have been extraordinary"
Adrien Guyot 26/10/2025 à 08h38
Jannik Sinner reviewed his season after qualifying for the final of the Vienna tournament at the expense of Alex De Minaur. World number 2, Sinner qualified for his eighth final of the season at the ...
Sinner: Darren Cahill is like a second father to me
Sinner: "Darren Cahill is like a second father to me"
Arthur Millot 21/10/2025 à 11h47
With powerful words, Jannik Sinner recently spoke about Darren Cahill, his coach, in an interview with Sky Sport. "He's kind of like a second dad to me. In crucial moments, Darren is fundamental, esp...
ITIA Validates the Return of Umberto Ferrara, Sinner's Physical Trainer
ITIA Validates the Return of Umberto Ferrara, Sinner's Physical Trainer
Arthur Millot 08/10/2025 à 15h58
Umberto Ferrara, the former physical trainer of Jannik Sinner, who was dismissed last August following the world number 2's positive anti-doping test, has officially returned to the Italian prodigy's ...
I spoke with Vagnozzi...: Musetti gives update on Sinner
I spoke with Vagnozzi...": Musetti gives update on Sinner
Arthur Millot 07/10/2025 à 09h28
After his sudden withdrawal at the Shanghai Masters 1000, the public expected a quick reaction from the Italian or his team. But it was ultimately Lorenzo Musetti who broke the silence. Following his...
Share
Latest flashs flash
video Latest video + all
35:04
Epic duels 2025 - Shelton, Alcaraz, Zverev, Moutet, Rune & More: Part 2
Top des commentaires
thank God🫡
0
Silverstone Silverstone
ranking Live Ranking
ranking Top 5 Wednesday 3
Rémi G 2 Rémi G 9pts
4 9pts
Rafa76 5 Rafa76 8pts
Play the predictions