Spojeni tabulek pres UNION a celkovy soucet i jednotlive

Snazim se vykutit tabulku uzivatelu s prispevky ( jsou 3x druhy , 1/ prispevky ve foru, 2/ prispevky ke clankum , 3/ prispevky k zapasum)


zatim mam tento select spojujici 3 tabulky

  SELECT  u.ID as user, count(t.ID) as pocet

  FROM `forum_prispevky` as t 

  RIGHT JOIN uzivatele u ON u.ID = t.registrovany_uzivatel

  GROUP BY u.ID



UNION ALL



  SELECT  u.ID as user, count(t.ID) as pocet

  FROM `komentare_clanky` as t 

  RIGHT JOIN uzivatele u ON u.ID = t.registrovany_uzivatel

  GROUP BY u.ID



UNION ALL



  SELECT  u.ID as user, count(t.ID) as pocet

  FROM `komentare_vysledky` as t 

  RIGHT JOIN uzivatele u ON u.ID = t.registrovany_uzivatel

  GROUP BY u.ID



ORDER BY user ASC

a co s tim ted? Pokud na to aplikuji vnoreny subselect a sectu pocty za usera cili select SUM(pocet), user FROM a tento select s 2x unionem

tak dostanu celkovy pocet prispevku.

Ja ale potrebuji tabulku takto

User | Prispevky-Clanky | Prispevky-Forum | Prispevky-Zapasy | CELKOVE


a seradit dle CELKOVE


A ted nevim jak na to. Pak me napada zrudnost 4x selectu, narvani do poli a naky sesorteni a vypsani.

Vi nekkdo?

hmm tak nic ( http://eldragon.rjwebdesign.net/statistiky/aktivita-na-webu/ )

vyreseno