SELECT * FROM 1_Kampe WHERE LigaID = '146' AND (Home='Cartagena' OR Away='Cartagena') 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-08-29 Xerez CD 1-4 Cartagena 1/-3 5,00 0.00/1 0.00/2 0.00/1 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2010-09-04 Cartagena 0-1 Elche 4/3 5,00 3.00/1 3.00/1 0.00/0 3.00/1   2/2 1,00 3.00/2 3.00/3 3.00/1 3.00/1
2010-09-11 Cartagena 5-1 Barcelona B 4/2 3,00 1.50/2 1.50/2 0.00/1 3.00/1   5/-2 4,00 2.00/3 1.50/4 3.00/1 1.50/2
2010-09-18 Numancia 2-0 Cartagena 5/-2 3,00 0.75/4 1.20/5 1.50/2 0.00/2   9/6 4,00 2.00/3 2.00/3 1.50/2 3.00/1
2010-09-25 Cartagena 1-2 Cordoba 9/4 3,50 1.50/4 1.50/4 1.50/2 1.50/2   7/-3 3,40 0.80/5 1.17/6 0.00/2 1.33/3
2010-10-03 Tenerife 1-1 Cartagena 3/-8 2,80 0.00/5 0.00/5 0.00/2 0.00/3   10/3 3,40 1.20/5 1.20/5 1.00/3 1.50/2
2010-10-09 Cartagena 2-2 Gimnastic 11/3 3,17 1.17/6 1.17/6 1.00/3 1.33/3   4/-4 2,00 0.50/6 0.50/6 1.00/3 0.00/3
2010-10-16 Huesca 0-0 Cartagena 5/-6 2,29 0.71/7 0.71/7 0.33/3 1.00/4   13/3 3,29 1.14/7 1.14/7 1.00/4 1.33/3
2010-10-23 Cartagena 1-0 Alcorcon 13/3 2,88 1.13/8 1.13/8 1.00/4 1.25/4   13/2 3,00 1.75/8 1.75/8 3.00/4 0.50/4
2010-10-30 Villarreal B 2-0 Cartagena 14/-4 3,20 1.30/10 1.25/8 1.40/5 1.20/5   14/4 2,67 1.33/9 1.13/8 1.40/5 1.25/4
2010-11-06 Cartagena 2-1 Granada CF 14/2 2,60 1.20/10 1.13/8 1.40/5 1.00/5   16/4 2,80 1.50/10 1.88/8 2.00/5 1.00/5
2010-11-14 Recreativo Huelva 3-0 Cartagena 5/-9 1,73 0.64/11 0.88/8 0.60/5 0.67/6   16/3 2,64 1.36/11 1.13/8 1.67/6 1.00/5
2010-11-20 Cartagena 2-1 Betis 16/0 2,67 1.25/12 1.13/8 1.67/6 0.83/6   30/20 3,33 2.42/12 2.13/8 3.00/6 1.83/6
2010-11-28 Valladolid 0-1 Cartagena 20/3 2,85 1.62/13 1.38/8 2.67/6 0.71/7   18/1 2,69 1.38/13 1.50/8 1.86/7 0.83/6
2010-12-04 Cartagena 1-1 Albacete 19/2 2,57 1.50/14 1.75/8 1.86/7 1.14/7   11/-5 1,93 0.86/14 0.38/8 1.43/7 0.29/7
2010-12-10 Ponferradina 1-2 Cartagena 11/-15 2,47 0.93/15 1.38/8 1.43/7 0.50/8   20/2 2,53 1.47/15 1.75/8 1.75/8 1.14/7
2010-12-19 Cartagena 5-2 Las Palmas 22/3 2,56 1.56/16 2.00/8 1.75/8 1.38/8   25/-2 3,25 1.31/16 1.00/8 1.88/8 0.75/8
2011-01-02 Girona 1-1 Cartagena 22/-2 2,71 1.06/17 1.00/8 1.88/8 0.33/9   27/6 2,82 1.65/17 2.00/8 1.89/9 1.38/8
2011-01-08 Cartagena 1-0 UD Salamanca 28/6 2,78 1.61/18 2.13/8 1.89/9 1.33/9   21/-2 2,44 1.33/18 0.88/8 1.22/9 1.44/9
2011-01-15 Rayo Vallecano 3-1 Cartagena 33/13 2,65 2.00/20 2.00/8 2.50/10 1.50/10   29/7 2,68 1.68/19 2.13/8 2.00/10 1.33/9
2011-01-22 Cartagena 0-4 Celta Vigo 30/5 2,75 1.60/20 2.13/8 2.00/10 1.20/10   40/21 2,81 2.05/21 2.50/8 2.10/10 2.00/11
2011-01-29 Cartagena 1-2 Xerez CD 30/1 2,81 1.52/21 1.75/8 1.82/11 1.20/10   34/1 2,91 1.52/23 2.13/8 1.50/12 1.55/11
2011-02-05 Elche 1-2 Cartagena 20/-1 1,71 1.33/24 0.63/8 1.42/12 1.25/12   31/0 2,82 1.45/22 1.38/8 1.67/12 1.20/10
2011-02-12 Barcelona B 3-0 Cartagena 38/-1 3,08 1.40/25 1.38/8 1.69/13 1.08/12   33/1 2,83 1.52/23 1.63/8 1.67/12 1.36/11
2011-02-19 Cartagena 1-0 Numancia 33/-2 2,83 1.46/24 1.25/8 1.67/12 1.25/12   37/4 2,80 1.44/25 1.50/8 2.00/14 0.73/11
2011-02-26 Cordoba 2-0 Cartagena 36/2 2,69 1.35/26 1.50/8 1.46/13 1.23/13   34/-1 2,76 1.52/25 1.25/8 1.77/13 1.25/12
2011-03-01 Cartagena 1-0 Tenerife 34/-3 2,73 1.46/26 1.13/8 1.77/13 1.15/13   28/-13 2,56 1.04/27 1.63/8 1.20/15 0.83/12
2011-03-05 Gimnastic 2-0 Cartagena 24/-7 1,96 1.04/28 1.50/8 1.14/14 0.93/14   35/-2 2,67 1.52/27 1.13/8 1.86/14 1.15/13
2011-03-12 Cartagena 2-0 Huesca 35/-4 2,64 1.46/28 1.13/8 1.86/14 1.07/14   25/-1 1,76 1.31/29 1.88/8 1.31/16 1.31/13
2011-03-19 Alcorcon 0-0 Cartagena 38/1 2,50 1.33/30 2.00/8 2.27/15 0.40/15   37/-2 2,62 1.52/29 1.50/8 1.93/15 1.07/14
2011-03-26 Cartagena 2-0 Villarreal B 37/-2 2,53 1.50/30 1.63/8 1.93/15 1.07/15   37/-2 2,45 1.52/31 1.25/8 1.59/17 1.43/14
2011-04-02 Granada CF 2-1 Cartagena 56/18 2,85 1.52/33 1.50/8 2.25/16 0.82/17   39/0 2,52 1.55/31 1.63/8 2.00/16 1.07/15
2011-04-09 Cartagena 1-3 Recreativo Huelva 40/-1 2,53 1.50/32 1.63/8 2.00/16 1.00/16   37/8 2,00 1.30/33 1.75/8 1.47/17 1.13/16
2011-04-16 Betis 5-0 Cartagena 61/26 2,82 1.85/34 2.13/8 2.38/16 1.39/18   41/-3 2,58 1.45/33 1.25/8 1.88/17 1.00/16
2011-04-23 Cartagena 1-1 Valladolid 41/-8 2,65 1.41/34 1.25/8 1.88/17 0.94/17   49/7 2,60 1.49/35 2.13/8 2.00/18 0.94/17
2011-04-30 Albacete 1-2 Cartagena 27/-22 2,11 0.83/36 0.50/8 1.12/17 0.58/19   42/-8 2,63 1.40/35 1.00/8 1.83/18 0.94/17
2011-05-07 Cartagena 1-1 Ponferradina 44/-7 2,64 1.44/36 1.38/8 1.83/18 1.06/18   30/-28 2,32 0.74/38 0.63/8 0.89/19 0.58/19
2011-05-12 Las Palmas 2-0 Cartagena 50/-21 3,18 1.16/38 1.75/8 1.78/18 0.60/20   45/-7 2,62 1.43/37 1.13/8 1.79/19 1.06/18
2011-05-15 Cartagena 1-0 Girona 45/-9 2,61 1.39/38 1.00/8 1.79/19 1.00/19   57/8 2,72 1.41/39 1.50/8 1.85/20 0.95/19
2011-05-21 UD Salamanca 2-0 Cartagena 41/-21 2,58 1.05/40 1.38/8 1.21/19 0.90/21   46/-8 2,56 1.44/39 1.00/8 1.85/20 1.00/19
2011-05-29 Cartagena 2-4 Rayo Vallecano 46/-10 2,55 1.40/40 1.00/8 1.85/20 0.95/20   70/26 2,78 1.93/41 1.75/8 2.19/21 1.65/20
2011-06-04 Celta Vigo 3-0 Cartagena 63/20 2,52 1.60/42 1.00/8 1.50/20 1.68/22   48/-12 2,63 1.37/41 1.00/8 1.76/21 0.95/20