4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Virtus Francavilla

Virtus Francavilla

Entrenador: Nicola Antonio Calabro

Temporada 2020/2021
TEMPORADA 2020/2021
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Ternana Calcio Ternana 36 95 32 90
2 Catanzaro Catanzaro 36 44 29 68
3 Avellino Avellino 36 53 33 68
4 SSC Bari SSC Bari 36 52 34 63
5 Juve Stabia Juve Stabia 36 51 39 61
6 Catania Catania 36 50 38 59
7 Palermo FC Palermo FC 36 44 40 53
8 Teramo Teramo 36 38 34 52
9 Calcio Foggia Calcio 36 36 39 51
10 Casertana Casertana 36 47 59 45
11 Monopoli Monopoli 36 43 51 41
12 Viterbese Viterbese 36 36 42 40
13 Potenza Calcio Potenza 36 38 52 39
14 Turris Neapolis Turris 36 40 56 39
15 Virtus Francavilla Virtus 36 32 44 38
16 US Vibonese Calcio Vibonese 36 34 37 36
17 Paganese Paganese 36 26 49 32
18 Bisceglie Bisceglie 36 28 51 30
19 Cavese 1919 Cavese 1919 36 27 55 23
20 Trapani Trapani 0 0 0 0
TEMPORADA 2019/2020
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Reggina Reggina 30 54 19 69
2 SSC Bari SSC Bari 30 54 24 60
3 Monopoli Monopoli 30 40 22 57
4 Potenza Calcio Potenza 30 36 23 56
5 Ternana Calcio Ternana 30 38 29 51
6 Catania Catania 30 39 38 47
7 Catanzaro Catanzaro 30 41 36 43
8 Teramo Teramo 30 29 31 41
9 Virtus Francavilla Virtus 30 39 36 40
10 Avellino Avellino 30 34 38 40
11 US Vibonese Calcio Vibonese 30 48 37 39
12 Viterbese Viterbese 30 37 38 39
13 Cavese 1919 Cavese 1919 30 24 36 38
14 Casertana Casertana 30 37 35 38
15 Paganese Paganese 30 35 34 36
16 Picerno Picerno 30 29 38 32
17 Sicula Leonzio Sicula 30 31 46 29
18 Bisceglie Bisceglie 30 21 40 20
19 Rende Rende 30 19 50 18
20 Rieti Rieti 30 29 64 15
TEMPORADA 2018/2019
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Juve Stabia Juve Stabia 36 63 18 77
2 Trapani Trapani 36 60 34 73
3 Catanzaro Catanzaro 36 65 32 67
4 Catania Catania 36 48 29 65
5 Potenza Calcio Potenza 36 45 32 57
6 Reggina Reggina 36 45 33 56
7 Virtus Francavilla Virtus 36 42 39 55
8 Monopoli Monopoli 36 41 31 51
9 Casertana Casertana 36 46 38 51
10 Rende Rende 36 46 45 47
11 Cavese 1919 Cavese 1919 36 49 50 47
12 Viterbese Viterbese 36 39 44 45
13 Rieti Rieti 36 33 43 43
14 US Vibonese Calcio Vibonese 36 33 37 42
15 Sicula Leonzio Sicula 36 32 42 42
16 Siracusa Siracusa 36 34 44 41
17 Bisceglie Bisceglie 36 22 41 32
18 Paganese Paganese 36 36 72 23
19 Matera Matera 36 16 91 8
TEMPORADA 2017/2018
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Lecce Lecce 36 53 30 74
2 Catania Catania 36 65 31 70
3 Trapani Trapani 36 60 35 68
4 Juve Stabia Juve Stabia 36 49 35 55
5 Cosenza Cosenza 36 41 35 54
6 Monopoli Monopoli 36 46 35 53
7 Casertana Casertana 36 37 32 50
8 Rende Rende 36 31 35 50
9 Siracusa Siracusa 36 37 29 47
10 Matera Matera 36 40 37 46
11 Sicula Leonzio Sicula 36 37 37 46
12 Virtus Francavilla Virtus 36 35 43 46
13 Bisceglie Bisceglie 36 39 46 45
14 Catanzaro Catanzaro 36 35 45 42
15 Reggina Reggina 36 29 38 41
16 Fidelis Andria Fidelis 36 36 40 38
17 Paganese Paganese 36 36 56 33
18 Fondi Fondi 36 33 52 30
19 Akragas Akragas 36 18 66 6
TEMPORADA 2016/2017
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Calcio Foggia Calcio 38 70 29 85
2 Lecce Lecce 38 62 36 74
3 Matera Matera 38 71 44 65
4 Juve Stabia Juve Stabia 38 65 43 64
5 Siracusa Siracusa 38 47 43 57
6 Virtus Francavilla Virtus 38 47 45 57
7 Cosenza Cosenza 38 57 46 55
8 Paganese Paganese 38 51 45 51
9 Casertana Casertana 38 38 42 49
10 Fondi Fondi 38 49 46 49
11 Fidelis Andria Fidelis 38 30 33 47
12 Catania Catania 38 40 36 47
13 ACR Messina ACR Messina 38 38 52 46
14 Reggina Reggina 38 44 54 45
15 Monopoli Monopoli 38 42 54 42
16 Akragas Akragas 38 30 47 39
17 US Vibonese Calcio Vibonese 38 27 46 39
18 Catanzaro Catanzaro 38 36 49 38
19 Melfi Melfi 38 38 68 34
20 Taranto Taranto 38 25 49 30
TEMPORADA 2015/2016
SERIE D GRUPO 10
Equipo PJ GF GC Puntos
1 AS Gubbio 1910 Gubbio 1910 2 3 1 6
2 Piacenza Piacenza 2 5 1 4
3 Bellinzago Bellinzago 2 4 3 4
4 Viterbese Viterbese 2 6 4 3
5 Virtus Francavilla Virtus 2 5 5 3
6 Siracusa Siracusa 2 4 6 3
7 Parma Parma 2 3 4 1
8 Sambenedettese Sambenedette 2 2 3 1
9 Venezia Venezia 2 4 9 0
TEMPORADA 2010/2011
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Arzanese Arzanese 34 60 28 71
2 Pomigliano Pomigliano 34 47 24 69
3 Gaeta Gaeta 34 50 18 67
4 Nardò Nardò 34 48 28 62
5 Virtus Casarano Virtus 34 46 30 56
6 Virtus Francavilla Virtus 34 43 38 47
7 Ischia Ischia 34 37 35 44
8 Capriatese Capriatese 34 33 35 44
9 Irsinese Irsinese 34 33 38 44
10 Atletico Boville Atletico 34 31 36 44
11 Fortis Trani Fortis Trani 34 34 42 44
12 Sant Antonio Abate Sant Antonio 34 37 43 42
13 Grottaglie Grottaglie 34 26 41 42
14 Battipagliese Battipaglies 34 36 36 39
15 Pisticci Pisticci 34 41 37 38
16 Angri Angri 34 42 59 36
17 Francavilla Calcio Francavilla 34 27 58 28
18 Ostuni Sport Ostuni Sport 34 19 64 16
TEMPORADA 2009/2010
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Turris Neapolis Turris 68 119 90 117
2 Francavilla Calcio Francavilla 68 80 85 82
3 ASD Pianura ASD Pianura 34 62 33 69
4 Virtus Casarano Virtus 34 56 28 65
5 Forza e Coraggio Forza 34 61 45 62
6 Sant Antonio Abate Sant Antonio 34 53 38 57
7 Pomigliano Pomigliano 34 41 36 55
8 Casertana Casertana 34 38 32 52
9 Matera Matera 34 43 44 46
10 Grottaglie Grottaglie 34 47 44 44
11 Ostuni Sport Ostuni Sport 34 38 51 41
12 Angri Angri 34 37 53 40
13 ASD Omnia Bitonto Omnia 35 36 50 36
14 Bacoli Sibilla Bacoli 34 36 51 33
15 Ischia Ischia 34 27 47 32
16 Pisticci Pisticci 35 28 49 32
17 Città di Fasano Città 34 23 49 23
TEMPORADA 2008/2009
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Brindisi Brindisi 34 61 28 70
2 ASD Pianura ASD Pianura 34 71 39 60
3 Nocerina Nocerina 33 51 40 60
4 Pomigliano Pomigliano 34 56 41 56
5 Ischia Ischia 34 43 29 55
6 Turris 1944 Turris 1944 34 40 37 54
7 Matera Matera 34 42 33 47
8 Virtus Francavilla Virtus 34 35 39 47
9 Città di Fasano Città 34 41 36 46
10 Francavilla Calcio Francavilla 33 36 33 45
11 Bacoli Sibilla Bacoli 34 43 41 45
12 Angri Angri 33 33 41 42
13 Sant Antonio Abate Sant Antonio 34 34 44 42
14 ASD Omnia Bitonto Omnia 33 33 47 37
15 Grottaglie Grottaglie 34 31 41 36
16 FC Sporting Genzano Sporting 34 27 52 32
17 Gelbison Gelbison 34 35 56 24
18 US Venafro US Venafro 34 25 60 20

  USO DE MEMORIA  
6,514,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1499
Total Execution Time  0.1518
  CADENA URL  
/historico/Virtus-Francavilla/2021
  GET DATOS  
$_GET['/historico/Virtus-Francavilla/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0045  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 = 'Virtus-Francavilla' AND l.year = 2021 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=66537 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=66537 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=66537 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=66537 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 58762
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66537 AND type_rel = 2
0.0028  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 = '66537' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '66537' AND l.year = 2021 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 = '66537' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 58676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 63868 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 58762 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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=66537 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (69410,67434,58676) 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.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 67434 AND teamId = 66537
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 58676 AND teamId = 66537
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 69410 AND teamId = 66537
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 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 = 58762 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '66537' 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 = '66537' and rp.type = 4
0.0020  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 = '66537' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  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 events2021 e ON e.player_id = p.id AND e.league_id = 58762 WHERE rp.league_id = 58762 AND rp.teamId = 66537 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.0033  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 events2021 e ON e.player_id = p.id AND e.league_id = 58762 WHERE rp.league_id = 58762 AND rp.teamId = 66537 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 events2021 e ON e.player_id = p.id AND e.league_id = 58762 WHERE rp.league_id = 58762 AND rp.teamId = 66537 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 66537 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031  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 = 58762 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 `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 = 51023 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.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 = 44233 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 38931 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 33445 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 15656 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 `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 = 28006 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 24702 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 `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 = 24716 AND t.round = 36 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 `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 = 24735 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 58762 ORDER BY nameShow LIMIT 100
0.0030  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 90 AND l.year = 2021 ORDER BY l.group_code ASC