実行したSQL
SELECT COUNT(ur.uid) AS "人数"
, round( AVG( ur.tokuten ), 0 ) AS "平均点"
, t.average AS "平均値"
, t.median AS "中央値"
, t.sellday AS "発売日"
, t.game_id AS ゲームid
, CHR(60)||'a href='||CHR(34)||'game.php?game='||t.game_id||CHR(34)||CHR(62) ||t.gamename ||CHR(60)||'/a'||CHR(62) AS "ゲーム名"
, CHR(60)||'a href='||CHR(34)||'brand.php?brand='||t.brand_id||CHR(34)||CHR(62) ||t.brandname ||CHR(60)||'/a'||CHR(62) AS "ブランド"
FROM userreview ur
INNER JOIN toukei_temp_table t
ON ur.game = t.game_id
WHERE ur.uid IN
(
SELECT ur.uid
FROM userreview ur
INNER JOIN toukei_temp_table t
ON t.game_id = ur.game
WHERE ur.game = 13827
AND ur.tokuten >= t.average + t.stddev
AND ur.tokuten IS NOT NULL
AND ur.play
)
AND ur.play
AND t.game_id != 13827
AND t.coterie IS NULL
AND t.model = 'PC'
AND ur.tokuten >= t.average + t.stddev
AND t.stddev > 0
AND t.stddev IS NOT NULL
AND t.average >= 65
AND t.median >= 65
AND t.sellday > '2007-01-01'
AND t.count >= 20
GROUP BY t.sellday, t.median, t.average, t.stddev, t.game_id, t.gamename, t.brand_id, t.brandname
ORDER BY AVG( ur.tokuten ) DESC, COUNT(ur.uid) DESC, t.median ASC, t.game_id DESC
LIMIT 10