4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 SC Bengaluru Bengaluru 12 23 12 27
2 Dempo SC Dempo SC 13 18 12 24
3 Sudeva Delhi Sudeva Delhi 13 16 16 23
4 Bengaluru United Bengaluru 13 21 18 20
5 Sporting Club Goa Sporting 13 18 16 19
6 United SC United SC 13 16 20 12
7 Maharashtra Oranje Maharashtra 13 19 25 12
8 Kenkre Kenkre 12 17 29 9
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Shillong Lajong Shillong 3 9 2 7
2 Dowtown Heroes Dowtown 3 8 3 7
3 United Chirang United 3 4 12 3
4 Corbett Corbett 3 2 6 0
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Madan Maharaj Madan 3 5 4 5
2 Rajasthan Rajasthan 3 5 4 5
3 Ryntih Ryntih 3 4 4 3
4 Bengaluru United Bengaluru 3 4 6 2
5 Delhi FC Delhi FC 4 11 2 12
6 Kenkre Kenkre 4 4 3 7
7 Kerala FC Kerala FC 4 7 5 6
8 Corbett Corbett 4 2 8 2
9 ARA ARA 4 3 9 1
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Garhwal Garhwal 7 14 8 14
2 ATK II ATK II 8 10 9 14
3 Jamshedpur II Jamshedpur 8 7 9 10
4 Minerva Punjab II Minerva 6 8 5 9
5 Rajasthan Rajasthan 6 4 7 5
6 Lonestar Kashmir Lonestar 7 8 13 5
7 Mohammedan SC Mohammedan 6 13 6 12
8 Bhawanipore FC Bhawanipore 5 7 7 8
9 Hyderabad II Hyderabad 6 6 6 8
10 Chennaiyin II Chennaiyin 7 8 12 8
11 Bengaluru II Bengaluru 6 8 11 6
12 ARA ARA 7 15 6 14
13 Bengaluru United Bengaluru 8 12 6 14
14 Goa II Goa II 7 11 6 12
15 FC Kerala FC Kerala 7 9 7 9
16 Kerala Blasters II Kerala 7 8 14 5
17 Mumbai City II Mumbai City 8 4 20 5
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Bengaluru II Bengaluru 8 26 3 22
2 Goa II Goa II 8 17 7 15
3 Lonestar Kashmir Lonestar 8 8 13 11
4 ARA ARA 8 10 14 10
5 Hindustan Hindustan 8 5 29 0
6 Ozone Ozone 8 19 6 20
7 Fateh Hyderabad Fateh 8 12 9 13
8 Kerala Blasters II Kerala 8 9 13 8
9 South United FC South United 8 10 16 7
10 Chennaiyin II Chennaiyin 8 8 14 6
11 Chhinga Veng Chhinga Veng 10 18 11 20
12 TRAU TRAU 10 17 20 17
13 Mohammedan SC Mohammedan 10 21 13 16
14 ATK II ATK II 10 15 14 14
15 Rainbow Rainbow 10 17 16 13
16 Jamshedpur II Jamshedpur 10 10 24 4
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Real Kashmir Real Kashmir 10 15 8 22
2 Hindustan Hindustan 10 13 7 20
3 Pune City II Pune City 10 10 9 13
4 Delhi United SC Delhi United 10 10 11 9
5 Odisha FC II Odisha 9 5 9 8
6 Lonestar Kashmir Lonestar 9 9 18 2
7 Kerala Blasters II Kerala 10 25 17 21
8 Ozone Ozone 10 19 3 19
9 FC Kerala FC Kerala 10 19 12 19
10 Fateh Hyderabad Fateh 10 23 16 17
11 Goa II Goa II 10 13 15 9
12 Madhya Bharat Madhya 10 3 39 0
13 TRAU TRAU 10 26 9 23
14 Bengaluru II Bengaluru 10 19 13 17
15 Langsning Langsning 10 16 9 15
16 Mohammedan SC Mohammedan 10 12 13 12
17 Jamshedpur II Jamshedpur 10 11 22 11
18 Chennaiyin II Chennaiyin 10 8 26 6
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Lonestar Kashmir Lonestar 6 6 3 10
2 Delhi United SC Delhi United 6 5 4 9
3 Real Kashmir Real Kashmir 6 7 8 9
4 Sudeva Delhi Sudeva Delhi 6 6 9 5
5 Neroca Neroca 6 5 3 13
6 Southern Samity Southern 6 10 4 12
7 Mohammedan SC Mohammedan 6 10 6 10
8 Hindustan Hindustan 6 3 15 0
9 Fateh Hyderabad Fateh 6 7 1 12
10 Kenkre Kenkre 6 7 4 11
11 Ozone Ozone 6 13 8 10
12 Pride Sports Pride Sports 6 2 16 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Punjab FC Punjab FC 8 16 3 19
2 Mohammedan SC Mohammedan 8 11 7 16
3 Dempo SC Dempo SC 8 16 6 15
4 Lonestar Kashmir Lonestar 8 10 5 13
5 Gangtok Himalayan Gangtok 8 9 4 13
6 Neroca Neroca 8 7 5 12
7 Guwahati Guwahati 8 9 8 9
8 Kenkre Kenkre 8 6 11 6
9 Fateh Hyderabad Fateh 8 5 17 4
10 PIFA Sports PIFA Sports 8 3 26 2
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Aizawl Aizawl 14 45 20 34
2 Lonestar Kashmir Lonestar 14 22 14 27
3 Mohammedan SC Mohammedan 14 29 17 26
4 Chanmari Chanmari 14 35 24 25
5 Chirag United SC Chirag 14 24 28 17
6 Hindustan Hindustan 14 18 28 15
7 Kenkre Kenkre 14 21 39 10
8 PIFA Sports PIFA Sports 14 15 39 4
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Royal Wahingdoh Royal 5 17 2 11
2 Kalighat Milan Sangha Kalighat 5 12 2 11
3 Garhwal Garhwal 5 10 15 9
4 Green Valley FC Green Valley 5 5 5 7
5 PIFA Sports PIFA Sports 5 3 7 4
6 MP United FC United 5 2 18 0
7 Hindustan Hindustan 4 7 7 9
8 Bhawanipore FC Bhawanipore 4 8 3 7
9 Eagles Cochin Eagles 4 7 4 7
10 Aizawl Aizawl 4 7 4 5
11 Kenkre Kenkre 4 1 12 0
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Langsning Langsning 8 20 4 20
2 Rangdajied United Rangdajied 8 18 6 18
3 DSK Shivajians Shivajians 8 15 7 17
4 Kenkre Kenkre 8 12 10 12
5 KGF Academy KGF Academy 8 9 12 10
6 Delhi United SC Delhi United 8 8 11 9
7 George Telegraph George 8 11 13 6
8 Samaleswari Samaleswari 8 4 13 4
9 Kohima Komets Kohima 8 4 25 4
10 Mohammedan SC Mohammedan 8 13 3 20
11 Bhawanipore FC Bhawanipore 8 12 6 19
12 Royal Wahingdoh Royal 8 18 4 16
13 Techno Aryan Techno Aryan 8 14 7 13
14 Aizawl Aizawl 8 15 13 13
15 Josco Josco 8 9 11 10
16 PIFA Sports PIFA Sports 8 8 17 6
17 Green Valley FC Green Valley 8 7 17 4
18 Simla Youngs Simla Youngs 8 10 28 3
19 Southern Samity Southern 7 10 4 17
20 Mumbai Tigers FC Mumbai 7 14 7 16
21 Vasco SC Vasco SC 7 9 3 16
22 Kalighat Milan Sangha Kalighat 7 19 9 10
23 South United FC South United 7 12 11 7
24 Eagles Cochin Eagles 7 7 15 5
25 Hindustan Hindustan 7 4 11 4
26 Luangmual FC Luangmual 7 8 23 4
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 United Sikkim United 6 18 11 13
2 Aizawl Aizawl 6 11 4 13
3 Rangdajied United Rangdajied 6 18 12 11
4 Green Valley FC Green Valley 6 11 10 8
5 Southern Samity Southern 6 8 10 5
6 Bhawanipore FC Bhawanipore 6 8 11 3
7 Eagles Cochin Eagles 6 4 20 3
8 Royal Wahingdoh Royal 7 18 7 17
9 Kalighat Milan Sangha Kalighat 7 21 7 16
10 Sesa Academy Sesa Academy 7 15 9 14
11 Techno Aryan Techno Aryan 7 13 8 9
12 Samaleswari Samaleswari 7 13 15 8
13 Kenkre Kenkre 7 10 16 7
14 Gauhati Town Club Gauhati Town 7 11 14 6
15 Kerala FC Kerala FC 7 4 29 1
16 Mohammedan SC Mohammedan 7 15 4 19
17 Vasco SC Vasco SC 7 16 6 16
18 Langsning Langsning 7 11 9 13
19 KGF Academy KGF Academy 7 15 13 9
20 Simla Youngs Simla Youngs 7 8 9 7
21 Golden Threads Golden 7 12 18 7
22 Luangmual FC Luangmual 7 8 17 5
23 PIFA Sports PIFA Sports 7 5 14 2
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 United Sikkim United 6 15 7 13
2 Southern Samity Southern 6 10 5 13
3 Langsning Langsning 6 11 7 10
4 NISA NISA 6 9 7 9
5 Golden Threads Golden 6 5 10 5
6 Simla Youngs Simla Youngs 6 3 8 5
7 Gauhati Town Club Gauhati Town 6 4 13 4
8 Mohammedan SC Mohammedan 6 11 4 14
9 Rangdajied United Rangdajied 6 15 10 10
10 Kenkre Kenkre 6 15 12 10
11 Josco Josco 6 12 11 10
12 Malabar United Malabar 6 8 6 7
13 Sesa Academy Sesa Academy 6 8 13 4
14 Denzong Boyz Denzong Boyz 6 8 21 2
15 Royal Wahingdoh Royal 6 17 7 18
16 Vasco SC Vasco SC 6 26 6 15
17 Techno Aryan Techno Aryan 6 20 6 12
18 Eagles Cochin Eagles 6 10 13 7
19 PIFA Sports PIFA Sports 6 7 14 6
20 Bharat FC Bharat FC 6 4 20 3
21 Chandni Chandni 6 2 20 1
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Malabar United Malabar 6 10 7 12
2 Hindustan Aeronautics Hindustan 6 13 6 9
3 Bharat FC Bharat FC 6 14 10 9
4 Travancore Travancore 6 12 9 9
5 Travancore Titanium Travancore 6 4 8 6
6 Golden Threads Golden 6 5 11 5
7 Chandni Chandni 6 5 12 5
8 Sesa Academy Sesa Academy 6 17 6 15
9 ONGC ONGC 6 16 3 13
10 Hindustan Hindustan 6 10 8 10
11 Amity United Amity United 6 8 12 9
12 New Delhi Heroes Delhi Heroes 6 14 10 7
13 Simla Youngs Simla Youngs 6 8 22 4
14 Indian National FC Indian 6 3 15 3
15 NISA NISA 6 14 6 15
16 Oil India Oil India 6 12 3 13
17 JCB Bhilai Brothers Bhilai 6 10 6 9
18 Rangdajied United Rangdajied 6 8 11 8
19 Mumbai United Athletic Club Mumbai 6 8 9 7
20 Gauhati Town Club Gauhati Town 6 5 10 5
21 Denzong Boyz Denzong Boyz 6 2 14 1
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 ONGC ONGC 4 8 4 9
2 Shillong Lajong Shillong 4 7 5 8
3 Oil India Oil India 4 6 5 5
4 George Telegraph George 4 6 5 4
5 Bengal Mumbai Bengal 4 4 12 1
6 Sesa Academy Sesa Academy 4 10 1 10
7 Pune FC Pune FC 4 2 0 8
8 New Delhi Heroes Delhi Heroes 4 6 6 5
9 Simla Youngs Simla Youngs 4 3 11 2
10 Amity United Amity United 4 5 8 1
11 Salgaocar Salgaocar 4 6 2 10
12 Chirag Kerala Chirag 4 10 3 8
13 Chandni Chandni 4 2 5 4
14 Malabar United Malabar 4 3 7 4
15 Travancore Travancore 4 2 6 1
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Vasco SC Vasco SC 5 7 3 13
2 Chirag United SC Chirag 5 8 5 10
3 Pune FC Pune FC 5 8 6 7
4 Hindustan Aeronautics Hindustan 5 11 9 6
5 ONGC ONGC 5 4 4 6
6 Travancore Travancore 5 1 12 0
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Chirag United SC Chirag 5 6 2 11
2 Vasco SC Vasco SC 5 9 8 9
3 ONGC ONGC 5 5 3 8
4 SEC Railway SEC Railway 5 1 3 6
5 Travancore Travancore 5 2 5 4
6 Punjab Police Punjab 5 5 7 3
7 Salgaocar Salgaocar 5 8 1 13
8 Army XI Army XI 5 6 6 8
9 Chirag Kerala Chirag 5 11 5 7
10 Shillong Lajong Shillong 5 4 3 7
11 FC Indian Bank Indian Bank 5 2 8 6
12 J and K Bank Bank 5 0 8 1

  USO DE MEMORIA  
6,457,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6064
Total Execution Time  0.6083
  CADENA URL  
/segunda_india2024/grupo1/historico
  GET DATOS  
$_GET['/segunda_india2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0147  SELECT type FROM routes WHERE alias = 'segunda_india2024'
0.0302  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_india' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1753 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1753 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (1118087,942046,373438) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1753 ORDER BY order_id ASC
0.0146  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 = 75108 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1753 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0147  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 `tables2024` 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 = 75108 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 `tables2023` 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 = 71314 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 64968 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 48899 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 48565 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 38037 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 15578 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 12489 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 15165 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15167 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15169 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 15171 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 15173 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 15175 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15177 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 15180 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 23:34:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 23:34:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 23:34:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 23:34:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0167  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 events2024 e ON e.player_id = p.id AND e.league_id = 75108 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75108 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.0170  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 events2024 e ON e.player_id = p.id AND e.league_id = 75108 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75108 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  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 events2024 e ON e.player_id = p.id AND e.league_id = 75108 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75108 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 75108 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC