MySQL - possibile eseguire una query simile?

[markzzz]

ok. sotto puoi vedere il dump della tabella calendario (non è completa perchè quì non me la lascia inserire tutta. ci sono solo le prime 4 giornate di andata e le prime 4 di ritorno. per ogni giornata le varie partite, senza risultati perchè devo ancora inserirli. man mano che li inserisco faccio gli update sulle varie righe, e da lì la classifica si aggiorna. è chiaro più o meno?

CREATE TABLE /*!32312 IF NOT EXISTS*/ "calendario" (
  "id" int(11) unsigned NOT NULL auto_increment,
  "team1" varchar(255) NOT NULL,
  "team2" varchar(255) NOT NULL,
  "v1" varchar(255) NOT NULL default '-',
  "v2" varchar(255) NOT NULL default '-',
  "giornata" int(11) NOT NULL,
  "campionato" int(11) unsigned NOT NULL,
  PRIMARY KEY  ("id")
) AUTO_INCREMENT=168;

TRUNCATE TABLE "calendario";
LOCK TABLES "calendario" WRITE;
/*!40000 ALTER TABLE "calendario" DISABLE KEYS;*/
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('36','C.A. Sernaglia','G.S.A. Montebelluna','-','-',1,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('37','G.S.A. Montebelluna','C.A. Sernaglia','-','-',12,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('38','C.A. Bigolino','A.S.C.D. Mittici','-','-',1,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('39','A.S.C.D. Mittici','C.A. Bigolino','-','-',12,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('40','Amatori Piave T.','C.A. Pieve 2001','-','-',1,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('41','C.A. Pieve 2001','Amatori Piave T.','-','-',12,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('42','C.A. Valdobbiadene','C.A. Farra 90','-','-',1,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('43','C.A. Farra 90','C.A. Valdobbiadene','-','-',12,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('44','G.S.A. Caerano','G.S.A. Contea','-','-',1,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('45','G.S.A. Contea','G.S.A. Caerano','-','-',12,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('46','C.A. Razza Piave','A.F. Conegliano','-','-',1,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('47','A.F. Conegliano','C.A. Razza Piave','-','-',12,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('48','C.A. Pieve 2001','C.A. Valdobbiadene','-','-',2,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('49','C.A. Valdobbiadene','C.A. Pieve 2001','-','-',13,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('50','C.A. Farra 90','C.A. Razza Piave','-','-',2,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('51','C.A. Razza Piave','C.A. Farra 90','-','-',13,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('52','G.S.A. Contea','Amatori Piave T.','-','-',2,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('53','Amatori Piave T.','G.S.A. Contea','-','-',13,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('54','G.S.A. Montebelluna','C.A. Bigolino','-','-',2,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('55','C.A. Bigolino','G.S.A. Montebelluna','-','-',13,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('56','A.S.C.D. Mittici','G.S.A. Caerano','-','-',2,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('57','G.S.A. Caerano','A.S.C.D. Mittici','-','-',13,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('58','A.F. Conegliano','C.A. Sernaglia','-','-',2,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('59','C.A. Sernaglia','A.F. Conegliano','-','-',13,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('60','C.A. Bigolino','C.A. Sernaglia','-','-',3,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('61','C.A. Sernaglia','C.A. Bigolino','-','-',14,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('62','Amatori Piave T.','A.S.C.D. Mittici','-','-',3,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('63','A.S.C.D. Mittici','Amatori Piave T.','-','-',14,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('64','C.A. Valdobbiadene','G.S.A. Contea','-','-',3,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('65','G.S.A. Contea','C.A. Valdobbiadene','-','-',14,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('66','G.S.A. Caerano','G.S.A. Montebelluna','-','-',3,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('67','G.S.A. Montebelluna','G.S.A. Caerano','-','-',14,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('68','C.A. Razza Piave','C.A. Pieve 2001','-','-',3,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('69','C.A. Pieve 2001','C.A. Razza Piave','-','-',14,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('70','C.A. Farra 90','A.F. Conegliano','-','-',3,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('71','A.F. Conegliano','C.A. Farra 90','-','-',14,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('72','C.A. Sernaglia','G.S.A. Caerano','-','-',4,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('73','G.S.A. Caerano','C.A. Sernaglia','-','-',15,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('74','C.A. Pieve 2001','C.A. Farra 90','-','-',4,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('75','C.A. Farra 90','C.A. Pieve 2001','-','-',15,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('76','G.S.A. Contea','C.A. Razza Piave','-','-',4,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('77','C.A. Razza Piave','G.S.A. Contea','-','-',15,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('78','G.S.A. Montebelluna','Amatori Piave T.','-','-',4,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('79','Amatori Piave T.','G.S.A. Montebelluna','-','-',15,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('80','A.S.C.D. Mittici','C.A. Valdobbiadene','-','-',4,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('81','C.A. Valdobbiadene','A.S.C.D. Mittici','-','-',15,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('82','A.F. Conegliano','C.A. Bigolino','-','-',4,'12');
INSERT INTO "calendario" ("id", "team1", "team2", "v1", "v2", "giornata", "campionato") VALUES ('83','C.A. Bigolino','A.F. Conegliano','-','-',15,'12');
/*!40000 ALTER TABLE "calendario" ENABLE KEYS;*/
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/