SELECT * FROM 1_Kampe WHERE LigaID = '234' AND (Home='Sandnes' OR Away='Sandnes') 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
2013-03-17 Stromsgodset 2-0 Sandnes 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
2013-04-01 Sandnes 0-1 Aalesund 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   3/3 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2013-04-07 Sandnes 1-1 Haugesund 0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1   0/-3 3,00 0.00/1 0.00/1 0.00/0 0.00/1
2013-04-14 Tromso 0-1 Sandnes 6/1 3,67 1.67/3 1.67/3 3.00/1 1.00/2   1/-3 1,67 0.33/3 0.33/3 0.50/2 0.00/1
2013-04-21 Sandnes 1-1 Honefoss 2/-2 1,50 1.00/4 1.00/4 0.50/2 1.50/2   7/-1 3,75 0.75/4 0.75/4 1.50/2 0.00/2
2013-04-28 Rosenborg 0-1 Sandnes 11/7 3,00 2.00/5 2.00/5 2.00/2 2.00/3   3/-2 1,60 1.00/5 1.00/5 0.67/3 1.50/2
2013-05-04 Sandnes 1-2 Valerenga 4/-1 1,50 1.33/6 1.33/6 0.67/3 2.00/3   4/-6 2,33 1.00/6 1.00/6 2.00/3 0.00/3
2013-05-09 Sarpsborg 08 3-2 Sandnes 7/0 2,00 1.43/7 1.43/7 1.33/3 1.50/4   5/-2 1,71 1.14/7 1.14/7 0.50/4 2.00/3
2013-05-12 Sandnes 0-0 Molde 7/-3 2,13 1.00/8 1.00/8 0.50/4 1.50/4   10/-2 2,75 0.63/8 0.63/8 0.75/4 0.50/4
2013-05-16 Lillestrom 2-2 Sandnes 13/-5 3,44 1.22/9 1.25/8 1.60/5 0.75/4   7/-3 1,89 1.00/9 1.13/8 0.60/5 1.50/4
2013-05-21 Sandnes 0-1 Viking 9/-3 2,10 1.00/10 1.25/8 0.60/5 1.40/5   12/2 2,20 1.70/10 1.75/8 2.20/5 1.20/5
2013-05-26 Odd 3-0 Sandnes 7/-7 1,91 0.73/11 0.63/8 1.33/6 0.00/5   9/-4 2,00 0.91/11 1.13/8 0.50/6 1.40/5
2013-06-23 Sandnes 1-3 Sogndal 9/-7 2,08 0.83/12 0.75/8 0.50/6 1.17/6   15/-4 2,83 1.33/12 1.50/8 1.50/6 1.17/6
2013-06-29 Brann 6-1 Sandnes 17/0 2,62 1.62/13 1.50/8 3.00/7 0.00/6   10/-9 2,23 0.77/13 0.63/8 0.43/7 1.17/6
2013-07-07 Sandnes 3-1 Start 11/-14 2,57 0.71/14 0.25/8 0.43/7 1.00/7   18/-9 3,21 1.00/14 0.75/8 1.29/7 0.71/7
2013-07-14 Sandnes 2-1 Stromsgodset 14/-12 2,67 0.87/15 0.63/8 0.75/8 1.00/7   30/18 2,80 2.13/15 2.00/8 2.75/8 1.43/7
2013-07-27 Aalesund 2-3 Sandnes 32/10 3,38 1.75/16 1.75/8 2.25/8 1.25/8   16/-11 2,69 1.00/16 1.00/8 1.00/9 1.00/7
2013-08-04 Haugesund 3-1 Sandnes 21/-3 2,65 1.41/17 1.25/8 1.88/8 1.00/9   19/-10 2,82 1.12/17 1.25/8 1.00/9 1.25/8
2013-08-11 Sandnes 2-1 Tromso 20/-12 2,89 1.06/18 1.13/8 1.00/9 1.11/9   28/1 3,06 1.17/18 1.00/8 1.89/9 0.44/9
2013-08-18 Honefoss 0-1 Sandnes 21/-14 2,95 0.84/19 0.38/8 1.00/9 0.70/10   22/-11 2,89 1.16/19 1.50/8 1.20/10 1.11/9
2013-08-25 Sandnes 2-3 Rosenborg 23/-10 2,80 1.25/20 1.88/8 1.20/10 1.30/10   36/19 2,65 2.10/20 2.25/8 2.18/11 2.00/9
2013-09-01 Start 7-0 Sandnes 27/-14 3,24 0.90/21 0.75/8 1.00/10 0.82/11   25/-11 2,90 1.19/21 1.88/8 1.09/11 1.30/10
2013-09-15 Sandnes 2-0 Sarpsborg 08 25/-18 3,09 1.14/22 1.88/8 1.09/11 1.18/11   28/-19 3,41 0.91/22 0.38/8 1.27/11 0.55/11
2013-09-22 Molde 4-1 Sandnes 39/5 3,17 1.35/23 1.75/8 1.55/11 1.17/12   27/-16 3,04 1.22/23 1.88/8 1.25/12 1.18/11
2013-09-29 Sandnes 1-1 Lillestrom 28/-19 3,13 1.17/24 1.50/8 1.25/12 1.08/12   30/-3 2,63 1.29/24 1.63/8 1.58/12 1.00/12
2013-10-05 Viking 1-1 Sandnes 33/8 2,32 1.68/25 1.63/8 2.33/12 1.08/13   29/-19 3,08 1.16/25 1.25/8 1.23/13 1.08/12
2013-10-20 Sandnes 2-4 Odd 30/-19 3,04 1.15/26 1.38/8 1.23/13 1.08/13   33/3 2,42 1.27/26 1.13/8 1.69/13 0.85/13
2013-10-27 Sogndal 2-1 Sandnes 29/-13 2,63 1.11/27 0.88/8 1.08/13 1.14/14   32/-21 3,15 1.11/27 1.00/8 1.14/14 1.08/13
2013-11-03 Sandnes 3-1 Brann 33/-22 3,14 1.07/28 0.63/8 1.14/14 1.00/14   41/-1 2,96 1.29/28 1.13/8 2.14/14 0.43/14
2013-11-10 Valerenga 2-0 Sandnes 39/-11 3,07 1.14/29 0.75/8 1.29/14 1.00/15   36/-20 3,17 1.14/29 1.00/8 1.27/15 1.00/14