質問編集履歴
2
クエリの修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -33,8 +33,6 @@
|
|
33
33
|
AND a.c_id = Y
|
34
34
|
|
35
35
|
AND a.name LIKE '%??%'
|
36
|
-
|
37
|
-
ORDER BY a.id
|
38
36
|
|
39
37
|
|
40
38
|
|
@@ -82,8 +80,6 @@
|
|
82
80
|
|
83
81
|
INNER JOIN C AS c ON a.c_id = c.id
|
84
82
|
|
85
|
-
ORDER BY a.id
|
86
|
-
|
87
83
|
|
88
84
|
|
89
85
|
[レコード取得]
|
1
クエリの修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -24,9 +24,9 @@
|
|
24
24
|
|
25
25
|
SELECT COUNT(a.id) FROM A AS a
|
26
26
|
|
27
|
-
INNER JOIN b ON a.b_id = b.id
|
27
|
+
INNER JOIN B AS b ON a.b_id = b.id
|
28
28
|
|
29
|
-
INNER JOIN c ON a.c_id = c.id
|
29
|
+
INNER JOIN C AS c ON a.c_id = c.id
|
30
30
|
|
31
31
|
WHERE a.b_id = X
|
32
32
|
|
@@ -42,9 +42,9 @@
|
|
42
42
|
|
43
43
|
SELECT a.*, b.name, c.name FROM A AS a
|
44
44
|
|
45
|
-
INNER JOIN b ON a.b_id = b.id
|
45
|
+
INNER JOIN B AS b ON a.b_id = b.id
|
46
46
|
|
47
|
-
INNER JOIN c ON a.c_id = c.id
|
47
|
+
INNER JOIN C AS c ON a.c_id = c.id
|
48
48
|
|
49
49
|
WHERE a.b_id = X
|
50
50
|
|
@@ -78,9 +78,9 @@
|
|
78
78
|
|
79
79
|
) AS a
|
80
80
|
|
81
|
-
INNER JOIN b ON a.b_id = b.id
|
81
|
+
INNER JOIN B AS b ON a.b_id = b.id
|
82
82
|
|
83
|
-
INNER JOIN c ON a.c_id = c.id
|
83
|
+
INNER JOIN C AS c ON a.c_id = c.id
|
84
84
|
|
85
85
|
ORDER BY a.id
|
86
86
|
|
@@ -102,9 +102,9 @@
|
|
102
102
|
|
103
103
|
) AS a
|
104
104
|
|
105
|
-
INNER JOIN b ON a.b_id = b.id
|
105
|
+
INNER JOIN B AS b ON a.b_id = b.id
|
106
106
|
|
107
|
-
INNER JOIN c ON a.c_id = c.id
|
107
|
+
INNER JOIN C AS c ON a.c_id = c.id
|
108
108
|
|
109
109
|
ORDER BY a.id LIMIT 10
|
110
110
|
|