반응형
SET @RANK := 0, @PREV := '';
SELECT @PREV := uid AS uid, token, platform
FROM (
SELECT n.uid uid, n.title token
FROM content_type t
LEFT JOIN node n ON t.vid = n.vid
WHERE t.field_id = 'AA'
ORDER BY n.uid, n.vid DESC
) AS tb
WHERE IF( uid = @PREV , @RANK := @RANK +1, @RANK :=1 ) <=1
limit 0, 30
반응형