SELECT * FROM 1_Kampe WHERE LigaID = '54' AND (Home='St. Pauli' OR Away='St. Pauli') 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-05 Magdeburg 1-2 St. Pauli 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-10 St. Pauli 2-0 Darmstadt 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-26 Union Berlin 4-1 St. Pauli 2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1   4/3 2,50 3.00/2 3.00/2 3.00/1 3.00/1
2018-09-02 St. Pauli 3-5 FC Koln 5/0 3,33 2.00/3 2.00/3 3.00/1 1.50/2   6/4 2,67 2.33/3 2.33/3 2.00/2 3.00/1
2018-09-16 Aue 3-1 St. Pauli 3/-4 2,50 0.25/4 0.25/4 1.00/1 0.00/3   8/-2 4,50 1.50/4 1.50/4 1.50/2 1.50/2
2018-09-21 Ingolstadt 0-1 St. Pauli 6/-6 3,60 1.00/5 1.00/5 2.00/2 0.33/3   9/-4 4,40 1.20/5 1.20/5 1.50/2 1.00/3
2018-09-26 St. Pauli 2-1 Paderborn 10/-3 3,83 1.50/6 1.50/6 1.50/2 1.50/4   15/3 4,50 1.50/6 1.50/6 1.67/3 1.33/3
2018-09-30 Hamburger SV 0-0 St. Pauli 10/0 2,86 1.86/7 1.86/7 1.50/4 2.33/3   12/-2 3,71 1.71/7 1.71/7 2.00/3 1.50/4
2018-10-07 St. Pauli 3-1 Sandhausen 12/-2 3,25 1.63/8 1.63/8 2.00/3 1.40/5   4/-7 1,88 0.63/8 0.63/8 0.25/4 1.00/4
2018-10-22 Duisburg 0-1 St. Pauli 9/-9 3,00 0.56/9 0.63/8 0.00/4 1.00/5   15/0 3,33 1.78/9 1.63/8 2.25/4 1.40/5
2018-10-28 St. Pauli 0-1 Holstein Kiel 16/1 3,10 1.90/10 1.63/8 2.25/4 1.67/6   15/0 3,00 1.30/10 1.13/8 1.80/5 0.80/5
2018-11-04 Arminia Bielefeld 1-2 St. Pauli 14/-4 2,91 1.09/11 1.00/8 1.40/5 0.83/6   16/0 2,91 1.73/11 1.63/8 1.80/5 1.67/6
2018-11-10 St. Pauli 1-1 Heidenheim 18/1 2,92 1.83/12 2.00/8 1.80/5 1.86/7   19/6 2,67 1.58/12 1.75/8 2.17/6 1.00/6
2018-11-25 Regensburg 1-1 St. Pauli 24/4 3,38 1.54/13 2.00/8 1.50/6 1.57/7   19/1 2,85 1.77/13 2.13/8 1.67/6 1.86/7
2018-12-01 St. Pauli 1-1 SG Dynamo Dresden 20/1 2,79 1.71/14 1.88/8 1.67/6 1.75/8   19/-1 2,79 1.50/14 1.50/8 1.63/8 1.33/6
2018-12-10 Bochum 1-3 St. Pauli 24/8 2,67 1.60/15 1.63/8 2.00/8 1.14/7   21/1 2,73 1.67/15 1.63/8 1.57/7 1.75/8
2018-12-15 St. Pauli 2-0 Greuther Furth 24/3 2,81 1.75/16 1.88/8 1.57/7 1.89/9   21/-8 3,13 1.44/16 1.00/8 1.63/8 1.25/8
2018-12-22 St. Pauli 4-1 Magdeburg 26/5 2,76 1.82/17 1.88/8 1.75/8 1.89/9   19/-12 2,94 0.65/17 0.25/8 0.67/9 0.63/8
2019-01-29 Darmstadt 2-1 St. Pauli 23/-10 3,11 1.06/18 1.00/8 1.56/9 0.56/9   30/8 2,89 1.89/18 1.88/8 1.89/9 1.89/9
2019-02-04 St. Pauli 3-2 Union Berlin 31/7 2,89 1.79/19 1.88/8 1.89/9 1.70/10   29/14 2,32 1.79/19 1.88/8 2.40/10 1.11/9
2019-02-08 FC Koln 4-1 St. Pauli 47/23 3,74 1.89/19 1.88/8 1.70/10 2.11/9   34/8 3,00 1.85/20 1.88/8 2.00/10 1.70/10
2019-02-16 St. Pauli 1-2 Aue 35/5 3,10 1.76/21 1.75/8 2.00/10 1.55/11   25/-2 2,60 1.10/20 1.00/8 1.50/10 0.70/10
2019-02-23 St. Pauli 1-0 Ingolstadt 36/4 3,09 1.68/22 1.63/8 1.82/11 1.55/11   23/-14 2,73 0.86/22 1.38/8 0.83/12 0.90/10
2019-03-02 Paderborn 0-1 St. Pauli 54/18 3,91 1.65/23 2.00/8 2.00/12 1.27/11   37/5 3,00 1.74/23 1.88/8 1.92/12 1.55/11
2019-03-10 St. Pauli 0-4 Hamburger SV 38/6 2,92 1.79/24 1.88/8 1.92/12 1.67/12   32/6 2,42 1.96/24 1.63/8 2.00/12 1.92/12
2019-03-16 Sandhausen 4-0 St. Pauli 25/-13 2,52 0.80/25 1.00/8 0.92/12 0.69/13   38/2 2,96 1.72/25 1.50/8 1.77/13 1.67/12
2019-03-29 St. Pauli 0-0 Duisburg 38/-2 3,00 1.65/26 1.13/8 1.77/13 1.54/13   24/-18 2,64 0.84/25 1.00/8 0.75/12 0.92/13
2019-04-06 Holstein Kiel 2-1 St. Pauli 51/10 3,41 1.56/27 1.38/8 1.77/13 1.36/14   38/-2 2,89 1.63/27 1.25/8 1.71/14 1.54/13
2019-04-14 St. Pauli 1-1 Arminia Bielefeld 39/-3 2,89 1.57/28 0.88/8 1.71/14 1.43/14   42/-2 3,07 1.36/28 1.75/8 1.43/14 1.29/14
2019-04-21 Heidenheim 3-0 St. Pauli 41/7 2,59 1.59/29 1.13/8 1.71/14 1.47/15   40/-3 2,86 1.55/29 1.00/8 1.67/15 1.43/14
2019-04-27 St. Pauli 4-3 Regensburg 40/-6 2,87 1.50/30 1.00/8 1.67/15 1.33/15   44/2 2,87 1.50/30 1.88/8 1.53/15 1.47/15
2019-05-03 SG Dynamo Dresden 2-1 St. Pauli 36/-7 2,55 1.16/31 1.25/8 1.33/15 1.00/16   44/-5 3,00 1.55/31 1.00/8 1.75/16 1.33/15
2019-05-12 St. Pauli 0-0 Bochum 45/-6 3,00 1.50/32 0.63/8 1.75/16 1.25/16   47/-1 2,97 1.31/32 1.38/8 1.81/16 0.81/16
2019-05-19 Greuther Furth 2-1 St. Pauli 35/-20 2,73 1.18/33 0.88/8 1.44/16 0.94/17   45/-6 2,91 1.48/33 0.75/8 1.71/17 1.25/16