Re: [support] using drupal in mysql without subquery

here I found a solution! SELECT DISTINCT uid, @test:=0, @test := @test+ 1 FROM node WHERE type='blog' GROUP BY uid ORDER BY @test DESC LIMIT 1