回答編集履歴
2
修正
test
CHANGED
|
@@ -8,7 +8,7 @@
|
|
|
8
8
|
|
|
9
9
|
INNER JOIN facilities_trait as f2
|
|
10
10
|
|
|
11
|
-
ON f2.id = f.id
|
|
11
|
+
ON f2.rooms_id = f.rooms_id
|
|
12
12
|
|
|
13
13
|
AND f2.facilities_id = 31
|
|
14
14
|
|
1
修正
test
CHANGED
|
@@ -26,4 +26,6 @@
|
|
|
26
26
|
|
|
27
27
|
AND r.status = 2
|
|
28
28
|
|
|
29
|
+
WHERE f.flag = 2 AND (f.type = 1 OR f.type = 3)
|
|
30
|
+
|
|
29
31
|
```
|