Original query from user:
SELECT * FROM ( SELECT @rn := if( @lc = l.l_contentid, @rn +1, 0 ) AS rnum, @lc := l_contentid, l.* FROM vb3_vbseo_likes l, (SELECT @rn :=0, @lc :=0) r WHERE l_ctype = 1 AND l_cgroup =39820 AND l_contentid IN (289195,289196 ) ORDER BY l_contentid;
Original query from user:
SELECT * FROM (
SELECT @rn := if( @lc = l.l_contentid, @rn +1, 0 ) AS rnum, @lc := l_contentid, l.*
FROM vb3_vbseo_likes l, (SELECT @rn :=0, @lc :=0) r
WHERE l_ctype = 1 AND l_cgroup =39820 AND l_contentid IN (289195,289196 )
ORDER BY l_contentid;