Re: Record Position in Ordered Selection

[Rick James]

It could be done:

CREATE TEMPORARY TABLE Tmp (
   rank INT UNSIGNED AUTO_INCREMENT NOT NULL,
   listing_id ...
)
   SELECT NULL, listing_id
     FROM Rankings
     ORDER BY ranking
     LIMIT 1000;
SELECT rank FROM Tmp 
   WHERE listing_id = ...;

It won't be fast -- it needs to go through all(?) of Rankings, then all of Tmp.
But doing it in PHP (or whatever) won't be fast either.