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

« Temporada Anterior

Temporada 2012

Temporada Siguiente »

2011/2012

segunda division usa, segunda division estados unidos, usl pro

USL Championship - USA 2012

Ver jornada

Jornada 1

06 Abr 12	Antigua	Antigua - Pittsburgh 2012-04-06T19:00:00 No disponible 0 - 1	Pittsburgh	...
07 Abr 12	Richmond	Richmond - Charleston 2012-04-07T17:00:00 City Stadium 1 - 2	Charleston	...
07 Abr 12	Charlotte	Charlotte - Orlando 2012-04-07T19:00:00 Charlotte Christian School 0 - 2	Orlando	...

Ver jornada

Jornada 2

14 Abr 12	Charlotte	Charlotte - Dayton 2012-04-14T01:00:00 Charlotte Christian School 0 - 0	Dayton	...
15 Abr 12	Charleston	Charleston - Richmond 2012-04-15T01:30:00 Patriots Point Soccer Stadium 1 - 2	Richmond	...
14 Abr 12	Orange	Orange - Rochester 2012-04-14T22:30:00 Champioship Soccer Stadium 0 - 1	Rochester	...
15 Abr 12	Orlando	Orlando - Wilmington 2012-04-15T18:00:00 Exploria Stadium 4 - 1	Wilmington	...
17 Abr 12	Charlotte	Charlotte - Charleston 2012-04-17T18:00:00 Charlotte Christian School 0 - 3	Charleston	...
08 Abr 12	Antigua	Antigua - Pittsburgh 2012-04-08T22:30:00 No disponible 3 - 1	Pittsburgh	...

Ver jornada

Jornada 3

21 Abr 12	Charlotte	Charlotte - Penn FC 2012-04-21T01:00:00 Charlotte Christian School 1 - 2	Penn FC	...
22 Abr 12	Richmond	Richmond - Orlando 2012-04-22T01:00:00 City Stadium 0 - 2	Orlando	...
21 Abr 12	Pittsburgh	Pittsburgh - Dayton 2012-04-21T19:00:00 Highmark Stadium 2 - 0	Dayton	...
21 Abr 12	Wilmington	Wilmington - Penn FC 2012-04-21T19:30:00 Legion Stadium 0 - 0	Penn FC	...
20 Abr 12	Orange	Orange - Rochester 2012-04-20T22:30:00 Champioship Soccer Stadium 0 - 2	Rochester	...
26 Abr 12	Antigua	Antigua - Charlotte 2012-04-26T20:00:00 No disponible 3 - 2	Charlotte	...

Ver jornada

Jornada 4

29 Abr 12	Antigua	Antigua - Charlotte 2012-04-29T01:00:00 No disponible 0 - 2	Charlotte	...
28 Abr 12	Charleston	Charleston - Pittsburgh 2012-04-28T01:30:00 Patriots Point Soccer Stadium 1 - 0	Pittsburgh	...
29 Abr 12	Wilmington	Wilmington - Pittsburgh 2012-04-29T01:30:00 Legion Stadium 1 - 0	Pittsburgh	...
28 Abr 12	Orlando	Orlando - Richmond 2012-04-28T19:30:00 Exploria Stadium 0 - 0	Richmond	...
28 Abr 12	Dayton	Dayton - Rochester 2012-04-28T19:30:00 No disponible 0 - 1	Rochester	...
05 May 12	Orange	Orange - Wilmington 2012-05-05T02:00:00 Champioship Soccer Stadium 2 - 2	Wilmington	...

Ver jornada

Jornada 5

03 May 12	Wilmington	Wilmington - Antigua 2012-05-03T01:00:00 Legion Stadium 3 - 0	Antigua	...
05 May 12	Penn FC	Penn FC - Charlotte 2012-05-05T01:00:00 FNB Field/Clipper Magazine Stadium 1 - 2	Charlotte	...
04 May 12	Charleston	Charleston - Antigua 2012-05-04T19:30:00 Patriots Point Soccer Stadium 4 - 0	Antigua	...
05 May 12	Rochester	Rochester - Charlotte 2012-05-05T19:05:00 Marina Auto Stadium 1 - 0	Charlotte	...
05 May 12	Orlando	Orlando - Pittsburgh 2012-05-05T19:30:00 Exploria Stadium 3 - 2	Pittsburgh	...
05 May 12	Dayton	Dayton - Richmond 2012-05-05T19:30:00 No disponible 1 - 1	Richmond	...
06 May 12	Orange	Orange - Wilmington 2012-05-06T20:00:00 Champioship Soccer Stadium 2 - 2	Wilmington	...
11 May 12	Antigua	Antigua - Orlando 2012-05-11T19:00:00 No disponible 0 - 1	Orlando	...

Ver jornada

Jornada 6

12 May 12	Dayton	Dayton - Orange 2012-05-12T01:30:00 No disponible 0 - 1	Orange	...
11 May 12	Charlotte	Charlotte - Rochester 2012-05-11T20:00:00 Charlotte Christian School 0 - 1	Rochester	...
12 May 12	Pittsburgh	Pittsburgh - Orange 2012-05-12T19:00:00 Highmark Stadium 0 - 3	Orange	...
12 May 12	Richmond	Richmond - Penn FC 2012-05-12T19:00:00 City Stadium 2 - 2	Penn FC	...
12 May 12	Charleston	Charleston - Rochester 2012-05-12T19:30:00 Patriots Point Soccer Stadium 0 - 1	Rochester	...
13 May 12	Antigua	Antigua - Orlando 2012-05-13T19:00:00 No disponible 1 - 2	Orlando	...
16 May 12	Penn FC	Penn FC - Pittsburgh 2012-05-16T19:00:00 FNB Field/Clipper Magazine Stadium 0 - 0	Pittsburgh	...

Ver jornada

Jornada 7

18 May 12	Pittsburgh	Pittsburgh - Richmond 2012-05-18T19:00:00 Highmark Stadium 1 - 1	Richmond	...
18 May 12	Rochester	Rochester - Dayton 2012-05-18T19:35:00 Marina Auto Stadium 1 - 1	Dayton	...
19 May 12	Penn FC	Penn FC - Dayton 2012-05-19T18:00:00 FNB Field/Clipper Magazine Stadium 4 - 0	Dayton	...
19 May 12	Wilmington	Wilmington - Charlotte 2012-05-19T19:30:00 Legion Stadium 1 - 1	Charlotte	...

Ver jornada

Jornada 8

25 May 12	Orlando	Orlando - Orange 2012-05-25T01:30:00 Exploria Stadium 1 - 1	Orange	...
26 May 12	Penn FC	Penn FC - Rochester 2012-05-26T00:00:00 FNB Field/Clipper Magazine Stadium 1 - 0	Rochester	...
26 May 12	Richmond	Richmond - Wilmington 2012-05-26T19:00:00 City Stadium 3 - 1	Wilmington	...
26 May 12	Orlando	Orlando - Charlotte 2012-05-26T19:30:00 Exploria Stadium 2 - 1	Charlotte	...
26 May 12	Dayton	Dayton - Rochester 2012-05-26T19:30:00 No disponible 2 - 2	Rochester	...
26 May 12	Charleston	Charleston - Orange 2012-05-26T19:30:00 Patriots Point Soccer Stadium 1 - 0	Orange	...

Ver jornada

Jornada 9

01 Jun 12	Pittsburgh	Pittsburgh - Charleston 2012-06-01T01:00:00 Highmark Stadium 1 - 3	Charleston	...
02 Jun 12	Penn FC	Penn FC - Richmond 2012-06-02T01:00:00 FNB Field/Clipper Magazine Stadium 1 - 1	Richmond	...
02 Jun 12	Rochester	Rochester - Richmond 2012-06-02T19:05:00 Marina Auto Stadium 0 - 1	Richmond	...
02 Jun 12	Wilmington	Wilmington - Orlando 2012-06-02T19:30:00 Legion Stadium 3 - 1	Orlando	...
02 Jun 12	Dayton	Dayton - Charleston 2012-06-02T20:00:00 No disponible 0 - 1	Charleston	...

Ver jornada

Jornada 10

09 Jun 12	Rochester	Rochester - Wilmington 2012-06-09T01:35:00 Marina Auto Stadium 1 - 1	Wilmington	...
10 Jun 12	Richmond	Richmond - Charlotte 2012-06-10T01:00:00 City Stadium 1 - 0	Charlotte	...
10 Jun 12	Penn FC	Penn FC - Wilmington 2012-06-10T01:00:00 FNB Field/Clipper Magazine Stadium 0 - 2	Wilmington	...
09 Jun 12	Orlando	Orlando - Charleston 2012-06-09T19:30:00 Exploria Stadium 2 - 1	Charleston	...
09 Jun 12	Dayton	Dayton - Pittsburgh 2012-06-09T20:00:00 No disponible 1 - 1	Pittsburgh	...
18 Jun 12	Orange	Orange - Dayton 2012-06-18T02:00:00 Champioship Soccer Stadium 1 - 0	Dayton	...

Ver jornada

Jornada 11

16 Jun 12	Penn FC	Penn FC - Rochester 2012-06-16T00:00:00 FNB Field/Clipper Magazine Stadium 2 - 1	Rochester	...
16 Jun 12	Wilmington	Wilmington - Richmond 2012-06-16T01:30:00 Legion Stadium 2 - 1	Richmond	...
16 Jun 12	Charlotte	Charlotte - Richmond 2012-06-16T20:00:00 Charlotte Christian School 4 - 1	Richmond	...
17 Jun 12	Pittsburgh	Pittsburgh - Rochester 2012-06-17T15:00:00 Highmark Stadium 1 - 1	Rochester	...
17 Jun 12	Orlando	Orlando - Antigua 2012-06-17T18:00:00 Exploria Stadium 2 - 0	Antigua	...
15 Jun 12	Orange	Orange - Dayton 2012-06-15T22:30:00 Champioship Soccer Stadium 1 - 0	Dayton	...

Ver jornada

Jornada 12

23 Jun 12	Pittsburgh	Pittsburgh - Wilmington 2012-06-23T01:00:00 Highmark Stadium 2 - 1	Wilmington	...
23 Jun 12	Orlando	Orlando - Penn FC 2012-06-23T01:35:00 Exploria Stadium 3 - 0	Penn FC	...
23 Jun 12	Richmond	Richmond - Rochester 2012-06-23T19:00:00 City Stadium 2 - 3	Rochester	...
23 Jun 12	Charleston	Charleston - Penn FC 2012-06-23T19:30:00 Patriots Point Soccer Stadium 3 - 1	Penn FC	...
23 Jun 12	Dayton	Dayton - Wilmington 2012-06-23T20:00:00 No disponible 4 - 0	Wilmington	...
30 Jun 12	Antigua	Antigua - Charleston 2012-06-30T01:00:00 No disponible 0 - 2	Charleston	...

Ver jornada

Jornada 13

29 Jun 12	Charlotte	Charlotte - Orange 2012-06-29T01:05:00 Charlotte Christian School 3 - 2	Orange	...
30 Jun 12	Dayton	Dayton - Orlando 2012-06-30T02:20:00 No disponible 2 - 2	Orlando	...
30 Jun 12	Pittsburgh	Pittsburgh - Orlando 2012-06-30T19:00:00 Highmark Stadium 1 - 1	Orlando	...
30 Jun 12	Rochester	Rochester - Penn FC 2012-06-30T19:05:00 Marina Auto Stadium 1 - 2	Penn FC	...
30 Jun 12	Wilmington	Wilmington - Orange 2012-06-30T19:30:00 Legion Stadium 4 - 2	Orange	...
01 Jul 12	Antigua	Antigua - Charleston 2012-07-01T19:00:00 No disponible 1 - 0	Charleston	...

Ver jornada

Jornada 14

04 Jul 12	Richmond	Richmond - Orange 2012-07-04T01:00:00 City Stadium 1 - 0	Orange	...
04 Jul 12	Dayton	Dayton - Pittsburgh 2012-07-04T02:00:00 No disponible 1 - 0	Pittsburgh	...
04 Jul 12	Rochester	Rochester - Antigua 2012-07-04T19:55:00 Marina Auto Stadium 4 - 1	Antigua	...
09 Jul 12	Orange	Orange - Orlando 2012-07-09T02:02:00 Champioship Soccer Stadium 0 - 4	Orlando	...

Ver jornada

Jornada 15

06 Jul 12	Pittsburgh	Pittsburgh - Penn FC 2012-07-06T01:00:00 Highmark Stadium 2 - 3	Penn FC	...
07 Jul 12	Charleston	Charleston - Charlotte 2012-07-07T01:30:00 Patriots Point Soccer Stadium 0 - 2	Charlotte	...
08 Jul 12	Rochester	Rochester - Dayton 2012-07-08T01:05:00 Marina Auto Stadium 2 - 0	Dayton	...
08 Jul 12	Wilmington	Wilmington - Richmond 2012-07-08T01:30:00 Legion Stadium 1 - 0	Richmond	...
07 Jul 12	Charlotte	Charlotte - Charleston 2012-07-07T20:00:00 Charlotte Christian School 1 - 0	Charleston	...
07 Jul 12	Penn FC	Penn FC - Antigua 2012-07-07T20:00:00 FNB Field/Clipper Magazine Stadium 1 - 1	Antigua	...
06 Jul 12	Orange	Orange - Orlando 2012-07-06T22:30:00 Champioship Soccer Stadium 0 - 1	Orlando	...
12 Jul 12	Antigua	Antigua - Orange 2012-07-12T16:00:00 No disponible 0 - 3	Orange	...

Ver jornada

Jornada 16

13 Jul 12	Wilmington	Wilmington - Rochester 2012-07-13T01:40:00 Legion Stadium 0 - 0	Rochester	...
14 Jul 12	Antigua	Antigua - Orange 2012-07-14T16:30:00 No disponible 0 - 2	Orange	...
14 Jul 12	Penn FC	Penn FC - Dayton 2012-07-14T00:08:00 FNB Field/Clipper Magazine Stadium 0 - 0	Dayton	...
13 Jul 12	Richmond	Richmond - Pittsburgh 2012-07-13T19:00:00 City Stadium 3 - 1	Pittsburgh	...
14 Jul 12	Orlando	Orlando - Rochester 2012-07-14T19:30:00 Exploria Stadium 4 - 0	Rochester	...
14 Jul 12	Charleston	Charleston - Wilmington 2012-07-14T19:30:00 Patriots Point Soccer Stadium 3 - 1	Wilmington	...
14 Jul 12	Charlotte	Charlotte - Pittsburgh 2012-07-14T20:00:00 Charlotte Christian School 2 - 0	Pittsburgh	...

Ver jornada

Jornada 17

19 Jul 12	Dayton	Dayton - Penn FC 2012-07-19T01:30:00 No disponible 2 - 1	Penn FC	...
19 Jul 12	Charleston	Charleston - Orlando 2012-07-19T19:30:00 Patriots Point Soccer Stadium 1 - 2	Orlando	...
20 Jul 12	Pittsburgh	Pittsburgh - Penn FC 2012-07-20T19:00:00 Highmark Stadium 0 - 2	Penn FC	...
20 Jul 12	Wilmington	Wilmington - Dayton 2012-07-20T19:30:00 Legion Stadium 2 - 0	Dayton	...
21 Jul 12	Richmond	Richmond - Dayton 2012-07-21T19:00:00 City Stadium 2 - 0	Dayton	...
21 Jul 12	Rochester	Rochester - Pittsburgh 2012-07-21T19:05:00 Marina Auto Stadium 2 - 0	Pittsburgh	...
25 Jul 12	Orlando	Orlando - Wilmington 2012-07-25T19:30:00 Exploria Stadium 1 - 1	Wilmington	...

Ver jornada

Jornada 18

27 Jul 12	Pittsburgh	Pittsburgh - Antigua 2012-07-27T19:00:00 Highmark Stadium 4 - 1	Antigua	...
27 Jul 12	Orlando	Orlando - Charleston 2012-07-27T19:30:00 Exploria Stadium 4 - 0	Charleston	...
27 Jul 12	Rochester	Rochester - Orange 2012-07-27T19:35:00 Marina Auto Stadium 1 - 0	Orange	...
27 Jul 12	Charlotte	Charlotte - Richmond 2012-07-27T19:00:00 Charlotte Christian School 1 - 0	Richmond	...
28 Jul 12	Richmond	Richmond - Charlotte 2012-07-28T19:00:00 City Stadium 2 - 1	Charlotte	...
28 Jul 12	Penn FC	Penn FC - Orange 2012-07-28T19:00:00 FNB Field/Clipper Magazine Stadium 2 - 0	Orange	...
30 Jul 12	Dayton	Dayton - Antigua 2012-07-30T01:30:00 No disponible 3 - 1	Antigua	...
31 Jul 12	Pittsburgh	Pittsburgh - Orange 2012-07-31T19:00:00 Highmark Stadium 0 - 2	Orange	...

Ver jornada

Jornada 19

01 Ago 12	Penn FC	Penn FC - Orlando 2012-08-01T19:00:00 FNB Field/Clipper Magazine Stadium 2 - 4	Orlando	...
03 Ago 12	Richmond	Richmond - Antigua 2012-08-03T19:00:00 City Stadium 2 - 0	Antigua	...
03 Ago 12	Charleston	Charleston - Wilmington 2012-08-03T19:30:00 Patriots Point Soccer Stadium 2 - 2	Wilmington	...
03 Ago 12	Rochester	Rochester - Orlando 2012-08-03T19:35:00 Marina Auto Stadium 0 - 1	Orlando	...
05 Ago 12	Charlotte	Charlotte - Antigua 2012-08-05T01:00:00 Charlotte Christian School 4 - 0	Antigua	...
05 Ago 12	Wilmington	Wilmington - Charleston 2012-08-05T01:30:00 Legion Stadium 2 - 1	Charleston	...

Ver jornada

Jornada 20

08 Ago 12	Penn FC	Penn FC - Charleston 2012-08-08T19:00:00 FNB Field/Clipper Magazine Stadium 3 - 0	Charleston	...
11 Ago 12	Orange	Orange - Antigua 2012-08-11T22:30:00 Champioship Soccer Stadium 1 - 2	Antigua	...
10 Ago 12	Pittsburgh	Pittsburgh - Charlotte 2012-08-10T19:00:00 Highmark Stadium 0 - 3	Charlotte	...
11 Ago 12	Richmond	Richmond - Penn FC 2012-08-11T19:00:00 City Stadium 2 - 2	Penn FC	...
12 Ago 12	Rochester	Rochester - Charleston 2012-08-12T01:05:00 Marina Auto Stadium 0 - 4	Charleston	...
12 Ago 12	Dayton	Dayton - Charlotte 2012-08-12T01:30:00 No disponible 2 - 2	Charlotte	...
17 Ago 12	Orange	Orange - Penn FC 2012-08-17T19:00:00 Champioship Soccer Stadium 2 - 2	Penn FC	...
17 Ago 12	Antigua	Antigua - Richmond 2012-08-17T19:00:00 No disponible 2 - 1	Richmond	...

Ver jornada

Jornada 21

11 Ago 12	Orange	Orange - Antigua 2012-08-11T22:30:00 Champioship Soccer Stadium 1 - 0	Antigua	...
17 Ago 12	Orlando	Orlando - Dayton 2012-08-17T19:30:00 Exploria Stadium 1 - 1	Dayton	...
19 Ago 12	Rochester	Rochester - Pittsburgh 2012-08-19T01:05:00 Marina Auto Stadium 1 - 0	Pittsburgh	...
19 Ago 12	Charleston	Charleston - Dayton 2012-08-19T01:30:00 Patriots Point Soccer Stadium 0 - 0	Dayton	...
18 Ago 12	Wilmington	Wilmington - Charlotte 2012-08-18T01:30:00 Legion Stadium 0 - 1	Charlotte	...
19 Ago 12	Antigua	Antigua - Richmond 2012-08-19T01:00:00 No disponible 0 - 1	Richmond	...
20 Ago 12	Charlotte	Charlotte - Wilmington 2012-08-20T01:00:00 Charlotte Christian School 1 - 2	Wilmington	...
19 Ago 12	Orange	Orange - Penn FC 2012-08-19T01:00:00 Champioship Soccer Stadium 0 - 1	Penn FC	...

JUGADORES DESTACADOS

Nombre	Goles	Equipo
D. Chin	11	ORL
C. Hertzog	9	WIL
M. Luzunaris	9	ORL
Andriy Budnyi	8	WIL
N. Paterson	8	CHA
L. Mkosana	7	PNN
A. Hoxie	6	ROC
C. Agorsor	6	RIC
B. Dike	6	ORA
M. Kassel	6	PIT

Clasificación

Jornada 21

Equipo		PJ	GF	GC	Puntos
1	Orlando City	24	50	18	57
2	Rochester	24	27	23	41
3	Penn FC	24	35	29	38
4	Wilmington	24	35	32	38
5	Charlotte	24	34	26	36
6	Richmond	24	31	28	36
7	Charleston	23	33	26	35
8	Orange	24	26	30	28
9	Dayton Dutch	24	20	29	22
10	Pittsburgh	24	20	39	17
11	Antigua	23	16	47	16

Equipos de esta liga

USO DE MEMORIA

5,702,864 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.3657
Total Execution Time	0.3676

CADENA URL

/usl_pro_usa2012/grupo1/calendario

GET DATOS

$_GET['/usl_pro_usa2012/grupo1/calendario']

POST DATOS

No hay datos POST existentes

CONSULTAS (13)

0.0125	SELECT type FROM routes WHERE alias = 'usl_pro_usa2012'
0.0259	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usl_pro_usa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129	SELECT id,name,alias,stepParent FROM categories WHERE parentId=1666 ORDER BY order_id ASC
0.0166	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 calendars2012 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 14045 ORDER BY round ASC
0.0128	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 09:06:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 09:06:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 09:06:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 09:06:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0138	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usl_pro_usa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0354	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 events2012 e ON e.player_id = p.id AND e.league_id = 14045 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14045 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.0427	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 events2012 e ON e.player_id = p.id AND e.league_id = 14045 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14045 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134	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 events2012 e ON e.player_id = p.id AND e.league_id = 14045 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14045 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0141	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2012` 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 = 14045 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nombre	Rojas	Equipo
M. Galindo	2	ORA
K. Hoffer	2	CHA
A. Welker	1	PNN
C. Chijindu	1	WIL
L. George-Blakely	1	ANT
M. Kassel	1	PIT
G. Dublin	1	ANT
A. Mbengue	1	ORL
E. García	1	ORA
H. Kalungi	1	RIC

Nombre	Amarillas	Equipo
N. Katić	10	PIT
Allan Russell	8	ORA
M. Copier	7	DAY
A. Welker	6	PNN
G. Evans	6	WIL
M. Seth	6	PIT
D. Riley	6	WIL
T. Cole	5	WIL
Marshall	5	PNN
G. Pettis	5	PNN