4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Barça

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Barça

Enviar Datos
Información
Otros Datos
  • Año de Fundación 1978
  • Patrocinador Lassa tyres
  • Patrocinador Secundario Serveto
  • Equipo Filial FC Barcelona B
  • Marca de Ropa Nike
  • Lugar de entrenamiento Palau Blaugrana
Internet

Información sobre el estadio

  • Nombre del estadio Palau Blaugrana
  • Capacidad 7585
  • Dirección Avinguda Joan XXIII, s/n, 08028 Barcelona
  • Teléfono 659135240
  • Año de construcción 1971
Palau Blaugrana

Partidos del Barça

Ir al LIVESCORE
Primera División Futsal Primera División Futsal »
22 Jun 19  Finalizado Barça
3 - 2
 ElPozo Murcia Costa Cál. 9
17 Jun 19  Finalizado ElPozo Murcia Costa Cál.
3 - 7
 Barça 6
15 Jun 19  Finalizado ElPozo Murcia Costa Cál.
3 - 3
 Barça 14
11 Jun 19  Finalizado Barça
2 - 3
 ElPozo Murcia Costa Cál. 7
08 Jun 19  Finalizado Barça
7 - 2
 ElPozo Murcia Costa Cál. 1
03 Jun 19  Finalizado Barça
1 - 1
 Palma Futsal 13
31 May 19  Finalizado Palma Futsal
3 - 1
 Barça 3
24 May 19  Finalizado Barça
2 - 2
 Palma Futsal 4
19 May 19  Finalizado Barça
5 - 1
 Levante UD FS 1
17 May 19  Finalizado Barça
5 - 1
 Levante UD FS 2
10 May 19  Finalizado Levante UD FS
5 - 3
 Barça 0
19 Abr 19  Finalizado Barça
5 - 1
 Viña Albali Valdepeñas 2
06 Abr 19  Finalizado Osasuna Magna
3 - 2
 Barça 0
02 Abr 19  Finalizado Inter FS
1 - 2
 Barça 2
29 Mar 19  Finalizado Barça
8 - 1
 CD UMA Antequera 0
24 Mar 19  Finalizado Industrias Santa Coloma
2 - 3
 Barça 3
15 Mar 19  Finalizado Barça
6 - 0
 O Parrulo Ferrol 0
09 Mar 19  Finalizado Palma Futsal
3 - 2
 Barça 0
22 Feb 19  Finalizado Barça
4 - 5
 Jimbee Cartagena 6
16 Feb 19  Finalizado ElPozo Murcia Costa Cál.
5 - 5
 Barça 1
10 Feb 19  Finalizado Barça
4 - 2
 Jaén FS 3
27 Ene 19  Finalizado Peñíscola FS
0 - 1
 Barça 0
18 Ene 19  Finalizado Barça
4 - 2
 Levante UD FS 0
12 Ene 19  Finalizado Naturpellet Segovia
2 - 5
 Barça 1
04 Ene 19  Finalizado Sala 10 Zaragoza
2 - 6
 Barça 0
22 Dic 18  Finalizado Ribera Navarra FS
2 - 3
 Barça 1
15 Dic 18  Finalizado Barça
4 - 4
 Inter FS 2
09 Dic 18  Finalizado Viña Albali Valdepeñas
2 - 9
 Barça 0
01 Dic 18  Finalizado Barça
3 - 2
 Osasuna Magna 1
27 Nov 18  Finalizado CD UMA Antequera
1 - 5
 Barça 1
24 Nov 18  Finalizado Barça
2 - 3
 Industrias Santa Coloma 0
10 Nov 18  Finalizado Barça
8 - 1
 Palma Futsal 7
06 Nov 18  Finalizado O Parrulo Ferrol
2 - 5
 Barça 0
03 Nov 18  Finalizado Jimbee Cartagena
5 - 5
 Barça 2
27 Oct 18  Finalizado Barça
3 - 3
 ElPozo Murcia Costa Cál. 1
20 Oct 18  Finalizado Jaén FS
1 - 7
 Barça 8
16 Oct 18  Finalizado Levante UD FS
2 - 3
 Barça 1
12 Oct 18  Finalizado Barça
1 - 2
 Peñíscola FS 2
28 Sep 18  Finalizado Barça
7 - 1
 Naturpellet Segovia 0
21 Sep 18  Finalizado Barça
6 - 3
 Sala 10 Zaragoza 1
14 Sep 18  Finalizado Barça
6 - 2
 Ribera Navarra FS 1
Copa del Rey Futsal Copa del Rey Futsal »
05 May 19  Finalizado Barça
5 - 2
 Jaén FS 6
04 May 19  Finalizado Inter FS
4 - 5
 Barça 2
23 Ene 19  Finalizado ElPozo Murcia Costa Cál.
2 - 2
 Barça 4
12 Dic 18  Finalizado Peñíscola FS
1 - 5
 Barça 0
Futsal Cup Futsal Cup »
28 Abr 19  Finalizado Inter FS
1 - 3
 Barça 1
26 Abr 19  Finalizado Barça
2 - 5
 Kairat 0
Copa de España Futsal Copa de España Futsal »
03 Mar 19  Finalizado ElPozo Murcia Costa Cál.
1 - 2
 Barça 6
02 Mar 19  Finalizado Osasuna Magna
1 - 3
 Barça 5
01 Mar 19  Finalizado Barça
3 - 0
 Jaén FS 11
Copa Intercontinental Futsal Copa Intercontinental Futsal »
01 Sep 19  Finalizado Barça
2 - 4
 Corinthians FS 0
31 Ago 19  Finalizado Boca Juniors FS
3 - 1
 Barça 0
28 Ago 19  Finalizado Corinthians FS
1 - 1
 Barça 0
26 Ago 19  Finalizado Barça
4 - 1
 Shenzen Nanling Tielang 0

Noticias del Barça

Ver últimas noticias

El Barça Lassa, líder tras la derrota del Movistar Inter

BeSoccer - Sábado, 22 Septiembre 2018
0 150

El Barça Lassa se aupó este viernes al liderato de la liga de fútbol sala de Primera División tras ganar por 6-3 al Fútbol Emotion Zaragoza y aprovechar la primera derrota del curso del Movistar Inter, que perdió en Valencia ante el Levante por 5-3 en la segunda jornada.

Otro Arthur llega a Barcelona

BeSoccer - Miércoles, 01 Agosto 2018
0 3.946

El Barcelona Lassa, equipo de fútbol sala perteneciente al FC Barcelona, anunció este martes los fichajes de Arthur Guillerme de Souza y de Adrián Ortego hasta 2020.

El Barça altera la agenda de su equipo de fútbol sala por el atentado

BeSoccer - Jueves, 17 Agosto 2017
0 1.343

El FC Barcelona ha decidido suspender el viernes la presentación de los tres jugadores que ha fichado para su sección de fútbol sala "en señal de respeto por las víctimas" del atentado terrorista de este jueves en la Rambla de la capital catalana.

Barça y Chapecoense estrechan lazos y homenajean a los fallecidos

BeSoccer - Domingo, 06 Agosto 2017
0 10.622

El Joan Gamper homenajeará a los fallecidos en el accidente de avión de Chapecoense antes de la final de la Sudamericana, pero, antes, Barça y Chape fortalecieron aún más su ya de por sí buena relación.

Hamza y Cabezón dicen que la liga española es la más potente del mundo

BeSoccer - Viernes, 26 Junio 2015
0 1.187

Los jugadores ceutíes Hamza Maimón, ala del Aspil Ribera Navarra, y Dani Cabezón, guardameta del Jaén Paraíso Interior, han considerado que la Primera División del fútbol sala español ha evidenciado esta temporada que es la más potente del mundo por la calidad de los jugadores.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,262,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.7546
Total Execution Time  0.7570
  CADENA URL  
/Futsal-Barcelona/2019
  GET DATOS  
$_GET['/Futsal-Barcelona/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0154  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 = 'Futsal-Barcelona' AND l.year = 2019 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.0126  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=1041 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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 = 44361
0.0134  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 = 49585
0.0138  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 = 49170
0.0136  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 = 50647
0.0133  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 = 48499
0.0134  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 = 51119
0.0134  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 = 51203
0.0135  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 = '1041' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0135  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 = '1041' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 48499 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 51119 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 49170 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 49585 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 50647 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2019 as c ON c.league_id = l.id WHERE (c.datateam1 = 1041 or c.datateam2 = 1041) AND l.year = 2019 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0143  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2019 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 1041 or c.datateam2 = 1041) AND l.year = 2019 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0132  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2019 as c ON c.league_id = l.id INNER JOIN events2019 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 1041 or c.datateam2 = 1041) AND l.year = 2019)
0.0136  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=1041 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (56735,55371,53583,51469,51203,50647) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 56735 AND teamId = 1041
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 51469 AND teamId = 1041
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 55371 AND teamId = 1041
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 50647 AND teamId = 1041
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 53583 AND teamId = 1041
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 51203 AND teamId = 1041
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 44361 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 events2019 e ON e.player_id = p.id AND e.league_id = 44361 WHERE rp.league_id = 44361 AND rp.teamId = 1041 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.0127  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 events2019 e ON e.player_id = p.id AND e.league_id = 44361 WHERE rp.league_id = 44361 AND rp.teamId = 1041 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 events2019 e ON e.player_id = p.id AND e.league_id = 44361 WHERE rp.league_id = 44361 AND rp.teamId = 1041 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1041 AND rp.league_id = 44361 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0127  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1041 AND rp.league_id = 44361 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0127  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1041 AND rp.league_id = 44361 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0127  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1041 AND rp.league_id = 44361 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0128  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1041 AND rp.league_id = 44361 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0127  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1041 AND rp.league_id = 44361 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0127  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 = 44361 ORDER BY nameShow LIMIT 100
0.0127  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 108 AND l.year = 2019 ORDER BY l.group_code ASC