Sample of data stored in table Matches
TID |
G |
A |
B |
X |
Y |
MID |
0 |
A |
BRA |
MAR |
3 |
0 |
17 |
0 |
A |
BRA |
SCO |
2 |
1 |
1 |
0 |
A |
MAR |
NOR |
2 |
2 |
2 |
0 |
A |
NOR |
BRA |
2 |
1 |
33 |
0 |
A |
NOR |
SCO |
1 |
1 |
18 |
0 |
A |
SCO |
MAR |
0 |
3 |
34 |
0 |
B |
AUT |
CHL |
1 |
1 |
20 |
0 |
B |
AUT |
ITA |
1 |
2 |
35 |
0 |
B |
CHL |
CMR |
1 |
1 |
36 |
0 |
B |
CMR |
AUT |
1 |
1 |
4 |
0 |
B |
ITA |
CHL |
2 |
2 |
3 |
0 |
B |
ITA |
CMR |
3 |
0 |
19 |
0 |
C |
DNK |
FRA |
1 |
2 |
38 |
0 |
C |
FRA |
ZAF |
3 |
0 |
6 |
0 |
C |
SAU |
DNK |
0 |
1 |
5 |
0 |
C |
SAU |
FRA |
0 |
4 |
21 |
0 |
C |
ZAF |
DNK |
1 |
1 |
22 |
0 |
C |
ZAF |
SAU |
2 |
2 |
37 |
0 |
D |
BGR |
ESP |
1 |
6 |
40 |
0 |
D |
ESP |
NGA |
2 |
3 |
8 |
0 |
D |
NGA |
BGR |
1 |
0 |
24 |
0 |
D |
NGA |
PRY |
1 |
3 |
39 |
0 |
D |
PRY |
BGR |
0 |
0 |
7 |
0 |
D |
PRY |
ESP |
0 |
0 |
23 |
0 |
E |
BEL |
KOR |
1 |
1 |
41 |
0 |
E |
BEL |
MEX |
2 |
2 |
26 |
0 |
E |
KOR |
MEX |
1 |
3 |
9 |
0 |
E |
KOR |
NLD |
0 |
5 |
25 |
0 |
E |
MEX |
NLD |
2 |
2 |
42 |
0 |
E |
NLD |
BEL |
0 |
0 |
10 |
0 |
F |
DEU |
USA |
2 |
0 |
12 |
0 |
F |
IRN |
DEU |
0 |
2 |
44 |
0 |
F |
USA |
IRN |
1 |
2 |
28 |
0 |
F |
USA |
YUG |
0 |
1 |
43 |
0 |
F |
YUG |
DEU |
2 |
2 |
27 |
0 |
F |
YUG |
IRN |
1 |
0 |
11 |
0 |
G |
COL |
ENG |
0 |
2 |
45 |
0 |
G |
COL |
TUN |
1 |
0 |
30 |
0 |
G |
ENG |
ROU |
1 |
2 |
29 |
0 |
G |
ENG |
TUN |
2 |
0 |
13 |
0 |
G |
ROU |
COL |
1 |
0 |
14 |
0 |
G |
TUN |
ROU |
1 |
1 |
46 |
0 |
H |
ARG |
JAM |
5 |
0 |
31 |
0 |
H |
ARG |
JPN |
1 |
0 |
15 |
0 |
H |
HRV |
ARG |
0 |
1 |
47 |
0 |
H |
HRV |
JPN |
1 |
0 |
32 |
0 |
H |
JAM |
HRV |
1 |
3 |
16 |
0 |
H |
JPN |
JAM |
1 |
2 |
48 |
0 |
P |
ARG |
ENG |
6 |
5 |
56 |
0 |
P |
BRA |
CHL |
4 |
1 |
49 |