SELECT * FROM 1_Kampe WHERE LigaID = '137' AND (Home='Zaragoza' OR Away='Zaragoza') ORDER BY Dato ASC;

Dato

Home

Score

Away

H Goals/Dif

A Goals Av.

H Avp/M

H Avp Last/M

H Avp Home/M

H Avp Away/M

A Goals/Dif

A Goals Av.

A Avp/M

A Avp Last/M

A Avp Home/M

A Avp Away/M

2019-08-17

Zaragoza

2-0

Tenerife

0/0

0,00

0.00/0

0.00/0

0.00/0

0.00/0

0/0

0,00

0.00/0

0.00/0

0.00/0

0.00/0

2019-08-25

Ponferradina

1-1

Zaragoza

1/-2

4,00

0.00/1

0.00/1

0.00/0

0.00/1

2/2

2,00

3.00/1

3.00/1

3.00/1

0.00/0

2019-08-30

Zaragoza

1-0

Elche

3/2

2,00

2.00/2

2.00/2

3.00/1

1.00/1

2/-1

2,50

1.50/2

1.50/2

0.00/1

3.00/1

2019-09-08

Alcorcon

0-3

Zaragoza

6/2

3,33

2.00/3

2.00/3

0.00/1

3.00/2

4/3

1,67

2.33/3

2.33/3

3.00/2

1.00/1

2019-09-15

Zaragoza

3-1

Extremadura UD

7/6

2,00

2.50/4

2.50/4

3.00/2

2.00/2

2/-2

1,50

0.50/4

0.50/4

0.50/2

0.50/2

2019-09-21

Zaragoza

0-0

Lugo

10/8

2,40

2.60/5

2.60/5

3.00/3

2.00/2

8/0

2,67

1.17/6

1.17/6

1.25/4

1.00/2

2019-09-29

R. Oviedo

2-2

Zaragoza

7/-6

2,86

0.29/7

0.29/7

0.67/3

0.00/4

10/8

2,00

2.33/6

2.33/6

2.50/4

2.00/2

2019-10-03

Zaragoza

2-2

Malaga

12/8

2,29

2.14/7

2.14/7

2.50/4

1.67/3

4/-2

1,25

0.88/8

0.88/8

0.75/4

1.00/4

2019-10-06

Zaragoza

0-2

Cadiz CF

14/8

2,50

2.00/8

2.00/8

2.20/5

1.67/3

14/6

2,44

2.44/9

2.38/8

2.60/5

2.25/4

2019-10-13

Numancia

0-1

Zaragoza

11/2

2,00

1.40/10

1.75/8

2.00/5

0.80/5

14/6

2,44

1.78/9

1.63/8

1.83/6

1.67/3

2019-10-16

Fuenlabrada

2-1

Zaragoza

13/3

2,30

1.70/10

1.38/8

2.00/4

1.50/6

15/7

2,30

1.90/10

1.88/8

1.83/6

2.00/4

2019-10-20

Zaragoza

1-2

Mirandes

16/6

2,36

1.73/11

1.50/8

1.83/6

1.60/5

12/-7

2,82

1.00/11

1.25/8

1.50/6

0.40/5

2019-10-27

Gijon

4-0

Zaragoza

12/-1

2,08

1.17/12

1.13/8

1.50/6

0.83/6

17/5

2,42

1.58/12

1.13/8

1.57/7

1.60/5

2019-11-03

Zaragoza

3-0

Las Palmas

17/1

2,54

1.46/13

0.75/8

1.57/7

1.33/6

15/0

2,31

1.38/13

1.88/8

1.43/7

1.33/6

2019-11-10

Almeria

1-1

Zaragoza

21/8

2,43

1.71/14

1.00/8

2.17/6

1.38/8

20/4

2,57

1.57/14

1.00/8

1.75/8

1.33/6

2019-11-16

Zaragoza

0-1

Albacete

21/4

2,53

1.53/15

1.00/8

1.75/8

1.29/7

10/-6

1,73

1.47/15

1.25/8

1.43/7

1.50/8

2019-11-23

Rayo Vallecano

0-1

Zaragoza

24/3

2,81

1.31/16

1.25/8

1.63/8

1.00/8

21/3

2,44

1.44/16

0.88/8

1.56/9

1.29/7

2019-11-30

Zaragoza

3-3

Girona

22/4

2,35

1.53/17

1.25/8

1.56/9

1.50/8

22/4

2,35

1.59/17

1.75/8

2.22/9

0.88/8

2019-12-08

Dep. La Coruna

1-3

Zaragoza

14/-15

2,39

0.67/18

0.50/8

0.88/8

0.50/10

25/4

2,56

1.50/18

1.00/8

1.50/10

1.50/8

2019-12-14

Zaragoza

2-0

Racing Santander

28/6

2,63

1.58/19

1.38/8

1.50/10

1.67/9

22/-3

2,47

0.89/19

1.00/8

1.10/10

0.67/9

2019-12-22

Huesca

2-1

Zaragoza

23/6

2,00

1.60/20

1.63/8

2.20/10

1.00/10

30/8

2,60

1.65/20

1.75/8

1.64/11

1.67/9

2020-01-07

Zaragoza

2-0

Gijon

31/7

2,62

1.57/21

1.75/8

1.64/11

1.50/10

20/-1

1,95

1.19/21

1.00/8

1.36/11

1.00/10

2020-01-14

Las Palmas

0-1

Zaragoza

28/2

2,45

1.50/22

1.88/8

1.64/11

1.36/11

33/9

2,59

1.64/22

1.75/8

1.75/12

1.50/10

2020-01-25

Zaragoza

1-0

Numancia

34/10

2,52

1.70/23

2.00/8

1.75/12

1.64/11

30/6

2,25

1.50/24

1.38/8

1.85/13

1.09/11

2020-02-02

Cadiz CF

1-1

Zaragoza

35/12

2,32

1.92/25

1.13/8

2.25/12

1.62/13

35/11

2,46

1.75/24

2.38/8

1.85/13

1.64/11

2020-02-08

Zaragoza

0-0

Fuenlabrada

36/11

2,44

1.72/25

2.13/8

1.85/13

1.58/12

29/3

2,12

1.42/26

0.75/8

1.62/13

1.23/13

2020-02-15

Elche

1-2

Zaragoza

35/7

2,33

1.48/27

1.50/8

1.38/13

1.57/14

36/11

2,35

1.69/26

2.13/8

1.79/14

1.58/12

2020-02-19

Mirandes

1-1

Zaragoza

36/-1

2,70

1.37/27

1.50/8

1.64/14

1.08/13

38/12

2,37

1.74/27

2.13/8

1.79/14

1.69/13

2020-02-23

Zaragoza

3-1

Dep. La Coruna

39/12

2,36

1.71/28

1.88/8

1.79/14

1.64/14

27/-12

2,36

1.21/28

2.75/8

1.43/14

1.00/14

2020-02-29

Racing Santander

2-2

Zaragoza

27/-10

2,21

0.83/29

0.75/8

1.00/14

0.67/15

42/14

2,41

1.76/29

2.25/8

1.87/15

1.64/14

2020-03-08

Malaga

0-1

Zaragoza

27/1

1,77

1.27/30

1.88/8

1.57/14

1.00/16

44/14

2,47

1.73/30

2.00/8

1.87/15

1.60/15

2020-06-13

Zaragoza

1-3

Alcorcon

45/15

2,42

1.77/31

2.00/8

1.87/15

1.69/16

38/1

2,42

1.32/31

1.50/8

1.00/16

1.67/15

2020-06-16

Lugo

1-3

Zaragoza

30/-11

2,22

1.16/32

1.50/8

1.31/16

1.00/16

46/13

2,47

1.72/32

1.63/8

1.75/16

1.69/16

2020-06-20

Zaragoza

0-2

Almeria

49/15

2,52

1.76/33

1.88/8

1.75/16

1.76/17

52/19

2,58

1.61/33

1.00/8

1.69/16

1.53/17

2020-06-23

Extremadura UD

1-2

Zaragoza

32/-14

2,29

0.97/34

0.88/8

0.94/17

1.00/17

49/13

2,50

1.71/34

1.75/8

1.65/17

1.76/17

2020-06-29

Zaragoza

0-1

Huesca

51/14

2,51

1.74/35

1.75/8

1.65/17

1.83/18

46/8

2,40

1.57/35

1.50/8

2.17/18

0.94/17

2020-07-03

Girona

1-0

Zaragoza

42/4

2,22

1.44/36

1.25/8

2.11/18

0.78/18

51/13

2,47

1.69/36

1.63/8

1.56/18

1.83/18

2020-07-06

Zaragoza

2-4

Rayo Vallecano

51/12

2,43

1.65/37

1.25/8

1.56/18

1.74/19

46/6

2,32

1.27/37

0.88/8

1.53/19

1.00/18

2020-07-09

Tenerife

1-1

Zaragoza

47/6

2,32

1.39/38

2.13/8

1.53/19

1.26/19

53/10

2,53

1.61/38

1.13/8

1.47/19

1.74/19

2020-07-12

Zaragoza

2-4

R. Oviedo

54/10

2,51

1.59/39

0.88/8

1.47/19

1.70/20

43/-6

2,36

1.21/39

1.50/8

1.45/20

0.95/19

2020-07-17

Albacete

4-1

Zaragoza

31/-13

1,88

1.15/40

1.38/8

1.05/20

1.25/20

56/8

2,60

1.55/40

0.88/8

1.40/20

1.70/20

2020-07-20

Zaragoza

2-1

Ponferradina

57/5

2,66

1.51/41

0.50/8

1.40/20

1.62/21

44/-4

2,24

1.24/41

0.88/8

1.71/21

0.75/20