Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

« Temporada Anterior

Temporada 2006

Temporada Siguiente »

2005/2006

2. Lig 2006 G 1

2. Lig - Play Offs Ascenso

Ver jornada

Jornada 1

13 Ago 05	Eyupspor	Eyupspor - Maltepespor 2005-08-13T16:00:00 Eyüp Stadı 0 - 2	Maltepespor	...
14 Ago 05	Sariyer	Sariyer - Pendikspor 2005-08-14T16:00:00 Yusuf Ziya Öniş Stadyumu 2 - 2	Pendikspor	...
14 Ago 05	Kasımpaşa	Kasımpaşa - Fatih 2005-08-14T16:00:00 Recep Tayyip Erdoğan Stadyumu 2 - 0	Fatih	...
14 Ago 05	Kartalspor	Kartalspor - Kartal 2005-08-14T16:00:00 Radyo Seymen Kartal Stadı 5 - 1	Kartal	...
14 Ago 05	İstanbul	İstanbul - Bagcilarspo 2005-08-14T16:00:00 Mimar Yahya Baş Stadı 4 - 0	Bagcilarspo	...

Ver jornada

Jornada 2

21 Ago 05	Pendikspor	Pendikspor - İstanbul 2005-08-21T16:00:00 Pendik Stadyumu 3 - 1	İstanbul	...
21 Ago 05	Kartalspor	Kartalspor - Maltepespor 2005-08-21T16:00:00 Radyo Seymen Kartal Stadı 1 - 0	Maltepespor	...
21 Ago 05	Kartal	Kartal - Kasımpaşa 2005-08-21T16:00:00 No disponible 0 - 5	Kasımpaşa	...
21 Ago 05	Fatih	Fatih - Kucukkoyspo 2005-08-21T16:00:00 Vefa Stadı 4 - 0	Kucukkoyspo	...
21 Ago 05	Bagcilarspo	Bagcilarspo - Eyupspor 2005-08-21T16:00:00 No disponible 1 - 3	Eyupspor	...

Ver jornada

Jornada 3

27 Ago 05	Kasımpaşa	Kasımpaşa - Maltepespor 2005-08-27T16:00:00 Recep Tayyip Erdoğan Stadyumu 2 - 1	Maltepespor	...
28 Ago 05	Kucukkoyspo	Kucukkoyspo - Kartal 2005-08-28T16:00:00 No disponible 0 - 1	Kartal	...
28 Ago 05	Kartalspor	Kartalspor - Bagcilarspo 2005-08-28T16:00:00 Radyo Seymen Kartal Stadı 1 - 0	Bagcilarspo	...
28 Ago 05	İstanbul	İstanbul - Sariyer 2005-08-28T16:00:00 Mimar Yahya Baş Stadı 2 - 3	Sariyer	...
28 Ago 05	Eyupspor	Eyupspor - Pendikspor 2005-08-28T16:00:00 Eyüp Stadı 1 - 1	Pendikspor	...

Ver jornada

Jornada 4

04 Sep 05	Sariyer	Sariyer - Eyupspor 2005-09-04T15:00:00 Yusuf Ziya Öniş Stadyumu 1 - 1	Eyupspor	...
04 Sep 05	Pendikspor	Pendikspor - Kartalspor 2005-09-04T15:00:00 Pendik Stadyumu 1 - 4	Kartalspor	...
04 Sep 05	Maltepespor	Maltepespor - Kucukkoyspo 2005-09-04T15:00:00 No disponible 0 - 2	Kucukkoyspo	...
04 Sep 05	Kartal	Kartal - Fatih 2005-09-04T15:00:00 No disponible 1 - 3	Fatih	...
04 Sep 05	Bagcilarspo	Bagcilarspo - Kasımpaşa 2005-09-04T15:00:00 No disponible 1 - 3	Kasımpaşa	...

Ver jornada

Jornada 5

07 Sep 05	Kucukkoyspo	Kucukkoyspo - Bagcilarspo 2005-09-07T15:00:00 No disponible 1 - 0	Bagcilarspo	...
07 Sep 05	Kasımpaşa	Kasımpaşa - Pendikspor 2005-09-07T15:00:00 Recep Tayyip Erdoğan Stadyumu 1 - 2	Pendikspor	...
07 Sep 05	Kartalspor	Kartalspor - Sariyer 2005-09-07T15:00:00 Radyo Seymen Kartal Stadı 1 - 1	Sariyer	...
07 Sep 05	Fatih	Fatih - Maltepespor 2005-09-07T15:00:00 Vefa Stadı 2 - 2	Maltepespor	...
07 Sep 05	Eyupspor	Eyupspor - İstanbul 2005-09-07T15:00:00 Eyüp Stadı 0 - 1	İstanbul	...

Ver jornada

Jornada 6

11 Sep 05	Sariyer	Sariyer - Kasımpaşa 2005-09-11T15:00:00 Yusuf Ziya Öniş Stadyumu 2 - 1	Kasımpaşa	...
11 Sep 05	Pendikspor	Pendikspor - Kucukkoyspo 2005-09-11T15:00:00 Pendik Stadyumu 1 - 2	Kucukkoyspo	...
11 Sep 05	Maltepespor	Maltepespor - Kartal 2005-09-11T15:00:00 No disponible 0 - 0	Kartal	...
11 Sep 05	İstanbul	İstanbul - Kartalspor 2005-09-11T15:00:00 Mimar Yahya Baş Stadı 0 - 1	Kartalspor	...
11 Sep 05	Bagcilarspo	Bagcilarspo - Fatih 2005-09-11T15:00:00 No disponible 1 - 2	Fatih	...

Ver jornada

Jornada 7

18 Sep 05	Kartal	Kartal - Bagcilarspo 2005-09-18T00:00:00 No disponible 1 - 0	Bagcilarspo	...
18 Sep 05	Kucukkoyspo	Kucukkoyspo - Sariyer 2005-09-18T15:00:00 No disponible 0 - 1	Sariyer	...
18 Sep 05	Kasımpaşa	Kasımpaşa - İstanbul 2005-09-18T15:00:00 Recep Tayyip Erdoğan Stadyumu 3 - 1	İstanbul	...
18 Sep 05	Kartalspor	Kartalspor - Eyupspor 2005-09-18T15:00:00 Radyo Seymen Kartal Stadı 3 - 0	Eyupspor	...
18 Sep 05	Fatih	Fatih - Pendikspor 2005-09-18T15:00:00 Vefa Stadı 0 - 0	Pendikspor	...

Ver jornada

Jornada 8

25 Sep 05	Sariyer	Sariyer - Fatih 2005-09-25T15:00:00 Yusuf Ziya Öniş Stadyumu 1 - 3	Fatih	...
25 Sep 05	Pendikspor	Pendikspor - Kartal 2005-09-25T15:00:00 Pendik Stadyumu 1 - 0	Kartal	...
25 Sep 05	İstanbul	İstanbul - Kucukkoyspo 2005-09-25T15:00:00 Mimar Yahya Baş Stadı 3 - 0	Kucukkoyspo	...
25 Sep 05	Eyupspor	Eyupspor - Kasımpaşa 2005-09-25T15:00:00 Eyüp Stadı 2 - 2	Kasımpaşa	...
25 Sep 05	Bagcilarspo	Bagcilarspo - Maltepespor 2005-09-25T15:00:00 No disponible 1 - 1	Maltepespor	...

Ver jornada

Jornada 9

01 Oct 05	Maltepespor	Maltepespor - Pendikspor 2005-10-01T14:00:00 No disponible 1 - 0	Pendikspor	...
01 Oct 05	Kartal	Kartal - Sariyer 2005-10-01T14:00:00 No disponible 1 - 2	Sariyer	...
02 Oct 05	Kucukkoyspo	Kucukkoyspo - Eyupspor 2005-10-02T14:00:00 No disponible 0 - 1	Eyupspor	...
02 Oct 05	Kasımpaşa	Kasımpaşa - Kartalspor 2005-10-02T14:00:00 Recep Tayyip Erdoğan Stadyumu 1 - 0	Kartalspor	...
02 Oct 05	Fatih	Fatih - İstanbul 2005-10-02T14:00:00 Vefa Stadı 1 - 1	İstanbul	...

Ver jornada

Jornada 10

09 Oct 05	Sariyer	Sariyer - Maltepespor 2005-10-09T14:00:00 Yusuf Ziya Öniş Stadyumu 2 - 0	Maltepespor	...
09 Oct 05	Pendikspor	Pendikspor - Bagcilarspo 2005-10-09T14:00:00 Pendik Stadyumu 5 - 1	Bagcilarspo	...
09 Oct 05	Kartalspor	Kartalspor - Kucukkoyspo 2005-10-09T14:00:00 Radyo Seymen Kartal Stadı 1 - 0	Kucukkoyspo	...
09 Oct 05	İstanbul	İstanbul - Kartal 2005-10-09T14:00:00 Mimar Yahya Baş Stadı 3 - 0	Kartal	...
09 Oct 05	Eyupspor	Eyupspor - Fatih 2005-10-09T14:00:00 Eyüp Stadı 2 - 1	Fatih	...

Ver jornada

Jornada 11

12 Oct 05	Kartal	Kartal - Eyupspor 2005-10-12T14:00:00 No disponible 2 - 0	Eyupspor	...
13 Oct 05	Maltepespor	Maltepespor - İstanbul 2005-10-13T14:00:00 No disponible 1 - 2	İstanbul	...
13 Oct 05	Kucukkoyspo	Kucukkoyspo - Kasımpaşa 2005-10-13T14:00:00 No disponible 0 - 3	Kasımpaşa	...
13 Oct 05	Fatih	Fatih - Kartalspor 2005-10-13T14:00:00 Vefa Stadı 0 - 0	Kartalspor	...
13 Oct 05	Bagcilarspo	Bagcilarspo - Sariyer 2005-10-13T14:00:00 No disponible 1 - 2	Sariyer	...

Ver jornada

Jornada 12

22 Oct 05	Kartal	Kartal - Kartalspor 2005-10-22T14:00:00 No disponible 1 - 1	Kartalspor	...
23 Oct 05	Pendikspor	Pendikspor - Sariyer 2005-10-23T14:00:00 Pendik Stadyumu 0 - 0	Sariyer	...
23 Oct 05	Maltepespor	Maltepespor - Eyupspor 2005-10-23T14:00:00 No disponible 0 - 0	Eyupspor	...
23 Oct 05	Fatih	Fatih - Kasımpaşa 2005-10-23T14:00:00 Vefa Stadı 1 - 2	Kasımpaşa	...
23 Oct 05	Bagcilarspo	Bagcilarspo - İstanbul 2005-10-23T14:00:00 No disponible 0 - 2	İstanbul	...

Ver jornada

Jornada 13

30 Oct 05	Maltepespor	Maltepespor - Kartalspor 2005-10-30T12:30:00 No disponible 0 - 2	Kartalspor	...
30 Oct 05	Kucukkoyspo	Kucukkoyspo - Fatih 2005-10-30T12:30:00 No disponible 1 - 0	Fatih	...
30 Oct 05	Kasımpaşa	Kasımpaşa - Kartal 2005-10-30T12:30:00 Recep Tayyip Erdoğan Stadyumu 3 - 1	Kartal	...
30 Oct 05	İstanbul	İstanbul - Pendikspor 2005-10-30T12:30:00 Mimar Yahya Baş Stadı 2 - 1	Pendikspor	...
30 Oct 05	Eyupspor	Eyupspor - Bagcilarspo 2005-10-30T12:30:00 Eyüp Stadı 2 - 0	Bagcilarspo	...

Ver jornada

Jornada 14

06 Nov 05	Sariyer	Sariyer - İstanbul 2005-11-06T12:30:00 Yusuf Ziya Öniş Stadyumu 0 - 2	İstanbul	...
06 Nov 05	Pendikspor	Pendikspor - Eyupspor 2005-11-06T12:30:00 Pendik Stadyumu 2 - 0	Eyupspor	...
06 Nov 05	Maltepespor	Maltepespor - Kasımpaşa 2005-11-06T12:30:00 No disponible 1 - 1	Kasımpaşa	...
06 Nov 05	Kartal	Kartal - Kucukkoyspo 2005-11-06T12:30:00 No disponible 1 - 0	Kucukkoyspo	...
06 Nov 05	Bagcilarspo	Bagcilarspo - Kartalspor 2005-11-06T12:30:00 No disponible 0 - 3	Kartalspor	...

Ver jornada

Jornada 15

10 Nov 05	Kucukkoyspo	Kucukkoyspo - Maltepespor 2005-11-10T12:30:00 No disponible 1 - 0	Maltepespor	...
10 Nov 05	Kasımpaşa	Kasımpaşa - Bagcilarspo 2005-11-10T12:30:00 Recep Tayyip Erdoğan Stadyumu 3 - 1	Bagcilarspo	...
10 Nov 05	Kartalspor	Kartalspor - Pendikspor 2005-11-10T12:30:00 Radyo Seymen Kartal Stadı 1 - 1	Pendikspor	...
10 Nov 05	Fatih	Fatih - Kartal 2005-11-10T12:30:00 Vefa Stadı 1 - 1	Kartal	...
10 Nov 05	Eyupspor	Eyupspor - Sariyer 2005-11-10T12:30:00 Eyüp Stadı 4 - 0	Sariyer	...

Ver jornada

Jornada 16

19 Nov 05	Maltepespor	Maltepespor - Fatih 2005-11-19T12:30:00 No disponible 0 - 0	Fatih	...
20 Nov 05	Sariyer	Sariyer - Kartalspor 2005-11-20T12:30:00 Yusuf Ziya Öniş Stadyumu 1 - 2	Kartalspor	...
20 Nov 05	Pendikspor	Pendikspor - Kasımpaşa 2005-11-20T12:30:00 Pendik Stadyumu 2 - 1	Kasımpaşa	...
20 Nov 05	İstanbul	İstanbul - Eyupspor 2005-11-20T12:30:00 Mimar Yahya Baş Stadı 0 - 0	Eyupspor	...
20 Nov 05	Bagcilarspo	Bagcilarspo - Kucukkoyspo 2005-11-20T12:30:00 No disponible 1 - 3	Kucukkoyspo	...

Ver jornada

Jornada 17

23 Nov 05	Kucukkoyspo	Kucukkoyspo - Pendikspor 2005-11-23T12:30:00 No disponible 0 - 1	Pendikspor	...
23 Nov 05	Kasımpaşa	Kasımpaşa - Sariyer 2005-11-23T12:30:00 Recep Tayyip Erdoğan Stadyumu 0 - 0	Sariyer	...
23 Nov 05	Kartalspor	Kartalspor - İstanbul 2005-11-23T12:30:00 Radyo Seymen Kartal Stadı 0 - 1	İstanbul	...
23 Nov 05	Kartal	Kartal - Maltepespor 2005-11-23T12:30:00 No disponible 1 - 2	Maltepespor	...
23 Nov 05	Fatih	Fatih - Bagcilarspo 2005-11-23T12:30:00 Vefa Stadı 3 - 0	Bagcilarspo	...

Ver jornada

Jornada 18

27 Nov 05	Sariyer	Sariyer - Kucukkoyspo 2005-11-27T12:30:00 Yusuf Ziya Öniş Stadyumu 2 - 0	Kucukkoyspo	...
27 Nov 05	Pendikspor	Pendikspor - Fatih 2005-11-27T12:30:00 Pendik Stadyumu 1 - 0	Fatih	...
27 Nov 05	İstanbul	İstanbul - Kasımpaşa 2005-11-27T12:30:00 Mimar Yahya Baş Stadı 3 - 3	Kasımpaşa	...
27 Nov 05	Eyupspor	Eyupspor - Kartalspor 2005-11-27T12:30:00 Eyüp Stadı 0 - 0	Kartalspor	...
27 Nov 05	Bagcilarspo	Bagcilarspo - Kartal 2005-11-27T12:30:00 No disponible 2 - 2	Kartal	...

Ver jornada

Jornada 19

04 Dic 05	Maltepespor	Maltepespor - Bagcilarspo 2005-12-04T12:30:00 No disponible 2 - 1	Bagcilarspo	...
04 Dic 05	Kucukkoyspo	Kucukkoyspo - İstanbul 2005-12-04T12:30:00 No disponible 2 - 1	İstanbul	...
04 Dic 05	Kasımpaşa	Kasımpaşa - Eyupspor 2005-12-04T12:30:00 Recep Tayyip Erdoğan Stadyumu 2 - 0	Eyupspor	...
04 Dic 05	Kartal	Kartal - Pendikspor 2005-12-04T12:30:00 No disponible 0 - 2	Pendikspor	...
04 Dic 05	Fatih	Fatih - Sariyer 2005-12-04T12:30:00 Vefa Stadı 1 - 0	Sariyer	...

Ver jornada

Jornada 20

08 Dic 05	Sariyer	Sariyer - Kartal 2005-12-08T12:30:00 Yusuf Ziya Öniş Stadyumu 2 - 0	Kartal	...
08 Dic 05	Pendikspor	Pendikspor - Maltepespor 2005-12-08T12:30:00 Pendik Stadyumu 0 - 1	Maltepespor	...
08 Dic 05	Kartalspor	Kartalspor - Kasımpaşa 2005-12-08T12:30:00 Radyo Seymen Kartal Stadı 1 - 0	Kasımpaşa	...
08 Dic 05	İstanbul	İstanbul - Fatih 2005-12-08T12:30:00 Mimar Yahya Baş Stadı 1 - 0	Fatih	...
08 Dic 05	Eyupspor	Eyupspor - Kucukkoyspo 2005-12-08T12:30:00 Eyüp Stadı 1 - 1	Kucukkoyspo	...

Ver jornada

Jornada 21

18 Dic 05	Kartal	Kartal - İstanbul 2005-12-18T12:30:00 No disponible 1 - 1	İstanbul	...
18 Dic 05	Fatih	Fatih - Eyupspor 2005-12-18T12:30:00 Vefa Stadı 0 - 2	Eyupspor	...
18 Dic 05	Bagcilarspo	Bagcilarspo - Pendikspor 2005-12-18T12:30:00 No disponible 0 - 1	Pendikspor	...
18 Dic 05	Kucukkoyspo	Kucukkoyspo - Kartalspor 2005-12-18T12:30:00 No disponible 0 - 0	Kartalspor	...
18 Dic 05	Maltepespor	Maltepespor - Sariyer 2005-12-18T12:30:00 No disponible 3 - 3	Sariyer	...

Ver jornada

Jornada 22

25 Dic 05	İstanbul	İstanbul - Maltepespor 2005-12-25T12:30:00 Mimar Yahya Baş Stadı 0 - 1	Maltepespor	...
25 Dic 05	Kasımpaşa	Kasımpaşa - Kucukkoyspo 2005-12-25T12:30:00 Recep Tayyip Erdoğan Stadyumu 2 - 1	Kucukkoyspo	...
25 Dic 05	Kartalspor	Kartalspor - Fatih 2005-12-25T12:30:00 Radyo Seymen Kartal Stadı 0 - 0	Fatih	...
25 Dic 05	Sariyer	Sariyer - Bagcilarspo 2005-12-25T12:30:00 Yusuf Ziya Öniş Stadyumu 2 - 1	Bagcilarspo	...
25 Dic 05	Eyupspor	Eyupspor - Kartal 2005-12-25T12:30:00 Eyüp Stadı 3 - 1	Kartal	...

Clasificación

Jornada 22

Equipo		PJ	GF	GC	Puntos
1	Kasımpaşa	20	40	20	40
2	Kartalspor	20	27	8	40
3	Pendikspor	20	27	18	35
4	İstanbul	20	31	20	34
5	Sariyer	20	27	25	33
6	Eyupspor	20	22	20	28
7	Fatih	20	22	18	25
8	Maltepespor	20	18	21	25
9	Kucukkoyspor	20	14	24	23
10	Kartal	20	16	36	17
11	Bagcilarspor	20	12	46	2

Equipos de esta liga

USO DE MEMORIA

5,418,592 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.0980
Total Execution Time	0.1001

CADENA URL

/2_lig_turquia2006/grupo1/calendario

GET DATOS

$_GET['/2_lig_turquia2006/grupo1/calendario']

POST DATOS

No hay datos POST existentes

CONSULTAS (14)

0.0023	SELECT type FROM routes WHERE alias = '2_lig_turquia2006'
0.0052	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_lig_turquia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0024	SELECT id,name,alias,stepParent FROM categories WHERE parentId=359 ORDER BY order_id ASC
0.0028	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 = 50677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0058	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 calendars2006 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 50677 ORDER BY round ASC
0.0024	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 23:42:54' 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-04-30 23:42:54' 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=4 AND last_update > '2024-04-30 23:42:54' 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=3 AND last_update > '2024-04-30 23:42:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0033	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2_lig_turquia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0030	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 events2006 e ON e.player_id = p.id AND e.league_id = 50677 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50677 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.0028	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 events2006 e ON e.player_id = p.id AND e.league_id = 50677 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50677 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025	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 events2006 e ON e.player_id = p.id AND e.league_id = 50677 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50677 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0075	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2006` 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 = 50677 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos