4ª Fem points

Points obtained in this tournament
Ranking points
SELECT xtcp.tournament_id,xtcp.position,xtcp.position_prev,xtcp.position_prev_round,u2.nombre as partner_name,u.user_id,xpiu.player_identity_id,u.email,u.idcard,xtcp.participant_id,xtcp.participant_type,xtcp.points,xtcp.points_to_defend,xtcp.calc,xt.name as tournament_name,xt2.name as imported_circuit_name,xtcp.points_description FROM x_tournament_circuit_points xtcp LEFT JOIN x_tournament_event xte USING (event_id) LEFT JOIN x_tournament xt ON (xt.tournament_id=xte.tournament_id) LEFT JOIN usuarios u ON (u.user_id=xtcp.participant_id) LEFT JOIN x_player_identity_user xpiu ON (xpiu.user_id=xtcp.participant_id) LEFT JOIN usuarios u2 ON (u2.user_id=xtcp.partner_id) LEFT JOIN x_tournament_event xte2 ON (xte2.event_id=xtcp.imported_circuit_event_id) LEFT JOIN x_tournament xt2 ON (xt2.tournament_id=xte2.tournament_id) WHERE xtcp.points IS NOT NULL AND xtcp.event_id=1972913 AND xtcp.participant_type=1
P Doubles Pts
There are no details
.