SELECT * FROM 1_Kampe WHERE LigaID = '121' AND (Home='Lanciano' OR Away='Lanciano') 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
2015-09-06 Pro Vercelli 2-1 Lanciano 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
2015-09-12 Lanciano 2-0 Ascoli 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2015-09-19 Trapani 1-1 Lanciano 4/3 2,50 2.00/2 2.00/2 3.00/1 1.00/1   3/1 2,50 1.50/2 1.50/2 3.00/1 0.00/1
2015-09-22 Lanciano 0-0 L.R. Vicenza 4/1 2,33 1.33/3 1.33/3 3.00/1 0.50/2   4/1 2,33 1.67/3 1.67/3 1.00/2 3.00/1
2015-09-26 Modena 1-0 Lanciano 1/-4 1,50 0.75/4 0.75/4 1.50/2 0.00/2   4/1 1,75 1.25/4 1.25/4 2.00/2 0.50/2
2015-10-03 Lanciano 0-0 Spezia 4/0 1,60 1.00/5 1.00/5 2.00/2 0.33/3   9/3 3,00 2.00/5 2.00/5 2.00/2 2.00/3
2015-10-11 Bari 1-0 Lanciano 9/0 3,00 1.83/6 1.83/6 2.33/3 1.33/3   4/0 1,33 1.00/6 1.00/6 1.67/3 0.33/3
2015-10-17 Lanciano 1-0 Como 4/-1 1,29 0.86/7 0.86/7 1.67/3 0.25/4   7/-7 3,00 0.71/7 0.71/7 0.25/4 1.33/3
2015-10-24 Brescia 2-1 Lanciano 13/0 3,25 1.25/8 1.25/8 1.67/3 1.00/5   5/0 1,25 1.13/8 1.13/8 2.00/4 0.25/4
2015-10-27 Lanciano 2-2 Salernitana 6/-1 1,44 1.00/9 1.13/8 2.00/4 0.20/5   9/-5 2,56 1.00/9 0.75/8 1.40/5 0.50/4
2015-10-31 Cesena 2-0 Lanciano 19/10 2,80 2.00/10 2.13/8 3.00/5 1.00/5   8/-1 1,70 1.00/10 0.88/8 1.80/5 0.20/5
2015-11-08 Perugia 2-0 Lanciano 6/0 1,09 1.09/11 1.00/8 1.40/5 0.83/6   8/-3 1,73 0.91/11 0.75/8 1.80/5 0.17/6
2015-11-15 Lanciano 1-1 Crotone 8/-5 1,75 0.83/12 0.63/8 1.80/5 0.14/7   21/9 2,75 2.00/12 2.13/8 2.67/6 1.33/6
2015-11-21 Entella 1-1 Lanciano 11/-2 1,85 1.31/13 1.75/8 1.83/6 0.86/7   9/-5 1,77 0.85/13 0.75/8 1.67/6 0.14/7
2015-11-28 Lanciano 2-1 Latina 10/-5 1,79 0.86/14 0.75/8 1.67/6 0.25/8   17/-1 2,50 1.21/14 1.38/8 1.57/7 0.86/7
2015-12-05 Novara 4-1 Lanciano 15/6 1,60 1.80/15 2.38/8 2.29/7 1.38/8   12/-4 1,87 1.00/15 1.13/8 1.86/7 0.25/8
2015-12-09 Lanciano 1-3 Cagliari 13/-7 2,06 0.94/16 0.75/8 1.86/7 0.22/9   31/16 2,88 2.06/16 2.13/8 2.78/9 1.14/7
2015-12-12 Avellino 3-2 Lanciano 26/-1 3,12 1.12/17 1.50/8 1.75/8 0.56/9   14/-9 2,18 0.88/17 0.75/8 1.63/8 0.22/9
2015-12-19 Lanciano 1-2 Pescara 16/-10 2,33 0.83/18 0.63/8 1.63/8 0.20/10   25/3 2,61 1.56/18 1.25/8 2.22/9 0.89/9
2015-12-23 Ternana 1-1 Lanciano 22/-6 2,63 1.16/19 1.50/8 1.44/9 0.90/10   17/-11 2,37 0.79/19 0.63/8 1.44/9 0.20/10
2015-12-27 Lanciano 2-1 Livorno 18/-11 2,35 0.80/20 0.75/8 1.44/9 0.27/11   24/-3 2,55 1.15/20 0.38/8 1.45/11 0.78/9
2016-01-16 Lanciano 1-0 Pro Vercelli 20/-10 2,38 0.90/21 1.00/8 1.60/10 0.27/11   16/-6 1,81 1.14/21 1.25/8 1.45/11 0.80/10
2016-01-23 Ascoli 1-0 Lanciano 19/-14 2,36 1.05/22 1.25/8 1.55/11 0.55/11   21/-9 2,32 1.00/22 1.25/8 1.73/11 0.27/11
2016-01-30 Lanciano 0-3 Trapani 21/-10 2,26 0.96/23 0.88/8 1.73/11 0.25/12   25/-4 2,35 1.26/23 1.13/8 1.75/12 0.73/11
2016-02-06 L.R. Vicenza 0-2 Lanciano 27/-3 2,38 1.17/24 1.00/8 1.18/11 1.15/13   21/-13 2,29 0.92/24 0.88/8 1.58/12 0.25/12
2016-02-13 Lanciano 2-1 Modena 23/-11 2,28 1.00/25 1.25/8 1.58/12 0.46/13   21/-7 1,96 1.04/25 1.00/8 1.85/13 0.17/12
2016-02-20 Spezia 2-0 Lanciano 28/-4 2,31 1.42/26 1.63/8 1.77/13 1.08/13   25/-10 2,31 1.08/26 1.63/8 1.69/13 0.46/13
2016-02-27 Lanciano 1-0 Bari 25/-12 2,30 1.04/27 1.63/8 1.69/13 0.43/14   31/1 2,26 1.52/27 0.75/8 2.00/14 1.00/13
2016-03-01 Como 1-1 Lanciano 24/-20 2,43 0.75/28 1.25/8 0.86/14 0.64/14   26/-11 2,25 1.11/28 1.88/8 1.79/14 0.43/14
2016-03-05 Lanciano 1-0 Brescia 27/-11 2,24 1.10/29 1.63/8 1.79/14 0.47/15   40/1 2,72 1.55/29 1.25/8 2.13/15 0.93/14
2016-03-12 Salernitana 1-3 Lanciano 32/-12 2,53 1.00/30 1.25/8 1.43/14 0.63/16   28/-10 2,20 1.17/30 1.63/8 1.87/15 0.47/15
2016-03-19 Lanciano 2-0 Cesena 31/-8 2,26 1.23/31 2.00/8 1.87/15 0.63/16   44/17 2,29 1.61/31 1.88/8 2.31/16 0.87/15
2016-03-26 Lanciano 0-1 Perugia 33/-6 2,25 1.28/32 2.38/8 1.94/16 0.63/16   31/3 1,84 1.38/32 1.38/8 1.59/17 1.13/15
2016-04-01 Crotone 1-0 Lanciano 52/24 2,42 2.03/33 1.63/8 2.44/16 1.65/17   33/-7 2,21 1.24/33 2.00/8 1.82/17 0.63/16
2016-04-09 Lanciano 1-2 Entella 33/-8 2,18 1.21/34 1.63/8 1.82/17 0.59/17   42/8 2,24 1.50/34 1.75/8 2.00/18 0.94/16
2016-04-16 Latina 2-2 Lanciano 38/-6 2,34 1.11/35 0.75/8 1.53/17 0.72/18   34/-9 2,20 1.17/35 1.63/8 1.72/18 0.59/17
2016-04-19 Lanciano 2-1 Novara 36/-9 2,25 1.17/36 1.38/8 1.72/18 0.61/18   48/18 2,17 1.64/36 1.75/8 1.89/18 1.39/18
2016-04-23 Cagliari 1-1 Lanciano 67/30 2,81 1.95/37 1.38/8 2.39/18 1.53/19   38/-8 2,27 1.22/37 1.63/8 1.79/19 0.61/18
2016-04-30 Lanciano 1-2 Avellino 39/-8 2,26 1.21/38 1.38/8 1.79/19 0.63/19   48/-10 2,79 1.18/38 0.63/8 1.47/19 0.89/19
2016-05-08 Pescara 4-0 Lanciano 59/10 2,77 1.67/39 2.00/8 2.11/19 1.25/20   40/-9 2,28 1.18/39 1.00/8 1.70/20 0.63/19
2016-05-14 Lanciano 1-1 Ternana 40/-13 2,33 1.15/40 0.63/8 1.70/20 0.60/20   46/-7 2,48 1.23/40 1.13/8 1.45/20 1.00/20
2016-05-20 Livorno 2-2 Lanciano 43/-12 2,39 1.00/41 1.00/8 1.35/20 0.67/21   41/-13 2,32 1.15/41 0.75/8 1.67/21 0.60/20