SELECT * FROM 1_Kampe WHERE LigaID = '130' AND (Home='Alaves' OR Away='Alaves') 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

2016-08-21

Atl. Madrid

1-1

Alaves

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

2016-08-28

Alaves

0-0

Gijon

1/0

2,00

1.00/1

1.00/1

0.00/0

1.00/1

2/1

3,00

3.00/1

3.00/1

3.00/1

0.00/0

2016-09-10

Barcelona

1-2

Alaves

7/5

4,50

3.00/2

3.00/2

3.00/1

3.00/1

1/0

1,00

1.00/2

1.00/2

1.00/1

1.00/1

2016-09-19

Alaves

0-0

Dep. La Coruna

3/1

1,67

1.67/3

1.67/3

1.00/1

2.00/2

2/0

1,33

1.33/3

1.33/3

1.50/2

1.00/1

2016-09-22

Valencia

2-1

Alaves

5/-5

3,75

0.00/4

0.00/4

0.00/2

0.00/2

3/1

1,25

1.50/4

1.50/4

1.00/2

2.00/2

2016-09-26

Alaves

3-1

Granada CF

4/0

1,60

1.20/5

1.20/5

1.00/2

1.33/3

6/-6

3,60

0.40/5

0.40/5

0.33/3

0.50/2

2016-10-01

Sevilla

2-1

Alaves

11/2

3,33

1.83/6

1.83/6

3.00/3

0.67/3

7/2

2,00

1.50/6

1.50/6

1.67/3

1.33/3

2016-10-16

Alaves

1-1

Malaga

8/1

2,14

1.29/7

1.29/7

1.67/3

1.00/4

7/-2

2,29

1.14/7

1.14/7

1.75/4

0.33/3

2016-10-22

Real Sociedad

3-0

Alaves

11/-1

2,88

1.25/8

1.25/8

1.75/4

0.75/4

9/1

2,13

1.25/8

1.25/8

1.50/4

1.00/4

2016-10-29

Alaves

1-4

Real Madrid

9/-2

2,22

1.11/9

1.13/8

1.50/4

0.80/5

24/15

3,67

2.33/9

2.25/8

2.20/5

2.50/4

2016-11-05

Osasuna

0-1

Alaves

12/-8

3,20

0.70/10

0.75/8

0.40/5

1.00/5

10/-5

2,50

1.00/10

1.00/8

1.20/5

0.80/5

2016-11-20

Alaves

0-1

Espanyol

11/-4

2,36

1.18/11

1.00/8

1.20/5

1.17/6

13/-4

2,73

1.09/11

1.25/8

0.67/6

1.60/5

2016-11-27

Villarreal

0-2

Alaves

19/11

2,25

1.83/12

1.75/8

2.67/6

1.00/6

11/-5

2,25

1.08/12

0.88/8

1.00/6

1.17/6

2016-12-04

Alaves

1-1

Las Palmas

13/-3

2,23

1.23/13

1.25/8

1.00/6

1.43/7

24/3

3,46

1.46/13

1.25/8

2.14/7

0.67/6

2016-12-11

Eibar

0-0

Alaves

21/2

2,86

1.50/14

1.38/8

2.29/7

0.71/7

14/-3

2,21

1.21/14

1.00/8

1.00/7

1.43/7

2016-12-16

Alaves

1-0

Betis

14/-3

2,07

1.20/15

1.13/8

1.00/7

1.38/8

18/-10

3,07

1.20/15

1.25/8

1.50/8

0.86/7

2017-01-08

Ath Bilbao

0-0

Alaves

22/3

2,56

1.63/16

1.38/8

2.38/8

0.88/8

15/-2

2,00

1.31/16

1.38/8

1.25/8

1.38/8

2017-01-15

Celta Vigo

1-0

Alaves

28/-4

3,53

1.41/17

1.38/8

2.00/9

0.75/8

15/-2

1,88

1.29/17

1.50/8

1.25/8

1.33/9

2017-01-21

Alaves

2-2

Leganes

15/-3

1,83

1.22/18

1.50/8

1.25/8

1.20/10

13/-16

2,33

0.94/18

0.88/8

0.78/9

1.11/9

2017-01-28

Alaves

0-0

Atl. Madrid

17/-3

1,95

1.21/19

1.25/8

1.22/9

1.20/10

34/18

2,63

1.84/19

1.75/8

2.22/9

1.50/10

2017-02-05

Gijon

2-4

Alaves

20/-19

2,95

0.65/20

0.50/8

1.11/9

0.27/11

17/-3

1,85

1.20/20

1.38/8

1.20/10

1.20/10

2017-02-11

Alaves

0-6

Barcelona

21/-1

2,05

1.29/21

1.38/8

1.20/10

1.36/11

55/37

3,48

2.14/21

2.25/8

2.10/10

2.18/11

2017-02-18

Dep. La Coruna

0-1

Alaves

26/-8

2,86

0.90/21

1.13/8

1.56/9

0.42/12

21/-7

2,23

1.23/22

1.25/8

1.09/11

1.36/11

2017-02-25

Alaves

2-1

Valencia

22/-6

2,17

1.30/23

1.50/8

1.09/11

1.50/12

33/-8

3,22

1.13/23

1.75/8

1.27/11

1.00/12

2017-03-01

Granada CF

2-1

Alaves

22/-30

3,08

0.67/24

0.88/8

1.18/11

0.23/13

24/-5

2,21

1.38/24

1.50/8

1.25/12

1.50/12

2017-03-06

Alaves

1-1

Sevilla

25/-6

2,24

1.32/25

1.38/8

1.25/12

1.38/13

49/20

3,12

2.20/25

2.38/8

2.58/12

1.85/13

2017-03-11

Malaga

1-2

Alaves

32/-11

2,88

1.00/26

0.63/8

1.67/12

0.43/14

26/-6

2,23

1.31/26

1.50/8

1.23/13

1.38/13

2017-03-18

Alaves

1-0

Real Sociedad

28/-5

2,26

1.37/27

1.75/8

1.23/13

1.50/14

42/4

2,96

1.78/27

1.63/8

1.71/14

1.85/13

2017-04-02

Real Madrid

3-0

Alaves

71/43

3,67

2.41/27

2.38/8

2.57/14

2.23/13

29/-4

2,21

1.43/28

2.00/8

1.36/14

1.50/14

2017-04-05

Alaves

0-1

Osasuna

29/-7

2,24

1.38/29

1.63/8

1.36/14

1.40/15

29/-40

3,38

0.38/29

0.13/8

0.33/15

0.43/14

2017-04-08

Espanyol

1-0

Alaves

42/0

2,80

1.43/30

1.38/8

1.73/15

1.13/15

29/-8

2,20

1.33/30

1.63/8

1.27/15

1.40/15

2017-04-17

Alaves

2-1

Villarreal

29/-9

2,16

1.29/31

1.25/8

1.27/15

1.31/16

45/21

2,23

1.74/31

1.88/8

1.88/16

1.60/15

2017-04-23

Las Palmas

1-1

Alaves

51/-6

3,38

1.19/32

1.25/8

2.00/16

0.38/16

31/-8

2,19

1.34/32

1.25/8

1.38/16

1.31/16

2017-04-27

Alaves

0-0

Eibar

32/-8

2,18

1.33/33

1.38/8

1.38/16

1.29/17

52/7

2,94

1.52/33

1.38/8

1.76/17

1.25/16

2017-04-30

Betis

1-4

Alaves

37/-16

2,65

1.09/34

1.13/8

1.41/17

0.76/17

32/-8

2,12

1.32/34

1.38/8

1.35/17

1.29/17

2017-05-07

Alaves

1-0

Ath Bilbao

36/-5

2,20

1.37/35

1.38/8

1.35/17

1.39/18

51/13

2,54

1.77/35

2.25/8

2.33/18

1.18/17

2017-05-14

Alaves

3-1

Celta Vigo

37/-4

2,17

1.42/36

1.38/8

1.44/18

1.39/18

49/-11

3,11

1.26/35

0.75/8

1.65/17

0.89/18

2017-05-20

Leganes

1-1

Alaves

35/-19

2,41

0.92/37

0.88/8

1.11/18

0.74/19

40/-2

2,22

1.46/37

1.75/8

1.53/19

1.39/18