4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
SERIE C

Girone A
                     Pts
 1.PARMA              52      Promoted
 2.Udinese            52 
 3.Alessandria        51 
 4.Venezia            50  
 5.Savona             43 
 6.Cremonese          42 
 7.Padova             41 
 8.Seregno            40 
 9.Piacenza           37 
10.Trento             35 
   Solbiatese         35 
12.Legnano            34 
13.Derthona           33 
   Triestina          33 
   Belluno            33 
   Vigevano           33 
   Pro Vercelli       33 
18.Rovereto           32      Relegated
19.Cossatese          31      Relegated
20.Verbania           20      Relegated

Girone B
                     Pts
 1.SPAL               53      Promoted
 2.Giulianova         49 
 3.Lucchese           48
 4.Sambenedettese     47 
 5.Viareggio          42
   Livorno            42
 7.Modena             41
   Rimini             41
 9.Montevarchi        39
   Empoli             39
11.Ravenna            37
   Massese            37
13.Pisa               36
14.Spezia             34
15.Prato              32
   Olbia              32
17.Torres             30
18.Viterbese          29      Relegated
19.Maceratese         27      Relegated
20.Anconitana         25      Relegated

Girone C
                     Pts
 1.AVELLINO           62      Promoted
 2.Lecce              59
 3.Turris             46
 4.Acireale           45 
 5.Salernitana        43 
 6.Chieti             42 
   Juve Stabia        42  
 8.Casertana          40 
 9.Frosinone          37 
   Trapani            37 
   Siracusa           37 
12.Sorrento           36 
   Pro Vasto          36 
14.Cosenza            34 
   Barletta           33 
16.Crotone            32 
   Matera             32
18.Messina            31      Relegated
19.Trani              26      Relegated
20.Potenza             9      Relegated


Author: Maurizio Mariani (maurizio.mariani@npo.it)
Last updated: 26 Oct 2000

(C) Copyright Maurizio Mariani and RSSSF 1999/2000


  USO DE MEMORIA  
4,260,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  1.2307
Total Execution Time  1.2325
  CADENA URL  
/serie_c11973
  GET DATOS  
$_GET['/serie_c11973']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0246  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90 AND type_rel = 3
1.0094  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 90 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0845  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 (1288519,1278023,1273213,1269533,1269201) ORDER BY n.cover_points DESC, update_date DESC
0.0082  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 30887 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT type,rule FROM rules WHERE categoryId = 90 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0062  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:54:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0060  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 12:54:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:54:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:54:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1973` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 30887 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
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 `tables1973` 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 = 30887 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0072  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1973` 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 = 30887 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0017  SELECT data1, data2 FROM services_tags WHERE categoryId=90
0.0375  SELECT group_code, extraName from `leagues` WHERE categoryId=90 AND year=1973