printable version

NO ACTUAL CODE YET, MERELY HAMMERING OUT A QUERY

BLAME GHETTOAARDVARK FOR THINKING OF THIS

SENT SLOUCHING ITS WAY TO BE BORN BY GORGONZOLA

SELECT TOP 10 * FROM (SELECT N.TITLE, REP, TV, REP/TV RAT 
                      FROM NODE N, (SELECT VOTE_ID, SUM(WEIGHT) REP , COUNT(*) TV 
                                    FROM VOTE
                                    GROUP BY VOTE_ID) VS
                      WHERE (N.NODE_ID=VS.VOTE_ID) and (VS.TV>25) )
                ORDER BY RAT DESC;