SELECT ranked.rank FROM ( SELECT id, ROW_NUMBER() OVER (ORDER BY posted DESC) AS `rank` FROM myvidster_video WHERE channel_id = 175822 AND ( private IN (0,2)) ) ranked WHERE ranked.id = 64146312;