質問編集履歴
2
文法の修正
title
CHANGED
File without changes
|
body
CHANGED
@@ -42,7 +42,8 @@
|
|
42
42
|
SELECT rank, product
|
43
43
|
FROM ranking
|
44
44
|
WHERE
|
45
|
-
|
45
|
+
pref = 13
|
46
|
+
area = 2
|
46
47
|
AND NOT (rank IS NULL)
|
47
48
|
ORDER BY rank ASC
|
48
49
|
LIMIT 0, 10
|
1
文法修正
title
CHANGED
File without changes
|
body
CHANGED
@@ -60,7 +60,7 @@
|
|
60
60
|
FROM ranking
|
61
61
|
WHERE
|
62
62
|
pref = ?
|
63
|
-
area = ?
|
63
|
+
AND area = ?
|
64
64
|
AND NOT (rank IS NULL)
|
65
65
|
ORDER BY rank ASC
|
66
66
|
LIMIT 0, 10");
|