SELECT * FROM 1_Kampe WHERE LigaID = '200' 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
2012-07-29 Lyngby 3-2 FC Fyn 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
2012-08-05 AB Copenhagen 0-1 Lyngby 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   3/1 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2012-08-08 Lyngby 3-1 Vendsyssel 4/2 3,00 3.00/2 3.00/2 3.00/1 3.00/1   2/1 1,50 1.50/2 1.50/2 3.00/1 0.00/1
2012-08-11 Slagelse 4-1 Lyngby 3/-5 3,67 1.33/3 1.33/3 3.00/1 0.50/2   7/4 3,33 3.00/3 3.00/3 3.00/2 3.00/1
2012-08-19 Lyngby 0-0 Hobro 8/1 3,75 2.25/4 2.25/4 3.00/2 1.50/2   4/0 2,00 1.75/4 1.75/4 2.00/2 1.50/2
2012-08-26 Lyngby 2-1 Viborg 8/1 3,00 2.00/5 2.00/5 2.33/3 1.50/2   13/5 4,20 1.20/5 1.20/5 1.50/2 1.00/3
2012-09-03 Koge 0-5 Lyngby 5/-2 2,00 0.67/6 0.67/6 0.67/3 0.67/3   10/2 3,00 2.17/6 2.17/6 2.50/4 1.50/2
2012-09-09 Lyngby 5-1 Skive 15/7 3,29 2.29/7 2.29/7 2.50/4 2.00/3   8/-1 2,43 1.29/7 1.29/7 1.50/4 1.00/3
2012-09-15 Bronshoj 3-2 Lyngby 9/3 1,88 1.25/8 1.25/8 1.50/4 1.00/4   20/11 3,63 2.38/8 2.38/8 2.60/5 2.00/3
2012-09-23 Lyngby 1-2 Fredericia 22/10 3,78 2.11/9 2.00/8 2.60/5 1.50/4   11/3 2,11 1.56/9 1.63/8 1.60/5 1.50/4
2012-09-30 Vejle 1-1 Lyngby 13/4 2,20 1.50/10 1.38/8 1.20/5 1.80/5   23/9 3,70 1.90/10 1.63/8 2.17/6 1.50/4
2012-10-07 Lyngby 3-3 FC Fyn 24/9 3,55 1.82/11 1.38/8 2.17/6 1.40/5   19/0 3,45 1.18/11 1.38/8 1.40/5 1.00/6
2012-10-14 Koge 0-2 Lyngby 13/-8 2,83 1.08/12 1.25/8 1.33/6 0.83/6   27/9 3,75 1.75/12 1.50/8 2.00/7 1.40/5
2012-10-21 Lyngby 0-2 Viborg 29/11 3,62 1.85/13 1.75/8 2.00/7 1.67/6   30/12 3,69 1.46/13 1.63/8 2.29/7 0.50/6
2012-10-28 Vendsyssel 2-0 Lyngby 11/-11 2,36 0.86/14 0.75/8 1.67/6 0.25/8   29/9 3,50 1.71/14 1.38/8 1.75/8 1.67/6
2012-11-04 Lyngby 2-1 Hobro 29/7 3,40 1.60/15 1.00/8 1.75/8 1.43/7   13/-2 1,87 1.27/15 1.13/8 1.43/7 1.13/8
2012-11-10 Bronshoj 0-1 Lyngby 22/7 2,31 1.63/16 2.00/8 2.25/8 1.00/8   31/8 3,38 1.69/16 1.00/8 1.89/9 1.43/7
2012-11-18 Lyngby 1-1 AB Copenhagen 32/9 3,24 1.76/17 1.38/8 1.89/9 1.63/8   12/-7 1,82 0.76/17 0.63/8 0.63/8 0.89/9
2012-11-25 Vejle 2-0 Lyngby 22/8 2,00 1.61/18 1.75/8 1.44/9 1.78/9   33/9 3,17 1.72/18 1.50/8 1.80/10 1.63/8
2013-03-28 Lyngby 1-0 Skive 33/7 3,11 1.63/19 1.38/8 1.80/10 1.44/9   25/-7 2,85 1.05/20 1.13/8 1.60/10 0.50/10
2013-04-01 Slagelse 2-0 Lyngby 23/4 2,10 1.85/20 1.88/8 2.00/11 1.67/9   34/8 3,00 1.70/20 1.63/8 1.91/11 1.44/9
2013-04-04 Lyngby 2-1 Koge 34/6 2,95 1.62/21 1.25/8 1.91/11 1.30/10   22/-7 2,55 1.25/20 1.50/8 1.50/10 1.00/10
2013-04-07 FC Fyn 0-0 Lyngby 26/-16 2,96 0.61/23 0.00/8 0.64/11 0.58/12   36/7 2,95 1.68/22 1.63/8 2.00/12 1.30/10
2013-04-14 Lyngby 0-1 Slagelse 36/7 2,83 1.61/23 1.63/8 2.00/12 1.18/11   28/7 2,13 1.91/23 1.88/8 2.15/13 1.60/10
2013-04-21 Lyngby 2-1 Vendsyssel 36/6 2,75 1.54/24 1.25/8 1.85/13 1.18/11   27/-6 2,40 1.24/25 1.88/8 2.09/11 0.57/14
2013-04-24 Viborg 2-0 Lyngby 44/21 2,68 1.80/25 2.25/8 2.00/13 1.58/12   38/7 2,76 1.60/25 1.25/8 1.93/14 1.18/11
2013-04-28 Skive 0-1 Lyngby 34/-11 2,93 0.93/27 0.63/8 1.54/13 0.36/14   38/5 2,73 1.54/26 1.13/8 1.93/14 1.08/12
2013-05-01 Fredericia 1-3 Lyngby 39/3 2,78 1.26/27 1.00/8 1.31/13 1.21/14   39/6 2,67 1.59/27 1.50/8 1.93/14 1.23/13
2013-05-05 Lyngby 2-1 Fredericia 42/8 2,71 1.64/28 1.50/8 1.93/14 1.36/14   40/1 2,82 1.21/28 1.00/8 1.21/14 1.21/14
2013-05-08 Lyngby 2-2 Bronshoj 44/9 2,72 1.69/29 1.88/8 2.00/15 1.36/14   28/-3 2,03 1.14/29 0.13/8 1.47/15 0.79/14
2013-05-11 Hobro 1-0 Lyngby 27/-12 2,20 0.93/30 0.63/8 1.21/14 0.69/16   46/9 2,77 1.67/30 1.63/8 1.94/16 1.36/14
2013-05-16 Lyngby 4-0 Vejle 46/8 2,71 1.61/31 1.63/8 1.94/16 1.27/15   41/16 2,13 1.68/31 1.00/8 1.81/16 1.53/15
2013-05-20 AB Copenhagen 4-2 Lyngby 23/-9 1,72 0.88/32 1.25/8 0.80/15 0.94/17   50/12 2,75 1.66/32 2.00/8 2.00/17 1.27/15
2018-10-21 Skive IK 1-3 Lyngby 46/4 4,00 1.64/22 1.13/8 0.00/10 3.00/12   52/10 2,85 1.61/33 1.63/8 2.00/17 1.19/16
2018-10-21 Lyngby 1-3 Skive IK 55/12 2,88 1.65/34 1.25/8 2.00/17 1.29/17   59/2 4,00 1.55/29 1.13/8 0.00/14 3.00/15
2018-10-21 Lyngby 1-3 Skive IK 56/10 2,91 1.60/35 1.25/8 1.89/18 1.29/17   18/4 4,00 1.88/8 1.13/8 0.00/3 3.00/5