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

2023/2024

Temporada Regular

Catarinense 1 2024

Ver

TEMPORADA 2023/2024

Equipo		PJ	GF	GC	Puntos
1	Criciúma	11	17	7	25
2	Avaí	11	20	17	20
3	Marcílio	11	15	14	20
4	Figueirense	11	11	10	18
5	Barra FC	11	15	9	17
6	Brusque	11	13	8	17
7	Joinville	11	17	15	15
8	Hercílio	11	14	12	14
9	Chapecoense	11	13	16	11
10	Concórdia	11	8	16	11
11	Internaciona	11	12	18	8
12	Naçao	11	10	23	5

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	Hercílio	11	9	3	22
2	Chapecoense	11	16	7	20
3	Brusque	11	11	6	19
4	Criciúma	11	12	6	18
5	Avaí	11	18	14	17
6	Concórdia	11	9	5	16
7	Barra FC	11	10	14	13
8	Joinville	11	10	6	12
9	Figueirense	11	11	13	12
10	Marcílio	11	8	15	11
11	Camboriú	11	7	14	11
12	Atletico	11	2	20	1

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Brusque	11	20	11	24
2	Hercílio	11	13	7	21
3	Camboriú	11	11	6	21
4	Concórdia	11	13	8	20
5	Chapecoense	11	10	13	16
6	Marcílio	11	19	15	15
7	Figueirense	11	15	14	15
8	Avaí	11	8	9	12
9	Joinville	11	9	15	11
10	Barra FC	11	12	14	10
11	Próspera	11	8	15	10
12	Juventus SC	11	7	18	7

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Chapecoense	11	23	6	26
2	Brusque	11	19	9	22
3	Avaí	11	10	5	21
4	Juventus SC	11	16	17	18
5	Marcílio	11	11	9	15
6	Próspera	11	10	16	14
7	Joinville	11	10	13	13
8	Hercílio	11	12	18	12
9	Figueirense	11	12	11	11
10	Concórdia	11	11	15	10
11	Criciúma	11	6	10	8
12	Metropolitan	11	8	19	6

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Avaí	9	12	6	17
2	Brusque	9	13	9	17
3	Figueirense	9	8	5	15
4	Marcílio	9	9	9	15
5	Criciúma	9	9	9	13
6	Juventus SC	9	10	10	11
7	Chapecoense	9	8	6	10
8	Joinville	9	13	17	10
9	Concórdia	9	10	12	7
10	CA Tubarão	9	5	14	6

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Avaí	18	34	7	39
2	Figueirense	18	22	13	32
3	Chapecoense	18	25	20	32
4	Marcílio	18	18	14	27
5	Criciúma	18	15	15	27
6	Brusque	18	17	21	20
7	Joinville	18	16	20	20
8	CA Tubarão	18	16	24	17
9	Metropolitan	18	13	32	16
10	Hercílio	18	19	29	13

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Chapecoense	18	25	8	41
2	Figueirense	18	24	14	36
3	CA Tubarão	18	26	21	26
4	Criciúma	18	20	18	26
5	Joinville	18	20	21	24
6	Avaí	18	22	21	24
7	Brusque	18	20	23	20
8	Hercílio	18	16	23	17
9	Internaciona	18	18	27	17
10	Concórdia	18	19	34	13

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Avaí	9	14	3	21
2	Chapecoense	9	13	8	17
3	Brusque	9	12	12	16
4	Criciúma	9	17	16	13
5	Figueirense	9	14	12	13
6	CA Tubarão	9	11	10	11
7	Internaciona	9	11	12	11
8	Metropolitan	9	10	15	8
9	Joinville	9	4	10	7
10	Almirante	9	11	19	6

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Chapecoense	9	13	3	23
2	Avaí	9	15	8	17
3	Criciúma	9	13	8	17
4	Internaciona	9	15	10	15
5	Brusque	9	10	12	12
6	Figueirense	9	7	10	9
7	Joinville	9	8	11	8
8	Metropolitan	9	7	17	8
9	Camboriú	9	14	14	7
10	Guarani	9	8	17	4

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Chapecoense	9	17	3	20
2	Figueirense	9	13	9	19
3	Metropolitan	9	12	10	15
4	Criciúma	9	12	11	13
5	Internaciona	9	12	15	12
6	Joinville	9	7	8	11
7	Guarani	9	14	15	10
8	Marcílio	9	11	15	8
9	Avaí	9	10	14	7
10	Hermann	9	8	16	6

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Metropolitan	9	17	12	18
2	Criciúma	9	10	7	16
3	Joinville	9	14	8	15
4	Figueirense	9	12	7	15
5	Chapecoense	9	12	10	15
6	Brusque	9	13	7	14
7	Marcílio	9	11	13	10
8	Avaí	9	11	14	7
9	Juventus SC	9	10	21	7
10	Hermann	9	9	20	7

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Chapecoense	18	27	16	35
2	Figueirense	18	30	21	32
3	Criciúma	18	42	22	29
4	Avaí	18	30	28	29
5	Metropolitan	18	25	26	26
6	Joinville	18	38	27	24
7	Hermann	18	26	19	24
8	Juventus SC	18	22	43	19
9	Guarani	18	17	32	18
10	Camboriú	18	16	39	12

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Figueirense	9	27	12	20
2	Chapecoense	9	14	9	18
3	Metropolitan	9	16	13	16
4	Avaí	9	14	11	15
5	Hermann	9	16	13	14
6	Joinville	9	17	14	12
7	Criciúma	9	21	19	12
8	Camboriú	9	7	14	9
9	Marcílio	9	9	22	6
10	Brusque	9	4	18	4

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Figueirense	9	23	12	16
2	Criciúma	9	18	9	15
3	Chapecoense	9	18	16	15
4	Marcílio	9	15	12	13
5	Joinville	9	16	20	13
6	Brusque	9	18	17	12
7	Metropolitan	9	12	12	11
8	Avaí	9	11	15	11
9	Imbituba	9	12	18	9
10	Concórdia	9	15	27	6

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Joinville	9	18	12	19
2	Avaí	9	20	11	18
3	Hermann	9	15	10	17
4	Metropolitan	9	10	8	15
5	Imbituba	9	16	15	15
6	Figueirense	9	18	14	14
7	Criciúma	9	13	16	11
8	Brusque	9	12	17	9
9	Chapecoense	9	14	16	8
10	Juventus SC	9	6	23	2

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Criciúma	9	24	16	19
2	Hermann	9	16	9	18
3	Joinville	9	16	9	16
4	Brusque	9	13	10	15
5	Chapecoense	9	19	16	13
6	Avaí	9	12	11	13
7	Figueirense	9	11	12	12
8	Marcílio	9	9	13	10
9	Metropolitan	9	8	16	4
10	CA Tubarão	9	8	24	4

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Figueirense	11	28	13	25
2	Criciúma	11	26	16	23
3	Avaí	11	29	11	22
4	Metropolitan	10	22	18	18
5	Guarani	11	13	19	15
6	Chapecoense	11	20	18	14
7	Marcílio	11	13	14	13
8	Hermann	10	13	15	13
9	Joinville	11	10	15	11
10	Juventus SC	11	12	30	9
11	Brusque	11	14	22	8
12	CA Tubarão	11	22	31	6

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Criciúma	22	51	22	54
2	Chapecoense	22	38	23	46
3	Hermann	22	37	28	37
4	Avaí	22	41	31	36
5	Figueirense	22	40	32	33
6	Juventus SC	22	44	40	29
7	Guarani	22	32	39	27
8	Brusque	22	30	31	23
9	Metropolitan	22	29	40	23
10	Marcílio	22	24	39	19
11	Joinville	22	31	48	19
12	Próspera	22	30	54	19

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	Figueirense	10	19	9	21
2	Juventus SC	10	22	14	19
3	Avaí	10	22	11	16
4	Hermann	10	12	17	11
5	Guarani	10	9	24	10
6	Chapecoense	10	11	20	6
7	Brusque	10	27	15	23
8	Metropolitan	10	17	13	16
9	Marcílio	10	13	10	16
10	Joinville	10	19	17	14
11	Criciúma	10	19	15	13
12	Caxias	10	9	34	2

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Hermann	10	21	10	25
2	Avaí	10	18	10	22
3	Figueirense	10	28	10	18
4	Guarani	10	16	18	13
5	Chapecoense	10	11	20	8
6	União	10	11	37	0
7	Joinville	10	18	9	21
8	Metropolitan	10	11	9	16
9	Marcílio	10	15	17	15
10	Criciúma	10	15	12	13
11	CA Lages	10	10	14	10
12	CA Tubarão	10	16	24	5

Equipos de esta liga

USO DE MEMORIA

6,339,728 bytes

BENCHMARKS

Loading Time Base Classes	0.0029
Controller Execution Time ( Home / Category )	0.7986
Total Execution Time	0.8017

CADENA URL

/catarinense_12024/grupo1/historico

GET DATOS

$_GET['/catarinense_12024/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0144	SELECT type FROM routes WHERE alias = 'catarinense_12024'
0.0292	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'catarinense_1' 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.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=566 AND type_rel = 3
0.0151	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 566 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 (968664,963158,954743,886552,858654) ORDER BY n.cover_points DESC, update_date DESC
0.0146	SELECT id,name,alias,stepParent FROM categories WHERE parentId=566 ORDER BY order_id ASC
0.0155	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 = 74836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 566 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0163	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 = 74836 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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 = 70570 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 66076 AND t.round = 11 ORDER BY team.conference ASC,t.position 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* `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 = 60883 AND t.round = 11 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* `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 = 53452 AND t.round = 9 ORDER BY team.conference ASC,t.position 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* `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 = 48174 AND t.round = 18 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* `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 = 41682 AND t.round = 18 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* `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 = 37539 AND t.round = 9 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* `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 = 19979 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 9111 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* `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 = 3491 AND t.round = 9 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* `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 = 13885 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 13887 AND t.round = 9 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 = 13890 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 13893 AND t.round = 9 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* `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 = 13896 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 13900 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 13903 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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* `tables2006` 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 = 13905 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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* `tables2005` 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 = 13908 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:49:31' 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=2 AND last_update > '2024-04-28 08:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 08:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0161	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'catarinense_1' AND (l.group_code = 0 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=0 DESC LIMIT 1
0.0178	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 566 AND l.year = 2024
0.0166	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74836,75524) 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, e.player_id ASC LIMIT 10
0.0174	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74836,75524) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (696539,229055,312427,367077,833723,232091,316295,587227,651888,851730) ORDER BY rp.in_squad = 1 DESC
0.0179	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 566 AND l.year = 2024
0.0178	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74836,75524) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0157	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74836,75524) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (218759,369426,228353,274433,362325,731502,27392,240261,249098,298107) ORDER BY rp.in_squad = 1 DESC
0.0152	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 566 AND l.year = 2024
0.0146	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74836,75524) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0152	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (74836,75524) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (474196,132747,166538,171304,218759,229558,244367,249084,249098,267713) ORDER BY rp.in_squad = 1 DESC
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 = 74836 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC