Predmet:Re: MySql Tabela lige
Evo konacne tabele, ako dobro vidim sve elemente, tacne podatke prikazuje, no vemenom cemo uociti postoje li nepravilnosti
Citat:
SELECT t.naziv AS NAZIV, d.domacin,
Sum( d.pob ) AS POB_KUC,
Sum( d.ner ) AS NER_KUC,
Sum( d.por ) AS POR_KUC,
Sum( d.pob + d.ner + d.por ) AS UKU_KUC,
Sum( d.gold ) AS GOL_DAT_KUC,
Sum( d.golg ) AS GOL_PRI_KUC,
Sum( d.gold - d.golg ) GOL_RAZ_KUC,
Sum( d.bodd ) AS BOD_KOD_KUC,
Sum( g.pob ) AS POB_GOS,
Sum( g.ner ) AS NER_GOS,
Sum( g.por ) AS POR_GOS,
Sum( g.pob + g.ner + g.por ) AS UKU_GOS,
Sum( g.golg ) AS GOL_DAT_GOS,
Sum( g.gold ) AS GOL_PRI_GOS,
Sum( g.golg - g.gold ) AS GOL_RAZ_GOS,
Sum( g.bodg ) AS BOD_U_GOS,
Sum( d.pob + g.por ) AS UKU_POB,
Sum( d.ner + g.ner ) AS UKU_NER,
Sum( d.por + g.pob ) AS UKU_POR,
Sum( d.pob + d.ner + d.por + g.pob + g.ner + g.por) AS UKU_UTA,
Sum(d.gold + g.golg) AS GOL_DAT_UKU,
Sum(d.golg + d.gold) AS GOL_PRI_UKU,
Sum((d.gold + g.golg)-(d.golg + d.gold)) AS GOL_RAZ_UKU,
Sum(d.bodd + g.bodg) AS BOD_UKU
FROM man_utakmice AS d
LEFT JOIN man_timovi AS t ON t.id = d.domacin
INNER JOIN man_utakmice AS g ON ( d.domacin = g.gost )
AND (
d.gost = g.domacin
)
WHERE t.liga_id = 1
GROUP BY domacin
ORDER BY Sum(d.bodd + g.bodg) DESC, Sum((d.gold + g.golg)-(d.golg + d.gold)) DESC