[support] using drupal in mysql without subquery

[Drupal Indonesia]

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