SELECT * FROM 1_Kampe WHERE LigaID = '138' 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

2018-08-19

Zaragoza

2-1

Rayo Majadahonda

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

2018-08-25

Reus FCR

0-0

Zaragoza

0/-2

2,00

0.00/1

0.00/1

0.00/0

0.00/1

2/1

3,00

3.00/1

3.00/1

3.00/1

0.00/0

2018-09-01

Zaragoza

1-1

Las Palmas

2/1

1,50

2.00/2

2.00/2

3.00/1

1.00/1

3/2

2,00

2.00/2

2.00/2

2.00/2

0.00/0

2018-09-08

R. Oviedo

0-4

Zaragoza

6/2

3,33

1.67/3

1.67/3

1.00/1

2.00/2

3/1

1,67

1.67/3

1.67/3

2.00/2

1.00/1

2018-09-16

Almeria

2-1

Zaragoza

2/-4

2,00

0.25/4

0.25/4

0.50/2

0.00/2

7/5

2,25

2.00/4

2.00/4

2.00/2

2.00/2

2018-09-22

Zaragoza

0-2

Lugo

8/4

2,40

1.60/5

1.60/5

2.00/2

1.33/3

5/-3

2,60

0.80/5

0.80/5

1.00/3

0.50/2

2018-09-28

Albacete

2-2

Zaragoza

11/6

2,67

2.00/6

2.00/6

1.67/3

2.33/3

8/2

2,33

1.33/6

1.33/6

1.33/3

1.33/3

2018-10-08

Zaragoza

1-1

Osasuna

10/2

2,57

1.29/7

1.29/7

1.33/3

1.25/4

5/-1

1,57

1.14/7

1.14/7

2.00/4

0.00/3

2018-10-13

Numancia

1-0

Zaragoza

9/-1

2,38

1.25/8

1.25/8

1.75/4

0.75/4

11/2

2,50

1.25/8

1.25/8

1.25/4

1.25/4

2018-10-21

Zaragoza

1-1

Tenerife

11/1

2,33

1.11/9

0.88/8

1.25/4

1.00/5

7/-5

1,90

0.80/10

1.13/8

1.00/5

0.60/5

2018-10-21

Zaragoza

0-1

Reus Deportiu

12/1

2,30

1.10/10

0.75/8

1.20/5

1.00/5

10/-3

1,00

1.30/23

1.88/8

0.00/13

3.00/10

2018-10-21

Reus Deportiu

0-1

Zaragoza

6/0

1,00

1.50/12

1.88/8

0.00/6

3.00/6

12/0

2,18

1.00/11

0.75/8

1.00/6

1.00/5

2018-10-28

Elche

2-0

Zaragoza

10/-4

2,00

1.17/12

1.50/8

1.33/6

1.00/6

13/1

2,08

1.17/12

0.75/8

1.00/6

1.33/6

2018-11-04

Zaragoza

0-2

Granada CF

13/-1

2,08

1.08/13

0.75/8

1.00/6

1.14/7

19/10

2,15

2.00/13

1.88/8

2.29/7

1.67/6

2018-11-12

Gimnastic

1-3

Zaragoza

8/-10

1,86

0.86/14

0.88/8

1.00/7

0.71/7

13/-3

2,07

1.00/14

0.75/8

0.86/7

1.14/7

2018-11-17

Zaragoza

2-2

Mallorca

16/-1

2,20

1.13/15

1.00/8

0.86/7

1.38/8

18/5

2,07

1.53/15

1.50/8

1.75/8

1.29/7

2018-11-25

Alcorcon

2-0

Zaragoza

15/9

1,31

1.88/16

1.88/8

2.38/8

1.38/8

18/-1

2,31

1.13/16

1.00/8

0.88/8

1.38/8

2018-11-30

Zaragoza

0-1

Cadiz CF

18/-3

2,29

1.06/17

1.00/8

0.88/8

1.22/9

23/8

2,24

1.53/17

2.38/8

1.67/9

1.38/8

2018-12-09

Zaragoza

0-0

Cordoba

18/-4

2,22

1.00/18

0.63/8

0.78/9

1.22/9

19/-15

2,94

0.83/18

1.00/8

1.10/10

0.50/8

2018-12-16

Dep. La Coruna

3-1

Zaragoza

29/16

2,21

1.84/19

2.00/8

2.22/9

1.50/10

18/-4

2,11

1.00/19

0.75/8

0.80/10

1.22/9

2018-12-22

Zaragoza

2-1

Extremadura UD

19/-6

2,20

0.95/20

0.63/8

0.80/10

1.10/10

24/-4

2,60

1.00/20

1.00/8

0.70/10

1.30/10

2019-01-05

Gijon

1-2

Zaragoza

19/3

1,67

1.38/21

1.50/8

1.90/10

0.91/11

21/-5

2,24

1.05/21

1.00/8

1.00/11

1.10/10

2019-01-13

Zaragoza

0-2

Malaga

23/-4

2,27

1.14/22

1.38/8

1.00/11

1.27/11

23/6

1,82

1.77/22

1.38/8

2.18/11

1.36/11

2019-01-19

Rayo Majadahonda

2-2

Zaragoza

17/-10

1,91

1.09/23

0.75/8

1.36/11

0.83/12

23/-6

2,26

1.09/23

1.00/8

0.92/12

1.27/11

2019-01-25

Zaragoza

2-0

R. Oviedo

25/-6

2,33

1.08/24

1.00/8

0.92/12

1.25/12

27/0

2,25

1.50/24

1.75/8

1.58/12

1.42/12

2019-02-04

Las Palmas

1-1

Zaragoza

30/3

2,28

1.40/25

1.25/8

1.75/12

1.08/13

27/-4

2,32

1.16/25

1.38/8

1.08/13

1.25/12

2019-02-09

Lugo

1-2

Zaragoza

24/-5

2,04

1.12/26

1.25/8

1.38/13

0.85/13

28/-4

2,31

1.15/26

1.50/8

1.08/13

1.23/13

2019-02-16

Zaragoza

0-0

Albacete

30/-3

2,33

1.22/27

1.75/8

1.08/13

1.36/14

37/15

2,19

1.89/27

2.13/8

1.93/14

1.85/13

2019-02-23

Osasuna

1-0

Zaragoza

35/9

2,18

1.82/28

2.38/8

2.46/13

1.27/15

30/-3

2,25

1.21/28

1.88/8

1.07/14

1.36/14

2019-03-03

Zaragoza

1-2

Almeria

30/-4

2,21

1.17/29

1.50/8

1.07/14

1.27/15

31/6

1,93

1.38/29

1.50/8

1.73/15

1.00/14

2019-03-10

Granada CF

1-0

Zaragoza

36/17

1,83

1.77/30

1.38/8

1.67/15

1.87/15

31/-5

2,23

1.13/30

1.13/8

1.00/15

1.27/15

2019-03-16

Zaragoza

1-0

Elche

31/-6

2,19

1.10/31

1.13/8

1.00/15

1.19/16

30/-5

2,10

1.16/31

1.13/8

1.50/16

0.80/15

2019-03-25

Mallorca

3-0

Zaragoza

39/10

2,13

1.59/32

1.88/8

2.06/16

1.13/16

32/-5

2,16

1.16/32

1.38/8

1.13/16

1.19/16

2019-04-01

Zaragoza

3-0

Gimnastic

32/-8

2,18

1.12/33

1.00/8

1.13/16

1.12/17

17/-26

1,82

0.73/33

0.50/8

0.94/16

0.53/17

2019-04-08

Cadiz CF

3-3

Zaragoza

41/14

2,00

1.53/34

1.75/8

1.82/17

1.24/17

35/-5

2,21

1.18/34

1.25/8

1.24/17

1.12/17

2019-04-14

Zaragoza

0-2

Alcorcon

38/-5

2,31

1.17/35

1.00/8

1.24/17

1.11/18

29/-3

1,74

1.26/35

0.75/8

1.78/18

0.71/17

2019-04-19

Zaragoza

0-0

Reus FCR

38/-7

2,31

1.14/36

0.88/8

1.17/18

1.11/18

16/-13

1,32

0.62/34

0.00/8

0.44/18

0.81/16

2019-04-28

Cordoba

0-3

Zaragoza

42/-26

2,97

0.81/37

0.75/8

1.06/18

0.58/19

38/-7

2,24

1.11/37

0.88/8

1.11/19

1.11/18

2019-05-04

Zaragoza

0-1

Dep. La Coruna

41/-4

2,26

1.16/38

1.25/8

1.11/19

1.21/19

45/14

2,00

1.50/38

0.63/8

1.63/19

1.37/19

2019-05-11

Extremadura UD

0-3

Zaragoza

41/-4

2,21

1.15/39

1.88/8

1.05/19

1.25/20

41/-5

2,23

1.13/39

1.25/8

1.05/20

1.21/19

2019-05-17

Zaragoza

4-2

Gijon

44/-2

2,25

1.18/40

1.25/8

1.05/20

1.30/20

40/7

1,83

1.45/40

1.63/8

1.65/20

1.25/20

2019-05-24

Malaga

3-1

Zaragoza

43/13

1,78

1.59/41

1.00/8

1.70/20

1.48/21

48/0

2,34

1.22/41

1.63/8

1.14/21

1.30/20

2019-06-04

Zaragoza

0-0

Numancia

49/-2

2,38

1.19/42

1.25/8

1.14/21

1.24/21

43/-7

2,21

1.12/42

0.63/8

1.48/21

0.76/21

2019-06-09

Tenerife

1-0

Zaragoza

39/-12

2,09

1.09/43

1.25/8

1.52/21

0.68/22

49/-2

2,33

1.19/43

1.25/8

1.14/22

1.24/21