SELECT * FROM video AS v, favourite as f WHERE f.UID=1357 AND f.VID=v.VID ORDER BY v.addtime DESC LIMIT 0, 10