4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Sportivo Trinidense Sportivo 30 54 24 66
2 Sportivo Luqueño Sportivo 30 42 26 61
3 Sportivo San Lorenzo Sportivo 30 47 26 54
4 Pastoreo Pastoreo 30 44 28 53
5 Fernando de la Mora Fernando 30 48 31 48
6 Martín Ledesma Martín 30 30 29 45
7 Rubio Ñu Rubio Ñu 30 39 30 44
8 Independiente FBC Independient 30 33 36 41
9 Atyrá Atyrá 30 24 28 36
10 CA Colegiales Colegiales 30 32 42 36
11 3 de Febrero Febrero 30 29 36 35
12 Deportivo Santaní Deportivo 30 30 42 33
13 Guarani Trinidad Guarani 30 29 41 31
14 2 de Mayo 2 de Mayo 30 32 39 29
15 Club River Plate Club River. 30 27 39 26
16 Sportivo Iteño Sportivo 30 27 70 20
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 General Caballero JLM General 34 67 31 73
2 Resistencia Resistencia 34 44 22 61
3 Tacuary Tacuary 34 54 44 57
4 Sportivo Ameliano Sportivo 34 51 37 56
5 Sportivo San Lorenzo Sportivo 34 60 44 53
6 Sportivo Trinidense Sportivo 34 48 48 52
7 Independiente FBC Independient 34 38 30 51
8 3 de Febrero Febrero 34 48 44 48
9 Fernando de la Mora Fernando 34 40 36 45
10 Atyrá Atyrá 34 47 45 43
11 Guarani Trinidad Guarani 34 34 37 41
12 Deportivo Santaní Deportivo 34 38 42 41
13 Rubio Ñu Rubio Ñu 34 34 44 39
14 Dep. Capiatá Dep. 34 34 47 39
15 Sportivo Iteño Sportivo 34 26 39 39
16 2 de Mayo 2 de Mayo 34 39 55 36
17 General Díaz General 34 25 53 24
18 Fulgencio Yegros Fulgencio 34 25 54 21
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 2 de Mayo 2 de Mayo 0 0 0 0
2 3 de Febrero Febrero 0 0 0 0
3 Atyrá Atyrá 0 0 0 0
4 Dep. Capiatá Dep. 0 0 0 0
5 Deportivo Santaní Deportivo 0 0 0 0
6 Fernando de la Mora Fernando 0 0 0 0
7 Fulgencio Yegros Fulgencio 0 0 0 0
8 General Caballero JLM General 0 0 0 0
9 Guarani Trinidad Guarani 0 0 0 0
10 Independiente FBC Independient 0 0 0 0
11 Resistencia Resistencia 0 0 0 0
12 Rubio Ñu Rubio Ñu 0 0 0 0
13 Sportivo Ameliano Sportivo 0 0 0 0
14 Sportivo Iteño Sportivo 0 0 0 0
15 Sportivo Trinidense Sportivo 0 0 0 0
16 Tacuary Tacuary 0 0 0 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Guaireña Guaireña 30 49 25 57
2 12 de Octubre Octubre 30 39 28 56
3 2 de Mayo 2 de Mayo 30 48 24 55
4 Atyrá Atyrá 30 46 40 49
5 Resistencia Resistencia 30 49 42 45
6 Fernando de la Mora Fernando 30 43 37 43
7 Independiente FBC Independient 30 37 36 41
8 General Caballero JLM General 30 41 42 41
9 Sportivo Trinidense Sportivo 30 37 36 40
10 3 de Febrero Febrero 30 36 40 39
11 Sportivo Iteño Sportivo 30 35 42 36
12 Rubio Ñu Rubio Ñu 30 32 39 35
13 RI 3 Corrales Corrales 30 32 33 32
14 Ovetense Ovetense 30 29 46 29
15 Fulgencio Yegros Fulgencio 30 25 45 24
16 Deportivo Caaguazú Deportivo 30 23 46 23
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Club River Plate Club River. 30 41 26 55
2 Sportivo San Lorenzo Sportivo 30 47 30 51
3 Fernando de la Mora Fernando 30 41 28 51
4 Guaireña Guaireña 30 38 23 50
5 2 de Mayo 2 de Mayo 30 48 41 46
6 Rubio Ñu Rubio Ñu 30 40 38 44
7 Fulgencio Yegros Fulgencio 30 33 39 41
8 Resistencia Resistencia 30 32 33 40
9 CD Liberación Liberación 30 36 44 39
10 Sportivo Trinidense Sportivo 30 34 30 38
11 RI 3 Corrales Corrales 30 39 44 37
12 Ovetense Ovetense 30 29 35 36
13 General Caballero SC General 30 39 46 35
14 Sportivo Iteño Sportivo 30 35 41 34
15 Deportivo Caaguazú Deportivo 30 34 44 33
16 Martín Ledesma Martín 30 25 49 21
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 3 de Febrero Febrero 30 47 28 56
2 Deportivo Santaní Deportivo 30 45 27 55
3 Fulgencio Yegros Fulgencio 30 43 32 49
4 Resistencia Resistencia 30 52 46 47
5 CD Liberación Liberación 30 41 47 43
6 Ovetense Ovetense 30 42 39 42
7 Martín Ledesma Martín 30 49 45 41
8 Deportivo Caaguazú Deportivo 30 40 41 41
9 Guaireña Guaireña 30 37 34 40
10 Sportivo Iteño Sportivo 30 31 33 39
11 Club River Plate Club River. 30 42 37 38
12 General Caballero SC General 30 37 36 38
13 22 de Setiembre Setiembre 30 36 34 37
14 Fernando de la Mora Fernando 30 38 46 35
15 Caacupé Caacupé 30 30 44 28
16 Olimpia Itá Olimpia Itá 30 33 74 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Independiente FBC Independient 30 59 31 62
2 Sportivo Trinidense Sportivo 30 44 36 52
3 Resistencia Resistencia 30 34 34 48
4 Deportivo Santaní Deportivo 30 42 34 45
5 Deportivo Caaguazú Deportivo 30 41 39 43
6 Sportivo Iteño Sportivo 30 35 42 42
7 3 de Febrero Febrero 30 41 35 41
8 Fernando de la Mora Fernando 30 39 37 41
9 Caacupé Caacupé 30 44 42 40
10 Fulgencio Yegros Fulgencio 30 50 50 40
11 Olimpia Itá Olimpia Itá 30 30 35 40
12 Ovetense Ovetense 30 47 45 38
13 Sportivo San Lorenzo Sportivo 30 38 35 36
14 Cristóbal Colón Cristóbal 30 40 47 34
15 CD Liberación Liberación 30 37 51 28
16 Sport Colombia Sport 30 29 57 27
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Club River Plate Club River. 30 41 29 54
2 Fernando de la Mora Fernando 30 45 25 53
3 General Caballero SC General 30 45 33 52
4 CD Liberación Liberación 30 40 31 50
5 Deportivo Caaguazú Deportivo 30 33 26 46
6 Resistencia Resistencia 30 29 23 45
7 Sportivo Iteño Sportivo 30 33 32 43
8 Caacupé Caacupé 30 45 39 42
9 Cristóbal Colón Cristóbal 30 45 48 42
10 3 de Febrero Febrero 30 27 18 40
11 Independiente FBC Independient 30 39 44 34
12 Sportivo Trinidense Sportivo 30 34 43 29
13 Sport Colombia Sport 30 27 42 29
14 Tacuary Tacuary 30 22 30 27
15 Sportivo Carapeguá Sportivo 30 32 50 26
16 12 de Octubre Octubre 30 28 52 23
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Sportivo San Lorenzo Sportivo 30 40 20 57
2 Deportivo Santaní Deportivo 30 36 22 57
3 Resistencia Resistencia 30 34 25 47
4 Sportivo Iteño Sportivo 30 35 29 47
5 Independiente FBC Independient 30 33 32 44
6 Sportivo Trinidense Sportivo 30 39 34 43
7 Deportivo Caaguazú Deportivo 30 36 27 42
8 Club River Plate Club River. 30 37 37 42
9 Sport Colombia Sport 30 34 29 39
10 Caacupé Caacupé 30 32 35 39
11 Sportivo Carapeguá Sportivo 30 30 31 36
12 Tacuary Tacuary 30 36 39 36
13 General Caballero SC General 30 34 36 34
14 Paranaense FC Paranaense 30 26 46 30
15 Olimpia Itá Olimpia Itá 30 33 51 27
16 PF Cerro Por. Cerro Por. 30 23 45 26
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 3 de Febrero Febrero 30 42 28 52
2 12 de Octubre Octubre 30 45 28 51
3 Sportivo Trinidense Sportivo 30 30 21 49
4 Tacuary Tacuary 30 37 23 48
5 Sport Colombia Sport 30 35 28 47
6 Independiente FBC Independient 30 34 32 47
7 Paranaense FC Paranaense 30 34 38 40
8 General Caballero SC General 30 30 31 39
9 Caacupé Caacupé 30 29 32 38
10 Fernando de la Mora Fernando 30 31 33 36
11 Resistencia Resistencia 30 37 37 35
12 Deportivo Santaní Deportivo 30 39 40 34
13 Club River Plate Club River. 30 30 39 33
14 Sportivo San Lorenzo Sportivo 30 29 35 30
15 Martín Ledesma Martín 30 31 53 30
16 2 de Mayo 2 de Mayo 30 24 39 26
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 General Díaz General 30 48 22 60
2 Dep. Capiatá Dep. 30 61 37 58
3 Deportivo Santaní Deportivo 30 46 27 54
4 Sportivo San Lorenzo Sportivo 30 40 35 48
5 Sportivo Trinidense Sportivo 30 34 33 46
6 Sport Colombia Sport 30 48 33 44
7 3 de Febrero Febrero 30 48 41 42
8 General Caballero SC General 30 31 33 42
9 Club River Plate Club River. 30 38 45 41
10 2 de Mayo 2 de Mayo 30 36 37 40
11 Resistencia Resistencia 30 43 45 40
12 Fernando de la Mora Fernando 30 31 40 36
13 Paranaense FC Paranaense 30 31 39 34
14 CA Colegiales Colegiales 30 22 29 33
15 Sportivo Iteño Sportivo 30 35 60 23
16 29 de Setiembre Setiembre 30 28 64 17
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 PF Cerro Por. Cerro Por. 26 43 28 45
2 Sportivo Carapeguá Sportivo 26 41 29 45
3 Dep. Capiatá Dep. 26 39 26 44
4 Deportivo Santaní Deportivo 26 28 22 44
5 Club River Plate Club River. 26 32 36 37
6 General Díaz General 26 30 28 36
7 CA Colegiales Colegiales 26 23 28 33
8 Sportivo San Lorenzo Sportivo 26 36 37 32
9 Fernando de la Mora Fernando 26 28 29 31
10 Sportivo Iteño Sportivo 26 22 24 29
11 Sportivo Trinidense Sportivo 26 22 31 29
12 Sport Colombia Sport 26 21 26 28
13 Deportivo Caaguazú Deportivo 26 29 37 24
14 12 de Octubre Octubre 26 24 37 22
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 General Caballero SC General 26 38 22 50
2 Independiente FBC Independient 26 33 26 46
3 Sportivo San Lorenzo Sportivo 26 31 24 42
4 Fernando de la Mora Fernando 26 34 25 37
5 CA Colegiales Colegiales 26 29 31 37
6 Deportivo Caaguazú Deportivo 26 32 36 35
7 PF Cerro Por. Cerro Por. 26 31 31 32
8 General Díaz General 26 36 36 31
9 12 de Octubre Octubre 26 34 39 31
10 Deportivo Santaní Deportivo 26 25 28 30
11 Sportivo Iteño Sportivo 26 21 25 29
12 Dep. Capiatá Dep. 26 27 37 29
13 2 de Mayo 2 de Mayo 26 27 35 28
14 Club Cerro Corá Club Cerro. 26 28 31 27
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Sportivo Trinidense Sportivo 22 31 11 44
2 Sport Colombia Sport 22 31 24 39
3 PF Cerro Por. Cerro Por. 22 27 18 36
4 CA Colegiales Colegiales 22 29 20 35
5 Fernando de la Mora Fernando 22 23 17 35
6 Independiente FBC Independient 22 26 21 29
7 Deportivo Caaguazú Deportivo 22 19 25 28
8 General Díaz General 22 31 36 25
9 Sportivo Iteño Sportivo 22 23 29 23
10 General Caballero SC General 22 19 31 23
11 Benjamin Aceval Benjamin 22 20 31 18
12 Silvio Pettirossi Silvio 22 18 34 18
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 General Caballero SC General 19 26 18 35
2 Rubio Ñu Rubio Ñu 19 25 11 34
3 Sportivo Trinidense Sportivo 19 24 21 30
4 Sport Colombia Sport 19 32 29 27
5 Sportivo Iteño Sportivo 19 21 22 25
6 PF Cerro Por. Cerro Por. 19 21 23 23
7 Benjamin Aceval Benjamin 18 21 21 22
8 General Díaz General 18 15 17 22
9 Fernando de la Mora Fernando 18 19 28 19
10 Presidente Hayes Presidente 18 11 25 12
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Silvio Pettirossi Silvio 18 27 15 35
2 General Díaz General 18 18 12 32
3 Rubio Ñu Rubio Ñu 18 22 16 28
4 PF Cerro Por. Cerro Por. 18 30 31 26
5 Sportivo Iteño Sportivo 18 27 24 24
6 Presidente Hayes Presidente 18 17 16 24
7 Fernando de la Mora Fernando 18 21 23 20
8 General Caballero SC General 18 14 20 19
9 Martín Ledesma Martín 18 16 23 17
10 Chore Central Chore 18 14 26 17

  USO DE MEMORIA  
6,951,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.1307
Total Execution Time  0.1332
  CADENA URL  
/paraguay_division_intermedia2022/grupo1/historico
  GET DATOS  
$_GET['/paraguay_division_intermedia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0017  SELECT type FROM routes WHERE alias = 'paraguay_division_intermedia2022'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'paraguay_division_intermedia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=195 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 195 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0026  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 (1053484,940535,933802,923443,885068) ORDER BY n.cover_points DESC, update_date DESC
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 = 66216 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 195 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66216 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 61984 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 53794 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 48876 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 42469 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 37858 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 20478 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 10890 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 3677 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 2416 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 1642 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 1389 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 15380 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 15381 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 15382 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 15383 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 17:02:31' 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-04-18 17:02:31' 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-04-18 17:02:31' 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-04-18 17:02:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'paraguay_division_intermedia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0089  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 events2022 e ON e.player_id = p.id AND e.league_id = 66216 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66216 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.0023  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 events2022 e ON e.player_id = p.id AND e.league_id = 66216 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66216 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
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 events2022 e ON e.player_id = p.id AND e.league_id = 66216 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66216 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66216 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC