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 2002

Temporada Siguiente »

2001/2002

2. Lig 2002 G 1

2. Lig - Play Offs Ascenso

Ver jornada

Jornada 1

19 Ago 01	Sapancaspor	Sapancaspor - Kartalspor 2001-08-19T16:00:00 No disponible 0 - 3	Kartalspor	...
19 Ago 01	Mersin	Mersin - Eskişehirs 2001-08-19T16:00:00 No disponible 1 - 1	Eskişehirs	...
19 Ago 01	Maltepespor	Maltepespor - Kartal 2001-08-19T16:00:00 No disponible 2 - 2	Kartal	...
19 Ago 01	Kucukkoyspo	Kucukkoyspo - Zeytinburnu 2001-08-19T16:00:00 No disponible 3 - 2	Zeytinburnu	...
19 Ago 01	Gaziantep	Gaziantep - Mezitlispor 2001-08-19T16:00:00 Kamil Ocak Stadyumu 2 - 0	Mezitlispor	...

Ver jornada

Jornada 2

25 Ago 01	Kartalspor	Kartalspor - Gaziantep 2001-08-25T16:00:00 Radyo Seymen Kartal Stadı 0 - 0	Gaziantep	...
26 Ago 01	Zeytinburnu	Zeytinburnu - Mersin 2001-08-26T16:00:00 No disponible 1 - 1	Mersin	...
26 Ago 01	Mezitlispor	Mezitlispor - Kucukkoyspo 2001-08-26T16:00:00 No disponible 2 - 2	Kucukkoyspo	...
26 Ago 01	Kartal	Kartal - Sapancaspor 2001-08-26T16:00:00 No disponible 0 - 0	Sapancaspor	...
26 Ago 01	Eskişehirs	Eskişehirs - Maltepespor 2001-08-26T18:00:00 Eskişehir Atatürk Stadyumu 3 - 2	Maltepespor	...

Ver jornada

Jornada 3

02 Sep 01	Mersin	Mersin - Mezitlispor 2001-09-02T15:00:00 No disponible 4 - 1	Mezitlispor	...
02 Sep 01	Gaziantep	Gaziantep - Sapancaspor 2001-09-02T15:00:00 Kamil Ocak Stadyumu 4 - 2	Sapancaspor	...
02 Sep 01	Maltepespor	Maltepespor - Zeytinburnu 2001-09-02T15:30:00 No disponible 6 - 1	Zeytinburnu	...
02 Sep 01	Kucukkoyspo	Kucukkoyspo - Kartalspor 2001-09-02T15:30:00 No disponible 1 - 1	Kartalspor	...
02 Sep 01	Eskişehirs	Eskişehirs - Kartal 2001-09-02T18:00:00 Eskişehir Atatürk Stadyumu 2 - 2	Kartal	...

Ver jornada

Jornada 4

09 Sep 01	Mezitlispor	Mezitlispor - Maltepespor 2001-09-09T15:00:00 No disponible 6 - 2	Maltepespor	...
09 Sep 01	Zeytinburnu	Zeytinburnu - Eskişehirs 2001-09-09T15:30:00 No disponible 1 - 2	Eskişehirs	...
09 Sep 01	Sapancaspor	Sapancaspor - Kucukkoyspo 2001-09-09T15:30:00 No disponible 4 - 2	Kucukkoyspo	...
09 Sep 01	Kartalspor	Kartalspor - Mersin 2001-09-09T15:30:00 Radyo Seymen Kartal Stadı 1 - 3	Mersin	...
09 Sep 01	Kartal	Kartal - Gaziantep 2001-09-09T15:30:00 No disponible 1 - 1	Gaziantep	...

Ver jornada

Jornada 5

16 Sep 01	Mersin	Mersin - Sapancaspor 2001-09-16T15:00:00 No disponible 0 - 0	Sapancaspor	...
16 Sep 01	Zeytinburnu	Zeytinburnu - Kartal 2001-09-16T15:30:00 No disponible 1 - 0	Kartal	...
16 Sep 01	Maltepespor	Maltepespor - Kartalspor 2001-09-16T15:30:00 No disponible 1 - 0	Kartalspor	...
16 Sep 01	Kucukkoyspo	Kucukkoyspo - Gaziantep 2001-09-16T15:30:00 No disponible 0 - 4	Gaziantep	...
16 Sep 01	Eskişehirs	Eskişehirs - Mezitlispor 2001-09-16T18:00:00 Eskişehir Atatürk Stadyumu 1 - 0	Mezitlispor	...

Ver jornada

Jornada 6

23 Sep 01	Mezitlispor	Mezitlispor - Zeytinburnu 2001-09-23T15:00:00 No disponible 2 - 0	Zeytinburnu	...
23 Sep 01	Gaziantep	Gaziantep - Mersin 2001-09-23T15:00:00 Kamil Ocak Stadyumu 2 - 3	Mersin	...
23 Sep 01	Sapancaspor	Sapancaspor - Maltepespor 2001-09-23T15:30:00 No disponible 2 - 3	Maltepespor	...
23 Sep 01	Kartalspor	Kartalspor - Eskişehirs 2001-09-23T15:30:00 Radyo Seymen Kartal Stadı 0 - 0	Eskişehirs	...
23 Sep 01	Kartal	Kartal - Kucukkoyspo 2001-09-23T15:30:00 No disponible 5 - 2	Kucukkoyspo	...

Ver jornada

Jornada 7

30 Sep 01	Mersin	Mersin - Kucukkoyspo 2001-09-30T14:00:00 No disponible 7 - 0	Kucukkoyspo	...
30 Sep 01	Zeytinburnu	Zeytinburnu - Kartalspor 2001-09-30T14:30:00 No disponible 1 - 1	Kartalspor	...
30 Sep 01	Maltepespor	Maltepespor - Gaziantep 2001-09-30T14:30:00 No disponible 2 - 1	Gaziantep	...
30 Sep 01	Kartal	Kartal - Mezitlispor 2001-09-30T14:30:00 No disponible 1 - 1	Mezitlispor	...
30 Sep 01	Eskişehirs	Eskişehirs - Sapancaspor 2001-09-30T18:00:00 Eskişehir Atatürk Stadyumu 1 - 0	Sapancaspor	...

Ver jornada

Jornada 8

06 Oct 01	Gaziantep	Gaziantep - Eskişehirs 2001-10-06T14:00:00 Kamil Ocak Stadyumu 0 - 0	Eskişehirs	...
07 Oct 01	Mersin	Mersin - Kartal 2001-10-07T14:00:00 No disponible 2 - 0	Kartal	...
07 Oct 01	Sapancaspor	Sapancaspor - Zeytinburnu 2001-10-07T14:30:00 No disponible 2 - 1	Zeytinburnu	...
07 Oct 01	Kucukkoyspo	Kucukkoyspo - Maltepespor 2001-10-07T14:30:00 No disponible 1 - 1	Maltepespor	...
07 Oct 01	Kartalspor	Kartalspor - Mezitlispor 2001-10-07T14:30:00 Radyo Seymen Kartal Stadı 3 - 1	Mezitlispor	...

Ver jornada

Jornada 9

14 Oct 01	Mezitlispor	Mezitlispor - Sapancaspor 2001-10-14T14:00:00 No disponible 5 - 0	Sapancaspor	...
14 Oct 01	Eskişehirs	Eskişehirs - Kucukkoyspo 2001-10-14T14:00:00 Eskişehir Atatürk Stadyumu 1 - 0	Kucukkoyspo	...
14 Oct 01	Zeytinburnu	Zeytinburnu - Gaziantep 2001-10-14T14:30:00 No disponible 0 - 1	Gaziantep	...
14 Oct 01	Maltepespor	Maltepespor - Mersin 2001-10-14T14:30:00 No disponible 1 - 1	Mersin	...
14 Oct 01	Kartal	Kartal - Kartalspor 2001-10-14T14:30:00 No disponible 1 - 1	Kartalspor	...

Ver jornada

Jornada 10

20 Oct 01	Zeytinburnu	Zeytinburnu - Kucukkoyspo 2001-10-20T14:30:00 No disponible 2 - 2	Kucukkoyspo	...
20 Oct 01	Kartal	Kartal - Maltepespor 2001-10-20T14:30:00 No disponible 2 - 0	Maltepespor	...
21 Oct 01	Mezitlispor	Mezitlispor - Gaziantep 2001-10-21T14:00:00 No disponible 0 - 3	Gaziantep	...
21 Oct 01	Eskişehirs	Eskişehirs - Mersin 2001-10-21T14:00:00 Eskişehir Atatürk Stadyumu 1 - 0	Mersin	...
21 Oct 01	Kartalspor	Kartalspor - Sapancaspor 2001-10-21T14:30:00 Radyo Seymen Kartal Stadı 3 - 0	Sapancaspor	...

Ver jornada

Jornada 11

27 Oct 01	Sapancaspor	Sapancaspor - Kartal 2001-10-27T12:30:00 No disponible 0 - 0	Kartal	...
28 Oct 01	Mersin	Mersin - Zeytinburnu 2001-10-28T12:30:00 No disponible 2 - 1	Zeytinburnu	...
28 Oct 01	Maltepespor	Maltepespor - Eskişehirs 2001-10-28T12:30:00 No disponible 3 - 2	Eskişehirs	...
28 Oct 01	Kucukkoyspo	Kucukkoyspo - Mezitlispor 2001-10-28T12:30:00 No disponible 1 - 2	Mezitlispor	...
28 Oct 01	Gaziantep	Gaziantep - Kartalspor 2001-10-28T12:30:00 Kamil Ocak Stadyumu 4 - 2	Kartalspor	...

Ver jornada

Jornada 12

03 Nov 01	Zeytinburnu	Zeytinburnu - Maltepespor 2001-11-03T12:30:00 No disponible 1 - 0	Maltepespor	...
03 Nov 01	Kartal	Kartal - Eskişehirs 2001-11-03T12:30:00 No disponible 2 - 1	Eskişehirs	...
04 Nov 01	Sapancaspor	Sapancaspor - Gaziantep 2001-11-04T12:30:00 No disponible 1 - 1	Gaziantep	...
04 Nov 01	Mezitlispor	Mezitlispor - Mersin 2001-11-04T12:30:00 No disponible 1 - 1	Mersin	...
04 Nov 01	Kartalspor	Kartalspor - Kucukkoyspo 2001-11-04T12:30:00 Radyo Seymen Kartal Stadı 2 - 1	Kucukkoyspo	...

Ver jornada

Jornada 13

11 Nov 01	Mersin	Mersin - Kartalspor 2001-11-11T12:30:00 No disponible 3 - 1	Kartalspor	...
11 Nov 01	Maltepespor	Maltepespor - Mezitlispor 2001-11-11T12:30:00 No disponible 2 - 2	Mezitlispor	...
11 Nov 01	Kucukkoyspo	Kucukkoyspo - Sapancaspor 2001-11-11T12:30:00 No disponible 0 - 0	Sapancaspor	...
11 Nov 01	Eskişehirs	Eskişehirs - Zeytinburnu 2001-11-11T12:30:00 Eskişehir Atatürk Stadyumu 1 - 0	Zeytinburnu	...
11 Nov 01	Gaziantep	Gaziantep - Kartal 2001-11-11T12:30:00 Kamil Ocak Stadyumu 5 - 2	Kartal	...

Ver jornada

Jornada 14

17 Nov 01	Kartal	Kartal - Zeytinburnu 2001-11-17T12:30:00 No disponible 2 - 2	Zeytinburnu	...
18 Nov 01	Sapancaspor	Sapancaspor - Mersin 2001-11-18T12:30:00 No disponible 0 - 2	Mersin	...
18 Nov 01	Mezitlispor	Mezitlispor - Eskişehirs 2001-11-18T12:30:00 No disponible 2 - 1	Eskişehirs	...
18 Nov 01	Kartalspor	Kartalspor - Maltepespor 2001-11-18T12:30:00 Radyo Seymen Kartal Stadı 3 - 0	Maltepespor	...
18 Nov 01	Gaziantep	Gaziantep - Kucukkoyspo 2001-11-18T12:30:00 Kamil Ocak Stadyumu 3 - 0	Kucukkoyspo	...

Ver jornada

Jornada 15

25 Nov 01	Zeytinburnu	Zeytinburnu - Mezitlispor 2001-11-25T12:30:00 No disponible 1 - 2	Mezitlispor	...
25 Nov 01	Mersin	Mersin - Gaziantep 2001-11-25T12:30:00 No disponible 1 - 0	Gaziantep	...
25 Nov 01	Maltepespor	Maltepespor - Sapancaspor 2001-11-25T12:30:00 No disponible 1 - 1	Sapancaspor	...
25 Nov 01	Kucukkoyspo	Kucukkoyspo - Kartal 2001-11-25T12:30:00 No disponible 1 - 0	Kartal	...
25 Nov 01	Eskişehirs	Eskişehirs - Kartalspor 2001-11-25T12:30:00 Eskişehir Atatürk Stadyumu 0 - 3	Kartalspor	...

Ver jornada

Jornada 16

02 Dic 01	Sapancaspor	Sapancaspor - Eskişehirs 2001-12-02T12:30:00 No disponible 0 - 0	Eskişehirs	...
02 Dic 01	Kucukkoyspo	Kucukkoyspo - Mersin 2001-12-02T12:30:00 No disponible 3 - 0	Mersin	...
02 Dic 01	Kartalspor	Kartalspor - Zeytinburnu 2001-12-02T12:30:00 Radyo Seymen Kartal Stadı 3 - 2	Zeytinburnu	...
02 Dic 01	Gaziantep	Gaziantep - Maltepespor 2001-12-02T12:30:00 Kamil Ocak Stadyumu 1 - 1	Maltepespor	...
09 Dic 01	Zeytinburnu	Zeytinburnu - Sapancaspor 2001-12-09T12:30:00 No disponible 3 - 2	Sapancaspor	...

Ver jornada

Jornada 17

09 Dic 01	Eskişehirs	Eskişehirs - Gaziantep 2001-12-09T12:30:00 Eskişehir Atatürk Stadyumu 2 - 1	Gaziantep	...
09 Dic 01	Maltepespor	Maltepespor - Kucukkoyspo 2001-12-09T12:30:00 No disponible 1 - 3	Kucukkoyspo	...
16 Dic 01	Mersin	Mersin - Maltepespor 2001-12-16T12:30:00 No disponible 3 - 1	Maltepespor	...
16 Dic 01	Kartalspor	Kartalspor - Kartal 2001-12-16T12:30:00 Radyo Seymen Kartal Stadı 4 - 0	Kartal	...
16 Dic 01	Sapancaspor	Sapancaspor - Mezitlispor 2001-12-16T12:30:00 No disponible 3 - 1	Mezitlispor	...

Ver jornada

Jornada 18

16 Dic 01	Gaziantep	Gaziantep - Zeytinburnu 2001-12-16T12:30:00 Kamil Ocak Stadyumu 2 - 0	Zeytinburnu	...
19 Dic 01	Mezitlispor	Mezitlispor - Kartal 2001-12-19T12:30:00 No disponible 0 - 4	Kartal	...
23 Dic 01	Mezitlispor	Mezitlispor - Kartalspor 2001-12-23T12:30:00 No disponible 0 - 1	Kartalspor	...
23 Dic 01	Kucukkoyspo	Kucukkoyspo - Eskişehirs 2001-12-23T12:30:00 No disponible 3 - 3	Eskişehirs	...

Clasificación

Jornada 18

Equipo		PJ	GF	GC	Puntos
1	Mersin	17	34	15	35
2	Gaziantep	18	35	17	32
3	Kartalspor	18	32	18	32
4	Eskişehirsp	18	22	20	30
5	Mezitlispor	18	28	32	22
6	Maltepespor	18	29	35	21
7	Kartal	17	24	25	20
8	Kucukkoyspor	18	25	40	18
9	Sapancaspor	18	17	30	16
10	Zeytinburnus	18	20	34	13

Equipos de esta liga

USO DE MEMORIA

5,233,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.0801
Total Execution Time	0.0820

CADENA URL

/2_lig_turquia2002/grupo1/calendario

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (14)

0.0017	SELECT type FROM routes WHERE alias = '2_lig_turquia2002'
0.0040	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 = 2002 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=359 ORDER BY order_id ASC
0.0019	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 = 50698 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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 calendars2002 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 50698 ORDER BY round ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 20:53:45' 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=2 AND last_update > '2024-05-02 20:53:45' 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-02 20:53:45' 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-02 20:53:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	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 = 2002 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 events2002 e ON e.player_id = p.id AND e.league_id = 50698 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50698 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.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 events2002 e ON e.player_id = p.id AND e.league_id = 50698 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50698 AND (e.action = 4 or e.action = 5) 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 events2002 e ON e.player_id = p.id AND e.league_id = 50698 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50698 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2002` 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 = 50698 AND t.round = 18 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