SELECT * FROM 1_Kampe WHERE LigaID = '58' AND (Home='Nurnberg' OR Away='Nurnberg') 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
2014-08-03 Nurnberg 1-0 Aue 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
2014-08-11 Greuther Furth 5-1 Nurnberg 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2014-08-23 Nurnberg 0-1 FSV Frankfurt 2/-3 3,50 1.50/2 1.50/2 3.00/1 0.00/1   5/-3 4,33 0.00/3 0.00/3 0.00/2 0.00/1
2014-08-29 Union Berlin 0-4 Nurnberg 2/0 1,00 1.00/4 1.00/4 1.00/1 1.00/3   2/-4 2,67 1.00/3 1.00/3 1.50/2 0.00/1
2014-09-15 Nurnberg 0-2 Dusseldorf 6/0 3,00 1.50/4 1.50/4 1.50/2 1.50/2   6/-1 2,60 1.00/5 1.00/5 0.33/3 2.00/2
2014-09-21 Karlsruher SC 3-0 Nurnberg 7/3 2,20 1.80/5 1.80/5 1.00/2 2.33/3   6/-2 2,80 1.20/5 1.20/5 1.00/3 1.50/2
2014-09-21 Karlsruher 3-0 Nurnberg 7/3 2,20 1.80/5 1.80/5 1.00/2 2.33/3   6/-5 2,83 1.00/6 0.86/7 1.00/3 1.00/3
2014-09-24 Heidenheim 3-0 Nurnberg 11/-1 3,29 1.29/7 1.29/7 2.33/3 0.50/4   6/-8 2,86 0.86/7 0.86/7 1.00/3 0.75/4
2014-09-29 Nurnberg 3-2 Kaiserslautern 6/-11 2,88 0.75/8 0.75/8 1.00/3 0.60/5   11/3 2,71 2.00/7 2.00/7 3.00/4 0.67/3
2014-10-03 Bochum 1-1 Nurnberg 17/4 3,33 1.56/9 1.63/8 1.00/5 2.25/4   9/-10 3,11 1.00/9 0.75/8 1.50/4 0.60/5
2014-10-17 Nurnberg 1-0 RB Leipzig 10/-10 3,00 1.00/10 0.88/8 1.50/4 0.67/6   17/9 2,50 1.90/10 1.88/8 2.33/6 1.25/4
2014-10-27 Darmstadt 3-0 Nurnberg 15/4 2,60 1.60/10 1.50/8 2.40/5 0.80/5   11/-9 2,82 1.18/11 1.25/8 1.80/5 0.67/6
2014-11-01 Nurnberg 2-2 St. Pauli 11/-12 2,83 1.08/12 0.88/8 1.80/5 0.57/7   11/-13 2,92 0.92/12 0.88/8 1.43/7 0.20/5
2014-11-07 Sandhausen 2-1 Nurnberg 10/-8 2,15 1.00/13 1.13/8 1.33/6 0.71/7   13/-12 2,92 1.08/13 1.00/8 1.67/6 0.57/7
2014-11-23 Nurnberg 2-1 Ingolstadt 14/-13 2,93 1.00/14 1.00/8 1.67/6 0.50/8   22/13 2,21 2.14/14 2.25/8 2.14/7 2.14/7
2014-12-01 Braunschweig 1-0 Nurnberg 23/6 2,86 1.64/14 2.00/8 2.17/6 1.25/8   16/-12 2,93 1.13/15 1.38/8 1.86/7 0.50/8
2014-12-08 Nurnberg 2-1 Munich 1860 16/-13 2,81 1.06/16 1.38/8 1.86/7 0.44/9   19/-5 2,87 1.00/15 1.13/8 0.71/7 1.25/8
2014-12-14 Aalen 1-2 Nurnberg 13/-7 1,94 1.00/17 1.00/8 1.43/7 0.70/10   18/-12 2,82 1.18/17 1.38/8 2.00/8 0.44/9
2014-12-17 Aue 0-1 Nurnberg 15/-13 2,39 0.72/18 0.38/8 1.25/8 0.30/10   20/-11 2,83 1.28/18 1.63/8 2.00/8 0.70/10
2014-12-20 Nurnberg 0-0 Greuther Furth 21/-10 2,74 1.37/19 1.63/8 2.00/8 0.91/11   22/-4 2,53 1.16/19 0.88/8 1.36/11 0.88/8
2015-02-08 FSV Frankfurt 2-1 Nurnberg 27/-13 3,19 1.00/21 1.13/8 0.60/10 1.36/11   21/-10 2,60 1.35/20 1.75/8 1.89/9 0.91/11
2015-02-15 Nurnberg 3-1 Union Berlin 22/-11 2,62 1.29/21 1.63/8 1.89/9 0.83/12   26/-4 2,55 1.41/22 2.00/8 1.82/11 1.00/11
2015-02-22 Dusseldorf 1-3 Nurnberg 33/4 2,70 1.43/23 1.00/8 1.18/11 1.67/12   25/-9 2,68 1.36/22 2.00/8 2.00/10 0.83/12
2015-02-28 Nurnberg 1-1 Karlsruher 28/-7 2,74 1.43/23 2.00/8 2.00/10 1.00/13   30/13 2,14 1.73/22 1.88/8 1.64/11 1.82/11
2015-02-28 Nurnberg 1-1 Karlsruher SC 29/-7 2,71 1.42/24 1.88/8 1.91/11 1.00/13   30/13 2,14 1.73/22 1.88/8 1.64/11 1.82/11
2015-03-06 Nurnberg 0-1 Heidenheim 30/-7 2,68 1.40/25 1.88/8 1.83/12 1.00/13   33/4 2,48 1.16/25 0.50/8 1.38/13 0.92/12
2015-03-14 Kaiserslautern 2-1 Nurnberg 34/12 2,24 1.80/25 1.75/8 2.54/13 1.00/12   30/-8 2,62 1.35/26 1.50/8 1.69/13 1.00/13
2015-03-23 Nurnberg 1-2 Bochum 31/-9 2,63 1.30/27 1.13/8 1.69/13 0.93/14   42/3 3,00 1.26/27 1.38/8 1.36/14 1.15/13
2015-04-05 RB Leipzig 2-1 Nurnberg 32/11 1,89 1.46/28 1.13/8 2.00/14 0.93/14   32/-10 2,64 1.25/28 1.00/8 1.57/14 0.93/14
2015-04-10 Nurnberg 1-1 Darmstadt 33/-11 2,66 1.21/29 1.00/8 1.57/14 0.87/15   36/17 1,96 1.75/28 1.88/8 2.13/15 1.31/13
2015-04-17 St. Pauli 1-0 Nurnberg 30/-24 2,80 0.83/30 1.00/8 1.20/15 0.47/15   34/-11 2,63 1.20/30 0.75/8 1.53/15 0.87/15
2015-04-24 Nurnberg 2-0 Sandhausen 34/-12 2,58 1.16/31 0.38/8 1.53/15 0.81/16   27/-5 1,90 1.26/31 1.63/8 1.25/16 1.27/15
2015-05-04 Ingolstadt 1-1 Nurnberg 50/21 2,47 1.94/32 1.75/8 1.94/16 1.94/16   36/-10 2,56 1.22/32 0.63/8 1.63/16 0.81/16
2015-05-10 Nurnberg 3-1 Braunschweig 37/-10 2,55 1.21/33 0.63/8 1.63/16 0.82/17   43/8 2,44 1.56/32 2.00/8 1.94/16 1.19/16
2015-05-17 Munich 1860 2-1 Nurnberg 41/-10 2,79 1.00/33 1.38/8 0.76/17 1.25/16   40/-8 2,59 1.26/34 1.00/8 1.71/17 0.82/17
2015-05-24 Nurnberg 2-1 Aalen 41/-9 2,60 1.23/35 1.00/8 1.71/17 0.78/18   35/-11 2,31 1.00/35 1.25/8 1.22/18 0.76/17