SELECT * FROM 1_Kampe WHERE LigaID = '52' AND (Home='Schalke' OR Away='Schalke') 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
2010-08-21 Hamburger SV 2-1 Schalke 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
2010-08-28 Schalke 1-2 Hannover 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2010-09-10 Hoffenheim 2-0 Schalke 5/4 3,00 3.00/2 3.00/2 3.00/1 3.00/1   2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1
2010-09-19 Schalke 1-3 Dortmund 2/-4 2,67 0.00/3 0.00/3 0.00/1 0.00/2   5/2 2,67 2.00/3 2.00/3 1.50/2 3.00/1
2010-09-22 Freiburg 1-2 Schalke 6/1 2,75 2.25/4 2.25/4 1.50/2 3.00/2   3/-6 3,00 0.00/4 0.00/4 0.00/2 0.00/2
2010-09-25 Schalke 2-2 B. Monchengladbach 5/-5 3,00 0.60/5 0.60/5 0.00/2 1.00/3   8/-9 5,00 0.80/5 0.80/5 0.33/3 1.50/2
2010-10-02 Nurnberg 2-1 Schalke 5/-2 2,00 1.00/6 1.00/6 1.50/2 0.75/4   7/-5 3,17 0.67/6 0.67/6 0.33/3 1.00/3
2010-10-16 Schalke 2-2 Stuttgart 8/-6 3,14 0.57/7 0.57/7 0.33/3 0.75/4   12/-3 3,86 0.43/7 0.43/7 0.75/4 0.00/3
2010-10-23 Eintracht Frankfurt 0-0 Schalke 14/5 2,88 1.50/8 1.50/8 1.00/3 1.80/5   10/-6 3,25 0.63/8 0.63/8 0.50/4 0.75/4
2010-10-30 Schalke 0-1 Bayer Leverkusen 10/-6 2,89 0.67/9 0.75/8 0.50/4 0.80/5   18/3 3,67 1.67/9 1.50/8 1.00/5 2.50/4
2010-11-05 Schalke 3-0 St. Pauli 10/-7 2,70 0.60/10 0.75/8 0.40/5 0.80/5   12/-3 2,70 1.30/10 1.25/8 0.80/5 1.80/5
2010-11-13 Wolfsburg 2-2 Schalke 18/-1 3,36 1.18/11 1.63/8 1.80/5 0.67/6   13/-4 2,73 0.82/11 1.13/8 0.83/6 0.80/5
2010-11-20 Schalke 4-0 Werder Bremen 15/-4 2,83 0.83/12 1.25/8 0.83/6 0.83/6   19/-8 3,83 1.25/12 1.38/8 1.67/6 0.83/6
2010-11-27 Kaiserslautern 5-0 Schalke 20/-5 3,46 1.08/13 0.88/8 1.33/6 0.86/7   19/0 2,92 1.00/13 1.25/8 1.14/7 0.83/6
2010-12-04 Schalke 2-0 Bayern Munich 19/-5 3,07 0.93/14 1.13/8 1.14/7 0.71/7   23/8 2,71 1.64/14 1.88/8 2.13/8 1.00/6
2010-12-12 Mainz 0-1 Schalke 26/10 2,80 2.00/15 1.13/8 1.88/8 2.14/7   21/-3 3,00 1.07/15 1.50/8 1.38/8 0.71/7
2010-12-18 Schalke 3-0 FC Koln 22/-2 2,88 1.19/16 1.75/8 1.38/8 1.00/8   18/-12 3,00 0.94/16 1.25/8 1.38/8 0.50/8
2011-01-15 Schalke 0-1 Hamburger SV 25/1 2,88 1.29/17 2.00/8 1.56/9 1.00/8   27/-1 3,24 1.41/17 1.13/8 1.75/8 1.11/9
2011-01-22 Hannover 0-1 Schalke 28/1 3,06 1.89/18 2.25/8 2.11/9 1.67/9   25/0 2,78 1.22/18 2.00/8 1.40/10 1.00/8
2011-01-29 Schalke 0-1 Hoffenheim 26/1 2,68 1.32/19 2.00/8 1.40/10 1.22/9   35/9 3,21 1.37/19 1.00/8 1.67/9 1.10/10
2011-02-04 Dortmund 0-0 Schalke 46/34 2,90 2.50/20 2.38/8 2.22/9 2.73/11   26/0 2,60 1.25/20 1.88/8 1.27/11 1.22/9
2011-02-12 Schalke 1-0 Freiburg 26/0 2,48 1.24/21 1.63/8 1.27/11 1.20/10   29/1 2,71 1.62/21 1.63/8 1.82/11 1.40/10
2011-02-20 B. Monchengladbach 2-1 Schalke 32/-24 4,00 0.73/22 0.75/8 0.27/11 1.18/11   27/1 2,41 1.32/22 2.00/8 1.42/12 1.20/10
2011-02-26 Schalke 1-1 Nurnberg 28/0 2,43 1.26/23 1.63/8 1.42/12 1.09/11   33/2 2,78 1.52/23 2.13/8 2.00/12 1.00/11
2011-03-05 Stuttgart 1-0 Schalke 42/-5 3,71 0.92/24 1.25/8 1.08/12 0.75/12   29/0 2,42 1.25/24 1.38/8 1.38/13 1.09/11
2011-03-12 Schalke 2-1 Eintracht Frankfurt 29/-1 2,36 1.20/25 1.00/8 1.38/13 1.00/12   24/-10 2,32 1.12/25 0.25/8 1.08/13 1.17/12
2011-03-20 Bayer Leverkusen 2-0 Schalke 54/20 3,38 2.00/26 2.38/8 1.69/13 2.31/13   31/0 2,38 1.27/26 1.38/8 1.50/14 1.00/12
2011-04-01 St. Pauli 0-2 Schalke 29/-18 2,81 1.04/27 1.13/8 1.07/14 1.00/13   31/-2 2,37 1.22/27 1.00/8 1.50/14 0.92/13
2011-04-09 Schalke 1-0 Wolfsburg 33/0 2,36 1.29/28 1.38/8 1.50/14 1.07/14   32/-9 2,61 1.00/28 0.63/8 1.21/14 0.79/14
2011-04-16 Werder Bremen 1-1 Schalke 39/-16 3,24 1.17/29 1.38/8 1.43/14 0.93/15   34/1 2,31 1.34/29 1.63/8 1.60/15 1.07/14
2011-04-23 Schalke 0-1 Kaiserslautern 35/1 2,30 1.33/30 1.38/8 1.60/15 1.07/15   40/-8 2,93 1.13/30 1.38/8 1.20/15 1.07/15
2011-04-30 Bayern Munich 4-1 Schalke 67/30 3,35 1.81/31 1.75/8 2.33/15 1.31/16   35/0 2,26 1.29/31 1.38/8 1.50/16 1.07/15
2011-05-07 Schalke 1-3 Mainz 36/-3 2,34 1.25/32 1.25/8 1.50/16 1.00/16   47/10 2,63 1.63/32 1.50/8 1.44/16 1.81/16
2011-05-14 FC Koln 2-1 Schalke 45/-16 3,21 1.24/33 1.50/8 2.00/16 0.53/17   37/-5 2,39 1.21/33 1.25/8 1.41/17 1.00/16