4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Compañia de Maria
Información

Partidos del Compañia de Maria

Ir al LIVESCORE
27 Abr 19  Finalizado Olimpico CF Olimpico CF
4 - 3
Compañia de Maria Compañia de Maria 0
14 Abr 19  Finalizado Compañia de Maria Compañia de Maria
5 - 1
Ciudad Jardin Ciudad Jardin 0
06 Abr 19  Finalizado Once Caballeros CF Once Caballeros CF
0 - 1
Compañia de Maria Compañia de Maria 0
31 Mar 19  Finalizado Rayo Sadense Rayo Sadense
3 - 0
Compañia de Maria Compañia de Maria 0
24 Mar 19  Finalizado Compañia de Maria Compañia de Maria
2 - 1
Sporting Burgo A Sporting Burgo A 0
19 Mar 19  Finalizado Maravillas SD Maravillas SD
2 - 1
Compañia de Maria Compañia de Maria 0
17 Mar 19  Finalizado Compañia de Maria Compañia de Maria
8 - 2
Paiosaco Hierros Paiosaco Hierros 0
09 Mar 19  Finalizado Silva SD Silva SD
5 - 1
Compañia de Maria Compañia de Maria 0
24 Feb 19  Finalizado Compañia de Maria Compañia de Maria
0 - 3
Atl. Coruña Montañeros Atl. Coruña Montañeros 0
16 Feb 19  Finalizado Sporting Cambre Sporting Cambre
1 - 0
Compañia de Maria Compañia de Maria 0
09 Feb 19  Finalizado Compañia de Maria Compañia de Maria
0 - 7
Imperator OAR Imperator OAR 0
02 Feb 19  Finalizado C D Calasanz C C D Calasanz C
2 - 5
Compañia de Maria Compañia de Maria 0
26 Ene 19  Finalizado Compañia de Maria Compañia de Maria
2 - 1
Ordenes SD Ordenes SD 0
19 Ene 19  Finalizado Sporting Coruñes SD Sporting Coruñes SD
4 - 1
Compañia de Maria Compañia de Maria 0
12 Ene 19  Finalizado Compañia de Maria Compañia de Maria
1 - 1
Betanzos CF Betanzos CF 0
22 Dic 18  Finalizado Atletico Castros Atletico Castros
3 - 0
Compañia de Maria Compañia de Maria 0
15 Dic 18  Finalizado Compañia de Maria Compañia de Maria
0 - 6
Oza Juvenil Oza Juvenil 0
09 Dic 18  Finalizado Compañia de Maria Compañia de Maria
1 - 5
Olimpico CF Olimpico CF 0
06 Dic 18  Finalizado Ciudad Jardin Ciudad Jardin
1 - 1
Compañia de Maria Compañia de Maria 0
01 Dic 18  Finalizado Compañia de Maria Compañia de Maria
2 - 4
Once Caballeros CF Once Caballeros CF 0
25 Nov 18  Finalizado Compañia de Maria Compañia de Maria
3 - 2
Rayo Sadense Rayo Sadense 0
18 Nov 18  Finalizado Sporting Burgo A Sporting Burgo A
5 - 0
Compañia de Maria Compañia de Maria 0
10 Nov 18  Finalizado Compañia de Maria Compañia de Maria
6 - 1
Maravillas SD Maravillas SD 0
03 Nov 18  Finalizado Paiosaco Hierros Paiosaco Hierros
1 - 0
Compañia de Maria Compañia de Maria 0
01 Nov 18  Finalizado Compañia de Maria Compañia de Maria
1 - 3
Silva SD Silva SD 0
27 Oct 18  Finalizado Atl. Coruña Montañeros Atl. Coruña Montañeros
11 - 0
Compañia de Maria Compañia de Maria 0
21 Oct 18  Finalizado Compañia de Maria Compañia de Maria
2 - 3
Sporting Cambre Sporting Cambre 0
13 Oct 18  Finalizado Imperator OAR Imperator OAR
6 - 0
Compañia de Maria Compañia de Maria 0
06 Oct 18  Finalizado Compañia de Maria Compañia de Maria
3 - 0
C D Calasanz C C D Calasanz C 0
30 Sep 18  Finalizado Ordenes SD Ordenes SD
2 - 1
Compañia de Maria Compañia de Maria 0
22 Sep 18  Finalizado Compañia de Maria Compañia de Maria
1 - 2
Sporting Coruñes SD Sporting Coruñes SD 0
15 Sep 18  Finalizado Betanzos CF Betanzos CF
3 - 3
Compañia de Maria Compañia de Maria 0
08 Sep 18  Finalizado Compañia de Maria Compañia de Maria
1 - 2
Atletico Castros Atletico Castros 0
01 Sep 18  Finalizado Oza Juvenil Oza Juvenil
3 - 2
Compañia de Maria Compañia de Maria 0
04 May 19  Finalizado Racing San Lorenzo Racing San Lorenzo
0 - 1
Compañia de Maria Compañia de Maria 0
28 Abr 19  Finalizado Compañia de Maria Compañia de Maria
1 - 0
La Salle La Salle 0
13 Abr 19  Finalizado Belvis Belvis
1 - 1
Compañia de Maria Compañia de Maria 0
07 Abr 19  Finalizado Compañia de Maria Compañia de Maria
3 - 0
Victoria B Victoria B 0
31 Mar 19  Finalizado Vista Alegre Vista Alegre
0 - 9
Compañia de Maria Compañia de Maria 0
23 Mar 19  Finalizado Compañia de Maria Compañia de Maria
2 - 0
Bertamirans C Bertamirans C 0
17 Mar 19  Finalizado Cacheiras Cacheiras
1 - 2
Compañia de Maria Compañia de Maria 0
10 Mar 19  Finalizado Compañia de Maria Compañia de Maria
3 - 0
Atletico Fatima Atletico Fatima 0
24 Feb 19  Finalizado Villestro B Villestro B
1 - 5
Compañia de Maria Compañia de Maria 0
10 Feb 19  Aplazado Club Escolas Deportivas Club Escolas Deportivas
-
Compañia de Maria Compañia de Maria 0
10 Feb 19  Finalizado Compañia de Maria Compañia de Maria
3 - 1
Atletico San Pedro Atletico San Pedro 0
02 Feb 19  Finalizado Amio B Amio B
6 - 2
Compañia de Maria Compañia de Maria 0
27 Ene 19  Finalizado Compañia de Maria Compañia de Maria
3 - 0
Burgo Das Nacions Burgo Das Nacions 0
23 Ene 19  Finalizado Compañia de Maria Compañia de Maria
4 - 4
Manuel Peleteiro Manuel Peleteiro 0
20 Ene 19  Finalizado SR Calo SR Calo
6 - 2
Compañia de Maria Compañia de Maria 0
23 Dic 18  Finalizado Compañia de Maria Compañia de Maria
1 - 5
Racing San Lorenzo Racing San Lorenzo 0
16 Dic 18  Finalizado La Salle La Salle
1 - 5
Compañia de Maria Compañia de Maria 0
09 Dic 18  Finalizado Compañia de Maria Compañia de Maria
1 - 1
Belvis Belvis 0
02 Dic 18  Finalizado Victoria B Victoria B
2 - 2
Compañia de Maria Compañia de Maria 0
25 Nov 18  Finalizado Compañia de Maria Compañia de Maria
5 - 0
Vista Alegre Vista Alegre 0
18 Nov 18  Finalizado Bertamirans C Bertamirans C
1 - 3
Compañia de Maria Compañia de Maria 0
11 Nov 18  Finalizado Compañia de Maria Compañia de Maria
2 - 1
Cacheiras Cacheiras 0
05 Nov 18  Finalizado Burgo Das Nacions Burgo Das Nacions
2 - 2
Compañia de Maria Compañia de Maria 0
04 Nov 18  Finalizado Atletico Fatima Atletico Fatima
1 - 6
Compañia de Maria Compañia de Maria 0
01 Nov 18  Finalizado Compañia de Maria Compañia de Maria
9 - 0
Villestro B Villestro B 0
14 Oct 18  Finalizado Atletico San Pedro Atletico San Pedro
0 - 1
Compañia de Maria Compañia de Maria 0
14 Oct 18  Aplazado Compañia de Maria Compañia de Maria
-
Club Escolas Deportivas Club Escolas Deportivas 0
06 Oct 18  Finalizado Compañia de Maria Compañia de Maria
1 - 1
Amio B Amio B 0
23 Sep 18  Finalizado Compañia de Maria Compañia de Maria
3 - 1
SR Calo SR Calo 0
19 Sep 18  Finalizado Manuel Peleteiro Manuel Peleteiro
2 - 3
Compañia de Maria Compañia de Maria 0

Noticias de 1ª Cadete Auto. Galicia

Ver últimas noticias

Emotiva despedida al futbolista del Muxía fallecido este fin de semana

Con un aplauso espontáneo, lágrimas y desolación, decenas de personas han despedido esta tarde al futbolista cadete del Muxía Abdoulaye Fall Seck, que falleció el pasado sábado en el descanso del partido entre su equipo y el Fisterra.

Fallece un jugador cadete en La Coruña

Trágico acontecimiento durante un partido de fútbol en la categoría cadete de fútbol en Galicia. Un futbolista ha fallecido a los 15 años de edad consecuencia de un paro cardíaco.




  USO DE MEMORIA  
5,209,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5184
Total Execution Time  0.5203
  CADENA URL  
/Compania-De-Maria-Cadete/2019
  GET DATOS  
$_GET['/Compania-De-Maria-Cadete/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0127  SELECT type FROM routes WHERE alias = 'compania-de-maria-cadete'
0.0183  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 = 'Compania-De-Maria-Cadete' 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.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=28178 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=28178 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=28178 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0264  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 = 46003
0.0155  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 = 46089
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=28178 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=792 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 792 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (64088,63213) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '28178' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '28178' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '28178' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  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 = 46003 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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 = 46089 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  (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_base as c ON c.league_id = l.id WHERE (c.datateam1 = 28178 or c.datateam2 = 28178) AND l.year = 2019 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0153  (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_base 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 = 28178 or c.datateam2 = 28178) AND l.year = 2019 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0129  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2019_base as c ON c.league_id = l.id INNER JOIN events2019_base as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players_base 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 = 28178 or c.datateam2 = 28178) AND l.year = 2019)
0.0128  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=28178 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (46089,46003) 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_base WHERE league_id = 46003 AND teamId = 28178
0.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 46089 AND teamId = 28178
0.0127  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 = 46003 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '28178' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '28178' and rp.type = 4
0.0138  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 = '28178' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  SELECT rp.team_id as teamId FROM rel_players_base 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 = 28178 AND rp.league_id = 46003 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0132  SELECT rp.team_id as teamId FROM rel_players_base 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 = 28178 AND rp.league_id = 46003 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0135  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 = 46003 ORDER BY nameShow LIMIT 100