mysql, zjisteni poradi radku

select @i:=0;
select * from (
  select @i:=@i+1 as i, t.* from tab as t order by sloupec5, sloupec3 desc
) as temp where a=2 and b=3 and c=3

dik moc, po par upravach to dela presne to co chci

SELECT @i:=0;
SELECT i FROM (
SELECT @i:=@i+1 AS i, id FROM (
  SELECT t.* FROM tab AS t WHERE a=2 AND b=3 AND c=3 ORDER BY sloupec5 DESC, sloupec3 DESC
)AS temp1
)AS temp5 WHERE id=X

V takomto prípade by mohlo stačiť toto (bez toho jedného vnoreného selectu):

SELECT @i:=0;
SELECT i FROM (
SELECT @i:=@i+1 AS i, id FROM tab WHERE a=2 AND b=3 AND c=3 ORDER BY sloupec5 DESC, sloupec3 DESC
) AS temp WHERE id=X