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

Resultados de Fútbol

« Temporada Anterior

Temporada 2022

Temporada Siguiente »

2021/2022

Fase de Grupos

Eliminatoria

Copa de la Liga de Escocia 2022

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Heart	4	8	0	12
2	Stirling	4	8	7	7
3	Inverness	4	5	6	4
4	Cove Rangers	4	6	10	3
5	Peterhead	4	4	8	3
6	Dundee	4	9	1	12
7	Arbroath	4	6	3	9
8	Kelty Hearts	4	8	5	6
9	Elgin City	4	5	12	3
10	East Fife	4	2	9	0
11	Dundee	4	14	2	12
12	Forfar	4	6	5	7
13	Ross County	4	5	7	6
14	Montrose	4	4	6	4
15	Brora	4	0	9	0
16	Raith Rovers	4	5	0	8
17	Livingston	4	7	3	7
18	Cowdenbeath	4	5	6	6
19	Alloa	4	2	3	4
20	Brechin City	4	3	10	3
21	Ayr United	4	7	0	10
22	Hamilton	4	5	4	7
23	Edinburgh	4	4	5	4
24	Falkirk	4	6	9	3
25	Albion	4	4	8	3
26	Motherwell	4	6	4	9
27	Queen's Park	4	3	2	7
28	Queen South	4	9	6	6
29	Airdrieonian	4	4	5	5
30	Annan	4	3	8	1
31	Kilmarnock	4	7	3	10
32	Stranraer	4	5	3	6
33	Greenock	4	3	5	5
34	Clyde	4	5	6	4
35	East	4	2	5	2
36	St. Mirren	4	9	1	12
37	Dunfermline	4	13	5	9
38	Partick	4	6	7	6
39	Stenhousemui	4	5	10	3
40	Dumbarton	4	2	12	0

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Heart	4	8	3	12
2	Raith Rovers	4	7	7	7
3	Inverness	4	4	4	5
4	East Fife	4	5	6	3
5	Cowdenbeath	4	0	4	1
6	Hibernian	4	10	3	12
7	Dundee	4	9	4	9
8	Cove Rangers	4	4	7	4
9	Brora	4	6	10	2
10	Forfar	4	3	8	1
11	Johnstone	4	12	2	10
12	Dundee	4	7	3	7
13	Peterhead	4	6	5	7
14	Kelty Hearts	4	4	4	4
15	Brechin City	4	3	18	0
16	Ross County	4	12	5	10
17	Arbroath	4	9	4	9
18	Elgin City	4	5	7	6
19	Stirling	4	3	8	3
20	Montrose	4	5	10	1
21	Dunfermline	4	9	2	12
22	Falkirk	4	9	3	9
23	Kilmarnock	4	4	6	6
24	Clyde	4	6	9	3
25	Dumbarton	4	2	10	0
26	Annan	4	9	4	7
27	Ayr United	4	8	5	7
28	Hamilton	4	7	6	6
29	Stranraer	4	6	5	6
30	Albion	4	5	15	1
31	St. Mirren	4	8	4	8
32	Queen South	4	7	5	6
33	Greenock	4	4	3	6
34	Partick	4	3	4	5
35	Queen's Park	4	1	7	0
36	Livingston	4	15	3	12
37	Alloa	4	9	5	9
38	Edinburgh	4	5	9	4
39	Airdrieonian	4	3	7	3
40	Stenhousemui	4	4	12	1

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Heart	4	6	3	8
2	Dundee	4	6	4	7
3	East Fife	4	5	3	7
4	Stenhousemui	4	4	6	3
5	Cowdenbeath	4	2	7	3
6	Ross County	4	12	2	12
7	Forfar	4	9	4	9
8	Montrose	4	4	9	4
9	Johnstone	4	6	5	3
10	Brechin City	4	1	12	1
11	Hibernian	4	8	1	10
12	Alloa	4	8	8	7
13	Arbroath	4	10	8	6
14	Elgin City	4	7	7	4
15	Stirling	4	3	12	1
16	Dundee	4	4	0	8
17	Inverness	4	7	4	7
18	Peterhead	4	3	4	5
19	Cove Rangers	4	6	5	4
20	Raith Rovers	4	4	11	3
21	Motherwell	4	13	0	12
22	Greenock	4	14	8	7
23	Queen South	4	10	10	5
24	Dumbarton	4	3	12	3
25	Annan	4	3	13	1
26	Partick	4	8	5	10
27	Hamilton	4	8	5	8
28	Airdrieonian	4	7	8	4
29	Queen's Park	4	4	5	3
30	Clyde	4	6	10	1
31	Livingston	4	10	3	10
32	Ayr United	4	12	5	7
33	Falkirk	4	6	3	7
34	Stranraer	4	9	5	4
35	Berwick	4	0	21	0
36	Dunfermline	4	13	3	9
37	Albion	4	3	7	7
38	St. Mirren	4	3	3	5
39	East	4	1	5	4
40	Edinburgh	4	2	4	3

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Ross County	4	6	4	9
2	Arbroath	4	9	6	7
3	Alloa	4	8	5	7
4	Dundee	4	6	3	5
5	Elgin City	4	0	11	0
6	Johnstone	4	5	1	10
7	Falkirk	4	4	3	6
8	Montrose	4	3	4	6
9	Forfar	4	5	7	4
10	East Fife	4	2	4	2
11	Heart	4	13	2	10
12	Inverness	4	9	8	9
13	Cowdenbeath	4	5	10	6
14	Cove Rangers	4	3	5	3
15	Raith Rovers	4	2	7	1
16	Dunfermline	4	14	2	12
17	Dundee	4	8	1	9
18	Brechin City	4	3	10	4
19	Stirling	4	4	9	3
20	Peterhead	4	0	7	1
21	Ayr United	4	12	1	12
22	Partick	4	6	3	9
23	Greenock	4	9	5	6
24	Stenhousemui	4	4	9	3
25	Albion	4	0	13	0
26	Livingston	4	5	1	10
27	Airdrieonian	4	9	4	7
28	Annan	4	6	5	6
29	Hamilton	4	5	2	5
30	Berwick	4	0	13	0
31	Motherwell	4	11	2	10
32	Queen South	4	12	5	9
33	Clyde	4	5	8	4
34	Edinburgh	4	5	12	4
35	Stranraer	4	7	13	1
36	Kilmarnock	4	9	2	10
37	St. Mirren	4	8	2	6
38	Queen's Park	4	2	4	4
39	Dumbarton	4	3	10	4
40	Spartans	4	3	7	2

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Falkirk	4	13	1	12
2	Inverness	4	5	3	7
3	Stirling	4	6	5	7
4	Forfar	4	3	10	1
5	Brechin City	4	1	9	1
6	Peterhead	4	7	6	9
7	Dunfermline	4	13	3	8
8	Heart	4	7	4	7
9	East Fife	4	3	6	4
10	Elgin City	4	2	13	0
11	Dundee	4	10	2	10
12	Dundee	4	8	2	10
13	Raith Rovers	4	9	5	6
14	Cowdenbeath	4	5	11	3
15	Buckie	4	3	15	0
16	Hibernian	4	13	1	10
17	Ross County	4	8	0	8
18	Arbroath	4	6	7	5
19	Montrose	4	2	15	3
20	Alloa	4	2	8	1
21	Ayr United	4	15	3	12
22	Kilmarnock	4	9	3	9
23	Clyde	4	7	11	6
24	Dumbarton	4	2	8	1
25	Annan	4	2	10	1
26	Motherwell	4	12	2	12
27	Greenock	4	8	6	7
28	Queen's Park	4	9	9	7
29	Berwick	4	4	7	1
30	Edinburgh	4	3	12	1
31	Hamilton	4	11	6	8
32	Albion	4	12	9	6
33	Queen South	4	6	4	6
34	East	4	5	9	4
35	Stenhousemui	4	3	9	1
36	Partick	4	9	2	10
37	Livingston	4	8	3	10
38	St. Mirren	4	9	7	6
39	Airdrieonian	4	4	10	3
40	Stranraer	4	4	12	0

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Peterhead	4	8	6	9
2	Dundee	4	15	5	8
3	East Fife	4	5	4	6
4	Forfar	4	4	11	3
5	Dumbarton	4	7	13	2
6	Johnstone	4	11	2	9
7	Falkirk	4	5	4	6
8	Stirling	4	6	7	6
9	Brechin City	4	5	8	6
10	Elgin City	4	6	12	3
11	Inverness	4	15	3	9
12	Dundee	4	10	3	8
13	Dunfermline	4	7	7	6
14	Cowdenbeath	4	4	11	3
15	Arbroath	4	1	13	1
16	Alloa	4	10	2	12
17	Ross County	4	11	4	10
18	Raith Rovers	4	5	4	6
19	Cove Rangers	4	4	13	3
20	Montrose	4	1	8	0
21	Partick	4	9	2	12
22	Queen South	4	6	2	9
23	Airdrieonian	4	5	7	6
24	Queen's Park	4	5	7	6
25	Stenhousemui	4	2	9	0
26	Rangers FC	4	10	0	12
27	Motherwell	4	9	3	9
28	Stranraer	4	5	8	6
29	Annan	4	4	7	3
30	East	4	1	11	0
31	Hamilton	4	10	5	9
32	Ayr United	4	5	2	9
33	St. Mirren	4	7	5	9
34	Livingston	4	6	7	3
35	Edinburgh	4	2	11	0
36	Greenock	4	5	0	9
37	Kilmarnock	4	5	5	7
38	Berwick	4	3	6	5
39	Clyde	4	4	5	4
40	Albion	4	1	2	2

Ver

TEMPORADA 1982/1983

Equipo		PJ	GF	GC	Puntos
1	Dundee	6	20	5	16
2	Motherwell	6	11	14	7
3	Alloa	6	10	15	7
4	Greenock	6	7	14	4

Ver

TEMPORADA 1981/1982

Equipo		PJ	GF	GC	Puntos
1	Celtic	6	29	3	18
2	Arbroath	6	4	9	7
3	Alloa	6	7	13	6
4	Dunfermline	6	3	18	4

Ver

TEMPORADA 1980/1981

Equipo		PJ	GF	GC	Puntos
1	St. Mirren	6	10	8	13
2	Celtic	6	18	9	12
3	Johnstone	6	8	12	6
4	Hibernian	6	5	12	4

Ver

TEMPORADA 1975/1976

Equipo		PJ	GF	GC	Puntos
1	Heart	6	15	8	13
2	Dundee	6	9	10	10
3	Partick	6	8	7	8
4	Motherwell	6	7	14	2

Ver

TEMPORADA 1974/1975

Equipo		PJ	GF	GC	Puntos
1	Rangers FC	6	18	5	14
2	Motherwell	6	10	6	11
3	Airdrieonian	6	7	14	6
4	Clyde	6	4	14	3

Ver

TEMPORADA 1973/1974

Equipo		PJ	GF	GC	Puntos
1	Partick	6	13	8	10
2	Dumbarton	6	11	11	8
3	Clyde	6	9	11	8
4	Arbroath	6	8	11	7

Ver

TEMPORADA 1972/1973

Equipo		PJ	GF	GC	Puntos
1	Rangers FC	6	17	6	15
2	Celtic	6	12	7	15
3	Arbroath	6	9	13	6
4	Falkirk	6	6	18	0

Ver

TEMPORADA 1971/1972

Equipo		PJ	GF	GC	Puntos
1	Partick	6	11	3	12
2	Stranraer	6	11	8	9
3	Greenock	6	11	9	8
4	Cowdenbeath	6	6	19	4

Ver

TEMPORADA 1970/1971

Equipo		PJ	GF	GC	Puntos

Ver

TEMPORADA 1969/1970

Equipo		PJ	GF	GC	Puntos
1	Celtic	6	17	10	14
2	Dundee	6	8	7	8
3	Clyde	6	8	15	5
4	Heart	6	10	11	4

Ver

TEMPORADA 1968/1969

Equipo		PJ	GF	GC	Puntos
1	Celtic	6	21	5	15
2	Rangers FC	6	14	7	13
3	Raith Rovers	6	10	20	4
4	Airdrieonian	6	5	18	3

Ver

TEMPORADA 1967/1968

Equipo		PJ	GF	GC	Puntos
1	Hibernian	6	10	3	13
2	Raith Rovers	6	7	8	8
3	Johnstone	6	8	9	6
4	Falkirk	6	8	13	5

Ver

TEMPORADA 1966/1967

Equipo		PJ	GF	GC	Puntos
1	Kilmarnock	6	11	5	11
2	Dunfermline	6	11	12	8
3	Airdrieonian	6	7	8	7
4	Partick	6	6	10	7

Ver

TEMPORADA 1965/1966

Equipo		PJ	GF	GC	Puntos
1	Aberdeen	6	20	7	18
2	Dundee	6	13	13	8
3	Dundee	6	8	11	5
4	Johnstone	6	6	16	2

Ver

TEMPORADA 1964/1965

Equipo		PJ	GF	GC	Puntos
1	Celtic	6	11	7	12
2	Motherwell	6	9	11	9
3	Dundee	6	7	7	7
4	Dundee	6	9	11	7

Ver

TEMPORADA 1963/1964

Equipo		PJ	GF	GC	Puntos
1	Rangers FC	6	26	7	16
2	St. Mirren	6	11	12	9
3	Aberdeen	6	11	15	6
4	Johnstone	6	5	19	1

Equipos de esta liga

USO DE MEMORIA

8,114,736 bytes

BENCHMARKS

Loading Time Base Classes	0.0022
Controller Execution Time ( Home / Category )	0.1611
Total Execution Time	0.1633

CADENA URL

/copa_liga_escocia2022/grupo1/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0019	SELECT type FROM routes WHERE alias = 'copa_liga_escocia2022'
0.0041	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_liga_escocia' 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.0024	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 = 62930 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1499 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 62930 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 58494 AND t.round = 8 ORDER BY team.conference ASC,t.position 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* `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 = 49970 AND t.round = 8 ORDER BY team.conference ASC,t.position 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* `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 = 43803 AND t.round = 8 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* `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 = 38683 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 31269 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1983` 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 = 25776 AND t.round = 6 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* `tables1982` 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 = 25644 AND t.round = 6 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* `tables1981` 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 = 25666 AND t.round = 6 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* `tables1976` 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 = 25711 AND t.round = 6 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* `tables1975` 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 = 25741 AND t.round = 6 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* `tables1974` 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 = 25800 AND t.round = 6 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* `tables1973` 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 = 25862 AND t.round = 6 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* `tables1972` 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 = 25886 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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* `tables1971` 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 = 25908 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1970` 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 = 25932 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1969` 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 = 25955 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1968` 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 = 25988 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1967` 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 = 26004 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1966` 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 = 25871 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1965` 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 = 25887 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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* `tables1964` 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 = 25914 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 05:00:03' 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-20 05:00:03' 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-20 05:00:03' 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-20 05:00:03' 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 = 'copa_liga_escocia' 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.0046	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1499 AND l.year = 2022
0.0022	SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62930,63468) 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.0027	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 (62930,63468) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (299670,160332,161028,201792,331893,66428,93942,160716,192455,201858) ORDER BY rp.in_squad = 1 DESC
0.0026	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1499 AND l.year = 2022
0.0021	SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62930,63468) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0022	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 (62930,63468) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (294787,297304,13136,30134,47279,160207,160233,160240,160636,160832) ORDER BY rp.in_squad = 1 DESC
0.0026	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1499 AND l.year = 2022
0.0021	SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (62930,63468) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0022	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 (62930,63468) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2726,141806,141923,141980,238010,295606) ORDER BY rp.in_squad = 1 DESC
0.0058	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 = 62930 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos