SELECT * FROM 1_Kampe WHERE LigaID = '25' AND (Home='Bolton' OR Away='Bolton') 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
2017-08-06 Bolton 2-3 Leeds 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
2017-08-12 Millwall 1-1 Bolton 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   2/-1 5,00 0.00/1 0.00/1 0.00/1 0.00/0
2017-08-15 Birmingham 0-0 Bolton 2/0 2,00 1.50/2 1.50/2 3.00/1 0.00/1   3/-1 3,50 0.50/2 0.50/2 0.00/1 1.00/1
2017-08-19 Bolton 1-2 Derby 3/-1 2,33 0.67/3 0.67/3 0.00/1 1.00/2   2/-1 1,67 1.33/3 1.33/3 1.50/2 1.00/1
2017-08-25 Hull 4-0 Bolton 8/1 3,75 1.00/4 1.00/4 1.50/2 0.50/2   4/-2 2,50 0.50/4 0.50/4 0.00/2 1.00/2
2017-09-09 Bolton 0-3 Middlesbrough 4/-6 2,80 0.40/5 0.40/5 0.00/2 0.67/3   4/1 1,40 1.40/5 1.40/5 2.33/3 0.00/2
2017-09-12 Bolton 0-1 Sheffield Utd 4/-9 2,83 0.33/6 0.33/6 0.00/3 0.67/3   7/2 2,00 2.00/6 2.00/6 3.00/3 1.00/3
2017-09-16 Ipswich 2-0 Bolton 10/2 3,00 2.00/6 2.00/6 2.00/3 2.00/3   4/-10 2,57 0.29/7 0.29/7 0.00/4 0.67/3
2017-09-23 Bolton 0-3 Brentford 4/-12 2,50 0.25/8 0.25/8 0.00/4 0.50/4   7/-5 2,38 0.50/8 0.50/8 0.75/4 0.25/4
2017-09-26 Bristol City 2-0 Bolton 15/5 2,78 1.56/9 1.38/8 2.00/4 1.20/5   4/-15 2,56 0.22/9 0.25/8 0.00/5 0.50/4
2017-09-30 Aston Villa 1-0 Bolton 16/6 2,60 1.60/10 1.88/8 1.80/5 1.40/5   4/-17 2,50 0.20/10 0.13/8 0.00/5 0.40/5
2017-10-14 Bolton 2-1 Sheffield Wed 4/-18 2,36 0.18/11 0.00/8 0.00/5 0.33/6   15/3 2,45 1.45/11 1.75/8 1.83/6 1.00/5
2017-10-21 Bolton 1-1 QPR 6/-17 2,42 0.42/12 0.38/8 0.50/6 0.33/6   15/-1 2,58 1.17/12 0.88/8 1.83/6 0.50/6
2017-10-28 Fulham 1-1 Bolton 17/3 2,38 1.38/13 1.50/8 1.17/6 1.57/7   7/-17 2,38 0.46/13 0.50/8 0.57/7 0.33/6
2017-10-31 Sunderland 3-3 Bolton 17/-10 3,14 0.64/14 0.50/8 0.29/7 1.00/7   8/-17 2,36 0.50/14 0.63/8 0.57/7 0.43/7
2017-11-04 Bolton 2-1 Norwich 11/-17 2,60 0.53/15 0.75/8 0.57/7 0.50/8   14/-4 2,13 1.47/15 1.75/8 1.13/8 1.86/7
2017-11-17 Preston 0-0 Bolton 19/0 2,38 1.31/16 0.75/8 1.50/8 1.13/8   13/-16 2,63 0.69/16 1.13/8 0.88/8 0.50/8
2017-11-21 Bolton 2-2 Reading 13/-16 2,47 0.71/17 1.25/8 0.88/8 0.56/9   18/-3 2,44 1.13/16 1.13/8 1.00/8 1.25/8
2017-11-25 Wolves 5-1 Bolton 35/19 2,83 2.28/18 2.63/8 2.44/9 2.11/9   15/-16 2,56 0.72/18 1.38/8 0.89/9 0.56/9
2017-12-02 Bolton 3-1 Barnsley 16/-20 2,74 0.68/19 1.38/8 0.89/9 0.50/10   23/-5 2,68 1.05/19 1.00/8 1.10/10 1.00/9
2017-12-09 Nottingham 3-2 Bolton 28/-5 3,05 1.35/20 1.50/8 1.80/10 0.90/10   19/-18 2,80 0.80/20 1.38/8 1.10/10 0.50/10
2017-12-16 Bolton 0-1 Burton 21/-19 2,90 0.76/21 1.25/8 1.10/10 0.45/11   13/-27 2,52 0.67/21 0.50/8 0.64/11 0.70/10
2017-12-23 Bolton 2-0 Cardiff 21/-20 2,82 0.73/22 1.13/8 1.00/11 0.45/11   33/17 2,23 2.14/22 2.38/8 2.45/11 1.82/11
2017-12-26 Middlesbrough 2-0 Bolton 30/7 2,30 1.52/23 1.50/8 1.82/11 1.25/12   23/-18 2,78 0.83/23 1.38/8 1.17/12 0.45/11
2017-12-30 Sheffield Utd 0-1 Bolton 39/10 2,83 1.71/24 1.00/8 2.08/12 1.33/12   23/-20 2,75 0.79/24 1.00/8 1.17/12 0.42/12
2018-01-01 Bolton 1-0 Hull 24/-19 2,68 0.88/25 1.25/8 1.17/12 0.62/13   39/-4 3,28 0.96/25 0.88/8 1.23/13 0.67/12
2018-01-13 Brentford 2-0 Bolton 39/4 2,85 1.42/26 1.75/8 1.69/13 1.15/13   25/-18 2,62 0.96/26 1.50/8 1.31/13 0.62/13
2018-01-20 Bolton 1-1 Ipswich 25/-20 2,59 0.93/27 1.50/8 1.31/13 0.57/14   40/1 2,93 1.44/27 1.25/8 1.86/14 1.00/13
2018-02-02 Bolton 1-0 Bristol City 26/-20 2,57 0.93/28 1.25/8 1.29/14 0.57/14   42/10 2,55 1.76/29 1.38/8 1.80/15 1.71/14
2018-02-10 Bolton 1-1 Fulham 27/-19 2,52 1.00/29 1.63/8 1.40/15 0.57/14   51/16 2,87 1.70/30 2.75/8 1.80/15 1.60/15
2018-02-13 Cardiff 2-0 Bolton 45/18 2,40 1.83/30 1.00/8 2.14/14 1.56/16   28/-19 2,50 1.00/30 1.75/8 1.38/16 0.57/14
2018-02-17 QPR 2-0 Bolton 33/-11 2,48 1.16/31 1.25/8 1.67/15 0.69/16   28/-21 2,48 0.97/31 1.38/8 1.38/16 0.53/15
2018-02-20 Bolton 1-0 Sunderland 28/-23 2,47 0.94/32 1.38/8 1.38/16 0.50/16   34/-23 2,84 0.81/32 0.88/8 0.69/16 0.94/16
2018-02-24 Norwich 0-0 Bolton 34/-3 2,15 1.39/33 1.88/8 1.31/16 1.47/17   29/-22 2,42 1.00/33 1.38/8 1.47/17 0.50/16
2018-03-03 Bolton 1-3 Preston 29/-22 2,35 1.00/34 1.13/8 1.47/17 0.53/17   40/7 2,15 1.50/34 1.38/8 1.47/17 1.53/17
2018-03-06 Reading 1-1 Bolton 39/-9 2,56 1.00/34 0.75/8 0.82/17 1.18/17   30/-24 2,40 0.97/35 1.13/8 1.39/18 0.53/17
2018-03-10 Sheffield Wed 1-1 Bolton 38/-12 2,44 1.03/36 0.63/8 1.17/18 0.89/18   31/-24 2,39 0.97/36 1.13/8 1.39/18 0.56/18
2018-03-17 Bolton 1-0 Aston Villa 32/-24 2,38 0.97/37 0.88/8 1.39/18 0.58/19   61/25 2,62 1.86/37 2.00/8 2.05/19 1.67/18
2018-03-30 Leeds 2-1 Bolton 50/-3 2,71 1.32/38 0.75/8 1.37/19 1.26/19   33/-23 2,34 1.03/38 1.13/8 1.47/19 0.58/19
2018-04-03 Bolton 0-1 Birmingham 34/-24 2,36 1.00/39 1.13/8 1.47/19 0.55/20   29/-28 2,21 0.92/39 0.75/8 1.30/20 0.53/19
2018-04-07 Derby 3-0 Bolton 57/19 2,44 1.67/39 0.88/8 1.68/19 1.65/20   34/-25 2,33 0.98/40 1.13/8 1.40/20 0.55/20
2018-04-10 Bolton 0-2 Millwall 34/-28 2,34 0.95/41 0.75/8 1.40/20 0.52/21   52/13 2,22 1.59/41 2.50/8 1.90/21 1.25/20
2018-04-14 Barnsley 2-2 Bolton 42/-19 2,51 0.90/41 0.75/8 0.95/21 0.85/20   34/-30 2,33 0.93/42 0.63/8 1.33/21 0.52/21
2018-04-21 Bolton 0-4 Wolves 36/-30 2,37 0.93/43 0.75/8 1.33/21 0.55/22   78/42 2,65 2.21/43 2.38/8 2.36/22 2.05/21
2018-04-28 Burton 2-0 Bolton 35/-44 2,59 0.86/44 1.00/8 0.64/22 1.09/22   36/-34 2,41 0.91/44 0.63/8 1.27/22 0.55/22
2018-05-06 Bolton 3-2 Nottingham 36/-36 2,40 0.89/45 0.50/8 1.27/22 0.52/23   49/-13 2,47 1.18/45 1.00/8 1.43/23 0.91/22