SELECT * FROM 1_Kampe WHERE LigaID = '5' AND (Home='Gillingham' OR Away='Gillingham') 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-04 Accrington 0-2 Gillingham 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-11 Gillingham 3-1 Burton 2/2 2,00 3.00/1 3.00/1 0.00/0 3.00/1   1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-08-18 Walsall 2-1 Gillingham 3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1   5/4 3,00 3.00/2 3.00/2 3.00/1 3.00/1
2018-08-22 Gillingham 1-4 Sunderland 6/3 3,00 2.00/3 2.00/3 3.00/1 1.50/2   6/4 2,67 2.33/3 2.33/3 3.00/2 1.00/1
2018-08-25 Gillingham 1-1 Coventry 7/0 3,50 1.50/4 1.50/4 1.50/2 1.50/2   2/-2 1,50 1.00/4 1.00/4 1.50/2 0.50/2
2018-09-01 Barnsley 2-1 Gillingham 12/10 2,80 2.20/5 2.20/5 2.00/2 2.33/3   8/0 3,20 1.40/5 1.40/5 1.33/3 1.50/2
2018-09-08 Gillingham 0-1 AFC Wimbledon 9/-1 3,17 1.17/6 1.17/6 1.33/3 1.00/3   3/-5 1,83 0.83/6 0.83/6 0.33/3 1.33/3
2018-09-15 Rochdale 3-0 Gillingham 10/-6 3,71 1.14/7 1.14/7 0.00/3 2.00/4   9/-2 2,86 1.00/7 1.00/7 1.00/4 1.00/3
2018-09-22 Gillingham 2-4 Peterborough 9/-5 2,88 0.88/8 0.88/8 1.00/4 0.75/4   20/11 3,63 2.38/8 2.38/8 1.75/4 3.00/4
2018-09-29 Shrewsbury 2-2 Gillingham 7/-2 1,78 0.78/9 0.88/8 1.25/4 0.40/5   11/-7 3,22 0.78/9 0.50/8 0.80/5 0.75/4
2018-10-06 Portsmouth 0-2 Gillingham 21/13 2,64 2.45/11 2.25/8 2.20/5 2.67/6   13/-7 3,30 0.80/10 0.25/8 0.80/5 0.80/5
2018-10-13 Gillingham 0-2 Southend 15/-5 3,18 1.00/11 0.63/8 0.80/5 1.17/6   15/-1 2,58 1.42/12 1.63/8 1.17/6 1.67/6
2018-10-20 Doncaster 3-3 Gillingham 21/5 2,85 1.85/13 2.00/8 1.83/6 1.86/7   15/-7 3,08 0.92/12 0.63/8 0.67/6 1.17/6
2018-10-23 Plymouth 3-1 Gillingham 11/-14 2,57 0.50/14 0.63/8 0.71/7 0.29/7   18/-7 3,31 0.92/13 0.63/8 0.67/6 1.14/7
2018-10-27 Gillingham 4-0 Bradford City 19/-9 3,36 0.86/14 0.63/8 0.67/6 1.00/8   12/-14 2,53 0.67/15 0.50/8 0.50/8 0.86/7
2018-11-03 Gillingham 3-0 Fleetwood 23/-5 3,40 1.00/15 1.00/8 1.00/7 1.00/8   24/8 2,50 1.44/16 1.25/8 1.50/8 1.38/8
2018-11-06 Gillingham 0-1 Blackpool 26/-2 3,38 1.13/16 1.38/8 1.25/8 1.00/8   17/2 2,13 1.47/15 1.50/8 1.67/9 1.17/6
2018-11-17 Oxford Utd 1-0 Gillingham 20/-7 2,76 0.88/17 1.25/8 1.13/8 0.67/9   26/-3 3,24 1.06/17 1.38/8 1.11/9 1.00/8
2018-11-24 Gillingham 1-3 Luton 26/-4 3,11 1.00/18 1.25/8 1.11/9 0.89/9   32/12 2,89 1.78/18 2.38/8 2.56/9 1.00/9
2018-11-27 Bristol Rovers 1-2 Gillingham 16/-3 1,84 0.89/19 0.88/8 0.89/9 0.90/10   27/-6 3,16 0.95/19 0.88/8 1.00/10 0.89/9
2018-12-08 Scunthorpe 0-2 Gillingham 29/-13 3,55 1.05/20 0.50/8 1.00/10 1.10/10   29/-5 3,15 1.05/20 1.25/8 1.00/10 1.10/10
2018-12-15 Gillingham 2-2 Wycombe 31/-3 3,10 1.14/21 1.50/8 1.00/10 1.27/11   30/2 2,76 1.48/21 2.38/8 1.91/11 1.00/10
2018-12-22 Charlton 2-0 Gillingham 36/11 2,77 1.82/22 2.25/8 2.09/11 1.55/11   33/-3 3,14 1.14/22 1.63/8 1.00/11 1.27/11
2018-12-26 Gillingham 2-0 Portsmouth 33/-5 3,09 1.09/23 1.25/8 1.00/11 1.17/12   39/20 2,52 2.22/23 2.13/8 2.00/12 2.45/11
2018-12-29 Gillingham 1-3 Doncaster 35/-3 3,04 1.17/24 1.25/8 1.17/12 1.17/12   39/8 2,92 1.63/24 1.75/8 1.83/12 1.42/12
2019-01-01 Southend 2-0 Gillingham 30/-1 2,44 1.28/25 1.13/8 1.33/12 1.23/13   36/-5 3,08 1.12/25 1.25/8 1.08/13 1.17/12
2019-01-12 Burton 2-3 Gillingham 34/1 2,58 1.35/26 1.38/8 1.77/13 0.92/13   36/-7 3,04 1.08/26 1.25/8 1.08/13 1.08/13
2019-01-19 Gillingham 0-3 Walsall 39/-6 3,11 1.15/27 1.63/8 1.08/13 1.21/14   29/-14 2,67 1.19/27 0.63/8 1.14/14 1.23/13
2019-01-29 Gillingham 0-0 Accrington 39/-9 3,11 1.11/28 1.25/8 1.00/14 1.21/14   27/-9 2,33 1.30/27 0.88/8 1.31/13 1.29/14
2019-02-02 Coventry 1-1 Gillingham 31/-5 2,23 1.30/30 1.25/8 1.47/15 1.13/15   39/-9 3,00 1.10/29 1.00/8 1.00/15 1.21/14
2019-02-09 Gillingham 1-4 Barnsley 40/-9 2,97 1.10/30 1.00/8 1.00/15 1.20/15   53/27 2,63 1.97/30 2.50/8 2.33/15 1.60/15
2019-02-16 Gillingham 1-0 Scunthorpe 41/-12 3,03 1.06/31 1.00/8 0.94/16 1.20/15   40/-16 3,00 1.25/32 2.38/8 1.25/16 1.25/16
2019-02-19 Sunderland 4-2 Gillingham 53/23 2,68 1.90/31 1.50/8 2.00/16 1.80/15   42/-11 2,97 1.13/32 1.00/8 1.06/17 1.20/15
2019-02-23 Wycombe 0-1 Gillingham 42/-5 2,70 1.30/33 1.38/8 1.75/16 0.88/17   44/-13 3,06 1.09/33 1.00/8 1.06/17 1.13/16
2019-03-02 Fleetwood 1-1 Gillingham 45/9 2,38 1.41/34 1.75/8 1.53/17 1.29/17   45/-12 3,00 1.15/34 1.38/8 1.06/17 1.24/17
2019-03-09 Gillingham 1-0 Oxford Utd 46/-12 2,97 1.14/35 1.13/8 1.06/17 1.22/18   43/-10 2,74 1.11/35 1.50/8 1.44/18 0.76/17
2019-03-12 Gillingham 0-1 Bristol Rovers 47/-11 2,92 1.19/36 1.50/8 1.17/18 1.22/18   36/-1 2,09 1.14/35 1.50/8 0.94/18 1.35/17
2019-03-16 Luton 2-2 Gillingham 70/41 2,68 2.14/37 2.50/8 2.56/18 1.74/19   47/-12 2,86 1.16/37 1.38/8 1.11/19 1.22/18
2019-03-23 AFC Wimbledon 2-4 Gillingham 32/-21 2,24 1.03/38 2.00/8 0.95/19 1.11/19   49/-12 2,89 1.16/38 1.38/8 1.11/19 1.21/19
2019-03-30 Gillingham 1-1 Rochdale 53/-10 2,97 1.21/39 1.75/8 1.11/19 1.30/20   47/-29 3,24 1.08/38 1.25/8 1.10/20 1.06/18
2019-04-06 Peterborough 2-0 Gillingham 60/6 2,92 1.49/39 1.13/8 1.35/20 1.63/19   54/-10 2,95 1.20/40 1.50/8 1.10/20 1.30/20
2019-04-13 Gillingham 0-2 Shrewsbury 54/-12 2,93 1.17/41 1.50/8 1.10/20 1.24/21   45/-8 2,39 1.15/41 1.38/8 1.52/21 0.75/20
2019-04-19 Gillingham 3-1 Plymouth 54/-14 2,90 1.14/42 1.13/8 1.05/21 1.24/21   51/-16 2,81 1.12/42 0.75/8 1.43/21 0.81/21
2019-04-22 Bradford City 1-1 Gillingham 45/-29 2,77 0.84/43 0.38/8 1.10/21 0.59/22   57/-12 2,93 1.19/43 1.38/8 1.14/22 1.24/21
2019-04-27 Gillingham 0-2 Charlton 58/-12 2,91 1.18/44 1.13/8 1.14/22 1.23/22   67/27 2,43 1.86/44 2.38/8 2.27/22 1.45/22
2019-05-04 Blackpool 0-3 Gillingham 50/1 2,20 1.38/45 1.13/8 1.45/22 1.30/23   58/-14 2,89 1.16/45 1.13/8 1.09/23 1.23/22