回答編集履歴
1
追記
answer
CHANGED
|
@@ -5,4 +5,19 @@
|
|
|
5
5
|
GROUP BY comments.ID
|
|
6
6
|
HAVING genre_names='指導'
|
|
7
7
|
LIMIT 0, 5
|
|
8
|
+
```
|
|
9
|
+
|
|
10
|
+
### 追記
|
|
11
|
+
genre_namesかどうか不定ならexists内のtag_nameで対処
|
|
12
|
+
２回連結するっていうのはその通り。
|
|
13
|
+
```SQL
|
|
14
|
+
where exists(
|
|
15
|
+
select 0
|
|
16
|
+
from my_tag_holders h
|
|
17
|
+
inner join my_tags t on t.ID=h.tags_ID
|
|
18
|
+
where h.comments_ID=comments.ID
|
|
19
|
+
and t.tag_name='指導'
|
|
20
|
+
)
|
|
21
|
+
GROUP BY comments.ID
|
|
22
|
+
LIMIT 0, 5
|
|
8
23
|
```
|