- [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('2602144','1663824','2601803','2598189','2559306','2586047','2585638','2581257','2578891','2577607','2577603','2569429','2565648','2564499','2560983','2560777','2559106','2556722','2556188','2549051','2544715','2539915','2540476','2539901','2539824','2539372','2538690','2515635','2503258','2503109','2501551','2501660','2501272','2500076','2463041')
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
|