Re: [support] using drupal in mysql without subquery

5 Oct 2006


      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