Calendario de Liga Fútbol Japón - 1ª Fase - Temporada 2007/2008

Ver jornada

Jornada 1

16 Mar 08	Sony Sendai	Sony Sendai - Gainare 2008-03-16T00:00:00 No disponible 1 - 2	Gainare	...
16 Mar 08	Sagawa	Sagawa - Blaublitz 2008-03-16T00:00:00 No disponible 1 - 1	Blaublitz	...
16 Mar 08	Ryutsu	Ryutsu - Mizushima 2008-03-16T00:00:00 No disponible 1 - 1	Mizushima	...
16 Mar 08	United	United - FC Kariya 2008-03-16T00:00:00 No disponible 0 - 3	FC Kariya	...
16 Mar 08	Tochigi	Tochigi - Ryūkyū 2008-03-16T00:00:00 Tochigi Green Stadium 3 - 1	Ryūkyū	...
16 Mar 08	Yokogawa	Yokogawa - Arte 2008-03-16T00:00:00 No disponible 2 - 1	Arte	...
16 Mar 08	Honda	Honda - Fagiano 2008-03-16T00:00:00 No disponible 2 - 3	Fagiano	...
16 Mar 08	Kataller	Kataller - Giravanz 2008-03-16T00:00:00 Toyama Athletic Recreation Park Stadium 2 - 2	Giravanz	...
16 Mar 08	Sagawa	Sagawa - Reilac 2008-03-16T00:00:00 No disponible 1 - 2	Reilac	...

Ver jornada

Jornada 2

20 Mar 08	FC Kariya	FC Kariya - Tochigi 2008-03-20T00:00:00 No disponible 0 - 1	Tochigi	...
20 Mar 08	Ryūkyū	Ryūkyū - Yokogawa 2008-03-20T00:00:00 No disponible 1 - 2	Yokogawa	...
20 Mar 08	Reilac	Reilac - Sagawa 2008-03-20T00:00:00 No disponible 1 - 1	Sagawa	...
20 Mar 08	Giravanz	Giravanz - Sagawa 2008-03-20T00:00:00 Honjō Athletic Stadium 1 - 1	Sagawa	...
20 Mar 08	Arte	Arte - Honda 2008-03-20T00:00:00 No disponible 0 - 3	Honda	...
20 Mar 08	Gainare	Gainare - Ryutsu 2008-03-20T00:00:00 Tottori Bank Bird Stadium 3 - 1	Ryutsu	...
20 Mar 08	Blaublitz	Blaublitz - Sony Sendai 2008-03-20T00:00:00 No disponible 0 - 2	Sony Sendai	...
20 Mar 08	Fagiano	Fagiano - Kataller 2008-03-20T00:00:00 Kanko Stadium 3 - 2	Kataller	...
20 Mar 08	Mizushima	Mizushima - United 2008-03-20T00:00:00 No disponible 1 - 1	United	...

Ver jornada

Jornada 3

23 Mar 08	Sagawa	Sagawa - Fagiano 2008-03-23T00:00:00 No disponible 1 - 2	Fagiano	...
23 Mar 08	Reilac	Reilac - Giravanz 2008-03-23T00:00:00 No disponible 1 - 0	Giravanz	...
23 Mar 08	Gainare	Gainare - United 2008-03-23T00:00:00 Tottori Bank Bird Stadium 0 - 1	United	...
23 Mar 08	Sony Sendai	Sony Sendai - Sagawa 2008-03-23T00:00:00 No disponible 5 - 1	Sagawa	...
23 Mar 08	Ryutsu	Ryutsu - Blaublitz 2008-03-23T00:00:00 No disponible 1 - 1	Blaublitz	...
23 Mar 08	Tochigi	Tochigi - Mizushima 2008-03-23T00:00:00 Tochigi Green Stadium 5 - 0	Mizushima	...
23 Mar 08	Yokogawa	Yokogawa - FC Kariya 2008-03-23T00:00:00 No disponible 2 - 2	FC Kariya	...
23 Mar 08	Honda	Honda - Ryūkyū 2008-03-23T00:00:00 No disponible 1 - 0	Ryūkyū	...
23 Mar 08	Kataller	Kataller - Arte 2008-03-23T00:00:00 Toyama Athletic Recreation Park Stadium 2 - 1	Arte	...

Ver jornada

Jornada 4

29 Mar 08	Arte	Arte - Sagawa 2008-03-29T00:00:00 No disponible 1 - 1	Sagawa	...
29 Mar 08	Sagawa	Sagawa - Ryutsu 2008-03-29T00:00:00 No disponible 0 - 2	Ryutsu	...
30 Mar 08	Ryūkyū	Ryūkyū - Kataller 2008-03-30T00:00:00 No disponible 2 - 1	Kataller	...
30 Mar 08	Fagiano	Fagiano - Giravanz 2008-03-30T00:00:00 Kanko Stadium 4 - 2	Giravanz	...
30 Mar 08	FC Kariya	FC Kariya - Honda 2008-03-30T00:00:00 No disponible 1 - 2	Honda	...
30 Mar 08	Mizushima	Mizushima - Yokogawa 2008-03-30T00:00:00 No disponible 0 - 2	Yokogawa	...
30 Mar 08	Gainare	Gainare - Tochigi 2008-03-30T00:00:00 Tottori Bank Bird Stadium 0 - 1	Tochigi	...
30 Mar 08	Blaublitz	Blaublitz - United 2008-03-30T00:00:00 No disponible 1 - 2	United	...
30 Mar 08	Sony Sendai	Sony Sendai - Reilac 2008-03-30T00:00:00 No disponible 1 - 3	Reilac	...

Ver jornada

Jornada 5

05 Abr 08	Yokogawa	Yokogawa - Gainare 2008-04-05T00:00:00 No disponible 2 - 1	Gainare	...
05 Abr 08	Ryutsu	Ryutsu - Sony Sendai 2008-04-05T00:00:00 No disponible 1 - 3	Sony Sendai	...
06 Abr 08	United	United - Sagawa 2008-04-06T00:00:00 No disponible 1 - 2	Sagawa	...
06 Abr 08	Fagiano	Fagiano - Reilac 2008-04-06T00:00:00 Kanko Stadium 2 - 0	Reilac	...
06 Abr 08	Giravanz	Giravanz - Arte 2008-04-06T00:00:00 Honjō Athletic Stadium 1 - 0	Arte	...
06 Abr 08	Tochigi	Tochigi - Blaublitz 2008-04-06T00:00:00 Tochigi Green Stadium 2 - 1	Blaublitz	...
06 Abr 08	Honda	Honda - Mizushima 2008-04-06T00:00:00 No disponible 1 - 0	Mizushima	...
06 Abr 08	Kataller	Kataller - FC Kariya 2008-04-06T00:00:00 Toyama Athletic Recreation Park Stadium 0 - 1	FC Kariya	...
06 Abr 08	Sagawa	Sagawa - Ryūkyū 2008-04-06T00:00:00 No disponible 3 - 0	Ryūkyū	...

Ver jornada

Jornada 6

12 Abr 08	Ryūkyū	Ryūkyū - Giravanz 2008-04-12T00:00:00 No disponible 1 - 1	Giravanz	...
12 Abr 08	FC Kariya	FC Kariya - Sagawa 2008-04-12T00:00:00 No disponible 2 - 1	Sagawa	...
13 Abr 08	Arte	Arte - Fagiano 2008-04-13T00:00:00 No disponible 1 - 3	Fagiano	...
13 Abr 08	Mizushima	Mizushima - Kataller 2008-04-13T00:00:00 No disponible 0 - 4	Kataller	...
13 Abr 08	Gainare	Gainare - Honda 2008-04-13T00:00:00 Tottori Bank Bird Stadium 4 - 1	Honda	...
13 Abr 08	Blaublitz	Blaublitz - Yokogawa 2008-04-13T00:00:00 No disponible 1 - 3	Yokogawa	...
13 Abr 08	Sagawa	Sagawa - Tochigi 2008-04-13T00:00:00 No disponible 2 - 2	Tochigi	...
13 Abr 08	Sony Sendai	Sony Sendai - United 2008-04-13T00:00:00 No disponible 1 - 1	United	...
13 Abr 08	Ryutsu	Ryutsu - Reilac 2008-04-13T00:00:00 No disponible 4 - 3	Reilac	...

Ver jornada

Jornada 7

19 Abr 08	Reilac	Reilac - Arte 2008-04-19T00:00:00 No disponible 2 - 2	Arte	...
20 Abr 08	Giravanz	Giravanz - FC Kariya 2008-04-20T00:00:00 Honjō Athletic Stadium 1 - 0	FC Kariya	...
20 Abr 08	Fagiano	Fagiano - Ryūkyū 2008-04-20T00:00:00 Kanko Stadium 2 - 2	Ryūkyū	...
20 Abr 08	United	United - Ryutsu 2008-04-20T00:00:00 No disponible 0 - 2	Ryutsu	...
20 Abr 08	Tochigi	Tochigi - Sony Sendai 2008-04-20T00:00:00 Tochigi Green Stadium 1 - 0	Sony Sendai	...
20 Abr 08	Yokogawa	Yokogawa - Sagawa 2008-04-20T00:00:00 No disponible 1 - 0	Sagawa	...
20 Abr 08	Honda	Honda - Blaublitz 2008-04-20T00:00:00 No disponible 4 - 2	Blaublitz	...
20 Abr 08	Kataller	Kataller - Gainare 2008-04-20T00:00:00 Toyama Athletic Recreation Park Stadium 1 - 0	Gainare	...
20 Abr 08	Sagawa	Sagawa - Mizushima 2008-04-20T00:00:00 No disponible 1 - 2	Mizushima	...

Ver jornada

Jornada 8

27 Abr 08	Ryūkyū	Ryūkyū - Arte 2008-04-27T00:00:00 No disponible 1 - 0	Arte	...
27 Abr 08	FC Kariya	FC Kariya - Fagiano 2008-04-27T00:00:00 No disponible 2 - 2	Fagiano	...
27 Abr 08	Mizushima	Mizushima - Giravanz 2008-04-27T00:00:00 No disponible 1 - 2	Giravanz	...
27 Abr 08	Gainare	Gainare - Sagawa 2008-04-27T00:00:00 Tottori Bank Bird Stadium 1 - 2	Sagawa	...
27 Abr 08	Blaublitz	Blaublitz - Kataller 2008-04-27T00:00:00 No disponible 1 - 1	Kataller	...
27 Abr 08	Sagawa	Sagawa - Honda 2008-04-27T00:00:00 No disponible 1 - 6	Honda	...
27 Abr 08	Sony Sendai	Sony Sendai - Yokogawa 2008-04-27T00:00:00 No disponible 0 - 1	Yokogawa	...
27 Abr 08	Ryutsu	Ryutsu - Tochigi 2008-04-27T00:00:00 No disponible 2 - 1	Tochigi	...
29 Abr 08	United	United - Reilac 2008-04-29T06:00:00 No disponible 0 - 1	Reilac	...

Ver jornada

Jornada 9

02 May 08	Kataller	Kataller - Sagawa 2008-05-02T00:00:00 Toyama Athletic Recreation Park Stadium 1 - 1	Sagawa	...
03 May 08	Fagiano	Fagiano - Mizushima 2008-05-03T00:00:00 Kanko Stadium 2 - 0	Mizushima	...
03 May 08	Yokogawa	Yokogawa - Ryutsu 2008-05-03T00:00:00 No disponible 0 - 0	Ryutsu	...
03 May 08	Reilac	Reilac - Ryūkyū 2008-05-03T00:00:00 No disponible 1 - 0	Ryūkyū	...
03 May 08	Giravanz	Giravanz - Gainare 2008-05-03T00:00:00 Honjō Athletic Stadium 1 - 1	Gainare	...
03 May 08	Arte	Arte - FC Kariya 2008-05-03T00:00:00 No disponible 1 - 2	FC Kariya	...
03 May 08	Tochigi	Tochigi - United 2008-05-03T00:00:00 Tochigi Green Stadium 4 - 0	United	...
03 May 08	Honda	Honda - Sony Sendai 2008-05-03T00:00:00 No disponible 1 - 0	Sony Sendai	...
03 May 08	Sagawa	Sagawa - Blaublitz 2008-05-03T00:00:00 No disponible 1 - 0	Blaublitz	...

Ver jornada

Jornada 10

06 May 08	FC Kariya	FC Kariya - Ryūkyū 2008-05-06T00:00:00 No disponible 4 - 1	Ryūkyū	...
06 May 08	Mizushima	Mizushima - Arte 2008-05-06T00:00:00 No disponible 3 - 1	Arte	...
06 May 08	Gainare	Gainare - Fagiano 2008-05-06T00:00:00 Tottori Bank Bird Stadium 2 - 3	Fagiano	...
06 May 08	Blaublitz	Blaublitz - Giravanz 2008-05-06T00:00:00 No disponible 2 - 3	Giravanz	...
06 May 08	Sagawa	Sagawa - Sagawa 2008-05-06T00:00:00 No disponible 0 - 1	Sagawa	...
06 May 08	Sony Sendai	Sony Sendai - Kataller 2008-05-06T00:00:00 No disponible 2 - 0	Kataller	...
06 May 08	Ryutsu	Ryutsu - Honda 2008-05-06T00:00:00 No disponible 0 - 2	Honda	...
06 May 08	United	United - Yokogawa 2008-05-06T00:00:00 No disponible 1 - 2	Yokogawa	...
06 May 08	Tochigi	Tochigi - Reilac 2008-05-06T00:00:00 Tochigi Green Stadium 4 - 3	Reilac	...

Ver jornada

Jornada 11

10 May 08	Yokogawa	Yokogawa - Tochigi 2008-05-10T00:00:00 No disponible 1 - 0	Tochigi	...
10 May 08	Reilac	Reilac - FC Kariya 2008-05-10T00:00:00 No disponible 0 - 0	FC Kariya	...
11 May 08	Ryūkyū	Ryūkyū - Mizushima 2008-05-11T00:00:00 No disponible 4 - 1	Mizushima	...
11 May 08	Giravanz	Giravanz - Sagawa 2008-05-11T00:00:00 Honjō Athletic Stadium 1 - 1	Sagawa	...
11 May 08	Fagiano	Fagiano - Blaublitz 2008-05-11T00:00:00 Kanko Stadium 1 - 2	Blaublitz	...
11 May 08	Honda	Honda - United 2008-05-11T00:00:00 No disponible 3 - 1	United	...
11 May 08	Kataller	Kataller - Ryutsu 2008-05-11T00:00:00 Toyama Athletic Recreation Park Stadium 3 - 2	Ryutsu	...
11 May 08	Sagawa	Sagawa - Sony Sendai 2008-05-11T00:00:00 No disponible 2 - 1	Sony Sendai	...
12 May 08	Arte	Arte - Gainare 2008-05-12T00:00:00 No disponible 1 - 1	Gainare	...

Ver jornada

Jornada 12

17 May 08	Sony Sendai	Sony Sendai - Giravanz 2008-05-17T06:00:00 No disponible 3 - 1	Giravanz	...
18 May 08	United	United - Kataller 2008-05-18T05:00:00 No disponible 1 - 2	Kataller	...
18 May 08	Mizushima	Mizushima - FC Kariya 2008-05-18T06:00:00 No disponible 3 - 3	FC Kariya	...
18 May 08	Gainare	Gainare - Ryūkyū 2008-05-18T06:00:00 Tottori Bank Bird Stadium 5 - 1	Ryūkyū	...
18 May 08	Blaublitz	Blaublitz - Arte 2008-05-18T06:00:00 No disponible 3 - 0	Arte	...
18 May 08	Sagawa	Sagawa - Fagiano 2008-05-18T06:00:00 No disponible 0 - 0	Fagiano	...
18 May 08	Ryutsu	Ryutsu - Sagawa 2008-05-18T06:00:00 No disponible 3 - 1	Sagawa	...
18 May 08	Tochigi	Tochigi - Honda 2008-05-18T06:00:00 Tochigi Green Stadium 1 - 0	Honda	...
18 May 08	Yokogawa	Yokogawa - Reilac 2008-05-18T06:00:00 No disponible 0 - 1	Reilac	...

Ver jornada

Jornada 13

24 May 08	Reilac	Reilac - Mizushima 2008-05-24T06:00:00 No disponible 2 - 0	Mizushima	...
24 May 08	Sony Sendai	Sony Sendai - Fagiano 2008-05-24T06:00:00 No disponible 3 - 2	Fagiano	...
25 May 08	Giravanz	Giravanz - Ryutsu 2008-05-25T06:00:00 Honjō Athletic Stadium 4 - 2	Ryutsu	...
25 May 08	Arte	Arte - Sagawa 2008-05-25T06:00:00 No disponible 0 - 5	Sagawa	...
25 May 08	FC Kariya	FC Kariya - Gainare 2008-05-25T06:00:00 No disponible 0 - 1	Gainare	...
25 May 08	Honda	Honda - Yokogawa 2008-05-25T06:00:00 No disponible 1 - 2	Yokogawa	...
25 May 08	Kataller	Kataller - Tochigi 2008-05-25T06:00:00 Toyama Athletic Recreation Park Stadium 0 - 0	Tochigi	...
25 May 08	Sagawa	Sagawa - United 2008-05-25T06:00:00 No disponible 1 - 2	United	...
25 May 08	Ryūkyū	Ryūkyū - Blaublitz 2008-05-25T08:00:00 No disponible 0 - 1	Blaublitz	...

Ver jornada

Jornada 14

01 Jun 08	Gainare	Gainare - Mizushima 2008-06-01T06:00:00 Tottori Bank Bird Stadium 2 - 1	Mizushima	...
01 Jun 08	Blaublitz	Blaublitz - FC Kariya 2008-06-01T06:00:00 No disponible 1 - 1	FC Kariya	...
01 Jun 08	Sagawa	Sagawa - Ryūkyū 2008-06-01T06:00:00 No disponible 2 - 0	Ryūkyū	...
01 Jun 08	Sony Sendai	Sony Sendai - Arte 2008-06-01T06:00:00 No disponible 1 - 2	Arte	...
01 Jun 08	Ryutsu	Ryutsu - Fagiano 2008-06-01T06:00:00 No disponible 2 - 1	Fagiano	...
01 Jun 08	United	United - Giravanz 2008-06-01T06:00:00 No disponible 2 - 3	Giravanz	...
01 Jun 08	Tochigi	Tochigi - Sagawa 2008-06-01T06:00:00 Tochigi Green Stadium 2 - 1	Sagawa	...
01 Jun 08	Yokogawa	Yokogawa - Kataller 2008-06-01T06:00:00 No disponible 1 - 2	Kataller	...
01 Jun 08	Honda	Honda - Reilac 2008-06-01T06:00:00 No disponible 4 - 0	Reilac	...

Ver jornada

Jornada 15

07 Jun 08	Reilac	Reilac - Gainare 2008-06-07T06:00:00 No disponible 0 - 3	Gainare	...
07 Jun 08	Arte	Arte - Ryutsu 2008-06-07T06:00:00 No disponible 1 - 0	Ryutsu	...
07 Jun 08	FC Kariya	FC Kariya - Sagawa 2008-06-07T06:00:00 No disponible 2 - 2	Sagawa	...
08 Jun 08	Giravanz	Giravanz - Tochigi 2008-06-08T06:00:00 Honjō Athletic Stadium 2 - 3	Tochigi	...
08 Jun 08	Kataller	Kataller - Honda 2008-06-08T06:00:00 Toyama Athletic Recreation Park Stadium 2 - 2	Honda	...
08 Jun 08	Sagawa	Sagawa - Yokogawa 2008-06-08T06:00:00 No disponible 1 - 1	Yokogawa	...
08 Jun 08	Mizushima	Mizushima - Blaublitz 2008-06-08T07:00:00 No disponible 0 - 2	Blaublitz	...
08 Jun 08	Ryūkyū	Ryūkyū - Sony Sendai 2008-06-08T08:00:00 No disponible 0 - 2	Sony Sendai	...
08 Jun 08	Fagiano	Fagiano - United 2008-06-08T11:00:00 Kanko Stadium 3 - 1	United	...

Ver jornada

Jornada 16

14 Jun 08	Sagawa	Sagawa - Mizushima 2008-06-14T06:00:00 No disponible 3 - 3	Mizushima	...
14 Jun 08	Sony Sendai	Sony Sendai - FC Kariya 2008-06-14T06:00:00 No disponible 0 - 1	FC Kariya	...
15 Jun 08	Blaublitz	Blaublitz - Gainare 2008-06-15T06:00:00 No disponible 1 - 1	Gainare	...
15 Jun 08	United	United - Arte 2008-06-15T06:00:00 No disponible 1 - 1	Arte	...
15 Jun 08	Tochigi	Tochigi - Fagiano 2008-06-15T06:00:00 Tochigi Green Stadium 2 - 1	Fagiano	...
15 Jun 08	Yokogawa	Yokogawa - Giravanz 2008-06-15T06:00:00 No disponible 1 - 2	Giravanz	...
15 Jun 08	Honda	Honda - Sagawa 2008-06-15T06:00:00 No disponible 0 - 0	Sagawa	...
15 Jun 08	Kataller	Kataller - Reilac 2008-06-15T06:00:00 Toyama Athletic Recreation Park Stadium 5 - 1	Reilac	...
15 Jun 08	Ryutsu	Ryutsu - Ryūkyū 2008-06-15T07:00:00 No disponible 1 - 3	Ryūkyū	...

Ver jornada

Jornada 17

21 Jun 08	Fagiano	Fagiano - Yokogawa 2008-06-21T06:00:00 Kanko Stadium 2 - 0	Yokogawa	...
21 Jun 08	Ryūkyū	Ryūkyū - United 2008-06-21T08:00:00 No disponible 4 - 0	United	...
22 Jun 08	Reilac	Reilac - Blaublitz 2008-06-22T06:00:00 No disponible 1 - 4	Blaublitz	...
22 Jun 08	Giravanz	Giravanz - Honda 2008-06-22T06:00:00 Honjō Athletic Stadium 2 - 2	Honda	...
22 Jun 08	Arte	Arte - Tochigi 2008-06-22T06:00:00 No disponible 2 - 3	Tochigi	...
22 Jun 08	FC Kariya	FC Kariya - Ryutsu 2008-06-22T06:00:00 No disponible 1 - 1	Ryutsu	...
22 Jun 08	Gainare	Gainare - Sagawa 2008-06-22T06:00:00 Tottori Bank Bird Stadium 1 - 0	Sagawa	...
22 Jun 08	Mizushima	Mizushima - Sony Sendai 2008-06-22T07:00:00 No disponible 0 - 1	Sony Sendai	...
22 Jun 08	Sagawa	Sagawa - Kataller 2008-06-22T09:00:00 No disponible 2 - 2	Kataller	...

Ver jornada

Jornada 18

28 Jun 08	Arte	Arte - Yokogawa 2008-06-28T06:00:00 No disponible 1 - 8	Yokogawa	...
29 Jun 08	Reilac	Reilac - Sagawa 2008-06-29T06:00:00 No disponible 3 - 3	Sagawa	...
29 Jun 08	Giravanz	Giravanz - Kataller 2008-06-29T06:00:00 Honjō Athletic Stadium 2 - 0	Kataller	...
29 Jun 08	Fagiano	Fagiano - Honda 2008-06-29T06:00:00 Kanko Stadium 1 - 3	Honda	...
29 Jun 08	Gainare	Gainare - Sony Sendai 2008-06-29T06:00:00 Tottori Bank Bird Stadium 0 - 0	Sony Sendai	...
29 Jun 08	Blaublitz	Blaublitz - Sagawa 2008-06-29T06:00:00 No disponible 1 - 2	Sagawa	...
29 Jun 08	Mizushima	Mizushima - Ryutsu 2008-06-29T07:00:00 No disponible 1 - 4	Ryutsu	...
29 Jun 08	Ryūkyū	Ryūkyū - Tochigi 2008-06-29T08:00:00 No disponible 0 - 1	Tochigi	...
29 Jun 08	FC Kariya	FC Kariya - United 2008-06-29T11:00:00 No disponible 1 - 0	United	...

Ver jornada

Jornada 19

05 Jul 08	Sagawa	Sagawa - FC Kariya 2008-07-05T09:00:00 No disponible 0 - 0	FC Kariya	...
05 Jul 08	Tochigi	Tochigi - Sagawa 2008-07-05T10:00:00 Tochigi Green Stadium 4 - 0	Sagawa	...
05 Jul 08	Honda	Honda - Gainare 2008-07-05T11:00:00 No disponible 5 - 1	Gainare	...
05 Jul 08	Kataller	Kataller - Mizushima 2008-07-05T11:00:00 Toyama Athletic Recreation Park Stadium 3 - 0	Mizushima	...
06 Jul 08	United	United - Sony Sendai 2008-07-06T05:00:00 No disponible 1 - 2	Sony Sendai	...
06 Jul 08	Reilac	Reilac - Ryutsu 2008-07-06T06:00:00 No disponible 1 - 2	Ryutsu	...
06 Jul 08	Giravanz	Giravanz - Ryūkyū 2008-07-06T06:00:00 Honjō Athletic Stadium 0 - 1	Ryūkyū	...
06 Jul 08	Fagiano	Fagiano - Arte 2008-07-06T06:00:00 Kanko Stadium 5 - 1	Arte	...
06 Jul 08	Yokogawa	Yokogawa - Blaublitz 2008-07-06T07:00:00 No disponible 1 - 1	Blaublitz	...

Ver jornada

Jornada 20

12 Jul 08	Sony Sendai	Sony Sendai - Tochigi 2008-07-12T06:00:00 No disponible 3 - 2	Tochigi	...
12 Jul 08	FC Kariya	FC Kariya - Giravanz 2008-07-12T11:00:00 No disponible 1 - 1	Giravanz	...
12 Jul 08	Gainare	Gainare - Kataller 2008-07-12T11:30:00 Tottori Bank Bird Stadium 1 - 2	Kataller	...
13 Jul 08	Arte	Arte - Reilac 2008-07-13T06:00:00 No disponible 3 - 1	Reilac	...
13 Jul 08	Blaublitz	Blaublitz - Honda 2008-07-13T06:00:00 No disponible 1 - 1	Honda	...
13 Jul 08	Ryutsu	Ryutsu - United 2008-07-13T06:00:00 No disponible 1 - 0	United	...
13 Jul 08	Mizushima	Mizushima - Sagawa 2008-07-13T07:00:00 No disponible 1 - 3	Sagawa	...
13 Jul 08	Ryūkyū	Ryūkyū - Fagiano 2008-07-13T08:00:00 No disponible 1 - 2	Fagiano	...
13 Jul 08	Sagawa	Sagawa - Yokogawa 2008-07-13T08:30:00 No disponible 1 - 1	Yokogawa	...

Ver jornada

Jornada 21

19 Jul 08	Yokogawa	Yokogawa - Sony Sendai 2008-07-19T08:00:00 No disponible 0 - 0	Sony Sendai	...
19 Jul 08	Sagawa	Sagawa - Gainare 2008-07-19T09:00:00 No disponible 1 - 1	Gainare	...
19 Jul 08	Tochigi	Tochigi - Ryutsu 2008-07-19T10:00:00 Tochigi Green Stadium 4 - 3	Ryutsu	...
19 Jul 08	Fagiano	Fagiano - FC Kariya 2008-07-19T11:00:00 Kanko Stadium 0 - 0	FC Kariya	...
19 Jul 08	Honda	Honda - Sagawa 2008-07-19T11:00:00 No disponible 1 - 1	Sagawa	...
20 Jul 08	Reilac	Reilac - United 2008-07-20T06:00:00 No disponible 0 - 3	United	...
20 Jul 08	Giravanz	Giravanz - Mizushima 2008-07-20T06:00:00 Honjō Athletic Stadium 2 - 0	Mizushima	...
20 Jul 08	Arte	Arte - Ryūkyū 2008-07-20T06:00:00 No disponible 1 - 1	Ryūkyū	...
21 Jul 08	Kataller	Kataller - Blaublitz 2008-07-21T08:00:00 Toyama Athletic Recreation Park Stadium 3 - 1	Blaublitz	...

Ver jornada

Jornada 22

25 Jul 08	Sagawa	Sagawa - Kataller 2008-07-25T11:00:00 No disponible 0 - 0	Kataller	...
26 Jul 08	FC Kariya	FC Kariya - Arte 2008-07-26T11:00:00 No disponible 3 - 1	Arte	...
26 Jul 08	Gainare	Gainare - Giravanz 2008-07-26T11:30:00 Tottori Bank Bird Stadium 1 - 0	Giravanz	...
27 Jul 08	Blaublitz	Blaublitz - Sagawa 2008-07-27T06:00:00 No disponible 3 - 2	Sagawa	...
27 Jul 08	Ryutsu	Ryutsu - Yokogawa 2008-07-27T06:00:00 No disponible 1 - 2	Yokogawa	...
27 Jul 08	Mizushima	Mizushima - Fagiano 2008-07-27T07:00:00 No disponible 0 - 3	Fagiano	...
27 Jul 08	Ryūkyū	Ryūkyū - Reilac 2008-07-27T08:00:00 No disponible 1 - 1	Reilac	...
27 Jul 08	United	United - Tochigi 2008-07-27T10:00:00 No disponible 1 - 1	Tochigi	...
27 Jul 08	Sony Sendai	Sony Sendai - Honda 2008-07-27T11:00:00 No disponible 0 - 2	Honda	...

Ver jornada

Jornada 23

02 Ago 08	Arte	Arte - Mizushima 2008-08-02T06:00:00 No disponible 1 - 1	Mizushima	...
02 Ago 08	Sagawa	Sagawa - Sagawa 2008-08-02T09:00:00 No disponible 1 - 3	Sagawa	...
02 Ago 08	Fagiano	Fagiano - Gainare 2008-08-02T11:00:00 Kanko Stadium 0 - 1	Gainare	...
02 Ago 08	Yokogawa	Yokogawa - United 2008-08-02T11:00:00 No disponible 1 - 0	United	...
02 Ago 08	Honda	Honda - Ryutsu 2008-08-02T11:00:00 No disponible 0 - 0	Ryutsu	...
03 Ago 08	Reilac	Reilac - Tochigi 2008-08-03T07:00:00 No disponible 2 - 2	Tochigi	...
03 Ago 08	Ryūkyū	Ryūkyū - FC Kariya 2008-08-03T08:00:00 No disponible 1 - 4	FC Kariya	...
03 Ago 08	Kataller	Kataller - Sony Sendai 2008-08-03T08:00:00 Toyama Athletic Recreation Park Stadium 3 - 0	Sony Sendai	...
03 Ago 08	Giravanz	Giravanz - Blaublitz 2008-08-03T09:00:00 Honjō Athletic Stadium 0 - 2	Blaublitz	...

Ver jornada

Jornada 24

09 Ago 08	Sony Sendai	Sony Sendai - Sagawa 2008-08-09T08:00:00 No disponible 1 - 2	Sagawa	...
09 Ago 08	United	United - Honda 2008-08-09T10:00:00 No disponible 1 - 0	Honda	...
09 Ago 08	Tochigi	Tochigi - Yokogawa 2008-08-09T10:00:00 Tochigi Green Stadium 0 - 1	Yokogawa	...
09 Ago 08	FC Kariya	FC Kariya - Reilac 2008-08-09T11:00:00 No disponible 0 - 1	Reilac	...
09 Ago 08	Gainare	Gainare - Arte 2008-08-09T11:30:00 Tottori Bank Bird Stadium 8 - 1	Arte	...
10 Ago 08	Mizushima	Mizushima - Ryūkyū 2008-08-10T06:00:00 No disponible 1 - 1	Ryūkyū	...
10 Ago 08	Ryutsu	Ryutsu - Kataller 2008-08-10T06:00:00 No disponible 1 - 0	Kataller	...
10 Ago 08	Sagawa	Sagawa - Giravanz 2008-08-10T11:00:00 No disponible 0 - 0	Giravanz	...
14 Ago 08	FC Kariya	FC Kariya - Mizushima 2008-08-14T09:00:00 No disponible 1 - 0	Mizushima	...

Ver jornada

Jornada 25

16 Ago 08	Honda	Honda - Tochigi 2008-08-16T11:00:00 No disponible 2 - 1	Tochigi	...
17 Ago 08	Arte	Arte - Blaublitz 2008-08-17T06:00:00 No disponible 1 - 3	Blaublitz	...
17 Ago 08	Reilac	Reilac - Yokogawa 2008-08-17T07:00:00 No disponible 0 - 2	Yokogawa	...
17 Ago 08	Ryūkyū	Ryūkyū - Gainare 2008-08-17T08:00:00 No disponible 0 - 4	Gainare	...
17 Ago 08	Kataller	Kataller - United 2008-08-17T08:00:00 Toyama Athletic Recreation Park Stadium 0 - 1	United	...
17 Ago 08	Giravanz	Giravanz - Sony Sendai 2008-08-17T09:00:00 Honjō Athletic Stadium 0 - 3	Sony Sendai	...
17 Ago 08	Sagawa	Sagawa - Ryutsu 2008-08-17T09:00:00 No disponible 2 - 3	Ryutsu	...
20 Ago 08	Fagiano	Fagiano - Sagawa 2008-08-20T11:00:00 Kanko Stadium 0 - 0	Sagawa	...
27 Ago 08	Blaublitz	Blaublitz - Fagiano 2008-08-27T06:00:00 No disponible 1 - 2	Fagiano	...

Ver jornada

Jornada 26

06 Sep 08	Yokogawa	Yokogawa - Honda 2008-09-06T07:00:00 No disponible 0 - 1	Honda	...
06 Sep 08	Sagawa	Sagawa - Arte 2008-09-06T11:00:00 No disponible 1 - 0	Arte	...
06 Sep 08	Fagiano	Fagiano - Sony Sendai 2008-09-06T11:00:00 Kanko Stadium 2 - 2	Sony Sendai	...
07 Sep 08	Blaublitz	Blaublitz - Ryūkyū 2008-09-07T06:00:00 No disponible 1 - 0	Ryūkyū	...
07 Sep 08	Ryutsu	Ryutsu - Giravanz 2008-09-07T06:00:00 No disponible 2 - 1	Giravanz	...
07 Sep 08	Tochigi	Tochigi - Kataller 2008-09-07T06:00:00 Tochigi Green Stadium 1 - 2	Kataller	...
07 Sep 08	Mizushima	Mizushima - Reilac 2008-09-07T07:00:00 No disponible 3 - 0	Reilac	...
07 Sep 08	Gainare	Gainare - FC Kariya 2008-09-07T08:00:00 Tottori Bank Bird Stadium 1 - 3	FC Kariya	...
07 Sep 08	United	United - Sagawa 2008-09-07T09:00:00 No disponible 2 - 1	Sagawa	...

Ver jornada

Jornada 27

04 Oct 08	Sagawa	Sagawa - Tochigi 2008-10-04T06:00:00 No disponible 3 - 2	Tochigi	...
04 Oct 08	Arte	Arte - Sony Sendai 2008-10-04T07:00:00 No disponible 2 - 6	Sony Sendai	...
05 Oct 08	Reilac	Reilac - Honda 2008-10-05T06:00:00 No disponible 2 - 4	Honda	...
05 Oct 08	Giravanz	Giravanz - United 2008-10-05T06:00:00 Honjō Athletic Stadium 3 - 2	United	...
05 Oct 08	Fagiano	Fagiano - Ryutsu 2008-10-05T06:00:00 Kanko Stadium 2 - 2	Ryutsu	...
05 Oct 08	Kataller	Kataller - Yokogawa 2008-10-05T06:00:00 Toyama Athletic Recreation Park Stadium 4 - 1	Yokogawa	...
05 Oct 08	Mizushima	Mizushima - Gainare 2008-10-05T07:00:00 No disponible 0 - 2	Gainare	...
05 Oct 08	FC Kariya	FC Kariya - Blaublitz 2008-10-05T07:30:00 No disponible 1 - 1	Blaublitz	...
05 Oct 08	Ryūkyū	Ryūkyū - Sagawa 2008-10-05T08:00:00 No disponible 1 - 2	Sagawa	...

Ver jornada

Jornada 28

18 Oct 08	Sagawa	Sagawa - FC Kariya 2008-10-18T06:00:00 No disponible 1 - 0	FC Kariya	...
18 Oct 08	Sony Sendai	Sony Sendai - Ryūkyū 2008-10-18T06:00:00 No disponible 0 - 1	Ryūkyū	...
19 Oct 08	Gainare	Gainare - Reilac 2008-10-19T06:00:00 Tottori Bank Bird Stadium 2 - 1	Reilac	...
19 Oct 08	Blaublitz	Blaublitz - Mizushima 2008-10-19T06:00:00 No disponible 5 - 0	Mizushima	...
19 Oct 08	Ryutsu	Ryutsu - Arte 2008-10-19T06:00:00 No disponible 3 - 2	Arte	...
19 Oct 08	United	United - Fagiano 2008-10-19T06:00:00 No disponible 1 - 2	Fagiano	...
19 Oct 08	Tochigi	Tochigi - Giravanz 2008-10-19T06:00:00 Tochigi Green Stadium 1 - 1	Giravanz	...
19 Oct 08	Yokogawa	Yokogawa - Sagawa 2008-10-19T06:00:00 No disponible 0 - 0	Sagawa	...
19 Oct 08	Honda	Honda - Kataller 2008-10-19T06:00:00 No disponible 2 - 1	Kataller	...

Ver jornada

Jornada 29

25 Oct 08	Mizushima	Mizushima - Honda 2008-10-25T05:00:00 No disponible 1 - 2	Honda	...
25 Oct 08	Reilac	Reilac - Fagiano 2008-10-25T06:00:00 No disponible 1 - 2	Fagiano	...
25 Oct 08	Arte	Arte - Giravanz 2008-10-25T06:00:00 No disponible 1 - 3	Giravanz	...
26 Oct 08	FC Kariya	FC Kariya - Kataller 2008-10-26T05:00:00 No disponible 0 - 1	Kataller	...
26 Oct 08	Gainare	Gainare - Yokogawa 2008-10-26T05:00:00 Tottori Bank Bird Stadium 1 - 0	Yokogawa	...
26 Oct 08	Blaublitz	Blaublitz - Tochigi 2008-10-26T05:00:00 No disponible 0 - 0	Tochigi	...
26 Oct 08	Sagawa	Sagawa - United 2008-10-26T05:00:00 No disponible 2 - 0	United	...
26 Oct 08	Sony Sendai	Sony Sendai - Ryutsu 2008-10-26T05:00:00 No disponible 0 - 0	Ryutsu	...
26 Oct 08	Ryūkyū	Ryūkyū - Sagawa 2008-10-26T07:00:00 No disponible 0 - 2	Sagawa	...

Ver jornada

Jornada 30

30 Oct 08	Tochigi	Tochigi - Gainare 2008-10-30T11:00:00 Tochigi Green Stadium 5 - 0	Gainare	...
01 Nov 08	Reilac	Reilac - Sony Sendai 2008-11-01T05:00:00 No disponible 1 - 0	Sony Sendai	...
01 Nov 08	Giravanz	Giravanz - Fagiano 2008-11-01T05:00:00 Honjō Athletic Stadium 3 - 1	Fagiano	...
01 Nov 08	Ryutsu	Ryutsu - Sagawa 2008-11-01T05:00:00 No disponible 1 - 2	Sagawa	...
01 Nov 08	United	United - Blaublitz 2008-11-01T05:00:00 No disponible 1 - 1	Blaublitz	...
01 Nov 08	Honda	Honda - FC Kariya 2008-11-01T05:00:00 No disponible 6 - 1	FC Kariya	...
01 Nov 08	Sagawa	Sagawa - Arte 2008-11-01T05:00:00 No disponible 7 - 4	Arte	...
01 Nov 08	Yokogawa	Yokogawa - Mizushima 2008-11-01T06:00:00 No disponible 1 - 1	Mizushima	...
02 Nov 08	Kataller	Kataller - Ryūkyū 2008-11-02T05:00:00 Toyama Athletic Recreation Park Stadium 1 - 0	Ryūkyū	...

Ver jornada

Jornada 31

08 Nov 08	Arte	Arte - Kataller 2008-11-08T05:00:00 No disponible 0 - 3	Kataller	...
08 Nov 08	Fagiano	Fagiano - Sagawa 2008-11-08T06:00:00 Kanko Stadium 0 - 1	Sagawa	...
09 Nov 08	Giravanz	Giravanz - Reilac 2008-11-09T05:00:00 Honjō Athletic Stadium 0 - 1	Reilac	...
09 Nov 08	FC Kariya	FC Kariya - Yokogawa 2008-11-09T05:00:00 No disponible 1 - 2	Yokogawa	...
09 Nov 08	United	United - Gainare 2008-11-09T05:00:00 No disponible 0 - 1	Gainare	...
09 Nov 08	Blaublitz	Blaublitz - Ryutsu 2008-11-09T05:00:00 No disponible 0 - 1	Ryutsu	...
09 Nov 08	Sagawa	Sagawa - Sony Sendai 2008-11-09T05:00:00 No disponible 1 - 0	Sony Sendai	...
09 Nov 08	Ryūkyū	Ryūkyū - Honda 2008-11-09T07:00:00 No disponible 0 - 0	Honda	...
09 Nov 08	Mizushima	Mizushima - Tochigi 2008-11-09T07:00:00 No disponible 0 - 1	Tochigi	...

Ver jornada

Jornada 32

15 Nov 08	Sagawa	Sagawa - Gainare 2008-11-15T05:00:00 No disponible 3 - 0	Gainare	...
15 Nov 08	Yokogawa	Yokogawa - Fagiano 2008-11-15T06:00:00 No disponible 1 - 0	Fagiano	...
16 Nov 08	Blaublitz	Blaublitz - Reilac 2008-11-16T05:00:00 No disponible 0 - 0	Reilac	...
16 Nov 08	Sony Sendai	Sony Sendai - Mizushima 2008-11-16T05:00:00 No disponible 4 - 3	Mizushima	...
16 Nov 08	Ryutsu	Ryutsu - FC Kariya 2008-11-16T05:00:00 No disponible 0 - 1	FC Kariya	...
16 Nov 08	United	United - Ryūkyū 2008-11-16T05:00:00 No disponible 0 - 0	Ryūkyū	...
16 Nov 08	Honda	Honda - Giravanz 2008-11-16T05:00:00 No disponible 1 - 1	Giravanz	...
16 Nov 08	Kataller	Kataller - Sagawa 2008-11-16T05:00:00 Toyama Athletic Recreation Park Stadium 0 - 0	Sagawa	...
16 Nov 08	Tochigi	Tochigi - Arte 2008-11-16T09:00:00 Tochigi Green Stadium 3 - 1	Arte	...

Ver jornada

Jornada 33

22 Nov 08	Sagawa	Sagawa - Honda 2008-11-22T05:00:00 No disponible 1 - 1	Honda	...
23 Nov 08	Reilac	Reilac - Kataller 2008-11-23T05:00:00 No disponible 1 - 2	Kataller	...
23 Nov 08	Giravanz	Giravanz - Yokogawa 2008-11-23T05:00:00 Honjō Athletic Stadium 2 - 1	Yokogawa	...
23 Nov 08	Fagiano	Fagiano - Tochigi 2008-11-23T05:00:00 Kanko Stadium 0 - 0	Tochigi	...
23 Nov 08	FC Kariya	FC Kariya - Sony Sendai 2008-11-23T05:00:00 No disponible 0 - 3	Sony Sendai	...
23 Nov 08	Ryūkyū	Ryūkyū - Ryutsu 2008-11-23T07:00:00 No disponible 1 - 2	Ryutsu	...
24 Nov 08	Arte	Arte - United 2008-11-24T05:00:00 No disponible 2 - 1	United	...
24 Nov 08	Gainare	Gainare - Blaublitz 2008-11-24T05:00:00 Tottori Bank Bird Stadium 4 - 0	Blaublitz	...
24 Nov 08	Mizushima	Mizushima - Sagawa 2008-11-24T05:00:00 No disponible 0 - 1	Sagawa	...

Ver jornada

Jornada 34

30 Nov 08	Tochigi	Tochigi - FC Kariya 2008-11-30T05:00:00 Tochigi Green Stadium 1 - 1	FC Kariya	...
30 Nov 08	Ryutsu	Ryutsu - Gainare 2008-11-30T05:00:00 No disponible 2 - 0	Gainare	...
30 Nov 08	United	United - Mizushima 2008-11-30T05:00:00 No disponible 1 - 1	Mizushima	...
30 Nov 08	Yokogawa	Yokogawa - Ryūkyū 2008-11-30T05:00:00 No disponible 1 - 1	Ryūkyū	...
30 Nov 08	Honda	Honda - Arte 2008-11-30T05:00:00 No disponible 11 - 1	Arte	...
30 Nov 08	Sagawa	Sagawa - Giravanz 2008-11-30T05:00:00 No disponible 2 - 0	Giravanz	...
30 Nov 08	Sony Sendai	Sony Sendai - Blaublitz 2008-11-30T05:00:00 No disponible 3 - 2	Blaublitz	...
30 Nov 08	Sagawa	Sagawa - Reilac 2008-11-30T05:00:00 No disponible 1 - 1	Reilac	...
30 Nov 08	Kataller	Kataller - Fagiano 2008-11-30T05:00:00 Toyama Athletic Recreation Park Stadium 1 - 1	Fagiano	...

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1417
Total Execution Time	0.1436

0.0018	SELECT type FROM routes WHERE alias = 'liga_futbol_japon2008'
0.0039	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_futbol_japon' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018	SELECT id,name,alias,stepParent FROM categories WHERE parentId=233 ORDER BY order_id ASC
0.0020	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 49992 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0052	SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2008 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 49992 ORDER BY round ASC
0.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 01:48:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 01:48:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 01:48:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 01:48:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_futbol_japon' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2008 e ON e.player_id = p.id AND e.league_id = 49992 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49992 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2008 e ON e.player_id = p.id AND e.league_id = 49992 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49992 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2008 e ON e.player_id = p.id AND e.league_id = 49992 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49992 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 49992 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Liga Fútbol Japón - 1ª Fase 2008

Clasificación

Equipos de esta liga

Equipo		PJ	GF	GC	Puntos
1	Honda	34	77	33	69
2	Tochigi	34	64	36	65
3	Kataller	34	56	34	60
4	Yokogawa	34	46	31	60
5	Fagiano	34	59	43	57
6	Gainare	34	56	41	56
7	Ryutsu	34	53	47	55
8	Sagawa	34	43	39	53
9	Sony Sendai	34	53	41	50
10	Giravanz	34	48	47	49
11	FC Kariya	34	43	39	48
12	Sagawa Shiga	34	52	46	47
13	Blaublitz	34	47	46	41
14	Reilac Shiga	34	39	61	38
15	Ryūkyū	34	31	53	29
16	United	34	30	53	28
17	Arte	34	38	102	18
18	Mizushima	34	29	72	17