Buenos Aires 3

select p.NAME_P as player1_name,k.NAME_P as player2_name,p.COUNTRY_P as country1,k.COUNTRY_P as country2,a.*,t.* from games_atp a Join tours_atp t on a.ID_T_G=t.ID_T JOIN players_atp p on a.ID1_G=p.ID_P JOIN players_atp k on a.ID2_G=k.ID_P where ((a.ID1_G in("3700") and a.ID2_G in("3700")) or (a.ID2_G in("3700") and a.ID1_G in("3700"))) and a.ID_R_G="12" and t.ID_T="17923" and p.COUNTRY_P!="N/A" order by a.DATE_G asc