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