長文感想参照数の実行結果

SQLの説明

最近一週間分です。同一IPを除いていません。

検索結果

実行したSQL

      SELECT main AS "</TABLE><TABLE>"
FROM ((SELECT '</TABLE>
	<TABLE CLASS="index">
	<TR><TD BGCOLOR="#F8F8DF">
		<TABLE>
			<TR><TH>ゲーム</TH><TH>参照数</TH></TR>
			<!--' AS main) 
UNION ALL  (SELECT '-->
			<TR><TD><A HREF="http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/game.php?game='||game||'">'||(SELECT gamename FROM gamelist g WHERE g.id=game)||'</A></TD>
			<TD>'||COUNT(*)||'</TD></TR>
			<!--' AS main FROM userreview_display_log WHERE timestamp>=CURRENT_DATE-7 GROUP BY game ORDER BY COUNT(*) DESC LIMIT 30) 
UNION ALL  (SELECT '-->
		</TABLE>
	</TD><TD BGCOLOR="#F8F8DF">
		<TABLE>
			<TR><TH>ユーザー</TH><TH>参照数</TH></TR>
			<!--' AS main) 
UNION ALL  (SELECT '-->
			<TR><TD><A HREF="http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/user_userreview_log.php?user=urlencode("'||uid||'")#userreview_log">'||uid||'</A></TD>
			<TD>'||COUNT(*)||'</TD></TR>
			<!--' AS main FROM userreview_display_log WHERE timestamp>=CURRENT_DATE-7 GROUP BY uid ORDER BY COUNT(*) DESC LIMIT 30) 
UNION ALL  (SELECT '-->
		</TABLE>
	</TD><TD BGCOLOR="#F8F8DF">
		<TABLE>
			<TR><TH>コメント</TH><TH>参照数</TH></TR>
			<!--' AS main)
UNION ALL  (SELECT '-->
			<TR><TD>'||(SELECT gamename FROM gamelist g WHERE g.id=game)||' <A HREF="http://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/memo.php?game='||game||'&uid=urlencode("'||uid||'")">'||uid||'</A><FONT COLOR=RED>'||CASE WHEN (SELECT netabare FROM userreview u WHERE u.game=ul.game AND u.uid=ul.uid) THEN ' !' ELSE '' END||'</FONT></TD>
			<TD>'||COUNT(*)||'</TD></TR>
			<!--' AS main FROM userreview_display_log ul WHERE timestamp>=CURRENT_DATE-7 GROUP BY uid,game ORDER BY COUNT(*) DESC LIMIT 30)
UNION ALL  (SELECT '-->
		</TABLE>
	</TD></TR>
	</TABLE><TABLE>' AS main)
) AS j