SELECT ranked.rank
FROM (
SELECT
id,
ROW_NUMBER() OVER (ORDER BY posted DESC) AS `rank`
FROM myvidster_video
WHERE channel_id = 2029558
AND (
private IN (0,2))
) ranked
WHERE ranked.id = 231527383;
Simultaneous Localization Of Robot Within Environment
