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

Cadiz CF

1-0

Almeria

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-26

Almeria

1-1

Tenerife

0/-1

1,00

0.00/1

0.00/1

0.00/0

0.00/1

1/0

2,00

1.00/1

1.00/1

0.00/0

1.00/1

2018-09-03

Almeria

0-1

Malaga

1/-1

1,50

0.50/2

0.50/2

1.00/1

0.00/1

3/2

2,00

3.00/2

3.00/2

3.00/1

3.00/1

2018-09-08

Osasuna

3-1

Almeria

1/-3

1,67

0.33/3

0.33/3

1.00/1

0.00/2

1/-2

1,33

0.33/3

0.33/3

0.50/2

0.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-23

Numancia

0-2

Almeria

8/0

3,20

1.20/5

1.20/5

2.00/2

0.67/3

4/-3

2,20

0.80/5

0.80/5

1.33/3

0.00/2

2018-09-30

Almeria

2-0

Reus FCR

6/-1

2,17

1.17/6

1.17/6

1.33/3

1.00/3

5/0

1,67

1.33/6

1.33/6

0.67/3

2.00/3

2018-10-06

Cordoba

1-0

Almeria

8/-10

3,71

0.43/7

0.43/7

0.75/4

0.00/3

8/1

2,14

1.43/7

1.43/7

1.75/4

1.00/3

2018-10-13

Almeria

3-0

Las Palmas

8/0

2,00

1.25/8

1.25/8

1.75/4

0.75/4

11/7

1,88

1.88/8

1.88/8

2.20/5

1.33/3

2018-10-21

Almeria

0-1

Reus Deportiu

11/3

2,11

1.44/9

1.63/8

2.00/5

0.75/4

8/-1

1,00

1.41/17

1.88/8

0.00/9

3.00/8

2018-10-21

Albacete

1-1

Almeria

14/4

2,67

1.44/9

1.50/8

1.50/4

1.40/5

11/2

2,00

1.30/10

2.00/8

1.67/6

0.75/4

2018-10-21

Reus Deportiu

0-1

Almeria

18/0

1,00

1.50/36

1.88/8

0.00/18

3.00/18

12/2

2,00

1.27/11

2.00/8

1.67/6

0.80/5

2018-10-27

Granada CF

1-0

Almeria

18/9

2,25

1.92/12

1.88/8

2.17/6

1.67/6

13/3

1,92

1.42/12

2.00/8

1.67/6

1.17/6

2018-11-04

Almeria

2-1

Gijon

13/2

1,85

1.31/13

1.63/8

1.67/6

1.00/7

10/2

1,38

1.31/13

1.13/8

1.71/7

0.83/6

2018-11-11

Rayo Majadahonda

2-0

Almeria

10/-8

2,00

1.14/14

1.25/8

1.43/7

0.86/7

15/3

1,93

1.43/14

1.63/8

1.86/7

1.00/7

2018-11-19

Almeria

1-1

Dep. La Coruna

15/1

1,93

1.33/15

1.25/8

1.86/7

0.88/8

24/14

2,27

1.93/15

1.88/8

2.29/7

1.63/8

2018-11-24

Gimnastic

2-2

Almeria

9/-14

2,00

0.75/16

0.75/8

0.88/8

0.63/8

16/1

1,94

1.31/16

1.38/8

1.75/8

0.88/8

2018-12-01

Almeria

1-1

Extremadura UD

18/1

2,06

1.29/17

1.13/8

1.75/8

0.89/9

23/-3

2,88

1.06/17

1.25/8

0.78/9

1.38/8

2018-12-08

R. Oviedo

1-2

Almeria

20/-2

2,33

1.44/18

1.38/8

1.67/9

1.22/9

19/1

2,06

1.28/18

1.25/8

1.67/9

0.89/9

2018-12-16

Almeria

1-1

Lugo

21/2

2,11

1.37/19

1.25/8

1.67/9

1.10/10

18/-2

2,00

1.16/19

1.25/8

1.30/10

1.00/9

2018-12-22

Elche

2-2

Almeria

17/-6

2,00

1.15/20

1.13/8

1.30/10

1.00/10

22/2

2,10

1.35/20

1.25/8

1.60/10

1.10/10

2019-01-06

Almeria

2-0

Mallorca

24/2

2,19

1.33/21

1.38/8

1.60/10

1.09/11

26/8

2,10

1.57/21

1.75/8

1.82/11

1.30/10

2019-01-13

Alcorcon

0-0

Almeria

20/5

1,59

1.55/22

1.25/8

2.09/11

1.00/11

26/4

2,18

1.41/22

1.38/8

1.73/11

1.09/11

2019-01-19

Almeria

0-0

Cadiz CF

26/4

2,09

1.39/23

1.50/8

1.73/11

1.08/12

29/11

2,04

1.57/23

2.00/8

1.83/12

1.27/11

2019-01-26

Almeria

0-1

Osasuna

26/4

2,00

1.38/24

1.50/8

1.67/12

1.08/12

30/5

2,29

1.71/24

2.00/8

2.42/12

1.00/12

2019-02-01

Malaga

1-1

Almeria

27/9

1,80

1.84/25

1.75/8

2.25/12

1.46/13

26/3

1,96

1.32/25

1.38/8

1.54/13

1.08/12

2019-02-10

Almeria

1-0

Numancia

27/3

1,96

1.31/26

1.38/8

1.54/13

1.08/13

31/0

2,38

1.27/26

1.25/8

1.69/13

0.85/13

2019-02-17

Reus FCR

0-0

Almeria

16/-13

1,80

0.84/25

0.63/8

0.62/13

1.08/12

28/4

1,93

1.37/27

1.38/8

1.64/14

1.08/13

2019-02-24

Almeria

3-1

Cordoba

28/4

1,86

1.32/28

1.25/8

1.64/14

1.00/14

32/-16

2,86

0.86/28

0.88/8

1.07/14

0.64/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-09

Gijon

1-0

Almeria

31/3

1,97

1.30/30

1.25/8

1.47/15

1.13/15

33/7

1,97

1.43/30

1.50/8

1.73/15

1.13/15

2019-03-17

Almeria

0-0

Granada CF

33/6

1,94

1.39/31

1.38/8

1.73/15

1.06/16

37/18

1,81

1.81/31

1.63/8

1.75/16

1.87/15

2019-03-22

Dep. La Coruna

0-0

Almeria

40/17

1,97

1.63/32

1.25/8

1.88/16

1.38/16

33/6

1,88

1.38/32

1.38/8

1.69/16

1.06/16

2019-03-30

Almeria

2-2

Rayo Majadahonda

33/6

1,82

1.36/33

1.50/8

1.69/16

1.06/17

32/-10

2,24

1.18/33

1.63/8

1.47/17

0.88/16

2019-04-06

Extremadura UD

1-0

Almeria

34/-9

2,26

0.88/34

0.63/8

0.82/17

0.94/17

35/6

1,88

1.35/34

1.50/8

1.65/17

1.06/17

2019-04-13

Almeria

3-0

Gimnastic

35/5

1,86

1.31/35

1.13/8

1.65/17

1.00/18

19/-27

1,86

0.77/35

0.88/8

1.06/17

0.50/18

2019-04-21

Tenerife

1-3

Almeria

33/-7

2,03

1.11/36

1.25/8

1.44/18

0.78/18

38/8

1,89

1.36/36

1.50/8

1.72/18

1.00/18

2019-04-27

Almeria

0-1

R. Oviedo

41/10

1,95

1.41/37

1.50/8

1.72/18

1.11/19

40/1

2,14

1.43/37

0.88/8

1.68/19

1.17/18

2019-05-05

Lugo

4-2

Almeria

37/-12

2,26

0.97/38

0.75/8

1.05/19

0.89/19

41/9

1,92

1.37/38

1.13/8

1.63/19

1.11/19

2019-05-12

Almeria

5-3

Elche

43/7

2,03

1.33/39

1.13/8

1.63/19

1.05/20

40/-2

2,10

1.28/39

1.75/8

1.65/20

0.89/19

2019-05-19

Mallorca

1-0

Almeria

51/15

2,18

1.60/40

1.63/8

2.10/20

1.10/20

48/9

2,18

1.38/40

1.38/8

1.70/20

1.05/20

2019-05-26

Almeria

0-0

Alcorcon

48/8

2,15

1.34/41

1.25/8

1.70/20

1.00/21

32/-7

1,73

1.17/41

0.63/8

1.57/21

0.75/20

2019-06-02

Las Palmas

0-0

Almeria

48/-2

2,33

1.31/42

1.25/8

1.67/21

0.95/21

48/8

2,10

1.33/42

1.25/8

1.67/21

1.00/21

2019-06-08

Almeria

3-0

Albacete

48/8

2,05

1.33/43

1.38/8

1.67/21

1.00/22

55/19

2,12

1.72/43

1.38/8

1.68/22

1.76/21