4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Parque Cruz Conde CF
TEMPORADA 2021/2022
3ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 CD Futbol Juanin Y Diego B Futbol 25 74 29 61
2 CD Colonia de Fuente Palmer Colonia 26 68 47 49
3 Apademar Apademar 26 61 40 48
4 Don Bosco CF B Bosco 26 63 41 46
5 RUD La Carlota Carlota 26 69 58 45
6 C.D. Stadium C.D. Stadium 25 61 43 43
7 Salerm Puente Genil Sub 19 Salerm 26 58 58 36
8 Villa del Rio Servicio Depo Villa 26 53 55 31
9 Ciudad Jardin CD Ciudad 26 40 53 31
10 Atco. Villanueva F.B. Atco. 25 41 54 27
11 Montalbeño Montalbeño 25 28 36 26
12 Hinojosa Hinojosa 25 40 62 24
13 Bujalance Bujalance 26 37 61 19
14 CD Posadas CF Posadas 24 38 88 19
15 CD Pozoblanco B Pozoblanco 0 0 0 0
16 Parque Cruz Conde CF Parque Cruz 1 0 6 0
TEMPORADA 2020/2021
3ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Palomera-Naranjo CDCultural Palomera-Nar 24 67 22 56
2 CD Priego CF Priego 24 47 17 53
3 Villa del Rio Servicio Depo Villa 24 48 36 51
4 CD Posadas CF Posadas 24 62 35 46
5 Salerm Puente Genil Sub 19 Salerm 24 49 26 45
6 Ciudad Jardin CD Ciudad 24 46 35 37
7 C.D. Stadium C.D. Stadium 24 66 53 31
8 Parque Cruz Conde CF Parque Cruz 24 39 48 27
9 C.D. Deportivo Cordoba C.F. C.D. 24 40 58 27
10 CD Futbol Juanin Y Diego B Futbol 24 35 53 24
11 Hinojosa Hinojosa 23 29 45 21
12 Fundacion Lucena B Fundacion 23 28 70 11
13 CD El Higuerón Higuerón 24 25 83 5
14 Almodóvar del Río C.F. Almodóvar 0 0 0 0
TEMPORADA 2019/2020
3ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 C.D. Deportivo Cordoba C.F. C.D. 23 61 24 59
2 La Rambla AD Rambla 22 83 32 56
3 CD Apedem CD Apedem 22 84 20 54
4 Montemayor Atletico CD Montemayor 22 68 25 46
5 Ciudad Jardin CD Ciudad 23 66 31 46
6 CD El Carpio C.F. Carpio C.F. 22 66 35 44
7 Palomera-Naranjo CDCultural Palomera-Nar 22 65 43 33
8 Fundacion Lucena B Fundacion 22 70 41 26
9 C.D. Stadium C.D. Stadium 23 50 57 25
10 Parque Cruz Conde CF Parque Cruz 22 41 51 25
11 CD Futbol Juanin Y Diego B Futbol 23 41 64 23
12 CD AD Miralbaida Miralbaida 23 37 60 23
13 CD El Higuerón Higuerón 23 33 79 18
14 CD Posadas CF Posadas 23 33 68 15
15 La Ribera Del Guadalquivir Ribera 15 24 84 10
16 Almodóvar del Río C.F. Almodóvar 22 15 123 7
TEMPORADA 2018/2019
4ª ANDALUZA CÓRDOBA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Pozoblanco Sub 19 Pozoblanco 22 66 27 57
2 Parque Cruz Conde CF Parque Cruz 22 73 27 53
3 CD Futbol Juanin Y Diego B Futbol 22 89 21 52
4 C.D. Atletico Espeleño C.D. 22 65 24 43
5 Apademar B Apademar B 22 65 32 38
6 C.D. Alcázar B C.D. 21 51 41 32
7 Hinojosa Hinojosa 21 43 43 24
8 Figueroa CD B Figueroa 22 43 52 24
9 El Viso C.D. A.D. Viso C.D. A. 21 50 60 24
10 Palomera-Naranjo Palomera-Nar 22 57 63 19
11 La Ribera del Guadalquivir Ribera 22 11 117 7
12 Domcor Domcor 21 14 120 6
TEMPORADA 2017/2018
4ª ANDALUZA CÓRDOBA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 CD Futbol Juanin Y Diego Futbol 23 117 26 56
2 Ciudad Jardin CD Ciudad 22 77 30 56
3 CD AD Miralbaida Miralbaida 22 81 36 52
4 Hinojosa Hinojosa 24 59 21 47
5 Los Califas Balompie Califas 21 60 37 38
6 Parque Cruz Conde CF Parque Cruz 22 47 44 34
7 Apademar B Apademar B 23 52 58 32
8 Palomera-Naranjo Palomera-Nar 23 39 68 23
9 Figueroa CD B Figueroa 23 35 64 21
10 C.D. Atletico Espeleño C.D. 22 26 76 12
11 UD Sur UD Sur 15 22 42 8
12 Belmezano Belmezano 19 16 73 8
13 UD Las Palmeras Palmeras 5 15 15 6
14 El Naranjo El Naranjo 12 10 66 3
TEMPORADA 2016/2017
3ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Fundación Lucena FC Sub 19 Fundación 30 119 42 68
2 Palma del Rio Atlético Sub Palma 30 122 38 66
3 C.D. Deportivo Cordoba C.F. C.D. 30 97 36 60
4 Sporting de Benameji Sporting 30 106 56 57
5 RUD La Carlota Carlota 30 96 46 57
6 Palomera-Naranjo Palomera-Nar 30 92 50 50
7 Fray Albino Fray Albino 30 54 62 43
8 C.D. Stadium C.D. Stadium 30 64 74 43
9 Ud Salvador Allende Salvador 30 64 69 42
10 Alcazar CD Alcazar CD 30 73 70 40
11 CD El Higuerón Higuerón 30 68 76 40
12 Belalcazar UD Belalcazar 30 56 65 37
13 Los Califas Balompie Califas 30 71 69 36
14 Bujalance Futbol Base AD Bujalance 30 64 115 27
15 Figueroa CD B Figueroa 30 41 111 14
16 Parque Cruz Conde CF Parque Cruz 30 19 227 6
TEMPORADA 2015/2016
2ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Séneca B CF Séneca 29 66 22 63
2 Almodóvar del Río C.F. Almodóvar 29 62 29 57
3 Villafranca Villafranca 29 64 44 55
4 CD Pozoblanco Sub 19 Pozoblanco 29 55 31 54
5 Apademar A Apademar A 29 73 42 52
6 Don Bosco CF Sub 19 Bosco 29 47 27 47
7 CD Apedem CD Apedem 29 41 50 47
8 CD Deportivo Cordoba CF A Deportivo 29 57 39 46
9 Montalbeño Montalbeño 29 34 41 37
10 La Rambla AD Rambla 29 44 56 36
11 Salerm Puente Genil Sub 19 Salerm 29 49 64 33
12 Atco. Villanueva F.B. Atco. 29 31 65 28
13 Peñarroya Pueblonuevo Peñarroya 29 36 58 27
14 C.D. Stadium C.D. Stadium 30 33 76 25
15 Lucena C.F. Lucena C.F. 29 36 61 20
16 Parque Cruz Conde CF Parque Cruz 16 17 40 11
TEMPORADA 2014/2015
3ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 CD Pozoblanco Sub 19 Pozoblanco 29 90 34 71
2 Parque Cruz Conde CF Parque Cruz 29 107 27 70
3 C.D. Deportivo Cordoba C.F. C.D. 29 69 31 61
4 CD Castro Del Rio-Cajasol Castro 30 69 31 58
5 Peñarroya Pueblonuevo Peñarroya 29 60 42 47
6 Montalbeño Montalbeño 30 45 52 41
7 Lucena Lucena 29 49 63 38
8 Villa del Rio Servicio Depo Villa 30 60 71 37
9 Aguilarense Aguilarense 29 36 58 37
10 Los Califas Los Califas 29 57 61 35
11 RUD La Carlota Carlota 29 44 48 35
12 Palomera-Naranjo Palomera-Nar 30 45 56 35
13 Ud Salvador Allende Salvador 29 34 54 31
14 Don Bosco CF B Bosco 29 40 94 26
15 Figueroa CD B Figueroa 29 30 88 16
16 CD El Carpio C.F. Carpio C.F. 19 30 55 10
TEMPORADA 2013/2014
2ª ANDALUZA CÓRDOBA JUVENIL
Equipo PJ GF GC Puntos
1 Lucena C.F. Lucena C.F. 15 50 19 31
2 Figueroa CD A Figueroa 16 39 26 31
3 Villafranca Villafranca 15 50 28 31
4 Séneca Cf Séneca Cf 16 29 23 28
5 Apademar A Apademar A 16 33 35 25
6 Córdoba CF Sub 19 B Córdoba 10 29 10 24
7 Salerm Puente Genil Sub 19 Salerm 16 38 39 23
8 La Rambla AD Rambla 16 35 31 22
9 Atlético Baenense Atlético 16 40 41 21
10 CD Deportivo Cordoba CF A Deportivo 15 28 32 20
11 Almodóvar del Río C.F. Almodóvar 15 30 40 19
12 Círculo Don Bosco Círculo 15 21 31 17
13 Prieguense AF Prieguense 16 21 47 15
14 Los Califas Los Califas 15 38 39 14
15 CD Pozoblanco Sub 19 Pozoblanco 16 24 40 11
16 Parque Cruz Conde CF Parque Cruz 15 22 42 10
17 Ud Salvador Allende Salvador 1 2 6 0

  USO DE MEMORIA  
5,601,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1027
Total Execution Time  0.1039
  CADENA URL  
/historico/Parque-Cruz-Conde-434
  GET DATOS  
$_GET['/historico/Parque-Cruz-Conde-434']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0023  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 = 'Parque-Cruz-Conde-434' 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.0034  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 = 'Parque-Cruz-Conde-434' 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.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=16089 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=16089 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=16089 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=16089 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=16089 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=16089 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=16089 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=16089 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=16089 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=16089 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 65918
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16089 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=754 AND type_rel = 3
0.0022  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 = '16089' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '16089' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = '16089' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 65918 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=16089 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (65918) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65918 AND teamId = 16089
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 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 = 65918 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = 16089 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2022_base` 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 = 65918 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.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 `tables2021_base` 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 = 59760 AND t.round = 26 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_base` 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 = 51960 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.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 `tables2019_base` 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 = 45827 AND t.round = 22 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 `tables2018_base` 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 = 40051 AND t.round = 30 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 `tables2017_base` 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 = 34222 AND t.round = 30 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 `tables2016_base` 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 = 17030 AND t.round = 30 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 `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 = 4856 AND t.round = 30 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 `tables2014_base` 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 = 3339 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 65918 ORDER BY nameShow LIMIT 100
0.0019  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 754 AND l.year = 2022 ORDER BY l.group_code ASC