- [Type] 查询语句错误
- [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank,\x0D\x0A @current_sid := p.sid\x0D\x0A FROM (\x0D' at line 8
- [Query] SELECT a.item, a.sid, a.count
FROM (
SELECT
p.item,
p.sid,
p.count,
p.updatedate,
@rank := IF(@current_sid = p.sid, @rank + 1, 1) AS rank,
@current_sid := p.sid
FROM (
SELECT item, sid, COUNT(*) as count, MAX(updatedate) as updatedate FROM ui_riposte
WHERE `type` = 'thread' AND status = 1 and `sid` IN('1335752','2374914','992621','2310335','1635401','2096618','2093827','2080609','2008531','1962962','1962221','1936333','1930267','1886264','1885800','1886375','1887100','1887797','1873040','1873227','1872927','1872892','1872351','1872350','1870156','1872331','1871809','1847404','1858786','1854413','1848497','1735862','1830141','1829354','1406470')
GROUP BY sid, item
) p
JOIN (SELECT @current_sid := NULL, @rank := 0) AS vars
ORDER BY p.sid, p.count DESC, p.updatedate ASC
) a
WHERE a.rank <= 3
|