4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Novo Chiclana
Información

Histórico de participación

Partidos del Novo Chiclana

Ir al LIVESCORE
19 Abr 20  Aplazado Novo Chiclana Novo Chiclana
-
Federico Mayo C.F. Federico Mayo C.F. 0
29 Mar 20  Aplazado CD Benalup CD Benalup
-
Novo Chiclana Novo Chiclana 0
22 Mar 20  Aplazado Novo Chiclana Novo Chiclana
-
CD Alcalat FC CD Alcalat FC 0
15 Mar 20  Aplazado Tiempo Libre Tiempo Libre
-
Novo Chiclana Novo Chiclana 0
08 Mar 20  Finalizado Novo Chiclana Novo Chiclana
1 - 3
Castellar Castellar 0
23 Feb 20  Finalizado RB Linense B RB Linense B
3 - 0
Novo Chiclana Novo Chiclana 0
09 Feb 20  Finalizado Novo Chiclana Novo Chiclana
2 - 2
Alma de África Alma de África 0
26 Ene 20  Finalizado Aficion Xerecista Aficion Xerecista
3 - 0
Novo Chiclana Novo Chiclana 0
19 Ene 20  Finalizado Novo Chiclana Novo Chiclana
1 - 4
Facinas Facinas 0
12 Ene 20  Finalizado Ud Bornense Ud Bornense
5 - 0
Novo Chiclana Novo Chiclana 0
22 Dic 19  Finalizado Federico Mayo C.F. Federico Mayo C.F.
2 - 0
Novo Chiclana Novo Chiclana 0
15 Dic 19  Finalizado Novo Chiclana Novo Chiclana
0 - 1
CD Benalup CD Benalup 0
01 Dic 19  Finalizado CD Alcalat FC CD Alcalat FC
2 - 0
Novo Chiclana Novo Chiclana 0
24 Nov 19  Finalizado Novo Chiclana Novo Chiclana
2 - 1
Tiempo Libre Tiempo Libre 0
17 Nov 19  Finalizado Castellar Castellar
2 - 1
Novo Chiclana Novo Chiclana 0
10 Nov 19  Finalizado Novo Chiclana Novo Chiclana
0 - 2
RB Linense B RB Linense B 0
27 Oct 19  Finalizado Alma de África Alma de África
5 - 0
Novo Chiclana Novo Chiclana 0
20 Oct 19  Finalizado Novo Chiclana Novo Chiclana
0 - 1
Aficion Xerecista Aficion Xerecista 0
13 Oct 19  Finalizado Facinas Facinas
2 - 0
Novo Chiclana Novo Chiclana 0
06 Oct 19  Finalizado Novo Chiclana Novo Chiclana
2 - 1
Ud Bornense Ud Bornense 0

Noticias de 3ª Andaluza Cádiz

Ver últimas noticias

El campeón de Ceuta tendrá plaza en Tercera Andaluza de Cádiz

El presidente de la Federación de Fútbol de Ceuta, Antonio García Gaona, destacó la buena sintonía que tiene con el nuevo presidente de la Federación Andaluza, Pablo Lozano, y anunció que tiene previsto organizar el próximo noviembre una reunión de trabajo en Ceuta con las federaciones andaluza y melillense.

Una camiseta contra el racismo: mono, negro, esclavo...

Alma de África ha demostrado que a valores no les gana nadie. El equipo de Tercera Andaluza de Cádiz saltó al campo con unas camisetas reivindicativas que en lugar de sus nombres, lucían los insultos recibidos en los diferentes campos de fútbol.

Insultos racistas en lugar del nombre en la camiseta como protesta

Esta ha sido la ocurrente manera de Alma de África de concienciar sobre el racismo. Es un equipo de Tercera Andaluza de Cádiz que, cansado de recibir insultos racistas, quiere protestar de esta forma.

El árbitro que denunció insultos homófobos abandona el fútbol

Jesús Tomillero deja el arbitraje. Las amenazas y descalificaciones por su condición de homosexual le han llevado a decir basta. Así lo ha anunciado el trencilla.

Nuevos insultos homófobos durante un partido a un árbitro gay

Jesús Tomillero, el árbitro que en marzo denunció haber sido víctima de insultos y vejaciones homófobas en un partido de Tercera Andaluza, volvía este sábado a sufrir nuevos ataques referidos a su condición sexual.




  USO DE MEMORIA  
4,628,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0577
Total Execution Time  0.0597
  CADENA URL  
/novo-chiclana
  GET DATOS  
$_GET['/novo-chiclana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
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 = 'novo-chiclana' 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.0027  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 = 'novo-chiclana' 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=14095 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=14095 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=14095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14095 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=420 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 420 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (685788,641934,638815,68963,68433) ORDER BY n.cover_points DESC, update_date 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 = '14095' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = '14095' 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 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=14095 AND l.year in (2019,2020,2021) 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 (51516) 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 = 51516 AND teamId = 14095
0.0019  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 = 14095 AND rp.league_id = 51516 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1