回答編集履歴
1
若干のリファクタリング
answer
CHANGED
@@ -9,7 +9,7 @@
|
|
9
9
|
FROM review
|
10
10
|
WHERE rev_date >= :target
|
11
11
|
AND rev_date < DATE_ADD(:target, INTERVAL 1 MONTH)
|
12
|
-
GROUP BY
|
12
|
+
GROUP BY rev_day
|
13
13
|
ORDER BY rev_day ASC
|
14
14
|
";
|
15
15
|
$record_rev_stt = $dbh->prepare($record_rev_sql);
|