SELECT * FROM 1_Kampe WHERE LigaID = '2' AND (Home='Crystal Palace' OR Away='Crystal Palace') 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-10 Crystal Palace 0-0 Everton 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-18 Sheffield Utd 1-0 Crystal Palace 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2019-08-24 Manchester Utd 1-2 Crystal Palace 5/4 3,00 2.00/2 2.00/2 3.00/1 1.00/1   0/-1 0,50 0.50/2 0.50/2 1.00/1 0.00/1
2019-08-31 Crystal Palace 1-0 Aston Villa 2/0 1,33 1.33/3 1.33/3 1.00/1 1.50/2   4/-1 3,00 1.00/3 1.00/3 1.50/2 0.00/1
2019-09-14 Tottenham 4-0 Crystal Palace 7/1 3,25 1.25/4 1.25/4 1.50/2 1.00/2   3/1 1,25 1.75/4 1.75/4 2.00/2 1.50/2
2019-09-22 Crystal Palace 1-1 Wolves 3/-3 1,80 1.40/5 1.40/5 2.00/2 1.00/3   6/-4 3,20 0.60/5 0.60/5 0.67/3 0.50/2
2019-09-28 Crystal Palace 2-0 Norwich 4/-3 1,83 1.33/6 1.33/6 1.67/3 1.00/3   9/-5 3,83 1.00/6 1.00/6 2.00/3 0.00/3
2019-10-05 West Ham 1-2 Crystal Palace 10/1 2,71 1.71/7 1.71/7 2.00/3 1.50/4   6/-1 1,86 1.57/7 1.57/7 2.00/4 1.00/3
2019-10-19 Crystal Palace 0-2 Manchester City 8/0 2,00 1.75/8 1.75/8 2.00/4 1.50/4   27/18 4,50 2.00/8 2.00/8 1.75/4 2.25/4
2019-10-27 Arsenal 2-2 Crystal Palace 13/1 2,78 1.67/9 1.50/8 2.50/4 1.00/5   8/-2 2,00 1.56/9 1.63/8 1.60/5 1.50/4
2019-11-03 Crystal Palace 0-2 Leicester 10/-2 2,20 1.50/10 1.75/8 1.60/5 1.40/5   25/17 3,30 2.00/10 2.25/8 2.60/5 1.40/5
2019-11-09 Chelsea 2-0 Crystal Palace 25/8 3,82 2.09/11 2.38/8 1.60/5 2.50/6   10/-4 2,18 1.36/11 1.38/8 1.33/6 1.40/5
2019-11-23 Crystal Palace 1-2 Liverpool 10/-6 2,17 1.25/12 1.00/8 1.33/6 1.17/6   28/18 3,17 2.83/12 2.75/8 3.00/6 2.67/6
2019-11-30 Burnley 0-2 Crystal Palace 20/2 2,92 1.38/13 1.63/8 2.00/6 0.86/7   11/-7 2,23 1.15/13 1.00/8 1.14/7 1.17/6
2019-12-03 Crystal Palace 1-0 Bournemouth 13/-5 2,21 1.29/14 1.25/8 1.14/7 1.43/7   18/-2 2,71 1.14/14 0.75/8 1.29/7 1.00/7
2019-12-07 Watford 0-0 Crystal Palace 9/-21 2,60 0.53/15 0.75/8 0.43/7 0.63/8   14/-4 2,13 1.40/15 1.25/8 1.38/8 1.43/7
2019-12-16 Crystal Palace 1-1 Brighton 14/-4 2,00 1.38/16 1.00/8 1.38/8 1.38/8   20/-4 2,75 1.19/16 1.25/8 1.50/8 0.88/8
2019-12-21 Newcastle 1-0 Crystal Palace 17/-7 2,41 1.29/17 1.75/8 1.63/8 1.00/9   15/-4 2,00 1.35/17 1.13/8 1.33/9 1.38/8
2019-12-26 Crystal Palace 2-1 West Ham 15/-5 1,94 1.28/18 1.00/8 1.33/9 1.22/9   19/-9 2,76 1.12/17 0.88/8 0.88/8 1.33/9
2019-12-28 Southampton 1-1 Crystal Palace 23/-14 3,16 1.11/19 1.63/8 0.78/9 1.40/10   17/-4 2,00 1.37/19 1.38/8 1.50/10 1.22/9
2020-01-01 Norwich 1-1 Crystal Palace 21/-19 3,05 0.65/20 0.75/8 0.80/10 0.50/10   18/-4 2,00 1.35/20 1.50/8 1.50/10 1.20/10
2020-01-11 Crystal Palace 1-1 Arsenal 19/-4 2,00 1.33/21 1.63/8 1.50/10 1.18/11   28/-2 2,76 1.29/21 1.13/8 1.45/11 1.10/10
2020-01-18 Manchester City 2-2 Crystal Palace 62/37 3,95 2.14/22 2.25/8 2.27/11 2.00/11   20/-4 2,00 1.32/22 1.38/8 1.45/11 1.18/11
2020-01-21 Crystal Palace 0-2 Southampton 22/-4 2,09 1.30/23 1.13/8 1.45/11 1.17/12   29/-13 3,09 1.22/23 1.63/8 0.92/12 1.55/11
2020-02-01 Crystal Palace 0-1 Sheffield Utd 22/-6 2,08 1.25/24 1.00/8 1.33/12 1.17/12   25/2 2,00 1.38/24 1.38/8 1.42/12 1.33/12
2020-02-08 Everton 3-1 Crystal Palace 31/-6 2,72 1.32/25 1.88/8 1.75/12 0.92/13   22/-7 2,04 1.20/25 0.88/8 1.23/13 1.17/12
2020-02-22 Crystal Palace 1-0 Newcastle 23/-9 2,12 1.15/26 0.88/8 1.23/13 1.08/13   24/-16 2,46 1.19/26 0.75/8 1.54/13 0.85/13
2020-02-29 Brighton 0-1 Crystal Palace 32/-7 2,63 1.04/27 1.00/8 1.38/13 0.71/14   24/-8 2,07 1.22/27 0.88/8 1.36/14 1.08/13
2020-03-07 Crystal Palace 1-0 Watford 25/-7 2,04 1.29/28 1.13/8 1.36/14 1.21/14   27/-16 2,50 0.96/28 1.38/8 1.21/14 0.71/14
2020-06-20 Bournemouth 0-2 Crystal Palace 29/-18 2,62 0.93/29 0.88/8 1.21/14 0.67/15   26/-6 2,00 1.34/29 1.38/8 1.47/15 1.21/14
2020-06-24 Liverpool 4-0 Crystal Palace 66/45 2,90 2.77/30 2.38/8 3.00/15 2.53/15   28/-4 2,00 1.40/30 1.63/8 1.47/15 1.33/15
2020-06-29 Crystal Palace 0-1 Burnley 28/-8 2,06 1.35/31 1.50/8 1.47/15 1.25/16   35/-10 2,58 1.35/31 1.88/8 1.63/16 1.07/15
2020-07-04 Leicester 3-0 Crystal Palace 60/29 2,84 1.72/32 0.88/8 1.94/16 1.50/16   28/-9 2,03 1.31/32 1.50/8 1.38/16 1.25/16
2020-07-07 Crystal Palace 2-3 Chelsea 28/-12 2,06 1.27/33 1.50/8 1.38/16 1.18/17   60/16 3,15 1.73/33 2.00/8 1.76/17 1.69/16
2020-07-12 Aston Villa 2-0 Crystal Palace 36/-29 2,97 0.79/34 0.25/8 1.06/17 0.53/17   30/-13 2,15 1.24/34 1.50/8 1.29/17 1.18/17
2020-07-16 Crystal Palace 0-2 Manchester Utd 30/-15 2,14 1.20/35 1.13/8 1.29/17 1.11/18   61/26 2,74 1.69/35 2.25/8 2.00/18 1.35/17
2020-07-20 Wolves 2-0 Crystal Palace 49/11 2,42 1.56/36 1.75/8 1.56/18 1.56/18   30/-17 2,14 1.17/36 0.75/8 1.22/18 1.11/18
2020-07-26 Crystal Palace 1-1 Tottenham 30/-19 2,14 1.14/37 0.38/8 1.22/18 1.05/19   60/14 2,86 1.57/37 2.13/8 2.05/19 1.06/18