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 IK 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-09 Lyngby 5-1 Skive 20/11 3,63 2.38/8 2.38/8 2.60/5 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   25/15 3,89 2.44/9 2.38/8 2.67/6 2.00/3
2012-09-23 Lyngby 1-2 Fredericia 27/14 4,00 2.20/10 2.00/8 2.67/6 1.50/4   12/3 2,10 1.50/10 1.63/8 1.60/5 1.40/5
2012-09-30 Vejle 1-1 Lyngby 17/7 2,45 1.64/11 1.38/8 1.50/6 1.80/5   28/13 3,91 2.00/11 1.63/8 2.29/7 1.50/4
2012-10-07 Lyngby 3-3 FC Fyn 29/13 3,75 1.92/12 1.75/8 2.29/7 1.40/5   20/0 3,33 1.17/12 1.38/8 1.40/5 1.00/7
2012-10-14 Koge 0-2 Lyngby 14/-9 2,85 1.00/13 1.25/8 1.33/6 0.71/7   32/13 3,92 1.85/13 1.75/8 2.13/8 1.40/5
2012-10-21 Lyngby 0-2 Viborg 34/15 3,79 1.93/14 1.75/8 2.13/8 1.67/6   32/13 3,64 1.57/14 2.00/8 2.38/8 0.50/6
2012-10-28 Vendsyssel 2-0 Lyngby 11/-13 2,33 0.80/15 0.75/8 1.67/6 0.22/9   34/13 3,67 1.80/15 1.38/8 1.89/9 1.67/6
2012-11-04 Lyngby 2-1 Hobro 34/11 3,56 1.69/16 1.00/8 1.89/9 1.43/7   14/-2 1,88 1.25/16 1.13/8 1.43/7 1.11/9
2012-11-10 Bronshoj 0-1 Lyngby 23/8 2,24 1.71/17 2.00/8 2.33/9 1.00/8   36/12 3,53 1.76/17 1.00/8 2.00/10 1.43/7
2012-11-18 Lyngby 1-1 AB Copenhagen 37/13 3,39 1.83/18 1.38/8 2.00/10 1.63/8   12/-8 1,78 0.72/18 0.63/8 0.56/9 0.89/9
2012-11-25 Vejle 2-0 Lyngby 28/13 2,15 1.75/20 2.00/8 1.60/10 1.90/10   38/13 3,32 1.79/19 1.50/8 1.91/11 1.63/8
2013-03-28 Lyngby 1-0 Skive IK 38/11 3,25 1.70/20 1.38/8 1.91/11 1.44/9   25/-7 2,85 1.05/20 1.13/8 1.60/10 0.50/10
2013-03-28 Lyngby 1-0 Skive 39/12 3,14 1.76/21 1.63/8 2.00/12 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 27/6 2,18 1.95/22 1.88/8 2.15/13 1.67/9   40/13 3,05 1.82/22 1.63/8 2.08/13 1.44/9
2013-04-04 Lyngby 2-1 Koge 40/11 3,00 1.74/23 1.63/8 2.08/13 1.30/10   25/-8 2,64 1.18/22 1.63/8 1.45/11 0.91/11
2013-04-07 FC Fyn - Lyngby / /0 / / /   / /0 / / /
2013-04-14 Lyngby 0-1 Slagelse 42/12 3,00 1.79/24 2.00/8 2.14/14 1.30/10   34/9 2,27 1.96/26 2.00/8 2.27/15 1.55/11
2013-04-21 Lyngby 2-1 Vendsyssel 42/11 2,92 1.72/25 1.63/8 2.00/15 1.30/10   29/-8 2,44 1.19/27 1.88/8 2.00/12 0.53/15
2013-04-24 Viborg 2-0 Lyngby 48/24 2,67 1.89/27 2.25/8 2.07/14 1.69/13   44/12 2,92 1.77/26 1.63/8 2.06/16 1.30/10
2013-04-28 Skive 0-1 Lyngby 34/-11 3,04 0.96/26 0.63/8 1.54/13 0.38/13   44/10 2,89 1.70/27 1.50/8 2.06/16 1.18/11
2013-04-28 Skive IK 0-1 Lyngby 34/-11 3,04 0.96/26 0.63/8 1.54/13 0.38/13   45/11 2,82 1.75/28 1.88/8 2.06/16 1.33/12
2013-05-01 Fredericia 1-3 Lyngby 46/3 3,07 1.31/29 1.38/8 1.54/13 1.13/16   46/12 2,76 1.79/29 1.88/8 2.06/16 1.46/13
2013-05-05 Lyngby 2-1 Fredericia 49/14 2,80 1.83/30 1.88/8 2.06/16 1.57/14   47/1 3,10 1.27/30 1.38/8 1.43/14 1.13/16
2013-05-08 Lyngby 2-2 Bronshoj 51/15 2,81 1.87/31 2.25/8 2.12/17 1.57/14   31/0 2,14 1.34/29 0.13/8 1.75/16 0.85/13
2013-05-11 Hobro 1-0 Lyngby 28/-15 2,37 0.97/30 0.63/8 1.31/13 0.71/17   53/15 2,84 1.84/32 2.00/8 2.06/18 1.57/14
2013-05-16 Lyngby 4-0 Vejle 53/14 2,79 1.79/33 2.00/8 2.06/18 1.47/15   50/23 2,33 1.85/33 1.38/8 2.06/17 1.63/16
2013-05-20 AB Copenhagen 4-2 Lyngby 23/-13 1,79 0.88/33 1.25/8 0.75/16 1.00/17   57/18 2,82 1.82/34 2.00/8 2.11/19 1.47/15