select row_number from (SELECT id, `login`, @curRow := @curRow + 1 AS row_number FROM `users` JOIN (SELECT @curRow := 0) r WHERE ".$tip.">0 order by ".$tip." desc) as t where t.id='ÜYE NO'

şu şekilde çözdüm