SELECT distinct e.* from entities e JOIN tennis_personal_match tpm on tpm.match_id = e.guid JOIN (SELECT subm1.*, s1.string FROM metadata subm1 JOIN metastrings s1 ON subm1.value_id = s1.id) AS m1 ON e.guid = m1.entity_guid JOIN (SELECT subm2.*, s2.string FROM metadata subm2 JOIN metastrings s2 ON subm2.value_id = s2.id) AS m2 ON e.guid = m2.entity_guid where ((m1.name_id='261' AND m1.string BETWEEN 1546300800 AND 1577750400 ) and e.owner_guid = '32' and (m2.name_id='259' AND m2.string IN ( 'single' ) ) and e.owner_guid = '32') and ((m1.name_id='261' AND m1.string BETWEEN 1546300800 AND 1577750400 ) and e.owner_guid = '32' and (m2.name_id='259' AND m2.string IN ( 'single' ) ) and e.owner_guid = '32') and e.type='object' and e.subtype='13' and tpm.type='player' and (tpm.player1 = '32' or player1_b = '32' or player2 ='32' or player2_b = '32') and ( (1 = 1) and e.enabled='yes') and ( (1 = 1) and m1.enabled='yes') and ( (1 = 1) and m2.enabled='yes') order by m1.string desc limit 0, 100000
Statistics
Matcheswin/loss
Setswin/loss
Gameswin/loss
Tie Breakswin/loss
  Total Won Lost %Won %Lost
Matches 0 0 0 0% 0%
Sets 0 0 0 0% 0%
Games 0 0 0 NAN% NAN%
Tie Breaks 0 0 0 NAN% NAN%