Question

I currently have a query that selects all the vid_id s where people are viewing a video and sorts them by most viewers. Each time someone views a video, an entry is created in scrusersonline with fields vid_id username timestamp.

我还有一张标的表格和一张标的表。 tag_map contained areas idtag_id and vid_id and tags contained areas tag_id and . 我只想修改下面的询问,以便所有红利结果只用某种标签显示。事先感谢你提供任何专家帮助。



www.un.org/Depts/DGACM/index_spanish.htm 我试图修改的教义。 茨鲁森特有田地为假肢用户名。 它向大多数用户检索并按 des令分类。 我愿进一步将这些结果限定为某种标签。

    SELECT SQL_CALC_FOUND_ROWS scrusersonline.vid_id, COUNT(scrusersonline.id) 
AS idcount FROM scrusersonline 
    GROUP BY scrusersonline.vid_id ORDER BY idcount DESC


www.un.org/Depts/DGACM/index_spanish.htm 下面的询问只是一个例子,它只是选择了带有某种标签的所有红衣,而是与视频表格联系在一起的。 我想能够改变上述问题,以便它只显示标签的结果。

SELECT SQL_CALC_FOUND_ROWS video.* FROM tag_map 
               INNER JOIN tags2 ON tags2.tag_id = tag_map.tag_id
INNER JOIN video ON video.vid_id = tag_map.vid_id
    WHERE name IN (?) 
    ORDER BY video.timestamp DESC LIMIT ?, ?

Answer 1

阁下:

SELECT SQL_CALC_FOUND_ROWS a.vid_id, count(a.id) as idCount
FROM scruseronline as a
INNER JOIN tag_map as b
ON b.vid_id = a.vid_id
INNER JOIN tags2 as c
ON c.tag_id = b.tag_id
AND c.name IN (?)
GROUP BY a.vid_id
ORDER BY idCount DESC

Oh,你不妨从<条码>上删除<条码>id,因为其他领域(<>条/条码>)的组合是独一无二的,因此通常从未提及过代号钥匙。

友情链接