W25 Wichita

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_wta a Join tours_wta t on a.ID_T_G=t.ID_T JOIN players_wta p on a.ID1_G=p.ID_P JOIN players_wta 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="14119" and p.COUNTRY_P!="N/A" order by a.DATE_G asc