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

Vis Pesaro

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cesena	38	80	19	96
2	Sassari	38	56	38	75
3	Carrarese	38	54	30	73
4	Perugia	38	44	35	63
5	Gubbio 1910	38	50	38	59
6	Pescara	38	60	55	55
7	Juventus	38	50	44	54
8	SS Arezzo	38	46	44	53
9	Pontedera	38	53	54	52
10	Rimini	38	52	54	50
11	SPAL	38	41	40	49
12	Lucchese	38	34	43	45
13	Virtus	38	33	35	45
14	Pineto	38	38	42	45
15	Sestri	38	42	55	44
16	Ancona	38	41	51	42
17	Vis Pesaro	38	39	47	39
18	Recanatese	38	47	65	38
19	Fermana	38	30	59	31
20	Olbia Calcio	38	25	67	26

TEMPORADA 2022/2023

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Reggiana	38	63	27	81
2	Cesena	38	66	24	79
3	Virtus	38	60	31	79
4	Carrarese	38	51	42	62
5	Gubbio 1910	38	50	34	61
6	Pontedera	38	48	39	60
7	Ancona	38	55	44	58
8	Lucchese	38	36	32	51
9	Siena	38	40	40	48
10	Rimini	38	43	41	47
11	Recanatese	38	39	43	47
12	Fermana	38	43	49	44
13	Olbia Calcio	38	43	50	41
14	Fiorenzuola	38	31	44	41
15	Sassari	38	33	36	41
16	Vis Pesaro	38	24	55	39
17	Alessandria	38	33	52	38
18	Donato	38	40	62	37
19	Imolese	38	29	55	30
20	Montevarchi	38	32	59	28

TEMPORADA 2021/2022

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Modena	38	69	25	88
2	Reggiana	38	72	26	86
3	Cesena	38	53	31	67
4	Virtus	38	62	40	65
5	Pescara	38	56	41	65
6	Ancona	38	61	50	57
7	Gubbio 1910	38	53	44	52
8	Lucchese	38	39	39	50
9	Olbia Calcio	38	44	47	46
10	Carrarese	38	39	55	45
11	Vis Pesaro	38	35	56	45
12	Montevarchi	38	41	55	45
13	Siena	38	40	41	44
14	Pontedera	38	38	56	43
15	Teramo	38	36	57	42
16	Viterbese	38	44	51	39
17	Imolese	38	42	56	37
18	Pistoiese	38	40	59	36
19	Fermana	38	31	49	35
20	Grosseto	38	30	47	30

TEMPORADA 2020/2021

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Perugia	38	67	30	79
2	Padova	38	68	26	79
3	Südtirol	38	66	29	75
4	Modena	38	51	28	70
5	Feralpisalò	38	54	46	60
6	Triestina	38	48	40	59
7	Cesena	38	51	42	57
8	Matelica	38	59	62	56
9	Sambenedette	38	43	43	54
10	Mantova	38	47	49	49
11	Virtus	38	43	44	49
12	Gubbio 1910	38	40	45	48
13	Fermana	38	31	44	42
14	Vis Pesaro	38	41	57	41
15	AC Carpi	38	45	62	41
16	Legnago	38	35	47	38
17	Imolese	38	34	55	35
18	Fano	38	32	47	33
19	Ravenna FC	38	32	62	30
20	SS Arezzo	38	37	66	29

TEMPORADA 2019/2020

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vicenza	27	41	12	61
2	Reggiana	27	45	25	55
3	AC Carpi	26	44	21	53
4	Südtirol	27	43	24	48
5	Feralpisalò	26	34	31	44
6	Padova	26	35	19	44
7	Piacenza	26	32	24	41
8	Modena	27	29	25	40
9	Triestina	27	36	32	40
10	Fermana	27	22	33	33
11	Sambenedette	26	31	31	33
12	Virtus	27	33	35	32
13	Cesena	27	33	42	30
14	Gubbio 1910	27	23	31	28
15	Vis Pesaro	27	22	37	28
16	Ravenna FC	27	25	41	27
17	Imolese	27	20	35	23
18	Arzignano	26	18	32	22
19	Fano	27	24	42	21
20	Rimini	27	24	42	21

TEMPORADA 2018/2019

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pordenone	38	56	32	73
2	Triestina	38	60	33	67
3	Imolese	38	51	33	62
4	Feralpisalò	38	50	41	62
5	AC Monza	38	45	35	60
6	Südtirol	38	42	33	55
7	Ravenna FC	38	39	38	55
8	Vicenza	38	43	38	51
9	Sambenedette	38	40	40	50
10	Fermana	38	21	35	47
11	Ternana	38	39	40	44
12	Gubbio 1910	38	35	45	44
13	AlbinoLeffe	38	31	35	43
14	Teramo	38	36	46	43
15	Vis Pesaro	38	29	31	42
16	Giana	38	42	50	42
17	Renate	38	23	33	39
18	Rimini	38	28	44	39
19	Virtus	38	36	50	38
20	Fano	38	18	32	38

TEMPORADA 2017/2018

SERIE D GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Vibonese	1	4	0	3
2	Gozzano	1	2	0	3
3	Vis Pesaro	2	1	4	0
4	Pro Patria	1	3	1	3
5	Virtus	2	1	5	0
6	Albissola	2	6	4	4
7	Rimini	2	6	5	4
8	Rieti	1	0	0	1
9	Potenza	2	0	4	1

TEMPORADA 2016/2017

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Fermana	32	51	28	69
2	Matelica	32	56	30	63
3	Notaresco	32	53	29	60
4	Vis Pesaro	32	48	32	53
5	Olympia	32	45	33	51
6	Sammaurese	32	37	25	50
7	Monticelli	32	37	33	47
8	Vastese	32	43	32	45
9	Marino	32	43	38	41
10	Jesina	32	35	44	40
11	Romagna	32	34	42	39
12	Pineto	32	35	44	39
13	Città	32	32	44	38
14	Alfonsine	32	33	45	30
15	Castelfidard	32	28	44	28
16	Recanatese	32	30	50	27
17	Civitanovese	32	22	69	17
18	Chieti	0	0	0	0

TEMPORADA 2015/2016

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Sambenedette	34	76	36	81
2	Fano	34	49	29	68
3	Città	34	48	27	61
4	Matelica	34	57	37	58
5	Fermana	34	50	39	55
6	Chieti	34	49	38	49
7	Recanatese	34	45	50	48
8	Jesina	34	39	46	47
9	Notaresco	34	49	42	46
10	Avezzano	34	51	52	44
11	Vis Pesaro	34	40	42	43
12	Castelfidard	34	33	40	42
13	Olympia	34	47	49	40
14	Monticelli	34	42	48	37
15	Isernia	34	27	49	37
16	Folgore	34	34	52	32
17	Real	34	27	63	27
18	Amiternina	34	34	58	24

TEMPORADA 2014/2015

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Maceratese	34	61	22	78
2	Fano	34	60	25	74
3	Sambenedette	34	71	40	63
4	Città	34	49	42	57
5	Notaresco	34	59	46	52
6	Chieti	34	52	46	50
7	Civitanovese	34	56	51	50
8	Matelica	34	36	34	45
9	Real	34	44	43	45
10	Jesina	34	40	38	42
11	Fermana	34	37	44	42
12	Recanatese	34	37	44	39
13	Termoli	34	31	53	39
14	Amiternina	34	30	45	38
15	Olympia	34	31	51	31
16	Castelfidard	34	25	49	31
17	Vis Pesaro	34	35	45	29
18	Celano	34	23	59	17

TEMPORADA 2013/2014

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Ancona	34	69	18	78
2	Matelica	34	64	29	68
3	Termoli	34	66	28	67
4	Maceratese	34	61	34	64
5	Vis Pesaro	34	53	38	49
6	Recanatese	34	53	39	49
7	Celano	34	46	26	46
8	Jesina	34	51	48	46
9	Fermana	34	48	40	45
10	Fano	34	37	31	44
11	Real	34	45	41	44
12	Civitanovese	34	36	32	44
13	Olympia	34	41	47	43
14	Amiternina	34	38	40	40
15	Sulmona	34	40	53	40
16	Isernia	34	29	57	28
17	RC Angolana	34	34	53	26
18	Bojano	34	9	166	4

TEMPORADA 2012/2013

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Sambenedette	34	75	35	71
2	Termoli	34	74	39	68
3	Cesareo	34	69	44	68
4	Maceratese	34	58	39	64
5	Vis Pesaro	34	47	25	57
6	Olympia	34	68	56	53
7	Ancona	34	54	43	53
8	Astrea	34	53	47	50
9	Jesina	34	50	47	46
10	Civitanovese	34	34	45	42
11	Amiternina	34	39	49	40
12	Fidene	34	41	52	40
13	Isernia	34	46	65	38
14	RC Angolana	34	35	53	37
15	Celano	34	32	42	33
16	Recanatese	34	28	51	29
17	Notaresco	34	36	62	22
18	Città	34	33	78	20

TEMPORADA 2011/2012

SERIE D GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Teramo	34	86	29	73
2	Sambenedette	34	57	31	72
3	Civitanovese	34	60	33	68
4	Isernia	34	46	35	60
5	Atletico	34	60	46	59
6	Notaresco	34	43	40	50
7	Jesina	34	48	33	48
8	Olympia	34	64	56	48
9	Recanatese	34	41	36	46
10	Vis Pesaro	34	45	47	44
11	Riccione	34	52	56	39
12	Atessa	34	40	49	39
13	RC Angolana	34	34	45	36
14	Santegidiese	34	48	62	36
15	Miglianico	34	32	57	24
16	Luco	34	22	71	19
17	Real Rimini	34	16	105	6

TEMPORADA 2004/2005

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rimini	34	50	23	70
2	Avellino	34	48	29	64
3	Napoli	34	45	31	61
4	Reggiana	34	41	24	54
5	Sambenedette	34	38	25	54
6	Padova	34	46	39	48
7	Virtus	34	36	38	46
8	Benevento	34	31	38	45
9	SPAL	34	36	33	43
10	Calcio	34	36	35	42
11	Martina	34	31	41	42
12	Cittadella	34	36	37	41
13	Teramo	34	32	37	40
14	Fermana	34	30	45	39
15	Sora	34	35	42	36
16	Real	34	20	43	31
17	Chieti	34	19	32	30
18	Vis Pesaro	34	21	39	25

TEMPORADA 2003/2004

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Catanzaro	34	44	25	67
2	Crotone	34	57	33	65
3	Viterbese	34	45	29	61
4	Acireale	34	40	26	60
5	Benevento	34	41	28	56
6	Virtus	34	34	31	53
7	Sambenedette	34	50	40	52
8	Chieti	34	39	35	48
9	Calcio	34	43	43	46
10	Teramo	34	40	41	45
11	Martina	34	45	50	42
12	Real	34	35	39	41
13	Sora	34	27	35	41
14	Fermana	34	34	46	40
15	Vis Pesaro	34	31	48	36
16	Paternò	34	32	47	32
17	Taranto	34	31	46	30
18	L'Aquila	34	26	52	13

TEMPORADA 2002/2003

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pescara	34	64	36	69
2	Avellino	34	51	25	69
3	Martina	34	52	37	62
4	Teramo	34	58	40	58
5	Sambenedette	34	46	26	56
6	Crotone	34	40	29	50
7	Virtus	34	39	39	49
8	Benevento	34	27	32	44
9	Taranto	34	31	35	41
10	Chieti	34	28	32	41
11	Viterbese	34	37	50	39
12	Sassari	34	34	37	38
13	Vis Pesaro	34	29	40	36
14	Real	34	29	37	35
15	Paternò	34	31	46	35
16	Sora	34	36	48	34
17	L'Aquila	34	30	53	33
18	Fermana	34	28	48	32

TEMPORADA 2001/2002

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ascoli	34	55	26	67
2	Taranto	34	50	30	62
3	Catania	34	44	26	58
4	Pescara	34	48	29	53
5	Real	34	44	31	51
6	Virtus	34	36	30	51
7	Avellino	35	40	43	48
8	Chieti	34	28	27	47
9	Fermana	34	32	33	46
10	L'Aquila	35	33	46	46
11	Viterbese	34	33	35	44
12	Sassari	34	41	35	43
13	Vis Pesaro	34	32	32	43
14	Castel	34	27	37	39
15	Benevento	34	27	38	39
16	Nocerina	34	32	59	30
17	Sora	34	21	39	29
18	Lodigiani	34	24	51	23

TEMPORADA 2000/2001

SERIE C GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Palermo FC	34	47	31	64
2	ACR Messina	34	40	26	61
3	Catania	34	49	40	58
4	Avellino	34	45	27	57
5	Ascoli	34	47	33	54
6	Sassari	34	55	45	53
7	Castel	34	44	40	47
8	L'Aquila	34	37	35	46
9	Fermana	34	41	38	42
10	Real	34	36	40	42
11	Vis Pesaro	34	26	29	39
12	Lodigiani	34	34	44	39
13	Benevento	34	40	54	39
14	Nocerina	34	29	42	36
15	Viterbese	34	32	48	29
16	Atl. Catania	34	27	44	27

Competiciones que juega

Grupo 2

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C

USO DE MEMORIA

7,577,800 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1410
Total Execution Time	0.1423

CADENA URL

/historico/Vis-Pesaro

GET DATOS

$_GET['/historico/Vis-Pesaro']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0029	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Vis-Pesaro' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2964 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2964 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2964 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2964 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2964 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2964 AND type_rel = 2
0.0026	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '2964' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '2964' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75938 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=2964 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75938,74153,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 75938 AND teamId = 2964
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 2964
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2964
0.0022	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2964' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2964' and rp.type = 4
0.0021	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2964' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 75938 WHERE rp.league_id = 75938 AND rp.teamId = 2964 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 75938 WHERE rp.league_id = 75938 AND rp.teamId = 2964 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 75938 WHERE rp.league_id = 75938 AND rp.teamId = 2964 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 2964 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039	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 = 72300 AND t.round = 38 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* `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 = 68592 AND t.round = 38 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* `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 = 63825 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 58761 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 51022 AND t.round = 27 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* `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 = 44232 AND t.round = 38 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* `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 = 39599 AND t.round = 34 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* `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 = 43432 AND t.round = 3 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* `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 = 33454 AND t.round = 34 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* `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 = 15654 AND t.round = 34 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* `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 = 4819 AND t.round = 34 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* `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 = 24680 AND t.round = 34 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* `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 = 2095 AND t.round = 34 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 = 1696 AND t.round = 34 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* `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 = 583 AND t.round = 34 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* `tables2004` 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 = 585 AND t.round = 34 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* `tables2003` 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 = 587 AND t.round = 34 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* `tables2002` 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 = 589 AND t.round = 34 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* `tables2001` 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 = 591 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Vis Pesaro

Vis Pesaro

Selecciona un equipo

Competiciones que juega

RIVALES EN Coppa Italia Ser.

RIVALES EN Serie C