回答編集履歴
2
修正
answer
CHANGED
|
@@ -3,7 +3,7 @@
|
|
|
3
3
|
```ここに言語を入力
|
|
4
4
|
SELECT f.* FROM facilities_trait as f
|
|
5
5
|
INNER JOIN facilities_trait as f2
|
|
6
|
-
ON f2.
|
|
6
|
+
ON f2.rooms_id = f.rooms_id
|
|
7
7
|
AND f2.facilities_id = 31
|
|
8
8
|
INNER JOIN articles AS a
|
|
9
9
|
ON a.id = f.rooms_id
|
1
修正
answer
CHANGED
|
@@ -12,4 +12,5 @@
|
|
|
12
12
|
ON r.id = f.rooms_id
|
|
13
13
|
AND r.flag = 2
|
|
14
14
|
AND r.status = 2
|
|
15
|
+
WHERE f.flag = 2 AND (f.type = 1 OR f.type = 3)
|
|
15
16
|
```
|