4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
12 Oct 19 Benisa ABenisa A 1 - 3 SPA Alicante CAlicante ...
13 Oct 19 Bonavista ABonavista 0 - 1 Elda Promesas AElda ...
13 Oct 19 Crevillente FemeninoCrevillente 3 - 2 El CampelloCampello ...
13 Oct 19 RojalesRojales 3 - 1 Elche CElche C ...
12 Oct 19 Sport Base Ontinyent ASport Base 2 - 1 Atco Aspe BAtco Aspe ...
12 Oct 19 Elche B FemElche 5 - 0 Cff UryulaCff Uryula ...
16 Oct 19 Bahia Santa Pola ABahia Santa 1 - 2 La Nucia ALa Nucia A ...
Ver jornada
Jornada 2
19 Oct 19 SPA Alicante CAlicante 5 - 1 Crevillente FemeninoCrevillente ...
20 Oct 19 Elda Promesas AElda 3 - 0 Benisa ABenisa A ...
19 Oct 19 El CampelloCampello 0 - 3 RojalesRojales ...
19 Oct 19 Elche CElche C 1 - 2 Elche B FemElche ...
20 Oct 19 Atco Aspe BAtco Aspe 0 - 4 Bahia Santa Pola ABahia Santa ...
19 Oct 19 Cff UryulaCff Uryula 2 - 3 Sport Base Ontinyent ASport Base ...
20 Oct 19 La Nucia ALa Nucia A 3 - 2 Bonavista ABonavista ...
Ver jornada
Jornada 3
27 Oct 19 Crevillente FemeninoCrevillente 0 - 4 Elda Promesas AElda ...
27 Oct 19 Bonavista ABonavista 2 - 0 Benisa ABenisa A ...
26 Oct 19 RojalesRojales 5 - 0 SPA Alicante CAlicante ...
26 Oct 19 Elche B FemElche 9 - 0 El CampelloCampello ...
27 Oct 19 Bahia Santa Pola ABahia Santa 6 - 1 Cff UryulaCff Uryula ...
27 Oct 19 Sport Base Ontinyent ASport Base 0 - 4 Elche CElche C ...
26 Oct 19 La Nucia ALa Nucia A 4 - 0 Atco Aspe BAtco Aspe ...
Ver jornada
Jornada 4
03 Nov 19 Elda Promesas AElda 4 - 1 RojalesRojales ...
02 Nov 19 Benisa ABenisa A 4 - 1 Crevillente FemeninoCrevillente ...
02 Nov 19 SPA Alicante CAlicante 0 - 10 Elche B FemElche ...
02 Nov 19 El CampelloCampello 2 - 0 Sport Base Ontinyent ASport Base ...
02 Nov 19 Cff UryulaCff Uryula 0 - 1 La Nucia ALa Nucia A ...
02 Nov 19 Elche CElche C 2 - 1 Bahia Santa Pola ABahia Santa ...
03 Nov 19 Atco Aspe BAtco Aspe 0 - 2 Bonavista ABonavista ...
Ver jornada
Jornada 5
10 Nov 19 RojalesRojales 3 - 0 Benisa ABenisa A ...
10 Nov 19 Bonavista ABonavista 1 - 2 Crevillente FemeninoCrevillente ...
09 Nov 19 Elche B FemElche 2 - 0 Elda Promesas AElda ...
09 Nov 19 Sport Base Ontinyent ASport Base 0 - 2 SPA Alicante CAlicante ...
09 Nov 19 La Nucia ALa Nucia A 5 - 0 Elche CElche C ...
09 Nov 19 Bahia Santa Pola ABahia Santa 3 - 0 El CampelloCampello ...
10 Nov 19 Atco Aspe BAtco Aspe 1 - 3 Cff UryulaCff Uryula ...
Ver jornada
Jornada 6
17 Nov 19 Benisa ABenisa A 1 - 4 Elche B FemElche ...
17 Nov 19 Crevillente FemeninoCrevillente 0 - 0 RojalesRojales ...
17 Nov 19 Elda Promesas AElda 2 - 2 Sport Base Ontinyent ASport Base ...
17 Nov 19 SPA Alicante CAlicante 1 - 5 Bahia Santa Pola ABahia Santa ...
16 Nov 19 Elche CElche C 2 - 1 Atco Aspe BAtco Aspe ...
17 Nov 19 El CampelloCampello 0 - 10 La Nucia ALa Nucia A ...
17 Nov 19 Cff UryulaCff Uryula 2 - 0 Bonavista ABonavista ...
Ver jornada
Jornada 7
23 Nov 19 Elche B FemElche 1 - 0 Crevillente FemeninoCrevillente ...
23 Nov 19 Bonavista ABonavista 0 - 6 RojalesRojales ...
23 Nov 19 Sport Base Ontinyent ASport Base 2 - 4 Benisa ABenisa A ...
23 Nov 19 Bahia Santa Pola ABahia Santa 1 - 2 Elda Promesas AElda ...
23 Nov 19 Atco Aspe BAtco Aspe 5 - 2 El CampelloCampello ...
23 Nov 19 La Nucia ALa Nucia A 3 - 0 SPA Alicante CAlicante ...
23 Nov 19 Cff UryulaCff Uryula 0 - 5 Elche CElche C ...
Ver jornada
Jornada 8
01 Dic 19 Crevillente FemeninoCrevillente 4 - 1 Sport Base Ontinyent ASport Base ...
01 Dic 19 RojalesRojales 1 - 2 Elche B FemElche ...
30 Nov 19 Benisa ABenisa A 1 - 4 Bahia Santa Pola ABahia Santa ...
01 Dic 19 Elda Promesas AElda 2 - 2 La Nucia ALa Nucia A ...
01 Dic 19 El CampelloCampello 1 - 3 Cff UryulaCff Uryula ...
30 Nov 19 SPA Alicante CAlicante 1 - 4 Atco Aspe BAtco Aspe ...
01 Dic 19 Elche CElche C 2 - 0 Bonavista ABonavista ...
Ver jornada
Jornada 9
07 Dic 19 Sport Base Ontinyent ASport Base 0 - 2 RojalesRojales ...
09 Dic 19 Bonavista ABonavista 0 - 3 Elche B FemElche ...
07 Dic 19 Bahia Santa Pola ABahia Santa 1 - 0 Crevillente FemeninoCrevillente ...
06 Dic 19 La Nucia ALa Nucia A 8 - 2 Benisa ABenisa A ...
08 Dic 19 Cff UryulaCff Uryula 4 - 2 SPA Alicante CAlicante ...
07 Dic 19 Atco Aspe BAtco Aspe 2 - 5 Elda Promesas AElda ...
07 Dic 19 Elche CElche C 8 - 1 El CampelloCampello ...
Ver jornada
Jornada 10
14 Dic 19 RojalesRojales 0 - 1 Bahia Santa Pola ABahia Santa ...
14 Dic 19 Elche B FemElche 12 - 1 Sport Base Ontinyent ASport Base ...
15 Dic 19 Crevillente FemeninoCrevillente 2 - 5 La Nucia ALa Nucia A ...
15 Dic 19 Benisa ABenisa A 0 - 0 Atco Aspe BAtco Aspe ...
14 Dic 19 SPA Alicante CAlicante 1 - 1 Elche CElche C ...
15 Dic 19 Elda Promesas AElda 3 - 3 Cff UryulaCff Uryula ...
15 Dic 19 El CampelloCampello 0 - 3 Bonavista ABonavista ...
Ver jornada
Jornada 11
11 Ene 20 Bahia Santa Pola ABahia Santa 2 - 5 Elche B FemElche ...
11 Ene 20 Bonavista ABonavista 2 - 0 Sport Base Ontinyent ASport Base ...
11 Ene 20 La Nucia ALa Nucia A 5 - 3 RojalesRojales ...
11 Ene 20 Atco Aspe BAtco Aspe 3 - 2 Crevillente FemeninoCrevillente ...
11 Ene 20 Elche CElche C 0 - 3 Elda Promesas AElda ...
11 Ene 20 Cff UryulaCff Uryula 4 - 1 Benisa ABenisa A ...
12 Ene 20 El CampelloCampello 3 - 2 SPA Alicante CAlicante ...
Ver jornada
Jornada 12
18 Ene 20 Elche B FemElche 2 - 0 La Nucia ALa Nucia A ...
14 Feb 20 Sport Base Ontinyent ASport Base 1 - 2 Bahia Santa Pola ABahia Santa ...
18 Ene 20 RojalesRojales 4 - 3 Atco Aspe BAtco Aspe ...
19 Ene 20 Crevillente FemeninoCrevillente Apl Cff UryulaCff Uryula ...
19 Ene 20 Elda Promesas AElda 2 - 0 El CampelloCampello ...
19 Ene 20 Benisa ABenisa A 0 - 0 Elche CElche C ...
16 Feb 20 Bonavista ABonavista 3 - 2 SPA Alicante CAlicante ...
Ver jornada
Jornada 13
25 Ene 20 La Nucia ALa Nucia A 12 - 0 Sport Base Ontinyent ASport Base ...
25 Ene 20 Bahia Santa Pola ABahia Santa 2 - 0 Bonavista ABonavista ...
26 Ene 20 Atco Aspe BAtco Aspe 2 - 3 Elche B FemElche ...
26 Ene 20 Cff UryulaCff Uryula 0 - 3 RojalesRojales ...
26 Ene 20 El CampelloCampello 2 - 5 Benisa ABenisa A ...
25 Ene 20 Elche CElche C 5 - 0 Crevillente FemeninoCrevillente ...
25 Ene 20 SPA Alicante CAlicante 1 - 3 Elda Promesas AElda ...
Ver jornada
Jornada 14
02 Feb 20 SPA Alicante CAlicante 1 - 5 Benisa ABenisa A ...
02 Feb 20 Elda Promesas AElda 1 - 2 Bonavista ABonavista ...
01 Feb 20 El CampelloCampello 1 - 0 Crevillente FemeninoCrevillente ...
01 Feb 20 Elche CElche C 2 - 3 RojalesRojales ...
01 Feb 20 Atco Aspe BAtco Aspe 3 - 3 Sport Base Ontinyent ASport Base ...
02 Feb 20 Cff UryulaCff Uryula 0 - 1 Elche B FemElche ...
31 Ene 20 La Nucia ALa Nucia A 3 - 1 Bahia Santa Pola ABahia Santa ...
Ver jornada
Jornada 15
09 Feb 20 Crevillente FemeninoCrevillente 0 - 1 SPA Alicante CAlicante ...
09 Feb 20 Benisa ABenisa A 1 - 3 Elda Promesas AElda ...
08 Feb 20 RojalesRojales 2 - 0 El CampelloCampello ...
08 Feb 20 Elche B FemElche 6 - 1 Elche CElche C ...
08 Feb 20 Bahia Santa Pola ABahia Santa 2 - 2 Atco Aspe BAtco Aspe ...
08 Feb 20 Sport Base Ontinyent ASport Base 0 - 3 Cff UryulaCff Uryula ...
09 Feb 20 Bonavista ABonavista 1 - 0 La Nucia ALa Nucia A ...
Ver jornada
Jornada 16
26 Feb 20 Elda Promesas AElda 5 - 0 Crevillente FemeninoCrevillente ...
22 Feb 20 Benisa ABenisa A 2 - 1 Bonavista ABonavista ...
22 Feb 20 SPA Alicante CAlicante 0 - 4 RojalesRojales ...
23 Feb 20 El CampelloCampello 1 - 6 Elche B FemElche ...
23 Feb 20 Cff UryulaCff Uryula 1 - 3 Bahia Santa Pola ABahia Santa ...
23 Feb 20 Elche CElche C 3 - 1 Sport Base Ontinyent ASport Base ...
22 Feb 20 Atco Aspe BAtco Aspe 4 - 3 La Nucia ALa Nucia A ...
Ver jornada
Jornada 17
01 Mar 20 RojalesRojales 1 - 1 Elda Promesas AElda ...
01 Mar 20 Crevillente FemeninoCrevillente 3 - 3 Benisa ABenisa A ...
29 Feb 20 Elche B FemElche 1 - 0 SPA Alicante CAlicante ...
29 Feb 20 Sport Base Ontinyent ASport Base 0 - 0 El CampelloCampello ...
01 Mar 20 La Nucia ALa Nucia A 5 - 1 Cff UryulaCff Uryula ...
28 Feb 20 Bahia Santa Pola ABahia Santa 1 - 0 Elche CElche C ...
01 Mar 20 Bonavista ABonavista 2 - 1 Atco Aspe BAtco Aspe ...
Ver jornada
Jornada 18
07 Mar 20 Benisa ABenisa A 2 - 5 RojalesRojales ...
07 Mar 20 Crevillente FemeninoCrevillente 2 - 4 Bonavista ABonavista ...
08 Mar 20 Elda Promesas AElda 0 - 3 Elche B FemElche ...
08 Mar 20 SPA Alicante CAlicante 3 - 2 Sport Base Ontinyent ASport Base ...
07 Mar 20 Elche CElche C 2 - 0 La Nucia ALa Nucia A ...
08 Mar 20 El CampelloCampello 2 - 2 Bahia Santa Pola ABahia Santa ...
07 Mar 20 Cff UryulaCff Uryula 1 - 2 Atco Aspe BAtco Aspe ...
Ver jornada
Jornada 19
22 Mar 20 Elche B FemElche Apl Benisa ABenisa A ...
22 Mar 20 RojalesRojales Apl Crevillente FemeninoCrevillente ...
22 Mar 20 Sport Base Ontinyent ASport Base Apl Elda Promesas AElda ...
22 Mar 20 Bahia Santa Pola ABahia Santa Apl SPA Alicante CAlicante ...
22 Mar 20 Atco Aspe BAtco Aspe Apl Elche CElche C ...
22 Mar 20 La Nucia ALa Nucia A Apl El CampelloCampello ...
22 Mar 20 Bonavista ABonavista Apl Cff UryulaCff Uryula ...
Ver jornada
Jornada 20
29 Mar 20 Crevillente FemeninoCrevillente Apl Elche B FemElche ...
29 Mar 20 RojalesRojales Apl Bonavista ABonavista ...
29 Mar 20 Benisa ABenisa A Apl Sport Base Ontinyent ASport Base ...
29 Mar 20 Elda Promesas AElda Apl Bahia Santa Pola ABahia Santa ...
29 Mar 20 El CampelloCampello Apl Atco Aspe BAtco Aspe ...
29 Mar 20 SPA Alicante CAlicante Apl La Nucia ALa Nucia A ...
29 Mar 20 Elche CElche C Apl Cff UryulaCff Uryula ...
Ver jornada
Jornada 21
05 Abr 20 Sport Base Ontinyent ASport Base Apl Crevillente FemeninoCrevillente ...
05 Abr 20 Elche B FemElche Apl RojalesRojales ...
05 Abr 20 Bahia Santa Pola ABahia Santa Apl Benisa ABenisa A ...
05 Abr 20 La Nucia ALa Nucia A Apl Elda Promesas AElda ...
05 Abr 20 Cff UryulaCff Uryula Apl El CampelloCampello ...
05 Abr 20 Atco Aspe BAtco Aspe Apl SPA Alicante CAlicante ...
05 Abr 20 Bonavista ABonavista Apl Elche CElche C ...
Ver jornada
Jornada 22
19 Abr 20 RojalesRojales Apl Sport Base Ontinyent ASport Base ...
19 Abr 20 Elche B FemElche Apl Bonavista ABonavista ...
19 Abr 20 Crevillente FemeninoCrevillente Apl Bahia Santa Pola ABahia Santa ...
19 Abr 20 Benisa ABenisa A Apl La Nucia ALa Nucia A ...
19 Abr 20 SPA Alicante CAlicante Apl Cff UryulaCff Uryula ...
19 Abr 20 Elda Promesas AElda Apl Atco Aspe BAtco Aspe ...
19 Abr 20 El CampelloCampello Apl Elche CElche C ...
Ver jornada
Jornada 23
26 Abr 20 Bahia Santa Pola ABahia Santa Apl RojalesRojales ...
26 Abr 20 Sport Base Ontinyent ASport Base Apl Elche B FemElche ...
26 Abr 20 La Nucia ALa Nucia A Apl Crevillente FemeninoCrevillente ...
26 Abr 20 Atco Aspe BAtco Aspe Apl Benisa ABenisa A ...
26 Abr 20 Elche CElche C Apl SPA Alicante CAlicante ...
26 Abr 20 Cff UryulaCff Uryula Apl Elda Promesas AElda ...
26 Abr 20 Bonavista ABonavista Apl El CampelloCampello ...
Ver jornada
Jornada 24
10 May 20 Elche B FemElche Apl Bahia Santa Pola ABahia Santa ...
10 May 20 Sport Base Ontinyent ASport Base Apl Bonavista ABonavista ...
10 May 20 RojalesRojales Apl La Nucia ALa Nucia A ...
10 May 20 Crevillente FemeninoCrevillente Apl Atco Aspe BAtco Aspe ...
10 May 20 Elda Promesas AElda Apl Elche CElche C ...
10 May 20 Benisa ABenisa A Apl Cff UryulaCff Uryula ...
10 May 20 SPA Alicante CAlicante Apl El CampelloCampello ...
Ver jornada
Jornada 25
17 May 20 La Nucia ALa Nucia A Apl Elche B FemElche ...
17 May 20 Bahia Santa Pola ABahia Santa Apl Sport Base Ontinyent ASport Base ...
17 May 20 Atco Aspe BAtco Aspe Apl RojalesRojales ...
17 May 20 Cff UryulaCff Uryula Apl Crevillente FemeninoCrevillente ...
17 May 20 El CampelloCampello Apl Elda Promesas AElda ...
17 May 20 Elche CElche C Apl Benisa ABenisa A ...
17 May 20 SPA Alicante CAlicante Apl Bonavista ABonavista ...
Ver jornada
Jornada 26
24 May 20 Sport Base Ontinyent ASport Base Apl La Nucia ALa Nucia A ...
24 May 20 Bonavista ABonavista Apl Bahia Santa Pola ABahia Santa ...
24 May 20 Elche B FemElche Apl Atco Aspe BAtco Aspe ...
24 May 20 RojalesRojales Apl Cff UryulaCff Uryula ...
24 May 20 Benisa ABenisa A Apl El CampelloCampello ...
24 May 20 Crevillente FemeninoCrevillente Apl Elche CElche C ...
24 May 20 Elda Promesas AElda Apl SPA Alicante CAlicante ...

Clasificación

Equipo PJ GF GC Puntos
1 Elche B Fem Elche B Fem 18 77 10 54
2 La Nucia A La Nucia A 18 71 23 40
3 Rojales Rojales 18 49 21 38
4 Elda Promesas A Elda 18 44 21 37
5 Bahia Santa Pola A Bahia Santa 18 42 23 35
6 Elche C Elche C 18 39 28 29
7 Bonavista A Bonavista A 18 25 29 27
8 Cff Uryula Cff Uryula 17 28 42 19
9 Atco Aspe B Atco Aspe B 18 34 45 18
10 Benisa A Benisa A 18 32 49 18
11 SPA Alicante C Alicante 18 25 55 16
12 Crevillente Femenino Crevillente 17 20 46 11
13 El Campello El Campello 18 17 66 11
14 Sport Base Ontinyent A Sport Base. 18 18 63 9

  USO DE MEMORIA  
5,971,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.4325
Total Execution Time  0.4358
  CADENA URL  
/primera_femenina_valencia_femenina2020/grupo3/calendario
  GET DATOS  
$_GET['/primera_femenina_valencia_femenina2020/grupo3/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0124  SELECT type FROM routes WHERE alias = 'primera_femenina_valencia_femenina2020'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_femenina_valencia_femenina' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1182 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1182 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0126  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (814852,791980,726275) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1182 ORDER BY order_id ASC
0.0125  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1182 GROUP BY l.categoryId
0.0126  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1182 GROUP BY l.year ORDER BY l.year DESC
0.0126  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 = 51398 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 51398 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 15:39:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 15:39:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 15:39:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 15:39:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_femenina_valencia_femenina' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  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 events2020 e ON e.player_id = p.id AND e.league_id = 51398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51398 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.0126  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 events2020 e ON e.player_id = p.id AND e.league_id = 51398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51398 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0127  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 events2020 e ON e.player_id = p.id AND e.league_id = 51398 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51398 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 51398 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC