SELECT * FROM 1_Kampe WHERE LigaID = '195' AND (Home='Lyngby' OR Away='Lyngby') 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-07-19 Lyngby 2-4 Aalborg 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-07-25 Lyngby 1-0 Horsens 2/-2 6,00 0.00/1 0.00/1 0.00/1 0.00/0   0/-2 2,00 0.00/1 0.00/1 0.00/1 0.00/0
2010-08-01 Silkeborg 2-2 Lyngby 1/-5 3,50 0.00/2 0.00/2 0.00/0 0.00/2   3/-1 3,50 1.50/2 1.50/2 1.50/2 0.00/0
2010-08-08 Lyngby 1-0 Sonderjyske 5/-1 3,67 1.33/3 1.33/3 1.50/2 1.00/1   6/2 3,33 2.00/3 2.00/3 1.50/2 3.00/1
2010-08-15 Randers FC 2-1 Lyngby 4/-1 2,25 1.25/4 1.25/4 1.50/2 1.00/2   6/0 3,00 1.75/4 1.75/4 2.00/3 1.00/1
2010-08-21 FC Copenhagen 3-0 Lyngby 11/6 3,20 2.60/5 2.60/5 2.00/2 3.00/3   7/-1 3,00 1.40/5 1.40/5 2.00/3 0.50/2
2010-08-29 Lyngby 3-3 Brondby 7/-4 3,00 1.17/6 1.17/6 2.00/3 0.33/3   11/4 3,00 1.83/6 1.83/6 1.67/3 2.00/3
2010-09-12 Esbjerg 2-3 Lyngby 6/-7 2,71 1.00/7 1.00/7 1.00/3 1.00/4   10/-4 3,43 1.14/7 1.14/7 1.75/4 0.33/3
2010-09-20 Lyngby 2-0 Nordsjaelland 13/-3 3,63 1.38/8 1.38/8 1.75/4 1.00/4   9/-3 2,63 1.25/8 1.25/8 1.00/4 1.50/4
2010-09-27 Odense 3-1 Lyngby 14/1 3,00 1.22/9 1.00/8 1.40/5 1.00/4   15/-1 3,44 1.56/9 1.75/8 2.00/5 1.00/4
2010-10-02 Midtjylland 1-2 Lyngby 17/9 2,50 1.90/10 1.63/8 2.00/5 1.80/5   16/-3 3,50 1.40/10 1.38/8 2.00/5 0.80/5
2010-10-17 Lyngby 1-1 Silkeborg 18/-2 3,45 1.55/11 1.63/8 2.00/5 1.17/6   16/-1 3,00 1.18/11 1.50/8 1.60/5 0.83/6
2010-10-24 Lyngby 0-2 Horsens 19/-2 3,33 1.50/12 1.38/8 1.83/6 1.17/6   9/-8 2,17 1.17/12 1.25/8 0.83/6 1.50/6
2010-10-30 FC Copenhagen 3-2 Lyngby 32/24 3,08 2.69/13 2.75/8 2.43/7 3.00/6   19/-4 3,23 1.38/13 1.38/8 1.57/7 1.17/6
2010-11-07 Lyngby 1-0 Sonderjyske 21/-5 3,36 1.29/14 1.38/8 1.57/7 1.00/7   17/-2 2,57 1.36/14 1.25/8 1.29/7 1.43/7
2010-11-14 Nordsjaelland 2-1 Lyngby 15/-8 2,53 1.00/15 1.00/8 1.14/7 0.88/8   22/-4 3,20 1.40/15 1.63/8 1.75/8 1.00/7
2010-11-20 Lyngby 3-3 Randers FC 23/-5 3,19 1.31/16 1.25/8 1.75/8 0.88/8   18/0 2,25 1.06/16 0.75/8 1.50/8 0.63/8
2010-11-28 Esbjerg 0-0 Lyngby 21/-7 2,88 0.94/17 0.75/8 0.63/8 1.22/9   26/-5 3,35 1.29/17 1.00/8 1.67/9 0.88/8
2011-03-06 Brondby 1-1 Lyngby 31/5 3,00 1.58/19 1.88/8 1.67/9 1.50/10   26/-5 3,17 1.28/18 1.13/8 1.67/9 0.89/9
2011-03-14 Odense 2-0 Lyngby 37/7 3,35 1.60/20 1.88/8 1.90/10 1.30/10   27/-5 3,11 1.26/19 0.88/8 1.67/9 0.90/10
2011-03-20 Lyngby 1-2 Aalborg 27/-7 3,05 1.20/20 0.75/8 1.67/9 0.82/11   19/-13 2,43 0.81/21 0.63/8 0.55/11 1.10/10
2011-04-04 Midtjylland 4-4 Lyngby 36/11 2,90 1.57/21 1.50/8 1.73/11 1.40/10   28/-8 3,05 1.14/21 0.75/8 1.50/10 0.82/11
2011-04-11 Lyngby 1-2 Esbjerg 32/-8 3,27 1.14/22 0.88/8 1.50/10 0.83/12   26/-11 2,74 0.91/23 0.75/8 0.58/12 1.27/11
2011-04-14 Lyngby 1-0 Midtjylland 33/-9 3,26 1.09/23 0.50/8 1.36/11 0.83/12   40/10 3,04 1.48/23 1.13/8 1.67/12 1.27/11
2011-04-17 Randers FC 1-1 Lyngby 30/1 2,46 1.13/24 1.25/8 1.45/11 0.85/13   34/-8 3,17 1.17/24 0.88/8 1.50/12 0.83/12
2011-04-21 Lyngby 1-2 FC Copenhagen 35/-8 3,12 1.16/25 0.88/8 1.50/12 0.85/13   61/40 3,28 2.56/25 2.38/8 2.69/13 2.42/12
2011-04-25 Horsens 2-0 Lyngby 21/-10 2,00 1.19/26 0.88/8 1.15/13 1.23/13   36/-9 3,12 1.12/26 0.75/8 1.38/13 0.85/13
2011-05-01 Lyngby 1-0 Nordsjaelland 36/-11 3,07 1.07/27 0.63/8 1.38/13 0.79/14   32/-11 2,78 1.15/27 1.13/8 1.23/13 1.07/14
2011-05-06 Aalborg 2-1 Lyngby 32/-7 2,54 1.11/28 1.75/8 0.87/15 1.38/13   37/-10 3,00 1.14/28 1.00/8 1.50/14 0.79/14
2011-05-15 Sonderjyske 1-0 Lyngby 27/-15 2,38 1.03/29 0.63/8 1.08/13 1.00/16   38/-11 3,00 1.10/29 1.00/8 1.50/14 0.73/15
2011-05-20 Lyngby 1-2 Brondby 38/-12 2,93 1.07/30 0.88/8 1.50/14 0.69/16   47/10 2,80 1.47/30 1.25/8 1.56/16 1.36/14
2011-05-25 Silkeborg 0-1 Lyngby 41/-6 2,84 1.29/31 1.50/8 1.80/15 0.81/16   39/-13 2,94 1.03/31 0.88/8 1.40/15 0.69/16
2011-05-29 Lyngby 2-0 Odense 40/-12 2,88 1.09/32 0.88/8 1.40/15 0.82/17   55/16 2,94 1.72/32 1.88/8 1.82/17 1.60/15