Administrace komentářů

select P.cislo, P.numeric1, P.numeric2, P.string1, P.string2, P.data,
        coalesce(counter,0) as counter, kdy, S.pridal, S.skupina, S.prava, R.cislo, contract from
        relace R, spolecne S, polozka P 
          left join (select R1.potomek as autor, count(P1.cislo) as counter, max(S1.vytvoreno) as kdy
                    from polozka P1, relace R1, vlastnost V1, spolecne S1
                    where P1.typ=2 and P1.cislo=V1.predek and V1.typ_predka='P' and V1.typ='author'
                    and R1.typ_potomka='P' and V1.hodnota=R1.cislo and S1.typ='P' and P1.cislo=S1.cislo
                    and S1.vytvoreno < now() group by autor) A on A.autor=P.cislo
          left join (select SCS.pridal as uid, CT.numeric1 as contract from polozka SC, polozka CT, spolecne SCS
                    where SC.typ=31 and CT.typ=30 and SC.numeric1 = CT.cislo and SC.cislo=SCS.cislo and SCS.typ='P' and CT.numeric1<>0
                    ) B on B.uid = P.numeric1
  where P.typ=19 and R.typ_potomka=S.typ and R.potomek=S.cislo and S.typ='P' and S.cislo=P.cislo and P.numeric1 in (1,99,143)

• hlavni select pres tabulky P, R, S vybira polozky typu autor
• prvni vnoreny subselect hleda pocet clanku a datum posledniho clanku autora
• druhy hleda polozku SC spojenou s polozkou CT, kterou vytvoril (SCS.pridal) stejny autor, potrebuji jen radek s nejvetsi hodnotou CT.cislo. Aktualne subselect vraci zadny, jeden nebo vice radku.