最近のお勧めの期間を延長しただけです。すんまそんm(__)m
SELECT '<A href="http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/game.php?game='||game||'">'||g.gamename||'</A>' AS ゲーム名,'<A href="http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/brand.php?brand='||b.id||'">'||b.brandname||'</A>' AS ブランド名 ,g.sellday AS 発売日, cast(AVG(tokuten) as integer) AS 平均点,cast ( STDDEV(tokuten) AS INTEGER ) AS 標準偏差,count(tokuten) AS データ数 FROM (select game,tokuten FROM userreview union all select game,tokuten FROM reviewpagelist) AS j,gamelist g, brandlist b WHERE j.game = g.id AND g.brandname=b.id AND g.sellday >= cast((select 'today'::date + '-180 day'::interval) AS DATE ) GROUP BY game,g.gamename,b.brandname,b.id,g.furigana,g.sellday HAVING count(tokuten) >= 5 AND AVG(tokuten) >= 70 ORDER BY ((AVG(tokuten)*4)+count(tokuten)) DESC,count(tokuten) DESC,AVG(tokuten) DESC;